PDURATION
Returns the number of periods required by an investment to reach a specified value
Syntax
PDURATION(rate, pv, fv)
Parameters
- rate: Required. The interest rate per period
- pv: Required. The present value of the investment
- fv: Required. The desired future value of the investment
Example
=PDURATION(0.025/12, 1000, 1200)