# Math, Financial

Description

Financial Math Functions allow you to calculate the "Time-value-of-money".

Version Ref: 5.0

Formulas Description

N = TVM_N(i,pv,pmt,fv) | Calculates the number of compounding periods.
I = TVM_I(n,pv,pmt,fv) | Calculates the value of interest.
PV = TVM_PV(n,i,pmt,fv) | Calculates the present value.
PMT = TVM_PMT(n,i,pv,fv) | Calculates the payment value.
FV = TVM_FV(n,i,pv,pmt) | Calculates the future value.

The formula used is:

100 ( 1 - sppv ) * pmt * ---- + pv = -fv * sppv i where "sppv" is the single payment present value: i -n sppv = ( 1 + ----- ) 100

Note: It is assumed that payments are made at the end of each period.