Difference between revisions of "Documentation/How Tos/Calc: Financial functions"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
m
 
(61 intermediate revisions by 6 users not shown)
Line 1: Line 1:
−
==Financial Functions==
+
{{DISPLAYTITLE: Financial Functions}}
 +
{{Documentation/CalcFunc FinancialTOC
 +
|ShowPrevPage={{{ShowPrevPage}}}
 +
|PrevPage={{{PrevPage}}}
 +
|ShowNextPage={{{ShowNextPage}}}
 +
|NextPage={{{NextPage}}}
 +
|bookid=CalcFunctions
 +
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">[[Documentation/Reference/Calc_functions|CALC FUNCTIONS]]</div>
 +
|ShowParttitle=block
 +
|parttitle=[[Documentation/How_Tos/Calc:_Financial_functions|<div style="font-size: 140%;">Financial Functions]]
 +
|ShowPrevPart=block
 +
|PrevPart=Documentation/How_Tos/Calc:_Date_%26_Time_functions
 +
|ShowNextPart=block
 +
|NextPart=Documentation/How_Tos/Calc:_Information_functions
 +
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
 +
}}__NOTOC__
 +
[[File:open.jpg]]
 +
 
 +
==<big>Financial functions</big>==
 
The Financial functions provide common business calculations.
 
The Financial functions provide common business calculations.
  
 
{| border="0" cellpadding="0" cellspacing="10" align="left"
 
{| border="0" cellpadding="0" cellspacing="10" align="left"
 +
|-valign="top"
 +
|colspan="2"|'''<big> Depreciation</big>'''
 +
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: AMORDEGRC function|'''AMORDEGRC''']]
 
|[[Documentation/How_Tos/Calc: AMORDEGRC function|'''AMORDEGRC''']]
−
|Calculates the amount of depreciation for a settlement period as degressive amortization. Unlike AMORLINC, a depreciation coefficient that is independent of the depreciable life is used here.
+
|Returns depreciation for a period using degressive depreciation (French system).  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: AMORLINC function|'''AMORLINC''']]
 
|[[Documentation/How_Tos/Calc: AMORLINC function|'''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.
+
|Returns depreciation for a period using linear depreciation (French system).  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: ACCRINT function|'''ACCRINT''']]
+
|[[Documentation/How_Tos/Calc: DB function|'''DB''']]
−
|Calculates the accrued interest of a security in the case of periodic payments.
+
|Returns the depreciation of an asset for a given year using the fixed rate declining-balance method.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: ACCRINTM function|'''ACCRINTM''']]
+
|[[Documentation/How_Tos/Calc: DDB function|'''DDB''']]
−
|Calculates the accrued interest of a security in the case of one-off payment at the settlement date.
+
|Returns the depreciation of an asset for a given year using the double (or other factor) declining-balance method.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: RECEIVED function|'''RECEIVED''']]
+
|[[Documentation/How_Tos/Calc: SLN function|'''SLN''']]
−
|Calculates the amount received that is paid for a fixed-interest security at a given point in time.
+
|Returns the depreciation of an asset in a single period using the straight-line depreciation method.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PV function|'''PV''']]
+
|[[Documentation/How_Tos/Calc: SYD function|'''SYD''']]
−
|Returns the present value of an investment resulting from a series of regular payments.
+
|Returns the depreciation of an asset for a given year using the sum-of-years'-digits method.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: SYD function|'''SYD''']]
+
|[[Documentation/How_Tos/Calc: VDB function|'''VDB''']]
−
|Returns the arithmetic-declining depreciation rate.
+
|Returns the depreciation of an asset for a given year using a variable declining-balance method.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DISC function|'''DISC''']]
+
|colspan="2"|'''<big> Payment Streams, Annuities, Loans</big>'''
−
|Calculates the allowance (discount) of a security as a percentage.
+
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DURATION_ADD function|'''DURATION_ADD''']]
+
|[[Documentation/How_Tos/Calc: CUMIPMT function|'''CUMIPMT''']]
−
|Calculates the duration of a fixed interest security in years.
+
|Returns the total interest paid on a loan in specified periodic payments.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: EFFECTIVE function|'''EFFECTIVE''']]
+
|[[Documentation/How_Tos/Calc: CUMIPMT_ADD function|'''CUMIPMT_ADD''']]
−
|Returns the net annual interest rate for a nominal interest rate.
+
|Returns the total interest paid on a loan in specified periodic payments.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: EFFECT_ADD function|'''EFFECT_ADD''']]
+
|[[Documentation/How_Tos/Calc: CUMPRINC function|'''CUMPRINC''']]
−
|Calculates the effective annual rate of interest on the basis of the nominal interest rate and the number of interest payments per annum.
+
|Returns the total capital repaid on a loan in specified periodic payments.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DDB function|'''DDB''']]
+
|[[Documentation/How_Tos/Calc: CUMPRINC_ADD function|'''CUMPRINC_ADD''']]
−
|Returns the depreciation of an asset for a specified period using the arithmetic-declining method.
+
|Returns the total capital repaid on a loan in specified periodic payments.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DB function|'''DB''']]
+
|[[Documentation/How_Tos/Calc: FV function|'''FV''']]
−
|Returns the depreciation of an asset for a specified period using the double-declining balance method.
+
|Returns the future value of an initial sum with a subsequent stream of payments.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: IRR function|'''IRR''']]
+
|[[Documentation/How_Tos/Calc: FVSCHEDULE function|'''FVSCHEDULE''']]
−
|Calculates the internal rate of return for an investment. 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).
+
|Returns the future value of an initial sum, with changing future interest rates.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: ISPMT function|'''ISPMT''']]
+
|[[Documentation/How_Tos/Calc: IPMT function|'''IPMT''']]
−
|Calculates the level of interest for unchanged amortization installments.
+
|Returns the portion of the periodic payment which is interest for a fixed rate loan or annuity.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PPMT function|'''PPMT''']]
+
|[[Documentation/How_Tos/Calc: IRR function|'''IRR''']]
−
|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.
+
|Calculates the internal rate of return of a series of cash flows.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: CUMPRINC function|'''CUMPRINC''']]
+
|[[Documentation/How_Tos/Calc: ISPMT function|'''ISPMT''']]
−
|Returns the cumulative interest paid for an investment period with a constant interest rate.
+
|Returns the interest paid in a period for a fixed rate loan.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: CUMPRINC_ADD function|'''CUMPRINC_ADD''']]
+
|[[Documentation/How_Tos/Calc: MIRR function|'''MIRR''']]
−
|Calculates the cumulative redemption of a loan in a period.
+
|Returns the modified internal rate of return of a series of cash flows.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: CUMIPMT function|'''CUMIPMT''']]
+
|[[Documentation/How_Tos/Calc: NPER function|'''NPER''']]
−
|Calculates the cumulative interest payments, that is, the total interest, for an investment based on a constant interest rate.
+
|Returns the number of payment periods for an annuity.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: CUMIPMT_ADD function|'''CUMIPMT_ADD''']]
+
|[[Documentation/How_Tos/Calc: NPV function|'''NPV''']]
−
|Calculates the accumulated interest for a period.
+
|Returns the net present value of an investment with regular cash payments.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PRICE function|'''PRICE''']]
+
|[[Documentation/How_Tos/Calc: PMT function|'''PMT''']]
−
|Calculates the market value of a fixed interest security with a par value of 100 currency units as a function of the forecast yield.
+
|Returns the payment per period for a fixed rate loan.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PRICEDISC function|'''PRICEDISC''']]
+
|[[Documentation/How_Tos/Calc: PPMT function|'''PPMT''']]
−
|Calculates the price per 100 currency units of par value of a non-interest- bearing security.
+
|Returns the portion of the periodic payment which is repaid capital for a fixed rate loan or annuity.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PRICEMAT function|'''PRICEMAT''']]
+
|[[Documentation/How_Tos/Calc: PV function|'''PV''']]
−
|Calculates the price per 100 currency units of par value of a security, that pays interest on the maturity date.
+
|Returns the present value of a stream of future payments with a final lump sum.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DURATION function|'''DURATION''']]
+
|[[Documentation/How_Tos/Calc: RATE function|'''RATE''']]
−
|Calculates the number of periods required by an investment to attain the desired value.
+
|Calculates the interest rate for an annuity.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: SLN function|'''SLN''']]
+
|[[Documentation/How_Tos/Calc: RRI function|'''RRI''']]
−
|Returns the straight-line depreciation of an asset for one period.The amount of the depreciation is constant during the depreciation period.
+
|Returns an equivalent interest rate when an investment increases in value.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: MDURATION function|'''MDURATION''']]
+
|[[Documentation/How_Tos/Calc: XIRR function|'''XIRR''']]
−
|Calculates the modified Macauley duration of a fixed interest security in years.
+
|Calculates the internal rate of return of a series of irregular cash flows.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: NPV function|'''NPV''']]
+
|[[Documentation/How_Tos/Calc: XNPV function|'''XNPV''']]
−
|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.
+
|Returns the net present value of an investment with irregular cash payments.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: NOMINAL function|'''NOMINAL''']]
+
|colspan="2"|'''<big> Securities</big>'''
−
|Calculates the yearly nominal interest rate, given the effective rate and the number of compounding periods per year.
+
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: NOMINAL_ADD function|'''NOMINAL_ADD''']]
+
|[[Documentation/How_Tos/Calc: ACCRINT function|'''ACCRINT''']]
−
|Calculates the annual nominal rate of interest on the basis of the effective rate and the number of interest payments per annum.
+
|Calculates the accrued interest for a security with periodic interest payments.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DOLLARFR function|'''DOLLARFR''']]
+
|[[Documentation/How_Tos/Calc: ACCRINTM function|'''ACCRINTM''']]
−
|Converts a quotation that has been given as a decimal number into a mixed decimal fraction.
+
|Calculates the accrued interest for a security that pays at maturity.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DOLLARDE function|'''DOLLARDE''']]
+
|[[Documentation/How_Tos/Calc: DISC function|'''DISC''']]
−
|Converts a quotation that has been given as a decimal fraction into a decimal number.
+
|Returns the discount rate of a security.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: MIRR function|'''MIRR''']]
+
|[[Documentation/How_Tos/Calc: DURATION function|'''DURATION''']]
−
|Calculates the modified internal rate of return of a series of investments.
+
|Returns the number of periods needed for an investment to reach a certain value.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: YIELD function|'''YIELD''']]
+
|[[Documentation/How_Tos/Calc: DURATION_ADD function|'''DURATION_ADD''']]
−
|Calculates the yield of a security.
+
|Returns the Macaulay duration of a security.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: YIELDDISC function|'''YIELDDISC''']]
+
|[[Documentation/How_Tos/Calc: EFFECTIVE function|'''EFFECTIVE''']]
−
|Calculates the annual yield of a non-interest-bearing security.
+
|Returns the effective compounded interest rate given a nominal interest rate.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: YIELDMAT function|'''YIELDMAT''']]
+
|[[Documentation/How_Tos/Calc: EFFECT_ADD function|'''EFFECT_ADD''']]
−
|Calculates the annual yield of a security, the interest of which is paid on the date of maturity.
+
|Returns the effective compounded interest rate given a nominal interest rate.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PMT function|'''PMT''']]
+
|[[Documentation/How_Tos/Calc: INTRATE function|'''INTRATE''']]
−
|Returns the periodic payment for an annuity with constant interest rates.
+
|Returns the equivalent annual interest rate for an investment bought at one price and sold at another.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: TBILLEQ function|'''TBILLEQ''']]
+
|[[Documentation/How_Tos/Calc: MDURATION function|'''MDURATION''']]
−
|Calculates the annual return on a treasury bill (). 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.
+
|Returns the modified Macaulay duration of a security.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: TBILLPRICE function|'''TBILLPRICE''']]
+
|[[Documentation/How_Tos/Calc: NOMINAL function|'''NOMINAL''']]
−
|Calculates the price of a treasury bill per 100 currency units.
+
|Returns a nominal interest rate given the effective compounded interest rate.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: TBILLYIELD function|'''TBILLYIELD''']]
+
|[[Documentation/How_Tos/Calc: NOMINAL_ADD function|'''NOMINAL_ADD''']]
−
|Calculates the yield of a treasury bill.
+
|Returns a nominal interest rate given the effective compounded interest rate.
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: ODDFPRICE function|'''ODDFPRICE''']]
 
|[[Documentation/How_Tos/Calc: ODDFPRICE function|'''ODDFPRICE''']]
−
|Calculates the price per 100 currency units par value of a security, if the first interest date falls irregularly.
+
|Returns the value of a security per 100 currency units of face value, where the time to the first  
 +
interest payment is not a whole period.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: ODDFYIELD function|'''ODDFYIELD''']]
 
|[[Documentation/How_Tos/Calc: ODDFYIELD function|'''ODDFYIELD''']]
−
|Calculates the yield of a security if the first interest date falls irregularly.
+
|Returns the yield of a security, where the time to the first interest payment is not a whole period.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: ODDLPRICE function|'''ODDLPRICE''']]
 
|[[Documentation/How_Tos/Calc: ODDLPRICE function|'''ODDLPRICE''']]
−
|Calculates the price per 100 currency units par value of a security, if the last interest date falls irregularly.
+
|Returns the value of a security per 100 currency units of face value, where the last interest payment
 +
is not a whole period.
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: ODDLYIELD function|'''ODDLYIELD''']]
 
|[[Documentation/How_Tos/Calc: ODDLYIELD function|'''ODDLYIELD''']]
−
|Calculates the yield of a security if the last interest date falls irregularly.
+
|Returns the yield of a security, where the last interest payment is not a whole period.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: VDB function|'''VDB''']]
+
|[[Documentation/How_Tos/Calc: PRICE function|'''PRICE''']]
−
|Returns the depreciation of an asset for a specified or partial period using a variable declining balance method.
+
|Calculates a quoted price for an interest paying security, per 100 currency units par value.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: XIRR function|'''XIRR''']]
+
|[[Documentation/How_Tos/Calc: PRICEDISC function|'''PRICEDISC''']]
−
|Calculates the internal rate of return for a list of payments which take place on different dates. The calculation is based on a 365 days per year basis, ignoring leap years.
+
|Calculates a price for a non-interest paying discounted bond.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: XNPV function|'''XNPV''']]
+
|[[Documentation/How_Tos/Calc: PRICEMAT function|'''PRICEMAT''']]
−
|Calculates the capital value (net present value)for a list of payments which take place on different dates. The calculation is based on a 365 days per year basis, ignoring leap years.
+
|Calculates a price (per 100 currency units par value) for a bond that pays interest on maturity.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: RRI function|'''RRI''']]
+
|[[Documentation/How_Tos/Calc: RECEIVED function|'''RECEIVED''']]
−
|Calculates the interest rate resulting from the profit (return) of an investment.
+
|Calculates the amount received at maturity for a zero coupon bond.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: RATE function|'''RATE''']]
+
|[[Documentation/How_Tos/Calc: TBILLEQ function|'''TBILLEQ''']]
−
|Returns the constant interest rate per period of an annuity.
+
|Returns the bond-equivalent-yield (BEY) for a US Treasury bill.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: INTRATE function|'''INTRATE''']]
+
|[[Documentation/How_Tos/Calc: TBILLPRICE function|'''TBILLPRICE''']]
−
|Calculates the annual interest rate that results when a security (or other item) is purchased at an investment value and sold at a redemption value. No interest is paid.
+
|Returns the issue price for a US Treasury bill, per $100 par value, given a discount rate.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: COUPNCD function|'''COUPNCD''']]
+
|[[Documentation/How_Tos/Calc: TBILLYIELD function|'''TBILLYIELD''']]
−
|Returns the date of the first interest date after the settlement date. Format the result as a date.
+
|Returns the yield for a US Treasury bill.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: COUPDAYS function|'''COUPDAYS''']]
+
|[[Documentation/How_Tos/Calc: YIELD function|'''YIELD''']]
−
|Returns the number of days in the current interest period in which the settlement date falls.
+
|Calculates the yield for an interest paying security.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: COUPDAYSNC function|'''COUPDAYSNC''']]
+
|[[Documentation/How_Tos/Calc: YIELDDISC function|'''YIELDDISC''']]
−
|Returns the number of days from the settlement date until the next interest date.
+
|Calculates the yield for a non-interest paying discounted bond.
 +
 
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: YIELDMAT function|'''YIELDMAT''']]
 +
|Calculates the yield for a bond that pays interest on maturity.  
 +
 +
|-valign="top"
 +
|colspan="2"|'''<big> Coupons</big>'''
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: COUPDAYBS function|'''COUPDAYBS''']]
 
|[[Documentation/How_Tos/Calc: COUPDAYBS function|'''COUPDAYBS''']]
−
|Returns the number of days from the first day of interest payment on a security until the settlement date.
+
|Returns the number of days between the coupon date preceding the settlement, and the settlement date.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: COUPPCD function|'''COUPPCD''']]
+
|[[Documentation/How_Tos/Calc: COUPDAYS function|'''COUPDAYS''']]
−
|Returns the date of the interest date prior to the settlement date. Format the result as a date.
+
|Returns the number of days in the coupon period that contains the settlement date.
 +
 
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: COUPDAYSNC function|'''COUPDAYSNC''']]
 +
|Returns the number of days between the settlement date and the next coupon date.
 +
 
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: COUPNCD function|'''COUPNCD''']]
 +
|Returns the coupon date next after the settlement date.  
  
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: COUPNUM function|'''COUPNUM''']]
 
|[[Documentation/How_Tos/Calc: COUPNUM function|'''COUPNUM''']]
−
|Returns the number of coupons (interest payments) between the settlement date and the maturity date.
+
|Returns the number of coupons (interest payments) between the settlement  
 +
date and maturity.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: IPMT function|'''IPMT''']]
+
|[[Documentation/How_Tos/Calc: COUPPCD function|'''COUPPCD''']]
−
|Calculates the periodic amortizement for an investment with regular payments and a constant interest rate.
+
|Returns the coupon (interest payment) date which precedes the settlement date.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: FV function|'''FV''']]
+
|colspan="2"|'''<big> Miscellaneous</big>'''
−
|Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).
+
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: FVSCHEDULE function|'''FVSCHEDULE''']]
+
|[[Documentation/How_Tos/Calc: DOLLARDE function|'''DOLLARDE''']]
−
|Calculates the accumulated value of the starting capital for a series of periodically varying interest rates.
+
|Converts a fractional number representation of a number into a decimal number.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: NPER function|'''NPER''']]
+
|[[Documentation/How_Tos/Calc: DOLLARFR function|'''DOLLARFR''']]
−
|Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
+
|Converts a decimal number into a fractional representation of that number.
 
|}
 
|}
 
<br style="clear:both;" />
 
<br style="clear:both;" />
 
<!-- why on earth is this necessary? -->
 
<!-- why on earth is this necessary? -->
−
==See also==
+
 
−
'''[[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]'''
+
{{SeeAlso|EN|
 +
* [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]
 +
* [[Documentation/How_Tos/Calc: Date & Time functions#Financial date systems|Financial date systems]]
 +
 
 +
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]],
 +
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]
 +
}}
 +
 
 +
 
 +
[[nl:Documentation/nl/How_Tos/Calc:_Financiële_functies]]
 +
[[Category: Documentation/Reference/Calc]]

Latest revision as of 16:14, 1 February 2024

Open.jpg

Financial functions

The Financial functions provide common business calculations.

Depreciation
AMORDEGRC Returns depreciation for a period using degressive depreciation (French system).
AMORLINC Returns depreciation for a period using linear depreciation (French system).
DB Returns the depreciation of an asset for a given year using the fixed rate declining-balance method.
DDB Returns the depreciation of an asset for a given year using the double (or other factor) declining-balance method.
SLN Returns the depreciation of an asset in a single period using the straight-line depreciation method.
SYD Returns the depreciation of an asset for a given year using the sum-of-years'-digits method.
VDB Returns the depreciation of an asset for a given year using a variable declining-balance method.
Payment Streams, Annuities, Loans
CUMIPMT Returns the total interest paid on a loan in specified periodic payments.
CUMIPMT_ADD Returns the total interest paid on a loan in specified periodic payments.
CUMPRINC Returns the total capital repaid on a loan in specified periodic payments.
CUMPRINC_ADD Returns the total capital repaid on a loan in specified periodic payments.
FV Returns the future value of an initial sum with a subsequent stream of payments.
FVSCHEDULE Returns the future value of an initial sum, with changing future interest rates.
IPMT Returns the portion of the periodic payment which is interest for a fixed rate loan or annuity.
IRR Calculates the internal rate of return of a series of cash flows.
ISPMT Returns the interest paid in a period for a fixed rate loan.
MIRR Returns the modified internal rate of return of a series of cash flows.
NPER Returns the number of payment periods for an annuity.
NPV Returns the net present value of an investment with regular cash payments.
PMT Returns the payment per period for a fixed rate loan.
PPMT Returns the portion of the periodic payment which is repaid capital for a fixed rate loan or annuity.
PV Returns the present value of a stream of future payments with a final lump sum.
RATE Calculates the interest rate for an annuity.
RRI Returns an equivalent interest rate when an investment increases in value.
XIRR Calculates the internal rate of return of a series of irregular cash flows.
XNPV Returns the net present value of an investment with irregular cash payments.
Securities
ACCRINT Calculates the accrued interest for a security with periodic interest payments.
ACCRINTM Calculates the accrued interest for a security that pays at maturity.
DISC Returns the discount rate of a security.
DURATION Returns the number of periods needed for an investment to reach a certain value.
DURATION_ADD Returns the Macaulay duration of a security.
EFFECTIVE Returns the effective compounded interest rate given a nominal interest rate.
EFFECT_ADD Returns the effective compounded interest rate given a nominal interest rate.
INTRATE Returns the equivalent annual interest rate for an investment bought at one price and sold at another.
MDURATION Returns the modified Macaulay duration of a security.
NOMINAL Returns a nominal interest rate given the effective compounded interest rate.
NOMINAL_ADD Returns a nominal interest rate given the effective compounded interest rate.
ODDFPRICE Returns the value of a security per 100 currency units of face value, where the time to the first

interest payment is not a whole period.

ODDFYIELD Returns the yield of a security, where the time to the first interest payment is not a whole period.
ODDLPRICE Returns the value of a security per 100 currency units of face value, where the last interest payment

is not a whole period.

ODDLYIELD Returns the yield of a security, where the last interest payment is not a whole period.
PRICE Calculates a quoted price for an interest paying security, per 100 currency units par value.
PRICEDISC Calculates a price for a non-interest paying discounted bond.
PRICEMAT Calculates a price (per 100 currency units par value) for a bond that pays interest on maturity.
RECEIVED Calculates the amount received at maturity for a zero coupon bond.
TBILLEQ Returns the bond-equivalent-yield (BEY) for a US Treasury bill.
TBILLPRICE Returns the issue price for a US Treasury bill, per $100 par value, given a discount rate.
TBILLYIELD Returns the yield for a US Treasury bill.
YIELD Calculates the yield for an interest paying security.
YIELDDISC Calculates the yield for a non-interest paying discounted bond.
YIELDMAT Calculates the yield for a bond that pays interest on maturity.
Coupons
COUPDAYBS Returns the number of days between the coupon date preceding the settlement, and the settlement date.
COUPDAYS Returns the number of days in the coupon period that contains the settlement date.
COUPDAYSNC Returns the number of days between the settlement date and the next coupon date.
COUPNCD Returns the coupon date next after the settlement date.
COUPNUM Returns the number of coupons (interest payments) between the settlement

date and maturity.

COUPPCD Returns the coupon (interest payment) date which precedes the settlement date.
Miscellaneous
DOLLARDE Converts a fractional number representation of a number into a decimal number.
DOLLARFR Converts a decimal number into a fractional representation of that number.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_Financial_functions&oldid=259959"
Views
Personal tools
Navigation
Tools
In other languages