Table of Contents

Previous topic


Next topic


Financial functions

Simple financial functions

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.


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.