CAGR meaning, in one line: CAGR is the steady yearly rate at which a value would have to grow to get from its start value to its end value over a period. It smooths uneven years into one rate. The figure assumes that nothing is added or withdrawn between the start date and the end date, which is the limit to keep in mind when you use it on your own accounts.
Key Takeaways
- What it is: the one constant yearly rate that takes a value from its start to its end over a period.
- The formula: CAGR = (end value ÷ start value) ^ (1 ÷ years) − 1.
- Why it differs from a simple average: it includes compounding, so +50% and −50% do not average to zero.
- When it stops being enough: as soon as money is paid in or taken out along the way.
What is CAGR?
CAGR definition: the constant yearly rate at which an investment would have grown to get from its start value to its end value, with the ups and downs in between smoothed away. What does CAGR stand for? Compound annual growth rate: “compound” because each year’s growth builds on the last, “annual” because the result is expressed per year.
The point of smoothing is comparison. Two investments with different patterns of good and bad years can be put on the same footing by asking what single yearly rate would have produced each result. CAGR answers that question and nothing else: it does not account for deposits or withdrawals made after the start.
The CAGR formula
The CAGR formula takes three numbers and returns a yearly percentage:
CAGR = (end value ÷ start value) ^ (1 ÷ number of years) − 1The start value is what the investment was worth at the beginning of the period. The end value is what it was worth at the end. The number of years is the length of the period between the two dates, and it does not have to be a whole number: a holding kept for eighteen months uses 1.5. The result is a yearly percentage, whether the period was shorter or longer than a year, and it can be worked out for the full holding period or for any stretch inside it.
How to calculate CAGR: a worked example
How to calculate CAGR in four steps: take the start value, take the end value, count the years, and apply the formula. The first example below shows the steps; the second shows why a simple average of yearly returns gives a different, misleading number.
Start value: £10,000. End value after two years: £12,100 (the fund is worth £11,000 after year one and £12,100 after year two). Number of years: 2. Formula: (£12,100 ÷ £10,000) ^ (1 ÷ 2) − 1 = 1.21 ^ 0.5 − 1 = 1.10 − 1 = 10% a year. You can check it by hand: 1.10 × 1.10 = 1.21, so 10% compounded for two years takes £10,000 to £12,100.
The numbers are chosen to make the arithmetic easy. They are not a typical or expected return.
Start value: £10,000. Year one: +50%, so £15,000. Year two: −50%, so £7,500. The simple average of the two yearly returns is (50% + −50%) ÷ 2 = 0%. The CAGR is (£7,500 ÷ £10,000) ^ (1 ÷ 2) − 1 = 0.75 ^ 0.5 − 1 = 0.866 − 1 = approximately −13.4% a year.
The numbers are chosen to make the arithmetic easy. They are not a typical or expected return.
The simple average adds up yearly returns and divides, as if each year started from the same base. It does not: the second year’s −50% applies to a larger amount than the first year’s +50% was earned on. CAGR includes that compounding, which is why it describes what happened to the £10,000 and the average does not.
CAGR in Excel and Google Sheets
The CAGR formula in Excel and Google Sheets can be written two ways, and both give the same result as the formula above.
=RRI(number of years, start value, end value)RRI takes three arguments in this order: the number of periods (the years), the present value (the start value) and the future value (the end value). With the figures from Example 1: =RRI(2, 10000, 12100) returns 0.10, or 10%.
=(end value / start value) ^ (1 / number of years) − 1The second way is the formula typed out with the power operator; =POWER(end value / start value, 1 / number of years) − 1 is the same calculation with the POWER function. Either way, the spreadsheet and the hand calculation agree.
When CAGR is enough, and when money moves in and out
CAGR is enough when one amount is invested at the start and nothing is added or withdrawn until the end. That is the assumption built into the formula: a single start value that grows, on its own, to a single end value.
If money is paid in or taken out along the way, the formula no longer describes what the investor’s own money did, because part of the change in value is the deposits themselves. A different measure is needed then, one that counts the date and the amount of every deposit and withdrawal and gives a yearly rate for the whole set. The comparison of the two approaches, and the question of which return to track, is covered in the pillar article of this series. When money moves in and out, you can work it out with dates instead.
What CAGR does not tell you
Three limits of the number. First, it hides the path: a 10% CAGR says nothing about the rises and falls between the start and the end, only about the two endpoints. Second, it depends on the dates chosen: move the start or the end by a year and the rate changes, because the endpoints change. Third, it says nothing about the future: CAGR describes a period that has already happened and is not a forecast of the next one.
Calculate CAGR for your own numbers
Enter a start value, an end value and the number of years, and the CAGR calculator returns the yearly rate for those figures. Try your own numbers, or run it the other way round to see what yearly rate a target value would require.
There is no single figure. What counts as a good CAGR depends on the period measured, the asset and the risk taken to earn it: different assets carry different risk, which shows up in their rates. No single number is good or bad on its own.
Yes. When the end value is below the start value, the formula returns a negative rate: the steady yearly rate of decline that would take the start value to the end value. Example 2 above shows a CAGR of about −13.4% a year.
Only if they are in the end value. CAGR worked out on a share price alone ignores dividends; CAGR worked out on the total value of a holding with dividends reinvested includes them. Check which value the figure was built from before comparing two holdings.
There is no minimum. The formula works for periods shorter than a year (the number of years is then a fraction) and for periods of many years, over the full holding period or any part of it. Shorter periods produce rates that are more sensitive to the dates chosen.
Sources & references
- Microsoft Support — RRI function
- Microsoft Support — POWER function
- Google Docs Editors Help — RRI function (Google Sheets)
Last verified: 11 November 2026. Examples use invented round numbers and are not real data.