Overview
Most investors check their mutual fund app and see a percentage labelled "returns" — but that number is often the fund's point-to-point CAGR, not your personal return. Your actual return depends on when you invested, how much, and whether you made partial withdrawals. XIRR (Extended Internal Rate of Return) is the only metric that answers the question: what annualised return did I earn on my specific investments?
This matters most for SIP investors, where every month's purchase is at a different NAV and on a slightly different date. Without XIRR, you cannot compare your mutual fund returns to an FD rate, a PPF rate, or any other fixed-return instrument on an apples-to-apples basis.
What You Need
- Transaction history — a list of all investment dates and amounts (your SIP instalments, lump sum top-ups, and any redemptions)
- Current portfolio value — today's market value of all units held; available from your CAS (Consolidated Account Statement) from CAMS or KFintech, or directly in your mutual fund app
- XIRR Calculator or Excel — use the XIRR Calculator for a quick calculation, or Excel's
=XIRR()function for full control
Steps
Step 1: Download your transaction history
Log into your mutual fund platform or MF Central and download the full transaction history for the fund or portfolio you want to evaluate. You need two columns: date and amount for every transaction.
For a CAS (Consolidated Account Statement), visit mycams.com or kfintech.com, request a detailed CAS for the period you want, and export it.
Step 2: Format cash flows as positive and negative
XIRR uses a sign convention that reflects your perspective as an investor:
- Money you invest (SIP instalments, lump sums, top-ups) = negative values (cash leaving your pocket)
- Money you receive (redemptions, dividends, or the final current value) = positive values (cash returning to you)
For a 12-month SIP of ₹10,000/month with no redemptions:
| Date | Amount |
|---|---|
| 2025-01-10 | -10,000 |
| 2025-02-10 | -10,000 |
| ... | ... |
| 2025-12-10 | -10,000 |
| 2026-01-10 (today) | +1,32,450 (current value) |
The current portfolio value on today's date acts as your "hypothetical redemption" — it anchors the calculation.
Step 3: Calculate XIRR
Using the XIRR Calculator: Enter each cash flow with its date. The calculator solves iteratively for the annualised rate r that satisfies:
Sum of [Cash Flow(t) ÷ (1 + r)^(days(t) ÷ 365)] = 0
Using Excel: Enter dates in column A and cash flows in column B (negative for investments, positive for redemption/current value). In an empty cell:
=XIRR(B1:B13, A1:A13)
Excel returns the annualised XIRR as a decimal. Multiply by 100 for the percentage.
For our example (₹10,000/month for 12 months, current value ₹1,32,450):
- Total invested: ₹1,20,000
- Gain: ₹12,450
- XIRR ≈ 19.8% per annum
Even though the absolute gain is only 10.4% (12,450 ÷ 1,20,000), the annualised XIRR is much higher because most of the investment was made recently — early months' money has been deployed longest but later months' contributions had less time to grow.
Step 4: Interpret your XIRR
XIRR tells you the equivalent annual return you earned. To interpret:
- XIRR > FD rate (currently ~7%): your equity investment has outperformed the risk-free rate
- XIRR > PPF rate (7.1%): you have beaten the guaranteed government-backed rate
- XIRR < Inflation (estimated 5–6%): your purchasing power has declined in real terms despite nominal gains
Compare your XIRR against the fund's published returns to understand whether your entry timing helped or hurt. If the fund returned 15% CAGR over 5 years but your XIRR is only 10%, you likely invested more when valuations were high.
Step 5: Use XIRR for portfolio-level analysis
Run XIRR across all your mutual funds combined to get a single blended return. Pool all transactions from all funds into one list, then add a single row for the total current portfolio value at today's date. This blended XIRR lets you judge your overall investment decisions rather than fund-by-fund performance.
Compare this to a Lumpsum Calculator scenario: if you had invested the same total amount as a lump sum on day one at the Nifty 50's average CAGR, would you have done better or worse than your SIP XIRR? This comparison reveals whether your SIP timing actually helped.
Common Mistakes to Avoid
Using absolute return instead of XIRR for SIPs. Absolute return (total gain ÷ total invested) ignores time and is meaningless for SIPs. A 20% absolute gain over 3 years is ~6.3% XIRR; the same 20% gain over 1 year is 20% XIRR — completely different outcomes.
Forgetting to include reinvested dividends. If you chose the dividend reinvestment plan (IDCW Reinvestment), each reinvested dividend is both a positive cash flow (dividend received) and a negative cash flow (reinvested). Many investors simply omit these, understating their XIRR.
Using the wrong sign convention. If all your cash flows are the same sign, XIRR throws an error. Investments must be negative, and at least one positive value (the current value or a redemption) must exist.
Comparing XIRR to CAGR without understanding the difference. A fund's 5-year CAGR is measured from a single start date. Your XIRR is measured from the weighted average of your many investment dates. Both are valid but measure different things.
Formula & Methodology
XIRR solves for the rate r in this equation using iterative numerical methods (Newton-Raphson):
NPV = Σ [ CF(t) / (1 + r)^(d(t) / 365) ] = 0
Where:
- CF(t) = cash flow at transaction t (negative for investments, positive for redemptions/current value)
- d(t) = number of days from the first transaction date to transaction t
- r = the XIRR (annualised rate) — the unknown being solved
The equation has no closed-form solution; calculators and Excel solve it by trying successive values of r until NPV approaches zero. The XIRR Calculator handles this instantly for up to hundreds of transactions.