[Libreoffice-commits] help.git: source/text
Olivier Hallot (via logerrit)
logerrit at kemper.freedesktop.org
Wed Nov 27 19:07:06 UTC 2019
source/text/scalc/01/04060103.xhp | 43 ++++++++++-----------
source/text/scalc/01/04060119.xhp | 76 +++++++++++++++++++-------------------
2 files changed, 59 insertions(+), 60 deletions(-)
New commits:
commit 2e263815cad73dd9b350cb4f679bc69c551e89ab
Author: Olivier Hallot <olivier.hallot at libreoffice.org>
AuthorDate: Wed Nov 27 15:24:34 2019 -0300
Commit: Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Wed Nov 27 20:06:44 2019 +0100
tdf#129057 Correct DURATION and PDURATION Help
+ some refactor on the 2 pages
Change-Id: I997a3ed484c6cccf71d9726444ca75ded7d48d32
Reviewed-on: https://gerrit.libreoffice.org/83942
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot at 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>
More information about the Libreoffice-commits
mailing list