The XIRR is omnipresent. It can be found in mutual fund statements, on bond platforms, and in the insights your broker provides about your portfolio. But what does it mean? How do you calculate it? Experience this conversation between two friends as they discuss the action while their electric vehicle is charging.
Abhishek: Dude, I was looking at my mutual fund statement yesterday and came across this metric called XIRR. I know you work in finance. Can you help me understand this?
Anand: Naturally. XIRR stands for Extended Internal Rate of Return. However, before understanding what XIRR is, you must first understand the concept of IRR.
Abhishek: Keep going.
Anand: The textbook definition is as follows: IRR is the discount rate at which the present value of cash inflows equals the present value of cash outflows.
Abhishek: Got it. But how do they calculate this discount rate?
Anand: We have built-in Excel formulas to make this super easy, which I’ll talk about later. However, have you wondered why IRR exists?
Abhishek: Actually yes! Don’t we already have enough ways to measure returns – such as CAGR (Compounded Annual Growth Rate), absolute returns, etc.?
Anand: Of course we do. However, CAGR and absolute returns have their limits. If you look at CAGR, it is used to measure returns between point A and point B. Point A is the time you invested your capital and point B is the maturity date. What if your investment has intermediate cash flows – such as a bond that pays annual interest or a mutual fund paired with a monthly SWP option? There is simply no scope for applying CAGR in such cases. Therefore, it is best suited for investments with a single maturity value in the future.
The absolute return, also known as the holding period return, is more limited in scope. While the CAGR at least takes the time factor into account, the absolute return does not differentiate between a two-year and a five-year investment.
So we need a flexible measure that works regardless of the timing of cash flows – lump sums or SIPs, interim or cumulative payouts – and helps compare returns across any two investment products across the board. That is exactly the goal of using IRR. Additionally, with IRR, the returns you receive are already adjusted to fair value, making it a better and more accurate measure than CAGR and holding period returns.
Abhishek: Sounds cool. But are IRR and XIRR the same?
Anand: Well, basically the formula for XIRR in Excel is based on the textbook concept of IRR that I mentioned earlier. However, there is another formula in Excel called IRR that only works when the interval between two cash flows is equal. Think quarterly, semi-annually, annually and so on. However, if the interval is less than one year, the result must be extrapolated to the year.
If the cash flows are random, the IRR function will not work. Here you need to use the XIRR function, which has an expanded scope and responds more flexibly to the timing of cash flows.
Abhishek: Interesting! Last week I was looking for a bond opportunity. It promised semi-annual interest payments for three years and repayment at par. But I remember the website mentioned both XIRR and coupon rate. The XIRR was 8.15 percent while the coupon was only 8 percent. Why is this difference?
Anand: That’s a good question. Because when you receive interim cash flows – like the semi-annual interest you mentioned – XIRR assumes that you are reinvesting the interest until maturity at the rate of XIRR itself. For example, when you receive the first interest payment, the formula assumes you reinvest it at 8.15 percent for 2.5 years. So on and so forth for the other interest income. This is the reason for the difference.
If you spend the interest or leave it sitting in a savings account earning 2-3 percent interest, your net realized returns at maturity will not be as high as the claimed XIRR. Therefore, set your expectations accordingly.
But you can use the XIRR to compare and gain perspective.
In connection with fixed-interest securities, XIRR is also referred to as YTM or Yield to Maturity.
Abhishek: In order. I’ll remember that. Can you teach me to calculate the XIRR for my index fund? It is a semi-annual SIP for ₹50,000 which I started on January 1, 2024. On September 30 this year, I sold units worth ₹20,000. The statement states that the current value of my holdings is ₹1,95,000.
Anand: Secure. The XIRR calculation is very easy. All it takes is two inputs – the cash flows in one column and the corresponding dates they occur in another column. Remember that cash outflows like capital, purchase price and SIPs should have a minus sign. You may also have a third column that describes the meaning of cash flows for your reference.
When this is done, call the XIRR function and define the range of cash flows followed by the date range and press Enter. That’s it. Your XIRR will be calculated.
You can use this method not only for mutual funds, but for any investment product with cash flows.
The screen glowed bright green and said “Fully Charged” when Anand was finished.
Published on December 13, 2025