Financial Functions
Time-value-of-money functions have been implemented to calculate n/i/pv/pmt/fv values, given the other 4.
Examples:
N = TVM_N(i,pv,pmt,fv)
I = TVM_I(n,pv,pmt,fv)
PV = TVM_PV(n,i,pmt,fv)
PMT = TVM_PMT(n,i,pv,fv)
FV = TVM_FV(n,i,pv,pmt)
where:
N = number of payments
I = Interest rate
PV = present value
PMT = amount of payment
FV = future value
Notes:
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
It is assumed that payments are made at the end of each period.