source/text/scalc/01/04060103.xhp | 43 ++++++++++-----------
source/text/scalc/01/04060119.xhp | 76 +++++++++++++++++++-------------------
2 files changed, 59 insertions(+), 60 deletions(-)
New commits:
commit 07a573b651b1378ba70f8a06b2bbfdc163a96da5
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed Nov 27 15:24:34 2019 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Nov 27 20:07:01 2019 +0100
tdf#129057 Correct DURATION and PDURATION Help
+ some refactor on the 2 pages
Change-Id: I997a3ed484c6cccf71d9726444ca75ded7d48d32
Reviewed-on: https://gerrit.libreoffice.org/83944
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060103.xhp
b/source/text/scalc/01/04060103.xhp
index b22e8dd06..94ad211cb 100644
--- a/source/text/scalc/01/04060103.xhp
+++ b/source/text/scalc/01/04060103.xhp
@@ -32,7 +32,7 @@
<bookmark_value>Function Wizard; financial</bookmark_value>
<bookmark_value>amortizations, see also depreciations</bookmark_value>
</bookmark><comment>mw added one entry</comment>
-<paragraph xml-lang="en-US" id="hd_id3143284" role="heading"
level="1">Financial Functions Part One</paragraph>
+<h1 id="hd_id3143284">Financial Functions Part One</h1>
<paragraph xml-lang="en-US" id="par_id3149095"
role="paragraph"><variable id="finanztext">This category contains the
mathematical finance functions of <item type="productname">%PRODUCTNAME</item>
Calc.
</variable></paragraph>
<sort order="asc">
@@ -41,7 +41,7 @@
<bookmark_value>depreciations;degressive
amortizations</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_AMORDEGRC"
id="bm_id3152578" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153366" role="heading"
level="2">AMORDEGRC</paragraph>
+<h2 id="hd_id3153366">AMORDEGRC</h2>
<paragraph xml-lang="en-US" id="par_id3147434"
role="paragraph"><ahelp hid="HID_AAI_FUNC_AMORDEGRC">Calculates the amount of
depreciation for a settlement period as degressive amortization.</ahelp> Unlike
AMORLINC, a depreciation coefficient that is independent of the depreciable
life is used here.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3147427"
role="code">AMORDEGRC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate;
Basis)</paragraph>
@@ -64,7 +64,7 @@
<bookmark_value>depreciations;linear amortizations</bookmark_value>
</bookmark><comment>mw added "depreciations;..."</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_AMORLINC"
id="bm_id3153711" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153765" role="heading"
level="2">AMORLINC</paragraph>
+<h2 id="hd_id3153765">AMORLINC</h2>
<paragraph xml-lang="en-US" id="par_id3159264"
role="paragraph"><ahelp hid="HID_AAI_FUNC_AMORLINC">Calculates the amount of
depreciation for a settlement period as linear amortization. If the capital
asset is purchased during the settlement period, the proportional amount of
depreciation is considered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3147363"
role="code">AMORLINC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate;
Basis)</paragraph>
@@ -86,7 +86,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3145257"><bookmark_value>ACCRINT function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ACCRINT"
id="bm_id3149815" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3145257" role="heading"
level="2">ACCRINT</paragraph>
+<h2 id="hd_id3145257">ACCRINT</h2>
<bookmark xml-lang="en-US" branch="index"
id="bm_id3151276"><bookmark_value>accrued interests;periodic
payments</bookmark_value>
</bookmark><comment>mw changed "accrued interests"</comment>
<paragraph xml-lang="en-US" id="par_id3151276" role="paragraph"><ahelp
hid="HID_AAI_FUNC_ACCRINT">Calculates the accrued interest of a security in the
case of periodic payments.</ahelp></paragraph>
@@ -115,7 +115,7 @@
<bookmark_value>accrued interests;one-off payments</bookmark_value>
</bookmark><comment>mw added one index entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ACCRINTM"
id="bm_id3148866" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3151240" role="heading"
level="2">ACCRINTM</paragraph>
+<h2 id="hd_id3151240">ACCRINTM</h2>
<paragraph xml-lang="en-US" id="par_id3157981"
role="paragraph"><ahelp hid="HID_AAI_FUNC_ACCRINTM">Calculates the accrued
interest of a security in the case of one-off payment at the settlement
date.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3147074"
role="code">ACCRINTM(Issue; Settlement; Rate; Par; Basis)</paragraph>
@@ -138,7 +138,7 @@
<bookmark_value>amount received for fixed-interest
securities</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_RECEIVED"
id="bm_id3143218" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3145753" role="heading"
level="2">RECEIVED</paragraph>
+<h2 id="hd_id3145753">RECEIVED</h2>
<paragraph xml-lang="en-US" id="par_id3150051"
role="paragraph"><ahelp hid="HID_AAI_FUNC_RECEIVED">Calculates the amount
received that is paid for a fixed-interest security at a given point in
time.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3145362"
role="code">RECEIVED("Settlement"; "Maturity"; Investment; Discount;
Basis)</paragraph>
@@ -163,7 +163,7 @@
<bookmark_value>calculating; present values</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BW" id="bm_id3153072"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147556" role="heading"
level="2">PV</paragraph>
+<h2 id="hd_id3147556">PV</h2>
<paragraph xml-lang="en-US" id="par_id3153301"
role="paragraph"><ahelp hid="HID_FUNC_BW">Returns the present value of an
investment resulting from a series of regular payments.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id3146099" role="paragraph">Use
this function to calculate the amount of money needed to be invested at a fixed
rate today, to receive a specific amount, an annuity, over a specified number
of periods. You can also determine how much money is to remain after the elapse
of the period. Specify as well if the amount is to be paid out at the beginning
or at the end of each period.</paragraph>
<paragraph xml-lang="en-US" id="par_id3153334" role="paragraph">Enter
these values either as numbers, expressions or references. If, for example,
interest is paid annually at 8%, but you want to use month as your period,
enter 8%/12 under <emph>Rate</emph> and <item
type="productname">%PRODUCTNAME</item> Calc with automatically calculate the
correct factor.</paragraph>
@@ -195,7 +195,7 @@
<bookmark_value>arithmetic declining depreciations</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DIA" id="bm_id3157905"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3152978" role="heading"
level="2">SYD</paragraph>
+<h2 id="hd_id3152978">SYD</h2>
<paragraph xml-lang="en-US" id="par_id3148732"
role="paragraph"><ahelp hid="HID_FUNC_DIA">Returns the arithmetic-declining
depreciation rate.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id3149886" role="paragraph">Use
this function to calculate the depreciation amount for one period of the total
depreciation span of an object. Arithmetic declining depreciation reduces the
depreciation amount from period to period by a fixed sum.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -538,7 +538,7 @@
<bookmark_value>discounts</bookmark_value>
</bookmark><comment>mw added "discounts" and "allowances"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_DISC" id="bm_id3149290"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3155104" role="heading"
level="2">DISC</paragraph>
+<h2 id="hd_id3155104">DISC</h2>
<paragraph xml-lang="en-US" id="par_id3153891"
role="paragraph"><ahelp hid="HID_AAI_FUNC_DISC">Calculates the allowance
(discount) of a security as a percentage.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149756"
role="code">DISC("Settlement"; "Maturity"; Price; Redemption; Basis)</paragraph>
@@ -556,17 +556,16 @@
<paragraph xml-lang="en-US" id="par_id3152797" role="paragraph">
<item
type="input">=DISC("2001-01-25";"2001-11-15";97;100;3)</item> returns about
0.0372 or 3.72 per cent.</paragraph>
</section>
- <section id="duration_add">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3154695"><bookmark_value>DURATION_ADD function</bookmark_value>
- <bookmark_value>Microsoft Excel functions</bookmark_value>
+ <section id="duration">
+<bookmark xml-lang="en-US" branch="index"
id="bm_id3154695"><bookmark_value>DURATION function</bookmark_value>
<bookmark_value>durations;fixed interest securities</bookmark_value>
</bookmark><comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_DURATION"
id="bm_id3159344" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3154695" role="heading"
level="2">DURATION_ADD</paragraph>
+<h2 id="hd_id3154695">DURATION</h2>
<paragraph xml-lang="en-US" id="par_id3145768"
role="paragraph"><ahelp hid="HID_AAI_FUNC_DURATION">Calculates the duration of
a fixed interest security in years.</ahelp></paragraph>
<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3153373"
role="code">DURATION_ADD("Settlement"; "Maturity"; Coupon; Yield; Frequency;
Basis)</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3153373"
role="code">DURATION("Settlement"; "Maturity"; Coupon; Yield; Frequency;
Basis)</paragraph>
<paragraph xml-lang="en-US" id="par_id3155397" role="paragraph">
<emph>Settlement</emph> is the date of purchase of the
security.</paragraph>
<paragraph xml-lang="en-US" id="par_id3148558" role="paragraph">
@@ -581,7 +580,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3148834" role="paragraph">A
security is purchased on 2001-01-01; the maturity date is 2006-01-01. The
Coupon rate of interest is 8%. The yield is 9.0%. Interest is paid half-yearly
(frequency is 2). Using daily balance interest calculation (basis 3) how long
is the duration?</paragraph>
<paragraph xml-lang="en-US" id="par_id3154902" role="paragraph">
- <item
type="input">=DURATION_ADD("2001-01-01";"2006-01-01";0.08;0.09;2;3)</item>
+ <item
type="input">=DURATION("2001-01-01";"2006-01-01";0.08;0.09;2;3)</item>
</paragraph>
</section>
<section id="effective">
@@ -591,7 +590,7 @@
<bookmark_value>EFFECT function</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EFFEKTIV" id="bm_id3154290"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3159147" role="heading"
level="2">EFFECT</paragraph>
+<h2 id="hd_id3159147">EFFECT</h2>
<paragraph xml-lang="en-US" id="par_id3154204"
role="paragraph"><ahelp hid="HID_FUNC_EFFEKTIV">Returns the net annual interest
rate for a nominal interest rate.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id3145417"
role="paragraph">Nominal interest refers to the amount of interest due at the
end of a calculation period. Effective interest increases with the number of
payments made. In other words, interest is often paid in installments (for
example, monthly or quarterly) before the end of the calculation
period.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -610,7 +609,7 @@
<bookmark_value>EFFECT_ADD function</bookmark_value>
</bookmark><comment>mw changed "effective rates"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_EFFECT"
id="bm_id3147515" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147241" role="heading"
level="2">EFFECT_ADD</paragraph>
+<h2 id="hd_id3147241">EFFECT_ADD</h2>
<paragraph xml-lang="en-US" id="par_id3147524"
role="paragraph"><ahelp hid="HID_AAI_FUNC_EFFECT">Calculates the effective
annual rate of interest on the basis of the nominal interest rate and the
number of interest payments per annum.</ahelp></paragraph>
<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -631,7 +630,7 @@
<bookmark_value>DDB function</bookmark_value>
</bookmark><comment>mw corrected two typos and added
"depreciations;..."</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GDA" id="bm_id3149176"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149998" role="heading"
level="2">DDB</paragraph>
+<h2 id="hd_id3149998">DDB</h2>
<paragraph xml-lang="en-US" id="par_id3159190"
role="paragraph"><ahelp hid="HID_FUNC_GDA">Returns the depreciation of an asset
for a specified period using the arithmetic-declining
method.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id3152361" role="paragraph">Use
this form of depreciation if you require a higher initial depreciation value as
opposed to linear depreciation. The depreciation value gets less with each
period and is usually used for assets whose value loss is higher shortly after
purchase (for example, vehicles, computers). Please note that the book value
will never reach zero under this calculation type.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -658,7 +657,7 @@
<bookmark_value>DB function</bookmark_value>
</bookmark><comment>mw added "depreciations;.."</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GDA2" id="bm_id3149973"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149962" role="heading"
level="2">DB</paragraph>
+<h2 id="hd_id3149962">DB</h2>
<paragraph xml-lang="en-US" id="par_id3148989"
role="paragraph"><ahelp hid="HID_FUNC_GDA2">Returns the depreciation of an
asset for a specified period using the fixed-declining balance
method.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id3156213" role="paragraph">This
form of depreciation is used if you want to get a higher depreciation value at
the beginning of the depreciation (as opposed to linear depreciation). The
depreciation value is reduced with every depreciation period by the
depreciation already deducted from the initial cost.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -685,7 +684,7 @@
<bookmark_value>internal rates of return;regular
payments</bookmark_value>
</bookmark><comment>mw changed "calculating;..." and "internal rates"</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_IKV" id="bm_id3148419"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153948" role="heading"
level="2">IRR</paragraph>
+<h2 id="hd_id3153948">IRR</h2>
<paragraph xml-lang="en-US" id="par_id3143282"
role="paragraph"><ahelp hid="HID_FUNC_IKV">Calculates the internal rate of
return for an investment.</ahelp> The values represent cash flow values at
regular intervals, at least one value must be negative (payments), and at least
one value must be positive (income).</paragraph>
<paragraph id="par_idN10E621" role="paragraph" xml-lang="en-US">If
the payments take place at irregular intervals, use the <link
href="text/scalc/01/04060118.xhp#xirr" name="XIRR">XIRR</link>
function.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -696,7 +695,7 @@
<emph>Guess</emph> (optional) is the estimated value. An iterative
method is used to calculate the internal rate of return. If you can provide
only few values, you should provide an initial guess to enable the
iteration.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3150630" role="paragraph">Under
the assumption that cell contents are A1=<item type="input">-10000</item>,
A2=<item type="input">3500</item>, A3=<item type="input">7600</item> and
A4=<item type="input">1000</item>, the formula <item
type="input">=IRR(A1:A4)</item> gives a result of 11,33%.</paragraph>
- <paragraph xml-lang="en-US" id="par_id461513468030965"
role="warning">Because of the iterative method used, it is possible for IRR to
fail and return <link href="text/scalc/05/02140000.xhp" name="Error 523">Error
523</link>, with "Error: Calculation does not converge" in the status bar. In
that case, try another value for Guess.</paragraph>
+ <warning id="par_id461513468030965">Because of the iterative method
used, it is possible for IRR to fail and return <link
href="text/scalc/05/02140000.xhp" name="Error 523">Error 523</link>, with
"Error: Calculation does not converge" in the status bar. In that case, try
another value for Guess.</warning>
</section>
<section id="ispmt">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3151012"><bookmark_value>calculating; interests for unchanged
amortization installments</bookmark_value>
@@ -704,7 +703,7 @@
<bookmark_value>ISPMT function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISPMT" id="bm_id3149491"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3151012" role="heading"
level="2">ISPMT</paragraph>
+<h2 id="hd_id3151012">ISPMT</h2>
<paragraph xml-lang="en-US" id="par_id3148693"
role="paragraph"><ahelp hid="HID_FUNC_ISPMT">Calculates the level of interest
for unchanged amortization installments.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3146070"
role="code">ISPMT(Rate; Period; TotalPeriods; Invest)</paragraph>
diff --git a/source/text/scalc/01/04060119.xhp
b/source/text/scalc/01/04060119.xhp
index fb8ad96dd..ea6686d20 100644
--- a/source/text/scalc/01/04060119.xhp
+++ b/source/text/scalc/01/04060119.xhp
@@ -27,7 +27,7 @@
</topic>
</meta>
<body>
-<paragraph role="heading" id="hd_id3149052" xml-lang="en-US"
level="1">Financial Functions Part Two</paragraph>
+<h1 id="hd_id3149052">Financial Functions Part Two</h1>
<section id="howtoget">
<embed href="text/scalc/00/00000404.xhp#eikafi"/>
</section>
@@ -38,7 +38,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3150026"><bookmark_value>PPMT function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KAPZ" id="bm_id3145827"
localize="false"/>
-<paragraph role="heading" id="hd_id3150026" xml-lang="en-US"
level="2">PPMT</paragraph>
+<h2 id="hd_id3150026">PPMT</h2>
<paragraph role="paragraph" id="par_id3146942" xml-lang="en-US"><ahelp
hid="HID_FUNC_KAPZ">Returns for a given period the payment on the principal for
an investment that is based on periodic and constant payments and a constant
interest rate.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3146878" xml-lang="en-US">PPMT(Rate; Period;
NPer; PV; FV; Type)</paragraph>
@@ -70,7 +70,7 @@
<bookmark_value>CUMPRINC function</bookmark_value>
</bookmark><comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KUMKAPITAL"
id="bm_id3148754" localize="false"/>
-<paragraph role="heading" id="hd_id3146139" xml-lang="en-US"
level="2">CUMPRINC</paragraph>
+<h2 id="hd_id3146139">CUMPRINC</h2>
<paragraph role="paragraph" id="par_id3150140" xml-lang="en-US"><ahelp
hid="HID_FUNC_KUMKAPITAL">Returns the cumulative interest paid for an
investment period with a constant interest rate.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3148733" xml-lang="en-US">CUMPRINC(Rate;
NPer; PV; S; E; Type)</paragraph>
@@ -95,7 +95,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3150019"><bookmark_value>CUMPRINC_ADD function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_CUMPRINC"
id="bm_id3154330" localize="false"/>
-<paragraph role="heading" id="hd_id3150019" xml-lang="en-US"
level="2">CUMPRINC_ADD</paragraph>
+<h2 id="hd_id3150019">CUMPRINC_ADD</h2>
<paragraph role="paragraph" id="par_id3145246" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_CUMPRINC"> Calculates the cumulative redemption of a loan in
a period.</ahelp></paragraph>
<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -128,7 +128,7 @@
<bookmark_value>CUMIPMT function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KUMZINSZ" id="bm_id3148593"
localize="false"/>
-<paragraph role="heading" id="hd_id3155370" xml-lang="en-US"
level="2">CUMIPMT</paragraph>
+<h2 id="hd_id3155370">CUMIPMT</h2>
<paragraph role="paragraph" id="par_id3158411" xml-lang="en-US"><ahelp
hid="HID_FUNC_KUMZINSZ">Calculates the cumulative interest payments, that is,
the total interest, for an investment based on a constant interest
rate.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3147536" xml-lang="en-US">CUMIPMT(Rate; NPer;
PV; S; E; Type)</paragraph>
@@ -153,7 +153,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3083280"><bookmark_value>CUMIPMT_ADD function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_CUMIPMT"
id="bm_id3154312" localize="false"/>
-<paragraph role="heading" id="hd_id3083280" xml-lang="en-US"
level="2">CUMIPMT_ADD</paragraph>
+<h2 id="hd_id3083280">CUMIPMT_ADD</h2>
<paragraph role="paragraph" id="par_id3152482" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_CUMIPMT">Calculates the accumulated interest for a
period.</ahelp></paragraph>
<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -186,7 +186,7 @@
<bookmark_value>sales values;fixed interest securities</bookmark_value>
</bookmark><comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_PRICE"
id="bm_id3153279" localize="false"/>
-<paragraph role="heading" id="hd_id3150878" xml-lang="en-US"
level="2">PRICE</paragraph>
+<h2 id="hd_id3150878">PRICE</h2>
<paragraph role="paragraph" id="par_id3153210" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_PRICE">Calculates the market value of a fixed interest
security with a par value of 100 currency units as a function of the forecast
yield.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3152804" xml-lang="en-US">PRICE(Settlement;
Maturity; Rate; Yield; Redemption; Frequency; Basis)</paragraph>
@@ -205,7 +205,7 @@
<embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3150260" xml-lang="en-US">A security is
purchased on 1999-02-15; the maturity date is 2007-11-15. The nominal rate of
interest is 5.75%. The yield is 6.5%. The redemption value is 100 currency
units. Interest is paid half-yearly (frequency is 2). With calculation on basis
0, the price is as follows:</paragraph>
-<paragraph role="paragraph" id="par_id3147273"
xml-lang="en-US">=PRICE("1999-02-15"; "2007-11-15"; 0.0575; 0.065; 100; 2; 0)
returns 95.04287.</paragraph>
+<paragraph role="paragraph" id="par_id3147273"
xml-lang="en-US"><input>=PRICE("1999-02-15"; "2007-11-15"; 0.0575; 0.065; 100;
2; 0)</input> returns 95.04287.</paragraph>
</section>
<section id="pricedisc">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3151297"><bookmark_value>PRICEDISC function</bookmark_value>
@@ -213,7 +213,7 @@
<bookmark_value>sales values;non-interest-bearing securities</bookmark_value>
</bookmark><comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_PRICEDISC"
id="bm_id3143236" localize="false"/>
-<paragraph role="heading" id="hd_id3151297" xml-lang="en-US"
level="2">PRICEDISC</paragraph>
+<h2 id="hd_id3151297">PRICEDISC</h2>
<paragraph role="paragraph" id="par_id3155100" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_PRICEDISC">Calculates the price per 100 currency units of par
value of a non-interest- bearing security.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3146084"
xml-lang="en-US">PRICEDISC(Settlement; Maturity; Discount; Redemption;
Basis)</paragraph>
@@ -228,14 +228,14 @@
<embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3149198" xml-lang="en-US">A security is
purchased on 1999-02-15; the maturity date is 1999-03-01. Discount in per cent
is 5.25%. The redemption value is 100. When calculating on basis 2 the price
discount is as follows:</paragraph>
-<paragraph role="paragraph" id="par_id3151178"
xml-lang="en-US">=PRICEDISC("1999-02-15"; "1999-03-01"; 0.0525; 100; 2) returns
99.79583.</paragraph>
+<paragraph role="paragraph" id="par_id3151178"
xml-lang="en-US"><input>=PRICEDISC("1999-02-15"; "1999-03-01"; 0.0525; 100;
2)</input> returns 99.79583.</paragraph>
</section>
<section id="pricemat">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3154693"><bookmark_value>PRICEMAT function</bookmark_value>
<bookmark_value>prices;interest-bearing securities</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_PRICEMAT"
id="bm_id3150118" localize="false"/>
-<paragraph role="heading" id="hd_id3154693" xml-lang="en-US"
level="2">PRICEMAT</paragraph>
+<h2 id="hd_id3154693">PRICEMAT</h2>
<paragraph role="paragraph" id="par_id3153906" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_PRICEMAT">Calculates the price per 100 currency units of par
value of a security, that pays interest on the maturity
date.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3155393"
xml-lang="en-US">PRICEMAT(Settlement; Maturity; Issue; Rate; Yield;
Basis)</paragraph>
@@ -253,18 +253,18 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3154289" xml-lang="en-US">Settlement
date: February 15 1999, maturity date: April 13 1999, issue date: November 11
1998. Interest rate: 6.1 per cent, yield: 6.1 per cent, basis: 30/360 =
0.</paragraph>
<paragraph role="paragraph" id="par_id3154905" xml-lang="en-US">The price is
calculated as follows:</paragraph>
-<paragraph role="paragraph" id="par_id3158409"
xml-lang="en-US">=PRICEMAT("1999-02-15";"1999-04-13";"1998-11-11"; 0.061;
0.061;0) returns 99.98449888.</paragraph>
+<paragraph role="paragraph" id="par_id3158409"
xml-lang="en-US"><input>=PRICEMAT("1999-02-15";"1999-04-13";"1998-11-11";
0.061; 0.061;0)</input> returns 99.98449888.</paragraph>
</section>
-<section id="duration">
+<section id="pduration">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3148448"><bookmark_value>calculating; durations</bookmark_value>
<bookmark_value>durations;calculating</bookmark_value>
-<bookmark_value>DURATION function</bookmark_value>
+<bookmark_value>PDURATION function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LAUFZEIT" id="bm_id3154208"
localize="false"/>
-<paragraph role="heading" id="hd_id3148448" xml-lang="en-US"
level="2">DURATION</paragraph>
+<h2 id="hd_id3148448">PDURATION</h2>
<paragraph role="paragraph" id="par_id3153056" xml-lang="en-US"><ahelp
hid="HID_FUNC_LAUFZEIT">Calculates the number of periods required by an
investment to attain the desired value.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph role="code" id="par_id3148933" xml-lang="en-US">DURATION(Rate; PV;
FV)</paragraph>
+<paragraph role="code" id="par_id3148933" xml-lang="en-US">PDURATION(Rate; PV;
FV)</paragraph>
<paragraph role="paragraph" id="par_id3148801" xml-lang="en-US">
<emph>Rate</emph> is a constant. The interest rate is to be calculated for the
entire duration (duration period). The interest rate per period is calculated
by dividing the interest rate by the calculated duration. The internal rate for
an annuity is to be entered as Rate/12.</paragraph>
<paragraph role="paragraph" id="par_id3147239" xml-lang="en-US">
@@ -282,7 +282,7 @@
<bookmark_value>SLN function</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LIA" id="bm_id3154275"
localize="false"/>
-<paragraph role="heading" id="hd_id3148912" xml-lang="en-US"
level="2">SLN</paragraph>
+<h2 id="hd_id3148912">SLN</h2>
<paragraph role="paragraph" id="par_id3149154" xml-lang="en-US"><ahelp
hid="HID_FUNC_LIA">Returns the straight-line depreciation of an asset for one
period.</ahelp> The amount of the depreciation is constant during the
depreciation period.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3166456" xml-lang="en-US">SLN(Cost; Salvage;
Life)</paragraph>
@@ -302,7 +302,7 @@
<bookmark_value>Macauley duration</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_MDURATION"
id="bm_id3153750" localize="false"/>
-<paragraph role="heading" id="hd_id3153739" xml-lang="en-US"
level="2">MDURATION</paragraph>
+<h2 id="hd_id3153739">MDURATION</h2>
<paragraph role="paragraph" id="par_id3149923" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_MDURATION">Calculates the modified Macauley duration of a
fixed interest security in years.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3148987"
xml-lang="en-US">MDURATION(Settlement; Maturity; Coupon; Yield; Frequency;
Basis)</paragraph>
@@ -319,7 +319,7 @@
<embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3148652" xml-lang="en-US">A security is
purchased on 2001-01-01; the maturity date is 2006-01-01. The nominal rate of
interest is 8%. The yield is 9.0%. Interest is paid half-yearly (frequency is
2). Using daily balance interest calculation (basis 3) how long is the modified
duration?</paragraph>
-<paragraph role="paragraph" id="par_id3145378"
xml-lang="en-US">=MDURATION("2001-01-01"; "2006-01-01"; 0.08; 0.09; 2; 3)
returns 4.02 years.</paragraph>
+<paragraph role="paragraph" id="par_id3145378"
xml-lang="en-US"><input>=MDURATION("2001-01-01"; "2006-01-01"; 0.08; 0.09; 2;
3)</input> returns 4.02 years.</paragraph>
</section>
<section id="npv">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3149242"><bookmark_value>calculating;net present
values</bookmark_value>
@@ -327,7 +327,7 @@
<bookmark_value>NPV function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NBW" id="bm_id3148417"
localize="false"/>
-<paragraph role="heading" id="hd_id3149242" xml-lang="en-US"
level="2">NPV</paragraph>
+<h2 id="hd_id3149242">NPV</h2>
<paragraph role="paragraph" id="par_id3145308" xml-lang="en-US"><ahelp
hid="HID_FUNC_NBW">Returns the present value of an investment based on a series
of periodic cash flows and a discount rate. To get the net present value,
subtract the cost of the project (the initial cash flow at time zero) from the
returned value.</ahelp></paragraph>
<paragraph id="par_idN111381" role="paragraph" xml-lang="en-US">If the
payments take place at irregular intervals, use the <link
href="text/scalc/01/04060118.xhp#xnpv" name="XNPV">XNPV</link>
function.</paragraph>
@@ -348,7 +348,7 @@
<bookmark_value>NOMINAL function</bookmark_value>
</bookmark><comment>mw made "nominal interest rates;..." a one level
entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NOMINAL" id="bm_id3145600"
localize="false"/>
-<paragraph role="heading" id="hd_id3149484" xml-lang="en-US"
level="2">NOMINAL</paragraph>
+<h2 id="hd_id3149484">NOMINAL</h2>
<paragraph role="paragraph" id="par_id3149596" xml-lang="en-US"><ahelp
hid="HID_FUNC_NOMINAL">Calculates the yearly nominal interest rate, given the
effective rate and the number of compounding periods per
year.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3152769"
xml-lang="en-US">NOMINAL(EffectiveRate; NPerY)</paragraph>
@@ -365,7 +365,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3155123"><bookmark_value>NOMINAL_ADD function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_NOMINAL"
id="bm_id3158439" localize="false"/>
-<paragraph role="heading" id="hd_id3155123" xml-lang="en-US"
level="2">NOMINAL_ADD</paragraph>
+<h2 id="hd_id3155123">NOMINAL_ADD</h2>
<paragraph role="paragraph" id="par_id3148671" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_NOMINAL">Calculates the annual nominal rate of interest on
the basis of the effective rate and the number of interest payments per
annum.</ahelp></paragraph>
<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -384,7 +384,7 @@
<bookmark_value>converting;decimal fractions, into mixed decimal
fractions</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_DOLLARFR"
id="bm_id3146907" localize="false"/>
-<paragraph role="heading" id="hd_id3159087" xml-lang="en-US"
level="2">DOLLARFR</paragraph>
+<h2 id="hd_id3159087">DOLLARFR</h2>
<paragraph role="paragraph" id="par_id3150593" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_DOLLARFR">Converts a quotation that has been given as a
decimal number into a mixed decimal fraction.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3152959"
xml-lang="en-US">DOLLARFR(DecimalDollar; Fraction)</paragraph>
@@ -404,7 +404,7 @@
<bookmark_value>DOLLARDE function</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_DOLLARDE"
id="bm_id3154569" localize="false"/>
-<paragraph role="heading" id="hd_id3154671" xml-lang="en-US"
level="2">DOLLARDE</paragraph>
+<h2 id="hd_id3154671">DOLLARDE</h2>
<paragraph role="paragraph" id="par_id3154418" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_DOLLARDE">Converts a quotation that has been given as a
decimal fraction into a decimal number.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3150348"
xml-lang="en-US">DOLLARDE(FractionalDollar; Fraction)</paragraph>
@@ -425,7 +425,7 @@
<bookmark_value>internal rates of return;modified</bookmark_value>
</bookmark><comment>mw added "internal rates of return;..."</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QIKV" id="bm_id3150670"
localize="false"/>
-<paragraph role="heading" id="hd_id3148974" xml-lang="en-US"
level="2">MIRR</paragraph>
+<h2 id="hd_id3148974">MIRR</h2>
<paragraph role="paragraph" id="par_id3155497" xml-lang="en-US"><ahelp
hid="HID_FUNC_QIKV">Calculates the modified internal rate of return of a series
of investments.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3148399" xml-lang="en-US">MIRR(Values;
Investment; ReinvestRate)</paragraph>
@@ -444,7 +444,7 @@
<bookmark_value>yields, see also rates of return</bookmark_value>
</bookmark><comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_YIELD"
id="bm_id3152460" localize="false"/>
-<paragraph role="heading" id="hd_id3149323" xml-lang="en-US"
level="2">YIELD</paragraph>
+<h2 id="hd_id3149323">YIELD</h2>
<paragraph role="paragraph" id="par_id3150643" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_YIELD">Calculates the yield of a security.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3149744" xml-lang="en-US">YIELD(Settlement;
Maturity; Rate; Price; Redemption; Frequency; Basis)</paragraph>
@@ -463,14 +463,14 @@
<embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3151214" xml-lang="en-US">A security is
purchased on 1999-02-15. It matures on 2007-11-15. The rate of interest is
5.75%. The price is 95.04287 currency units per 100 units of par value, the
redemption value is 100 units. Interest is paid half-yearly (frequency = 2) and
the basis is 0. How high is the yield?</paragraph>
-<paragraph role="paragraph" id="par_id3154194"
xml-lang="en-US">=YIELD("1999-02-15"; "2007-11-15"; 0.0575 ;95.04287; 100; 2;
0) returns 0.065 or 6.50 per cent.</paragraph>
+<paragraph role="paragraph" id="par_id3154194"
xml-lang="en-US"><input>=YIELD("1999-02-15"; "2007-11-15"; 0.0575 ;95.04287;
100; 2; 0)</input> returns 0.065 or 6.50 per cent.</paragraph>
</section>
<section id="yielddisc">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3150100"><bookmark_value>YIELDDISC function</bookmark_value>
<bookmark_value>rates of return;non-interest-bearing
securities</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_YIELDDISC"
id="bm_id3156206" localize="false"/>
-<paragraph role="heading" id="hd_id3150100" xml-lang="en-US"
level="2">YIELDDISC</paragraph>
+<h2 id="hd_id3150100">YIELDDISC</h2>
<paragraph role="paragraph" id="par_id3150486" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_YIELDDISC">Calculates the annual yield of a
non-interest-bearing security.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3159191"
xml-lang="en-US">YIELDDISC(Settlement; Maturity; Price; Redemption;
Basis)</paragraph>
@@ -485,14 +485,14 @@
<embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3163815" xml-lang="en-US">A
non-interest-bearing security is purchased on 1999-02-15. It matures on
1999-03-01. The price is 99.795 currency units per 100 units of par value, the
redemption value is 100 units. The basis is 2. How high is the
yield?</paragraph>
-<paragraph role="paragraph" id="par_id3155187"
xml-lang="en-US">=YIELDDISC("1999-02-15"; "1999-03-01"; 99.795; 100; 2) returns
0.052823 or 5.2823 per cent.</paragraph>
+<paragraph role="paragraph" id="par_id3155187"
xml-lang="en-US"><input>=YIELDDISC("1999-02-15"; "1999-03-01"; 99.795; 100;
2)</input> returns 0.052823 or 5.2823 per cent.</paragraph>
</section>
<section id="yieldmat">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3155140"><bookmark_value>YIELDMAT function</bookmark_value>
<bookmark_value>rates of return;securities with interest paid on
maturity</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_YIELDMAT"
id="bm_id3156029" localize="false"/>
-<paragraph role="heading" id="hd_id3155140" xml-lang="en-US"
level="2">YIELDMAT</paragraph>
+<h2 id="hd_id3155140">YIELDMAT</h2>
<paragraph role="paragraph" id="par_id3151332" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_YIELDMAT">Calculates the annual yield of a security, the
interest of which is paid on the date of maturity.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3159113"
xml-lang="en-US">YIELDMAT(Settlement; Maturity; Issue; Rate; Price;
Basis)</paragraph>
@@ -509,7 +509,7 @@
<embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3163717" xml-lang="en-US">A security is
purchased on 1999-03-15. It matures on 1999-11-03. The issue date was
1998-11-08. The rate of interest is 6.25%, the price is 100.0123 units. The
basis is 0. How high is the yield?</paragraph>
-<paragraph role="paragraph" id="par_id3155311"
xml-lang="en-US">=YIELDMAT("1999-03-15"; "1999-11-03"; "1998-11-08"; 0.0625;
100.0123; 0) returns 0.060954 or 6.0954 per cent.</paragraph>
+<paragraph role="paragraph" id="par_id3155311"
xml-lang="en-US"><input>=YIELDMAT("1999-03-15"; "1999-11-03"; "1998-11-08";
0.0625; 100.0123; 0)</input> returns 0.060954 or 6.0954 per cent.</paragraph>
</section>
<section id="pmt">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3149577"><bookmark_value>calculating;annuities</bookmark_value>
@@ -517,7 +517,7 @@
<bookmark_value>PMT function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RMZ" id="bm_id3148895"
localize="false"/>
-<paragraph role="heading" id="hd_id3149577" xml-lang="en-US"
level="2">PMT</paragraph>
+<h2 id="hd_id3149577">PMT</h2>
<paragraph role="paragraph" id="par_id3148563" xml-lang="en-US"><ahelp
hid="HID_FUNC_RMZ">Returns the periodic payment for an annuity with constant
interest rates.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3147278" xml-lang="en-US">PMT(Rate; NPer; PV;
FV; Type)</paragraph>
@@ -545,7 +545,7 @@
<bookmark_value>annual return on treasury bills</bookmark_value>
</bookmark><comment>mw changed "treasury bills;..." and added one
entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_TBILLEQ"
id="bm_id3147380" localize="false"/>
-<paragraph role="heading" id="hd_id3155799" xml-lang="en-US"
level="2">TBILLEQ</paragraph>
+<h2 id="hd_id3155799">TBILLEQ</h2>
<paragraph role="paragraph" id="par_id3154403" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_TBILLEQ">Calculates the annual return on a treasury
bill.</ahelp> A treasury bill is purchased on the settlement date and sold at
the full par value on the maturity date, that must fall within the same year. A
discount is deducted from the purchase price.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3150224" xml-lang="en-US">TBILLEQ(Settlement;
Maturity; Discount)</paragraph>
@@ -558,7 +558,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3153173" xml-lang="en-US">Settlement
date: March 31 1999, maturity date: June 1 1999, discount: 9.14 per
cent.</paragraph>
<paragraph role="paragraph" id="par_id3153520" xml-lang="en-US">The return on
the treasury bill corresponding to a security is worked out as
follows:</paragraph>
-<paragraph role="paragraph" id="par_id3154382"
xml-lang="en-US">=TBILLEQ("1999-03-31";"1999-06-01"; 0.0914) returns 0.094151
or 9.4151 per cent.</paragraph>
+<paragraph role="paragraph" id="par_id3154382"
xml-lang="en-US"><input>=TBILLEQ("1999-03-31";"1999-06-01"; 0.0914)</input>
returns 0.094151 or 9.4151 per cent.</paragraph>
</section>
<section id="tbillprice">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3151032"><bookmark_value>TBILLPRICE function</bookmark_value>
@@ -566,7 +566,7 @@
<bookmark_value>prices;treasury bills</bookmark_value>
</bookmark><comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_TBILLPRICE"
id="bm_id3150576" localize="false"/>
-<paragraph role="heading" id="hd_id3151032" xml-lang="en-US"
level="2">TBILLPRICE</paragraph>
+<h2 id="hd_id3151032">TBILLPRICE</h2>
<paragraph role="paragraph" id="par_id3157887" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_TBILLPRICE">Calculates the price of a treasury bill per 100
currency units.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3150284"
xml-lang="en-US">TBILLPRICE(Settlement; Maturity; Discount)</paragraph>
@@ -579,7 +579,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3155542" xml-lang="en-US">Settlement
date: March 31 1999, maturity date: June 1 1999, discount: 9 per
cent.</paragraph>
<paragraph role="paragraph" id="par_id3154578" xml-lang="en-US">The price of
the treasury bill is worked out as follows:</paragraph>
-<paragraph role="paragraph" id="par_id3154592"
xml-lang="en-US">=TBILLPRICE("1999-03-31";"1999-06-01"; 0.09) returns
98.45.</paragraph>
+<paragraph role="paragraph" id="par_id3154592"
xml-lang="en-US"><input>=TBILLPRICE("1999-03-31";"1999-06-01"; 0.09)</input>
returns 98.45.</paragraph>
</section>
<section id="tbillyield">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3152912"><bookmark_value>TBILLYIELD function</bookmark_value>
@@ -587,7 +587,7 @@
<bookmark_value>rates of return of treasury bills</bookmark_value>
</bookmark><comment>mw added two entries</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_TBILLYIELD"
id="bm_id3151346" localize="false"/>
-<paragraph role="heading" id="hd_id3152912" xml-lang="en-US"
level="2">TBILLYIELD</paragraph>
+<h2 id="hd_id3152912">TBILLYIELD</h2>
<paragraph role="paragraph" id="par_id3145560" xml-lang="en-US"><ahelp
hid="HID_AAI_FUNC_TBILLYIELD">Calculates the yield of a treasury
bill.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3156077"
xml-lang="en-US">TBILLYIELD(Settlement; Maturity; Price)</paragraph>
@@ -600,7 +600,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id3145178" xml-lang="en-US">Settlement
date: March 31 1999, maturity date: June 1 1999, price: 98.45 currency
units.</paragraph>
<paragraph role="paragraph" id="par_id3145193" xml-lang="en-US">The yield of
the treasury bill is worked out as follows:</paragraph>
-<paragraph role="paragraph" id="par_id3148528"
xml-lang="en-US">=TBILLYIELD("1999-03-31";"1999-06-01"; 98.45) returns 0.091417
or 9.1417 per cent.</paragraph>
+<paragraph role="paragraph" id="par_id3148528"
xml-lang="en-US"><input>=TBILLYIELD("1999-03-31";"1999-06-01"; 98.45)</input>
returns 0.091417 or 9.1417 per cent.</paragraph>
</section>
</sort>
<paragraph role="paragraph" id="par_id3148546" xml-lang="en-US"><link
href="text/scalc/01/04060103.xhp" name="Back to Financial Functions Part
One">Back to Financial Functions Part One</link></paragraph>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
