CAGR Examples
Example 1 - Stock Investment: Invested $10,000 in a stock that grew to $18,000 over 5 years. Total return: 80%. CAGR: 12.47% annually. This means the investment effectively grew at 12.47% each year, compounded. Compare this to the S&P 500's historical 10% average to see outperformance.
Example 2 - Real Estate Appreciation: Bought a property for $250,000 that is now worth $400,000 after 10 years. Total gain: $150,000 (60% total return). CAGR: 4.81% annually. This modest but steady return reflects typical real estate appreciation rates before rental income.
Example 3 - Business Growth: Company revenue grew from $1 million to $5 million over 8 years. CAGR: 22.5% annually. This exceptional growth rate indicates strong business performance, far exceeding typical market returns and justifying premium valuations.
Frequently Asked Questions
What does CAGR stand for and mean?
CAGR stands for Compound Annual Growth Rate. It measures the mean annual growth rate of an investment over a specified time period longer than one year. CAGR assumes that investment growth is compounded annually, meaning profits are reinvested each year. Unlike simple average returns, CAGR accounts for compounding effects and provides a smoothed, annualized figure that makes it easier to compare investments with different time horizons.
What is the difference between CAGR and average annual return?
Average Annual Return (Arithmetic Mean): Simple average of yearly returns. Doesn't account for compounding. Can be misleading with volatile investments. Example: Year 1: +100%, Year 2: -50%. Average: 25%. Actual result: Break-even (0% total). CAGR (Geometric Mean): Accounts for compounding. Shows true annualized growth rate. Same example: CAGR = 0% (accurate). Always use CAGR for comparing investments and measuring true growth over multiple years. Arithmetic averages overstate performance, especially with volatile investments.
How do I calculate CAGR in Excel?
Excel offers multiple ways to calculate CAGR: Formula method: =(Ending_Value/Beginning_Value)^(1/Number_of_Years)-1. RATE function: =RATE(nper,,-pv,fv) where nper=years, pv=initial value (negative), fv=final value. POWER function: =POWER(Ending_Value/Beginning_Value,1/Years)-1. Example: Initial $10,000, Final $18,000, 5 years. =POWER(18000/10000,1/5)-1 = 12.47%. Format result as percentage. All methods yield identical results.
Can CAGR be negative?
Yes, negative CAGR indicates the investment lost value over the measured period. Example: Initial $10,000, Final $8,000 over 3 years. CAGR = (8000/10000)^(1/3)-1 = -7.19%. Interpretation: Investment declined at 7.19% annually. Compare negative CAGR to: Inflation rate (loss of purchasing power), Alternative investments, Cost of holding (fees, opportunity cost). Negative CAGR over long periods may indicate fundamental problems with the investment strategy.
What is a good CAGR for investments?
Context determines "good" CAGR: Stock Market (S&P 500): ~10% historical average; 7-10% considered good. Bonds: 3-5% typical for quality bonds. Balanced Portfolio: 5-7% realistic long-term target. Tech/Growth Stocks: 15-20%+ expected but with higher risk. Real Estate: 3-5% appreciation plus rental income. Startups/Venture: 20-30%+ target but high failure risk. Inflation-adjusted: Subtract 2-3% from nominal CAGR for real return. Compare your CAGR to appropriate benchmarks with similar risk profiles.
What are the limitations of CAGR?
CAGR limitations include: No Volatility Insight: Smooths out all year-to-year fluctuations—two investments can have same CAGR with very different risk profiles. Assumes Reinvestment: Assumes all gains reinvested, which may not reflect actual behavior. Single Period Only: Doesn't show varying performance across sub-periods. No Cash Flow Adjustment: Doesn't account for additions or withdrawals during the period. Sensitive to Start/End Dates: Beginning and ending points significantly affect results— cherry-picking dates can distort CAGR. Use alongside other metrics like standard deviation, Sharpe ratio, and rolling returns for complete analysis.
How does CAGR compare to IRR?
Similarities: Both measure compounded returns over time. Differences: CAGR: Assumes single initial investment and single final value. Simple calculation. Best for lump-sum investments without interim cash flows. IRR (Internal Rate of Return): Accounts for multiple cash flows in and out at various times. More complex calculation. Best for investments with periodic contributions or withdrawals. Use CAGR for simple investment performance. Use IRR for analyzing portfolios with ongoing contributions, real estate with rental income, or any investment with multiple cash flows.
Why is my CAGR different from my broker's reported return?
Possible reasons for discrepancy: Time-Weighted vs. Dollar-Weighted: Brokers often show time-weighted returns (removing impact of your cash flows) while your personal CAGR is dollar-weighted. Fees: Your calculation may not include management fees, expense ratios, or trading costs. Dividend Treatment: Reinvested vs. non-reinvested dividends affect calculations. Starting Date Differences: Even small date variations affect multi-year CAGR. Currency Effects: International investments may have currency conversion impacts. Verify both calculations are using identical parameters including dates, cash flows, and fee treatment.
Can I use CAGR for portfolio performance?
Yes, with considerations: Single Lump Sum: CAGR works perfectly if you made one initial investment with no additions. Multiple Contributions: Use IRR (Internal Rate of Return) instead for accurate personal performance. Time-Weighted Return: For evaluating manager skill independent of your cash flow timing. Dollar-Weighted Return (IRR): For your actual experienced return including timing of contributions. For most investors making regular contributions, IRR more accurately reflects personal performance than CAGR.
How do I calculate CAGR with monthly data?
For periods less than one year or monthly data: Less than 1 year: CAGR may not be meaningful—consider simple return or annualized return instead. Monthly to Annual: If you have monthly returns, convert to years: Years = Number of Months / 12. Example: 18 months = 1.5 years. Then apply normal CAGR formula. Monthly CAGR: You can calculate monthly CAGR with: =(Ending/Initial)^(1/Months)-1. Annualize it: =(1+Monthly_CAGR)^12-1. Most investors prefer annual CAGR for standardization and comparison purposes.
What is the Rule of 72 and how does it relate to CAGR?
Rule of 72 is a mental math shortcut to estimate doubling time: Years to Double = 72 / Annual Growth Rate. Examples: 6% CAGR: 72/6 = 12 years to double. 8% CAGR: 72/8 = 9 years to double. 12% CAGR: 72/12 = 6 years to double. Relationship to CAGR: If you know your CAGR, Rule of 72 estimates how long until investment doubles. Reverse: If investment doubled in X years, approximate CAGR = 72/X. Accuracy: Most accurate for rates between 6-10%; less precise for very high or low rates. Useful for quick mental calculations without a calculator.