pDuration

1 Description
2 Syntax
3 Parameters
4 Example
5 See Also

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

the present value of the investment

the desired future value of the investment

Example

pDuration(0.025,1000,1500)= // returns 16.42 years

pDuration

Contents

Description

Syntax

Parameters

Example

See Also