Your mutual fund app shows 28% absolute return. But you started the SIP 3 years ago. What is the actual annual return? XIRR gives you the real answer.
XIRR answers the question that absolute returns and even CAGR get wrong: what is the real annual return on money invested at different times in different amounts? When you run a SIP, every monthly instalment goes in at a different NAV on a different date. Some of those investments have been compounding for 5 years. Others for 3 months. Simple percentage gain ignores all of this. CAGR handles only a single upfront investment. XIRR handles the actual pattern of your investments, weighting each cash flow by exactly how long it was deployed, and produces a single annualised return figure that reflects what actually happened to your money.
Three inputs generate the XIRR. Select the investment frequency (monthly for most SIPs), enter the start and end dates of the investment period, enter the amount of each regular investment, and enter the current value of the portfolio. The calculator runs the XIRR formula iteratively and returns the annualised return percentage. For irregular investments (lumpsum additions, missed months, step-up SIPs) use the manual cash flow entry to input exact dates and amounts. XIRR handles irregular patterns as accurately as regular ones.
Three metrics, three different answers to the same underlying question. Absolute return divides total gain by total invested with no regard for time: a 40% gain over 2 years and a 40% gain over 8 years look identical. CAGR handles time correctly but only for a single investment on a single date: it does not work for SIPs or any investment pattern where money enters at multiple points. XIRR handles both the timing and the amount of every individual cash flow. On a 5-year monthly SIP, XIRR tells you the annualised return that makes the present value of all your monthly investments equal to the current portfolio value. That is the only return metric that genuinely reflects your personal investment experience.
Which metric to use when: check absolute return for a quick sense of how much a portfolio has grown in total. Use CAGR for a lumpsum investment or for comparing a fund's historical track record on a single investment basis. Use XIRR for your personal SIP portfolio, for comparing two SIP strategies, or for any investment with irregular cash flows like EMIs, partial redemptions, or dividend reinvestments.
XIRR is the annual return rate that makes the net present value of all your cash flows equal to zero. In plain terms: it is what your money actually earned per year, accounting for the timing of every investment. Invest Rs.10,000 in month 1 and Rs.10,000 in month 60 of a 5-year SIP and those two instalments have had vastly different amounts of time to compound. XIRR weights each investment by exactly how long it was deployed and produces a single annualised return that reflects your actual investment experience rather than a simplified average. Your fund's absolute return of 85% over 5 years translates to a XIRR of roughly 13% annually. That 13% is the number that tells you whether the fund beat its benchmark and whether it earned more than the alternatives you had.
XIRR is solved iteratively using the Newton-Raphson method. The algorithm starts with a guess for the rate, calculates the net present value of all cash flows at that rate, checks whether it is close to zero, and adjusts the guess. This repeats until the NPV is within an acceptable tolerance of zero. The formula for NPV in the XIRR context is the sum of each cash flow divided by (1 + r) raised to the power of (days from the first date divided by 365). Excel's XIRR function uses the same algorithm. Most financial calculators and platforms converge in 20 to 100 iterations. The calculator handles this automatically. What matters for you is that the result is more accurate than a CAGR estimate because it processes each individual cash flow rather than only the start and end values.
For equity mutual funds over 5 years or more: above 15% is excellent and places you in the top tier of investors. 12 to 15% is genuinely good and beats most conservative benchmarks. 10 to 12% is roughly in line with long-term Nifty 50 performance and beats inflation meaningfully. Below 10% on an equity fund over 5 years raises the question of whether a passive index fund would have served you better at lower cost. For debt funds, a XIRR between 6 and 8% is the expected range at current rates. The comparison that matters most is not against an absolute number but against the fund's own category benchmark and against what a comparable passive alternative would have returned in the same period.
Negative XIRR means the portfolio is losing money on an annualised basis, not merely giving low returns. For equity funds a 1-year negative XIRR is a normal occurrence during any market correction and is not a signal to act. A 3-year negative XIRR on an equity fund is unusual and worth examining. The question to ask is whether the fund is underperforming its own category or whether the entire category has delivered negative 3-year returns (which happens after sharp market corrections and typically reverses over the next 2 to 3 years). A negative XIRR on a debt fund is a significant red flag and warrants immediate investigation into whether a credit event or duration mismatch caused it.
SIP frequency has almost no meaningful impact on XIRR over periods longer than 2 years. The difference between monthly and daily SIP on the same annual investment amount is typically under 0.2% in XIRR terms over a 5-year period. The theoretical advantage of daily SIP (more averaging points) rarely materialises in practice because daily market movements average out over time. Monthly SIP is administratively simpler and performs nearly identically over the investment horizons where SIP is most useful. The one exception: in highly volatile markets over short periods (6 to 12 months), more frequent SIPs average the entry price across more data points and this effect is slightly visible in the XIRR. Beyond 2 years it disappears entirely.
One-year XIRR is a coincidence, not a measure of skill or fund quality. It reflects a single 12-month market period that is affected far more by broad market conditions than by fund management quality. Ignore it for decision-making. Three-year XIRR covers enough of a market cycle to begin distinguishing fund quality from market timing. Five-year XIRR across different starting points is the most reliable signal. When evaluating a fund, look at 3-year and 5-year XIRR on rolling bases: if the fund has consistently delivered 2 to 3% above its benchmark on a 5-year rolling XIRR, the fund manager is adding value. If not, the fund's XIRR is explained by category performance and a passive index fund would serve you better at lower cost.
Switching from a regular plan to a direct plan of the same fund adds approximately 1% XIRR immediately due to the lower expense ratio. On a Rs.50 lakh portfolio, 1% annually is Rs.50,000 per year in better compounding. Over 10 years at 12% XIRR, the gap between 12% and 13% on Rs.10,000 monthly SIP is approximately Rs.7 lakh in final corpus. The second lever: replace consistently underperforming funds. Funds that trail their category average by more than 1% on a 5-year rolling XIRR basis are costing you returns. Replacing them with index funds in the same category preserves category exposure while eliminating the manager underperformance cost. The third lever is not frequently discussed: the sequence of investments. Larger SIP amounts or lumpsum additions during market corrections disproportionately improve XIRR because those investments compound from a low NAV for the remaining duration.
XIRR (Money-Weighted Return) includes the impact of when you invested. TWRR (Time-Weighted Return) strips out the impact of investment timing and measures only the fund's performance. If you happened to invest a large lumpsum at a market low right before a rally, your XIRR will look exceptional. Your TWRR will look ordinary. The TWRR reflects how well the fund manager performed. The XIRR reflects how well you did, including your timing decisions. Mutual fund performance tables always use TWRR (CAGR for single investment) so different investors in the same fund all see the same benchmark number. Your personal XIRR is a different number that reflects your individual entry pattern. Neither is wrong. They answer different questions.
XIRR works for any investment with dated cash flows. For real estate: enter the purchase price and registration costs as a negative cash flow on the purchase date. Enter each year of rental income received (net of property tax, maintenance, and vacancy) as positive cash flows on their actual dates. Enter the expected sale price minus brokerage as a positive cash flow on the projected sale date. The resulting XIRR tells you the actual annualised return on the real estate investment on a like-for-like basis with equity fund XIRR. Most real estate investors discover that their XIRR on property, once rental income is included and vacancy is honestly accounted for, is between 7 and 10% in Indian metros. Comparing this directly against a 5-year SIP XIRR in an equity index fund is one of the most useful asset allocation exercises available.
Running the XIRR calculation on your full portfolio once a year takes about five minutes and gives you three things. First, it tells you whether your investments are on track to reach your financial goals at the current rate. If your retirement target requires 12% annual growth and your portfolio XIRR is 9%, you either need to increase contributions or shift allocation. Second, it lets you compare your personal portfolio XIRR against the category average XIRR for the same period, which tells you whether your fund selection is adding or subtracting value. Third, it creates a historical record. A portfolio XIRR that was 14% three years ago and is now 11% tells you something meaningful about the recent market environment or a specific fund that has underperformed. The XIRR does not lie about what actually happened to your money.
