diff options
Diffstat (limited to 'source/text/scalc/01/04060103.xhp')
| -rw-r--r-- | source/text/scalc/01/04060103.xhp | 43 |
1 files changed, 21 insertions, 22 deletions
diff --git a/source/text/scalc/01/04060103.xhp b/source/text/scalc/01/04060103.xhp index b22e8dd066..94ad211cb6 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> |