fv (rate, nper, pmt, pv[, when]) |
Compute the future value. |
pv (rate, nper, pmt[, fv, when]) |
Compute the present value. |
npv (rate, values) |
Returns the NPV (Net Present Value) of a cash flow series. |
pmt (rate, nper, pv[, fv, when]) |
Compute the payment against loan principal plus interest. |
ppmt (rate, per, nper, pv[, fv, when]) |
Compute the payment against loan principal. |
ipmt (rate, per, nper, pv[, fv, when]) |
Compute the interest portion of a payment. |
irr (values) |
Return the Internal Rate of Return (IRR). |
mirr (values, finance_rate, reinvest_rate) |
Modified internal rate of return. |
nper (rate, pmt, pv[, fv, when]) |
Compute the number of periodic payments. |
rate (nper, pmt, pv, fv[, when, guess, tol, …]) |
Compute the rate of interest per period. |