Financial functions
The 55 financial functions in Sheets, with the usual names, arguments and results.
| Function | What it does | Syntax |
|---|---|---|
| ACCRINT | Accrued interest of a periodic-interest bond | ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) |
| ACCRINTM | Accrued interest paid at maturity | ACCRINTM(issue, settlement, rate, par, [basis]) |
| AMORDEGRC | French degressive depreciation of a period | AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis]) |
| AMORLINC | French linear depreciation of a period | AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis]) |
| COUPDAYBS | Days from coupon period start to settlement | COUPDAYBS(settlement, maturity, frequency, [basis]) |
| COUPDAYS | Days in the coupon period of settlement | COUPDAYS(settlement, maturity, frequency, [basis]) |
| COUPDAYSNC | Days from settlement to the next coupon | COUPDAYSNC(settlement, maturity, frequency, [basis]) |
| COUPNCD | Next coupon date after settlement | COUPNCD(settlement, maturity, frequency, [basis]) |
| COUPNUM | Coupons payable up to maturity | COUPNUM(settlement, maturity, frequency, [basis]) |
| COUPPCD | Previous coupon date before settlement | COUPPCD(settlement, maturity, frequency, [basis]) |
| CUMIPMT | Interest paid between two periods | CUMIPMT(rate, nper, pv, start_period, end_period, type) |
| CUMPRINC | Principal paid between two periods | CUMPRINC(rate, nper, pv, start_period, end_period, type) |
| DB | Fixed-declining balance depreciation | DB(cost, salvage, life, period, [month]) |
| DDB | Double-declining balance depreciation | DDB(cost, salvage, life, period, [factor]) |
| DISC | Discount rate of a security | DISC(settlement, maturity, pr, redemption, [basis]) |
| DOLLARDE | Fractional dollar price as a decimal | DOLLARDE(fractional_dollar, fraction) |
| DOLLARFR | Decimal dollar price as a fraction | DOLLARFR(decimal_dollar, fraction) |
| DURATION | Macaulay duration of a bond | DURATION(settlement, maturity, coupon, yld, frequency, [basis]) |
| EFFECT | Effective annual interest rate | EFFECT(nominal_rate, npery) |
| FV | Future value of an investment | FV(rate, nper, pmt, [pv], [type]) |
| FVSCHEDULE | Future value after a series of rates | FVSCHEDULE(principal, schedule) |
| INTRATE | Interest rate of a fully invested security | INTRATE(settlement, maturity, investment, redemption, [basis]) |
| IPMT | Interest part of a payment | IPMT(rate, per, nper, pv, [fv], [type]) |
| IRR | Internal rate of return of cash flows | IRR(values, [guess]) |
| ISPMT | Interest of a period, even principal payments | ISPMT(rate, per, nper, pv) |
| MDURATION | Modified duration of a bond | MDURATION(settlement, maturity, coupon, yld, frequency, [basis]) |
| MIRR | Modified internal rate of return | MIRR(values, finance_rate, reinvest_rate) |
| NOMINAL | Nominal annual interest rate | NOMINAL(effect_rate, npery) |
| NPER | Number of periods of an investment | NPER(rate, pmt, pv, [fv], [type]) |
| NPV | Net present value of periodic cash flows | NPV(rate, value1, [value2, ...]) |
| ODDFPRICE | Price of a bond with an odd first period | ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis]) |
| ODDFYIELD | Yield of a bond with an odd first period | ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis]) |
| ODDLPRICE | Price of a bond with an odd last period | ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis]) |
| ODDLYIELD | Yield of a bond with an odd last period | ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis]) |
| PDURATION | Periods for an investment to reach a value | PDURATION(rate, pv, fv) |
| PMTexample | Periodic payment of a loan or annuity | PMT(rate, nper, pv, [fv], [type]) |
| PPMT | Principal part of a payment | PPMT(rate, per, nper, pv, [fv], [type]) |
| PRICE | Price per $100 of a periodic-interest bond | PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis]) |
| PRICEDISC | Price per $100 of a discounted security | PRICEDISC(settlement, maturity, discount, redemption, [basis]) |
| PRICEMAT | Price per $100, interest paid at maturity | PRICEMAT(settlement, maturity, issue, rate, yld, [basis]) |
| PV | Present value of an investment | PV(rate, nper, pmt, [fv], [type]) |
| RATE | Interest rate per period of an annuity | RATE(nper, pmt, pv, [fv], [type], [guess]) |
| RECEIVED | Amount received at maturity | RECEIVED(settlement, maturity, investment, discount, [basis]) |
| RRI | Equivalent interest rate for growth | RRI(nper, pv, fv) |
| SLN | Straight-line depreciation per period | SLN(cost, salvage, life) |
| SYD | Sum-of-years' digits depreciation | SYD(cost, salvage, life, per) |
| TBILLEQ | Bond-equivalent yield of a Treasury bill | TBILLEQ(settlement, maturity, discount) |
| TBILLPRICE | Price per $100 of a Treasury bill | TBILLPRICE(settlement, maturity, discount) |
| TBILLYIELD | Yield of a Treasury bill | TBILLYIELD(settlement, maturity, pr) |
| VDB | Declining balance depreciation over periods | VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch]) |
| XIRR | Internal rate of return of dated cash flows | XIRR(values, dates, [guess]) |
| XNPV | Net present value of dated cash flows | XNPV(rate, values, dates) |
| YIELD | Yield of a periodic-interest bond | YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis]) |
| YIELDDISC | Annual yield of a discounted security | YIELDDISC(settlement, maturity, pr, redemption, [basis]) |
| YIELDMAT | Annual yield, interest paid at maturity | YIELDMAT(settlement, maturity, issue, rate, pr, [basis]) |