CAGR Calculator Guide: How to Calculate CAGR, Formula, Examples & Investment Returns

by

CAGR (Compound Annual Growth Rate) is one of the most widely used numbers in investing. It tells you the steady annual rate at which an investment would have grown if it had compounded at the same rate every year.

People use CAGR to compare mutual funds, stocks, portfolios, or any investment over different time periods. It is useful, but it is also frequently misunderstood. CAGR smooths out the actual year-by-year path. It does not tell you how volatile the journey was, and it does not guarantee that the same rate will continue in the future.

This guide explains what CAGR really means, how to calculate it correctly, when it is useful, when it can mislead, and how to use it together with other tools for better decision-making. All examples are illustrations only.

Calculate CAGR instantly with the CAGR Calculator on Harshonomics. For regular investments, also use the SIP Calculator.

What Is CAGR?

CAGR stands for Compound Annual Growth Rate. It is the annualised rate of return that takes an investment from its beginning value to its ending value over a specific number of years, assuming the profits were reinvested.

In simple words, CAGR answers the question: “If this investment had grown at a constant rate every year, what would that rate have been?”

It is different from the simple average return because it accounts for compounding.

CAGR Formula

The standard formula is:

CAGR = (Ending Value / Beginning Value)(1 / Number of Years) – 1

Or in percentage terms:

CAGR (%) = [(Ending Value / Beginning Value)(1 / n) – 1] × 100

Where n = number of years.

You can also write it as:

CAGR = (EV / BV)(1/n) – 1

This is the same mathematical idea that sits behind the compound interest formula, just rearranged to solve for the rate.

How to Calculate CAGR – Step by Step

Illustration

You invested ₹2,00,000 in a mutual fund.
After 5 years the value became ₹3,50,000.

Step 1: Ending Value ÷ Beginning Value = 3,50,000 ÷ 2,00,000 = 1.75

Step 2: Raise 1.75 to the power of (1/5) ≈ 1.118

Step 3: Subtract 1 → 0.118

Step 4: Multiply by 100 → CAGR ≈ 11.8%

You can verify this instantly on the CAGR Calculator.

CAGR vs Absolute Return

Absolute return simply tells you the total percentage gain or loss over the entire period.

Example: ₹2 lakh became ₹3.5 lakh → Absolute return = 75%.

CAGR converts that total gain into an annualised number so you can compare investments held for different lengths of time. A 75% absolute return over 5 years is very different from a 75% absolute return over 2 years.

CAGR vs Average Annual Return

People sometimes confuse CAGR with the simple average of yearly returns. They are not the same.

Suppose an investment returns +50% in year 1 and –20% in year 2.

  • Simple average return = (50% – 20%) / 2 = 15%
  • CAGR will be lower than 15% because the loss in the second year is applied on a higher base.

CAGR always reflects the actual compounded growth from start to finish. The simple average does not.

Why CAGR Is Useful

  • It allows fair comparison between two investments held for different periods.
  • It is the standard way mutual fund factsheets and research platforms report long-term performance.
  • It helps you set realistic expectations when planning future goals (though it should never be used as a guarantee).
  • It works for any asset that has a clear starting value and ending value — mutual funds, stocks, portfolio, even real estate in some cases.
Try different beginning values, ending values and time periods on the CAGR Calculator.

Important Limitations of CAGR

CAGR is a powerful summary number, but it has clear limitations:

  • It ignores volatility. Two funds can have the same CAGR, yet one may have been much more volatile than the other.
  • It assumes money was invested only at the beginning and withdrawn only at the end. It does not handle SIPs or multiple cash flows well.
  • It is backward-looking. Past CAGR is not a prediction of future returns.
  • It can look artificially high or low depending on the exact start and end dates chosen (especially in volatile markets).
Key point: Always look at CAGR together with other information — rolling returns, standard deviation, maximum drawdown, and consistency across different market cycles. Relying only on a single CAGR figure can lead to poor decisions.

CAGR for SIP Investments

Standard CAGR assumes a single lump-sum investment. When you invest through SIP, money goes in at different times. In that case the correct measure is usually XIRR (Extended Internal Rate of Return), not simple CAGR.

Many platforms still show a “CAGR” for SIP portfolios, but the more accurate number is XIRR. The SIP Calculator helps you project future values, while XIRR is better for measuring the actual return you have earned so far on an ongoing SIP.

For a deeper understanding of SIP returns and how to evaluate them, see the SIP Investment Guide.

How to Use CAGR to Compare Mutual Funds

CAGR is one of the first numbers people look at when comparing mutual funds. It is useful, but it should never be the only number.

When comparing two or more funds:

  • Look at CAGR over the same time period (for example both over 5 years or both over 10 years).
  • Check consistency — a fund that has delivered good CAGR across multiple periods is generally more reliable than one that performed extremely well in only one period.
  • Compare against the relevant benchmark and category average for the same period.
  • Also examine risk measures such as standard deviation, Sharpe ratio and maximum drawdown.

A fund with slightly lower CAGR but much lower volatility may be more suitable for many investors than a higher-CAGR fund that swings wildly.

Rolling Returns vs Point-to-Point CAGR

Point-to-point CAGR uses only two dates — the start date and the end date. The result can change dramatically if you move either date by a few months, especially in volatile markets.

Rolling returns calculate CAGR for every possible period of a fixed length (for example every 3-year or 5-year window) within a longer history. This gives a much clearer picture of how consistently a fund has performed.

When available, rolling returns are generally more informative than a single point-to-point CAGR.

CAGR vs XIRR – When to Use Which

This is one of the most common points of confusion.

  • CAGR is appropriate when there is only one investment at the beginning and one withdrawal at the end.
  • XIRR is the correct measure when there are multiple cash flows (SIPs, additional purchases, partial redemptions, etc.).

If you have been doing a monthly SIP for several years, the return shown by a simple CAGR calculator will not accurately reflect your personal experience. Use XIRR instead for the actual return earned on your money.

Most mutual fund platforms and portfolio trackers show XIRR for ongoing investments. The SIP Calculator is better for future projections, while XIRR is better for evaluating past performance of irregular cash flows.

Practical Example – Comparing Two Investments

Illustration only

Investment A: Grew from ₹5 lakh to ₹11 lakh in 7 years.
CAGR ≈ 11.9%

Investment B: Grew from ₹5 lakh to ₹9.5 lakh in 5 years.
CAGR ≈ 13.7%

At first glance Investment B looks better. However, the time periods are different. To compare fairly you should either:

  • Look at both over the same number of years, or
  • Use additional context such as risk, consistency and the economic environment during each period.

Always calculate with the CAGR Calculator and then dig deeper.

CAGR and the Power of Compounding

CAGR is simply the rate that makes the compound interest formula true for a given start value, end value and time period. Understanding CAGR therefore helps you understand compounding better, and vice versa.

If you know the CAGR you expect (or hope for) and the number of years, you can reverse the calculation to estimate the future value. This is exactly what the Compound Interest Calculator does when you input a rate and time period.

For a full explanation of compounding, see the Compound Interest Calculator Guide.

Common Mistakes When Using CAGR

  • Treating past CAGR as a guaranteed future return.
  • Comparing CAGRs of different time periods without adjustment.
  • Using CAGR for SIP portfolios instead of XIRR.
  • Looking only at the highest CAGR period and ignoring the rest of the history.
  • Ignoring the impact of fees, taxes and exit loads on the actual return received.
  • Choosing a fund solely because it has the highest 3-year or 5-year CAGR at the moment.

Most of these mistakes come from treating CAGR as a complete performance measure instead of one useful summary statistic among several.

How Long a Period Should You Use for CAGR?

There is no perfect answer, but some practical guidelines help:

  • Avoid very short periods (1 year or less) — they are heavily influenced by recent market movement.
  • 3-year and 5-year CAGRs are commonly used for mutual funds.
  • 10-year and longer CAGRs give a better sense of performance across full market cycles.
  • For retirement-oriented equity investments, looking at the longest available meaningful period is usually more informative than focusing on the recent 3 years.

Always check more than one time frame.

Using CAGR for Goal Planning

When planning a future goal, people often assume a certain CAGR and then work backwards to the required monthly investment or lump sum. This is a reasonable planning approach as long as the assumed rate is realistic and a margin of safety is kept.

Steps that work well:

  1. Decide the future corpus needed (after adjusting for inflation).
  2. Choose a conservative-to-moderate assumed CAGR rather than an optimistic one.
  3. Calculate the required SIP or lump sum.
  4. Test what happens if the actual CAGR turns out 1–2 percentage points lower.

The SIP Calculator, Compound Interest Calculator and Retirement Planning Calculator are designed for exactly this kind of forward planning.

Negative CAGR – What It Means

CAGR can be negative. A negative CAGR simply means the investment lost value on an annualised basis over the period measured.

Example: An investment fell from ₹10 lakh to ₹7 lakh in 3 years. The CAGR will be negative (approximately –11.2%). This is mathematically correct and useful — it tells you the annualised rate of decline.

Negative CAGR is common in shorter periods during market corrections. Over long periods, equity investments have historically shown positive CAGR more often than not, but this is not guaranteed for any future period.

CAGR Across Different Asset Classes

Typical long-term CAGR ranges differ by asset class (these are broad historical observations, not predictions):

  • Equity (diversified mutual funds / indices) – Higher long-term CAGR potential, but with significant volatility.
  • Debt funds and fixed deposits – Lower and more stable CAGR.
  • Gold – Variable; sometimes strong, sometimes flat for long periods.
  • Real estate – Difficult to calculate cleanly because of additional costs, rental income, and lack of daily pricing.

When comparing assets, always use the same time period and remember that higher historical CAGR usually came with higher risk.

Impact of Taxes and Expenses on CAGR

The CAGR you see in a factsheet is usually pre-tax and after fund expenses (in the case of mutual funds). Your personal CAGR can be lower because of:

  • Exit loads
  • Capital gains tax
  • Distribution of dividends (if not reinvested)
  • Any advisory or platform fees

For accurate personal evaluation, calculate CAGR on the actual amount you received after all costs and taxes. The difference between pre-tax CAGR and post-tax CAGR can be meaningful over long periods.

How to Calculate CAGR Manually

You can calculate CAGR using a scientific calculator or spreadsheet:

  1. Divide Ending Value by Beginning Value.
  2. Raise the result to the power of (1 ÷ number of years).
  3. Subtract 1.
  4. Multiply by 100 to get the percentage.

In Excel or Google Sheets the formula is:

= (Ending Value / Beginning Value) ^ (1 / Years) – 1

Or use the built-in RRI function in newer versions of Excel.

For quick and error-free calculation, the CAGR Calculator is the easiest option.

CAGR for Portfolio Evaluation

When evaluating your overall portfolio (multiple funds, stocks, etc.), simple CAGR of the total portfolio value works if there were no external cash flows. If you added or withdrew money during the period, XIRR becomes the correct measure of your personal rate of return.

Many investors calculate both:

  • Time-weighted return (similar in spirit to CAGR) to judge the performance of the investments themselves.
  • Money-weighted return (XIRR) to judge the return on the actual money they invested, including the effect of timing of SIPs and withdrawals.

Using CAGR Together with Other Metrics

CAGR becomes much more useful when viewed alongside:

  • Standard deviation or beta (for volatility)
  • Maximum drawdown (biggest fall from peak to trough)
  • Rolling returns (consistency)
  • Benchmark comparison
  • Risk-adjusted measures such as Sharpe ratio

A fund with 14% CAGR and very high volatility may be less suitable for a conservative investor than a fund with 11% CAGR and significantly lower swings.

CAGR in Retirement and Goal Planning

When building a retirement corpus or any long-term goal, people often assume a certain CAGR for future projections. This is a planning tool, not a promise.

Best practices:

  • Use a conservative or moderate assumed CAGR rather than the highest recent number.
  • Run the calculation at least twice — once with your base assumption and once with a lower rate.
  • Combine CAGR assumptions with inflation adjustment so you plan in real (purchasing-power) terms.

The Retirement Planning Calculator, SIP Calculator and Compound Interest Calculator all allow you to test different growth-rate assumptions easily. For the broader retirement framework, see the Retirement Planning Guide.

Common Questions About Time Periods

Is 1-year CAGR useful?
Rarely for long-term decisions. It is heavily influenced by the recent market environment.

Is 3-year CAGR enough?
It is commonly shown, but 5-year and 10-year figures usually give better context.

What about since-inception CAGR?
Useful for older funds, but only if the inception date was not during an unusually high or low market point. Always cross-check with other periods.

Practical Framework for Using CAGR

A simple and disciplined way to use CAGR looks like this:

  1. Decide the exact time period you want to measure.
  2. Use the same period when comparing two or more investments.
  3. Calculate CAGR with the CAGR Calculator.
  4. Check rolling returns or multiple time frames if available.
  5. Look at risk measures (volatility, drawdowns) alongside CAGR.
  6. For SIP or multiple cash-flow portfolios, prefer XIRR over simple CAGR.
  7. When planning future goals, use a range of assumed CAGRs rather than a single optimistic number.
  8. Never treat past CAGR as a guarantee of future returns.

CAGR Checklist

  • I am comparing investments over the same time period.
  • I have checked more than one time frame (3-year, 5-year, 10-year etc.).
  • I understand that CAGR ignores volatility.
  • I am using XIRR instead of CAGR for SIP or irregular cash flows.
  • I have considered the impact of taxes and expenses on my personal return.
  • I am not selecting a fund only because it currently shows the highest CAGR.
  • When projecting future goals, I have tested a lower CAGR assumption as well.

Related Tools and Guides on Harshonomics

Frequently Asked Questions

What is a good CAGR for mutual funds?

There is no fixed “good” number. It depends on the asset class, time period and risk taken. Equity funds have historically delivered higher long-term CAGR than debt funds, but with higher volatility. Always compare against the relevant benchmark and category average for the same period.

Is CAGR the same as annualised return?

In most contexts yes. CAGR is the most common way to express the annualised return of a lump-sum investment over multiple years.

Can CAGR be used for SIPs?

Simple CAGR is not accurate for SIPs because money is invested at different times. XIRR is the correct measure for the return earned on SIP investments.

Why does my personal return look different from the fund’s CAGR?

Fund CAGR assumes a single investment at the beginning of the period. Your actual return depends on when you invested, when you withdrew, and the effect of taxes and costs. XIRR captures your personal experience better.

How many years of CAGR should I look at?

Look at multiple periods. 3-year, 5-year and 10-year CAGRs together give a clearer picture than any single number. Longer periods that cover different market cycles are generally more informative.

Does a higher CAGR always mean a better investment?

Not necessarily. A higher CAGR achieved with much higher volatility or inconsistent performance may not suit every investor. Risk-adjusted returns and consistency matter.

How is CAGR different from compound interest?

They are mathematically related. Compound interest calculates the future value from a known rate. CAGR calculates the rate from a known beginning value, ending value and time period.

Can CAGR predict future returns?

No. Past CAGR is only a historical summary. Future returns can be higher or lower and are not guaranteed.

What is a negative CAGR?

It means the investment declined on an annualised basis over the measured period. It is a normal mathematical outcome during market downturns.

Final Thoughts

CAGR is a clean and powerful way to summarise growth over time. Used correctly — alongside risk measures, multiple time frames and the right calculation method (CAGR vs XIRR) — it helps you compare investments and plan goals more rationally.

Used carelessly, it can create false confidence or lead to chasing recent high performers. The discipline lies in treating CAGR as one important number among several, never as the complete story.

Start with the CAGR Calculator, test a few different periods, and then combine the insights with the other calculators and guides linked above.

Disclaimer

This guide is for educational purposes only. It does not constitute investment advice. All examples are illustrations based on stated assumptions and are not predictions or guarantees of future results. Past performance is not indicative of future returns. Actual investment outcomes depend on market conditions, fees, taxes and individual circumstances. Readers should consider their own situation and, where appropriate, consult a qualified adviser. Harshonomics.com and its authors accept no liability for decisions taken on the basis of this material.