What Is XIRR in Mutual Funds? CAGR vs XIRR Explained (2026)

You have been running a SIP for three years. The app shows a number — say 14% — as your return. You feel good. But then a friend shows you their statement with 11%, and their actual wealth created is more than yours. Confusing? It happens more often than you think, and the reason is almost always a mismatch in how returns are being measured.

Most investors encounter three terms when reading about mutual fund returns: absolute return, CAGR, and XIRR. Each one measures something different. Use the wrong one and you are either flattering yourself or selling yourself short. For a SIP — where you add money every single month — only one of these three tells you the full truth.

That metric is XIRR. This guide explains what XIRR in mutual funds really means, how it differs from the other two, and how to calculate it yourself. No jargon. No fund recommendations. Just the math behind the number.

Why Simple Returns Mislead SIP Investors

Let us start with the problem XIRR was designed to solve.

Absolute return is blunt

Absolute return is the simplest measure: how much did your money grow in total, expressed as a percentage of what you put in?

(Current Value − Amount Invested) ÷ Amount Invested × 100

If you invested ₹1 lakh and it is now worth ₹1.35 lakh, your absolute return is 35%. Clean and easy. But it tells you nothing about time. A 35% gain in two years is very different from a 35% gain in seven years. Absolute return is useful for a quick glance, not for comparing different investments or different investors.

CAGR is better — but only for a lump sum

CAGR (Compound Annual Growth Rate) converts an absolute return into an annualised rate, accounting for compounding. It answers: at what steady annual rate would my single investment have grown to reach this final value?

The formula assumes one money-in date and one money-out date. That is exactly what a lump-sum investment looks like: one cheque written, one redemption later. For that specific situation, CAGR is the right tool.

But a SIP is the opposite of that. Every month, a fresh cheque goes in — on a different date, at a different NAV. The ₹5,000 you invested in month 1 has been compounding for 36 months. The ₹5,000 you invested in month 36 has been in the market for a single day. Applying one CAGR figure to all of those cash flows as if they were one lump sum gives you a number that is mathematically inaccurate. It typically overstates the real return in a rising market.

This is precisely the gap XIRR was built to fill.

What Is XIRR? (XIRR Meaning, Simply Put)

XIRR stands for Extended Internal Rate of Return. It is a financial calculation that finds the single annualised rate of return that, when applied to each cashflow on its actual date, makes the net present value of all your cash flows equal to zero.

In plain English: XIRR works backwards from all your investments and the current value of your portfolio to find the one annual return rate that perfectly explains everything that happened, date by date.

Unlike CAGR, XIRR: - Handles multiple investment dates (every SIP instalment, every top-up) - Handles irregular amounts (stepped-up SIPs, ad-hoc investments) - Handles partial redemptions (when you withdrew some money at a specific point)

Because of this flexibility, XIRR is the standard return metric recommended by AMFI for evaluating SIPs and is the figure most consolidated account statements report as your portfolio return. SEBI regulations also require that performance disclosures for schemes with regular cashflows use an appropriate time-weighted or money-weighted methodology — XIRR is the money-weighted approach for investor-level returns.

If you want to understand what a mutual fund is and how returns are generated before diving deeper into XIRR, that primer is a good starting point.

XIRR vs CAGR vs Absolute Return: When to Use Which

The simple rule: if money moves in or out on more than one date, use XIRR. If it was one clean lump-sum investment, CAGR is fine. Absolute return is only useful when time does not matter to your question.

XIRR in Action: An Illustrative Example

ILLUSTRATIVE — not a prediction. Numbers below are hypothetical and used purely to explain the concept. They do not represent any actual scheme, market condition, or expected return.

Imagine an investor, Meera, starts a SIP of ₹5,000 per month for 12 months, then redeems the entire amount at month 13.

Meera’s cashflows (hypothetical):

Naive absolute return: Meera invested ₹60,000 (12 × ₹5,000) and received ₹66,500. Absolute return = (66,500 − 60,000) ÷ 60,000 × 100 = 10.83%. Sounds reasonable for one year.

The problem with CAGR here: If you blindly apply the full ₹60,000 as if it was invested on 1-Jan-2025 (it was not — the last instalment went in on 1-Dec-2025), you would calculate it as if all money was at risk for 12 months. That inflates the apparent gain.

XIRR result (hypothetical): Running the above cashflows through a spreadsheet XIRR function returns approximately 19.6% per annum (hypothetical). Why so different from 10.83%? Because the early instalments were invested for the full 12 months and grew, while the later instalments were in the fund for just 1–2 months. XIRR correctly weights each rupee by how long it was actually invested. The 10.83% absolute return was flattening this time-value difference into one undifferentiated number.

This is the core insight: XIRR captures the fact that not all your money was invested for the same duration.

How to Calculate XIRR Yourself

You do not need any specialised software. A standard spreadsheet application has a built-in XIRR function. Here is the generic approach:

Step 1 — List every cashflow with its date

Create two columns: one for dates (in a proper date format your spreadsheet recognises), one for amounts.

•             Investments (money going out of your pocket): enter as negative numbers (e.g., −5000)

•             Redemptions or current portfolio value (money coming back): enter as positive numbers (e.g., +66500)

Your current portfolio value counts as a “hypothetical redemption today” even if you have not redeemed. This lets you calculate XIRR for an ongoing portfolio.

Step 2 — Use the XIRR formula

In a blank cell, type:

=XIRR(values_range, dates_range)

•             values_range — the column of cashflows (negatives for investments, positives for redemptions/current value)

•             dates_range — the corresponding column of dates

The function iterates internally to find the interest rate at which the net present value of all cashflows equals zero. That rate, expressed annually, is your XIRR.

Step 3 — Format as a percentage

The output will be a decimal (e.g., 0.196). Format the cell as a percentage to read it as 19.6%.

One watch-out: If your spreadsheet returns an error, check that your cashflows have at least one negative and one positive value, and that the dates are in the correct format. A common mistake is entering all amounts as positive — the function needs the sign convention to work correctly.

Common Pitfalls When Reading XIRR

1. Comparing XIRR across very different time periods

A SIP that is 6 months old will show a dramatically different XIRR than a 5-year-old SIP, even in the same fund. XIRR annualises returns, and annualising a short period amplifies both gains and losses. A SIP that is up 3% in 2 months might show an XIRR of 18%+ — which says nothing reliable about long-term performance.

Rule of thumb: XIRR becomes meaningful and comparable only after at least 2–3 years of consistent investment. SEBI and industry guidelines generally suggest treating short-period annualised figures with caution.

2. Confusing portfolio XIRR with scheme returns

The XIRR you calculate is your return — based on when you invested. Two investors in the same fund can have very different XIRRs because they invested on different dates, or one did an STP while the other did a lump sum. This is not a flaw; it is the point. XIRR is an investor-level metric, not a fund-level metric.

3. Treating XIRR as a promise

4. Forgetting to include all cashflows

If you did partial redemptions at any point — say you pulled out ₹20,000 mid-SIP — that redemption must appear in your cashflow list as a positive number on the correct date. Missing any cashflow will give you an incorrect XIRR.

Frequently Asked Questions

Q: My statement shows both CAGR and XIRR. Which one should I trust?

For a SIP portfolio or any account with multiple investment dates, trust XIRR. CAGR on an SIP is a simplification that treats all installments as if they were invested on day one — which they were not. XIRR is the more accurate picture of your actual experience.

Q: Can XIRR be negative?

Yes. If the current value of your portfolio is less than what you put in (adjusted for timing), XIRR will be negative. This means you are currently at a loss on an annualised basis. This can happen in a market downturn or if you invested heavily just before a fall.

Q: Is XIRR the same as IRR?

They are closely related. IRR (Internal Rate of Return) assumes cashflows happen at equal intervals (say, exactly every month or every year). XIRR is the extended version that accepts actual dates — which matters because SIP dates shift around weekends and holidays. For mutual fund SIPs, always use XIRR, not plain IRR.

Q: My XIRR is 18% but the fund fact sheet shows 14% CAGR. Am I doing better than the fund?

Not necessarily. The fund’s CAGR is calculated on a lump sum basis for standardised periods (1-year, 3-year, 5-year). Your XIRR is personalized to your investment dates. If you happen to invest more units at a market dip, your XIRR can legitimately exceed the fund’s stated CAGR. It simply means your entry timing was favourable. Compare your XIRR against your own goal — not against the fund’s headline return.

Conclusion

XIRR is not complicated once you understand the problem it solves. When money flows in on multiple dates — as it does in every SIP — simple absolute return and even CAGR give you a distorted picture. XIRR is the one metric that accounts for when each rupee was invested, giving you the truest measure of how your money has actually grown.

The practical takeaway: check your XIRR rather than just the absolute gain shown on your screen. Use a spreadsheet to verify it yourself using the cashflow method described above. And resist the temptation to compare your 6-month-old SIP’s XIRR to that of a friend who has been investing for five years — the number is only meaningful when given enough time.

For deeper context on how annualised returns work for single investments, read our guide on what is CAGR in mutual fund. If you are newer to the asset class, what is a mutual fund covers the foundation. And when you are ready to get started, how to invest in a SIP walks you through the process step by step.

Disclaimer: