| Function | What It Returns |
| DDB(cost, salvage, life, period, factor) | The depreciation of an asset over a specified period, using the doubledeclining balance method. |
| FV(rate, nper, pmt, pv, type) | The future value of an investment or loan. |
| IPmt(rate, per, nper, pv, fv, type) | The interest payment for a specified period of a loan. |
| IRR(values, guess) | The internal rate of return for a series of cash flows. |
| MIRR(values, finance_rate, reinvest_rate) | The modified internal rate of return for a series of periodic cash flows. |
| NPer(rate, pmt, pv, fv, type) | The number of periods for an investment or loan. |
| NPV(rate, value1, value2...) | The net present value of an investment based on a series of cash flows and a discount rate. |
| Pmt(rate, nper, pv, fv, type) | The periodic payment for a loan or investment. |
| PPmt(rate, per, nper, pv, fv, type) | The principal payment for a specified period of a loan. |
| PV(rate, nper, pmt, fv, type) | The present value of an investment. |
| Rate(nper, pmt, pv, fv, type, guess) | The periodic interest rate for a loan or investment. |
| SLN(cost, salvage, life) | The straight-line depreciation of an asset over one period. |
| SYD(cost, salvage, life, period) | The sum-of-years digits depreciation of an asset over a specified period. |
