PDURATION(rate, pv, fv)

Returns the number of periods required by an investment to reach a specified value.

rateThe interest rate per period.
pvThe present value of the investment.
fvThe future value of the investment.

Remarks

* Added in Excel 2013.
* For the Microsoft documentation refer to support.office.com

 A
1=PDURATION(3%,9000,10000) = 3.56
2=PDURATION(5%,50,100) = 14.21
3=PDURATION(RRI(12,100,200),100,200) = 12.00

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%.
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top