Financial functions

Simple financial functions

method	description
fv(rate, nperopen in new window, pmtopen in new window, pvopen 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.