A ₹60,000 SIP that grows to ₹64,500 in a year has gained 7.5%. Its XIRR, over the same period, is about 14.1%. Both numbers are correct, and neither one is a typo. That gap is the whole reason this metric exists. Understanding what is XIRR in mutual funds tells you which figure answers your question, and which one is quietly flattering your record.
What Is XIRR in Mutual Funds?
XIRR stands for Extended Internal Rate of Return. It is the single annual rate that ties every rupee you put in, on the date you put it in, to what your holding is worth now.
A cash flow is money moving. Each instalment you pay is an outflow. Each redemption, and the current value of your units, is an inflow.
The xirr meaning in mutual fund terms is narrower than most assume. It is not the scheme’s return, but yours from that scheme.
Why Is XIRR Important for Mutual Fund Investors?
Every sip investment you run is a stack of separate purchases at different Net Asset Values (NAV) on different dates.
Your January instalment worked for twelve months. Your December instalment worked for one. Any method treating ₹60,000 as though it arrived on day one is measuring an investment you never made.
XIRR credits each rupee for the time it actually spent invested.
How Does XIRR Work?
XIRR works by discounting each cash flow back to the date of the first cash flow, taking the exact number of days between transactions into account and using a 365-day year.
The calculation then uses an iterative method to find the annualized rate at which the net present value of all cash flows is zero. In Microsoft Excel, the XIRR function starts with a default guess of 10% unless another guess is provided. It continues iterating until the result meets Excel's specified accuracy of 0.000001%, or until it reaches 100 iterations. If it cannot find a result within those iterations, Excel returns a #NUM! error.
Why Is XIRR Important?
Beyond SIPs, it is the only return figure that puts unlike investments on one scale. A running SIP, a lumpsum, a fixed deposit, and etfs you bought in three tranches all become annual percentages.
It also grades your behaviour, not the fund manager’s. Pausing instalments, topping up in a correction, or panic-redeeming each move the number. The scheme’s published return does not budge.
XIRR Formula Explained
The xirr formula solves for r in this equation:
0 = Σ [ Pi ÷ (1 + r)(di − d1) ÷ 365 ]
Pi is each cash flow, di is its date, and d1 is the first date. Investments go in as negative amounts. Redemptions and the current value are positive.
There is no way to rearrange this to isolate r, so it is found by trial. That is why every platform leaves the job to software.
How to Calculate XIRR in Mutual Funds (With Example)
Put dates in one spreadsheet column and amounts in the next, then apply =XIRR(values, dates).
Take a hypothetical twelve-month SIP of ₹5,000, paid on the first of each month in 2025.
Row | Date | Amount entered |
Instalments 1 to 12 | 1st of each month, January to December 2025 | -5,000 |
Current value | 1 January 2026 | +64,500 |
Formula | =XIRR(B1:B13, A1:A13) | About 14.1% |
You invested ₹60,000 and hold ₹64,500, a gain of ₹4,500. The mutual fund XIRR on that record is roughly 14.1%. These figures are illustrative, not a forecast.
XIRR vs CAGR: What’s the Difference?
Compound Annual Growth Rate (CAGR) assumes one entry and one exit. Feed it the same ₹60,000 growing to ₹64,500 and it returns 7.5%, because it never learns that most of that money arrived late.
Basis | XIRR | CAGR |
Transactions | Many, on any dates | One in, one out |
Uses actual dates | Yes | Period length only |
Suits | SIPs, top-ups, partial exits | A single lumpsum |
Where you see it | Your account statement | Factsheets and advertisements |
That last row matters. SEBI requires scheme performance to be advertised in CAGR for one, three and five years and since inception (SEBI circular, March 2017). Your statement uses the other method, so the two rarely agree. A cagr calculator settles a lumpsum.
XIRR vs Absolute Returns
Absolute return is current value minus amount invested, divided by amount invested. On the example above, ₹4,500 on ₹60,000 is 7.5%.
It ignores time. Across that year, your money was invested for an average of about six and a half months, not twelve. Counting that turns 7.5% into 14.1%.
It is fine below one year. Past that it understates a SIP and flatters a long lumpsum, where 100% over ten years is about 7.2% compounded.
Benefits of Using XIRR in Mutual Funds
- Handles irregular dates and amounts, including paused, stepped-up or skipped instalments
- Uses the actual rupee amounts that left and reached your bank, so exit loads are inside the result
- Covers a whole portfolio of mutual funds in one calculation, not one scheme at a time
- Reports negative values plainly, instead of hiding a loss behind a horizon
Ready to start investing? Explore Online Mutual Fund Investment and choose funds aligned with your financial goals and investment horizon.
Choosing the Best XIRR Mutual Fund
There is no fund you can buy for its XIRR, because the number is built from your transactions, not the scheme’s. Two people in one scheme, starting a week apart, will show different figures.
Some fund houses publish an indicative SIP XIRR from historical dates. Treat it as one input alongside the mandate, the risk level and the expense ratio.
Past performance does not indicate future results.
Limitations of XIRR
The clean single number hides assumptions.
It treats every rupee returned to you as reinvested at the same rate for the rest of the period. Real portfolios rarely cooperate.
It is also live. A weak market week lowers the figure even though nothing about your investing changed.
Two mechanical limits matter. Excel needs at least one negative and one positive amount or it returns a #NUM! error, and dates stored as text break it. Where money moves in and out repeatedly, more than one rate can fit the data.
When Should You Use XIRR?
Use it when your record has more than one transaction date: a SIP running beyond a year, several lumpsums, top-ups, or partial withdrawals.
Skip it for a single lumpsum held to one exit, where CAGR is simpler and says the same thing. Skip it below one year, where annualising means little.
Tips to Improve Your Mutual Fund Returns
None of these promise a better outcome. They remove avoidable damage.
- Keep instalments running through falling markets, so each buys more units at lower NAVs. This is rupee cost averaging. It softens the effect of a single entry price without removing market risk
- Match the scheme’s mandate and horizon to the goal you are funding
- Compare expense ratios within a category, since the charge applies in any market
- Model the instalment before you commit, using a sip calculator
- For a one-time deployment, check the horizon in a lumpsum investment calculator
Conclusion
XIRR answers one question well: what annual rate has your own transactions earned. It will not tell you whether a scheme is well run, and it will not match a factsheet number built on a different method.
Pull your transaction history into a sheet, add today’s value as the final positive figure, and run it. Read the answer next to the fund’s published CAGR, and treat the gap as information about your timing.