The app shows 18 percent. Your friend shows 11 percent. Both numbers can be honest. Xirr in mutual fund means an annualised rate on money that did not all arrive on the same day.
Quick Answer Box
XIRR is Extended Internal Rate of Return. Use it for SIPs. Use CAGR for one lump sum. There is no single good XIRR. Excel, CAS and the major Indian apps all compute it. Compare only matching periods.
What Does XIRR Mean in Mutual Fund Investments?
What is XIRR in mutual funds, in one line: the yearly rate that explains every installment and the value you hold now.
Full form: Extended Internal Rate of Return.
The solver finds rate rrr such that
∑iCi(1+r)(di−d0)/365=0\sum_{i} \frac{C_i}{(1+r)^{(d_i-d_0)/365}} = 0i∑(1+r)(di−d0)/365Ci=0
C_i is the cash flow on date d_i. The money you pay in is negative. Money that comes out, and the current value treated as if sold today, is positive.
That is why a SIP statement uses XIRR and a five-year lump-sum factsheet uses CAGR.
Absolute return is only
Current value−Amount investedAmount invested×100\frac{\text{Current value}-\text{Amount invested}}{\text{Amount invested}}\times 100Amount investedCurrent value−Amount invested×100
A SIP of ₹10,000 a month for three years can show a large absolute gain and a modest XIRR, because most units were bought recently.
How to Calculate XIRR for a Portfolio
How to calculate XIRR for my mutual fund portfolio:
- List each purchase date and amount as a negative number.
- Enter each redemption as a positive number.
- Fill in today’s date and the current market value as a positive number in the last row.
- In Excel or Google Sheets: =XIRR(amount_range,date_range).
- Express as a percentage.
How to calculate XIRR on your mutual fund investments:units “unsold” to another column. One closing price.
A switch is a redemption of fund A and a purchase of fund B. Portfolio XIRR needs both legs or you will double count.
What Is a Good XIRR?
SEBI has no answer for what is good XIRR in mutual fund and how much XIRR is good for mutual fund.
Headline over context:
- A 6-7 per cent liquid fund can be in a line with its category.
- An equity SIP at 12 per cent over seven to ten years has often matched long Indian equity SIP experience cited around the low teens, not a bull year print.
- The same 12 percent in a small-cap fund in a strong cycle can be par for the course in that category.
- One year XIRR after a rally is not career grade.
- A negative XIRR means the set of cash flows is under water. It is permitted. This is not a software bug.
Look at the number compared to the category index on those same dates, not some cousin’s screenshot.
Can XIRR Compare Funds?
Can I use XIRR to compare mutual funds returns effectively?
If three locks match, yes:
- Same start/end dates
- Same cash flow pattern (either both SIPs or both lump sums)
- Same category
A flexi-cap SIP XIRR versus a gilt fund XIRR is a risk comparison, not a skill comparison. Factsheet CAGR is still the cleaner peer table for lump-sum category ranks. Your personal XIRR is the cleaner number for your SIP.
Which Platforms Show It?
What mutual fund platforms provide XIRR calculation tools? Best apps to check mutual fund XIRR performance in India?
There is no official list of best apps. They are already computing it on these surfaces:
- CAMS and KFintech consolidated account statements (mail-back CAS)
- Central-MF
- AMC apps & websites normally at folio level
- Broker and advisory apps like Groww, Zerodha Coin, Kuvera, INDmoney, Paytm Money
The usual reason for a disagreement of two apps is not a new formula but a missing transaction or the different “as on” date. CAS reconcile with the registrar
Table 1: Financial & Technical Data Matrix – Three Returns
| Metric | Time? | Many dates? | Use on |
| Absolute | No | No | Short glance |
| CAGR | Yes | No | Lump sum, factsheet |
| XIRR | Yes | Yes | SIP, STP, SWP, your folio |
Risk Analysis: Eleven XIRR Errors
- Calling a one-year XIRR a fund rating.
- Comparing SIP XIRR with factsheet CAGR.
- Forgetting the sign on purchases.
- Counting current value twice.
- Ignoring a switch.
- Treating 15 percent as “good” in a debt fund.
- Treating 9 percent as “bad” in a large-cap SIP after a flat year.
- Using XIRR on a three-month SIP.
- Mixing regular and direct without saying so.
- Trusting an app that missed an old ARN folio.
- Selling because a friend’s XIRR is higher on a different start date.
Table 2: Generic Advice vs. Strategic Thinking Matrix
| Decision Point | Generic Advice | Strategic Thinking |
| Good XIRR | “Above 15%” | Versus category and years |
| SIP score | “Use CAGR” | Use XIRR |
| App | “Best tracker” | Match it to CAS |
| Compare funds | “Highest XIRR wins” | Same dates, same category |
| Negative print | “Bug” | Loss on that cash-flow set |
Strategic thinking keeps the CAS and reads the rate beside the benchmark.
Closing Perspective
What is XIRR in mutual fund? XIRR in mutual fund is the yearly rate on uneven cash flow. That’s the SIP number. CAGR is the lump sum number. Absolute return isn’t. Compute it on a sheet or read it on the registrar statement. A good figure is one that fits the category over a long window, not a number pulled out of a bull year.
This is general information, not a guarantee of return.
People Also Know
What does XIRR mean in mutual funds?
Extended Internal Rate of Return: one annualised rate for investments and withdrawals on different dates.
How do I calculate it?
Negative purchases, positive redemptions, positive current value, then Excel =XIRR(values, dates).
What is a good XIRR?
Depends on category and horizon. Low-teens over long equity SIPs has been a common Indian experience, not a rule.
Which app is best?
No official best. CAMS, KFintech, MF Central and major broker apps all show it.
Can I compare funds with XIRR?
Only over the same dates and category.
Can XIRR be negative?
Yes. That cash-flow set is at a loss.
XIRR or CAGR for a SIP?
XIRR.
How can WealthMunshi help?
WealthMunshi Provides investment-advisory support to read folio XIRR against goals, not to guarantee rate.
Screenshot of a goal date-free portfolio XIRR. And readers with five years of SIPs can book a return and allocation review before they switch on a one year print.





