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.|
|* Added in Excel 2013.|
* For the Microsoft documentation refer to support.office.com
|Example 1 - How many periods are needed for an investment of £9,000 to reach £10,000 when you have an interest rate of 3%.|
Example 2 - How many periods are needed for an investment of £50 to reach £100 when you have an interest rate of 5%.
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top