Returns the interest rate needed for an investment to reach a specific value within a given number of periods..
81% OFF online library of tutorials for mastering Google Sheets
RRI()
Description
How To Use in Sheets
RRI(number_of_periods, present_value, future_value)
External Links
Google Sheets RRI Function | Calculate CAGR (Compound Annual Growth Rate) | Google Sheets Functions
Use the Google Sheets RRI function to calculate the Compound Annual Growth Rate (CAGR) of an investment over a time frame. The RRI function returns the average rate of return of an investment. CAGR requires that the returns are reinvested and interest is compounded once a year.
0Better Sheets Tutorials
No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.