What Is XIRR and Why Is It Important?
XIRR (Extended Internal Rate of Return) is the gold standard for measuring the annualised return on investments that involve irregular cashflows. While simple returns and CAGR work well for single lumpsum investments, most real-world investment portfolios involve multiple transactions at different dates: monthly SIPs, occasional lumpsum top-ups, partial withdrawals, dividend reinvestments, and final redemptions. XIRR captures all of this complexity and distils it into a single annualised percentage return.
Technically, XIRR is the discount rate that makes the Net Present Value (NPV) of all cashflows (both inflows and outflows) equal to zero. It is calculated using the Newton-Raphson iterative method, which converges on the precise rate through successive approximations. The formula accounts for the exact dates of each cashflow, not just the amounts, making it far more accurate than simple return calculations.
Why CAGR Is Not Enough
CAGR (Compound Annual Growth Rate) only works for a single investment made at a single point in time and measured at another single point. It assumes no intermediate cashflows. If you invest Rs 1 lakh and it becomes Rs 2 lakh in 5 years, CAGR correctly tells you the annualised return is 14.87%. But what if you invested Rs 1 lakh initially, added Rs 50,000 after 2 years, and withdrew Rs 30,000 after 4 years? CAGR cannot handle this. XIRR can.
For SIP investors, XIRR is especially critical. Each monthly SIP instalment has a different holding period, so the returns on the first instalment (which has been invested the longest) are very different from the last instalment. XIRR weights each cashflow by its time in the market and gives you the single annualised return that accounts for all of them.
How to Calculate XIRR
To calculate XIRR, you need two things for each transaction: the amount and the date. Investments (outflows) are entered as negative amounts, and redemptions or current portfolio value (inflows) are entered as positive amounts. The last entry should be the current value of your investment with today's date, representing the final inflow.
The calculator above uses the Newton-Raphson method, the same approach used by Excel's XIRR function, to find the rate r that satisfies the equation: Sum of [Cashflow_i / (1 + r)^((Date_i - Date_0) / 365)] = 0. This iterative process typically converges in 10-20 iterations to a precision of eight decimal places.
XIRR vs IRR: The Difference
IRR (Internal Rate of Return) assumes cashflows occur at regular intervals (monthly, quarterly, annually). XIRR extends this to handle cashflows at any irregular dates. For SIPs that are truly monthly with no gaps or extra investments, IRR and XIRR will give nearly identical results. But in practice, investors often miss SIP dates, make additional lumpsum investments, do partial withdrawals, or have varying SIP amounts. In all these cases, XIRR provides the correct answer while IRR does not.
Interpreting XIRR Results
A positive XIRR indicates your investment is generating returns. For context, equity mutual fund SIPs in India have historically delivered XIRR of 12-15% over 10+ year periods. Debt fund SIPs typically show 6-8% XIRR. A negative XIRR means your investment is losing money on an annualised basis. If you compare your portfolio XIRR with benchmark indices (Nifty 50, Sensex), you can assess whether your investment choices are adding alpha or underperforming the market.
Be cautious when interpreting XIRR for very short holding periods. A 3-month gain of 5% annualises to approximately 20% XIRR, which may overstate the likely long-term return. XIRR is most meaningful for holding periods of 1 year or more, where the annualisation reflects a realistic long-term trend.