Investment Analysis
- Stock portfolio performance
- Mutual fund comparison
- Retirement planning
Compare investment returns over time
Calculate Compound Annual Growth Rate (CAGR) for investments, revenue, or business metrics over time.
https://www.solvezi.com/finance-tools/cagr-calculator
Initial investment amount
Final value of investment
Investment period in years
Example: Beginning = ₹10,000, Ending = ₹16,105, Years = 5
→ CAGR = 10% per year
Calculate CAGR and future value • Understand your investment growth
Learn how to calculate CAGR (Compound Annual Growth Rate) with the CAGR formula, Excel CAGR calculation, step-by-step examples, and interpretation guide. Perfect for investments, mutual funds, stocks, real estate, and business metrics.
Determine initial investment amount (PV)
Determine final value after n years (FV)
Compute FV / PV (total growth factor)
Raise ratio to power of 1/n
Convert growth factor to rate
Multiply by 100% for annual rate
Present value / Initial investment
Starting amount investedFuture value / Final amount
Value at end of periodInvestment time horizon
Period length in yearsCompound Annual Growth Rate
(FV/PV)^(1/n) - 1Compound Annual Growth Rate (CAGR) measures the mean annual growth rate of an investment over a specified period longer than one year, assuming smooth, constant growth each year. It represents the compound annual growth rate at which an investment would have grown if it grew at a steady rate.
"What constant annual growth rate would produce my investment's total return over time?"
Enter this formula in Excel:
=((B2/A2)^(1/5))-1Where A2 = beginning value, B2 = ending value, 5 = years
Excel's built-in RRI function:
=RRI(5, A2, B2)RRI = Rate of Return on Investment. Format cell as % for CAGR result.
Excel Tip: Always format the CAGR cell as a percentage (Ctrl+Shift+%) to see the result correctly.
| Scenario | CAGR | Average | Insight |
|---|---|---|---|
| Smooth Growth (5% each year) | 5.00% | 5.00% | Equal when constant |
| Volatile Growth (0% & 10%) | 4.88% | 5.00% | Volatility reduces CAGR |
| Extreme Volatility (-50% +100%) | 0.00% | 25.00% | CAGR reveals true performance |
Key Insight: Volatility reduces CAGR compared to average return. Smooth growth = equal; volatile growth = CAGR < average. This is called volatility drag.
High-growth/unsustainable
Strong growth (tech stocks)
Solid returns (S&P 500 average)
Conservative growth (bonds)
Below inflation risk
Investment loss
| Asset Type | Typical CAGR | Risk Level | Volatility |
|---|---|---|---|
| Fixed Deposits | 6-8% | Low | Very Low |
| Debt Funds | 7-9% | Low-Mod | Low |
| Hybrid Funds | 9-12% | Moderate | Moderate |
| Equity Funds | 10-15% | High | High |
| Small/Mid Caps | 12-18% | Very High | Very High |
₹1,00,000 invested at 10% CAGR becomes:
₹1,61,051 after 5 years | ₹2,59,374 after 10 years | ₹6,72,750 after 20 years
Compare investment returns over time
Measure company growth rates
Track property investment returns
Measure economic expansion
Track business metrics over time
Plan long-term financial goals
Using simple average instead of CAGR
Use CAGR for cumulative growth over multiple periods
CAGR accounts for compounding; average doesn't
Ignoring time period consistency
Ensure n represents total years correctly
For 18 months, n = 1.5 years
CAGR = Annual return (no volatility consideration)
CAGR smooths volatility; actual annual returns vary
Use CAGR for long-term, annual returns for year-to-year
Applying CAGR to non-reinvested returns
CAGR assumes all returns are reinvested
For cash flows, use IRR or MWRR
To calculate CAGR, use the formula: CAGR = (Ending Value / Beginning Value)^(1/n) - 1, where n = number of years. Example: ₹1,00,000 grows to ₹2,00,000 in 5 years → CAGR = (200000/100000)^(1/5) - 1 = 14.87%. This CAGR calculation gives you the compound annual growth rate — the constant rate at which the investment grew each year.
To calculate CAGR in Excel, use: =((Ending_Value/Beginning_Value)^(1/Years))-1. Example: =((B2/A2)^(1/5))-1 where A2 = beginning value, B2 = ending value, 5 = years. You can also use the RRI function: =RRI(5, A2, B2). Format the cell as a percentage to see the CAGR calculation result.
To calculate CAGR: (1) Divide ending value by beginning value, (2) Raise the result to the power of 1/n (n = years), (3) Subtract 1. Formula: CAGR = (FV/PV)^(1/n) - 1. This gives the compound annual growth rate — the steady rate at which an investment would have grown. Example: ₹10,000 → ₹20,000 in 5 years = 14.87% CAGR.
The CAGR formula is: CAGR = (Ending Value / Beginning Value)^(1/n) - 1, where n = number of years. This compound annual growth rate formula calculates the geometric mean growth rate. Example: investment grows from ₹10,000 to ₹20,000 in 5 years → CAGR = (20000/10000)^(1/5) - 1 = 14.87%.
Compound Annual Growth Rate (CAGR) is the mean annual growth rate of an investment over a period longer than one year, assuming smooth, constant growth. CAGR represents the rate at which an investment would have grown if it grew at a steady rate each year.
CAGR is the geometric mean (accounts for compounding), while average return is the arithmetic mean (simple average). CAGR smooths volatility to show true performance. Example: Returns +30% then -30% → 0% average, but CAGR = -4.5% (a loss). Volatility reduces CAGR compared to average return — this is called volatility drag.
Standard CAGR assumes a single initial investment. With multiple contributions, use XIRR in Excel or time-weighted return. For approximate CAGR with regular contributions: CAGR = (FV/Total Contributions)^(1/n) - 1. For accurate results with cash flows, use IRR or XIRR.
Good CAGR depends on risk tolerance and time horizon. In India: Fixed Deposits 6-8%, Debt Funds 7-9%, Hybrid Funds 9-12%, Equity Funds 10-15%, Small/Mid Caps 12-18%. Historical benchmarks: S&P 500 ~10% long-term. Aim for 7-10% nominal CAGR for retirement planning.
Standard CAGR uses nominal returns. Real CAGR = (1 + nominal CAGR)/(1 + inflation rate) - 1. Example: 10% nominal CAGR with 5% inflation = 4.76% real CAGR. Always consider inflation when evaluating long-term investment growth.
Due to volatility drag: geometric mean (CAGR) is always ≤ arithmetic mean (average return). Formula: CAGR ≈ Average Return - (Variance/2). Example: Returns +30% then -30% → Average = 0%, but CAGR = -4.5%. Larger swings = larger volatility drag on CAGR.
CAGR works well for any period >1 year, but shorter periods (3-5 years) may not represent long-term expectations. For volatile assets, even 10 years can be misleading. Longer periods (20+ years) provide more reliable long-term CAGR averages.
Report CAGR with time period and methodology. Example: 'The investment achieved a CAGR of 12.3% over the 5-year period ended December 31, 2023.' Always disclose if returns are gross or net of fees, and whether dividends/interest are reinvested.
1900-1989
Present value theory (1938)
Developed dividend discount model
1894-1976
Value investing principles
Mentored Warren Buffett
1939-present
Efficient Market Hypothesis
Nobel Prize 2013
Did You Know? Albert Einstein reportedly called compound interest the "eighth wonder of the world." At 10% CAGR, money doubles every ~7.2 years (Rule of 72).
Investment Performance:
"The mutual fund delivered a CAGR of 12.4% over the 5-year period ending March 31, 2023."
Comparative Analysis:
"Fund A achieved 14.2% CAGR vs Fund B's 11.8% over the same 10-year period."
Best Practice: Always specify: 1) Time period (start and end dates), 2) Whether returns are gross or net of fees, 3) If dividends/interest are reinvested.
CAGR calculator and complete guide. How to calculate CAGR with the CAGR formula. Calculate CAGR in Excel using RRI function or power formula. Understand compound annual growth rate, CAGR calculation, and the difference between CAGR and average return. Essential for financial planning, investment analysis, mutual fund comparison, and business growth measurement.