This function returns the number of periods required by an investment to reach specified value.
PDURATION(rate,pv,fv)
This function has the following arguments:
Argument | Description |
---|---|
rate | Value of interest rate per period |
pv | Present value of the investment |
fv | Desired future value of the investment |
All the arguments of this function has positive values.
All the passed arguments should be positive values.
Accepts numeric data. Returns numeric data.
PDURATION(0.025/12,1000,1200) gives the result 87.6