ROI, CAGR, and IRR: How to Calculate and Compare Investment Returns

Why Return Metrics Matter

Every investment promises a return. The challenge is that investments use different metrics, different time horizons, and different risk profiles — making direct comparisons misleading without the right tools. A 50% return sounds excellent until you learn it took 10 years. A 15% annual return sounds reasonable until you discover it came with extreme volatility.

Understanding return metrics is not academic — it is the foundation of every rational investment decision. This guide breaks down the most important metrics, shows you when to use each one, and demonstrates how to compare returns across fundamentally different asset classes.

Return on Investment (ROI): The Starting Point

ROI is the simplest and most widely used return metric. It measures the total gain or loss relative to the initial investment.

The ROI Formula

ROI = (Final Value - Initial Investment) / Initial Investment × 100

Or equivalently:

ROI = (Net Profit / Cost of Investment) × 100

Example: You buy 100 shares at €20 each (€2,000 total). You sell them two years later for €2,700 and received €150 in dividends.

Total return = (€2,700 - €2,000) + €150 = €850
ROI = €850 / €2,000 × 100 = 42.5%

The Critical Weakness of Simple ROI

ROI ignores time. A 42.5% ROI over 2 years is very different from a 42.5% ROI over 10 years. This makes comparing investments with different holding periods impossible using ROI alone.

To compare investments on equal terms, you need annualized returns.

Compound Annual Growth Rate (CAGR)

CAGR answers the question: “What constant annual return would produce the same result?” It is the standard metric for comparing investments over different time periods.

The CAGR Formula

CAGR = (Ending Value / Beginning Value)^(1/n) - 1

Where n = number of years

Example: €10,000 grows to €17,500 over 6 years.

CAGR = (€17,500 / €10,000)^(1/6) - 1
CAGR = (1.75)^(0.1667) - 1
CAGR = 1.0978 - 1
CAGR = 9.78% per year

CAGR vs. Average Annual Return

These are not the same thing, and confusing them is a costly mistake.

Suppose an investment returns +50% in year 1 and -33% in year 2.

• Average annual return: (+50% + -33%) / 2 = +8.5%
• Actual result: €1,000 → €1,500 → €1,005
• CAGR: (€1,005/€1,000)^(0.5) - 1 = 0.25%

The average overstates the actual return by 8.25 percentage points. CAGR reflects reality.

Historical CAGR by Asset Class

Asset Class	10-Year CAGR (approx.)	20-Year CAGR (approx.)	30-Year CAGR (approx.)
Global equities (MSCI World)	8–11%	7–9%	8–10%
US S&P 500	10–13%	8–10%	9–11%
European equities	5–8%	5–7%	6–8%
Government bonds (EUR)	1–3%	3–5%	4–6%
Corporate bonds (EUR)	2–4%	3–5%	4–6%
Real estate (major cities)	4–8%	4–7%	4–6%
Gold	4–8%	5–9%	3–6%
Bitcoin (2013–2023)	~50%+	N/A	N/A

Past returns do not predict future results. Figures represent approximate ranges depending on specific index, region, and measurement period.

Tip: When evaluating a fund manager or strategy, always ask for CAGR over full market cycles (including downturns), not just cherry-picked periods.

Internal Rate of Return (IRR)

IRR is the most sophisticated common return metric. It is the discount rate at which the Net Present Value (NPV) of all cash flows from an investment equals zero. In plain language, IRR tells you the annualized return accounting for the timing of all cash flows.

When IRR Is Essential

CAGR works when you invest a lump sum and receive a lump sum back. Real-world investments are messier — rental properties receive monthly rent, private equity funds have capital calls and distributions at irregular intervals, businesses generate uneven profits. IRR handles all of this.

The IRR Concept

For an investment with multiple cash flows, IRR solves for r in:

0 = CF₀ + CF₁/(1+r)¹ + CF₂/(1+r)² + ... + CFₙ/(1+r)ⁿ

Where:

• CF₀ = initial investment (negative, as it is a cash outflow)
• CF₁ to CFₙ = subsequent cash flows (positive for inflows)
• r = IRR

This equation has no closed-form solution — it requires iteration or a financial calculator.

Example — Rental Property:

Year	Cash Flow
0	-€200,000 (purchase)
1–10	+€12,000/year (net rent)
10	+€280,000 (sale proceeds)

IRR ≈ 9.7% per year (includes both rental income and capital appreciation)

IRR Decision Rule

When evaluating a project or investment, compare the IRR to your hurdle rate (minimum required return):

• IRR > Hurdle Rate → Accept the investment
• IRR < Hurdle Rate → Reject the investment
• Comparing two investments → Prefer higher IRR (with caveat for scale differences)

Warning: IRR assumes intermediate cash flows are reinvested at the IRR rate itself, which is often unrealistic. For a more conservative measure, use Modified IRR (MIRR), which lets you specify a separate reinvestment rate.

Net Present Value (NPV)

NPV converts all future cash flows to today’s money using a discount rate. It answers: “How much value does this investment create in today’s money, above what I could earn from the risk-free alternative?”

The NPV Formula

NPV = Σ [CFₜ / (1 + r)ᵗ] - Initial Investment

Where:

• CFₜ = cash flow in period t
• r = discount rate (your required return)
• t = time period

NPV Interpretation:

• NPV > 0 → Investment creates value above your hurdle rate; accept
• NPV = 0 → Investment exactly meets your hurdle rate; indifferent
• NPV < 0 → Investment destroys value relative to hurdle rate; reject

NPV vs. IRR: Which to Use?

Situation	Preferred Metric
Single investment decision	Either (consistent results usually)
Comparing mutually exclusive projects	NPV (more reliable for scale differences)
Irregular cash flows	IRR or NPV
Ranking multiple independent investments	IRR (when capital is limited)
Quick communication	IRR (more intuitive)

Time-Weighted Return (TWR)

Time-Weighted Return eliminates the distorting effect of external cash flows (deposits and withdrawals). It is the standard method used by fund managers to report performance because it measures the manager’s actual investment skill, not the timing of investor deposits.

When TWR Matters

Suppose a fund returns 20% in January, then you deposit a large sum, and the fund falls 10% in February. Your personal return is much worse than the 20% headline figure. TWR calculates what the fund itself returned, regardless of when you added money.

Money-Weighted Return (MWR / XIRR)

MWR (equivalent to IRR for personal portfolios) reflects your actual experience as an investor, including the timing of your deposits and withdrawals. This is what matters for your personal financial plan — not the fund’s advertised performance.

Use MWR/XIRR in spreadsheets to calculate your actual personal return.

Risk-Adjusted Returns: The Sharpe Ratio

Two investments can have the same return but very different risk profiles. The Sharpe Ratio measures return per unit of risk.

The Sharpe Ratio Formula

Sharpe Ratio = (Portfolio Return - Risk-Free Rate) / Standard Deviation of Returns

Example:

Investment	Annual Return	Risk-Free Rate	Std Deviation	Sharpe Ratio
Stock A	15%	3%	25%	0.48
Stock B	10%	3%	8%	0.88
Bond Fund	5%	3%	3%	0.67

Stock B has a higher Sharpe Ratio than Stock A despite lower returns — it delivers more return per unit of risk taken. For risk-conscious investors, Stock B is the superior choice.

Interpreting Sharpe Ratios:

• Below 1.0: Acceptable but not efficient
• 1.0–2.0: Good
• Above 2.0: Excellent (but verify — can indicate look-back bias)

Comparing Returns Across Asset Classes

Stocks

Return metrics: CAGR (long-term performance), Sharpe Ratio (risk-adjusted efficiency), Dividend Yield (income component)

Historical CAGR (MSCI World, 1970–2023): approximately 9% per year before inflation, approximately 6% after inflation.

Bonds

Return metrics: Yield to Maturity (YTM) is the primary metric, equivalent to IRR for bonds.

Current EUR investment-grade bonds: approximately 3.5%–5.0% yield (2024), after a decade of near-zero yields.

Real Estate

Return metrics: Rental Yield (income return), Capital Appreciation (price return), Total Return (combined), Rental Yield + Appreciation CAGR.

Net rental yield across European cities (after costs, before taxes) typically ranges from 2.5%–6%, with total returns including appreciation of 4%–9% historically in major markets.

City	Gross Rental Yield	Net Yield (est.)	10-Year Price CAGR
Berlin	3.0–4.0%	2.0–3.0%	8–10%
Amsterdam	3.5–4.5%	2.5–3.5%	7–9%
Lisbon	4.5–6.0%	3.5–5.0%	9–12%
Milan	3.0–4.0%	2.0–3.0%	3–5%
Warsaw	5.0–7.0%	4.0–6.0%	6–9%

Cryptocurrency

Return metrics: CAGR dominates, but extreme volatility makes comparison with traditional assets misleading without risk adjustment.

Bitcoin Sharpe Ratio (5-year): approximately 0.6–1.2 depending on measurement period — comparable to equities but with far higher drawdown risk. Bitcoin 2019–2023 CAGR: approximately 35%, but with -80% drawdowns that test conviction.

Warning: Cryptocurrency CAGR figures are highly sensitive to start and end dates. Bitcoin’s CAGR from January 2018 peak to January 2023 was approximately 0% — despite massive intervening volatility. Always examine full cycles, not peak-to-peak periods.

Inflation-Adjusted (Real) Returns

Every return figure should be examined in real terms — after inflation. A 7% nominal return during a 3% inflation period represents a 4% real return. During high-inflation periods, this distinction becomes critical.

Real Return ≈ Nominal Return - Inflation Rate

More precisely (using the Fisher equation):

Real Return = (1 + Nominal Return) / (1 + Inflation Rate) - 1

Historical Real Returns by Asset Class (Global, Long-Term)

Asset Class	Nominal Return (avg)	Avg Inflation	Real Return
Global equities	~9%	~3%	~6%
Government bonds	~5%	~3%	~2%
Cash/Money market	~3.5%	~3%	~0.5%
Gold	~6%	~3%	~3%
Real estate	~7%	~3%	~4%

This is why long-term investors focus on equity-heavy portfolios — the real return advantage over bonds compounds dramatically over decades.

Practical Return Comparison Framework

When evaluating any investment, apply this checklist:

1. Time-normalize – Use CAGR, not total ROI, for comparisons
2. Risk-adjust – Calculate Sharpe Ratio or at least note volatility
3. Include all returns – Dividends, rental income, interest; not just price appreciation
4. Deduct all costs – Management fees, transaction costs, taxes, maintenance
5. Inflation-adjust – Convert to real returns for long-term comparisons
6. Model cash flows with IRR/NPV – For any investment with irregular cash flows
7. Stress test – What was the maximum drawdown? Could you have held through it?

Quick Reference: Which Metric to Use

Question	Metric to Use
How much did I make total?	ROI
What annual rate did I earn?	CAGR
How did the timing of cash flows affect my return?	IRR / XIRR
Is this investment creating value above my hurdle rate?	NPV
How efficient is the return per unit of risk?	Sharpe Ratio
What did I actually earn (as investor, with my timing)?	MWR / XIRR
What is my return after inflation?	Real Return

Conclusion: Building a Return-Aware Investment Framework

The investor who compares a bond fund’s yield to a stock fund’s ROI without adjusting for time, risk, and costs is making decisions in the dark. The investor who uses CAGR, IRR, NPV, and Sharpe Ratio together gets a complete picture.

Use an ROI calculator to quickly assess deals. Use an NPV calculator when analyzing investments with multiple future cash flows. Use compound interest modeling to understand what consistent returns do to capital over decades.

The best investors are not those who chase the highest returns — they are those who consistently earn good risk-adjusted returns across full market cycles. Mastering these metrics puts you in that category.