What is PDURATION function in Excel?
PDURATION function is one of the Financial functions in Microsoft Excel that returns the number of periods required by an investment to reach a specified value.
Syntax of PDURATION function
PDURATION(rate, pv, fv)
The PDURATION function syntax has the following arguments.
- Rate: Rate is the interest rate per period.
- Pv: Pv is the present value of the investment.
- Fv : 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:
PDURATION formula explanation
- PDURATION requires that all arguments are positive values.
- If argument values are not valid, PDURATION returns the #NUM! error value.
- If arguments are not using valid data types, PDURATION returns the #VALUE! error value.
Example of PDURATION function
Steps to follow:
1. Open a new Excel worksheet.
2. Copy data in the following table below and paste it in cell A1
Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.
You can adjust the column widths to see all the data, if need be.
|=PDURATION(2.5%,2000,2200)||The number of years required for an investment of $2,000, earning 2.5% annually, to reach $2,200 (3.86 years).||3.86|
|=PDURATION(0.025/12,1000,1200)||The number of months required for an investment of $1,000, earning 2.5% annually, to reach $1,200 (87.6 months).||87.6|