Overview

fv(rate, nper, pmt, pv[, when])

Compute the future value.

pmt(rate, nper, pv[, fv, when])

Compute the payment against loan principal plus interest.

nper(rate, pmt, pv[, fv, when])

Compute the number of periodic payments.

ipmt(rate, per, nper, pv[, fv, when])

Compute the interest portion of a payment.

ppmt(rate, per, nper, pv[, fv, when])

Compute the payment against loan principal.

pv(rate, nper, pmt[, fv, when])

Compute the present value.

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

Compute the rate of interest per period.

irr(values[, guess, tol, maxiter])

Return the Internal Rate of Return (IRR).

npv(rate, values)

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

mirr(values, finance_rate, reinvest_rate)

Modified internal rate of return.

depreciate(cost, salvage, life)

Calculate the straight-line depreciation of an asset over time.

digits(cost, salvage_value, useful_life)

Compute the depreciation for an asset using the sum-of-years-digits method.

decline(cost, salvage_value, useful_life, rate)

Compute the accumulated depreciation for an asset using the declining balance method.

double(cost, salvage_value, useful_life, rate)

Compute the depreciation for an asset using the double declining balance method.

units(cost, salvage, ...)

Calculate the units-of-production depreciation and book value at the end of year t.