Glossary · returns

CAGR (Compound Annual Growth Rate): Meaning, Formula and Calculator

CAGR is the steady yearly rate that would take a starting value to an ending value, as if it had grown by the same percentage every year. The formula is (end ÷ start)1/years − 1. Real investments never grow in a straight line; CAGR tells you the one rate that would have got you to the same place.

$10,000 in SPDR S&P 500 ETF Trust (SPY), dividends reinvested
Put in, 26 October 2016$10,000
Worth, 26 October 2026$41,959
Grew by4.20× · +319.6%
CAGR15.42%a year for 10 years: 4.19591/10 − 1
What $10,000 was actually worthGrowing 15.42% every year

Both lines start at $10,000 and end at $41,959. The real one fell 33.7% from 19 February to 23 March 2020 and lost 18% in 2022; the smooth one never dips. That is what CAGR gives you: one honest rate for the whole trip, with the bumps left out.

CAGR calculator

Work out the CAGR, or turn it around: the value you'd end with, the amount you'd need to start with, or how many years a rate takes.

$
$
Compound annual growth rate
15.42% a year

Total growth+319.59%
Multiple4.20×
Doubles every4.8 years

With dates, the years are the days between them ÷ 365.25, the way the AllInvestView dashboard counts them. Use the value at the end, with dividends included if you reinvested them, and keep deposits out: CAGR is for one amount in and one value out.

How to calculate CAGR in three steps

The SPY decade from the top of the page, $10,000 to $41,959 in 10 years.

CAGR = (Ending value ÷ Beginning value)1 / years − 1
1

Divide the end by the start

$41,959 ÷ $10,000. This is the growth multiple: every dollar became this many.

4.1959
2

Take the root for the years

Raise it to the power of 1 ÷ 10, the tenth root. It's the number that, multiplied by itself 10 times, gives 4.1959.

1.1542
3

Subtract 1

What's left is the yearly growth. Check it: $10,000 × 1.154210 comes back to $41,959.

15.42% a year

Turn it around

The same formula solves for any piece. End value = start × (1 + CAGR)years. Start value = end ÷ (1 + CAGR)years. Years = ln(end ÷ start) ÷ ln(1 + CAGR).

So to have $100,000 in 15 years at 7% a year, you need $36,245 today. The calculator's other tabs do exactly this.

Years don't have to be whole

From 4 January 2021 to 17 July 2026 is 2,020 days, or 5.53 years. A portfolio whose value grew 1.818 times over that stretch has a CAGR of 1.8181/5.53 − 1 = 11.41%, the figure in the dashboard capture below.

For a rough check in your head, the rule of 72 says money doubles in about 72 ÷ CAGR years: 72 ÷ 15.42 ≈ 4.7.

CAGR formula in Excel and Google Sheets

Starting value in A2, ending value in B2, years in C2. All three give 15.42% for the SPY example; format the cell as a percentage.

Any spreadsheet=(B2/A2)^(1/C2)-1

The formula exactly as written above. Works in Excel, Google Sheets, Numbers and LibreOffice.

Excel and Sheets=RRI(C2,A2,B2)

RRI is the built-in CAGR function: number of periods, then present value, then future value. Same answer, nothing to get wrong with the brackets.

With two dates=(B2/A2)^(365.25/(E2-D2))-1

Start date in D2 and end date in E2. Dates in a spreadsheet are day counts, so E2-D2 is the number of days between them.

CAGR vs average annual return

The average of the yearly returns is not what you earned. SPY over 2021, 2022 and 2023, with dividends reinvested.

$10,000 at the start of 2021 was $13,294 at the end of 2023. Growing at the 12.25% average would have made $14,145; growing at 9.96% makes $13,294, the real number.

Why the average runs high

A loss hurts more than a gain of the same size helps, because the gain that follows starts from a smaller base. Up 50% and then down 50% averages 0%, but $10,000 becomes $15,000 and then $7,500: a CAGR of −13.4% a year.

Whenever the yearly returns differ, the average comes out higher than the CAGR, and the bigger the swings, the bigger the gap. Over SPY's ten calendar years from 2016 to 2025 the average was 15.81% and the CAGR 14.72%.

A fund's "average annual return" in its factsheet is usually the CAGR. A sum of yearly returns divided by the count, in a pitch or a spreadsheet, usually isn't.

CAGR vs IRR and time-weighted return

CAGR is for one amount in and one value out. Add a deposit and it stops working. $10,000 into SPY on 26 October 2016, another $10,000 on 26 October 2021, worth $59,908 on 26 October 2026.

CalculationResultWhat's wrong or right with it
CAGR on the first deposit($59,908 ÷ $10,000)1/10 − 119.60% a yearToo high: it counts the second $10,000 as if the fund had earned it.
CAGR on everything put in($59,908 ÷ $20,000)1/10 − 111.60% a yearToo low: it pretends the second $10,000 was invested for all ten years, not five.
IRRmoney-weighted, from the dates14.84% a yearWhat your money earned, giving each deposit credit only for the time it was in. More on IRR
Time-weighted returnthe fund itself15.42% a yearHow the investment did with your deposits taken out: SPY's own CAGR over the decade. More on TWR

The IRR comes in below the fund's 15.42% because the second deposit missed the first five years, when SPY grew faster than it has since. With a single deposit and no withdrawals, CAGR, IRR and time-weighted return are all the same 15.42%. For working out a gain as a percentage, or a yearly rate on your own account, the rate of return guide goes step by step.

What is a good CAGR?

There's no single number. A good CAGR beats what a simple alternative earned over exactly the same dates.

Compare on the same dates

A 9% CAGR sounds fine on its own. From October 2016 to October 2026 it would have trailed SPY's 15.42% by more than six points a year, and turned $10,000 into $23,674 instead of $41,959.

For a stock portfolio the usual yardstick is a broad index fund. For a business's revenue, it's the industry or the economy over the same years.

Count the dividends

On price alone, SPY went from $10,000 to $35,808 over the decade, a CAGR of 13.61%. With dividends reinvested it was 15.42%. Comparing a price-only CAGR with someone else's total-return CAGR understates yours by about 1.8 points a year here.

The same goes for any fund you compare against: use its total return, with distributions in.

Where CAGR misleads

CAGR is a clean number for a clean case. Four things catch people out.

The start date picks the answer

SPY's CAGR to 26 October 2026 is 11.8% a year from 3 January 2022, near the old high, and 22.4% a year from 12 October 2022, near the low. Nine months apart, nearly double the rate. Check that a CAGR you're shown doesn't start at a convenient bottom.

11.8% vs 22.4%start Jan vs Oct 2022

It hides the drops

The 15.42% decade included a 33.7% fall in five weeks of 2020. CAGR says nothing about how rough the ride was; for that, look at the maximum drawdown or the standard deviation.

−33.7%Feb to Mar 2020

Short periods blow up

CAGR compounds any gain as if it went on all year. 5% in one month is about 80% a year, and nobody should plan on that. Under a year, quote the plain percentage gain.

≈ 80%a year, from 5% in a month

Deposits break it

Money you add shows up in the ending value as if it were growth. With deposits or withdrawals, use the IRR for what your money earned and the time-weighted return for how the investments did.

19.60%"CAGR" that is really 14.84%

Your portfolio's CAGR, worked out for you

Deposits are exactly what makes CAGR hard on a real portfolio. AllInvestView takes them out for you, time-weighting your returns before it annualizes them, across every broker account you add.

Your portfolio

CAGR (TWR) next to your benchmark

The dashboard's Insights tab shows your portfolio's CAGR beside the benchmark's over the same dates, across every account you add. It is time-weighted: your deposits and withdrawals are taken out, so the number measures the investments, not when you happened to add money. With less than a year of history it shows the return since you started instead of annualizing a few months.

See your portfolio's CAGR
AllInvestView AllInvestView Portfolio Insights from 2021-01-04 to 2026-07-17 with CAGR (TWR) 11.41% and a benchmark of 14.30% AllInvestView Portfolio Insights from 2021-01-04 to 2026-07-17 with CAGR (TWR) 11.41% and a benchmark of 14.30%
A demo portfolio bought from January 2021 to April 2025 with sample prices, against VOO as the benchmark. Staged capture.View full-size View full-size
Year by year

The yearly returns behind the CAGR

The Annual Returns card shows each calendar year on its own, time-weighted, so you can see the swings the single CAGR smooths away. The same portfolio gained 21.91% in 2021 and lost 6.73% in 2022, and compounded at 11.41% a year overall.

See your annual returns
AllInvestView AllInvestView Annual Returns card with time-weighted returns of 21.91% in 2021, -6.73% in 2022, 5.87% in 2023, 11.73% in 2024, 19.00% in 2025 and 13.67% in 2026 to 17 July AllInvestView Annual Returns card with time-weighted returns of 21.91% in 2021, -6.73% in 2022, 5.87% in 2023, 11.73% in 2024, 19.00% in 2025 and 13.67% in 2026 to 17 July
The same demo portfolio, with sample prices. Staged capture.View full-size View full-size
Every broker in one place

See the real growth rate of everything you own

Add the accounts you hold and AllInvestView shows your portfolio's CAGR next to its benchmark, its IRR, and every year's return on its own. No spreadsheet of start and end values to keep up.

CAGR against a benchmark Deposits taken out for you Free plan available

Questions about CAGR

What is CAGR in simple terms?

It's the yearly growth rate that would get you from where you started to where you ended if the investment had grown by the same percentage every year. $10,000 in SPY became $41,959 in ten years, a CAGR of 15.42%: grow $10,000 by 15.42% a year for ten years and you land on $41,959, even though the real path went up and down.

How do you calculate CAGR?

Divide the ending value by the starting value, raise the result to the power of 1 divided by the number of years, and subtract 1. In Excel or Google Sheets that's =(B2/A2)^(1/C2)-1, or =RRI(C2,A2,B2), with the starting value in A2, the ending value in B2 and the years in C2.

What is the difference between CAGR and average annual return?

The average adds up each year's return and divides by the number of years. CAGR is the rate you actually compounded at. SPY returned +28.74%, -18.17% and +26.19% in 2021, 2022 and 2023: the average is 12.25%, but $10,000 grew to $13,294, a CAGR of 9.96%. Whenever the yearly returns differ, the average comes out higher than the CAGR.

Is CAGR the same as IRR?

Only when there is one amount in at the start and one value at the end. Then both are the same yearly rate. Once you add or take out money in between, CAGR has no way to count it and IRR does: it gives each deposit credit only for the time it was invested.

What is a good CAGR?

One that beats what you could have earned in a simple alternative over the same dates, usually an index fund. $10,000 in SPY compounded at 15.42% a year from October 2016 to October 2026, a strong decade for US stocks. A portfolio that did 9% a year over those dates lagged the index by a wide margin, even though 9% sounds good on its own.

Can CAGR be negative?

Yes. If the ending value is below the starting value, the CAGR is negative. $10,000 that falls to $7,500 over two years has a CAGR of -13.4% a year. That's what a 50% gain followed by a 50% loss does: the average return is 0%, but you have lost a quarter of your money.

Should I use CAGR for less than a year?

Usually not. CAGR turns any gain into a yearly rate, so a short burst gets compounded as if it went on all year: 5% in one month is a CAGR of about 80%. For anything held under a year the plain percentage gain says more, and that's what the AllInvestView dashboard shows instead until a portfolio has a year of history.

Sources

Checked on 27 October 2026.

The SPY figures are worked out by AllInvestView from daily closing prices and the fund's dividends, each dividend reinvested at the close on its ex-date, with no trading costs or taxes. The IRR comes from the same solver the product uses. None of it is investment advice.