pDuration

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.

 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

See Also

Nominal, RRI, Effect,