Average Return
Compute arithmetic and geometric average returns on investments to measure portfolio performance over multiple periods
Formula
Geometric Mean = [(1+R₁) × (1+R₂) × ... × (1+Rₙ)]^(1/n) - 1
Geometric mean calculates true compound return by multiplying growth factors (1 + return rate) for each period, taking the nth root, and subtracting 1. This accounts for compounding and is always more accurate than arithmetic mean for multi-period investment returns.
Worked Examples
Example 1: Why Geometric Mean Matters
Problem:Investment returns: Year 1: +50%, Year 2: -50%. What's the real average return?
Solution:Arithmetic mean: (50 + (-50)) ÷ 2 = 0% Geometric mean: √[(1+0.50) × (1-0.50)] - 1 = √[1.5 × 0.5] - 1 = √0.75 - 1 = 0.866 - 1 = -13.4% Actual result: $100 → $150 (after year 1) $150 → $75 (after year 2) You lost $25 despite 0% arithmetic average! Geometric mean correctly shows -13.4% loss.
Result:Geometric: -13.4% (correct) | Arithmetic: 0% (misleading)
Example 2: Real Portfolio Example
Problem:5-year investment returns: +10%, -5%, +12%, +8%, +15%. What's the true annual growth rate?
Solution:Arithmetic mean: (10 - 5 + 12 + 8 + 15) ÷ 5 = 40 ÷ 5 = 8.0% Geometric mean (CAGR): [(1.10) × (0.95) × (1.12) × (1.08) × (1.15)]^(1/5) - 1 = [1.4536]^0.2 - 1 = 1.0777 - 1 = 0.0777 = 7.77% Geometric mean stays below arithmetic mean because compounding and volatility reduce the true multi-year growth rate. Actual portfolio growth: $10,000 → $14,536 over 5 years CAGR: 7.77%
Result:CAGR: 7.77% (true compound growth)
Example 3: Volatile Portfolio
Problem:Volatile stock returns: +30%, -20%, +25%, -15%, +35%, -10%. Average return?
Solution:Arithmetic: (30 - 20 + 25 - 15 + 35 - 10) ÷ 6 = 45 ÷ 6 = 7.5% Geometric: [(1.30)(0.80)(1.25)(0.85)(1.35)(0.90)]^(1/6) - 1 = [1.3426]^(1/6) - 1 = 1.0503 - 1 = 5.03% Difference: 7.5% - 5.03% = 2.47% High volatility creates a large gap between means. Geometric mean reflects actual compounded returns. Your money grew at 5.03%/year, not 7.5%.
Result:Arithmetic: 7.5% | Geometric: 5.03% (2.47% gap)
Frequently Asked Questions
What's the difference between arithmetic and geometric mean?
Arithmetic mean (simple average): add all returns and divide by number of periods. Shows average of individual returns. Geometric mean (CAGR): accounts for compounding by multiplying growth factors and taking nth root. Shows actual portfolio growth rate. For investments with volatility, geometric is always lower and more accurate for historical performance. Use geometric for 'what happened,' arithmetic for 'average of possibilities.'
Why is geometric mean always lower than arithmetic?
Losses hurt more than equal gains help due to compounding math. Example: +50% then -50% = -25% overall, not 0%. You need +100% to recover from -50% loss! Geometric mean captures this asymmetry. The more volatile the returns, the bigger the gap between means. A perfectly smooth investment (5%, 5%, 5%) has identical arithmetic and geometric means (both 5%). Volatility creates the drag.
Which mean should I use for my investment portfolio?
For historical performance (what happened): Geometric mean (CAGR)—always! Shows true compound growth. For future projections (what might happen): Arithmetic mean of expected scenario returns. Financial advisors typically show both: 'Historical CAGR: 7.2% (geometric), Expected return: 8.5% (arithmetic).' Never use arithmetic to describe past multi-period performance—it's misleading.
Can geometric mean be negative while arithmetic is positive?
Yes! Common with volatile returns and large losses. Example: +100%, -50% has arithmetic of +25% but geometric of 0% (break-even). More extreme: +100%, -70% has arithmetic of +15% but geometric of -19% (lost money). Large loss years devastate geometric mean more than gains boost it. This is why bear markets are so destructive—a -50% year needs +100% to recover. Geometric mean accurately reflects this pain.
How does volatility affect investment returns?
Volatility creates 'drag' on compound returns. Two portfolios with 8% arithmetic mean: Low volatility (7%, 9%, 8%): ~8% geometric. High volatility (+30%, -10%, +10%): ~6.5% geometric. The volatile portfolio underperforms by ~1.5%/year despite same arithmetic average! This is why risk-adjusted returns matter. Lower volatility preserves compound growth. Bonds add value by reducing volatility drag, not just diversification.
Why do mutual funds show both arithmetic and geometric returns?
Regulators require clear labeling. Historical performance must use geometric (CAGR)—what actually happened. 'Expected returns' use arithmetic mean of future scenarios—probability-weighted average. Example: Fund shows '7.2% CAGR (10-year historical)' and '8.5% expected return (forward-looking).' Arithmetic is higher because it represents average of possibilities, not compound reality. Always focus on geometric for past performance.
Can I use arithmetic mean for anything useful?
Yes! Use cases: 1) Forecasting expected returns from probability scenarios. 2) Calculating average of independent events. 3) Statistical analysis of return distribution. 4) Academic financial models. But NEVER use arithmetic to describe what happened to your portfolio over multiple periods. That's what geometric/CAGR is for. Think: arithmetic = future possibilities, geometric = past reality.
What if I have only the starting and ending values, not yearly returns?
Use simplified CAGR formula: (Ending ÷ Starting)^(1/years) - 1. Example: $50k → $100k over 8 years: ($100k÷$50k)^(1/8) - 1 = 2^0.125 - 1 = 1.0905 - 1 = 9.05% CAGR. This gives geometric mean without knowing individual year returns. Note: This assumes no contributions—adjust if you added money throughout period. Use Excel XIRR for contributions/withdrawals.