INVESTMENT_PDURATION

Periods required for investment to grow to given value

Description

Calculates how many periods an investment needs to grow to a given value at a given rate.

Function signature

INVESTMENT_PDURATION(rate: Number, presentvalue: Number, futurevalue: Number) => Number

Parameter

Description

Rate

The rate at which the investment grows each period

Present value

The investment's current value.

Future value

The investment's desired future value.

Examples

Formula

Return value

INVESTMENT_PDURATION(0.1, 10, 20)

7.272540897

INVESTMENT_PDURATION(1, 10, 20)

1

INVESTMENT_PDURATION(1, 10, 30)

1.584962501

INVESTMENT_PDURATION(1, 20, 20)

0