What Is XIRR in Mutual Funds?
XIRR explained simply: why it is the correct way to measure SIP returns, how it differs from absolute return and CAGR, and how to calculate XIRR for your portfolio.
Educational content only. This article is for learning purposes and does not constitute personalised financial, tax, or investment advice. Investments are subject to market risks. For decisions specific to your situation, consult a SEBI-registered investment adviser. Read our editorial standards.
What Is XIRR in Mutual Funds?
When you check your mutual fund returns, you'll often see a number labelled "XIRR", and it's usually different from the simple "absolute return" figure. XIRR is the most accurate way to measure your actual return when you've invested at multiple points in time (like a SIP). Understanding it tells you what your money is truly earning, accounting for the timing of every investment.
XIRR (Extended Internal Rate of Return) is the annualised return of an investment that accounts for multiple cash flows at irregular dates. For SIPs, where you invest different amounts on different dates, XIRR is the correct measure of return. A simple "total return %" overstates or understates your real performance because it ignores when each rupee was invested.
Why Simple Returns Mislead for SIPs
Imagine a SIP where you invest ₹10,000/month for 12 months. By year-end you've invested ₹1,20,000 and it's worth ₹1,30,000. A naive calculation says "8.3% return." But that's wrong, because your first installment was invested for 12 months while your last installment was invested for only 1 month.
XIRR is the single annualised rate of return that makes the present value of all your investments (outflows) equal to the present value of your current corpus (inflow), accounting for the exact date of each cash flow. It effectively answers: "What annual interest rate, applied to each investment from its own date, would produce my current value?"
Because each SIP installment has been invested for a different length of time, you cannot simply divide total gain by total investment. XIRR handles this by weighting each cash flow by its duration.
Absolute Return vs CAGR vs XIRR
| Metric | What It Measures | When to Use |
|---|---|---|
| Absolute Return | Total % gain, ignoring time | Quick snapshot of total profit |
| CAGR | Annualised return for a single lump-sum over a period | Lumpsum investments held for a fixed period |
| XIRR | Annualised return accounting for multiple dated cash flows | SIPs, additional purchases, partial withdrawals |
Rule of thumb:
- One-time lumpsum, held for N years → use CAGR
- Regular SIP or multiple investments at different dates → use XIRR
A Worked Example
Deepa invests ₹10,000/month for 12 months in an equity fund. Total invested: ₹1,20,000. Year-end value: ₹1,32,000.
Absolute return: (₹1,32,000 − ₹1,20,000) ÷ ₹1,20,000 = 10%
But this 10% was earned in just one year on money that, on average, was invested for only ~6.5 months (the first installment for 12 months, the last for 1 month).
XIRR: ~18–19% annualised.
The XIRR is much higher than the absolute return because most of the money was invested for less than a full year. XIRR tells Deepa her fund is actually delivering ~18% annualised, far more useful than the misleading 10% absolute figure.
This is the key insight: for SIPs, XIRR is usually higher than the absolute return in a rising market, because your money was invested for shorter average durations than the full period.
How XIRR Is Calculated (Conceptually)
You don't need to compute XIRR by hand. Your platform does it. But conceptually:
- List every cash flow with its date: each SIP installment as a negative (outflow), and the current value as a positive (inflow) on today's date.
- Find the single annual rate
rsuch that the sum of all cash flows, each discounted to present value at rater, equals zero. - That
ris your XIRR.
In Excel or Google Sheets, the XIRR(values, dates) function does exactly this. Most fund platforms (Zerodha Console, Groww, MF Central) show XIRR automatically in your portfolio.
Where to Find Your XIRR
| Platform | Where XIRR Appears |
|---|---|
| Zerodha Console | Holdings → returns column shows XIRR |
| Groww | Portfolio → fund detail → returns (XIRR) |
| MF Central / CAS | Consolidated Account Statement returns |
| Excel / Google Sheets | =XIRR(amounts_range, dates_range) |
What's a "Good" XIRR?
There's no universal answer, but context helps:
- Equity funds (long term): 11–15% XIRR is a healthy long-term result, roughly matching or beating the Nifty 50
- Debt funds: 6–8% XIRR is typical
- Below the benchmark: If your equity fund's XIRR consistently trails its benchmark index over 5+ years, consider switching to an index fund
XIRR over short periods (under 3 years) can look extreme, very high in a bull run and negative in a correction, because it annualises recent moves. A -25% XIRR after six months of investing doesn't mean a bad fund; it reflects a recent market dip annualised. Judge equity fund XIRR over 5+ year periods for meaningful conclusions.
Key Takeaways
- XIRR is the accurate annualised return for investments made at multiple dates, like SIPs
- Simple "absolute return" misleads for SIPs because it ignores how long each installment was invested
- Use CAGR for lumpsum; use XIRR for SIPs and multi-date investments
- For SIPs in a rising market, XIRR is usually higher than the absolute return
- Platforms (Zerodha Console, Groww, MF Central) and Excel's XIRR() function compute it automatically
- Judge equity fund XIRR over 5+ years; short-term XIRR can look misleadingly extreme
Use the SIP Calculator to project returns, and read How to Check Mutual Fund Returns to track your actual XIRR over time.
You invest ₹5,000/month via SIP for 1 year (₹60,000 total). Year-end value is ₹66,000. Your absolute return is 10%. Will your XIRR be higher or lower than 10%, and why?
Sources
- AMFI India. Return calculation methodology, XIRR vs absolute return guidance; amfiindia.com
- SEBI Mutual Fund Disclosure Norms. Standardised return reporting requirements for fund factsheets
- Microsoft / Google Sheets Documentation. XIRR() function specification for irregular cash flow returns
- Zerodha Varsity. Educational material on XIRR and SIP return measurement
Frequently asked questions
What is XIRR in mutual funds?
XIRR (Extended Internal Rate of Return) is the annualised return of an investment that has multiple cash flows on different dates, exactly the case with SIPs, where each instalment enters on a different day and compounds for a different duration. XIRR gives one single annual percentage that correctly accounts for the timing of every investment, making it the most accurate measure of your true SIP return.
What is the difference between XIRR and CAGR?
CAGR measures the annualised return of a single lump-sum investment over a period. XIRR measures the annualised return when there are multiple investments (and possibly withdrawals) on different dates. For a one-time investment, use CAGR; for SIPs or any series of dated cash flows, use XIRR. XIRR is essentially CAGR generalised to handle irregular, multiple cash flows.
Is a higher XIRR better?
Yes. A higher XIRR means a higher annualised return on your invested money, accounting for timing. For equity funds, a long-term XIRR of 12% or more is generally good. However, always compare XIRR over the same time period and against the fund's benchmark; a high XIRR over a short bull-market window is less meaningful than a steady XIRR over 5+ years across different market conditions.
How do I calculate XIRR?
The easiest way is a spreadsheet: list every SIP instalment as a negative amount with its date, add today's portfolio value as a positive amount with today's date, then use the formula =XIRR(values, dates). Most broker apps and your Consolidated Account Statement (CAS) also show XIRR automatically. The spreadsheet method gives you full control and the most precise figure.
Try Our Free Tools
Put what you’ve learned into action with our calculators and courses.
Continue Learning
This guide is part of our Mutual Funds course. Start with the related chapter:
Understanding Returns - XIRR, CAGR, AbsoluteThe Finance Signal
One email a week: a calculator tip, a concept explained, and the guide of the week. No spam, unsubscribe anytime.