Guide

CAGR formula: how to calculate compound annual growth rate

CAGR, the compound annual growth rate, is the steady yearly rate that turns a starting value into an ending value: divide the end value by the start value, raise the result to the power of 1 divided by the number of years, and subtract 1. Worked on real data, $10,000 put into QQQ on 10 March 1999 grew to $141,376 by 20 November 2026, a CAGR of 10.0%.

The CAGR formula in plain words

CAGR stands for compound annual growth rate. It answers one question: if an investment had grown at the same rate every single year, what rate would turn the starting value into the ending value? Real investments never grow evenly, so CAGR is a smoothed, imaginary path between two real points.

CAGR = (end value ÷ start value) ^ (1 ÷ number of years) − 1

The CAGR formula in four steps

  1. 1Divide end value by start value
  2. 2Count the years, part-years as decimals
  3. 3Raise to the power of 1 ÷ years
  4. 4Subtract 1: that's the yearly rate

Two details trip people up. The number of years must include part-years as decimals: two and a half years counts as two and a half, not two or three. And the "^" means "to the power of"; on a calculator it's the xʸ key, and in a spreadsheet it's the ^ symbol.

You can always check the answer backwards: grow the start value by the CAGR once for every year in the period and you should land on the end value. If you don't, the year count is usually the culprit.

The follow-along example

We'll use two funds most investors know, with dividends reinvested, from 10 March 1999 to 20 November 2026, the longest period both share. The dates matter: the example starts a year before the dot-com crash, which is why it teaches so much.

Follow along: the two funds

Fund What it is
QQQ The 100 largest non-financial Nasdaq companies, tech-heavy and the main example
SPY The S&P 500 in one fund, our benchmark: the yardstick we compare against

Step 1: Calculate CAGR from a start and end value

Put $10,000 into each fund on the first day and read the value on the last day. Those two numbers and the time between them are all the formula needs.

Follow along: the inputs and the answer

Start End CAGR
QQQ $10,000 $141,376 10.0%
SPY $10,000 $86,349 8.1%

Count the years between the two dates, with the extra months as a decimal, and run QQQ's numbers through the formula: you'll land on its CAGR in the table. If you're out by a little, check the part-year first.

Here is what those two smooth rates hide: neither fund travelled anywhere near a straight line, and QQQ spent years far below where it started.

QQQSPY
Growth of $10,000, full period: QQQ $141,376, SPY $86,349$0k$50k$100k$150k200020032006200920122015201820212024
  • QQQ $141,376
  • SPY $86,349

Full period: Indices Lab backtest, total return, funds held throughout, 10 March 1999 to 20 November 2026. Hypothetical results: past performance does not predict future returns.

Step 2: Don't confuse total return with CAGR

Total return is the whole gain over the period: how much more you ended with than you put in. CAGR spreads that gain into a yearly rate. Both are true; they answer different questions.

Follow along: one result, two numbers

Total return CAGR
QQQ 1313.8% 10.0%
SPY 763.5% 8.1%

QQQ's total return sounds enormous; spread over almost three decades it becomes a yearly rate in the low double digits. Compare yearly rates with yearly rates, never a total with a yearly figure.

The trap runs the other way for short periods. A fund up for six months can be "annualised" into a dramatic CAGR, but there's no reason the next six months will repeat the last. Treat any CAGR over less than a year as meaningless, and anything under three years as a rough sign at best.

Step 3: CAGR is not the average yearly return

The most common mistake is adding up each year's return and dividing by the number of years. That simple average, called the arithmetic mean, is almost always higher than the CAGR, and the bumpier the ride, the bigger the gap.

The reason is that losses and gains don't cancel out. Lose half your money one year, then gain half the next, and you end with three-quarters of what you started with. The average of the two years is zero; the money is down by a quarter. CAGR tells the truth about the money, the average doesn't.

Follow along: two real years that average a gain and still lose money

QQQ SPY
2008 −41.7% −36.8%
2009 +54.7% +26.4%

QQQ's two years average out to a gain, yet $10,000 held through both ended below $10,000. Now look at every full year in the chart below. Average QQQ's bars and you get a figure well above the rate those same years really compounded at. SPY's gap is smaller, because its years swing less.

QQQSPY
Calendar-year returns, QQQ best +54.9% (2023), worst -41.7% (2008); SPY best +32.3% (2013), worst -36.8% (2008)-40%-20%0%+20%+40%+60%200020032006200920122015201820212024
20002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025
QQQ−36.1%−33.3%−37.4%+49.7%+10.5%+1.6%+7.1%+19.0%−41.7%+54.7%+19.9%+3.4%+18.1%+36.6%+19.2%+9.4%+7.1%+32.7%−0.1%+39.0%+48.6%+27.4%−32.6%+54.9%+25.6%+20.8%
SPY−9.7%−11.8%−21.6%+28.2%+10.7%+4.8%+15.8%+5.1%−36.8%+26.4%+15.1%+1.9%+16.0%+32.3%+13.5%+1.2%+12.0%+21.7%−4.6%+31.2%+18.3%+28.7%−18.2%+26.2%+24.9%+17.7%

Full calendar years only. Full period: Indices Lab backtest, total return, funds held throughout, 10 March 1999 to 20 November 2026. Hypothetical results: past performance does not predict future returns.

So when a fund, an adviser or a newsletter quotes an "average annual return", ask whether it's the arithmetic average or the CAGR. Only the CAGR tells you what the money actually did.

Clone this example Opens the builder with QQQ 100% against SPY. Free account, no card.

Step 4: Change the start date and watch the CAGR move

A CAGR is a fact about two dates, not about a fund. Move either date and the number changes, sometimes completely. The test that shows this is to split the history in two and calculate each half.

Follow along: the same fund, two different answers

CAGR, first half CAGR, second half CAGR, last 3 years
QQQ 2.4% 18.3% 16.6%
SPY 2.8% 13.7% 16.3%

In the first half QQQ barely grew and finished behind SPY. In the second half it compounded faster than SPY did. Someone who looked only at the first half would call QQQ a poor fund; someone who looked only at the second would call it unbeatable. Both would be reading the calendar, not the fund.

QQQSPY
Growth of $10,000, first half: QQQ $13,879, SPY $14,574$5k$10k$15k$20k2000200220042006200820102012
  • QQQ $13,879
  • SPY $14,574

First half: Indices Lab backtest, total return, funds held throughout, 10 March 1999 to 14 January 2013. Hypothetical results: past performance does not predict future returns.

The fair way to judge is to look at every start date, not one. The strip below checks every 10-year window in the history: in each one, did QQQ's CAGR beat SPY's?

QQQ aheadSPY ahead
QQQ minus SPY, annualised return over every rolling 10-year window: QQQ ahead in 88.7% of 213 windows-5 pts0 pts+5 pts201020122014201620182020202220242026

QQQ finished ahead of SPY in 88.7% of 213 rolling 10-year windows (window ends by month). The last window QQQ won ended November 2026.

Full period: Indices Lab backtest, total return, funds held throughout, 10 March 1999 to 20 November 2026. Hypothetical results: past performance does not predict future returns.

Across 213 ten-year windows, QQQ came out ahead in 88.7% of them. But the gap ranged from −7.7 points to +7.3 points a year, and some 10-year stretches of QQQ ended lower than they began. A single "10-year CAGR" on a fund page is one of those windows.

Step 5: Read CAGR next to the worst fall

CAGR only looks at the first and last day. Everything in between disappears, including the falls that make real people sell. Two portfolios can share a CAGR and feel completely different to own.

Always read CAGR with the maximum drawdown, the biggest fall from a high to a low, and with how long the portfolio stayed under its old high.

Follow along: what the smooth rate left out

CAGR Maximum drawdown Longest time under a previous high
QQQ 10.0% 83.0% 14.9 years
SPY 8.1% 55.2% 6.6 years

QQQ's higher CAGR came with a deeper fall and a far longer wait to get back. Anyone who sold during that wait never earned the CAGR in the table.

QQQSPY
Drawdown from the previous high, full period. Worst falls: QQQ 83.0%; SPY 55.2%-80%-60%-40%-20%0%200020032006200920122015201820212024
  • QQQ worst fall 83.0% (27 March 2000 to 9 October 2002), longest time below a previous high 14.9 years
  • SPY worst fall 55.2% (9 October 2007 to 9 March 2009), longest time below a previous high 6.6 years

Full period: Indices Lab backtest, total return, funds held throughout, 10 March 1999 to 20 November 2026. Hypothetical results: past performance does not predict future returns.

Step 6: Use a different measure when money goes in or out

The CAGR formula assumes one deposit at the start and nothing else. Add money every month, or take some out, and CAGR on your account balance stops meaning anything: new deposits make the end value bigger without the investments growing at all.

Which return to use

CAGR

  • One sum at the start
  • Measures the investment
  • Start value, end value, years

Money-weighted return (XIRR)

  • Deposits and withdrawals
  • Measures your account
  • Every amount and its date

For an account with deposits and withdrawals, use a money-weighted return, often called IRR or, in a spreadsheet, XIRR. It weighs each deposit by how long it was invested. CAGR, worked on a single starting sum as in our example, measures the investment itself; the money-weighted return measures your experience of it, including when you added money. Both are useful. Just don't compare one with the other.

Step 7: Judge whether a CAGR is good

There is no fixed good CAGR. A number only means something next to an alternative measured over exactly the same dates, the same way.

Follow along: QQQ against its yardstick

QQQ minus SPY, CAGR per year
Full period +1.9 points
Last 3 years +0.2 points

Over the full period QQQ's lead was a couple of points a year, but Steps 4 and 5 showed what it took to collect it.

Three more checks before you trust any CAGR you read:

  • Dividends. Our figures include reinvested dividends. A CAGR from price alone understates funds that pay a lot of income.
  • Inflation. A CAGR is in today's money unless it says "real". Subtract inflation over the same years to see growth in buying power.
  • Costs. Fund fees are already inside an ETF's price, but trading costs and taxes in your own account are not.

Before you trust a CAGR

  • Same start and end dates for every option
  • Dividends included
  • At least a full year, ideally many
  • Checked from more than one start date
  • Read next to the maximum drawdown
  • XIRR, not CAGR, if money went in or out
  • Inflation and costs considered

The step-by-step backtest guide shows how to set up a test like this one, and Sharpe vs Sortino vs Calmar covers the ratios that put CAGR next to risk. For these two funds side by side, see QQQ vs VOO. Our methodology gives the exact definitions we use.

Backtest your own portfolio Opens the builder with QQQ 100% against SPY. Free account, no card.

Questions

What is the formula for CAGR?

CAGR = (end value ÷ start value) ^ (1 ÷ number of years) − 1. Divide the end value by the start value, raise the result to the power of one over the number of years (part-years as decimals), and subtract 1.

Is CAGR the same as average annual return?

No. The average annual return adds up each year's return and divides by the number of years. CAGR is the steady rate that actually links the start and end values. For anything that goes up and down, the average is higher than the CAGR, and only the CAGR matches the money.

What is a good CAGR for an investment?

There is no fixed number. Compare a CAGR only with another investment's CAGR over the same dates, with dividends treated the same way, and read it next to the worst fall it took to earn it.

Can CAGR be negative?

Yes. If the end value is below the start value, the formula gives a negative rate: the steady yearly loss that would have produced the same result.

How do I calculate CAGR with monthly contributions?

You don't: CAGR assumes a single deposit at the start. For an account with regular deposits or withdrawals, use a money-weighted return such as XIRR in a spreadsheet, which accounts for when each amount went in or out.

Build your index Opens the builder with QQQ 100% against SPY. Free account, no card.

About this page. Figures on this page come from Indices Lab’s own data, powered by EODHD, and every number is recalculated after each market close; the text is reviewed by a person before it is published. Indices Lab is a research and educational tool: everything here is hypothetical and informational, not investment advice and not a recommendation to buy or sell any security. Past performance does not predict future results. See our methodology.