What CAGR means and how to calculate it
CAGR stands for compound annual growth rate. It is the steady yearly growth rate that would take a starting amount to an ending amount over a given number of years. It smooths out the ups and downs into one figure per year.
It is the main return figure on our ticker pages, because it lets you compare a strategy with buying and holding on the same scale, even when the two were tested over different lengths of time.
The formula
CAGR = (ending value ÷ starting value) raised to the power of (1 ÷ number of years), minus 1.
In a spreadsheet, if the starting value is in A1, the ending value in B1 and the number of years in C1, type =(B1/A1)^(1/C1)-1 and format the cell as a percentage.
A worked example
This is an illustration, not a real investment. Say £1,000 grew to £2,000 over 10 years. The ending value divided by the starting value is 2. Two raised to the power of one tenth is about 1.072. Take away 1 and the CAGR is about 7.2% a year.
Notice that this is not 10% a year, even though the money doubled over 10 years. Simple division (100% ÷ 10 years) ignores compounding. Growth in later years builds on growth from earlier years, so a lower yearly rate is enough to double the money.
Why CAGR is not the average yearly return
Suppose an investment rises 50% one year and falls 50% the next. The average of the two yearly returns is zero. But £1,000 becomes £1,500 and then £750, a loss of a quarter. The CAGR over the two years is about minus 13% a year.
That gap is why CAGR is the better summary of what actually happened to the money. Averages of yearly returns flatter anything that swings a lot.
What CAGR leaves out
The path. Two investments with the same CAGR can have very different journeys: one steady, one falling by half along the way. Read CAGR beside the maximum drawdown, the largest fall from a peak.
Additions and withdrawals. CAGR assumes one sum in at the start and nothing added or taken out. If you added money regularly, a money-weighted return describes your own experience better.
Costs and tax, unless they were included. Our headline figures assume no trading costs, so real results would be lower.
How we use it
Each ticker page shows the median strategy CAGR across its backtests next to the CAGR of buying and holding the same ticker over the same dates. On SPY, the median backtest grew at 1.3% a year against 10.8% a year for holding. On NVDA the figures are 8.3% against 36.4%. On GLD, the gold fund, 1.8% against 10.3%.
Figures are from the StrategyLens published cards, updated 29 October 2026. They are hypothetical backtests with no trading costs, before tax, and they will change as the cards are refreshed.
In each case holding grew faster. That is the pattern across most of what we test, and CAGR is the figure that makes it plain.
Quick reference
Doubling in 5 years is about 14.9% a year. Doubling in 10 years is about 7.2% a year. Doubling in 20 years is about 3.5% a year. These come straight from the formula above, and they are a useful check on any growth figure you are shown.
Comparing a strategy with holding
The fair way to use CAGR is to compare two things over exactly the same dates. A strategy tested from 2010 to 2020 cannot be compared with holding from 2000 to 2020, because the two periods saw very different markets. Our ticker pages always compare the strategy with buying and holding the same ticker over the same dates for this reason.
Small gaps in CAGR add up. Over 20 years, £1,000 growing at 5% a year becomes about £2,650. At 7% a year it becomes about £3,870. At 10% a year it becomes about £6,730. These are illustrations from the formula, not forecasts, but they show why a few points of CAGR matter more than they seem.
The same arithmetic works against costs. A fee of 1% a year taken from a 7% return leaves 6%, and over 20 years that turns about £3,870 into about £3,210. When a strategy trades often, its costs can easily take more than that, which is why our pages say clearly that the headline figures assume no trading costs.
CAGR over short periods
CAGR becomes less useful the shorter the period. Over one or two years, a single good or bad month can dominate it, and quoting it as a yearly rate can make a short lucky run look like a lasting trend. Over periods under a year, it is usually clearer to quote the plain percentage change rather than annualise it.
The tested periods on our ticker pages run from about 2 to nearly 65 years, depending on how long each ticker has traded. The page states the length, so you can judge how much weight the CAGR can bear.
This is research, not financial advice. Past results, real or simulated, do not tell you what will happen next.
What does CAGR stand for?
Compound annual growth rate: the steady yearly rate that would take a starting value to an ending value over a set number of years.
How do you calculate CAGR in Excel or Google Sheets?
Use =(end/start)^(1/years)-1, with the ending value, starting value and number of years in cells, and format the result as a percentage.
Is CAGR the same as average annual return?
No. An average of yearly returns ignores compounding and flatters anything that swings a lot. CAGR describes what actually happened to the money from start to end.