How to Calculate XIRR (Step by Step) – India Guide

If you invest in mutual funds through a Systematic Investment Plan (SIP), you cannot judge your returns with a simple percentage gain, because each monthly installment stays invested for a different length of time. This is exactly the problem XIRR solves. Used by Groww, Zerodha Coin, Kuvera, and every other Indian investment platform, XIRR converts a messy series of dated cash flows into a single annualised return you can compare against a fixed deposit or the index. This guide shows you how to calculate it step by step, with Indian rupee examples.

You can automate the whole thing with a free XIRR calculator, but knowing the method lets you verify any platform figure and understand what drives your returns.

Key takeaway: XIRR treats every investment and withdrawal as a separate dated event, so it reflects the real timing of your money in a way that a single-figure CAGR cannot for SIPs.

What Is XIRR?

XIRR stands for Extended Internal Rate of Return. It is the constant annual rate of return that makes the present value of all your cash flows, invested and received, equal to zero on their respective dates. In plain terms, it is the yearly return your portfolio actually earned, accounting for exactly when each rupee went in and came out. For a lumpsum investment held for a whole number of years, XIRR and CAGR give the same answer; for SIPs and irregular top-ups, XIRR is the accurate measure.

Step-by-Step: How to Calculate XIRR

1. List every cash flow with its date. Each SIP installment, lumpsum, or withdrawal is one row with the transaction date.
2. Assign signs correctly. Money you invest is negative; money you receive, including the current portfolio value, is positive.
3. Add the current value as the final row. Use today date and the latest portfolio value as a positive cash flow if you have not redeemed.
4. Enter the data in two columns. One column for amounts, one for dates, in a spreadsheet.
5. Apply =XIRR(values, dates). The function returns the annualised return; format the cell as a percentage.

Worked Example 1: A 12-Month SIP

Suppose Ananya in Bengaluru invests ₹10,000 on the 1st of every month from January to December 2024, a total of ₹1,20,000 across twelve installments. On 1 January 2025 her folio is worth ₹1,32,000. Because the early installments stayed invested for almost a year while the last ones were invested for barely a month, a plain 10% gain badly understates her annualised return. Entering the twelve ₹10,000 outflows and the ₹1,32,000 inflow into =XIRR gives an annualised return of roughly 18.5%. The XIRR is higher than the 10% absolute gain precisely because the average holding period was only about half a year.

Worked Example 2: SIP With a Lumpsum Top-Up

Now imagine Ravi invests ₹5,000 monthly for two years and adds a ₹50,000 lumpsum during a market dip in month 10. XIRR effortlessly handles this irregular pattern: the ₹50,000 is just another dated negative cash flow. If his final value is ₹1,95,000 against total investments of ₹1,70,000, the XIRR might work out to around 14%, capturing both the regular SIP and the well-timed extra investment in one figure. Trying to compute this with CAGR would be impossible because there is no single start date.

XIRR vs CAGR vs Absolute Return

For a one-time investment held three years, CAGR is perfect. The moment you have more than one investment date, or any partial withdrawal, only XIRR gives the correct annualised picture, which is why it dominates Indian portfolio statements.

Why XIRR Matters for Indian Investors

Most Indian retail investors build wealth through SIPs, so XIRR is the number that actually reflects their experience. It lets you compare a mutual fund SIP against a fixed deposit, a recurring deposit, or the Nifty index on an apples-to-apples annualised basis. It also reveals whether your fund is genuinely beating inflation and your goals. Remember that redemptions are taxable, so pair your XIRR view with an understanding of capital gains and your overall tax bracket when planning withdrawals.

Benefits of Using XIRR

XIRR gives a single, honest annualised return that accounts for the exact timing of every rupee, making it the fairest way to judge SIP performance. It works for any pattern of cash flows, however irregular, so you can include bonuses, top-ups, and partial withdrawals without breaking the calculation. Because Indian platforms report XIRR by default, learning it also helps you read your own statements with confidence and compare funds meaningfully.

Challenges and Limitations

XIRR needs accurate dates and amounts for every transaction; a single wrong date can distort the result. In spreadsheets, the function occasionally returns an error if the cash flows never change sign or if the initial guess is far off, in which case you supply a guess value. XIRR also assumes interim cash flows are reinvested at the same rate, which may overstate returns for very high figures. Finally, it says nothing about risk, so a high XIRR from a volatile fund is not automatically better than a steadier one.

Common Mistakes to Avoid

• Wrong signs. Investments must be negative and redemptions positive; reversing them gives a nonsensical result.
• Forgetting the current value. If you have not redeemed, add today value as the final positive cash flow.
• Using approximate dates. XIRR is date-sensitive; use the actual transaction dates, not month-ends.
• Comparing XIRR with absolute return. They measure different things; do not treat a 10% gain as a 10% XIRR.
• Ignoring taxes and exit loads. XIRR shows gross return; your in-hand return is lower after tax and charges.
• Chasing XIRR without risk context. A very high XIRR may come with high volatility.

Best Practices and Expert Recommendations

• Maintain a transaction log. Keep dates and amounts so you can recompute XIRR any time.
• Recalculate at least annually. Review each fund XIRR against its benchmark and your goals.
• Compare like with like. Use XIRR for both the fund and the alternative you are considering.
• Adjust for taxes. Estimate post-tax XIRR before making withdrawal decisions.
• Use a guess value if needed. If the formula errors, add a guess such as 0.1 to help it converge.
• Look at XIRR alongside risk. Consider volatility and your time horizon, not the return alone.

Frequently Asked Questions

What is a good XIRR for mutual funds in India?
For equity mutual funds, an XIRR of 12–15% over the long term is generally considered good, as it comfortably beats fixed deposits and inflation. Debt funds naturally show lower XIRR in line with their lower risk.

Is XIRR the same as CAGR?
Only for a single lumpsum held over whole years. For SIPs and any investment with multiple dated cash flows, XIRR is the correct measure because it accounts for the timing of each transaction, while CAGR assumes one start and one end.

How do I calculate XIRR in Excel?
Put your cash flows in one column (investments negative, redemptions and current value positive) and their dates in the next column, then use =XIRR(values, dates) and format the result as a percentage.

Why is my XIRR higher than my absolute return?
Because XIRR is annualised and your SIP installments were invested for less than a full year on average. A modest absolute gain over a short average holding period translates into a higher annualised XIRR.

Does XIRR account for tax?
No. XIRR shows your gross annualised return. To know your real take-home return, reduce it for capital gains tax and any exit loads that apply to your redemptions.