XIRR in Mutual Funds: The Real Story Behind Your Portfolio Returns

XIRR: The Only Return Number That Tells You the Truth

You’ve been investing in a mutual fund SIP for three years. Your app shows a 14% return. Your friend invested a lump sum in the same fund and also sees 14%. You both feel equally good. But here’s the thing your actual returns are very different from each other. And neither of you is looking at the right number.

That number is XIRR.

Why Simple Returns Lie (Sometimes)

When you make a single investment and redeem it later, calculating returns is straightforward. Invest ₹1 lakh, get back ₹1.5 lakh in five years done.

But most of us don’t invest that way. We do SIPs monthly investments of, say, ₹10,000. Sometimes we invest extra when markets fall. Sometimes we pause. Sometimes we make partial withdrawals. Each of these transactions happens on a different date, at a different NAV (Net Asset Value the price of one unit of the fund).

So how do you calculate a single, honest return number across all these transactions? You use XIRR.

XIRR stands for Extended Internal Rate of Return. It sounds technical, but the idea is simple. XIRR calculates the annualised return by accounting for the exact dates and amounts of every cash flow every investment, every withdrawal, and the current value of your portfolio. It treats time seriously. A rupee invested two years ago should count differently from a rupee invested last month. XIRR does exactly that.

How XIRR Works Without the Jargon

Think of it like this. If you lent money to a friend in three different instalments ₹10,000 in January, ₹15,000 in June, and ₹5,000 in December and he repaid you a lump sum in March next year, you wouldn’t just add up what you lent and compare it to what you got back. You’d want to know: given when each amount was lent and when it was returned, what was my actual annual return?

XIRR does exactly this calculation for your mutual fund portfolio. It finds the rate of return that makes the present value of all your investments equal to the current value of your portfolio. In plain terms, it reverse-engineers your annualised return by looking at every rupee you put in, on every date you put it in.

How to Calculate XIRR

You don’t need to do this manually. But knowing the logic helps.

1. List all your cash outflows every SIP instalment, every lump sum investment. These are negative numbers because money is leaving your account.
2. Add the current portfolio value as a positive cash flow on today’s date. This represents money coming back to you (even if notionally).
3. Feed this data into Excel or Google Sheets using the =XIRR(values, dates) formula. The software does the heavy lifting.

For example: You invested ₹10,000 every month for 24 months. Your total investment is ₹2.4 lakhs. Today, your portfolio is worth ₹2.85 lakhs. The simple return looks like 18.75% ((2.85-2.4)/2.4). But XIRR might show you 16.2% because your earlier investments have had longer to grow, while recent ones have barely had time to do anything.

That 16.2% is the truth. It is your actual annualised return, adjusted for when each rupee was invested.

XIRR vs CAGR What’s the Difference?

CAGR (Compounded Annual Growth Rate) works perfectly for a single lump sum investment. You put in ₹1 lakh, it becomes ₹2 lakhs in five years. CAGR = 14.87%. Clean and simple.

But CAGR breaks down when you have multiple investments at different times. XIRR picks up exactly where CAGR leaves off. So:

• Use CAGR when you have one investment and one redemption.
• Use XIRR when you have SIPs, multiple investments, or partial withdrawals.

Most mutual fund statements and apps now show XIRR by default for SIP(Systematic Investment Portfolio) portfolios. If yours doesn’t, you should ask why or switch to a platform that does.

Why XIRR Matters More Than You Think

Here’s a practical scenario. Two investors, Anand and Priya, both invest in the same large-cap fund. Anand does a monthly SIP of ₹10,000. Priya invests ₹1.2 lakhs as a lump sum at the start of the year. Both invest the same total amount.

At year-end, if the market has gone up steadily, Priya’s lump sum has compounded the full amount all year. Anand’s SIP instalments have each compounded for a shorter time the January instalment for 12 months, the December instalment for just one month. So Anand’s XIRR will likely be lower than Priya’s CAGR, even if they’re in the same fund.

Neither is a bad investment. But comparing Anand’s return to Priya’s without accounting for this timing difference is misleading. XIRR fixes that.

A Few Things to Keep in Mind

1. XIRR is always annualised. So even if you’re calculating returns for a six-month period, XIRR will show you what that return looks like on a per-year basis. A 6-month gain of 8% would show as roughly 16% XIRR. Keep this in mind so you don’t over-read short-term numbers.
2. XIRR needs accurate data. If your transaction dates or amounts are wrong, the output will be wrong. Always match your data with your actual account statement.
3. Negative XIRR is possible. If your portfolio is currently worth less than what you’ve invested (after accounting for timing), XIRR will show a negative number. That’s not a flaw it’s honesty.
4. XIRR is not a fund performance metric. It reflects your return based on when you invested. Two people in the same fund can have different XIRRs simply because they invested at different times.

To Sum Up

XIRR is the most accurate way to measure your personal return on a mutual fund portfolio with multiple transactions. It accounts for the timing and amount of every investment and withdrawal, and gives you an annualised figure that actually reflects your experience not a theoretical one.

Practically, go to your mutual fund statement or platform, check if XIRR is displayed. If not, download your transaction history and run the =XIRR() formula in Excel or Google Sheets. Compare that number with the benchmark index return over the same period. That comparison will tell you far more about your portfolio’s performance than any marketing material ever will.