XIRR Meaning: How to Calculate It & Why It Matters
In one line
XIRR (Extended Internal Rate of Return) is the annualized return on irregular cash flows, like SIPs or lump-sum investments.
- Reading time
- 7 min
- 1,475 words
- Sections
- 9
- longest: Frequently Asked Questions
- Shelf
- Investing basics
- 25 explainers there
- First published
- Nov 2026
- updated 11 Nov
- 1What Does XIRR Stand For?139
- 2Why Regular IRR Fails for SIPs135
- 3How XIRR Works: Step by Step274
- 4XIRR vs CAGR vs IRR: What’s the Difference?99
- 5Where XIRR Is Used in India118
- 6Common Mistakes and Misunderstandings137
- 7How to Calculate XIRR Yourself97
- 8Frequently Asked Questions304
- 9Related22
Counted from this page's own text. Each row links to its section.
If you have ever invested in a mutual fund through a SIP (Systematic Investment Plan), you have probably seen the term XIRR on your fund statement or in a portfolio tracking app. It looks technical, but it is simply a way to measure the true annual return of an investment where money goes in and comes out at different times and in different amounts.
This article explains what XIRR means, how it is calculated, where it is used, and how it differs from other return measures like CAGR and IRR. You will also see a worked example with round numbers and common mistakes to avoid.
What Does XIRR Stand For?
XIRR stands for Extended Internal Rate of Return. The “X” means “extended” because it extends the standard Internal Rate of Return (IRR) formula to handle cash flows that are not periodic.
In finance, IRR is the discount rate that makes the net present value (NPV) of all cash flows equal to zero. But IRR assumes cash flows happen at regular intervals (like every year). Real investments, especially SIPs, have cash flows on arbitrary dates – you might invest on the 5th of one month, the 12th of the next, and so on. XIRR adjusts for those exact dates.
It is not a new or exotic concept. Spreadsheet tools like Microsoft Excel and Google Sheets have a built-in XIRR function. The formula is widely used by financial analysts, mutual fund houses, and portfolio trackers in India to show returns on SIPs.
Why Regular IRR Fails for SIPs
To understand XIRR, first see why simple IRR is not enough.
Suppose you invest ₹1,00,000 in a mutual fund on 1 January and get back ₹1,20,000 on 1 January next year. The return is clearly 20% – that is the CAGR (Compound Annual Growth Rate).
Now suppose you invest ₹10,000 on the 1st of every month for 12 months (total ₹1,20,000) and at the end of the year your portfolio value is ₹1,32,000. What is your return? It is not 10% (₹12,000 gain on ₹1,20,000) because the first ₹10,000 was invested for 12 months, but the last ₹10,000 was invested for only 1 month. Each instalment has a different holding period.
If you use the simple IRR formula, it assumes each cash flow is exactly one period apart (say, monthly). But in reality, months have different lengths (28, 30, 31 days). XIRR uses the actual calendar dates, so it gives a more accurate annualized return.
How XIRR Works: Step by Step
The XIRR calculation is iterative – it tries different discount rates until the net present value of all cash flows equals zero. Here is the logic in plain steps:
- List all cash flows: money you put in (negative values) and money you get out (positive values), with exact dates.
- Choose a starting guess for the annual rate (say 10%).
- Discount each cash flow back to the start date using that rate and the actual number of days between the cash flow date and the start date.
- Add up all discounted values. If the sum is positive, try a higher rate; if negative, try a lower rate.
- Repeat until the sum is exactly zero. That rate is the XIRR.
In Excel, you would use =XIRR(values, dates, guess). The values are your cash flows (negative for investments, positive for withdrawals), and dates are the corresponding dates.
Worked Example with Round Numbers
Let’s say you started a monthly SIP of ₹10,000 on 1 January 2023. You invested on the 1st of every month for 12 months. On 1 January 2024, your portfolio value is ₹1,30,000.
Your cash flows are:
- 1 Jan 2023: -₹10,000
- 1 Feb 2023: -₹10,000
- 1 Mar 2023: -₹10,000
- … (continue for all 12 months)
- 1 Dec 2023: -₹10,000
- 1 Jan 2024: +₹1,30,000 (this is your current value, treated as a positive cash flow)
If you run the XIRR function on these cash flows, you get an annualized return of about 12.5%. That means your money grew at an effective annual rate of 12.5%, even though the total gain was only ₹10,000 on a total investment of ₹1,20,000.
Why is it higher than 8.33% (₹10,000/₹1,20,000)? Because not all money was invested for the full year. The earlier instalments earned more, and the later ones earned less. XIRR accounts for that timing.
XIRR vs CAGR vs IRR: What’s the Difference?
These three terms are often confused. Here is a simple comparison:
| Term | Best for | Assumes |
|---|---|---|
| CAGR | Lump-sum investments with no intermediate cash flows | Money grows smoothly at one rate over the entire period |
| IRR | Investments with regular periodic cash flows (e.g., yearly) | Cash flows happen at equal intervals |
| XIRR | Irregular cash flows (SIPs, withdrawals, multiple investments) | Cash flows happen on exact dates, any gap |
For a simple lump-sum investment where you put in ₹1,00,000 and get back ₹1,21,000 after 2 years, CAGR and XIRR will give the same answer (10% per year). But for a SIP, XIRR is the only accurate measure.
Where XIRR Is Used in India
In India, XIRR is most commonly seen in:
- Mutual fund statements – many fund houses show XIRR for SIP investments in their consolidated account statements.
- Portfolio tracking apps – apps like Value Research, ET Money, and Groww show XIRR for your entire portfolio.
- Loan calculations – some lenders use XIRR to show the effective annual cost of a loan where you pay EMIs on different dates (though most use reducing balance method).
- Insurance policies – when you pay premiums and receive maturity benefits at different times, XIRR helps compare with other investments.
The Securities and Exchange Board of India (SEBI) does not mandate a single return measure, but the industry has largely adopted XIRR for SIPs because it is the most accurate.
Common Mistakes and Misunderstandings
Here are the most frequent errors people make with XIRR:
- Treating XIRR as a simple average – XIRR is annualized, not a simple average of yearly returns. A 12% XIRR does not mean you earned 12% every month.
- Ignoring the sign of cash flows – Investments must be negative, withdrawals/current value positive. If you flip the signs, the result is meaningless.
- Using XIRR for a single lump sum – For a single investment, XIRR equals CAGR. No need for XIRR.
- Comparing XIRR across different time periods – A 5-year SIP with 15% XIRR is not necessarily better than a 2-year SIP with 12% XIRR. Time matters.
- Forgetting to include the current value – If you are calculating XIRR for an ongoing SIP, you must add today’s portfolio value as a positive cash flow on today’s date. Otherwise, the calculation shows a negative return.
How to Calculate XIRR Yourself
You do not need a finance degree. Here is a simple method using a spreadsheet:
- Open Excel or Google Sheets.
- In column A, list all dates of your investments (and any withdrawals). In column B, list the amounts – negative for investments, positive for withdrawals or current value.
- In a blank cell, type
=XIRR(B1:B13, A1:A13)(adjust the range to your data). - Press Enter. The result is your annualized return.
If you do not want to use a spreadsheet, many online XIRR calculators are available. Just enter the dates and amounts, and they do the math.
Frequently Asked Questions
Is XIRR the same as absolute return?
No. Absolute return is the total gain divided by the total investment, without considering time. For example, if you invest ₹1,20,000 and get back ₹1,32,000, the absolute return is 10%. XIRR, on the other hand, annualizes the return based on when each rupee was invested, so it is usually different – often higher for SIPs with rising markets.
Can XIRR be negative?
Yes. If your current portfolio value is less than the total amount you invested, XIRR will be negative. That simply means your investment lost money on an annualized basis.
Does XIRR include taxes or fees?
No. XIRR uses the cash flows you enter. If you enter the net amount after deducting expense ratios or taxes, then it reflects those costs. But the standard XIRR function does not automatically deduct anything. You have to account for fees separately.
Why does my mutual fund statement show a different XIRR than my app?
Different tools may use different dates for the current value (e.g., end of month vs. today). Also, some include the expense ratio in the NAV, while others use a different valuation date. Always check the date and the cash flows used.
Is XIRR better than CAGR for comparing two SIPs?
Yes, for SIPs with different investment dates and amounts, XIRR is the correct comparison. CAGR assumes a single lump sum with no intermediate cash flows, so it would give a misleading picture for SIPs.
Can I use XIRR for my loan EMI?
Yes, you can. If you list the loan amount as a positive cash flow on the disbursement date and each EMI as a negative cash flow on its due date, XIRR gives the effective annual interest rate. However, most Indian lenders use the reducing balance method, which is simpler and may give a slightly different number.
Related
Rules referred to on this page come from their publishers: the Reserve Bank of India (banking, payments), SEBI (markets, mutual funds), NPCI (UPI), the Income Tax Department (tax). Rates and fees change; check the provider's own page. General information, not financial advice. Sources and method
Spotted an error? Tell us and we will correct it (corrections).