PDURATION function

The PDURATION function returns the number of periods for an investment to reach a specific value at a given rate. Mathematically, PDURATION = (log(futureValue) - log (currentValue))/(log(1 + rate)).

Parts of a PDURATION function

PDURATION(rate, present_value, future_value)

Part Description
rate Required. The rate at which the investment grows each period.
present_valuepresent_value Required. The investment's current value.
future_valuefuture_value Required. The investment's desired future value.

Notes

All values must be positive and greater than 0.

Examples

PDURATION FORMULA
1.817059493 =PDURATION(0.25, 10, 15)
3.600511394 =PDURATION(0.75, 2, 15)

Related functions

  • RRI: The RRI function returns the interest rate needed for an investment to reach a specific value within a given number of periods.
Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
true
false
true
true
35
false
false