XIRR vs CAGR for Mutual Funds (2026): Which Return Number Actually Matters

Open your mutual fund app and you will see a return percentage staring back at you. But which one is it — absolute return, CAGR, or XIRR? These three numbers can describe the very same investment and yet show wildly different figures. Pick the wrong one and you will either feel falsely rich or needlessly disappointed.

This guide explains all three in plain language, with an Indian-context example, so you know exactly which return number to trust for a lump sum versus a monthly SIP — and why almost every Indian platform reports XIRR for your SIP portfolio.

Absolute Return: The Simplest (and Most Misleading) Number

Absolute return is just the total percentage gain or loss, ignoring how long you stayed invested. If you put in ₹1,00,000 and it grew to ₹1,50,000, your absolute return is 50%. That's it — no annualisation, no compounding.

The problem is that 50% over 2 years and 50% over 7 years feel identical in this metric, even though one is a far better outcome than the other. Absolute return is fine for a quick gut-check, but it tells you nothing about the rate at which your money grew. For any decision that compares investments held over different periods, you need an annualised number.

CAGR: The Right Number for a Single Lump Sum

CAGR (Compound Annual Growth Rate) is the annualised return for a single lump-sum investment held from a start date to an end date. It answers: “If my money had grown at one steady compounding rate every year, what rate would take me from the starting value to the ending value?”

CAGR assumes exactly one inflow at the beginning and one value at the end. It is a point-to-point measure — it does not care what happened in between, and it ignores the timing or size of any intermediate cashflows.

An illustrative CAGR example

Suppose you invested ₹1,00,000 as a one-time lump sum and after 5 years it became ₹1,80,000 (illustrative, not an actual fund return). The absolute return is 80%, but the CAGR is roughly 12.5% per year. That single annual rate, compounded five times, turns ₹1,00,000 into about ₹1,80,000.

Because CAGR cleanly annualises a one-shot investment, it is the correct number for comparing a lump-sum mutual fund investment, an FD, or any product where you invested once and let it sit. The catch arrives the moment you add more money over time.

Why a SIP Breaks CAGR

A SIP (Systematic Investment Plan) is the opposite of a single lump sum. You invest a fixed amount every month, so each instalment stays invested for a different length of time. Your first ₹5,000 might be invested for 5 years; the ₹5,000 you put in last month has barely been invested at all.

CAGR cannot handle this. If you naively apply CAGR by treating your total invested amount as a lump sum on day one, you assume all your money was working for the full period — which is false. This usually understates the true return, because most of your money was actually invested for less than the full duration. To measure a SIP honestly, you need a metric that weights every instalment by its own date. That is XIRR.

XIRR: The Right Number for SIPs and Mixed Cashflows

XIRR (Extended Internal Rate of Return) is the annualised return when there are multiple, irregularly timed cashflows — monthly SIP instalments, occasional lump-sum top-ups, partial redemptions, or all of these in one portfolio.

Technically, XIRR is the single annual rate that makes the net present value of all your cashflows (every inflow and every outflow, each tagged with its exact date) equal to zero. In simpler terms, it gives each rupee credit only for the actual time it stayed invested. Money in early counts for more; money in last month counts for almost nothing.

This is why XIRR is the honest, apples-to-apples return for any real-world portfolio. Whenever your investment pattern is anything other than a single deposit, XIRR is the number to trust.

Same SIP, Two Different Numbers: An Illustrative Comparison

Imagine an investor running a ₹10,000 monthly SIP for 5 years. Total invested = ₹6,00,000. Suppose the corpus grows to about ₹8,20,000 (illustrative figures only).

If you wrongly treat the full ₹6,00,000 as a lump sum invested on day one and compute CAGR, you would get a low single-digit annual figure — because the calculation assumes all ₹6,00,000 sat invested for the entire 5 years. But in reality each instalment was invested for an average of roughly half the period. When you compute XIRR — crediting each ₹10,000 only for the months it was actually invested — the annualised return comes out meaningfully higher (often in the low-to-mid teens for the same data). Same money, same corpus, two very different stories. XIRR is the truthful one for a SIP.

CAGR vs XIRR: The Comparison Table

How to Read the Number Your App Shows You

Indian platforms have largely standardised on XIRR for portfolio returns, precisely because most retail investors run SIPs. When you open Groww, Zerodha Coin, or your consolidated CAMS/KFintech statement, the headline annualised return for your SIP holdings is almost always XIRR — even if the app simply labels it “returns” or “annualised return”.

A few practical reading tips:

• If you see a return on a single lump-sum fund investment, it is usually CAGR or a simple point-to-point return.
• If you see a return on a SIP or your overall portfolio, treat it as XIRR — that is the number that fairly reflects your staggered investing.
• Fund fact-sheets and rating sites usually quote fund CAGR (1-year, 3-year, 5-year point-to-point). That is the fund's performance, not necessarily your return, because your SIP timing differs from a clean lump sum.

The gap between “the fund's CAGR” and “my XIRR” is normal and expected. Don't panic if they differ — they answer different questions.

How to Compute XIRR Yourself in a Spreadsheet

You don't need any app to verify your return. Excel and Google Sheets both have a built-in =XIRR(values, dates) function. Here's the method:

1. In one column, list every cashflow. Each SIP instalment and top-up is a negative number (money leaving your pocket). The final or current value of your holdings is a single positive number.
2. In the next column, put the exact date of each cashflow, including the date you are valuing the corpus.
3. In an empty cell, type =XIRR(values_range, dates_range) and press Enter. The result is your annualised XIRR as a decimal — format it as a percentage.

For example, twelve monthly entries of −10,000 with their respective dates, followed by one positive entry for today's portfolio value with today's date, will return your true SIP XIRR. If the function returns an error, check that you have at least one negative and one positive value and that the dates are real date values, not text.

Want to project future SIP outcomes before committing? Our free financial calculators let you model SIP growth, and you can browse funds on the mutual funds page. If you're weighing options against borrowing, see our guide on loan against mutual funds vs personal loan.

Frequently Asked Questions

Is XIRR always higher than CAGR?

No. XIRR is simply the more accurate measure for staggered cashflows. For a SIP in a steadily rising market, XIRR will usually look higher than a naive lump-sum CAGR because your later instalments were invested for less time. But the relationship depends entirely on market timing — in a falling or volatile market, XIRR can be lower.

Which return should I use to compare two mutual funds?

Use the fund's CAGR (1-, 3-, and 5-year point-to-point) to compare the funds themselves on an equal footing. Use XIRR to measure your own personal return on each, since your actual SIP dates and amounts differ from a clean lump sum.

Why does my app's return differ from the fund's advertised 5-year return?

The fund's advertised figure is usually a 5-year point-to-point CAGR for a single lump sum on a fixed date. Your number is your personal XIRR based on your specific SIP instalments, which were invested at different times. Different inputs, different outputs — both can be correct.

Can I use CAGR for a SIP if I just want a rough idea?

You can, but understand it will likely understate your true return, because it pretends all your money was invested from day one. For anything beyond a very loose estimate, compute XIRR instead — it only takes a minute in a spreadsheet.

Does XIRR account for SIP top-ups and partial withdrawals?

Yes. That's its main strength. Add each top-up as another negative cashflow on its date and each redemption as a positive cashflow on its date. XIRR weights every one of them correctly, which is exactly why it works for messy, real-world portfolios.

What format must the dates be in for the XIRR function?

They must be genuine date values that the spreadsheet recognises, not text that merely looks like a date. If XIRR throws an error, reformat the date column as Date and ensure the values and dates ranges are the same length.

Bottom line: use CAGR when you invested once and left it alone; use XIRR for SIPs and any portfolio with multiple inflows or outflows. When your app shows a SIP return, it's almost certainly XIRR — and that is the number you should trust to judge how your money has really performed.