financial functions
interest, cash flow, depreciation and valuation.
| function | signature | what it does | tests |
|---|---|---|---|
| ACCRINT | ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) | accrued interest for a security paying periodic interest | — |
| ACCRINTM | ACCRINTM(issue, settlement, rate, [par], [basis]) | accrued interest for a security paying at maturity | — |
| AMORDEGRC | AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis]) | depreciation per period, French accounting, degressive | — |
| AMORLINC | AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis]) | depreciation per period, French accounting, linear | — |
| COUPDAYBS | COUPDAYBS(settlement, maturity, frequency, [basis]) | days from coupon period start to settlement | — |
| COUPDAYS | COUPDAYS(settlement, maturity, frequency, [basis]) | days in the coupon period containing settlement | — |
| COUPDAYSNC | COUPDAYSNC(settlement, maturity, frequency, [basis]) | days from settlement to the next coupon date | — |
| COUPNCD | COUPNCD(settlement, maturity, frequency, [basis]) | next coupon date after settlement | — |
| COUPNUM | COUPNUM(settlement, maturity, frequency, [basis]) | number of coupons between settlement and maturity | — |
| COUPPCD | COUPPCD(settlement, maturity, frequency, [basis]) | previous coupon date before settlement | — |
| CUMIPMT | CUMIPMT(rate, nper, pv, start_period, end_period, type) | returns cumulative interest paid on loan | — |
| CUMPRINC | CUMPRINC(rate, nper, pv, start_period, end_period, type) | returns cumulative principal paid on loan | — |
| DB | DB(cost, salvage, life, period, [month]) | returns fixed-declining balance depreciation | — |
| DDB | DDB(cost, salvage, life, period, [factor]) | returns double-declining balance depreciation | — |
| DISC | DISC(settlement, maturity, pr, redemption, [basis]) | discount rate of a security | — |
| DOLLARDE | DOLLARDE(fractional_dollar, fraction) | converts fractional dollar to decimal | — |
| DOLLARFR | DOLLARFR(decimal_dollar, fraction) | converts decimal dollar to fractional | — |
| DURATION | DURATION(settlement, maturity, coupon, yld, frequency, [basis]) | returns the Macaulay duration of a security | — |
| EFFECT | EFFECT(nominal_rate, npery) | returns effective annual interest rate | — |
| FV | FV(rate, nper, pmt, [pv], [type]) | returns future value of an investment | — |
| FVSCHEDULE | FVSCHEDULE(principal, schedule) | future value under a schedule of compound rates | — |
| INTRATE | INTRATE(settlement, maturity, investment, redemption, [basis]) | interest rate of a fully invested security | — |
| IPMT | IPMT(rate, per, nper, pv, [fv], [type]) | returns interest payment for a period | — |
| IRR | IRR(values, [guess]) | calculates internal rate of return | 1 |
| ISPMT | ISPMT(rate, per, nper, pv) | returns interest for even-principal payment | — |
| MDURATION | MDURATION(settlement, maturity, coupon, yld, frequency, [basis]) | modified Macauley duration | — |
| MIRR | MIRR(values, finance_rate, reinvest_rate) | returns modified internal rate of return | — |
| NOMINAL | NOMINAL(effect_rate, npery) | returns annual nominal interest rate | — |
| NPER | NPER(rate, pmt, pv, [fv], [type]) | returns number of periods for investment | — |
| NPV | NPV(rate, value…) | calculates net present value of investment | 3 |
| ODDFPRICE | ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis]) | returns the price of a security with an odd first period | — |
| ODDFYIELD | ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis]) | yield of a security with an odd first period | — |
| ODDLPRICE | ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis]) | price of a security with an odd last period | — |
| ODDLYIELD | ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis]) | yield of a security with an odd last period | — |
| PDURATION | PDURATION(rate, pv, fv) | returns periods to reach target value | — |
| PMT | PMT(rate, nper, pv, [fv], [type]) | returns periodic payment for an annuity | 1 |
| PPMT | PPMT(rate, per, nper, pv, [fv], [type]) | returns principal payment for a period | — |
| PRICE | PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis]) | returns the price per $100 face value of a security paying periodic interest | 1 |
| PRICEDISC | PRICEDISC(settlement, maturity, discount, redemption, [basis]) | price of a discounted security | — |
| PRICEMAT | PRICEMAT(settlement, maturity, issue, rate, yld, [basis]) | price of a security paying interest at maturity | — |
| PV | PV(rate, nper, pmt, [fv], [type]) | returns present value of an investment | — |
| RATE | RATE(nper, pmt, pv, [fv], [type], [guess]) | returns interest rate per period | — |
| RECEIVED | RECEIVED(settlement, maturity, investment, discount, [basis]) | amount received at maturity for a fully invested security | — |
| RRI | RRI(nper, pv, fv) | returns equivalent interest rate for growth | — |
| SLN | SLN(cost, salvage, life) | returns straight-line depreciation per period | — |
| SYD | SYD(cost, salvage, life, per) | returns sum-of-years-digits depreciation | — |
| TBILLEQ | TBILLEQ(settlement, maturity, discount) | returns bond-equivalent yield for treasury bill | — |
| TBILLPRICE | TBILLPRICE(settlement, maturity, discount) | returns price per $100 for treasury bill | — |
| TBILLYIELD | TBILLYIELD(settlement, maturity, pr) | returns yield for a treasury bill | — |
| VDB | VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch]) | depreciation over a period, declining balance with switch | — |
| XIRR | XIRR(values, dates, [guess]) | returns internal rate for irregular cash flows | — |
| XNPV | XNPV(rate, values, dates) | returns net present value for irregular cash flows | — |
| YIELD | YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis]) | returns the yield of a security paying periodic interest | — |
| YIELDDISC | YIELDDISC(settlement, maturity, pr, redemption, [basis]) | annual yield of a discounted security | — |
| YIELDMAT | YIELDMAT(settlement, maturity, issue, rate, pr, [basis]) | annual yield of a security paying interest at maturity | — |