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.