CAGR Calculator

Compound Annual Growth Rate (CAGR) is the mean annual growth rate of an investment over a specified time period longer than one year, assuming the investment compounded steadily each year.

The mathematical formula for CAGR is:

CAGR = (Ending Value ÷ Beginning Value)^(1 ÷ Number of Years) - 1

Example: If an investment starts at $10,000 and grows to $24,883 over 5 years, the calculation is ($24,883 ÷ $10,000)^(1/5) - 1 = (2.4883)^0.2 - 1 = 20.0% per year. In Excel or Google Sheets, you can compute this with =(Ending_Value/Beginning_Value)^(1/Years)-1 or =RRI(Years, Beginning_Value, Ending_Value).

Historically, the S&P 500 has generated an average long-term nominal CAGR of approximately 10% (roughly 7% after adjusting for inflation) over trailing 30- to 50-year periods. As a general benchmark:

• Below 7%: Conservative; typical of fixed-income instruments, treasury bonds, or lower-risk diversified portfolios.
• 8% to 12%: Good, competitive equity performance in line with broader broad-market stock indexes.
• 12% to 18%: Strong outperformance, characteristic of leading growth equity funds or superior capital allocators.
• 20%+: Exceptional; achieved historically by elite long-term investors (e.g., Warren Buffett’s Berkshire Hathaway trailing CAGR of ~19.8% over nearly six decades).

Remember that higher CAGR targets typically entail higher volatility and drawdown risk.

The distinction between these three metrics is vital for evaluating real financial performance:

• Absolute Return: Measures the total percentage change from start to finish regardless of time elapsed: (Ending - Beginning) ÷ Beginning. A 100% absolute return over 20 years represents a modest ~3.5% CAGR, whereas the same gain over 3 years is a stellar 26.0% CAGR.
• Average (Arithmetic) Return: The simple sum of annual returns divided by the count of years. It introduces severe distortions during volatile periods.
• CAGR (Geometric Mean): Captures true compounding by factoring in volatility drag. For example, if a portfolio gains +50% in Year 1 and loses -50% in Year 2, the arithmetic average return is (+50% - 50%) ÷ 2 = 0%. However, $100 grows to $150 and then crashes to $75—a net 25% loss! CAGR accurately reflects this loss as -13.4% per year.

Yes, CAGR is negative whenever an investment’s ending value is lower than its initial principal. A negative CAGR quantifies the steady annualized rate of capital destruction or loss over the evaluated period.

Example: If a $20,000 investment in a stock declines to $12,000 over 3 years, the calculation is ($12,000 ÷ $20,000)^(1/3) - 1 = (0.60)^0.3333 - 1 = -15.66% per year. This demonstrates that your asset decayed at an effective compounding rate of -15.66% annually.

CAGR is regarded as the gold standard performance metric for long-term wealth managers for three essential reasons:

• Eliminates Volatility Distortions: Standard arithmetic returns exaggerate performance during erratic bull and bear markets; CAGR shows what an investor truly put in their pocket.
• Universal Cross-Asset Benchmarking: Enables direct, objective comparisons across entirely dissimilar assets—such as comparing real estate returns, venture capital, dividend equities, gold, and Bitcoin across identical multi-year intervals.
• Reliable Forecasting: Enables disciplined reverse-engineering of required future compounding rates to hit specific retirement, college savings, or corporate revenue goals.

No. Standard CAGR assumes a single, static initial lump sum that grows untouched without intermediate deposits or withdrawals.

If you invest regular periodic amounts (such as monthly Dollar-Cost Averaging, SIPs, or 401(k) payroll deductions), standard CAGR will misstate your true performance. Instead, you should calculate the Money-Weighted Rate of Return (MWRR) using the Internal Rate of Return (IRR) or Excel’s XIRR function, which accounts for the exact timing and magnitude of every cash contribution.