Returns the number of periods required for an investment to reach a specified value.
Синтаксис
PDURATION(rate, pv, fv)Аргументы
rateобязательно
The interest rate for each period.
pvобязательно
The present value of the investment.
fvобязательно
The desired future value of the investment.
The PDURATION function calculates the number of periods needed for an investment to reach a target future value at a constant interest rate. It is useful for financial planning when you need to determine how long it will take for an initial investment to grow to a specific amount.
=PDURATION(0.05, 1000, 2000)→14.2067Calculates the number of periods required for 1000 to grow to 2000 at a 5% interest rate.
Identify input values
Determine the interest rate, present value, and target future value for your investment.
Enter the formula
Type =PDURATION(rate, pv, fv) into a cell, replacing the arguments with your specific values or cell references.
If the rate is 0, the function will return a #NUM! error because the investment value will never change.