What does XIRR mean in Mutual fund

Ever wondered how to truly measure the returns on your SIPs or multiple mutual fund investments? The answer lies in a powerful metric called XIRR in Mutual Funds. If you’ve ever struggled to compare returns from different funds or felt confused by all those numbers in your account statement, this blog will help you understand XIRR, why it matters, and how you can use it to make smarter investment decisions.

What is XIRR in Mutual Funds?

XIRR stands for Extended Internal Rate of Return. It’s a way to calculate the annualised return on investments that have multiple cash flows at different times, like SIPs, lump sums, or withdrawals. Unlike simple return calculations or CAGR, XIRR takes into account the timing and amount of every investment and redemption, giving you a real-world picture of your returns.

In simple terms:
If you invest ₹5,000 every month in a mutual fund, withdraw some money after two years, and then add more later, XIRR will tell you the actual annual return you’ve earned, considering all those ins and outs.

How XIRR Works?

• Tracks every cash flow: Every SIP, lump sum, withdrawal, or redemption is counted, along with the date it happened.
• Annualises your return: XIRR converts your unique investment pattern into a single, easy-to-understand annual return percentage.
• Perfect for irregular investments: XIRR works whether you invest monthly, quarterly, or whenever you have spare cash.

Suppose you start a monthly SIP of ₹8,000 in a mutual fund for four years. At the end, your total investment is ₹3.84 lakh, but the fund value is ₹7.5 lakh. Because each SIP is invested for a different period, calculating the return for each is complex. XIRR does the math for you, blending all those returns into one annualised figure.

Real-World Performance: What Does XIRR Look Like?

Recent data shows how powerful XIRR can be for long-term SIP investors. For example, the Edelweiss Mid Cap Fund posted an XIRR of 20.95% on SIP investments over the last 10 years. A monthly SIP of ₹10,000 in this scheme would have grown to ₹36.19 lakh. Similarly, HSBC Small Cap Fund and Axis Small Cap Fund delivered XIRRs of 20.87% and 20.77%, respectively, turning the same SIP into over ₹36 lakh. These numbers highlight why XIRR is the gold standard for measuring real returns from SIPs and multi-year investments.

Difference Between XIRR and CAGR

How to Calculate XIRR in Mutual Funds

The XIRR formula is:

XIRR = (NPV(Cash Flows, r) / Initial Investment) * 100

However, you don’t need to be a math whiz to calculate XIRR! Here’s how you can do it by yourself:

In Excel or Google Sheets:

1. List all your investment and withdrawal dates in one column.

2. Enter the corresponding cash flows in the next column.

• Outflows (investments) as negative numbers

• Inflows (redemptions, withdrawals) as positive numbers

3. Add the current value of your investment as a positive number on today’s date (if you haven’t redeemed everything).

4. Use the built-in XIRR function, or alternatively use the formula:
   =XIRR(values, dates)

Excel or Google Sheets will instantly give you your annualised XIRR.

Online Tools:

You can also use free online XIRR calculators like Groww’s or Policybazaar’s. Just enter your transactions and dates, and get your XIRR in seconds.

When Should Investors Use XIRR?

• SIPs: If you invest regularly, XIRR is the best way to see your true returns.
• Multiple investments/redemptions: Perfect for those who add or withdraw money at different times.
• Comparing funds: XIRR lets you compare funds even if you started them at different times or with different amounts.
• Planning future investments: Use XIRR to check which funds or strategies that have worked best for you.

Pros and Limitations of XIRR

Tools to Calculate XIRR Easily

• Excel/Google Sheets: Most popular and flexible
• Online XIRR Calculators: Groww, Policybazaar, and other mutual fund platforms offer easy tools
• Mutual fund statements: Many AMCs now show your XIRR directly in your account statement or online dashboard

How XIRR Can Help You Choose Better Mutual Funds?

XIRR gives you the real, annualised return you’ve earned-after considering all your investments and withdrawals. This helps you:

• Compare funds fairly, even if you invested at different times
• Spot underperforming funds and switch to better options
• Set realistic expectations for future returns
• Make smarter decisions about SIPs, SWPs, or lump sum investments

In Summary

XIRR in mutual funds is the gold standard for measuring real-world returns, especially for SIPs and investors with multiple transactions. It’s accurate, annualised, and helps you compare, plan, and optimise your investments like a pro. With top mutual funds delivering XIRRs above 20% over the past decade for SIP investors, understanding and tracking your XIRR can make a real difference in your wealth journey.

Also Read:
- Top 10 Best Mutual Funds in India 2025
- How to Invest in Mutual Funds for Beginners