Google Sheets
RRI function in Google Sheets
Returns the interest rate needed for an investment to reach a specific value within a given number of periods. .
=RRI(number_of_periods, present_value, future_value)RRI syntax and parameters
Three arguments, three required.
- number_of_periodsnumberRequired
- present_valuenumberRequired
- future_valuenumberRequired
RRI examples
Formulas you'll actually reuse.
The yearly rate that doubles $10,000 in 10 years — a CAGR:
=RRI(10, 10000, 20000)Result
0.0718Compound annual growth of revenue from B2 to C2 over five years:
=RRI(5, B2, C2)Result
0.1247
RRI in Excel
Same name — your formula ports as-is.
Try RRI in the playground
Edit the example — nothing to install.
Preloaded with the RRI formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- ACCRINTCalculates the accrued interest of a security that has periodic payments.FinancialExcel
- ACCRINTMCalculates the accrued interest of a security that pays interest at maturity.FinancialExcel
- AMORLINCReturns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.FinancialExcel
- COUPDAYBSCalculates the number of days from the first coupon, or interest payment, until settlement.FinancialExcel
- COUPDAYSCalculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.FinancialExcel
- COUPDAYSNCCalculates the number of days from the settlement date until the next coupon, or interest payment.FinancialExcel