Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
RRI
RRI calculates the per-period growth rate needed for an investment to grow from a present value to a future value in a given number of periods, essentially the CAGR formula. Use it to benchmark investment performance or compare growth across different assets.
Excel
=RRI(5,1000,1500)Google Sheets
=RRI(5,1000,1500)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Periods | PV | FV |
| 5 | 1000 | 1500 |
| 3 | 2000 | 2800 |
| 10 | 5000 | 9000 |
| 7 | 3000 | 6000 |
=RRI(5,1000,1500)→0.0844717712
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Provide the number of periods (e.g. years), the starting present value, and the ending future value.
- 2Enter =RRI(nper, pv, fv) to get the per-period growth rate.
- 3Format the result as a percentage to display the CAGR.
Need a version for your data?
Try: “What CAGR did my investment achieve if it grew from $1,000 to $1,500 over 5 years?”