PDURATION function
Summary
Returns the number of periods required by an investment to reach a specified value
Syntax
PDURATION(rate, pv, fv)
The PDURATION function syntax has the following arguments.
• Rate Required. Rate is the interest rate per period.
• Pv Required. Pv is the present value of the investment.
• Fv Required. Fv is the desired future value of the investment.
PDURATION uses the following equation, where specifiedValue is equal to fv, and currentValue is equal to pv:
• Rate Required. Rate is the interest rate per period.
• Pv Required. Pv is the present value of the investment.
• Fv Required. Fv is the desired future value of the investment.
PDURATION uses the following equation, where specifiedValue is equal to fv, and currentValue is equal to pv:
Example
=PDURATION(2.5%,2000,2200)
=PDURATION(0.025/12,1000,1200)
=PDURATION(0.025/12,1000,1200)