Home → Blog → CAGR Explained: Meaning, Formula and a Worked Example

Multi-Broker Integration

CAGR Explained: Meaning, Formula and a Worked Example

CAGR is the steady yearly rate that takes a value from start to end. The formula, a worked example you can check by hand, the Excel version, and when CAGR stops being the right number.

Jordan Doyle

November 11, 2026

A smooth growth curve drawn beside an uneven one, illustrating what CAGR smooths out
Quick answer

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) − 1

The 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.

Example 1 — the CAGR calculation (illustrative example, not real data)

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.

Example 2 — simple average vs CAGR (illustrative example, not real data)

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) − 1

The 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.

What is a good CAGR?

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.

Can CAGR be negative?

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.

Does CAGR include dividends?

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.

How many years do I need for CAGR?

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

  1. Microsoft Support — RRI function
  2. Microsoft Support — POWER function
  3. Google Docs Editors Help — RRI function (Google Sheets)

Last verified: 11 November 2026. Examples use invented round numbers and are not real data.

PRIVATE WEALTH COPILOT

One operating view for your wealth

Avex AI helps self-directed investors unify accounts, parse statements, spot concentration risk, and model what to add, trim, or rebalance next. Built for sophisticated retail investors.

Avex AI provides software for portfolio analysis, scenario modeling, and stress-testing. We are not a regulated investment advisor, broker, or financial planner. Nothing in this article constitutes investment advice, a recommendation, or a solicitation to buy or sell any security. Past performance does not guarantee future results. Consult an authorized financial advisor before making investment decisions. Capital at risk. See our full Editorial Standards for details.

Table of Contents