diff options
Diffstat (limited to 'source/text/scalc/01/04060103.xhp')
| -rw-r--r-- | source/text/scalc/01/04060103.xhp | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/source/text/scalc/01/04060103.xhp b/source/text/scalc/01/04060103.xhp index de745bfdbb..de2ac6669b 100644 --- a/source/text/scalc/01/04060103.xhp +++ b/source/text/scalc/01/04060103.xhp @@ -44,7 +44,7 @@ <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> + <paragraph xml-lang="en-US" id="par_id3147427" role="code">AMORDEGRC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate[; Basis])</paragraph> <paragraph xml-lang="en-US" id="par_id3147125" role="paragraph"> <emph>Cost</emph> is the acquisition costs.</paragraph> <paragraph xml-lang="en-US" id="par_id3151074" role="paragraph"> @@ -67,7 +67,7 @@ <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> + <paragraph xml-lang="en-US" id="par_id3147363" role="code">AMORLINC(Cost; DatePurchased; FirstPeriod; Salvage; Period; Rate[; Basis])</paragraph> <paragraph xml-lang="en-US" id="par_id3146920" role="paragraph"> <emph>Cost</emph> means the acquisition costs.</paragraph> <paragraph xml-lang="en-US" id="par_id3163807" role="paragraph"> @@ -91,7 +91,7 @@ </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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3159092" role="code">ACCRINT(Issue; FirstInterest; Settlement; Rate; Par; Frequency; Basis)</paragraph> + <paragraph xml-lang="en-US" id="par_id3159092" role="code">ACCRINT(Issue; FirstInterest; Settlement; Rate; [Par]; Frequency[; Basis])</paragraph> <paragraph xml-lang="en-US" id="par_id3150519" role="paragraph"> <emph>Issue</emph> (required) is the issue date of the security.</paragraph> <paragraph xml-lang="en-US" id="par_id3155376" role="paragraph"> @@ -118,7 +118,7 @@ <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> + <paragraph xml-lang="en-US" id="par_id3147074" role="code">ACCRINTM(Issue; Settlement; Rate[; Par][; Basis])</paragraph> <paragraph xml-lang="en-US" id="par_id3144773" role="paragraph"> <emph>Issue</emph> (required) is the issue date of the security.</paragraph> <paragraph xml-lang="en-US" id="par_id3154956" role="paragraph"> @@ -168,7 +168,7 @@ <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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3150395" role="code">PV(Rate; NPer; Pmt; FV; Type)</paragraph> + <paragraph xml-lang="en-US" id="par_id3150395" role="code">PV(Rate; NPer; Pmt[; FV][; Type])</paragraph> <paragraph xml-lang="en-US" id="par_id3151341" role="paragraph"> <emph>Rate</emph> defines the interest rate per period.</paragraph> <paragraph xml-lang="en-US" id="par_id3153023" role="paragraph"> @@ -632,7 +632,7 @@ <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"/> - <paragraph xml-lang="en-US" id="par_id3166452" role="code">DDB(Cost; Salvage; Life; Period; Factor)</paragraph> + <paragraph xml-lang="en-US" id="par_id3166452" role="code">DDB(Cost; Salvage; Life; Period[; Factor])</paragraph> <paragraph xml-lang="en-US" id="par_id3153237" role="paragraph"> <emph>Cost</emph> fixes the initial cost of an asset.</paragraph> <paragraph xml-lang="en-US" id="par_id3149787" role="paragraph"> @@ -659,7 +659,7 @@ <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"/> - <paragraph xml-lang="en-US" id="par_id3153349" role="code">DB(Cost; Salvage; Life; Period; Month)</paragraph> + <paragraph xml-lang="en-US" id="par_id3153349" role="code">DB(Cost; Salvage; Life; Period[; Month])</paragraph> <paragraph xml-lang="en-US" id="par_id3148462" role="paragraph"> <emph>Cost</emph> is the initial cost of an asset.</paragraph> <paragraph xml-lang="en-US" id="par_id3148658" role="paragraph"> @@ -686,7 +686,7 @@ <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"/> - <paragraph xml-lang="en-US" id="par_id3155427" role="code">IRR(Values; Guess)</paragraph> + <paragraph xml-lang="en-US" id="par_id3155427" role="code">IRR(Values[; Guess])</paragraph> <paragraph xml-lang="en-US" id="par_id3144758" role="paragraph"> <emph>Values</emph> represents an array containing the values.</paragraph> <paragraph xml-lang="en-US" id="par_id3149233" role="paragraph"> |