- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Financial - PDURATION Function
Description
The PDURATION function returns the number of periods required by an investment to reach a specified value.
PDURATION uses the following equation −
$$PDURATION = \frac{log\left ( specifiedValue \right ) - log\left ( currentValue \right )}{log\left ( 1+rate \right )}$$
Where
- specifiedValue is equal to fv
- currentValue is equal to pv
Syntax
PDURATION (rate, pv, fv)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
Rate | Rate is the interest rate per period. | Required |
Pv | Pv is the present value of the investment. | Required |
Fv | Fv is the desired future value of the investment. | Required |
Notes
PDURATION requires that all arguments are positive values.
If any of the argument values are zero or negative, PDURATION returns the #NUM! error value.
If any of the arguments is not recognized as numeric value, PDURATION returns the #VALUE! error value.
Applicability
Excel 2013, Excel 2016
Example
advanced_excel_financial_functions.htm
Advertisements