RRI(nper, pv, fv) |
Returns the equivalent interest rate for the growth of an investment. |
nper | The total number of periods. |
pv | The present value of the investment. |
fv | The 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.office.com |
|
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