CAGR Explained: The Right Way to Annualize Growth

If you have ever looked at two investments and wondered which one actually performed better, you have already needed CAGR — even if you did not know the name. A fund that "returned 40% over three years" and another that "averaged 12% per year" are not as easy to compare as they look. CAGR explained properly gives you a single, honest yardstick that accounts for the compounding that happens in real portfolios. This post breaks down what it is, how to calculate it, where it falls short, and what to use when it is not enough.

What CAGR Actually Means

Compound Annual Growth Rate is the hypothetical constant rate at which an investment would have had to grow each year to get from its starting value to its ending value over a given period — assuming all gains are reinvested.

It is not the return you earned in any single year. It is the smoothed annual equivalent of the whole journey.

A concrete example: you invest €10,000. After four years it is worth €17,000.

• Ending / Beginning = 1.70
• 1.70 ^ (1/4) = 1.1430…
• CAGR = 14.30%

That 14.30% is the single annual rate that, compounded four times, turns €10,000 into €17,000. Simple enough — but the implications are easy to misread.

The Averaging Trap CAGR Fixes

Suppose your investment returns are: +50%, −33%, +50%, −33% in four consecutive years. A naive arithmetic average gives you +8.5% per year. Sounds decent. But watch what happens to €10,000:

After four years you have barely more than you started with. The CAGR is roughly 0.25% — not 8.5%.

This gap is called volatility drag: losses hurt proportionally more than equivalent gains help, because a loss shrinks the base that the next gain has to work with. CAGR captures this; arithmetic averages do not. This is exactly why your portfolio return may look better on paper than it really is.

How to Calculate CAGR: Three Approaches

1. The Formula (manual or spreadsheet)

Use the formula above. In a spreadsheet:

= (B2/B1)^(1/C1) - 1

Where B2 is ending value, B1 is beginning value, and C1 is the number of years (which can be fractional — e.g. 2.5 for 30 months).

2. The XIRR Function

If you made additional contributions or withdrawals during the period, the basic CAGR formula breaks down — it only works cleanly with a single lump-sum investment and a single ending value. Excel and Google Sheets both offer XIRR, which handles irregular cash flows and is the spreadsheet equivalent of IRR (Internal Rate of Return).

3. A Portfolio Tracker

Manual calculation works for a single position. Across a full portfolio with dividends reinvested, currency conversions, partial sales and multiple entry points, it becomes impractical fast. A dedicated tracker that calculates IRR per asset is the practical solution — more on that at the end.

CAGR vs. IRR: Know the Difference

CAGR and IRR are closely related but not identical:

For a fund's published track record, CAGR is standard and fine. For your personal return on a stock you bought in three tranches, received dividends from, and partially sold — IRR is what you want. The two converge when there is only one cash flow in and one out.

When CAGR Is Not Enough (and What to Watch For)

Short time horizons. CAGR over one year is just the total return. Compounding needs time to be meaningful.

High-volatility assets. Two assets can share the same CAGR while having wildly different volatility profiles. A 10% CAGR achieved smoothly is not the same experience as a 10% CAGR with 60% drawdowns along the way. Always pair CAGR with a risk measure (standard deviation, max drawdown) before drawing conclusions.

It ignores taxes and costs. A fund with a 10% CAGR and a 1.5% TER (Total Expense Ratio) has an effective CAGR closer to 8.5% in your pocket — and that gap compounds dramatically over decades. Similarly, capital gains taxes (which vary by country and change over time — always verify the rules in your jurisdiction or consult a tax professional) reduce the real value of that headline number.

It does not account for your contributions. If you invest €500 every month into an ETF, the CAGR of the ETF is not your personal return. Your personal return depends on when each contribution went in relative to price movements. This is why tracking your complete net worth across all accounts requires more than a fund's published CAGR.

Benchmark comparisons need the same period. Comparing your portfolio's 3-year CAGR to an index's 5-year CAGR is meaningless. Always align the measurement window.

A Practical CAGR Reference Table

To build intuition, here is what different CAGRs do to €10,000 over time:

The difference between 7% and 10% looks modest in year five. Over twenty years it is the difference between roughly €39,000 and €67,000 on the same starting capital. This is why shaving costs, avoiding unnecessary tax drag, and accurately measuring what you are actually earning — rather than what a fund's fact sheet says — matters so much.

From CAGR to Real Portfolio Intelligence

Understanding CAGR is the foundation. Applying it honestly across a mixed portfolio — stocks bought at different prices, funds tracked by ISIN and NAV, crypto positions in multiple currencies, pension plans with irregular contributions — is where the real work is.

WealthFlow calculates IRR per asset across every position you hold, whether it is a listed stock, an investment fund, a pension plan, or a real-estate crowdfunding stake. Because you enter positions manually (no broker credentials ever required or requested — your data stays yours), every cost basis, dividend and partial sale is recorded exactly as it happened. You can also run a benchmark comparison to see whether your CAGR is beating a relevant index over the same period, and use multi-currency conversion so that a USD-denominated ETF and a EUR pension plan sit on the same footing.

If you want to go further, the Pro plan (9.99 €/month + VAT) includes a FIFO tax-report CSV — useful groundwork before you sit down with a tax adviser, wherever you are based.

Start with the number. Then make sure the number is real.