diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060103.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/04060103.xhp | 30 |
1 files changed, 15 insertions, 15 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060103.xhp b/helpcontent2/source/text/scalc/01/04060103.xhp index 4f8be69445..28573f43ae 100644 --- a/helpcontent2/source/text/scalc/01/04060103.xhp +++ b/helpcontent2/source/text/scalc/01/04060103.xhp @@ -51,7 +51,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3153366"><bookmark_value>AMORDEGRC function</bookmark_value> <bookmark_value>depreciations;degressive amortizations</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_AMORDEGRC" id="bm_id3152578" localize="false"/> +<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" l10n="U" oldref="359">AMORDEGRC</paragraph> <paragraph xml-lang="en-US" id="par_id3147434" role="paragraph" l10n="U" oldref="360"><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> @@ -76,7 +76,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3153765"><bookmark_value>AMORLINC function</bookmark_value> <bookmark_value>depreciations;linear amortizations</bookmark_value> </bookmark><comment>mw added "depreciations;..."</comment> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_AMORLINC" id="bm_id3153711" localize="false"/> +<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" l10n="U" oldref="369">AMORLINC</paragraph> <paragraph xml-lang="en-US" id="par_id3159264" role="paragraph" l10n="U" oldref="370"><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> @@ -100,7 +100,7 @@ <section id="accrint"> <bookmark xml-lang="en-US" branch="index" id="bm_id3145257"><bookmark_value>ACCRINT function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_ACCRINT" id="bm_id3149815" localize="false"/> +<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" l10n="U" oldref="335">ACCRINT</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3151276"><bookmark_value>accrued interests;periodic payments</bookmark_value> @@ -132,7 +132,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3151240"><bookmark_value>ACCRINTM function</bookmark_value> <bookmark_value>accrued interests;one-off payments</bookmark_value> </bookmark><comment>mw added one index entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_ACCRINTM" id="bm_id3148866" localize="false"/> +<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" l10n="U" oldref="348">ACCRINTM</paragraph> <paragraph xml-lang="en-US" id="par_id3157981" role="paragraph" l10n="U" oldref="349"><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> @@ -158,7 +158,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3145753"><bookmark_value>RECEIVED function</bookmark_value> <bookmark_value>amount received for fixed-interest securities</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_RECEIVED" id="bm_id3143218" localize="false"/> +<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" l10n="U" oldref="390">RECEIVED</paragraph> <paragraph xml-lang="en-US" id="par_id3150051" role="paragraph" l10n="U" oldref="391"><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> @@ -186,7 +186,7 @@ <bookmark_value>present values</bookmark_value> <bookmark_value>calculating; present values</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_BW" id="bm_id3153072" localize="false"/> +<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" l10n="U" oldref="3">PV</paragraph> <paragraph xml-lang="en-US" id="par_id3153301" role="paragraph" l10n="U" oldref="4"><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" l10n="U" oldref="5">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> @@ -219,7 +219,7 @@ <bookmark_value>depreciations; arithmetic declining</bookmark_value> <bookmark_value>arithmetic declining depreciations</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_DIA" id="bm_id3157905" localize="false"/> +<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" l10n="U" oldref="19">SYD</paragraph> <paragraph xml-lang="en-US" id="par_id3148732" role="paragraph" l10n="U" oldref="20"><ahelp hid="HID_FUNC_DIA">Returns the arithmetic-declining depreciation rate.</ahelp></paragraph> @@ -565,7 +565,7 @@ <bookmark_value>allowances</bookmark_value> <bookmark_value>discounts</bookmark_value> </bookmark><comment>mw added "discounts" and "allowances"</comment> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_DISC" id="bm_id3149290" localize="false"/> +<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" l10n="U" oldref="379">DISC</paragraph> <paragraph xml-lang="en-US" id="par_id3153891" role="paragraph" l10n="U" oldref="380"><ahelp hid="HID_AAI_FUNC_DISC">Calculates the allowance (discount) of a security as a percentage.</ahelp></paragraph> @@ -592,7 +592,7 @@ <bookmark_value>Microsoft Excel functions</bookmark_value> <bookmark_value>durations;fixed interest securities</bookmark_value> </bookmark><comment>mw added two entries</comment> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_DURATION" id="bm_id3159344" localize="false"/> +<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" l10n="U" oldref="402">DURATION_ADD</paragraph> <paragraph xml-lang="en-US" id="par_id3145768" role="paragraph" l10n="U" oldref="403"><ahelp hid="HID_AAI_FUNC_DURATION">Calculates the duration of a fixed interest security in years.</ahelp></paragraph> @@ -624,7 +624,7 @@ <bookmark_value>net annual interest rates</bookmark_value> <bookmark_value>EFFECTIVE function</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_EFFEKTIV" id="bm_id3154290" localize="false"/> +<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" l10n="U" oldref="88">EFFECTIVE</paragraph> <paragraph xml-lang="en-US" id="par_id3154204" role="paragraph" l10n="U" oldref="89"><ahelp hid="HID_FUNC_EFFEKTIV">Returns the net annual interest rate for a nominal interest rate.</ahelp></paragraph> @@ -646,7 +646,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3147241"><bookmark_value>effective interest rates</bookmark_value> <bookmark_value>EFFECT_ADD function</bookmark_value> </bookmark><comment>mw changed "effective rates"</comment> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_EFFECT" id="bm_id3147515" localize="false"/> +<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" l10n="U" oldref="414">EFFECT_ADD</paragraph> <paragraph xml-lang="en-US" id="par_id3147524" role="paragraph" l10n="U" oldref="415"><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> @@ -670,7 +670,7 @@ <bookmark_value>depreciations;arithmetic-degressive</bookmark_value> <bookmark_value>DDB function</bookmark_value> </bookmark><comment>mw corrected two typos and added "depreciations;..."</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_GDA" id="bm_id3149176" localize="false"/> +<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" l10n="U" oldref="99">DDB</paragraph> <paragraph xml-lang="en-US" id="par_id3159190" role="paragraph" l10n="U" oldref="100"><ahelp hid="HID_FUNC_GDA">Returns the depreciation of an asset for a specified period using the arithmetic-declining method.</ahelp></paragraph> @@ -700,7 +700,7 @@ <bookmark_value>depreciations;geometric-degressive</bookmark_value> <bookmark_value>DB function</bookmark_value> </bookmark><comment>mw added "depreciations;.."</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_GDA2" id="bm_id3149973" localize="false"/> +<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" l10n="U" oldref="113">DB</paragraph> <paragraph xml-lang="en-US" id="par_id3148989" role="paragraph" l10n="U" oldref="114"><ahelp hid="HID_FUNC_GDA2">Returns the depreciation of an asset for a specified period using the double-declining balance method.</ahelp></paragraph> @@ -730,7 +730,7 @@ <bookmark_value>calculating;internal rates of return, regular payments</bookmark_value> <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/HID_FUNC_IKV" id="bm_id3148419" localize="false"/> +<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" l10n="U" oldref="128">IRR</paragraph> <paragraph xml-lang="en-US" id="par_id3143282" role="paragraph" l10n="U" oldref="129"><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> @@ -750,7 +750,7 @@ <bookmark_value>interests for unchanged amortization installments</bookmark_value> <bookmark_value>ISPMT function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ISPMT" id="bm_id3149491" localize="false"/> +<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" l10n="U" oldref="314">ISPMT</paragraph> <paragraph xml-lang="en-US" id="par_id3148693" role="paragraph" l10n="U" oldref="315"><ahelp hid="HID_FUNC_ISPMT">Calculates the level of interest for unchanged amortization installments.</ahelp></paragraph> |