RRI

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
* The RRI stands for Rate of Return on Investment.
* The "nper" is the number of compounding periods.
* You can use the FV function to return the future value of a series of equal cash flows at regular intervals.
* You can use the NPER function to return the number of periods for an investment.
* You can use the PDURATION function to return the number of periods required by an investment to reach a specified value.
* You can use the PV function to return the present value of a series of equal cash flows at regular intervals.
* You can use the RATE function to return the interest rate for a series of equal cash flows at regular intervals.
* This function was added in Excel 2013.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.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.
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top