What does XIRR mean in Mutual Fund
Learn what XIRR means in mutual funds, how it's calculated, and what is considered a good XIRR. Check out our blog for detailed insights.
Rajat Kulshrestha
Head of Mutual Fund Distribution
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
|
Feature |
XIRR |
CAGR |
|
Cash Flow Timing |
Handles multiple, irregular cash flows |
Only works with a single, lump sum |
|
Use Case |
SIPs, SWPs, multiple investments/redemptions |
One-time investment, no withdrawals |
|
Accuracy |
More accurate for real-world investments |
Can be misleading for SIPs |
|
Calculation |
Considers dates and amounts of all flows |
Only considers start and end values |
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:
-
List all your investment and withdrawal dates in one column.
-
Enter the corresponding cash flows in the next column.
-
Outflows (investments) as negative numbers
-
Inflows (redemptions, withdrawals) as positive numbers
-
Add the current value of your investment as a positive number on today’s date (if you haven’t redeemed everything).
-
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 calculator 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
|
Pros |
Limitations |
|
|
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 Gold and Silver Mutual Funds in India (2026)
- Gold ETF vs Gold Mutual Fund: Which is Better in 2026?
Frequently Asked Questions
Q1. What is XIRR full form in mutual funds?
Ans: XIRR stands for Extended Internal Rate of Return. It’s an annualised return calculation that accounts for multiple cash flows at different times.
Q2. Why is XIRR better for SIP investments?
Ans: Because SIPs involve regular investments at different times, XIRR gives a true picture of your annual return, unlike CAGR, which only works for lump sum investments.
Q3. Can XIRR be negative? What does it mean?
Ans: Yes. A negative XIRR means your investment’s current value is less than the total money you’ve put in. This can happen if the fund has performed poorly or if markets have fallen.
Q4. What’s a good XIRR for mutual funds?
Ans: A “good” XIRR depends on your fund type and market conditions. Top-performing equity mutual funds in India have delivered XIRRs of 15–21% over the past decade for SIP investors. Historically, equity mutual funds in India have delivered 10–15% XIRR over the long term, but some small and mid-cap funds have crossed 20% XIRR in 10 years.
Q5. How to calculate XIRR in mutual funds?
Ans: List all transactions and dates, use the XIRR function in Excel or an online calculator, and you’ll get your annualised return.
Q6. Difference between XIRR and CAGR?
Ans: XIRR handles multiple, irregular cash flows. CAGR only works for one-time, lump sum investments.
Q7. When should investors use XIRR?
Ans: Whenever you have SIPs, multiple purchases, redemptions, or any irregular investment pattern.
Q8. Are there any limitations to XIRR?
Ans: Yes. It requires accurate transaction records and isn’t as straightforward for single investments.
Rajat Kulshrestha
Head of Mutual Fund Distribution
Rajat Kulshrestha brings over seven years of experience in public markets, specialising in fundamental analysis and valuation frameworks. In his role as Mutual Fund Distribution Head, he oversees portfolio strategy, asset allocation decisions, and fund evaluation processes. On this blog, he offers structured, research-oriented perspectives on SME-listed companies, aiming to enhance financial literacy and analytical depth among market participants.
