Skip to content
Menu
Finabase Learn

Measure and manage portfolio risk Lesson 1 of 14

Portfolio and risk · Measuring return and risk

CAGR: compound annual growth rate, with the formula and its limits

How to calculate a compound annual growth rate, why it is lower than the average yearly return, and what 33 years of SPY show about the years it hides.

On this page
  1. The idea
  2. How it works
  3. Why CAGR is lower than the average return
  4. Where it fails or misleads
  5. Compared with its neighbours
  6. How Finabase does it
  7. Frequently asked questions
  8. Summary
  9. Check your understanding
  10. Exercise

The compound annual growth rate, or CAGR, is the single yearly rate that would have turned a starting amount into an ending amount if growth had been perfectly steady. It answers one question: "per year, compounded, how fast did this grow?" It is the standard way to state the return of a fund, a portfolio or a backtest over several years.

CAGR is useful because it lets two investments held for different lengths of time be compared on one scale. It is also the most compressed number in investing. It keeps the start and the end and throws away everything in between. This lesson shows how to calculate it, why it is always lower than the average of the yearly returns, and what it leaves out, using 33 years of SPY, the oldest S&P 500 exchange-traded fund (it began trading in January 1993).

The idea

Suppose an account grows from $10,000 to $20,000 in six years. One way to describe that is "it doubled", but a doubling in six years and a doubling in twenty are very different investments. Dividing the 100% gain by six years gives 16.7% a year, which is wrong, because it ignores compounding: 16.7% a year for six years would turn $10,000 into more than $25,000.

CAGR asks the question the right way round. What fixed rate, applied to a growing balance year after year, lands exactly on the ending value? For a doubling in six years the answer is 12.2%. The figure draws the idea on real data: the jagged line is what $10,000 in SPY actually did, and the straight line is the steady rate that starts and ends at the same two points.

$10,000 in SPY with dividends reinvested, 1993–2026 (log scale) $10,000 $20,000 $50,000 $100,000 $200,000 What happened A steady 10.8% a year (the CAGR) 1995 2000 2005 2010 2015 2020 2025
SPY monthly closes with dividends reinvested, February 1993 to October 2026, log scale. The straight line is the CAGR: the steady rate with the same start and end.

On a log scale a constant growth rate is a straight line, which is why the CAGR line is straight. The real line crosses it many times. In early 2009 the fund was worth far less than the steady line implied, and by 2026 the two met again. CAGR is the slope between the first and last points and nothing else.

How it works

The formula is the compound-interest formula solved for the rate. Compound interest: how growth on growth builds wealth explains the forward direction: start × (1 + rate) ^ years = end. Divide by the start, take the root, subtract one.

A worked example on SPY

The data: SPY's month-end closes from the end of February 1993 to the end of October 2026, with every dividend reinvested at the close of the month it was paid for. That is 404 months, or 33.67 years.

  1. Starting value $10,000, ending value $312,724. The ratio is 31.27.
  2. One divided by the number of years is 1 ÷ 33.67 = 0.0297.
  3. 31.27 raised to the power 0.0297 is 1.1077.
  4. Subtract one: the CAGR is 10.8%.

Checking it forward: $10,000 × 1.1077 ^ 33.67 is $312,700, the ending value within rounding.

Dividends matter to the result. Using the price alone, with no dividends, the same period gives a CAGR of 8.8%. Two points a year over 33 years is the difference between $312,724 and about $170,000. A CAGR quoted without saying whether dividends are included is half a number.

From a total return to a CAGR

Many screens show a return over a period, not a yearly rate. Converting is one line:

  • A fund up 44% over two years: 1.44 ^ (1 ÷ 2) − 1 = 20% a year, not 22%.
  • A fund up 150% over ten years: 2.5 ^ (1 ÷ 10) − 1 = 9.6% a year, not 15%.
  • A fund down 30% over three years: 0.70 ^ (1 ÷ 3) − 1 = −11.2% a year.

For periods shorter than a year the convention is not to annualize at all. A fund that gains 5% in one month has not "returned 80% a year"; the performance standards used by asset managers (GIPS) prohibit annualizing periods of less than a year for that reason.

Why CAGR is lower than the average return

There are two ways to average yearly returns, and they give different answers.

  • The arithmetic average adds the yearly returns and divides by the number of years.
  • The geometric average multiplies the yearly growth factors and takes the root. That is the CAGR.

A two-year example shows the difference. A portfolio gains 50% and then loses 50%. The arithmetic average is zero. But $100 became $150 and then $75, so the CAGR is 0.75 ^ (1 ÷ 2) − 1 = −13.4%. The average says nothing happened; the investor lost a quarter of the money.

The same thing happens in real data, less dramatically. Over SPY's 32 full calendar years from 1994 to 2025, the arithmetic average of the yearly returns was 12.3%, and the compound rate over those same years was 10.7%. The 1.6-point gap is the cost of the ups and downs, sometimes called volatility drag. A useful approximation is:

Average yearly return against CAGR, 2005–2026 Average return (monthly × 12) CAGR 11.3% 10.7% SPY 15.6% 14.8% QQQ 7.3% 6.0% EFA 3.0% 2.9% AGG 3.9% 3.0% TLT 11.1% 10.1% GLD Monthly total returns, dividends reinvested. The gap grows with volatility.
Six funds, January 2005 to October 2026, monthly total returns. The average return is the monthly average times 12; the CAGR is what an investor actually compounded at.

The figure compares six funds over January 2005 to October 2026. For AGG, a bond fund with volatility of 4.5%, the average and the CAGR are almost the same: 3.0% and 2.9%. For EFA, foreign stocks with volatility of 16.7%, the average is 7.3% and the CAGR 6.0%. For TLT, long Treasury bonds, an average of 3.9% turned into a CAGR of 3.0%. Volatility and standard deviation: how investment risk is measured covers the volatility number itself.

The practical rule: the arithmetic average is the right number for "what is a typical single year?" and the CAGR is the right number for "what did my money actually do?" Fund fact sheets and backtests should quote CAGR. When someone quotes an "average annual return", it is worth asking which one they mean.

Where it fails or misleads

It hides the path

SPY's CAGR of 10.8% suggests a calm climb. The yearly results ranged from −36.8% in 2008 to +38.8% in 1995. Six of the 32 full years were negative, and only two years finished within two points of the CAGR. Along the way the fund fell by half, from October 2007 to February 2009. Two funds with the same CAGR can be very different to own, which is why CAGR is read beside Maximum drawdown (MDD): the worst fall from a peak, and the way back and volatility, never alone.

It depends on the end points

Because CAGR uses only two prices, moving either one changes it. The table uses the same fund and the same end date, October 2026.

Money invested at the end of Years CAGR $10,000 became
February 1993 (start of the data) 33.7 10.8% $312,724
March 2000 (a market peak) 26.6 8.2% $80,229
October 2007 (a market peak) 19.0 10.7% $69,134
February 2009 (a market low) 17.7 16.1% $140,451
October 2016 (ten years ago) 10.0 15.3% $41,619

Starting at the 2009 low doubles the rate compared with starting at the 2000 peak. Over the 285 ten-year windows in the data, the ten-year CAGR ranged from −3.4% a year (the ten years to February 2009) to +16.6% a year (the ten years to February 2019), and 24 of those windows were negative. A CAGR that begins at a famous low or ends at a record high is the most flattering one available. An honest presentation shows several periods.

It ignores money added or taken out

CAGR assumes one deposit and no withdrawals. If money is added along the way, as with monthly saving, the account's ending value divided by its starting value is not a return at all. The measure for that case is the money-weighted return (the internal rate of return), which weights each deposit by how long it was invested. A person who added most of their money just before a fall can have a much lower personal return than the fund's CAGR.

It is not a forecast

A past CAGR is a fact about one stretch of history. Projecting it forward assumes the next period will resemble the last, including its starting valuations and interest rates. The CAGR of the ten years to 2019 was a poor guide to anything except those ten years.

Costs, taxes and inflation

The examples here leave out trading costs and taxes, and they are in nominal dollars. A CAGR after inflation (a real CAGR) is lower by roughly the inflation rate; Inflation and real returns: what an investment earns after prices works through that adjustment.

Compared with its neighbours

Measure What it answers What it ignores
Total return How much did it gain over the whole period? How long it took
CAGR What steady yearly rate gives that gain? The path, deposits and withdrawals
Arithmetic average return What was a typical single year? Compounding; overstates what was earned
Money-weighted return What did this investor's own dollars earn? Comparability between investors
Real (after-inflation) CAGR How fast did purchasing power grow? Nothing extra, but it needs an inflation series

How Finabase does it

Finabase does not print a CAGR anywhere. What it shows are returns over fixed periods, and those are price changes without dividends:

  • Symbol pages show a year-to-date and a one-year return in the summary.
  • The screener and comparison tables have columns for one week, one, three and six months, year to date, one year and two years. Each is (last price − price at the start of the period) ÷ price at the start.
  • The comparison chart redraws each symbol as a percent change from the first bar on screen, so the right-hand end of each line is its total price return over the range chosen.
  • A portfolio's report lists profit and return for periods from one day to two years and for all time. These are totals, not yearly rates.

To turn any of these into a CAGR, apply the formula. A two-year return of 44% is 20% a year. The one-year figure is already a yearly rate. The year-to-date figure should not be annualized. For a fund that pays a meaningful dividend, add the yield back in your head: a bond fund's price return can be negative in a year when its total return was positive.

Frequently asked questions

What is a good CAGR?

There is no universal answer, only comparisons. Over January 2005 to October 2026, SPY compounded at 10.7% with dividends, a broad US bond fund (AGG) at 2.9% and gold (GLD) at 10.1%. A CAGR means little without the period, the risk taken to earn it and what a plain index fund did over the same dates.

Is CAGR the same as the annualized return?

For a single deposit with no withdrawals, yes: "annualized return", "geometric average return" and CAGR are the same calculation. "Average annual return" is ambiguous and sometimes means the arithmetic average, which is higher.

Can CAGR be negative?

Yes. If the ending value is below the starting value the ratio is below one and the result is negative. SPY's CAGR over the ten years to February 2009 was −3.4% a year, with dividends included.

How do I calculate CAGR in a spreadsheet?

Use =(end/start)^(1/years)-1. Spreadsheets also have a function, RRI(periods, start, end), that returns the same number. For a series of deposits on known dates, XIRR gives the money-weighted return instead.

Why does my own return differ from the fund's CAGR?

Usually because of timing and cash flows. The fund's CAGR assumes one purchase at the start. Buying more after prices have risen, or selling after they have fallen, produces a different personal result even though the fund's own figure is unchanged.

Summary

CAGR compresses any period into one compounded yearly rate: the ending value over the starting value, to the power one over the years, minus one. $10,000 in SPY grew to $312,724 between February 1993 and October 2026, a CAGR of 10.8% with dividends and 8.8% without. The number is lower than the average yearly return because volatility costs compound growth, it moves by several points when the start date moves, and it hides falls as deep as a half. Read it with the dates, with the dividends question answered, and beside a measure of risk.

Check your understanding

5 questions on this lesson. Each answer comes with the reason, and nothing is scored.

  1. A fund gains 100% in the first year and loses 50% in the second. What is its CAGR over the two years?

    1. 25%, the average of +100% and −50%
    2. 0%
    3. −13.4%
    Show the answer

    B. 0% $100 becomes $200 and then $100 again, so the ending value equals the starting value and the CAGR is zero. The arithmetic average of the two years is +25%, which is why the arithmetic average overstates what an investor earned.

  2. A screen shows that a stock is up 44% over two years. What is that as a CAGR?

    1. 22% a year
    2. 20% a year
    3. 44% a year
    Show the answer

    B. 20% a year CAGR = 1.44 ^ (1 ÷ 2) − 1 = 0.20. Dividing 44% by two ignores compounding: 22% a year for two years would be a 48.8% gain.

  3. Two funds both have a 10-year CAGR of 9%. What can you conclude?

    1. They were equally risky
    2. An investor with one deposit ended with the same amount in each, and nothing more
    3. They will both return about 9% a year over the next ten years
    Show the answer

    B. An investor with one deposit ended with the same amount in each, and nothing more CAGR uses only the starting and ending values. One fund may have fallen by half on the way and the other by a tenth. It also says nothing about the future.

  4. Why was SPY’s CAGR from March 2000 (8.2%) so much lower than from February 2009 (16.1%), to the same end date?

    1. The fund charged higher fees before 2009
    2. The first period starts at a market peak and the second at a market low
    3. Dividends were not paid before 2009
    Show the answer

    B. The first period starts at a market peak and the second at a market low CAGR depends only on the two end points. Starting from a high price lowers it and starting from a low price raises it, which is why a single CAGR should be read with its dates.

  5. A fund’s monthly returns average 1% and its volatility is high. How does its CAGR compare with 12% a year?

    1. Lower, because losses and gains do not cancel when compounded
    2. Higher, because compounding adds to the average
    3. The same; the average and the CAGR always agree
    Show the answer

    A. Lower, because losses and gains do not cancel when compounded The compound rate is roughly the arithmetic average minus half the variance. The more a fund swings, the further its CAGR falls below its average return.

Exercise

One task to do in Finabase. Nothing is graded or saved.

Open SPY’s Price history tab and choose 2Y. The table is newest first: write down the Close in the top row and the Close in the bottom row. Divide the newest by the oldest and apply the lesson’s formula with two years: ratio ^ (1 ÷ 2) − 1, which is a square root minus one. How does the result compare with simply halving the two-year percentage change?

Open SPY’s price history
What you should find

The compound rate is always below the halved figure: a 44% gain over two years is 20% a year, not 22%. The table holds prices only, so the result leaves out dividends, which added about two points a year to SPY’s CAGR since 1993. It also describes these two dates only; move either one and the rate changes.

Sources and further reading

  1. U.S. Securities and Exchange Commission, Investor.gov — Compound interest calculator
  2. State Street Global Advisors — SPDR S&P 500 ETF Trust (SPY), fund page (inception January 22, 1993)
  3. CFA Institute, Global Investment Performance Standards (GIPS) for Firms (2020) — annualizing returns for periods of one year or longer
  4. Zvi Bodie, Alex Kane and Alan J. Marcus, Investments, 12th ed. (McGraw-Hill, 2021) — arithmetic and geometric average returns
  5. Finabase chart data — SPY, QQQ, EFA, AGG, TLT and GLD monthly bars and dividends through October 2026; returns computed by Finabase