When you invest money, the most natural question that follows is: how well is my investment actually doing? Two numbers come up repeatedly in this context — CAGR and XIRR. You will see them on mutual fund fact sheets, investment platforms, and financial news. Both measure returns, but they do it in very different ways, and using the wrong one can give you a misleading picture of your portfolio.

Many investors use these terms interchangeably, which is a mistake. CAGR works well in certain situations and fails badly in others. The same is true for XIRR. Knowing which one to trust, and why, is a skill that every investor — beginner or experienced — should have.

This article explains both metrics from the ground up, walks through detailed examples with real numbers, covers their formulas, lists their strengths and weaknesses, and tells you exactly when to use which one. By the end, you will have a clear and confident understanding of CAGR and XIRR.

What is CAGR?

CAGR stands for Compound Annual Growth Rate. It tells you the average yearly rate at which an investment grew from a starting value to an ending value over a given number of years. The key word here is average. CAGR smooths out all the ups and downs in between and gives you one clean annual number.

Think of it like calculating your average speed on a road trip. You might have driven faster on the highway and slower through a city, but your average speed gives you a single, easy-to-understand number that describes the whole journey.

The CAGR Formula

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

Or, if working with exact days instead of rounded years:

CAGR = [ (Ending Value / Beginning Value) ^ (365 / Number of Days) ] – 1

Note: The ^ symbol means ‘to the power of’. So (1 / n) is the nth root of the ratio.

A Simple CAGR Example

Scenario: You invested ₹1,00,000 in a large-cap equity fund on 1st January 2019. On 31st December 2023, your investment was worth ₹1,76,234. That is 5 years.

Applying the formula:

CAGR = (1,76,234 / 1,00,000) ^ (1/5) – 1 = (1.76234) ^ 0.2 – 1 ≈ 0.1200 = 12%

This means your investment grew at approximately 12% per year on average. It does not mean it grew exactly 12% each year — the actual annual returns might have been 18%, -5%, 22%, 8%, and 15% across those five years. CAGR averages it all out into a single figure.

What CAGR Tells You

CAGR is very useful for comparing two investments over the same time period. If Fund A gave a 5-year CAGR of 12% and Fund B gave 10%, Fund A performed better on a compounded basis, assuming you made a single lump-sum investment in both.

But CAGR has a crucial assumption baked in: it treats the investment as if money entered once (at the start) and was withdrawn once (at the end). There were no additional contributions, no partial withdrawals, and no dividends reinvested along the way. In the real world, this is rarely how people invest.

What is XIRR?

XIRR stands for Extended Internal Rate of Return. It is a more powerful and flexible metric than CAGR. While CAGR only looks at two data points (the start and the end), XIRR accounts for every cash flow that happened along the way — and crucially, it considers the exact date of each flow.

The word ‘Extended’ in XIRR refers to its ability to handle cash flows that occur at irregular, non-periodic intervals. The basic IRR assumes equal time periods between cash flows. XIRR removes that restriction entirely.

The Concept of Time Value of Money

XIRR is built on a foundational financial concept called the Time Value of Money (TVM). The idea is simple: a rupee today is worth more than a rupee in the future. Why? Because you can invest the rupee you have today and earn returns on it. Money that arrives later has had less time to compound.

Example: If you put ₹1,000 into a savings account that earns 6% per year, it grows to ₹1,060 in a year. So ₹1,000 today equals ₹1,060 one year from now at that rate. Working backwards, ₹1,060 received one year from now has a present value of ₹1,000 today.

XIRR uses this logic across all your cash flows — investments (outflows) and redemptions or maturity values (inflows) — to find the single annualised rate of return that makes the total present value of all those cash flows equal to zero.

The XIRR Formula

XIRR solves for the rate r in the following equation:

Sum of [ CF_i / (1 + r) ^ ((d_i – d_0) / 365) ] = 0

Where CF_i is the cash flow at position i (negative for investments, positive for withdrawals/maturity), d_i is the date of that cash flow, d_0 is the date of the first cash flow, and r is the XIRR we are solving for.

You cannot solve this equation manually in a simple step. It requires a numerical method called iteration — the computer makes a guess for r, checks whether the equation balances, adjusts the guess, and repeats until it finds the correct answer. This is why XIRR is calculated in Excel or financial apps rather than by hand.

A Simple XIRR Example

Scenario: You invested ₹10,000 in a mutual fund on 1st January 2021. Each year, the fund paid out a ₹500 dividend which you reinvested. On 31st December 2024, you redeemed everything for ₹14,000.

Your cash flow table looks like this:

Using the XIRR function in Excel or a financial calculator, this series of cash flows yields an XIRR of approximately 12.33%.

Now compare that to CAGR calculated on only the initial investment of ₹10,000 growing to ₹14,000 over 4 years:

CAGR = (14,000 / 10,000) ^ (1/4) – 1 = 8.78%

The CAGR of 8.78% misses the three dividend reinvestments entirely. XIRR at 12.33% captures the full picture — including the compounding effect of those additional ₹500 contributions made at specific points in time. This difference is not trivial. It is the difference between understanding your real returns and having a distorted view.

CAGR vs XIRR: Key Differences

XIRR vs CAGR for SIP Returns

This is perhaps the most practically important comparison for retail investors in India, since a very large proportion of mutual fund investors use SIPs. The short answer is: always use XIRR for SIP returns. Here is why.

A SIP means you are investing a fixed amount every month. Each instalment enters the market on a different date, at a different NAV, and has a different holding period before you exit. The instalment you made in January 2020 has had four years to compound by January 2024. The one you made in December 2023 has had barely a month.

CAGR, which assumes a single start date, cannot account for this staggered entry. It either ignores all but the first investment (giving an absurd result) or pretends all investments were made on day one (still wrong). Both approaches misrepresent what really happened.

XIRR was designed precisely for this situation. It gives each cash flow the exact weight it deserves based on its timing. This is why every serious mutual fund platform — Zerodha, Groww, Paytm Money, Kuvera, and others — uses XIRR to report SIP returns. It is the industry standard for good reason.

Quick rule: Single lump sum with no withdrawals? CAGR works fine. More than one cash flow? Use XIRR, every time.

Advantages and Disadvantages of CAGR

Advantages

• Simple to calculate: You only need three numbers — start value, end value, and number of years. Anyone can apply the formula on a basic calculator.
• Easy to communicate: A 12% CAGR over 5 years is immediately understandable. It is a clean, intuitive benchmark for comparing funds or asset classes.
• Good for long-term benchmarking: Comparing a fund’s 10-year CAGR to the Nifty 50’s 10-year CAGR gives a clear view of whether the fund added value above the index.
• Widely used and standardised: Fund fact sheets, AMFI data, and financial media all report CAGR, making it easy to find and compare across sources.

Disadvantages

• Assumes constant growth: Real investments fluctuate. A fund that dropped 40% in year one and recovered 67% in year two shows the same 2-year CAGR as a fund that grew a steady 12% both years. The paths were very different but CAGR hides that.
• Ignores intermediate cash flows: If you made additional investments or partial withdrawals during the period, CAGR gives you a distorted picture.
• Does not account for risk: Two funds can have the same CAGR with dramatically different volatility. CAGR alone does not tell you how bumpy the ride was.
• Misleading for SIPs: As shown in the example above, applying CAGR to a SIP almost always produces a wrong and misleading number.

Advantages and Disadvantages of XIRR

Advantages

• Handles irregular cash flows: Whether you invested once, a hundred times, or withdrew money in between, XIRR handles all of it accurately.
• Accounts for timing: A ₹10,000 investment made three years ago gets more weight than a ₹10,000 investment made three months ago. This is exactly right and mathematically sound.
• Incorporates time value of money: XIRR reflects the financial reality that earlier money has more time to compound and therefore matters more to your return.
• The right tool for SIPs: XIRR is the only accurate way to measure returns on a Systematic Investment Plan, which is how most retail investors invest in mutual funds.
• Works for complex portfolios: Even if you have dozens of transactions across years, XIRR digests them all into one annualised figure.

Disadvantages

• Requires complete data: You need the exact date and amount of every single cash flow. Missing even one transaction can skew the result significantly.
• Cannot be calculated by hand: XIRR requires iterative computation. You need Excel, a financial app, or a programmed calculator. You cannot do it on paper in a few seconds.
• Sensitive to data errors: A wrong date entered for one cash flow changes the result. Small errors in inputs lead to inaccurate outputs.
• Less intuitive to explain: Telling someone their SIP has a 14.7% XIRR is accurate but harder to explain to a non-financial audience than saying the fund has a 10-year CAGR of 13%.
• May not reflect future expectations: Like all return metrics, XIRR is backward-looking. It describes what happened, not what will happen next.

Limitations of CAGR

Beyond the disadvantages already listed, CAGR has a few deeper limitations worth knowing.

First, CAGR can be manipulated by choosing different start and end dates. A fund that had a bad year in 2018 and a great year in 2023 will look very different if you choose a 5-year CAGR starting from 2018 versus starting from 2019. Always check what period a CAGR covers before drawing conclusions.

Second, CAGR hides sequence risk. If your investment lost 50% in year one and then gained 100% in year two, your 2-year CAGR is 0% (back to the starting value). But that is not the same as a fund that was flat for two years. The sequence of gains and losses matters enormously if you were withdrawing money during that period — CAGR does not show this.

Third, for very short time periods (less than one year), CAGR can produce misleading annualised figures. A fund that gained 5% in three months does not necessarily have a 21.5% annualised CAGR in any meaningful sense.

Limitations of XIRR

XIRR also has important limitations that users should be aware of.

XIRR assumes that intermediate cash flows are reinvested at the same XIRR rate. This is called the reinvestment rate assumption, and it is rarely perfectly accurate in practice. If your actual reinvestment returns differ from the XIRR rate, the true economic outcome will differ from what XIRR suggests.

XIRR can also produce unusual or multiple solutions in certain edge cases, particularly when cash flows alternate frequently between positive and negative with no clear trend. In such cases, some software might return an error or an illogical result.

Finally, XIRR is purely a return metric — it does not tell you anything about risk, maximum drawdown, or how volatile the journey was. A high XIRR achieved through a very volatile path may not suit every investor’s risk profile.

When to Use CAGR and When to Use XIRR

The choice between CAGR and XIRR is not about which one is generally better — it is about which one fits the situation you are evaluating. Here is a practical guide.

Use CAGR When:

• You made a single lump sum investment with no additional contributions or withdrawals during the period.
• You want to compare the historical performance of two mutual funds or asset classes over the same time period (e.g., 5-year CAGR of Fund A vs Fund B).
• You are evaluating investments like Fixed Deposits, PPF, or bonds where the return is predetermined and the cash flow structure is simple.
• You are doing a quick, back-of-the-envelope comparison between investment options.
• You are reading a fund fact sheet and comparing the 1-year, 3-year, and 5-year CAGRs to the benchmark index.

Use XIRR When:

• You are invested in a SIP — this is the most common use case for Indian retail investors.
• Your investment history includes any additional lump sum top-ups alongside regular SIP contributions.
• You made partial withdrawals from your investment at some point during the holding period.
• You reinvested dividends at different points in time.
• You are calculating the return on a portfolio with multiple entry and exit points.
• You want to know the true annualised return on your entire mutual fund portfolio across all transactions.

Quick Decision Guide

What Is Considered a Good XIRR or CAGR?

There is no universal answer to this question — it depends entirely on the asset class, the time period, and your personal financial goals. But here are some general benchmarks that many financial advisors use as reference points.

Benchmarks for CAGR

Benchmarks for XIRR

For equity mutual fund SIPs in India, a general rule of thumb is:

• An XIRR above 12% is considered good performance for a large-cap equity fund SIP.
• An XIRR above 15% is considered strong for a mid or small-cap fund SIP.
• For debt funds or hybrid funds, an XIRR above 7.5% to 8% is generally considered favourable.
• An XIRR below 6% on an equity fund SIP over 5+ years would be a cause for concern and warrants reviewing your fund selection.

Remember: XIRR is a backward-looking metric. A high historical XIRR does not guarantee future returns. Always consider your risk tolerance, investment horizon, and financial goals when evaluating whether your current returns are adequate.

Calculating CAGR in Excel

Excel does not have a built-in CAGR function, but you can calculate it using a simple formula. Say your start value is in cell B2, your end value is in cell B3, and the number of years is in cell B4.

= (B3 / B2) ^ (1 / B4) – 1

Format the result as a percentage and you have your CAGR.

Calculating XIRR in Excel

Excel has a built-in XIRR function. Set up your data with cash flows in one column (negative for investments, positive for redemptions) and corresponding dates in an adjacent column. Say cash flows are in column B (rows 2 to 14) and dates are in column A (rows 2 to 14).

= XIRR(B2:B14, A2:A14)

Excel will return the annualised XIRR. Format it as a percentage. Make sure investment cash flows are entered as negative numbers and redemption values as positive numbers — otherwise Excel will return an error.

Note: If you are using Google Sheets, the XIRR function works identically with the same syntax.

Conclusion

CAGR and XIRR are both valid and useful ways to measure investment returns, but they serve different purposes and work in different situations. Confusing them or applying the wrong one can lead to seriously misleading conclusions about your portfolio.

CAGR is clean, simple, and great for comparing two investments over the same period when only a single investment and a single exit are involved. It is the go-to metric for fund fact sheets, benchmark comparisons, and simple lump sum evaluations. But it fails the moment your investment picture gets more complex.

XIRR is the right tool for the real world of investing — where you add money monthly through SIPs, make occasional lump sum top-ups, reinvest dividends, and sometimes withdraw partially. XIRR accounts for all of this with mathematical precision by respecting the time value of every rupee you invested on every specific date.

For most retail investors in India who invest via SIPs — which is the recommended and most common way to build wealth through mutual funds — XIRR is the number that actually tells you the truth about your returns. When you log into your investment platform and see your portfolio return, that number is almost certainly an XIRR.

The bottom line: learn both metrics, understand what each one measures, and always match the metric to the situation. That simple habit will give you a far more accurate and honest view of how your investments are actually performing.

Frequently Asked Questions

1. Can XIRR and CAGR ever give the same result?

Yes. When there is only one investment made at the start and one redemption at the end with no other cash flows, XIRR and CAGR produce identical results. The time value calculation reduces to the same formula in that specific scenario.

2. Can you convert XIRR to CAGR?

Not directly. XIRR accounts for irregular cash flows, while CAGR assumes only two data points. They measure slightly different things. In cases where there are no intermediate cash flows, they coincide — but in general, you cannot convert between the two without losing information.

3. Is XIRR always higher than CAGR?

Not necessarily. XIRR can be higher or lower than a naive CAGR calculation depending on the timing and size of cash flows. For SIPs where money is invested over time rather than all at once, XIRR tends to reflect the true return more accurately, which can differ significantly from a misapplied CAGR.

4. Which is better for evaluating mutual funds — CAGR or XIRR?

For comparing two funds side by side using their published historical data, CAGR is fine and convenient. For evaluating how your personal mutual fund investment actually performed, given your specific SIP dates and amounts, XIRR is the correct measure.

5. What is a good XIRR for a SIP in equity mutual funds?

As a broad guideline, an XIRR above 12% per annum over a 5+ year period is considered good for large-cap equity funds. For mid and small-cap funds, above 15% is strong. However, past returns do not guarantee future performance, and suitability depends on your personal risk profile and goals.

6. Why do mutual fund platforms show XIRR and not CAGR for my portfolio?

Because XIRR is the only accurate metric for portfolios that contain SIP transactions. Since most investors invest through monthly SIPs, XIRR is the honest and appropriate way to show personalised portfolio returns.

7. Is absolute return different from CAGR?

Yes. Absolute return just measures the total percentage gain from start to end, without accounting for how many years it took. A 50% absolute return over 2 years is very different from a 50% absolute return over 10 years. CAGR converts the absolute return into an annualised figure, making it more meaningful and comparable across different time periods.