Annual Rate of Interest for Savings (RRI)
Syntax: RRI(Time; Value; Future)
What should the interest rate be if you want your investment of $100,000 to turn into a nice, round $1,000,000 over 25 years?
=RRI(25; 100,000; 1,000,000)
The answer is 9.65%.
Figure 8-15. Sample result of the RRI function
Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.