CAGR in Excel with RRI: Calculate Annual Growth Rate

How-to basics · Updated November 22, 2026

To calculate compound annual growth rate (CAGR) in Excel, enter the number of periods, starting value, and ending value in cells, then use Excel’s RRI function. For example, if a value grows from $10,000 to $14,641 over four years, RRI returns 10% per year. You’ll need the two values and the number of periods between them; the calculation assumes a steady equivalent annual rate, not that growth was actually identical each year.

What You’ll Need

  • Microsoft Excel for Microsoft 365 on Windows. The RRI function is also available in current Excel for Mac and Excel for the web; the formula is the same.
  • A beginning value and an ending value, entered as numbers, plus the number of periods between them.
  • Consistent units and a clear definition of a period. For an annual CAGR, use the number of years between the values.

Step-by-Step

  1. Set up the inputs. In a blank worksheet, type Beginning value in A2, Years in A3, and Ending value in A4. Enter 10000 in B2, 4 in B3, and 14641 in B4 for the example. Keep the beginning and ending values in the same units, such as dollars, units sold, or index points. Avoid typing a currency symbol directly into a cell if Excel would then treat the entry as text; apply a number or currency format instead.
  2. Check what counts as a period. RRI calculates a rate for each period you specify. If your values are recorded at the start and end of four full years, use 4. If you have ten yearly observations from year one through year ten, there are nine intervals between the first and last observation, not ten. The period count is the number of growth intervals, rather than the number of rows in your data.
  3. Choose where the result will go. Click B5, or another empty cell, and label A5 CAGR so it is clear what the returned rate means. You can place the calculation beside the inputs or on a separate summary sheet, as long as the cell references point to the correct values.
  4. Enter the RRI formula. With the beginning value in B2, the period count in B3, and the ending value in B4, enter =RRI(B3,B2,B4) in B5. RRI uses the arguments in this order: number of periods, present value (the starting amount), and future value (the ending amount). In the example, the result is 0.1, which is the decimal representation of 10%.
  5. Display the result as a percentage. Select B5, then choose Home > Number > Percent Style. Excel will display 10% rather than 0.1. Use the increase or decrease decimal buttons in the Number group if you want more precision, such as 10.00%. Percentage formatting changes how the result is shown, not the value used in later calculations.
  6. Check the arithmetic independently. A 10% annual rate applied four times turns $10,000 into $14,641: 10,000 × 1.1 × 1.1 × 1.1 × 1.1 = 14,641. This confirms the example’s result. In a real worksheet, compare the displayed rate with the scale of the change; a large increase over a short period should generally produce a larger CAGR than the same increase over a long period.
  7. Use the same setup for your own data. Replace the example values with your own beginning amount, ending amount, and period count. Keep the formula in B5 and update the referenced cells, or copy the formula to another row and adjust the references. When copying, verify that Excel has shifted the references to the intended cells rather than to a heading or unrelated value.

RRI is useful because it gives one annualized rate that links the starting and ending values over the stated period. It does not reveal the path between those values. If a balance rose sharply and then fell, the CAGR still summarizes only the endpoints and elapsed periods; it is not an average of every year’s reported percentage change.

Common Mistakes

  • Counting observations instead of intervals. Four annual data points contain three intervals. Using four as the period count in that case will understate or otherwise distort the annualized rate. Count the steps from the first value to the last.
  • Reversing the arguments. RRI expects the period count first, starting value second, and ending value third. Putting the starting value in the first argument can produce an error or an unintended result. Check the cell order in the formula before interpreting the answer.
  • Mixing time units. If one value is from January and the other is from July four years later, simply entering four treats the gap as exactly four annual periods. Decide whether that approximation is suitable. For exact date-based annualization, calculate the elapsed time consistently rather than silently treating partial years as full years.
  • Using different units or currencies. Comparing 500 kilograms with 800 pounds, or amounts in different currencies without conversion, does not describe growth on a consistent basis. Convert both values to a common unit and currency before calculating.
  • Assuming a positive result is guaranteed. A decline from a positive starting amount to a smaller positive ending amount produces a negative CAGR. That is meaningful: it represents an equivalent annual decrease. A negative rate is not automatically a formula error.
  • Expecting the annualized rate to match each year. CAGR is a smoothed equivalent rate. It does not say that the value actually increased by that exact percentage in every period, and it should not be presented as a forecast or a guarantee.

Tips

  • Make the period unit explicit. Rename a heading to Years, Quarters, or Months, as appropriate. RRI returns a rate per period, so a result based on 48 monthly periods is a monthly rate, not an annual one. Do not label it as annual CAGR without converting the period basis appropriately.
  • Keep inputs numeric. Use cell formatting to show currency, commas, or units. A number stored as text can lead to a value error, and an entry such as “$10,000 start” is not a numeric value Excel can reliably use as an input.
  • Show useful precision without overstating certainty. Two decimal places may help compare rates, but a displayed 10.00% does not mean the underlying data is accurate to one-hundredth of a percentage point. Match precision to the quality of the source values.
  • Keep the source values visible. A result is easier to audit when the start, end, period count, and CAGR appear together. Add a note describing the measurement dates and whether the values are nominal, inflation-adjusted, or otherwise transformed.
  • Use a comparison table carefully. When comparing several products, regions, or time periods, use the same period definition and consistent inputs for every row. A rate over three years is not directly comparable to one over six months unless both are converted to a common basis.

Troubleshooting

If Excel shows #NUM!: Check that the period count is greater than zero and that the starting and ending values create a valid positive ratio. For ordinary growth calculations, enter positive numeric values for both amounts. Opposite signs make the ratio negative, which does not produce a real-valued CAGR for the usual interpretation. If the series crosses zero, a standard CAGR may not be appropriate; report the values and change directly instead.

If Excel shows #DIV/0! or another error: Make sure the starting value is not zero, and verify that the referenced cells contain numbers rather than blanks or text. Also check for misplaced decimal points or values imported with a leading apostrophe. Click a referenced cell and inspect the formula bar; re-enter the value as a number if needed.

If the answer seems far too high or low: Recheck the number of intervals and the argument order. Confirm that B2 is the beginning value, B3 is the period count, and B4 is the ending value in the example layout. Check that you have not used months as if they were years or entered a percentage such as 10% where the intended amount was 10,000. Then compare the result with the endpoint relationship: compounding the result for the specified number of periods should reproduce the ending value approximately.

If you need to verify the function with the standard CAGR expression: With the beginning value in B2, the period count in B3, and the ending value in B4, enter =(B4/B2)^(1/B3)-1 in another cell. It returns the same decimal rate as RRI for valid inputs; for the worked example, it returns 0.1, or 10% when formatted as a percentage. If the two results differ, inspect the cell references, the number of periods, and whether one result has only been formatted differently.

If the formula is rejected as you type: Excel normally uses commas between function arguments in the English-language setup shown here. Some regional settings use semicolons instead. If Excel replaces or flags the commas, use the list separator configured for your system. The function name and argument order remain the same. On Mac or Excel for the web, the formula itself is also the same, though regional settings can affect separators and some interface labels may differ.

Frequently Asked Questions

What does RRI mean in Excel?
RRI is Excel’s function for returning the equivalent interest rate for growth from a present value to a future value over a specified number of periods. When those periods are years, that rate is the CAGR.

Is RRI the same as CAGR?
For a beginning value, ending value, and period count, RRI calculates the compound rate that connects those endpoints. It is commonly used to calculate CAGR when the period count represents years. If the periods are months or quarters, the result is per month or per quarter, not automatically annualized.

Can I calculate CAGR when the ending value is lower?
Yes. If both values are positive and the ending value is lower than the starting value, RRI returns a negative rate. Format it as a percentage to show the annualized decline.

Can RRI use dates instead of a period count?
No. RRI takes a number of periods, not start and end dates. Work out the elapsed periods from your dates and supply that count. For incomplete years, decide on a consistent day-count or year-fraction convention that fits your analysis; RRI will not choose one automatically.

Why does the result show as 0.1 instead of 10%?
The numeric result is 0.1, which is equal to 10%. Select the result cell and apply Home > Number > Percent Style. This changes the display format while preserving the underlying calculation.

Does CAGR tell me what will happen next?
No. It is a summary of historical endpoints and a time interval, not a prediction. Actual values can fluctuate, and future growth can differ from the historical annualized rate.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.