PDURATION function
The PDURATION function is one of the financial functions. It is used to calculate the number of periods required by an investment to reach a specified value.
Syntax
PDURATION(rate, pv, fv)
The PDURATION function has the following arguments:
| Argument | Description |
|---|---|
| rate | The interest rate per period. |
| pv | The present value of the investment. |
| fv | The desired future value of the investment. |
Notes
All arguments must be represented by positive numbers.
How to apply the PDURATION function.
Examples
The figure below displays the result returned by the PDURATION function.
