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

From Apache OpenOffice Wiki
Jump to: navigation, search
(categorised the functions)
Line 6: Line 6:
 
{| border="0" cellpadding="0" cellspacing="10" align="left"
 
{| border="0" cellpadding="0" cellspacing="10" align="left"
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: ACCRINT function|'''ACCRINT''']]
+
|colspan="2"|'''<big> Depreciation</big>'''
−
|Calculates the accrued interest for a security with periodic interest payments.
+
−
 
+
−
|-valign="top"
+
−
|[[Documentation/How_Tos/Calc: ACCRINTM function|'''ACCRINTM''']]
+
−
|Calculates the accrued interest for a security that pays at maturity.
+
  
 
|-valign="top"
 
|-valign="top"
Line 19: Line 14:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: AMORLINC function|'''AMORLINC''']]
 
|[[Documentation/How_Tos/Calc: AMORLINC function|'''AMORLINC''']]
−
|Returns depreciation for a settlement period as linear amortization.  
+
|Returns depreciation for a settlement period as linear amortization.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: COUPDAYBS function|'''COUPDAYBS''']]
+
|[[Documentation/How_Tos/Calc: DB function|'''DB''']]
−
|Returns the number of days between the coupon date preceding the settlement, and the settlement date.  
+
|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: COUPDAYS function|'''COUPDAYS''']]
+
|[[Documentation/How_Tos/Calc: DDB function|'''DDB''']]
−
|Returns the number of days in the coupon period that contains 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: COUPDAYSNC function|'''COUPDAYSNC''']]
+
|[[Documentation/How_Tos/Calc: SLN function|'''SLN''']]
−
|Returns the number of days between the settlement date and the next coupon date.
+
|Returns the depreciation of an asset in a single period using the straight-line depreciation method.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: COUPNCD function|'''COUPNCD''']]
+
|[[Documentation/How_Tos/Calc: SYD function|'''SYD''']]
−
|Returns the coupon date next after the settlement date.  
+
|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: COUPNUM function|'''COUPNUM''']]
+
|[[Documentation/How_Tos/Calc: VDB function|'''VDB''']]
−
|Returns the number of coupons (interest payments) between the settlement date and maturity.  
+
|Returns the depreciation of an asset for a given year using a variable declining-balance method.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: COUPPCD function|'''COUPPCD''']]
+
|colspan="2"|'''<big> Payment Streams, Annuities, Loans</big>'''
−
|Returns the coupon (interest payment) date which precedes the settlement date.
+
  
 
|-valign="top"
 
|-valign="top"
Line 59: Line 53:
 
|-valign="top"
 
|-valign="top"
 
|[[Documentation/How_Tos/Calc: CUMPRINC_ADD function|'''CUMPRINC_ADD''']]
 
|[[Documentation/How_Tos/Calc: CUMPRINC_ADD function|'''CUMPRINC_ADD''']]
−
|Returns the total capital repaid on a loan in specified periods.  
+
|Returns the total capital repaid on a loan in specified periods.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DB function|'''DB''']]
+
|[[Documentation/How_Tos/Calc: EFFECTIVE function|'''EFFECTIVE''']]
−
|Returns the depreciation of an asset for a given year using the fixed rate declining-balance method.  
+
|Returns the effective compounded interest rate given a nominal interest rate.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DDB function|'''DDB''']]
+
|[[Documentation/How_Tos/Calc: EFFECT_ADD function|'''EFFECT_ADD''']]
−
|Returns the depreciation of an asset for a given year using the double (or other factor) declining-balance method.  
+
|Returns the effective compounded interest rate given a nominal interest rate.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DISC function|'''DISC''']]
+
|[[Documentation/How_Tos/Calc: FV function|'''FV''']]
−
|Calculates the allowance (discount) of a security as a percentage.
+
|Returns the future value of an initial sum with a subsequent stream of payments.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DOLLARDE function|'''DOLLARDE''']]
+
|[[Documentation/How_Tos/Calc: FVSCHEDULE function|'''FVSCHEDULE''']]
−
|Converts a fractional number representation of a number into a decimal number.  
+
|Returns the future value of an initial sum, with changing future interest rates.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DOLLARFR function|'''DOLLARFR''']]
+
|[[Documentation/How_Tos/Calc: IPMT function|'''IPMT''']]
−
|Converts a decimal number into a fractional representation of that number.
+
|Returns the interest paid in a period for a fixed rate loan.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DURATION function|'''DURATION''']]
+
|[[Documentation/How_Tos/Calc: IRR function|'''IRR''']]
−
|Calculates the number of periods required by an investment to attain the desired value.
+
|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).
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: DURATION_ADD function|'''DURATION_ADD''']]
+
|[[Documentation/How_Tos/Calc: ISPMT function|'''ISPMT''']]
−
|Calculates the duration of a fixed interest security in years.
+
|Returns the interest paid in a period for a fixed rate loan.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: EFFECTIVE function|'''EFFECTIVE''']]
+
|[[Documentation/How_Tos/Calc: MIRR function|'''MIRR''']]
−
|Returns the effective compounded interest rate given a nominal interest rate.  
+
|Calculates the modified internal rate of return of a series of investments.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: EFFECT_ADD function|'''EFFECT_ADD''']]
+
|[[Documentation/How_Tos/Calc: NPER function|'''NPER''']]
−
|Returns the effective compounded interest rate given a nominal interest rate.  
+
|Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: FV function|'''FV''']]
+
|[[Documentation/How_Tos/Calc: NPV function|'''NPV''']]
−
|Returns the future value of an initial sum with a subsequent stream of payments.
+
|Returns the net present value of an investment given cash payments and a discount rate.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: FVSCHEDULE function|'''FVSCHEDULE''']]
+
|[[Documentation/How_Tos/Calc: PMT function|'''PMT''']]
−
|Returns the future value of an initial sum, with changing future interest rates.  
+
|Returns the payment per period for a fixed rate loan.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: INTRATE function|'''INTRATE''']]
+
|[[Documentation/How_Tos/Calc: PPMT function|'''PPMT''']]
−
|Returns the equivalent annual interest rate for an item bought at one price and sold at another.  
+
|Returns the capital repaid in a period for a fixed rate loan.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: IPMT function|'''IPMT''']]
+
|[[Documentation/How_Tos/Calc: PV function|'''PV''']]
−
|Returns the interest paid in a period for a fixed rate loan.  
+
|Returns the present value of a stream of future payments with a final lump sum.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: IRR function|'''IRR''']]
+
|[[Documentation/How_Tos/Calc: RATE function|'''RATE''']]
−
|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 constant interest rate per period of an annuity.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: ISPMT function|'''ISPMT''']]
+
|[[Documentation/How_Tos/Calc: RRI function|'''RRI''']]
−
|Returns the interest paid in a period for a fixed rate loan.  
+
|Calculates the interest rate resulting from the profit (return) of an investment.
  
 
|-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 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.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: MIRR function|'''MIRR''']]
+
|[[Documentation/How_Tos/Calc: XNPV function|'''XNPV''']]
−
|Calculates the modified internal rate of return of a series of investments.
+
|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>'''
−
|Returns a nominal interest rate given the effective compounded interest rate.
+
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: NOMINAL_ADD function|'''NOMINAL_ADD''']]
+
|[[Documentation/How_Tos/Calc: ACCRINT function|'''ACCRINT''']]
−
|Returns a nominal interest rate given the effective compounded interest rate.  
+
|Calculates the accrued interest for a security with periodic interest payments.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: NPER function|'''NPER''']]
+
|[[Documentation/How_Tos/Calc: ACCRINTM function|'''ACCRINTM''']]
−
|Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
+
|Calculates the accrued interest for a security that pays at maturity.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: NPV function|'''NPV''']]
+
|[[Documentation/How_Tos/Calc: DISC function|'''DISC''']]
−
|Returns the net present value of an investment given cash payments and a discount rate.  
+
|Calculates the allowance (discount) of a security as a percentage.
 +
 
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: DURATION function|'''DURATION''']]
 +
|Calculates the number of periods required by an investment to attain the desired value.
 +
 
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: DURATION_ADD function|'''DURATION_ADD''']]
 +
|Calculates the duration of a fixed interest security in years.
 +
 
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: INTRATE function|'''INTRATE''']]
 +
|Returns the equivalent annual interest rate for an item bought at one price and sold at another.
 +
 
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: MDURATION function|'''MDURATION''']]
 +
|Calculates the modified Macauley duration of a fixed interest security in years.
 +
 
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: NOMINAL function|'''NOMINAL''']]
 +
|Returns a nominal interest rate given the effective compounded interest rate.
 +
 
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: NOMINAL_ADD function|'''NOMINAL_ADD''']]
 +
|Returns a nominal interest rate given the effective compounded interest rate.
  
 
|-valign="top"
 
|-valign="top"
Line 160: Line 177:
 
|[[Documentation/How_Tos/Calc: ODDLYIELD function|'''ODDLYIELD''']]
 
|[[Documentation/How_Tos/Calc: ODDLYIELD function|'''ODDLYIELD''']]
 
|Returns the yield of a security, where the last interest payment is not a whole period.   
 
|Returns the yield of a security, where the last interest payment is not a whole period.   
−
 
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: PMT function|'''PMT''']]
 
−
|Returns the payment per period for a fixed rate loan.
 
−
 
−
|-valign="top"
 
−
|[[Documentation/How_Tos/Calc: PPMT function|'''PPMT''']]
 
−
|Returns the capital repaid in a period for a fixed rate loan.
 
  
 
|-valign="top"
 
|-valign="top"
Line 182: Line 191:
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: PV function|'''PV''']]
+
|[[Documentation/How_Tos/Calc: RECEIVED function|'''RECEIVED''']]
−
|Returns the present value of a stream of future payments with a final lump sum.  
+
|Calculates the amount received that is paid for a fixed-interest security at a given point in time.
  
 
|-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: RECEIVED function|'''RECEIVED''']]
+
|[[Documentation/How_Tos/Calc: TBILLPRICE function|'''TBILLPRICE''']]
−
|Calculates the amount received that is paid for a fixed-interest security at a given point in time.
+
|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: RRI function|'''RRI''']]
+
|[[Documentation/How_Tos/Calc: TBILLYIELD function|'''TBILLYIELD''']]
−
|Calculates the interest rate resulting from the profit (return) of an investment.
+
|Returns the yield for a US Treasury bill.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: SLN function|'''SLN''']]
+
|[[Documentation/How_Tos/Calc: YIELD function|'''YIELD''']]
−
|Returns the depreciation of an asset in a single period using the straight-line depreciation method.  
+
|Calculates the yield of a security.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: SYD function|'''SYD''']]
+
|[[Documentation/How_Tos/Calc: YIELDDISC function|'''YIELDDISC''']]
−
|Returns the depreciation of an asset for a given year using the sum-of-years'-digits method.
+
|Calculates the annual yield of a non-interest-bearing security.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: TBILLEQ function|'''TBILLEQ''']]
+
|[[Documentation/How_Tos/Calc: YIELDMAT function|'''YIELDMAT''']]
−
|Returns the bond-equivalent-yield (BEY) for a US Treasury bill.
+
|Calculates the annual yield of a security, the interest of which is paid on the date of maturity.
 +
 +
|-valign="top"
 +
|colspan="2"|'''<big> Coupons</big>'''
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: TBILLPRICE function|'''TBILLPRICE''']]
+
|[[Documentation/How_Tos/Calc: COUPDAYBS function|'''COUPDAYBS''']]
−
|Returns the issue price for a US Treasury bill, per $100 par value, given a discount rate.  
+
|Returns the number of days between the coupon date preceding the settlement, and the settlement date.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: TBILLYIELD function|'''TBILLYIELD''']]
+
|[[Documentation/How_Tos/Calc: COUPDAYS function|'''COUPDAYS''']]
−
|Returns the yield for a US Treasury bill.
+
|Returns the number of days in the coupon period that contains the settlement date.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: VDB function|'''VDB''']]
+
|[[Documentation/How_Tos/Calc: COUPDAYSNC function|'''COUPDAYSNC''']]
−
|Returns the depreciation of an asset for a given year using a variable declining-balance method.
+
|Returns the number of days between the settlement date and the next coupon date.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: XIRR function|'''XIRR''']]
+
|[[Documentation/How_Tos/Calc: COUPNCD function|'''COUPNCD''']]
−
|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.
+
|Returns the coupon date next after the settlement date.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: XNPV function|'''XNPV''']]
+
|[[Documentation/How_Tos/Calc: COUPNUM function|'''COUPNUM''']]
−
|Returns the net present value of an investment with irregular cash payments.  
+
|Returns the number of coupons (interest payments) between the settlement date and maturity.  
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: YIELD function|'''YIELD''']]
+
|[[Documentation/How_Tos/Calc: COUPPCD function|'''COUPPCD''']]
−
|Calculates the yield of a security.
+
|Returns the coupon (interest payment) date which precedes the settlement date.
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: YIELDDISC function|'''YIELDDISC''']]
+
|colspan="2"|'''<big> Miscellaneous</big>'''
−
|Calculates the annual yield of a non-interest-bearing security.
+
  
 
|-valign="top"
 
|-valign="top"
−
|[[Documentation/How_Tos/Calc: YIELDMAT function|'''YIELDMAT''']]
+
|[[Documentation/How_Tos/Calc: DOLLARDE function|'''DOLLARDE''']]
−
|Calculates the annual yield of a security, the interest of which is paid on the date of maturity.
+
|Converts a fractional number representation of a number into a decimal number.
 +
 
 +
|-valign="top"
 +
|[[Documentation/How_Tos/Calc: DOLLARFR function|'''DOLLARFR''']]
 +
|Converts a decimal number into a fractional representation of that number.
 
|}
 
|}
 
<br style="clear:both;" />
 
<br style="clear:both;" />

Revision as of 18:10, 16 August 2008

Financial Functions

The Financial functions provide common business calculations.

(Note to translators: some of these function descriptions may be rewritten for improved clarity.)

Depreciation
AMORDEGRC Returns depreciation for a settlement period as degressive amortization.
AMORLINC Returns depreciation for a settlement period as linear amortization.
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 periods.
CUMIPMT_ADD Returns the total interest paid on a loan in specified periods.
CUMPRINC Returns the total capital repaid on a loan in specified periods.
CUMPRINC_ADD Returns the total capital repaid on a loan in specified periods.
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.
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 interest paid in a period for a fixed rate loan.
IRR 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).
ISPMT Returns the interest paid in a period for a fixed rate loan.
MIRR Calculates the modified internal rate of return of a series of investments.
NPER Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
NPV Returns the net present value of an investment given cash payments and a discount rate.
PMT Returns the payment per period for a fixed rate loan.
PPMT Returns the capital repaid in a period for a fixed rate loan.
PV Returns the present value of a stream of future payments with a final lump sum.
RATE Returns the constant interest rate per period of an annuity.
RRI Calculates the interest rate resulting from the profit (return) of an investment.
XIRR 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.
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 Calculates the allowance (discount) of a security as a percentage.
DURATION Calculates the number of periods required by an investment to attain the desired value.
DURATION_ADD Calculates the duration of a fixed interest security in years.
INTRATE Returns the equivalent annual interest rate for an item bought at one price and sold at another.
MDURATION Calculates the modified Macauley duration of a fixed interest security in years.
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-bearing security.
PRICEDISC Calculates the price of a non-interest-bearing security.
PRICEMAT Calculates the price of a security that pays interest at maturity.
RECEIVED Calculates the amount received that is paid for a fixed-interest security at a given point in time.
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 of a security.
YIELDDISC Calculates the annual yield of a non-interest-bearing security.
YIELDMAT Calculates the annual yield of a security, the interest of which is paid on the date of 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

Derivation of Financial Formulas

Financial date systems

Functions listed by category

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_Financial_functions&oldid=89785"
Personal tools