PDURATION(rate, pv, fv) |
Returns the number of periods required by an investment to reach a specified value. |
rate | The interest rate per period. |
pv | The present value of the investment. |
fv | The future value of the investment. |
Remarks |
* Added in Excel 2013. * For the Microsoft documentation refer to support.office.com |
|
1 - How many periods are needed for an investment of £9,000 to reach £10,000 when you have an interest rate of 3%. 2 - How many periods are needed for an investment of £50 to reach £100 when you have an interest rate of 5%. |
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top