What is XIRR in Mutual Funds and When to Use It?
XIRR in mutual funds is the true annualised return on investments made on different dates and in different amounts. Use it whenever your money goes in or comes out at irregular intervals, like a SIP, top-up, or partial redemption.
Most mutual fund investors check the wrong return number. They look at absolute return or CAGR, but those numbers lie when you invest in installments. The honest answer is XIRR, and most people get this wrong.
XIRR in mutual funds is the true annualised return on investments made on different dates and in different amounts. You should use it whenever your money goes in or comes out at irregular intervals, like a SIP, a top-up, or a partial redemption.
What is XIRR in mutual funds, really?
XIRR stands for Extended Internal Rate of Return. It is a single percentage that tells you how fast your money grew per year, even when cash flows are messy.
A normal CAGR formula assumes one lump sum invested on day one and one redemption on the last day. Real life does not work that way. You add money every month. You skip a month. You redeem half. You top up during a market crash. XIRR handles all of that in one number.
Think of it as the bank interest rate that would have produced the exact same final value, given the exact same dates and amounts you actually invested.
Why CAGR fails for SIP investors
CAGR is fine for a one-time investment held for years. Drop in 1,000 dollars, pull out 1,500 dollars five years later, and CAGR gives you a clean answer.
But say you run a SIP of 100 dollars per month for three years. Each instalment has a different holding period. Your first instalment compounds for 36 months. Your last one compounds for one month. Treating the total as a single lump sum is just wrong, and the number you get is misleading.
This is the part most people get wrong. They divide profit by total invested, multiply by 100, and call it the return. That is a profit percentage, not an annual return. It ignores time completely.
When you should use the XIRR calculation
Use XIRR any time the cash flows are uneven. Here are the common cases:
- SIP returns: monthly contributions across many years.
- SWP withdrawals: regular money pulled out from a fund.
- STP transfers: moving money in chunks between two funds.
- Lump sum plus top-ups: one big buy followed by smaller ones.
- Partial redemptions: selling units mid-way and holding the rest.
- Goal tracking: measuring real progress toward retirement or a child's fees.
For a clean lump sum invested once and held until maturity, plain CAGR is enough. You do not need XIRR there.
How to calculate XIRR in Excel or Google Sheets
You do not need to do the math by hand. The formula is built into spreadsheets.
- List every cash flow in column A. Use a negative number for money going out (your investment) and a positive number for money coming back (redemption or current value).
- List the matching date in column B for each cash flow.
- The last row should be your current portfolio value as a positive number, with today's date.
- In any empty cell type: =XIRR(A2:A20, B2:B20) and press Enter.
The result is your annualised return, expressed as a decimal. Format it as a percentage. That is the number you should track.
A quick worked example
Imagine you ran a SIP of 5,000 rupees for 12 months in a midcap fund. Total invested is 60,000 rupees. After one year your portfolio is worth 66,000 rupees.
Profit looks like 10 percent. But XIRR will show roughly 18 percent, because each instalment was invested for less than a full year. The 10 percent figure understates how hard your money actually worked. That is why fund houses report XIRR for SIPs.
What is a good XIRR for mutual funds?
There is no single magic number. It depends on the category and the time frame. As a rough guide for a multi-year horizon:
- Liquid funds: 5 to 7 percent.
- Debt funds: 6 to 9 percent.
- Hybrid funds: 9 to 12 percent.
- Large-cap equity: 10 to 13 percent.
- Mid and small-cap: 12 to 18 percent, with much more volatility.
Always compare your XIRR against the fund's benchmark index, not against your neighbour's hot tip. A 14 percent XIRR sounds great until you find the index did 17 percent. For a deeper view of fund categories and disclosure norms, the regulator's site at sebi.gov.in is the cleanest source.
Common mistakes when reading your XIRR
A few traps catch new investors. Watch for these:
- Judging XIRR after only six months. Short-term numbers are noise, not signal.
- Forgetting to include the latest portfolio value as the final positive cash flow.
- Mixing dates from different funds in the same calculation.
- Comparing XIRR of an equity SIP with the FD rate. Different risk, different rules.
- Ignoring tax. Post-tax XIRR is what you actually keep.
Run the number once a year, not every week. Markets move. Your job is to stay invested, not to refresh the sheet. A small habit of reviewing your XIRR alongside your goal value gives you a much clearer picture than chasing the daily net asset value or any star rating you read online.
Frequently asked questions
Below are quick answers to the most common XIRR questions.
Frequently Asked Questions
- What is the difference between XIRR and CAGR?
- CAGR assumes a single lump sum invested once and redeemed once. XIRR handles many cash flows on different dates, which is why it is the right metric for SIPs, SWPs, and any portfolio with top-ups or partial withdrawals.
- Is a higher XIRR always better?
- Not on its own. A higher XIRR usually means higher risk and higher volatility. Always compare your XIRR with the fund's benchmark and the category average over the same period before judging the result.
- Can XIRR be negative?
- Yes. If your current portfolio value is lower than what you invested, your XIRR will be negative. This is common in the first year of an equity SIP during a market correction and tends to recover with time.
- How often should I check the XIRR of my mutual fund?
- Once or twice a year is enough for long-term goals. Checking it every week creates noise and pushes you toward emotional decisions. Review it at the same time you rebalance your portfolio.
- Does XIRR include taxes and exit loads?
- By default, no. The XIRR formula uses only the cash flows you enter. To get a post-tax XIRR, reduce the redemption value by the capital gains tax and any exit load before plugging it into the formula.