Module financial 

Financial formula functions: FV, PV, NPV, IRR, PMT, IPMT, PPMT, RATE, NPER, DB, DDB, SLN, SYD, EFFECT, NOMINAL, DOLLARDE, DOLLARFR, CUMPRINC, CUMIPMT, XNPV, XIRR.

Functions

fn_cumipmt

CUMIPMT(rate, nper, pv, start_period, end_period, type)

fn_cumprinc

CUMPRINC(rate, nper, pv, start_period, end_period, type)

fn_db

DB(cost, salvage, life, period, [month])

fn_ddb

DDB(cost, salvage, life, period, [factor])

fn_dollarde

DOLLARDE(fractional_dollar, fraction)

fn_dollarfr

DOLLARFR(decimal_dollar, fraction)

fn_effect

EFFECT(nominal_rate, npery)

fn_fv

FV(rate, nper, pmt, [pv], [type])

fn_ipmt

IPMT(rate, per, nper, pv, [fv], [type])

fn_irr

IRR(values, [guess])

fn_nominal

NOMINAL(effect_rate, npery)

fn_nper

NPER(rate, pmt, pv, [fv], [type])

fn_npv

NPV(rate, value1, [value2], …)

fn_pmt

PMT(rate, nper, pv, [fv], [type])

fn_ppmt

PPMT(rate, per, nper, pv, [fv], [type])

fn_pv

PV(rate, nper, pmt, [fv], [type])

fn_rate

RATE(nper, pmt, pv, [fv], [type], [guess])

fn_sln

SLN(cost, salvage, life)

fn_syd

SYD(cost, salvage, life, per)

fn_xirr

XIRR(values, dates, [guess])

fn_xnpv

XNPV(rate, values, dates)