What is XIRR? A simple guide for Indian investors
XIRR is your annualised return when you invested money on different dates. It treats every purchase, SIP instalment or withdrawal as a separate cash flow with its own date, then finds the single yearly rate that explains your final value. It is the fairest way to measure returns on a SIP or on any portfolio you built in stages.
Why a simple return can mislead you
Suppose you put in ₹1,00,000 and it grew to ₹1,20,000. That is a 20% gain. If it took one year, 20% a year is a good result. If it took three years, it is much less impressive. A simple percentage ignores time.
It gets worse when you invest in parts. Money you added last month has barely had time to grow, while money added two years ago has had plenty. Adding everything up and dividing by the total invested treats them the same. XIRR fixes this by giving each rupee credit only for the time it was actually invested.
A worked example
Two investors each put in a total of ₹2,00,000 and each ended up with ₹2,30,000 on 1 January 2025. Their simple gain is the same: ₹30,000, or 15%. The difference is when they invested.
| Investor | When the money went in | Simple gain | XIRR (approx.) |
|---|---|---|---|
| A | ₹1,00,000 on 1 Jan 2024 and ₹1,00,000 on 1 Jul 2024 | 15% | 20% |
| B | ₹1,00,000 on 1 Jan 2024 and ₹1,00,000 on 1 Dec 2024 | 15% | 28% |
Investor B put the second ₹1,00,000 in only a month before the end, so the same ₹30,000 gain came from a much shorter time for that money. That is why B's XIRR is higher. Simple return cannot see this. XIRR can.
These figures are illustrative examples for teaching, not real investment results.
Why XIRR matters most for SIPs
A SIP is the textbook case. Say you invest ₹10,000 on the 1st of every month for 12 months (₹1,20,000 in total), and the holding is worth ₹1,30,000 on 1 January 2025. The simple gain is ₹10,000 on ₹1,20,000, which is about 8.3%. That looks low, but most of your money was invested for only a few months. The XIRR works out to roughly 15.7% a year, which reflects how long each instalment was really invested.
If you compare a SIP fund to a lump-sum fund using simple returns, the SIP will almost always look worse than it is. XIRR puts them on the same footing.
XIRR vs CAGR
- CAGR (compound annual growth rate) works when there is one starting amount and one ending amount. Use it for a single lump-sum investment, or to compare how two funds performed over the same period.
- XIRR works when there are several cash flows on different dates, which is how most real portfolios and every SIP work.
For a single purchase with no further investing, the two give essentially the same number. XIRR is the more general tool, and CAGR is the simpler special case.
How to calculate XIRR in Excel or Google Sheets
- In one column, list the dates of every cash flow.
- In the next column, list the amounts. Enter money you invested as negative numbers and money you received or the current value as a positive number.
- Add the current value of the holding as the last row, dated today.
- Use the formula
=XIRR(values, dates), selecting the amount column first and the date column second.
The result is a yearly rate. Format the cell as a percentage.
Common mistakes
- Wrong signs. If every amount is positive or every amount is negative, XIRR returns an error. You need money out and money in.
- Forgetting the current value. XIRR needs a closing positive number to compare against what you invested.
- Using it on very short periods. A holding that is up 3% in two weeks will show an XIRR of dozens of percent because the formula scales it to a full year. Treat XIRR on holdings under a year old with caution.
- Missing dates. Without accurate buy dates, the number means little. If you do not know the date, an estimate is better than leaving it out, but accept that the result is approximate.
What XIRR does not tell you
XIRR looks backwards. A high XIRR does not mean a holding will keep performing, and a low one does not mean it will not recover. It also does not tell you how risky the ride was. Use it to understand what you have earned so far, not as a prediction.
See your own XIRR without the spreadsheet
WealthLenz calculates XIRR and CAGR from your actual buy dates, alongside your live gains and losses and your sector allocation. It is free for up to 10 stocks and 3 mutual funds.
Get started freeThis article is for general education only and is not investment advice. See our Disclaimer.
Next: CAGR vs XIRR vs absolute return →
Also read: How to track mutual funds and stocks together
→
