API Documentation#

fv(...)

Compute the future value.

ipmt(...)

Compute the interest portion of a payment.

irr(...)

Return the Internal Rate of Return (IRR).

mirr(...)

Return the Modified Internal Rate of Return (MIRR).

nper(...)

Compute the number of periodic payments.

npv(...)

Return the NPV (Net Present Value) of a cash flow series.

pmt(...)

Compute the payment against loan principal plus interest.

ppmt(...)

Compute the payment against loan principal.

pv(...)

Compute the present value.

rate(nper, pmt, pv, fv[, when, guess, tol, ...])

Compute the rate of interest per period.