Financial functions

Simple financial functions

fv(rate, nperopen in new windowpmtopen in new windowpvopen in new window[, when])Compute the future value.
pvopen in new window(rate, nper, pmt[, fv, when])Compute the present value.
npvopen in new window(rate, values)Returns the NPV (Net Present Value) of a cash flow series.
pmtopen in new window(rate, nper, pv[, fv, when])Compute the payment against loan principal plus interest.
ppmtopen in new window(rate, per, nper, pv[, fv, when])Compute the payment against loan principal.
ipmtopen in new window(rate, per, nper, pv[, fv, when])Compute the interest portion of a payment.
irropen in new window(values)Return the Internal Rate of Return (IRR).
mirropen in new window(values, finance_rate, reinvest_rate)Modified internal rate of return.
nperopen in new window(rate, pmt, pv[, fv, when])Compute the number of periodic payments.
rateopen in new window(nper, pmt, pv, fv[, when, guess, tol, …])Compute the rate of interest per period.