XIRR (Extended Internal Rate of Return)
XIRR (Extended Internal Rate of Return) is an annualised return measure for investments with multiple cash flows on different dates, such as SIPs, top-ups and withdrawals, making it the standard way to measure SIP returns.
What Is XIRR (Extended Internal Rate of Return)?
XIRR (Extended Internal Rate of Return) is a way of calculating the annualised return on an investment where money goes in or comes out at different times and in different amounts.
Most real-life investing looks like this. You start a Systematic Investment Plan (SIP), add a lump sum during a bonus month, skip an instalment, and later make a partial withdrawal. Each rupee has been invested for a different length of time. A simple percentage gain cannot capture this. XIRR can.
You will find XIRR in your mutual fund portfolio statements, investment apps and distributor reports. It is the most practical answer to the question: "What yearly return have I actually earned on my money?"
How Does XIRR Work?
XIRR finds the single annual rate that, when applied to every cash flow based on its exact date, makes the total present value of all cash flows equal to zero.
- List every cash flow with its date. Investments are entered as negative numbers (money leaving your pocket). Redemptions and the current value are entered as positive numbers.
- Measure time precisely. Each cash flow is discounted for the exact number of days between its date and the first cash flow, divided by 365.
- Solve for the rate. There is no simple formula. Spreadsheets and software try different rates repeatedly (iteration) until the present values balance out.
- Read the result as a yearly rate. XIRR is already annualised, so it can be compared with FD rates, inflation or a fund's CAGR.
The "extended" in the name means it extends the standard Internal Rate of Return (IRR), which assumes evenly spaced cash flows, to handle irregular dates.
Practical Example
Illustrative example 1: a simple 12-month SIP
Rahul invests ₹10,000 on the 5th of every month from January 2025 to December 2025 (12 instalments). On 5 January 2026, his investment is worth ₹1,28,000.
- Total invested = ₹10,000 × 12 = ₹1,20,000
- Gain = ₹1,28,000 − ₹1,20,000 = ₹8,000
- Absolute return = ₹8,000 ÷ ₹1,20,000 = 6.67%
But Rahul's money was not invested for a full year. The January instalment was invested for 12 months, while the December instalment was invested for just 1 month. On average, his money was invested for only about six and a half months. When each instalment is weighted by its actual time invested, the XIRR works out to approximately 12.5% per year.
Illustrative example 2: two lump sums
Meena invests ₹50,000 on 1 January 2025 and another ₹50,000 on 1 January 2026. On 1 January 2027, her holding is worth ₹1,15,000.
| Date | Cash flow |
|---|---|
| 1 Jan 2025 | −₹50,000 |
| 1 Jan 2026 | −₹50,000 |
| 1 Jan 2027 | +₹1,15,000 |
Absolute return = ₹15,000 ÷ ₹1,00,000 = 15%. Since the first ₹50,000 was invested for two years and the second for only one year, the XIRR is approximately 9.7% per year. You can check it: ₹50,000 × 1.097² + ₹50,000 × 1.097 ≈ ₹60,170 + ₹54,850 ≈ ₹1,15,020, which is close to ₹1,15,000.
How to calculate in Excel or Google Sheets: put dates in column A and amounts in column B (investments negative, current value positive), then use =XIRR(B1:B3, A1:A3).
Why Is XIRR Important?
- Accurate SIP evaluation: It is the correct way to measure returns when you invest in instalments.
- Fair comparison: Because it is annualised, you can compare your SIP's XIRR with an FD rate or the scheme's benchmark return.
- Captures your actual experience: Two investors in the same fund can have different XIRRs because they invested at different times and amounts. XIRR reflects your timing.
- Handles withdrawals: It works even if you have redeemed part of your investment or receive IDCW payouts.
Key Features of XIRR
- Date-sensitive: each cash flow is weighted by the exact days invested.
- Annualised: results are expressed as a yearly percentage.
- Sign convention matters: outflows (investments) are negative; inflows (redemptions, current value) are positive.
- Iterative calculation: it is solved by trial, not by a closed formula.
- Works for any instrument: mutual funds, stocks, insurance-cum-investment plans, or a combination.
Benefits and Limitations
| Benefits | Limitations |
|---|---|
| Handles irregular amounts and dates | Can show extreme figures over very short periods (a few weeks or months) |
| Reflects your personal return, not just the fund's | Harder to calculate by hand; needs a spreadsheet or app |
| Comparable with other annual rates | Assumes interim cash flows could be reinvested at the same rate |
| Works for SIPs, STPs, SWPs and top-ups | Errors in dates or signs give wrong results |
Comparison With Related Concepts
| Concept | Meaning | Key difference | Practical implication for an investor |
|---|---|---|---|
| CAGR | Yearly growth rate between one start value and one end value | CAGR assumes a single investment; XIRR handles many | Use CAGR for lump sums and fund performance; XIRR for your SIP portfolio |
| Absolute Return | Total gain as a percentage of amount invested | Ignores time; XIRR adjusts for it | Absolute return understates SIP performance in early years |
| IRR | Return for evenly spaced cash flows | XIRR uses actual dates; IRR assumes equal intervals | XIRR is more accurate for real-world investing |
| Annualised Return | Any return expressed per year | XIRR is a specific, cash-flow-weighted annualised return | Check which method a report uses before comparing |
How Does XIRR Apply to Mutual Fund Investors?
- SIP portfolios: Your Consolidated Account Statement (CAS) shows transactions; apps and distributors use these dates and amounts to compute XIRR.
- Missed or paused SIPs: XIRR naturally adjusts for a missed SIP instalment or a SIP pause, because it only counts actual cash flows.
- Step-up SIPs and top-ups: Larger later instalments are invested for shorter periods. XIRR weights them correctly.
- SWP and partial redemption: Withdrawals are positive cash flows. XIRR includes them, so you get the return on your overall money.
- Comparing with the fund's CAGR: Your SIP XIRR can be higher or lower than the scheme's published CAGR because of when your instalments were invested. See SIP Return vs Lump Sum Return.
Common Mistakes and Misconceptions
- "My SIP return is just total gain divided by total invested." That is absolute return. It ignores that later instalments were invested for shorter periods, so it often understates performance in the early years.
- "XIRR should match the fund's CAGR." The fund's CAGR is for a single lump sum on a specific date. Your XIRR depends on your dates and amounts, so the two often differ.
- "A high XIRR after two months shows a great fund." Annualising short periods magnifies small gains or losses. Judge XIRR over longer periods.
- "Sign doesn't matter in the spreadsheet." If investments and current value have the same sign, XIRR cannot be calculated or gives an error.
- "XIRR tells me how risky my investment was." XIRR measures return only. Check volatility and risk-adjusted return separately.
Important Terms to Know
- CAGR: yearly compounded growth between two values.
- Absolute Return: total percentage gain without time adjustment.
- Systematic Investment Plan (SIP): investing a fixed amount at regular intervals.
- Rupee Cost Averaging: buying more units when prices are low and fewer when high through regular investing.
- Time Value of Money: money available today is worth more than the same amount later.
- Systematic Withdrawal Plan (SWP): withdrawing fixed amounts at regular intervals.
- Annualised Return: return expressed on a per-year basis.
Key Takeaways
- XIRR is an annualised return that accounts for multiple cash flows on different dates.
- It is the right measure for SIPs, top-ups, partial redemptions and SWPs.
- Investments are entered as negative values and current value or redemptions as positive.
- Your XIRR can differ from the fund's published CAGR because of your timing.
- Be cautious with XIRR over very short periods, where annualisation exaggerates results.
Related Glossary Terms
- CAGR (Compound Annual Growth Rate)
- Absolute Return
- Annualised Return
- Systematic Investment Plan (SIP)
- SIP Return vs Lump Sum Return
- Consolidated Account Statement (CAS)
- Time Value of Money
References
- AMFI, Mutual Funds Sahi Hai: What is CAGR or Annualised Return
- AMFI, Mutual Funds Sahi Hai: Mutual Fund Calculators
Educational Disclaimer
This content is published by FynnChintan Finserv for educational and informational purposes only. It is not personalised investment, tax or legal advice, and it is not a recommendation to buy or sell any scheme or security. All figures in the examples are illustrative and do not represent actual or expected returns. Mutual fund investments are subject to market risks; read all scheme-related documents carefully. Investment decisions should consider your financial goals, risk profile, investment horizon and the applicable scheme documents. FynnChintan Finserv is an AMFI-registered mutual fund distributor.
Curious how your own SIPs are doing? Learn more about SIPs and Rupee Cost Averaging in the FynnChintan Financial Glossary.
Frequently Asked Questions
Is XIRR affected by the order of entries in Excel?
The order of rows does not matter as long as each amount is paired with its correct date. However, Excel's XIRR function expects the first cash flow to be the starting point, so listing the earliest transaction first is good practice.
What is a good XIRR for a SIP?
There is no fixed benchmark number. Compare your SIP's XIRR with the return of the scheme's benchmark index over the same cash-flow dates, with category peers, and with inflation. A positive XIRR above inflation over the long term is generally a basic expectation, but equity returns can be negative over shorter periods.
Why is my XIRR negative even though markets have been rising lately?
If many of your instalments were invested at higher NAVs before a fall, your current value may still be below what you invested. XIRR reflects the full history of your cash flows, not just recent market movement. Over time, as markets recover, XIRR may turn positive, though this is not guaranteed.
Can XIRR be calculated for a single investment?
Yes. With one investment and one current value, XIRR gives practically the same result as CAGR. Small differences can arise because XIRR uses exact days divided by 365.
Does XIRR include IDCW payouts?
It should, if those payouts are entered as positive cash flows on the dates received. Many portfolio tools include them automatically. If you calculate manually, remember to add each payout, or your XIRR will be understated.
Why does XIRR differ between two apps for the same portfolio?
Differences usually come from the valuation date (which NAV is used), whether pending transactions are included, how IDCW and switches are treated, and rounding. Check that both use the same transactions and the same "as on" date.
This explanation is for general education only and is not investment advice. Mutual fund investments are subject to market risks; read all scheme-related documents carefully.