Is CAGR the same as average return?

No, they are different. The average return simply takes the sum of returns for each year and divides by the number of years. CAGR accounts for compounding, making it a more accurate representation of actual wealth growth.

Can CAGR be negative?

Yes. If the ending value of an investment is lower than the beginning value, the CAGR will be a negative percentage, indicating an annualized loss over the time period.

When should I use CAGR instead of total ROI?

Use total ROI (Return on Investment) to see your absolute profit percentage. Use CAGR when you need to compare investments held for different lengths of time, or when you want to measure the steady growth rate per year.

Does CAGR account for investment risk or volatility?

No, this is a major limitation. CAGR assumes a smooth, steady growth rate and completely hides the volatility (ups and downs) the investment experienced between the start and end dates.

How do I calculate CAGR in Excel or Google Sheets?

You can use the RRI function: =RRI(number_of_periods, present_value, future_value). Alternatively, you can write the raw formula: =(End_Value/Start_Value)^(1/Years) - 1.

How to Calculate Annualized Return (CAGR)

A complete guide to understanding, calculating, and utilizing the Compound Annual Growth Rate to evaluate your portfolio's true performance.

What Is Annualized Return?

When you look at an investment's performance over several years, a simple total return percentage doesn't tell the whole story. For instance, a 50% return sounds great, but if it took 15 years to achieve, the investment actually performed quite poorly. If it took 2 years, it performed spectacularly.

Annualized Return, most commonly referred to as the Compound Annual Growth Rate (CAGR), solves this problem. It is the geometric progression ratio that provides a constant rate of return over a specific time period. It essentially answers the question: "If this investment grew at a steady, fixed rate every year, what would that rate be?"

The CAGR Formula

To calculate the Compound Annual Growth Rate, you need three pieces of information: the beginning value of the investment, the ending value, and the number of years it was held. The formula is:

CAGR = [ (Ending Value / Beginning Value) ^ (1 / Number of Years) ] - 1

Let's break down the mathematical steps:

Divide the Ending Value by the Beginning Value.
Raise the result to the power of one divided by the number of years.
Subtract 1 from the subsequent result.
Multiply by 100 to convert the final decimal to a percentage.

CAGR vs. Average Annual Return

It is crucial not to confuse CAGR with the arithmetic Average Annual Return. In investing, the average return is dangerously misleading due to the effects of compounding and volatility.

Imagine a $10,000 investment. In Year 1, it drops by 50% to $5,000. In Year 2, it rebounds by 100% back to $10,000.

Average Return: (-50% + 100%) / 2 = +25%. The average suggests you made a massive profit.
CAGR: You started with $10k and ended with $10k after 2 years. The CAGR is exactly 0%.

As this extreme example shows, average return ignores the reality of math, while CAGR accurately reflects what happened to your wealth.

Why CAGR Matters for Investors

CAGR is arguably the most important metric for evaluating long-term performance because:

It standardizes returns: It allows you to directly compare an investment held for 3 years with one held for 7 years.
It incorporates compounding: It reflects the reality that returns in Year 2 are generated on the principal plus the gains from Year 1.
It sets realistic expectations: By looking at the 10-year or 20-year CAGR of an index like the S&P 500, investors can set realistic goals for their financial planning, rather than expecting unsustainable short-term spikes.

Step-by-Step Calculation Examples

Example 1: Positive Returns
You invest $5,000 into a mutual fund. Five years later, the account balance is $8,200.

Ending Value: $8,200
Beginning Value: $5,000
Years: 5
CAGR = [ (8,200 / 5,000) ^ (1 / 5) ] - 1
CAGR = [ 1.64 ^ 0.2 ] - 1
CAGR = 1.104 - 1 = 0.104 or 10.4%

Example 2: Negative Returns
You buy $2,000 of cryptocurrency. Three years later, it is worth $1,200.

CAGR = [ (1,200 / 2,000) ^ (1 / 3) ] - 1
CAGR = [ 0.6 ^ 0.333 ] - 1
CAGR = 0.843 - 1 = -0.157 or -15.7%

Annualized Return for Different Asset Classes

To provide context, here are the historical, long-term rough CAGR expectations for major asset classes (not adjusted for inflation):

U.S. Large Cap Stocks (S&P 500): ~9% to 10%
U.S. Small Cap Stocks: ~10% to 12%
Long-Term Government Bonds: ~4% to 5%
Real Estate (Housing Market): ~3% to 5%
Cash / Savings Accounts: ~1% to 2% (highly dependent on central bank rates)

Remember, higher CAGR inherently requires accepting higher volatility and risk of capital loss.

Limitations of CAGR

While powerful, CAGR is not perfect and should not be used in isolation:

It ignores volatility: CAGR assumes steady, straight-line growth. It hides the fact that a stock might have plummeted 40% at some point during the holding period. An investment with wild swings and one with steady growth can have the exact same CAGR.
It ignores periodic contributions: The basic CAGR formula assumes a single lump-sum investment at the beginning. If you are adding money monthly (like Dollar Cost Averaging), you need a more complex calculation, such as the Internal Rate of Return (IRR).
Past performance is not future results: A high 5-year CAGR does not guarantee the next 5 years will be similar. In fact, extreme outperformance is often followed by mean reversion.

Using CAGR to Compare Investments

The true utility of CAGR shines when comparing alternatives. If Investment A returned 150% over 8 years, and Investment B returned 75% over 4 years, which is better? Calculating the CAGR reveals:

Investment A CAGR: ~12.1%
Investment B CAGR: ~15.0%

Investment B is actually growing wealth at a faster annualized clip, despite the lower total return number.