Documentation/How Tos/Calc: Financial functions
From Apache OpenOffice Wiki
< Documentation | How Tos
- Financial Functions
Depreciation
Payment Streams, Annuities, Loans
Securities
Coupons
Miscellaneous
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