summaryrefslogtreecommitdiff
path: root/source/text/scalc/01/04060119.xhp
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2019-11-27 15:24:34 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2019-11-27 20:06:44 +0100
commit2e263815cad73dd9b350cb4f679bc69c551e89ab (patch)
treece395866661ae8e17fa26510e0697ae9b330f187 /source/text/scalc/01/04060119.xhp
parent95642ebdd613e83f6239bcf51ba235b17682c4f4 (diff)
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@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/04060119.xhp')
-rw-r--r--source/text/scalc/01/04060119.xhp76
1 files changed, 38 insertions, 38 deletions
diff --git a/source/text/scalc/01/04060119.xhp b/source/text/scalc/01/04060119.xhp
index fb8ad96dd8..ea6686d20a 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>
generated by cgit (git 2.34.1) at 2025-01-28 23:30:35 +0000