Compound Annual Growth Rate (CAGR): A Simple Way to See Real Growth
If you’ve ever looked at business or investment numbers, someone has probably asked about growth. But raw growth can be tricky. A company might double one year, slow down the next, and speed up again after that. So how do you find the real average growth? That’s where Compound Annual Growth Rate (CAGR) comes in.
CAGR gives you one clean number that shows how something grew over time — as if it grew by the same rate every year. I use it often with founders and finance teams because it clears up a lot of confusion.
What is CAGR?
CAGR stands for Compound Annual Growth Rate. It answers a simple question:
“If a number grew from A to B over a few years, what steady yearly rate would make that happen?”
It smooths out the bumps — the ups and downs — and shows the average yearly growth.
Investors use it to compare different investments.
Business owners use it to track long-term progress.
Analysts use it to make reports easier to read.
But it’s not perfect. CAGR assumes steady growth, and real life is rarely steady. If cash flow jumps around a lot or includes several deposits and withdrawals, CAGR won’t tell the full story. Still, it’s a great starting point.
The Simple CAGR Formula
Here’s the formula in plain form:
CAGR = (End Value / Start Value) ^ (1 / Years) - 1
In Excel, it looks the same:
= (End / Start) ^ (1 / Years) - 1
Example:
Start = 100,000
End = 200,000
Years = 4
Step-by-step:
200,000 ÷ 100,000 = 2
2 ^ (1/4) = 1.189
1.189 - 1 = 0.189 → 18.9% per year
So, the business grew by about 18.9% each year, if it grew at a steady pace.
Quick Checklist to Calculate CAGR
Confirm the start value (use consistent definitions).
Confirm the end value (same type of number).
Convert months to years if needed (months ÷ 12).
Apply the formula.
Turn the result into a percentage and round it.
If your start or end number is zero or negative, CAGR won’t work — it only makes sense with positive numbers.
Example: Simple Investment
You invest $10,000. Six years later, it’s worth $19,000.
19,000 ÷ 10,000 = 1.9
1.9 ^ (1/6) = 1.1125
Subtract 1 = 0.1125 or 11.25%
Your money grew at about 11.25% per year on average.
Example: Startup Revenue
A startup grows from $250,000 to $1.2 million in five years.
1,200,000 ÷ 250,000 = 4.8
4.8 ^ (1/5) = 1.364
Subtract 1 = 36.4% CAGR
That 36.4% yearly growth tells a clear story — fast and consistent growth over time.
Using Excel or a Calculator
Online CAGR calculators are easy — just enter start, end, and years.
In Excel, try either of these:
Direct Formula:
= (End / Start) ^ (1 / Years) - 1
RATE Function:
= RATE(Years, 0, -Start, End)
(The minus sign means you “spent” the start value and “received” the end value.)
Common Mistakes
Using one-time events without adjusting.
Confusing CAGR with average growth rates.
Applying it to volatile cash flows.
Using zero or negative numbers.
Mixing definitions (like GAAP vs non-GAAP revenue).
And always include the time period when you report a CAGR. “25% CAGR” means nothing without “over 5 years.”
When Not to Use CAGR
Skip CAGR when:
Cash flows vary a lot → use IRR (Internal Rate of Return).
You care about typical, not average → use median growth.
You need to show volatility → use standard deviation.
The time window is short → use year-over-year growth.
Dealing with Negative or Zero Values
If your start or end number is negative or zero:
Use a positive metric instead (like active users).
Use point changes (like margin rising from 30% to 40%).
Shift all values upward (but explain it clearly).
Or just report the raw numbers and explain the story.
Never fake a CAGR just to make the chart look nice.
Comparing CAGR Across Companies
When comparing growth rates, make sure you’re comparing the same things:
Same metric (revenue vs revenue).
Same accounting rules.
Similar company size.
Same time period.
CAGR is good for quick comparisons, not for final judgments.
What’s a “Good” CAGR?
It depends on the type of company:
Startups: 50%+ is strong, but volatile.
SaaS growth stage: 20–40%.
Mature companies: 5–15%.
Stock indexes (S&P 500): 7–10% after inflation.
Always compare within the same industry.
Real Example
A founder grew her user base from 12,000 to 72,000 in 3 years.
72,000 ÷ 12,000 = 6
6 ^ (1/3) = 1.817
Subtract 1 = 81.7% CAGR
That single number told investors her company was growing fast — and the story behind it made sense.
Tips for Reporting CAGR
Always include the time period.
Explain any adjustments.
Add supporting numbers (like churn or ARR).
Show a chart — people like to see the trend.
Stay consistent in how you measure and report.
Final Thoughts
CAGR is simple, but powerful. It tells a long-term story in one number. Just remember: it’s a summary, not the whole picture. Show the context. Explain the highs and lows. Keep it honest.
If you want to try it, grab your recent data, pick a metric, and calculate a 3–5 year CAGR. Then look at how the year-by-year numbers compare. You’ll see right away if your growth story holds up.
Comments
Post a Comment