CAGR Explained: How to Calculate Compound Annual Growth Rate and Use It to Compare Investments

Compound annual growth rate is one of the most useful numbers in investing, yet it is frequently misunderstood, misquoted, and confused with simpler averages that tell a very different story. If you have ever seen a fund advertisement claiming "12% average annual returns" and wondered why your actual account balance looks nothing like that, CAGR is the number that explains the gap.

This guide covers what CAGR is, how to calculate it step by step with worked examples, how it differs from simple average annual return, how to apply it to stocks and revenue, what constitutes a strong CAGR by context, where it falls short, and how it compares to IRR and XIRR. By the end you will know exactly how to use CAGR in your own investment research.

What Is CAGR?

CAGR stands for compound annual growth rate. It measures the rate at which an investment or metric would have grown if it grew at a perfectly steady rate each year over a defined period.

The key word is "compound." CAGR treats each year's growth as building on the prior year's balance, not just the original starting value. It answers the question: what single annual growth rate, applied consistently and compounded each year, would take me from the starting value to the ending value over this exact time span?

CAGR is used everywhere in finance:

• To measure portfolio or stock return over a multi-year holding period
• To compare the growth rate of one company's revenue against another
• To evaluate fund performance across different time windows
• To assess the historical growth of earnings, dividends, or free cash flow
• To communicate long-run business trajectory to investors

CAGR is not a prediction. It is a backward-looking measurement that describes what actually happened, expressed as a smooth annual equivalent. It does not mean the investment grew smoothly every year — markets are volatile and revenues fluctuate — but CAGR translates any jagged multi-year path into a single clean rate.

CAGR Formula and Step-by-Step Calculation

The CAGR formula is:

CAGR = (Ending Value / Beginning Value) ^ (1 / Number of Years) - 1

Breaking it down:

• Ending Value: the final value at the end of the period (portfolio value, stock price, revenue figure)
• Beginning Value: the starting value at the beginning of the period
• Number of Years: the total length of the period (can be fractional for partial years, though whole years are most common)
• The exponent (1 / N) is what "annualizes" the total growth — it converts total growth over N years into a per-year equivalent

Worked example — stock investment:

You invested in a stock at $45.00 per share. Five years later, the stock trades at $82.60. Dividends were not reinvested.

CAGR = (82.60 / 45.00) ^ (1/5) - 1
CAGR = (1.8356) ^ (0.2) - 1
CAGR = 1.1287 - 1
CAGR = 0.1287 or 12.87%

The stock compounded at approximately 12.9% per year over five years.

Worked example — company revenue:

A software company reported revenue of $210 million in 2019 and $580 million in 2024. That is five years of growth.

CAGR = (580 / 210) ^ (1/5) - 1
CAGR = (2.7619) ^ (0.2) - 1
CAGR = 1.2243 - 1
CAGR = 0.2243 or 22.4%

Revenue compounded at 22.4% annually over that five-year stretch. That is a strong growth trajectory for a company of that size.

Worked example — partial year period:

An investment grew from $10,000 to $14,200 over 3.5 years.

CAGR = (14,200 / 10,000) ^ (1/3.5) - 1
CAGR = (1.42) ^ (0.2857) - 1
CAGR = 1.1068 - 1
CAGR = 10.68%

The formula handles fractional periods cleanly by using 3.5 as the exponent divisor.

CAGR vs Average Annual Return: The Key Difference

This is the most important distinction in understanding CAGR, and the one most often glossed over in fund marketing.

Average annual return (also called arithmetic mean return) adds up each year's individual return and divides by the number of years. It does not account for compounding.

CAGR (also called geometric mean return) accounts for the fact that gains compound on each other — and losses compound downward too.

A concrete illustration:

You start with $100,000. Year one: the investment drops 50%. Year two: the investment rises 50%.

• Average annual return = (-50% + 50%) / 2 = 0%. The average says you broke even.
• What actually happened: after year one you have $50,000. After year two, a 50% gain on $50,000 gives you $75,000. You lost $25,000.

The CAGR:

CAGR = (75,000 / 100,000) ^ (1/2) - 1
CAGR = (0.75) ^ (0.5) - 1
CAGR = 0.8660 - 1
CAGR = -13.4% per year

The arithmetic average said 0%. CAGR correctly shows you lost 13.4% per year on a compounded basis. That gap is why CAGR is the right tool for measuring multi-period investment returns and why arithmetic averages in fund advertisements can be misleading.

When does arithmetic mean still have a place? When you are estimating the projected return of a single future period — not measuring what has already happened across multiple compounded periods. For modeling projected future returns, arithmetic means are appropriate. For measuring what actually happened over multiple years, CAGR is the correct metric.

CAGR for Stock Returns

CAGR is the standard way to communicate long-term stock performance. When an analyst says a stock has "delivered 14% CAGR over the past decade," they mean that a dollar invested ten years ago grew at a compounded rate equivalent to 14% per year — regardless of how volatile the individual years were.

Useful applications in stock research:

Total return CAGR — includes both price appreciation and dividends (reinvested). This is the most complete measure of shareholder return over a holding period.

Price return CAGR — price appreciation only, excluding dividends. Useful for comparing stocks where reinvestment is uncertain.

EPS CAGR — growth rate of earnings per share over multiple years. A company with 15% EPS CAGR over five years is expanding earnings significantly. This is a common screen in growth investing.

Free cash flow CAGR — measures how quickly a company's actual cash generation has grown. Slower than EPS CAGR? Worth investigating. Faster? Often a positive quality signal.

Dividend CAGR — rate at which the dividend has grown. A dividend that has compounded at 8% annually is a meaningfully different income stream than a flat dividend, and investors in dividend growth strategies watch this figure closely.

When comparing two stocks, CAGR normalizes the comparison. A stock that returned 180% over seven years and a stock that returned 95% over four years cannot be directly compared on total return — but their CAGRs (approximately 15.4% and 18.9% respectively) can be compared on equal footing.

CAGR for Revenue Growth

Revenue CAGR is one of the most frequently cited metrics when analyzing growth companies. A single year of strong revenue growth might be a one-time event; a multi-year CAGR reveals whether the business is structurally growing or just had a good year.

How analysts use revenue CAGR:

• Compare revenue growth rate against industry peers over the same period
• Assess whether growth is accelerating or decelerating by comparing 3-year CAGR vs 5-year CAGR
• Evaluate management guidance versus historical CAGR as a sanity check
• Identify inflection points where a mature business began re-accelerating growth

Example comparison:

Company A grew revenue from $500M to $850M over four years. Company B grew from $200M to $430M over the same period.

Company A CAGR = (850/500)^(1/4) - 1 = 1.14 - 1 = 14.2%
Company B CAGR = (430/200)^(1/4) - 1 = 1.210 - 1 = 21.0%

Company B grew faster on a compounded basis despite starting from a smaller base. Whether that faster growth justifies a higher valuation multiple depends on additional factors — margin profile, market size, competitive position — but CAGR is the correct starting point for the comparison.

Revenue CAGR and valuation. High-growth companies often trade at elevated price-to-sales multiples precisely because their revenue CAGR implies a much larger future revenue base. Investors paying 15x revenue on a company growing at 30% CAGR are betting that revenue will triple within roughly four years — which would compress the forward multiple significantly if the growth holds.

What Is a Good CAGR?

"Good" depends entirely on what you are measuring and over what time period. Context is everything.

For stock or portfolio returns:

Under 5% CAGR     Below long-run equity market average; underperformed most index benchmarks
5% - 10% CAGR     In line with or slightly below broad market long-run average
10% - 15% CAGR    Above-market performance; solid long-run compounding
15% - 25% CAGR    Strong — typically achieved by skilled investors or high-quality growth stocks
Above 25% CAGR    Exceptional; very difficult to sustain over long periods

The S&P 500 has produced a long-run total return CAGR of approximately 10% before inflation over multi-decade periods, though individual windows vary significantly.

For revenue growth:

Under 5% CAGR       Slow-growth or mature business; in line with nominal GDP
5% - 10% CAGR       Moderate growth; holding market share in a growing industry
10% - 20% CAGR      Fast-growing business; typically commands a premium valuation
Above 20% CAGR      High-growth; typical of early-stage software, biotech, or disruptive businesses
Above 40% CAGR      Hypergrowth; usually unsustainable past a certain scale

For earnings per share growth:

5% - 8% CAGR     Stable compounder; suitable for dividend-focused or value investing
10% - 15% CAGR   Quality growth; commands a moderate to premium P/E multiple
Above 20% CAGR   High growth; market often prices this in with elevated multiples

Important caveat: high CAGRs over short periods are easier to achieve than over long periods. A three-year revenue CAGR of 40% is impressive but not as rare as a ten-year revenue CAGR of 25%. Always note the time period when citing or interpreting a CAGR.

CAGR Limitations

CAGR is useful precisely because it is simple. But that simplicity hides real limitations.

It conceals volatility. Two investments can have identical five-year CAGRs but radically different ride-along experiences. One might have been flat for four years and surged 80% in year five. The other might have risen steadily every year. CAGR cannot tell you which you actually experienced.

Sequence of returns matters for withdrawals. CAGR is calculated only on beginning and ending values. If you made withdrawals during the period — as retirees do — CAGR on the original balance is not a reliable guide to outcomes. The timing of losses relative to withdrawals matters enormously, which CAGR ignores.

It depends entirely on the endpoints. CAGR is sensitive to when you start and end the measurement. A stock measured from a market peak to a trough will look much worse than the same stock measured from trough to peak. Always check whether endpoints are cherry-picked.

It does not account for contributions or withdrawals. If you added capital mid-period, simple CAGR overstates your return. This is where XIRR (covered below) is more accurate.

Revenue CAGR ignores profitability. A company growing revenue at 25% CAGR while burning cash at an accelerating rate is a very different investment from one growing at 25% while expanding margins. CAGR on revenue says nothing about earnings quality.

Short time periods can mislead. A two-year CAGR of 30% could reflect one extraordinary year. Use longer windows — five years or more — for more reliable signal.

CAGR vs IRR vs XIRR

These three metrics are related but serve different purposes. Knowing which to use and when matters.

CAGR assumes a single lump sum invested at the start and a single payout at the end. No intermediate cash flows. It is the right tool when you want a clean annualized growth rate for a single value (a stock price, a revenue line, a portfolio balance with no contributions or withdrawals).

IRR (Internal Rate of Return) handles multiple cash flows at regular intervals. If you invested a lump sum and received annual dividends or coupon payments, IRR gives you the true annualized return across all those cash flows. Private equity and real estate investors use IRR extensively because projects involve capital calls at different points and distributions at different points.

XIRR (Extended Internal Rate of Return) is the most realistic metric for actual investor returns because it handles irregular cash flows with specific dates. If you invested $5,000 in January, added $2,000 in August, and added another $3,000 the following March, CAGR cannot handle that — but XIRR can, because it uses the exact dates of each cash flow.

Which to use:

Scenario                                        Use
Single lump sum, no contributions/withdrawals   CAGR
Regular periodic cash flows (bonds, dividends)  IRR
Irregular contributions/withdrawals             XIRR
Business investment with uneven cash flows      IRR or XIRR
Evaluating a company's revenue growth rate      CAGR
Comparing fund or index performance             CAGR

For most retail investors evaluating their own portfolio with regular contributions through a brokerage account, XIRR is technically more accurate. CAGR is still useful for comparing benchmarks and individual positions where you can isolate the beginning and ending value cleanly.

How to Calculate CAGR in Excel

Excel does not have a dedicated CAGR function, but the calculation is straightforward using the built-in RATE or power functions.

Method 1: Direct formula

If your starting value is in cell B2 and ending value is in cell B8 covering 6 years:

= (B8 / B2) ^ (1/6) - 1

Format the cell as a percentage. That is your CAGR.

Method 2: Using the RRI function

Excel has a lesser-known RRI function designed exactly for CAGR:

= RRI(nper, pv, fv)

Where nper is the number of periods, pv is the present (starting) value, and fv is the future (ending) value.

= RRI(6, B2, B8)

Returns the same result as the manual formula, formatted as a decimal. Format as percentage.

Method 3: CAGR with XIRR for irregular cash flows

If you want true time-weighted return with contributions:

1. List all cash flows in one column (outflows as negative, final value as positive)
2. List corresponding dates in the adjacent column
3. Enter: = XIRR(cash_flow_range, date_range)

Excel will return the annualized return rate that accounts for the exact timing and size of every cash flow.

Building a CAGR table: Many analysts build a small table that calculates 1-year, 3-year, 5-year, and 10-year CAGRs simultaneously by anchoring to a fixed ending date and looking back different numbers of years. This gives an instant picture of whether growth is accelerating or decelerating over different time horizons.

Applying CAGR in Your Investment Research

When you are researching a stock, CAGR shows up in multiple places and answers multiple questions simultaneously.

Reviewing historical revenue CAGR across three, five, and ten year windows tells you whether growth has been sustained or whether a recent strong year is masking deterioration. A company with 18% five-year revenue CAGR but only 8% three-year CAGR is decelerating — that shift often precedes multiple compression.

EPS CAGR compared to revenue CAGR reveals margin dynamics. If earnings have grown faster than revenue over five years, margins have expanded. If EPS CAGR lags revenue CAGR substantially, the company may be growing revenue at the cost of profitability.

Free cash flow CAGR is often the most durable indicator of business quality. Revenue can be boosted by aggressive accounting and EPS can be inflated through share buybacks, but free cash flow growth is harder to manufacture. A company with 15% free cash flow CAGR over seven years has typically built something real.

Equity Rank surfaces multi-year financial data for 3,000+ stocks, letting you examine revenue, earnings, and cash flow trends across historical periods. When the valuation models run, they incorporate historical growth rates alongside analyst consensus estimates to arrive at the SAVE score — the platform's composite model confidence metric across eight or more valuation methods. You can explore any stock's fundamentals and valuation at equity-rank.com.

CAGR in Context: A Complete Example

To bring all of this together, here is a full example of using CAGR to research a hypothetical software company.

Revenue CAGR (2019-2024, 5 years):

2019: $180M   2024: $510M
CAGR = (510/180)^(1/5) - 1 = (2.833)^(0.2) - 1 = 1.231 - 1 = 23.1%

Strong revenue growth. Consistent with a market-leading software business.

EPS CAGR (same period):

2019 EPS: $1.20   2024 EPS: $3.85
CAGR = (3.85/1.20)^(1/5) - 1 = (3.208)^(0.2) - 1 = 1.262 - 1 = 26.2%

EPS grew slightly faster than revenue, implying modest margin expansion. That is a quality indicator.

Free cash flow CAGR:

2019 FCF: $28M   2024 FCF: $95M
CAGR = (95/28)^(1/5) - 1 = (3.393)^(0.2) - 1 = 1.277 - 1 = 27.7%

FCF grew fastest of all three — a very strong signal. The company is converting an increasing share of revenue to cash.

Stock price CAGR (investor return):

2019 price: $42   2024 price: $118
CAGR = (118/42)^(1/5) - 1 = (2.810)^(0.2) - 1 = 1.229 - 1 = 22.9%

Stock returned 22.9% annualized. Just below EPS and FCF CAGR, suggesting the market is not dramatically overpricing the growth trajectory.

This is the kind of multi-metric CAGR analysis that helps investors distinguish between companies that grew fast and those that grew fast profitably.

CAGR and Fair Value

CAGR feeds directly into stock valuation. In a discounted cash flow analysis, the projected growth rate of free cash flow over the forecast horizon determines a large portion of the calculated fair value. A company with demonstrated 20% FCF CAGR over the past five years gives an analyst a data point — not a guarantee — when setting the growth assumption in a DCF model.

The model assumption should not mechanically replicate the historical CAGR forever. Growth rates mean-revert over time. Businesses that compound at 25% per year for a decade are rare. DCF models typically assume declining growth rates over the forecast period and a lower terminal growth rate reflecting long-run industry or GDP-level growth.

Equity Rank's valuation engine applies multiple methods — not just DCF — to generate fair value estimates, including earnings-based models, asset-based approaches, and market multiple comparisons. The SAVE score reflects the degree to which those methods converge on a similar value, giving investors a read on model confidence rather than a single point estimate that implies false precision.

Analyzing fundamentals including CAGR across revenue, earnings, and cash flow alongside multi-model fair value is available at equity-rank.com with a 7-day free trial.

Practical Takeaways

CAGR is not complicated, but it is powerful. Here is what to remember:

• CAGR measures the smooth annualized growth rate that connects a starting value to an ending value over multiple years. It accounts for compounding.
• It is not the same as average annual return. Average annual return ignores compounding and overstates performance when returns are volatile.
• Use the formula: (Ending / Beginning) raised to the power of (1 / Years), minus 1.
• For stocks and portfolios, CAGR over five or more years is a reliable measure of long-term performance.
• For business analysis, compare revenue, EPS, and FCF CAGRs together. Divergence between them tells you something important.
• What qualifies as a "good" CAGR depends entirely on the asset class, time period, and benchmark. Context matters.
• CAGR conceals volatility and is sensitive to endpoint selection. Always check the period being measured.
• For portfolios with regular contributions or withdrawals, XIRR gives a more accurate picture than CAGR.
• In Excel, use the formula (End/Start)^(1/N) - 1 or the RRI function for a clean calculation.

The next time you see a multi-year return or growth figure, ask: is this CAGR or an arithmetic average? The answer tells you whether the number means what it appears to mean.

This content is for educational purposes only. Nothing in this article constitutes investment advice. Equity Rank is not a registered investment adviser. All growth rate figures in examples are hypothetical and illustrative. Past performance of any investment or strategy does not guarantee future results.