RRI(nper, pv, fv)

Returns the equivalent interest rate for the growth of an investment.

nperThe total number of periods.
pvThe present value of the investment.
fvThe future value of the investment.

Remarks

* Added in Excel 2013.
* The "nper" is the number of compounding periods.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=RRI(4,9000,10000) = 2.67%
2=RRI(10,50,100) = 7.18%
3=RRI(PDURATION(5%,100,200),100,200) = 5.00%

1 - What is the equivalent interest rate when an investment increases from £9,000 to £10,000 over 4 periods.
2 - What is the equivalent interest rate when an investment increases from £50 to £100 over 10 periods.
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top