Step-by-step guide to calculating CAGR with worked examples. Learn when to use CAGR, its formula, common pitfalls, and how it differs from average return. Free, no signup.
CAGR = (End Value / Start Value)^(1 / years) − 1
CAGR is the constant annual rate at which an investment would have grown if it had grown at the same rate every year. It smooths out volatility to give you a single comparable number — like saying 'this investment returned 9.6% per year on average, compounded annually'.
CAGR assumes a single lump-sum investment at the start. For 401(k)s, IRAs, or any account with periodic contributions, CAGR understates the true return because it ignores the new money.
Fix: Use XIRR (Extended Internal Rate of Return) in Excel/Google Sheets. It accounts for the timing of each cash flow. Our investment return calculator uses a simplified XIRR-style calculation.
An S&P 500 CAGR of 10% from 2010-2020 (a bull market) is not directly comparable to a 10% CAGR from 2000-2010 (which included the dot-com crash and 2008 financial crisis).
Fix: Always state the time period when comparing CAGRs. A 10% CAGR over 5 years during a bull market ≠ 10% CAGR over 20 years including recessions.
If your investment returned 7% in price appreciation but paid 2% in dividends, your total return CAGR is 9%, not 7%. Similarly, a 1% expense ratio reduces your real CAGR by 1% per year.
Fix: Use total return (price + dividends) and subtract fees. For S&P 500, the historical CAGR is ~10% with dividends reinvested, not the 7% price-only number.
CAGR is backward-looking. The S&P 500's 10% historical CAGR does NOT mean it will return 10% over the next 10 years. Future returns depend on valuations, economic conditions, and corporate earnings.
Fix: Use historical CAGR as one input among many. For projections, use Monte Carlo simulations with a range of possible returns (e.g., 5%, 8%, 11%, 14%) rather than a single point estimate.
The S&P 500 has historically returned ~10% CAGR (with dividends reinvested) over long periods. A 'good' CAGR depends on the asset class: stocks 7-10%, bonds 3-5%, real estate 4-8%, savings accounts 1-5%. Risk-adjusted returns (Sharpe ratio) matter more than raw CAGR.
Average return is the arithmetic mean of yearly returns. CAGR is the geometric mean (compounded). Example: +100% year 1, −50% year 2 = 0% average, but −29.3% CAGR. CAGR is always lower than average return for volatile investments. CAGR is the correct measure of actual growth.
Yes. A negative CAGR means the investment lost value on an annualized basis. Example: a stock that drops from $100 to $50 over 3 years has a CAGR of −20.6%. A stock that drops from $100 to $90 over 1 year has a CAGR of −10%.
CAGR describes investment growth over multiple years. APY (Annual Percentage Yield) describes the annualized return on a deposit or loan, including compounding. CAGR is typically calculated for investments with buy/sell dates; APY is given for savings accounts, CDs, and loans.
Formula: =(End Value / Start Value)^(1 / years) − 1. Example: =((25000/10000)^(1/10))-1 returns 0.0960 (9.60%). For accounts with periodic contributions, use the XIRR function with dates and cash flows.
Use CAGR for lump-sum investments you can hold throughout the period. Use IRR (or XIRR) for investments with multiple cash flows — like a 401(k) with monthly contributions, a rental property with ongoing expenses, or a business investment. IRR handles the timing of each cash flow, which is critical for accurate returns.
Compounding is the engine of retirement wealth. A 1% higher CAGR over 30 years can mean 30%+ more retirement savings. If you start with $10K, contribute $500/month for 30 years: at 7% CAGR you have ~$680K; at 8% CAGR you have ~$890K. That's a $210K difference from one percentage point of return.
See your exact investment return with our free calculator — handles dividends, taxes, and contributions.