pDuration
Contents
Description
Minimum Origin Version Required: 2019 SR0
This function is used to calculate the number of periods required by an investment to reach a specified value, given the interest rate per period rate, the present value Pv and the future value of the investment Fv.
/math-2622b375a39f667a1e4d2a3ef7f785c9.png "pDuration = \frac{{\log \left( {fv} \right) - \log \left( {pv} \right)}}{{\log \left( {1 + rate} \right)}}\")
Syntax
double pDuration( double rate, double pv, double fv)
Parameters
rate
- the interest rate per period
pv
- the present value of the investment
fv
- the desired future value of the investment
Example
pDuration(0.025,1000,1500)= // returns 16.42 years