CAGR vs. Average Return: The Volatility Drag Calculator

Problem statement and target quantities

Given a return sequence or stylized bull/bear cycle, determine the compounded growth rate that maps to terminal wealth and quantify the volatility penalty versus arithmetic average return.

Knowns: periodic returns, initial wealth, horizon, fee assumptions. Unknowns: CAGR, drag in basis points, and wealth-path divergence.

Assumptions and unit discipline

• Returns are expressed in decimal form per period (for example 0.35 for 35%).
• CAGR rows assume full reinvestment with no intermediate external cash flows unless modeled explicitly.
• The μ-σ^2/2 relation is an approximation; rely on exact geometric compounding for decisions.
• Keep units coherent: percentages for reporting, decimals for computation, and basis points for drag communication.

Derivation: from wealth recursion to volatility drag

Start with multiplicative wealth dynamics W_n=W_0∏_i(1+r_i). The annualized geometric rate is the unique scalar g such that W_n=W_0(1+g)^n, giving the exact CAGR relation.

W_n = W_0 * product(1 + r_i)
CAGR = (W_n / W_0)^(1/n) - 1

For approximation intuition, apply a second-order expansion to log growth: E[log(1+r)] ≈ μ - σ^2/2. This is why volatility lowers long-horizon compounded return even when arithmetic average is unchanged.

1. The Simple Explanation: The "Loss Trap"

If you are confused by "Geometric Mean," just remember this rule: losses hit harder than gains.

Imagine you have USD 100.

• Year 1: You lose 50%. (You now have USD 50).
• Year 2: You gain 50%. (50% of USD 50 is USD 25. You now have USD 75).

The Trap: The average of -50% and +50% is 0%, so a headline average suggests “no change.”
The Reality: You end with USD 75. Compounding is path-dependent, so equal up/down percentages do not cancel.

2. Calculating Your Real Growth (CAGR)

Arithmetic mean is useful for expectation math, but CAGR is the quantity that maps directly to terminal wealth. If your goal is planning real portfolio growth, CAGR is the primary metric.

With return volatility, CAGR will generally sit below arithmetic average. That gap is the economic cost of variance on compounded growth.

3. The Formula: The Cost of Variance

For intuition, use the approximation below. It is most reliable for moderate volatility and short horizons.

What this means for you:

• $\mu$ (Average Return): The headline number funds advertise.
• $\frac{\sigma^2}{2}$ (The Drag): The penalty you pay for instability.

As variance rises, the drag term rises, reducing long-run compounded growth even if the headline average return remains unchanged.

4. Case Study: The USD 2M Portfolio

Let's look at a realistic scenario for a volatile asset vs. a stable asset. Imagine a USD 2,000,000 portfolio alternating between +35% and -20%.

5. Run the Simulator

Use the template to change bull/bear scenarios, add fee drag, and compare wealth paths side by side. The self-check rows help you confirm your scenario math before using outputs in planning discussions.

Appendix: Advanced Derivation

For the quantitative analysts: The approximation $R_G \approx \mu - \sigma^2/2$ is derived from the second-order Taylor expansion of the logarithmic return function $\ln(1+r)$.

Since $\ln(1+x) \approx x - x^2/2$, the expected log-return (continuously compounded return) is approximately the arithmetic mean minus half the variance. This explains why geometric returns are asymptotically lower than arithmetic means in the presence of noise.

Variable glossary and finance interpretation

How to interpret the results

• cagr_identity_error near zero confirms geometric-mean arithmetic is internally consistent.
• The gap between wealth_avg and wealth_real visualizes compounding loss from volatility.
• wealth_net shows how even small annual fees compound into large long-horizon differences.

Common mistakes and how to avoid them

• Forecasting portfolio growth with arithmetic averages instead of geometric compounding.
• Ignoring sequence risk and regime changes when using a single historical average.
• Applying the small-variance approximation as exact truth in highly volatile return series.

Worked example (interpreted)

When this model is invalid

How to validate your worksheet

• cagr_identity_error should remain near zero.
• approx_error quantifies approximation bias directly.
• regime_shift_proxy compares baseline and alternate-cycle geometric growth.

Domain-specific variants in this template

Fee-adjusted CAGR (net_cagr) and alternate-volatility branch rows show how small changes in dispersion and fees alter long-horizon wealth.

Practice problems (with answer outlines)

References and standards

• Bodie, Kane, Marcus, Investments (geometric vs arithmetic return treatment). Book page.
• CFA Institute GIPS Standards (performance reporting context). GIPS standards.
• Bernstein, The Intelligent Asset Allocator (practical compounding/risk interpretation). Reference page.