Overview
Most investors check their mutual fund app and see a percentage labeled "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 metric that answers a more specific question: what annualized return did you earn on your specific investments?
This matters most for SIP investors, where every month's purchase happens at a different NAV and on a slightly different date. Without XIRR, you can't 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 installments, 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 installments, lump sums, top-ups) counts as negative values (cash leaving your pocket)
- Money you receive (redemptions, dividends, or the final current value) counts as 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 annualized 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 annualized 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
The absolute gain is only 10.4% (12,450 ÷ 1,20,000), yet the annualized XIRR runs much higher because most of the investment went in recently. Early months' money has been deployed longest, while later months' contributions had less time to grow.
Step 4: Interpret your XIRR
XIRR tells you the equivalent annual return you earned. To read it:
- XIRR above the FD rate (currently ~7%) means your equity investment has outperformed the risk-free rate
- XIRR above the PPF rate (7.1%) means you've beaten the guaranteed government-backed rate
- XIRR below inflation (estimated 5-6%) means your purchasing power declined in real terms despite nominal gains
Compare your XIRR against the fund's published returns to see whether your entry timing helped or hurt. A fund returning 15% CAGR over 5 years while your XIRR sits at only 10% usually means you 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: had you invested the same total amount as a lump sum on day one at the Nifty 50's average CAGR, would that have beaten or trailed your SIP XIRR? This comparison shows whether your SIP timing actually paid off.
Common Mistakes to Avoid
Using absolute return instead of XIRR for SIPs. Absolute return (total gain ÷ total invested) ignores time and doesn't mean much for SIPs. A 20% absolute gain over 3 years works out to roughly 6.3% XIRR; the same 20% gain over 1 year is a 20% XIRR, an entirely different outcome.
Forgetting to include reinvested dividends. Choose the dividend reinvestment plan (IDCW Reinvestment) and each reinvested dividend counts as both a positive cash flow (dividend received) and a negative cash flow (reinvested). Many investors simply skip these, which understates their XIRR.
Using the wrong sign convention. All cash flows carrying the same sign throws an error. Investments need to be negative, with at least one positive value (the current value or a redemption) present.
Comparing XIRR to CAGR without understanding the difference. A fund's 5-year CAGR gets measured from a single start date. Your XIRR gets measured from the weighted average of your many investment dates. Both are valid, but they 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 (annualized 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.