Three practical ways to calculate CAGR in Excel
| Method | Best for | Example formula |
|---|---|---|
| Direct CAGR formula | Beginning value, ending value, fixed years | =(C2/B2)^(1/A2)-1 |
| RRI | Equivalent rate over a known number of periods | =RRI(A2,B2,C2) |
| XIRR | Actual dates and/or irregular dated cash flows | =XIRR(B2:B3,A2:A3) |
Method 1: use the direct CAGR formula
Suppose A2 contains the number of years, B2 contains the beginning value, and C2 contains the ending value. The direct Excel formula is:
With A2 = 4, B2 = 10000, and C2 = 16000, Excel returns approximately 0.12468265. Format the result cell as a percentage to display about 12.47%.
This method is transparent because the spreadsheet mirrors the mathematical definition directly. It is also easy to audit when another person needs to inspect the workbook.
Method 2: use Excel's RRI function
Microsoft documents RRI as returning the equivalent interest rate for growth given a number of periods, a present value, and a future value. For the same four-year example, use:
Or, when the values are stored in cells, use =RRI(A2,B2,C2). RRI is compact and makes the intent of the formula clear, but the period count still has to be correct. Four annual periods means four growth intervals, not five year labels.
RRI is especially convenient when your period is already expressed consistently. If you are feeding it monthly periods, for example, the returned rate is a per-period rate unless you transform it into an annual rate. For a CAGR calculation, keep the period definition aligned with years or explicitly annualize the result.
Method 3: use XIRR for exact dates
Microsoft recommends XIRR when calculating an annualized return from dated cash flows that are not necessarily periodic. XIRR expects cash flows and corresponding dates, with at least one negative and one positive value.
For a simple beginning-and-ending example, set up the sheet like this:
| Date | Cash flow |
|---|---|
| 2021-01-01 | -10000 |
| 2026-09-13 | 18000 |
Then use:
Microsoft states that XIRR discounts succeeding payments based on a 365-day year. With only a starting outflow and ending inflow, XIRR acts as an exact-date annualized return. With additional dated contributions or withdrawals, it also accounts for the timing and size of those intermediate cash flows.
RRI vs XIRR: which should you use?
Use RRI or the direct CAGR formula when you have one beginning value, one ending value, and a clean number of periods. Use XIRR when calendar dates are part of the problem or when money moves in and out during the period. The functions answer related but not identical questions once intermediate cash flows appear.
A business revenue series is usually a CAGR problem because you are comparing one revenue level with another. A portfolio with monthly contributions is generally an XIRR-style problem because each contribution has its own date and affects the investor's money-weighted return.
Common Excel mistakes
- Counting observations instead of periods. Six annual data points normally span five annual intervals.
- Forgetting percentage formatting. A result of 0.1247 is 12.47%, not 0.1247%.
- Using XIRR without opposite-signed cash flows. Microsoft requires at least one positive and one negative value.
- Mixing months with years. If the period input is monthly, make sure the output is annualized before calling it CAGR.
- Using a simple average. Averaging annual percentage changes is not the same as the endpoint CAGR formula.
Why an online calculator can still be useful
Excel is ideal when CAGR is part of a model, financial analysis, or repeatable reporting workflow. A browser calculator is faster for one-off checks and can make the period assumptions visible without requiring a workbook. The calculator on this site also shows total growth, a growth multiple, and a smoothed year-by-year path so you can inspect the result before copying it into a spreadsheet.