What is XIRR in Mutual Funds? Complete Explanation with Calculations
XIRR is the most accurate way to measure your mutual fund SIP returns. Learn how it works, how to calculate it, and why CAGR alone is not enough.
What is XIRR in Mutual Funds? Simple Guide with Real Calculations
Open any mutual fund app. You will see a number next to your portfolio — something like \"XIRR: 14.3%\".
Most people ignore it. Or worse, they confuse it with simple profit percentage.
That one number actually tells you more about your investment than anything else on that screen. This guide will make it completely clear — in plain language, with real examples and actual calculations.
Why Your Simple Profit % is Misleading
Let's start with a story.
Riya invested ₹5,000 every month in a mutual fund for 6 months. She put in ₹30,000 total. Today her portfolio is worth ₹32,500.
She tells her friend: \"I made ₹2,500 profit. That's about 8.3% return.\"
Sounds reasonable. But here's the problem — that 8.3% means nothing without time.
- Did she earn that in 1 month? That would be incredible.
- Did she earn that over 10 years? That would be terrible.
- She earned it in 6 months — so what is the actual yearly rate?
Simple profit percentage has no answer for this. That is exactly why XIRR exists.
What About CAGR? Why is That Not Enough?
You may have heard of CAGR — Compound Annual Growth Rate. It does fix the time problem, but only for one specific situation: a single lump sum investment.
CAGR Formula
CAGR = [ (Final Value ÷ Initial Investment) ^ (1 ÷ Years) ] − 1
CAGR Example
You invest ₹1,00,000 once. After 4 years, it becomes ₹1,60,000.
CAGR = (1,60,000 ÷ 1,00,000) ^ (1 ÷ 4) − 1 = 1.6 ^ 0.25 − 1 = 12.47% per year
Perfect. Clean. Works great.
But SIP is a Different Problem
In a SIP, you do not invest once. You invest every month — on different dates, for different durations.
- Your January ₹5,000 has been growing for 6 months.
- Your February ₹5,000 has been growing for 5 months.
- Your June ₹5,000 has been growing for just 1 month.
There is no single \"start date\" to plug into CAGR. It simply cannot handle this. XIRR can.
So What Exactly is XIRR?
XIRR = Extended Internal Rate of Return.
In simple words: XIRR is the one yearly interest rate that would explain all your investments turning into your final amount — considering the exact date of every single investment.
Think of it like this: Imagine a bank FD that matched your exact investment behaviour — same amounts, same dates. What interest rate would that FD need to give you the same result? That rate is your XIRR.
XIRR is Used Everywhere
- Groww, Zerodha Coin, Kuvera, Paytm Money — all show XIRR
- SEBI-registered advisors use XIRR for client reporting
- MF Central and CAMS use XIRR in consolidated statements
- Value Research and Morningstar use XIRR for portfolio tracking
What Makes XIRR Special
- Works with any number of transactions — 3 payments or 300, it handles all
- Works with irregular dates — SIP on 1st, 5th, or 15th of month, no problem
- Works with withdrawals too — partial redemptions are included automatically
- Always gives a yearly rate — so you can compare directly with FD, PPF, or NPS
- Gives more weight to early money — because it had more time to grow
The Golden Rule of XIRR — Signs Matter
Before calculations, you must understand one rule. It never changes:
| Type of Transaction | Sign to Use | Why |
|---|---|---|
| Money you invest (SIP, lump sum) | Negative (−) | Money is going OUT of your pocket |
| Money you withdraw | Positive (+) | Money is coming IN to your pocket |
| Current portfolio value (if not sold) | Positive (+) | Treated as if you redeemed today |
Mix up these signs and your XIRR will be completely wrong. This is the most common mistake beginners make.
XIRR Calculation — Step by Step (Riya's Example)
Let's go back to Riya. She did a ₹5,000/month SIP for 6 months. Her portfolio is now worth ₹32,500. Let's calculate her XIRR.
Step 1 — Write Down Every Transaction with Date and Sign
| Row | Date (Column A) | Cash Flow in ₹ (Column B) | What It Is |
|---|---|---|---|
| 1 | 01/01/2025 | -5000 | SIP Month 1 |
| 2 | 01/02/2025 | -5000 | SIP Month 2 |
| 3 | 01/03/2025 | -5000 | SIP Month 3 |
| 4 | 01/04/2025 | -5000 | SIP Month 4 |
| 5 | 01/05/2025 | -5000 | SIP Month 5 |
| 6 | 01/06/2025 | -5000 | SIP Month 6 |
| 7 | 01/07/2025 | +32500 | Portfolio value today |
Total invested: ₹30,000 | Portfolio value: ₹32,500 | Gain: ₹2,500
Step 2 — See Why Each Instalment is Different
This is the key insight. Every ₹5,000 had a different amount of time to grow:
| Instalment | Invested On | Days in Market (up to Jul 1) | Time to Grow |
|---|---|---|---|
| 1st ₹5,000 | 01 Jan 2025 | 181 days | Most time — highest impact |
| 2nd ₹5,000 | 01 Feb 2025 | 150 days | |
| 3rd ₹5,000 | 01 Mar 2025 | 122 days | |
| 4th ₹5,000 | 01 Apr 2025 | 91 days | |
| 5th ₹5,000 | 01 May 2025 | 61 days | |
| 6th ₹5,000 | 01 Jun 2025 | 30 days | Least time — lowest impact |
CAGR cannot handle 6 different start dates. XIRR handles all of them at once.
Step 3 — Type One Formula in Excel or Google Sheets
With your data in the table above (dates in Column A, amounts in Column B), click any empty cell and type:
=XIRR(B1:B7, A1:A7)
Hit Enter. Format as percentage. You get: ≈ 17.2% per annum.
That is Riya's real annual return — not 8.3%, not a rough guess. 17.2% per year, annualised, accounting for every date.
Bigger Example — 3-Year SIP Plus a Lump Sum Top-Up
Meet Rahul. He did a ₹10,000/month SIP for 3 years. In January 2023 (Month 13), he also added a ₹50,000 lump sum top-up. Let's see what his XIRR looks like.
| Date | Transaction | Cash Flow (₹) |
|---|---|---|
| 01 Jan 2022 | SIP Month 1 | −10,000 |
| 01 Feb 2022 to 01 Dec 2022 | SIP Month 2 to 12 (₹10,000 each) | −10,000 each |
| 01 Jan 2023 | SIP Month 13 + Lump Sum Top-Up | −60,000 |
| 01 Feb 2023 to 01 Dec 2024 | SIP Month 14 to 35 (₹10,000 each) | −10,000 each |
| 01 Jan 2025 | SIP Month 36 (last) | −10,000 |
| 01 Jan 2025 | Current portfolio value | +5,20,000 |
- Total invested: 35 × ₹10,000 + ₹50,000 = ₹4,00,000
- Portfolio value: ₹5,20,000
- Absolute gain: ₹1,20,000
- XIRR result: approximately 14.8% per annum
One clean number that accounts for all 36 instalments, the lump sum on a different date, and the exact final value. That is the power of XIRR.
XIRR with a Partial Withdrawal — Still Works Perfectly
What if you withdrew some money in between? No problem. Just enter the withdrawal as a positive number on the date it happened.
| Date | Transaction | Cash Flow (₹) |
|---|---|---|
| 01 Jan 2023 | Lump sum investment | −2,00,000 |
| 01 Jan 2024 | Partial withdrawal (you took money out) | +50,000 |
| 01 Jul 2025 | Remaining portfolio value today | +1,90,000 |
- Total invested: ₹2,00,000
- Total received: ₹50,000 + ₹1,90,000 = ₹2,40,000
- XIRR result: approximately 10.3% per annum
No manual adjustments. No complicated formula changes. Just add the withdrawal row and XIRR handles the rest.
XIRR vs CAGR — The Complete Comparison
Here is when to use which one:
| Question | CAGR | XIRR |
|---|---|---|
| Best for which type of investment? | Single lump sum only | SIP, lump sum, or any mix |
| How many cash flows does it handle? | Exactly 2 (one in, one out) | Any number — 2 or 2,000 |
| Does it care about investment dates? | No | Yes — every date matters |
| Can it handle partial withdrawals? | No | Yes |
| Result is annualised? | Yes | Yes |
| Can you calculate it manually? | Yes, easy | Needs Excel or Sheets |
| What do mutual fund apps show? | Fund's historical return | Your personal return |
Remember: CAGR tells you how the fund did. XIRR tells you how you did. They are different — and your XIRR is the one that actually matters for your financial life.
5 Mistakes People Make with XIRR
Mistake 1 — Forgetting to Add Today's Portfolio Value
XIRR needs a final positive cash flow — the current value of your portfolio. Without it, the formula does not know when your investment story ends. Always add today's portfolio value as a positive number on today's date.
Mistake 2 — Getting the Signs Wrong
Investments must be negative. Withdrawals and current value must be positive. This is non-negotiable. One wrong sign and your result is garbage.
Mistake 3 — Comparing Your XIRR to the Fund's CAGR
A fund's 5-year CAGR of 18% assumes someone invested one lump sum 5 years ago. You did a SIP. You entered at different NAV levels each month. Your XIRR will be different — it could be higher or lower depending on the market timing of your instalments.
Mistake 4 — Saying \"My Return is X%\" Using Simple Profit
₹2,500 gain on ₹30,000 invested looks like 8.3%. But your actual annualised return (XIRR) could be 17%. Using simple percentage undersells your actual performance — or in bad markets, it hides how bad things really are.
Mistake 5 — Using XIRR for Very Short Periods
If you have only invested for 1–2 months, XIRR will give a very high or very low number that means nothing. Use XIRR seriously only when you have at least 6 months of data. Shorter periods give extreme numbers that are not useful for decision-making.
What is a Good XIRR? Fund Category Reference
There is no single \"good\" XIRR number. It depends on what type of fund you are in. Here is a general reference for Indian mutual funds:
| Fund Type | Typical Long-Term XIRR | Compare It With |
|---|---|---|
| Liquid / Overnight Fund | 5% – 7% | Savings account (~3.5%) |
| Short Duration Debt Fund | 6% – 9% | Bank FD (6.5% – 7.5%) |
| Hybrid / Balanced Fund | 9% – 13% | PPF (7.1%) |
| Large Cap Equity Fund | 11% – 15% | Nifty 50 historical ~12% |
| Mid Cap Equity Fund | 13% – 18% | Higher risk, higher reward |
| Small Cap Equity Fund | 14% – 22% | Highest risk and potential |
| ELSS (Tax Saving Fund) | 11% – 16% | 3-year lock-in + 80C benefit |
Important note: These numbers are based on historical data. Past returns do not guarantee future returns. Equity XIRR is especially sensitive to which months you happened to invest in.
How to Find Your XIRR Right Now
You do not need to calculate XIRR yourself. Every major Indian mutual fund platform already shows it:
- Groww — Go to Portfolio → tap any fund → scroll to Returns section → XIRR is shown
- Zerodha Coin — Go to Portfolio → select a fund → look for \"XIRR\" under returns
- Kuvera — Dashboard shows XIRR by default on the portfolio summary screen
- Paytm Money — Portfolio → tap a fund → XIRR shown in the returns breakdown
- MF Central (mfcentral.com) — Best for a consolidated view across all AMCs and registrars
- Value Research Online — Log in → My Portfolio → XIRR column shown for each fund
For a single consolidated XIRR across all your mutual funds from all AMCs, MF Central is the most reliable — it pulls data directly from CAMS and KFin.
XIRR Quick Reference Card
| Question | Answer |
|---|---|
| Full form of XIRR | Extended Internal Rate of Return |
| Is XIRR a yearly number? | Yes — always per annum |
| My investment amount — positive or negative? | Negative (it leaves your pocket) |
| My portfolio value today — positive or negative? | Positive (it can come back to you) |
| Excel / Google Sheets formula | =XIRR(values range, dates range) |
| Minimum data needed | At least one investment + one final value |
| XIRR = 0% | You got back exactly what you put in. Zero growth. |
| XIRR is negative | Your portfolio is worth less than what you invested |
| XIRR looks very high (50%+) | Probably a very short holding period — not meaningful yet |
Key Takeaways
- XIRR is the real annual return on your investment — accounting for every date and every amount.
- CAGR is for lump sum. XIRR is for SIP, or any mix of investments and withdrawals.
- Investments are negative. Withdrawals and current value are positive. Get the signs right.
- In Excel or Google Sheets:
=XIRR(values, dates)— that is all you need. - Your XIRR and the fund's CAGR are different numbers. Your XIRR is the one that reflects your actual experience.
- Every major mutual fund app in India already calculates XIRR for you — you just need to know where to look.
The next time your app shows \"XIRR: 14.3%\" — you will know exactly what that means, how it was calculated, and why it is the most honest number in your portfolio.
