Solvezi.com
Home
Tools
Blog
About
Contact
  1. Home
  2. Finance
  3. CAGR Calculator

CAGR Calculator

Calculate Compound Annual Growth Rate (CAGR) for investments, revenue, or business metrics over time.

Related Tools

More in Finance

Salary CalculatorVAT CalculatorDiscount CalculatorSales Tax CalculatorProfit & Loss CalculatorMarkup CalculatorMargin CalculatorFixed Deposit CalculatorRecurring Deposit CalculatorPPF CalculatorMutual Fund SIP CalculatorRetirement CalculatorCurrency ConverterGST CalculatorSIP CalculatorEMI CalculatorIncome Tax CalculatorROI CalculatorCompound Interest CalculatorSimple Interest Calculator
Explore Other Categories

Share

https://www.solvezi.com/finance-tools/cagr-calculator

Solvezi.com

Solve Easy
Privacy PolicyTerms
© 2026 Solvezi.com. All rights reserved.

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

CAGR Calculator Guide: How to Calculate CAGR

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.

How to Calculate CAGR: Step-by-Step Guide

1

Identify Beginning Value

Determine initial investment amount (PV)

2

Identify Ending Value

Determine final value after n years (FV)

3

Calculate Ratio

Compute FV / PV (total growth factor)

4

Calculate Nth Root

Raise ratio to power of 1/n

5

Subtract 1

Convert growth factor to rate

6

Convert to Percentage

Multiply by 100% for annual rate

What is the CAGR Formula? (Compound Annual Growth Rate Formula)

Beginning Value (PV)

Present value / Initial investment

Starting amount invested

Ending Value (FV)

Future value / Final amount

Value at end of period

Number of Years (n)

Investment time horizon

Period length in years

CAGR (r)

Compound Annual Growth Rate

(FV/PV)^(1/n) - 1

What is CAGR (Compound Annual Growth Rate)?

Compound 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.

Key Question:

"What constant annual growth rate would produce my investment's total return over time?"

CAGR Formula
CAGR = (FV/PV)^(1/n) − 1
PV
Beginning
FV
Ending
n
Years

How to Calculate CAGR in Excel (2 Easy Methods)

1

Using Power Formula

Enter this formula in Excel:

=((B2/A2)^(1/5))-1

Where A2 = beginning value, B2 = ending value, 5 = years

2

Using RRI Function

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.

What is the Difference Between CAGR and Average Return?

ScenarioCAGRAverageInsight
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.

How to Interpret CAGR Values

CAGR > 25%
Exceptional

High-growth/unsustainable

15% - 25%
Excellent

Strong growth (tech stocks)

10% - 15%
Good

Solid returns (S&P 500 average)

5% - 10%
Moderate

Conservative growth (bonds)

0% - 5%
Low

Below inflation risk

CAGR < 0%
Negative

Investment loss

Typical CAGR by Asset Class (Indian Context)

Asset TypeTypical CAGRRisk LevelVolatility
Fixed Deposits6-8%LowVery Low
Debt Funds7-9%Low-ModLow
Hybrid Funds9-12%ModerateModerate
Equity Funds10-15%HighHigh
Small/Mid Caps12-18%Very HighVery High

The Power of Compounding (10% CAGR Example)

1.61x
5 years
10% CAGR
2.59x
10 years
10% CAGR
4.18x
15 years
10% CAGR
6.73x
20 years
10% CAGR
17.45x
30 years
10% CAGR

₹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

Real-World Applications of CAGR

Investment Analysis

  • Stock portfolio performance
  • Mutual fund comparison
  • Retirement planning

Compare investment returns over time

Business Growth

  • Revenue CAGR
  • Customer acquisition
  • Market share analysis

Measure company growth rates

Real Estate

  • Property appreciation
  • Rental income growth
  • REIT performance

Track property investment returns

GDP/Economics

  • Economic growth rates
  • Population growth
  • Sector performance

Measure economic expansion

Sales & Marketing

  • Revenue growth
  • User acquisition
  • Market penetration

Track business metrics over time

Personal Finance

  • Savings growth
  • Education fund planning
  • Retirement projections

Plan long-term financial goals

Common CAGR Calculation Mistakes to Avoid

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

CAGR Calculator FAQ: How to Calculate CAGR

Q
How to calculate CAGR?

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.

Q
How to calculate CAGR in Excel?

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.

Q
How do you calculate CAGR?

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.

Q
What is the CAGR formula?

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%.

Q
What is compound annual growth rate (CAGR)?

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.

Q
What is the difference between CAGR and average return?

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.

Q
How to calculate CAGR with contributions?

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.

Q
What is a good CAGR for investments?

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.

Q
Does CAGR account for inflation?

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.

Q
Why does volatility reduce CAGR?

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.

Q
How accurate is CAGR for 3-5 year periods?

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.

Q
How do I report CAGR in financial reports?

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.

History of Growth Rate Concepts

John Burr Williams

1900-1989

Present value theory (1938)

Developed dividend discount model

Benjamin Graham

1894-1976

Value investing principles

Mentored Warren Buffett

Eugene Fama

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).

How to Report CAGR

Reporting Format Examples:

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.