What CAGR Is and Why You Need It

CAGR stands for Compound Annual Growth Rate. It tells you the average yearly growth of an investment, business metric, or any number that changes over time. Unlike a straightforward average, CAGR accounts for the fact that growth compounds — meaning each year's growth builds on the previous year's total.

CAGR answers a specific question: if something grew from one value to another over several years, what was the steady yearly growth rate that would get you from start to finish? For example, if a stock portfolio grew from $10,000 to $15,000 over five years, CAGR tells you the consistent annual percentage gain that produced that result.

You'll use CAGR when comparing investments, tracking business revenue over time, or evaluating any metric where you need to know the real annual growth rate — not just the total change.

Key Takeaways

  • CAGR is calculated using the formula: (Ending Value ÷ Beginning Value) ^ (1 ÷ Number of Years) − 1, then multiply by 100 for a percentage.
  • You need three pieces of data: the starting value, the ending value, and the number of years between them.
  • CAGR smooths out year-to-year ups and downs to show one consistent growth rate across the entire period.
  • A spreadsheet or calculator makes the math fast; the exponent (^) is the only operation that trips up manual calculation.

The CAGR Formula and What Each Part Means

The formula is:

CAGR = (Ending Value ÷ Beginning Value) ^ (1 ÷ Number of Years) − 1

Then multiply the result by 100 to express it as a percentage.

Breaking this down: you divide the ending value by the starting value to get the total growth multiple. Then you raise that number to the power of (1 divided by the number of years). This is the step that "annualizes" the growth — it spreads the total growth evenly across each year. Finally, you subtract 1 and multiply by 100 to turn it into a percentage.

The exponent is what makes CAGR different from just dividing total growth by the number of years. It accounts for compounding, which is why CAGR is more accurate for real-world investments and business metrics.

Step-by-Step Calculation with a Real Example

Let's say you invested $5,000 in a fund in 2019, and it grew to $8,500 by the end of 2023. That's four years of growth. Here's how to find the CAGR:

Step 1: Divide ending value by beginning value. $8,500 ÷ $5,000 = 1.7

Step 2: Divide 1 by the number of years. 1 ÷ 4 = 0.25

Step 3: Raise 1.7 to the power of 0.25. This is where a calculator or spreadsheet saves time. 1.7 ^ 0.25 = 1.1398 (rounded)

Step 4: Subtract 1. 1.1398 − 1 = 0.1398

Step 5: Multiply by 100. 0.1398 × 100 = 13.98%

Your CAGR is 13.98%. That means your investment grew at an average rate of about 14% per year over those four years.

Using a Spreadsheet to Calculate CAGR

In Excel, Google Sheets, or any spreadsheet program, you can enter the formula directly. Put your beginning value in cell A1, your ending value in cell B1, and the number of years in cell C1. Then in cell D1, type:

=((B1/A1)^(1/C1)−1)*100

Press Enter, and the spreadsheet calculates CAGR when ready. This method eliminates rounding errors and is much faster than doing it by hand, especially if you're comparing multiple investments or time periods.

If you're working with dates instead of a year count, you can calculate the years between them first. In most spreadsheets, you can use =(YEAR(end_date)−YEAR(start_date)) to get the number of years, then plug that into the CAGR formula.

Common Mistakes When Computing CAGR

The most frequent error is forgetting to account for the number of years correctly. If you're measuring from January 2020 to December 2023, that's four full years, not three. Count the years carefully — it changes the result significantly.

Another mistake is using the wrong exponent. The exponent must be (1 ÷ number of years), not the number of years itself. Raising to the wrong power will give you a completely wrong answer.

People also sometimes confuse CAGR with average annual return. If an investment returned 10%, 20%, 15%, and 12% in four consecutive years, the average is 14.25%, but the CAGR is different because it accounts for compounding. Always use the formula, not a straightforward average.

Finally, CAGR assumes steady growth. If your data includes a major one-time event (a stock split, a merger, a one-time bonus), CAGR may not tell the full story. In those cases, note the exception alongside your CAGR figure.

When CAGR Is Most Useful

CAGR works best when you're comparing investments or metrics over three or more years. For shorter periods, the difference between CAGR and straightforward growth is small, so a basic percentage change is often enough.

Use CAGR to compare two investments fairly. If Fund A grew from $1,000 to $1,500 in three years and Fund B grew from $2,000 to $3,200 in five years, CAGR lets you see which one actually performed better on a year-by-year basis, regardless of the starting amount or time frame.

CAGR is also useful for business metrics: revenue growth, user growth, cost reduction over time, or any metric where you want to know the consistent annual rate of change. It smooths out the noise of individual years and shows the real trend.

CAGR Limitations You Should Know

CAGR assumes growth was steady every year, even if it wasn't. If your investment jumped 50% in year one and dropped 5% in year two, CAGR will show a middle-ground number that didn't actually happen in any single year. That's fine for comparison, but it can hide volatility.

CAGR also doesn't account for the timing of cash flows. If you added money to an investment partway through the period, CAGR won't reflect that accurately. For investments where you're adding or withdrawing money regularly, a different measure called the Internal Rate of Return (IRR) is more precise.

Finally, CAGR can be misleading with very short time periods or very small numbers. A $100 investment that grows to $150 in one year has a CAGR of 50%, which sounds impressive but may not be repeatable. Always look at the actual numbers and the time frame, not just the percentage.

Frequently Asked Questions

What's the difference between CAGR and average annual return?

Average annual return is the straightforward average of each year's return. CAGR accounts for compounding and tells you the single steady rate that would produce the same ending value. If returns vary year to year, CAGR and average return will differ. CAGR is more useful for comparing investments fairly.

Can CAGR be negative?

Yes. If your ending value is lower than your beginning value, CAGR will be negative, showing a decline. For example, if an investment fell from $10,000 to $7,000 over five years, CAGR would be approximately −7.2% per year.

Do I need to include partial years in my CAGR calculation?

You can, but it requires decimal years. If you're measuring from June 2020 to December 2023, that's 3.5 years. Use 3.5 in the formula. For simplicity, many people round to whole years, which is acceptable for rough comparisons.

What if my beginning value is zero or negative?

CAGR doesn't work when the beginning value is zero or negative. The formula breaks down mathematically. In those cases, describe the growth in absolute terms instead (the value increased by $X) rather than as a percentage.

Is there a quick way to estimate CAGR without a calculator?

The "Rule of 72" is a rough shortcut: divide 72 by the CAGR to estimate how many years it takes to double. But this works backward, not forward. For forward estimation, a calculator or spreadsheet is really the practical choice — the exponent step is too difficult to do accurately by hand.