Financial Functions
- 4 minutes to read
This document describes financial functions supported by the non-visual Spreadsheet component.
| Name | Description | Syntax |
|---|---|---|
| ACCRINTM | Returns the accrued interest for a security that pays interest at maturity. | ACCRINTM(issue, settlement, rate, par, [basis]) |
| COUPDAYBS | Returns the number of days from the beginning of a coupon period until its settlement date. | COUPDAYBS(settlement, maturity, frequency, [basis]) |
| COUPNCD | Returns the next coupon date after the settlement date. | COUPNCD(settlement, maturity, frequency, [basis]) |
| COUPNUM | Returns the number of coupons payable between the settlement date and maturity date. | COUPNUM(settlement, maturity, frequency, [basis]) |
| COUPPCD | Returns the previous coupon date before the settlement date. | COUPPCD(settlement, maturity, frequency, [basis]) |
| CUMIPMT | Returns the cumulative interest paid on a loan between two periods. | CUMIPMT(rate, nper, pv, start_period, end_period, type) |
| CUMPRINC | Returns the cumulative principal paid on a loan between two periods. | CUMPRINC(rate, nper, pv, start_period, end_period, type) |
| DB | Returns the depreciation of an asset for a specified period using the fixed-declining balance method. | DB(cost, salvage, life, period, [month]) |
| DDB | Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify. | DDB(cost, salvage, life, period, [factor]) |
| DISC | Returns the discount rate for a security. | DISC(settlement, maturity, pr, redemption, [basis]) |
| DOLLARDE | Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number. | DOLLARDE(fractional_dollar, fraction) |
| DOLLARFR | Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction. | DOLLARFR(decimal_dollar, fraction) |
| FVSCHEDULE | Returns the future value of an initial principal after applying a series of compound interest rates. | FVSCHEDULE(principal, schedule) |
| EFFECT | Returns the effective annual interest rate. | EFFECT(nominal_rate, npery) |
| FV | Calculates the future value of an investment based on a constant interest rate. | FV(rate,nper,pmt,[pv],[type]) |
| INTRATE | Returns the interest rate for a fully invested security. | INTRATE(settlement, maturity, investment, redemption, [basis]) |
| IPMT | Returns the interest payment for a given period for an investment based on periodic constant payments and a constant interest rate. | IPMT(rate, per, nper, pv, [fv], [type]) |
| IRR | Calculates the internal rate of return for a series of cash flows. | IRR(values, [guess]) |
| ISPMT | Calculates the interest paid during a specific period of a loan (or investment). | ISPMT(rate, per, nper, pv) |
| MIRR | Returns the modified internal rate of return for a series of periodic cash flows. | MIRR(values, finance_rate, reinvest_rate) |
| NOMINAL | Returns the annual nominal interest rate. | NOMINAL(effect_rate, npery) |
| NPER | Returns the number of periods for an investment based on periodic constant payments and a constant interest rate. | NPER(rate,pmt,pv,[fv],[type]) |
| NPV | Calculates the net present value of an investment based on a discount rate and a series of future payments and income. | NPV(rate,value1,[value2],…) |
| PDURATION | Returns the number of periods required by an investment to reach a specified value. | PDURATION(rate, pv, fv) |
| PMT | Calculates the payment for a loan based on constant payments and a constant interest rate. | PMT(rate, nper, pv, [fv], [type]) |
| PPMT | Returns the payment on the principal for a given period for an investment based on periodic constant payments and a constant interest rate. | PPMT(rate, per, nper, pv, [fv], [type]) |
| PRICE | Returns the price per $100 face value of a security that pays periodic interest. | PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis]) |
| PRICEDISC | Returns the price per $100 face value of a discounted security. | PRICEDISC(settlement, maturity, discount, redemption, [basis]) |
| PV | Calculates the present value of a loan or an investment based on a constant interest rate. | PV(rate, nper, pmt, [fv], [type]) |
| RATE | Returns the interest rate per period of an annuity. | RATE(nper, pmt, pv, [fv], [type], [guess]) |
| RECEIVED | Returns the amount received at maturity for a fully invested security. | RECEIVED(settlement, maturity, investment, discount, [basis]) |
| RRI | Returns an equivalent interest rate for the growth of an investment. | RRI(nper, pv, fv) |
| SLN | Returns the straight-line depreciation of an asset for one period. | SLN(cost, salvage, life) |
| SYD | Returns the sum-of-years’ digits depreciation of an asset for a specified period. | SYD(cost, salvage, life, per) |
| TBILLEQ | Returns the bond-equivalent yield for a Treasury bill. | TBILLEQ(settlement, maturity, discount) |
| TBILLPRICE | Returns the price per $100 face value for a Treasury bill. | TBILLPRICE(settlement, maturity, discount) |
| TBILLYIELD | Returns the yield for a Treasury bill. | TBILLYIELD(settlement, maturity, pr) |
| VDB | Returns the depreciation of an asset for a specified or partial period using a declining balance method. | VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch]). |
| XIRR | Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. | XIRR(values, dates, [guess]) |
| XNPV | Returns the net present value for a schedule of cash flows that is not necessarily periodic. | XNPV(rate, values, dates) |
| YIELD | Returns the yield on a security that pays periodic interest. | YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis]) |
| YIELDDISC | Returns the annual yield for a discounted security. | YIELDDISC(settlement, maturity, pr, redemption, [basis]) |
See Also