What is XIRR in Mutual Fund? Meaning, Full Form, Formula & How to Calculate It
By Investopedia India Editorial Team | Updated: March 2026 | 10 min read
If you have been investing in mutual funds through a SIP, you have probably opened your portfolio statement at some point and wondered: “My total investment was ₹1,80,000 and the current value is ₹2,20,000 — but what is my actual annual return?” The simple math tells you a 22% absolute gain, but that number hides a lot. It does not tell you how long each rupee was invested or account for the fact that your first SIP instalment worked for three years while your last one worked for only a month.
This is exactly the problem that XIRR solves. It is the single most important return metric for any SIP investor, yet most people either do not know it exists or do not fully understand what it means. By the end of this guide, you will know what XIRR is, how it works, how to calculate it in Excel, and most importantly, how to use it to make smarter investment decisions.
What is XIRR in Mutual Fund?
XIRR stands for Extended Internal Rate of Return. In simple terms, it is the annualised rate of return on an investment where cash flows — both investments and withdrawals — happen at irregular intervals and different points in time.
XIRR Definition (4): XIRR, or Extended Internal Rate of Return, is a single annualised return figure that accounts for every individual cash inflow (investment) and outflow (redemption) along with their exact dates. It tells you the true rate at which your money grew, factoring in when each rupee was deployed. It is essentially your personal, date-aware rate of return.
Think of it this way. When you invest ₹5,000 every month through a SIP, the first instalment stays invested for, say, 36 months, while the 36th instalment stays invested for just one month. Each of those instalments earns a different return purely because of timing. XIRR is the single number that combines all these individual returns into one clean, annualised figure — so you can compare it to an FD rate, a PPF rate, or any other benchmark.
Why CAGR Is Not Enough for SIP Investors
Before getting deeper into XIRR, it helps to understand why the popular metric CAGR falls short for SIP investors. CAGR (Compounded Annual Growth Rate) works beautifully when you make a single lump-sum investment and measure its growth to a single end point. For example: ₹1,00,000 invested in January 2021 grew to ₹1,61,000 by January 2024 — that is a CAGR of approximately 17.2%.
But when you invest ₹5,000 every month for three years, you do not have a single entry point. You have 36 different entry points. CAGR cannot handle that. Applying CAGR to a SIP portfolio would either ignore 35 of your 36 investments or give you a misleadingly average number that does not reflect your actual experience.
How XIRR works (40–60 words): XIRR works by finding the single discount rate that makes the net present value (NPV) of all your cash flows equal to zero. It assigns an exact date to every transaction — whether a SIP instalment, a lump sum addition, a partial redemption, or a final withdrawal — and calculates the annualised return considering the precise time each amount was invested.
Under the hood, XIRR uses iterative computation. It tries different rate values until it finds the one where the present value of all outflows (your investments) exactly equals the present value of all inflows (your redemptions or current portfolio value). This is why you need a computer or Excel to calculate it — the manual calculation would take hours.
The XIRR Formula
The mathematical expression for XIRR satisfies:
0 = Σ [ Cᵢ ÷ (1 + XIRR)^((dᵢ − d₀)/365) ]
Where:
Cᵢ = Cash flow at time i (negative for investments, positive for redemptions)
dᵢ = Date of cash flow i
d₀ = Date of the first cash flow
XIRR = The annualised rate being solved for
You do not need to memorise this formula. What matters is understanding that XIRR is date-sensitive — it counts the exact number of days each rupee was at work, not just the number of years.
How to Calculate XIRR in Excel — Step by Step
Excel and Google Sheets both have a built-in XIRR() function that makes this calculation straightforward. Here is how to do it with a real example.
Example: A 12-Month SIP of ₹10,000
Assume you started a monthly SIP of ₹10,000 from January 2024 to December 2024 (12 instalments = ₹1,20,000 invested). On 1 January 2025, your portfolio value stands at ₹1,38,000.
| Column A: Cash Flow (₹) | Column B: Date | Nature |
|---|---|---|
| -10,000 | 01-Jan-2024 | SIP Outflow |
| -10,000 | 01-Feb-2024 | SIP Outflow |
| -10,000 | 01-Mar-2024 | SIP Outflow |
| … (monthly SIP continues) … | ||
| -10,000 | 01-Dec-2024 | SIP Outflow |
| +1,38,000 | 01-Jan-2025 | Current Portfolio Value (Inflow) |
In a cell below this data, type: =XIRR(A1:A13, B1:B13)
Excel will return approximately 15.7% annualised. That is your XIRR — your true personal return for this SIP, accounting for each instalment’s individual time in the market.
XIRR vs CAGR vs Absolute Returns — A Simple Comparison
Understanding when to use which metric saves a lot of confusion. Here is a clean breakdown:
| Metric | Best Used For | Accounts for Timing? | Accounts for Multiple Cash Flows? |
|---|---|---|---|
| Absolute Return | Investments under 1 year | No | No |
| CAGR | Lump-sum investments, fund-level performance | Partially | No |
| XIRR | SIPs, SWPs, irregular investments | Yes — exact dates | Yes |
A practical example makes this clearer. Suppose you invested ₹1,20,000 through monthly SIPs and your portfolio is worth ₹1,35,000 after two years. Absolute return says 12.5%. CAGR (applied roughly) might say 6.1%. But XIRR correctly accounts for the fact that your last few instalments were only invested for 1–2 months and adjusts your return accordingly — it might show 7.86%, which is the honest number. For more detail, read our full comparison of CAGR vs XIRR for mutual fund investors.
Benefits of XIRR for Mutual Fund Investors
Benefits of XIRR (40–60 words): XIRR gives you a single, honest annualised return figure for all your SIP investments combined. It accounts for every top-up, withdrawal, and pause in your investing journey. This helps you compare your mutual fund performance accurately against other instruments like FDs or PPF and assess whether you are on track for your financial goals.
Here are the key reasons why XIRR matters more than any other return metric for a retail investor:
1. It is your personal return, not the fund’s return. The fund’s CAGR tells you how ₹1 invested at the start grew. Your XIRR tells you how your actual money — invested in instalments at different times — actually grew. These two numbers can be very different.
2. It handles complexity effortlessly. If you started a SIP, then added a lump sum mid-way, then paused for a couple of months, then redeemed a portion — XIRR handles all of this in a single calculation. No other commonly available metric does this cleanly.
3. It enables fair comparison. Once you know your XIRR, you can compare it directly against an FD interest rate, a PPF return, or a different mutual fund’s XIRR. All these are annualised numbers, so the comparison is apples-to-apples.
4. It keeps you goal-focused. If you know you need a 12% annualised return to meet your child’s education goal in 10 years and your current XIRR is 9%, you can course-correct now — not after a decade.
Risks and Limitations of Relying Only on XIRR
Risks of XIRR (40–60 words): XIRR can be misleading over very short investment periods or during strong bull markets, when timing luck inflates the number. It also does not distinguish between skill and fortune. A high XIRR achieved over 12 months during a bull run does not predict future returns and should not be extrapolated without considering the broader market context.
Short-period distortion: If you started a SIP in October 2023 and the market rose sharply through early 2024, your XIRR might show 35–40%. That is not a sustainable return — it reflects a fortunate entry point, not the long-term capability of the fund.
Input error risk: XIRR is only as accurate as the data you feed it. Entering a wrong date, forgetting a transaction, or mixing up the signs (positive vs negative) will produce an incorrect result. Always cross-check your transaction history from your AMC or CAMS/KFintech statement.
It does not tell you the risk taken: A small-cap fund and a debt fund might both show a 10% XIRR — but one took far more volatility risk to get there. XIRR needs to be read alongside the fund’s risk profile and standard deviation.
Dividend reinvestment grey area: If you are in a dividend re-investment plan, those reinvestments do not involve an actual cash outflow from your bank. Whether to include them in your XIRR calculation depends on whether you are measuring scheme-level or portfolio-level returns. This often causes confusion.
What is a Good XIRR for a Mutual Fund?
There is no single “good” XIRR number because it depends on the fund category, the time period, and market conditions. That said, here is a general reference frame for Indian investors in 2025:
| Fund Category | Expected XIRR Range (Long-term) |
|---|---|
| Liquid / Overnight Funds | 6–7% |
| Short / Medium Duration Debt Funds | 7–8% |
| Hybrid / Balanced Advantage Funds | 9–11% |
| Large Cap Equity Funds | 11–13% |
| Mid Cap / Flexi Cap Funds | 13–16% |
| Small Cap Funds | 14–18% (with high volatility) |
An XIRR that comfortably beats inflation (currently ~5–6% in India) and the risk-free rate (current 10-year G-sec yield ~7%) over a 5+ year period is generally considered healthy. If your equity fund SIP is showing an XIRR below 8% over 7–10 years, it is worth reviewing whether the fund is underperforming its benchmark. For a deeper look at how to evaluate fund performance, read our guide on how to select the best mutual fund for SIP.
Who Should Track XIRR?
Who should use XIRR (40–60 words): XIRR is relevant for any investor with multiple transactions in their mutual fund portfolio. SIP investors, those who have made lump sum additions at different times, investors with partial redemptions, and anyone using a Systematic Withdrawal Plan (SWP) should all track XIRR as their primary return metric rather than relying on the fund’s advertised CAGR.
If you made a single lump sum investment five years ago and never touched it, CAGR is perfectly adequate for you. But if you have any of the following, XIRR is the right tool:
1. Monthly or quarterly SIP investors
2. Investors who have made additional lump sum purchases on top of an ongoing SIP
3. Anyone who has paused and restarted a SIP
4. Investors using an SWP (Systematic Withdrawal Plan) for monthly income
5. Anyone who has partially redeemed their mutual fund units
6. Goal-based investors who want to know if they are on track
XIRR for SIP with a Partial Redemption — A Real-World Example
Let us take a slightly more complex scenario that most investors eventually face. Priya started a ₹5,000/month SIP in a flexi-cap fund in December 2022. In August 2023, she needed funds and redeemed ₹25,000. She then made a lump sum investment of ₹10,000 in September 2023 and continued her SIP. By January 2025, her portfolio is worth ₹60,000.
In Excel, her data would look like this: all SIP payments as negative entries on their respective dates, the August 2023 redemption of ₹25,000 as a positive entry, the September 2023 lump sum as a negative entry, and the ₹60,000 current value as a positive entry on the current date. Running the XIRR formula on this gives her the true annualised return on her actual investing journey — not some textbook scenario.
This is the power of XIRR: it handles the messy, real-world nature of investing without complaint.
When Not to Trust Your XIRR — And When to Speak to an Expert
XIRR is a powerful tool, but it is not infallible. There are situations where the number on your screen can mislead you into a false sense of security — or unnecessary panic. Knowing when to look beyond a formula and speak to a qualified financial expert can protect both your wealth and your peace of mind.
Do Not Over-Rely on XIRR When:
Your investment horizon is very short. An XIRR calculated on 6–12 months of data is highly susceptible to market timing. A strong bull run can make a mediocre fund look exceptional. Do not use short-term XIRR to make long-term fund selection decisions.
You are comparing across very different asset classes. A 14% XIRR from a small-cap fund and a 10% XIRR from a multi-asset fund are not directly comparable without factoring in volatility, drawdown risk, and your personal ability to stay invested through market crashes.
Your data inputs are uncertain. If you have invested across multiple platforms — Zerodha, Groww, Paytm Money, your bank’s platform — and you are not 100% sure you have captured every transaction with accurate dates, your XIRR calculation is unreliable. Always pull a consolidated account statement from CAMS or KFintech, which aggregates all your mutual fund transactions in one place.
Speak to a Financial Advisor If:
Your XIRR is consistently below inflation over a 5+ year period and you do not know why. You are approaching a major life goal (retirement, child’s education, home purchase) and want to know if your current XIRR trajectory is sufficient. You are managing a large corpus (above ₹25–30 lakh) and have complex transactions involving switches, dividend options, and SWPs across multiple fund houses. In these cases, a certified financial planner (CFP) can analyse your complete portfolio with context — something no formula can do on its own.
Key Takeaways
1. XIRR stands for Extended Internal Rate of Return and is the most accurate way to measure your personal return on a mutual fund SIP.
2. Unlike CAGR, XIRR accounts for the exact dates and amounts of every transaction — investments, top-ups, and redemptions.
3. In Excel or Google Sheets, use =XIRR(values, dates) with outflows as negative values and inflows (including current value) as positive.
4. A good XIRR depends on the fund category and your investment horizon — compare it to the relevant benchmark and inflation, not to a random number.
5. Do not read XIRR in isolation. Short-term XIRR can be distorted by market timing; always evaluate it over a meaningful period of 3 years or more.
6. For complex portfolios or goal-critical decisions, consult a SEBI-registered financial advisor rather than relying solely on calculated metrics.
For further reading, Mirae Asset Mutual Fund has a detailed knowledge centre article on XIRR in mutual funds, and Investopedia (global) has a comprehensive explanation of the Extended Internal Rate of Return concept for those wanting a deeper mathematical understanding.
Also see our related articles: What is SIP and how does it work for wealth creation?
Frequently Asked Questions (FAQs)
1. What is the full form of XIRR in mutual fund?
XIRR full form is Extended Internal Rate of Return. It is a financial metric used to calculate the annualised return on investments that have multiple cash flows occurring at different and irregular points in time.
2. Is XIRR the same as annual return?
Yes, XIRR is expressed as an annualised return. However, it differs from simple annual return because it accounts for the exact timing of each cash flow, not just the start and end value of your investment.
3. How is XIRR different from CAGR?
CAGR is used for single lump-sum investments and measures a fund’s point-to-point growth. XIRR is used for multiple cash flows at different dates, such as monthly SIPs. XIRR gives your personal, investor-specific return while CAGR gives the fund’s overall performance.
4. What is a good XIRR in mutual funds for India?
A good XIRR depends on the fund category. For equity mutual funds, an XIRR of 11–15% over 5–10 years is considered good. For hybrid funds, 9–11% is healthy. The key benchmark is whether your XIRR consistently beats inflation and the relevant index over the long term.
5. Can XIRR be negative?
Yes, XIRR can be negative. This happens when your total redemption value is less than your total invested amount — meaning you made a loss on your investment on an annualised basis. This can occur during prolonged market downturns or if you redeemed at an unfavourable time.
6. Do I need to calculate XIRR manually?
No. You can use the built-in =XIRR(values, dates) function in Microsoft Excel or Google Sheets. Several mutual fund platforms and portfolio trackers also calculate XIRR automatically from your transaction history.
7. What happens to XIRR if I skip a SIP instalment?
Skipping an instalment simply means there is no entry for that date. Since XIRR works on actual transaction dates, it handles this naturally. There is no penalty in the calculation — the formula only processes the transactions that actually happened.
Conclusion
XIRR is not just a spreadsheet function — it is the financial mirror that shows you the honest picture of your wealth creation journey. Every rupee you invest has a date stamp, and XIRR respects that fact in a way that simpler metrics never can. Whether you are a first-time SIP investor checking your portfolio for the first time or a seasoned investor managing multiple funds, making XIRR a regular part of your portfolio review will give you a cleaner, more honest read on how your money is actually growing.
Set it up once in Excel, update it every six months, and you will always know exactly where you stand — not where the market’s best-case advertisement wants you to think you stand.
Disclaimer: This article is for educational purposes only and does not constitute financial advice. Mutual fund investments are subject to market risks. Please read all scheme-related documents carefully before investing. For personalised advice, consult a SEBI-registered investment advisor.
