CAGR stands for compound annual growth rate. It is the one steady yearly rate that takes a number from its starting value to its ending value. That version of events assumes growth was perfectly smooth. Real growth never is, and that is exactly why the metric exists.
Think of it as the cruising speed of a road trip. You sped up, slowed down, and stopped for coffee. The trip computer still reports one average speed for the whole drive. CAGR does the same job for revenue growth, users, market size, or any value that changes over years.
I have built growth models for marketing and SaaS teams since 2019, and CAGR shows up in almost every one. It is also the metric I see abused most often in board decks. So in this guide, I will cover the formula, a worked example, and why it beats simple averages. You will also see where teams use it, what counts as good, and the traps that quietly bend the number.
What Does CAGR Actually Mean?
CAGR means the constant annual rate that connects a beginning value to an ending value across several years. Compounding is the key word here. Each year’s growth builds on the year before, the same way interest earns interest in a savings account.
For the mathematically inclined, CAGR is the geometric mean of the yearly growth factors, minus one. You do not need that framing to use it well. It just explains why the metric behaves differently from the ordinary averages most dashboards report.
Naming varies more than the math does. You will see it spelled out as compound annual growth rate, shortened to compound growth rate, or described as an annualized growth rate. Investors sometimes just say “the company compounds at 30.” All of these point at the same calculation.
That makes CAGR a smoothed, hypothetical rate rather than a record of what happened each year. The Wikipedia entry on compound annual growth rate describes it as the rate a value would need to grow at to reach its final level. Reinvestment along the way is assumed. No single year needs to match the rate, and usually no year does.
Why do people love it so much? Because it collapses a messy multi-year story into one comparable number. Investors use it to compare return on investment across assets. Analysts use it to describe how fast markets expand. Marketing leaders use it to show growth without a jagged chart that invites awkward questions.
📌 Example: A newsletter I ran grew from 8,000 to 27,000 subscribers between 2021 and 2024. Growth came in lumps: one viral month, two flat quarters, a slow grind. The three-year CAGR was still a clean 50 percent per year. One number told the whole story without the noise.
What Is the CAGR Formula?
The CAGR formula divides the ending value by the beginning value. You then raise the result to the power of one over the number of years and subtract one. Written out, it looks like this:
🧮 Formula: CAGR = (Ending value / Beginning value)^(1 / Number of years) - 1
Let me make that concrete. Say your annual recurring revenue grew from 1,000,000 dollars to 2,000,000 dollars over three years. Divide 2,000,000 by 1,000,000 to get 2. Raise 2 to the power of one third, which gives 1.2599. Subtract 1 and you get 0.2599, or a CAGR of about 26 percent.
Here is the same company year by year. The left side shows what actually happened, while the right side shows the smooth path the CAGR describes.
| Year | Actual ARR | Actual YoY change | Smooth path at 26% CAGR |
|---|---|---|---|
| Start | $1,000,000 | n/a | $1,000,000 |
| Year 1 | $1,400,000 | +40.0% | $1,259,921 |
| Year 2 | $1,540,000 | +10.0% | $1,587,401 |
| Year 3 | $2,000,000 | +29.9% | $2,000,000 |
Notice that no actual year grew at 26 percent. The real years came in at 40, 10, and 29.9 percent. Yet both paths start and end at exactly the same values. That is the whole trick of the metric. The Corporate Finance Institute’s CAGR guide walks through the same mechanics with investment examples.
One counting rule saves a lot of grief. Use the number of growth periods, not the number of data points. Four year-end values span three years of growth, so the exponent is one third, not one quarter. I have seen that single off-by-one error inflate a pitch deck more than once.
The formula also accepts fractional periods. Measuring across 30 months? Use 2.5 as the number of years and the math holds. What you should not do is compound a few good months into an implied annual rate and present it as history. More on that particular sin in the mistakes section.
Why Does CAGR Beat a Simple Average?
CAGR beats a simple average because averaging yearly growth rates ignores compounding, and that omission flatters volatile series. The distortion is not small. It can turn a portfolio that went nowhere into a story about 25 percent yearly growth.
Watch it happen. A fund starts at 100,000 dollars, doubles in year one, then loses half in year two.
| Year | Return | Value at year end |
|---|---|---|
| Start | n/a | $100,000 |
| Year 1 | +100% | $200,000 |
| Year 2 | -50% | $100,000 |
The simple average of those two returns is plus 25 percent per year. Meanwhile the investor has exactly the money they started with. CAGR reports the truth: zero percent. Because it only compares the endpoints with compounding, it cannot be fooled by a big up year followed by a crash.
This gap between arithmetic and geometric averages is visible in nearly a century of market data. Aswath Damodaran’s returns dataset at NYU Stern tracks 100 dollars invested in the S&P 500 from the start of 1928. By the end of 2024, that 100 dollars had grown to roughly 982,818 dollars. Across those 97 years, the compound annual growth rate works out to about 9.9 percent. Individual years ranged from a 52.6 percent gain in 1954 to a 43.8 percent loss in 1931. A simple average of swings like that would paint a rosier picture than any investor actually lived through.
💡 Pro Tip: When someone quotes "average annual growth," always ask whether it is arithmetic or compound. If the series is volatile, the arithmetic number will be higher, sometimes wildly so. I now ask this question in every diligence call, and about a third of the time the answer changes the conclusion.
How Do You Calculate CAGR in a Spreadsheet?
You calculate CAGR in a spreadsheet with one formula: divide the ending cell by the starting cell, raise it to one over the years, and subtract one. If your start value sits in B2 and your end value in B5 with three years between them, the formula is:
=(B5/B2)^(1/3)-1
In practice, my setup takes about two minutes. Here is the exact sequence I follow:
- Lay out the series. Years in column A, values in column B, one row per year end, no gaps.
- Count the periods. Subtract the first year from the last year. Four rows of values means three growth periods.
- Write the formula. Point it at the first and last cells, never at typed-in numbers.
- Format as a percentage. A raw 0.2599 gets misread as 0.26 percent more often than you would think.
- Label the window. Put the start and end years in the cell label, so nobody quotes the rate without them.
Format the cell as a percentage and you are done. Prefer a named function? Both Excel and Google Sheets ship RRI, which returns the same rate from a period count, a start value, and an end value. Here, =RRI(3, 1000000, 2000000) returns 0.2599, the 26 percent from our worked example. The Google Docs editors documentation for RRI covers the syntax and its quirks.
Two small habits keep spreadsheet CAGRs honest. First, reference cells instead of typing values, so a data correction updates the rate automatically. Second, sanity-check your result against an independent tool such as the Omni Calculator CAGR tool. A thirty-second cross-check has caught more of my exponent typos than I would like to admit.
CAGR vs YoY Growth vs AAGR: What Is the Difference?
The difference is scope: CAGR describes multi-year growth as one compound rate. Year-over-year (YoY) growth compares one period against the same period a year earlier, and AAGR simply averages the yearly rates. Three cousins, three different jobs. Mixing them up is how growth stories go wrong.
YoY is your operational pulse. It tells you whether this quarter beat last year’s quarter, which makes it the right lens for momentum and seasonality. A sales growth rate reviewed quarter by quarter lives in YoY territory. AAGR, the arithmetic cousin, is quick to compute but inherits the volatility problem we just saw. The Wall Street Prep breakdown of CAGR shows how AAGR and CAGR diverge as swings get bigger.
| Metric | What it measures | Best for | Blind spot |
|---|---|---|---|
| YoY growth | Change versus the same period one year ago | Momentum, seasonality, operating reviews | Says nothing beyond one period |
| CAGR | Smoothed compound rate across multiple years | Multi-year comparisons, market sizing, targets | Hides volatility between endpoints |
| AAGR | Arithmetic average of yearly growth rates | Quick reads on stable, low-variance series | Overstates growth when swings are large |
My rule: YoY for running the business, CAGR for judging the journey, AAGR almost never. If a series is stable enough for AAGR to be accurate, CAGR gives nearly the same answer anyway. So the safer habit costs you nothing.
What Counts as a Good CAGR?
A good CAGR depends entirely on the base, the market, and the timeframe, so there is no universal threshold. What helps is intuition for what each rate actually does to a number over time. Doubling time is the fastest way to build that intuition.
| CAGR | Time to double | Typical context |
|---|---|---|
| 5% | 14.2 years | Mature markets, large stable businesses |
| 10% | 7.3 years | Close to long-run equity market returns |
| 20% | 3.8 years | Healthy growth-stage companies |
| 30% | 2.6 years | Strong SaaS and expanding categories |
| 50% | 1.7 years | Early-stage growth from a small base |
Two cautions before you benchmark yourself against a table like this. First, base size changes everything. Growing 50 percent from 200,000 dollars is a good quarter of pipeline work, while the same rate from 20 million is a rocket. Second, sustainability beats peak speed. A company that compounds at 25 percent for a decade ends up far ahead of one that hits 80 percent once and stalls.
The honest benchmark question is never “is this rate good?” in the abstract. It is “is this rate good for a company of this size, in a market growing at that rate?” Answer both parts and the number starts meaning something.
Where Do Marketing and SaaS Teams Use CAGR?
Marketing and SaaS teams use CAGR in four main places: market sizing, ARR growth stories, forecast sanity checks, and competitor benchmarks. Each use has its own flavor, so let me take them one at a time.
A quick note on cadence first. This is an annual metric, so it belongs in quarterly business reviews, board decks, and planning documents. It does not belong in a weekly dashboard, where shorter growth measures do the real work. Matching the metric to the meeting saves everyone confusion.
Market sizing. Nearly every industry report expresses a market’s future as a CAGR. Analysts size an addressable market today, apply a compound rate, and project the value five or ten years out. When your deck says the market will double by 2031, a CAGR assumption is doing the heavy lifting. Always check whose assumption it is.
ARR growth stories. Boards and investors think in multi-year compound rates. A three-year ARR CAGR smooths out the lumpy quarters and answers the only question they care about: how fast does this business really grow? The same math works for customer growth rate, pipeline value, headcount, or organic traffic.
Forecast sanity checks. Work a plan backward into its implied CAGR and you find out fast whether it is brave or delusional. A plan that implies 80 percent compound growth while customer acquisition cost stays flat deserves hard questions. The same check applies to customer lifetime value models that quietly bake an optimistic growth rate into every cohort.
Competitor benchmarks. Public companies publish revenue, so you can compute their CAGRs directly. Private competitors take more work. I usually start from employee counts, since headcount growth tracks revenue growth reasonably well in B2B. For that kind of benchmark data, I pull firmographics from an enrichment tool such as CUFinder and compute three-year headcount CAGRs across the segment. Honestly, the math is the easy part. The result is only as good as the underlying records, and no data tool stops you from choosing endpoints that flatter your own story.
🔍 Field Note: In 2024 I watched two analysts size the same market and land 2x apart. Same sources, same method. One started the projection from a 2020 pandemic trough, the other from 2019. Endpoint choice, not analysis, produced the gap. We shipped both numbers with the assumptions labeled, and the client trusted us more for it.
What Are the Limitations of CAGR?
The main limitations of CAGR are that it hides volatility, depends entirely on two endpoints, and misleads over short windows. None of these make it a bad metric. They make it a metric you should never read alone.
It hides volatility. Our worked example grew 40 percent one year and 10 percent the next. The CAGR serenely reports 26 percent and tells you nothing about the swing. A SaaS business whose churn rate spiked for two quarters can still show a smooth multi-year CAGR. The risk lived between the endpoints, exactly where this metric never looks.
It is endpoint-sensitive. Move either endpoint one year and the rate can change dramatically. Start measuring at a trough and growth looks heroic. End at a peak and the same thing happens. This sensitivity is the root of most CAGR-based deception, intentional or not. Post-2020 data is especially treacherous here, because so many series cratered and rebounded within two years.
It breaks down over short windows. The metric answers an annual question, so it needs multiple years to mean much. Computing a CAGR across 18 months mostly amplifies noise. Below a year, it stops being an annual rate at all and becomes an extrapolation.
It says nothing about the future. A trailing CAGR is a description, not a forecast. Growth rates decay as bases get larger, so yesterday’s 60 percent rarely survives contact with next year. Treat any projection built on a trailing CAGR as an assumption to defend, not a fact to cite.
The fix for all four weaknesses is the same: never present the rate alone. Show the yearly series next to it, note the window, and add one volatility signal such as the worst single year. That combination keeps the convenience of one number without the blind spots.
What Is Reverse CAGR? Planning Targets With the Formula
Reverse CAGR runs the formula backward: you fix the target and the timeframe, then solve for the growth rate required to get there. Instead of describing the past, the same math now prices your ambition. The rearranged formula is Required CAGR = (Target value / Current value)^(1 / Years) – 1.
Suppose you sit at 2,000,000 dollars in ARR and want 5,000,000. The required rate depends heavily on how long you give yourself:
| Timeframe | Required CAGR | Year 1 milestone | Year 2 milestone |
|---|---|---|---|
| 2 years | 58.1% | $3,162,000 | $5,000,000 |
| 3 years | 35.7% | $2,714,000 | $3,684,000 |
| 4 years | 25.7% | $2,515,000 | $3,162,000 |
| 5 years | 20.1% | $2,402,000 | $2,885,000 |
Those intermediate milestones are the practical payoff. A three-year plan at 35.7 percent means hitting roughly 2.71 million by the end of year one. Miss that checkpoint and the remaining years must grow even faster, because compounding is unforgiving in both directions. You can pressure-test any of these paths with the compound interest calculator at Investor.gov. It runs the same math from the investor’s side.
I use the same trick below the company level. A pipeline target, a subscriber goal, an organic traffic plan: each one can be solved backward into a required compound rate. When the required rate looks nothing like your history, you have learned something important before spending a dollar.
🧠 Worth Remembering: Reverse CAGR is the fastest honesty test I know for annual planning. In 2023 a leadership team handed me a five-year revenue target that sounded reasonable in isolation. Solved backward, it implied 74 percent compound growth from a base that had never grown past 30. The target survived the meeting; the plan behind it did not.
What Are the Most Common CAGR Mistakes?
The most common CAGR mistakes are annualizing sub-year data, cherry-picking endpoints, miscounting periods, and quoting the rate as if it were a forecast. I have made at least two of these myself, so consider this section scar tissue.
Annualizing sub-year data. Early in 2023 I reviewed a deck built on four strong months of monthly recurring revenue. The authors had compounded that hot streak into an “89 percent CAGR,” as if the streak could never end. It ended in month six. The restated number cost the team far more board credibility than a modest true figure ever would have. Quote month-over-month growth for short periods and save CAGR for actual years.
Cherry-picking endpoints. Because only two values enter the formula, choosing them is choosing the answer. Starting from a down year manufactures growth. Common fixes: use fixed fiscal years, show the underlying series next to the rate, and disclose the window every single time.
Miscounting periods. Five data points mean four years of growth. Using five in the exponent understates the rate; using three overstates it. Small error, big consequences at compounding scale.
Treating the rate as destiny. Pasting last period’s CAGR onto the next five years is the laziest forecast in business. Growth decays with scale. Model the drivers, then check the implied CAGR, never the reverse.
📌 Checkpoint: Before you publish any CAGR, answer three questions. Are both endpoints real annual figures? Would the story survive shifting the window one year in either direction? Did you count growth periods, not data points? Two minutes of checking beats one restated board slide.
Frequently Asked Questions
What does a 10% CAGR mean?
A 10 percent CAGR means the value grew as if it had compounded at 10 percent every year over the measured period. At that rate, a value doubles in just over seven years. So 100,000 dollars becomes 110,000 after one year, 121,000 after two, and about 133,100 after three.
Is a CAGR of 30% good?
Yes, a 30 percent CAGR is strong in almost any context. It doubles a value roughly every two and a half years. For mature public companies it would be exceptional, while early-stage SaaS businesses often grow faster from small bases. Judge the number against the company’s size and its market’s growth rate.
What is CAGR in simple terms?
CAGR is the steady yearly growth rate that would take a number from its starting value to its ending value. Real growth bounces around, so CAGR smooths the bumps into one honest average speed. It answers the question: how fast did this really grow per year?
Is a CAGR of 5% good?
A 5 percent CAGR is modest. It sits below the long-run S&P 500 compound return of roughly 9.9 percent, so an investor could likely do better in an index fund. For a mature market or a large stable business, though, 5 percent can represent healthy, durable growth.
Can CAGR be negative?
Yes. If the ending value is lower than the starting value, the formula returns a negative rate. A business that shrank from 4,000,000 to 3,000,000 dollars over three years has a CAGR of about minus 9.1 percent. That means it declined at that compound pace each year.
What is the difference between CAGR and IRR?
CAGR measures growth between exactly two values, a start and an end. IRR, the internal rate of return, handles multiple cash flows at different times, such as staged investments and interim payouts. Use CAGR for a simple held position or metric, and IRR when money moves in and out along the way.
How do you calculate CAGR in Excel?
Use =(ending cell/starting cell)^(1/years)-1, for example =(B5/B2)^(1/3)-1 for three years. Alternatively, use the built-in function =RRI(years, start, end), which returns the same rate. Format the result as a percentage. Both formulas also work in Google Sheets.
What is a good CAGR for a SaaS company?
It depends on scale. Small SaaS companies often need compound growth well above 50 percent to attract venture funding. Businesses past 20 million in ARR are judged against progressively lower bars. Compare against companies at your revenue stage, not against the whole industry, and read the rate alongside retention.
So that is CAGR: one formula, two endpoints, and a smooth annual rate that makes messy growth comparable. Use it to judge multi-year journeys, pair it with the yearly series so volatility stays visible, and always disclose your endpoints. Handled that way, it becomes one of the most honest numbers in your reporting. Abused, it becomes the most polite way to mislead a board. The difference is entirely in the hands holding the formula.
Bad
Okay
Good
Amazing
