"My investment is up 60%!" sounds impressive — but if that was a SIP over 6 years, it might be an annualised return of only about 12%. Most investors measure their returns wrong, and the error usually flatters them.
For any portfolio with money going in and out on different dates — which is every SIP — there is one correct metric: XIRR.
This article explains what XIRR is, how it differs from CAGR and absolute return, why it is right for SIPs, and how to calculate it.
What XIRR Is
XIRR (Extended Internal Rate of Return) is the annualised return of an investment that accounts for multiple cash flows happening on different dates.
It is the single percentage rate that — applied to every investment and withdrawal on its actual date — makes everything balance. Because it weights each cash flow by how long it was truly invested, it gives the genuine annualised return of a messy, real-world portfolio. This is exactly why fund platforms report your return as XIRR.
XIRR vs CAGR vs Absolute Return
Metric
Handles time?
Best for
Absolute return
No
Single lump sum, ignore when
CAGR
One entry, one exit
A single lump-sum investment
XIRR
Many cash flows, any dates
SIPs, irregular contributions
Absolute return = total gain ÷ amount invested. Ignores time entirely.
CAGR annualises a single lump sum's return — one entry, one exit.
XIRR generalises CAGR to many cash flows on different dates.
For a one-time investment, XIRR and CAGR give the same answer. For a SIP, only XIRR is correct.
Why XIRR Is Right for a SIP
In a SIP, each instalment is invested for a different length of time — your first may have been invested 5 years, your latest one month. A simple average or absolute figure ignores this and misleads you.
Why 60% can be 12%:
A SIP showing a 60% absolute gain might have an XIRR of around 12%. The absolute number looks bigger only because it ignores that most of your money was invested for just part of the period. XIRR strips away that illusion and tells you the real annualised rate.
How to Calculate XIRR
You never need to do the maths by hand — it is an iterative calculation that tools solve instantly.
In a spreadsheet
List every cash flow with its date
Enter investments as negative numbers, redemptions and the final current value as positive
Use =XIRR(values, dates) in Excel or Google Sheets
Or use a tool
An online XIRR calculator or your fund platform's built-in XIRR display does it automatically. Just include every contribution, withdrawal, and the latest valuation with correct dates.
Interpreting Your XIRR
Judge against a benchmark for the same period and asset class — not a fixed target
Long-term Indian equity has historically delivered annualised returns broadly in the low-to-mid teens over long periods — with large swings and no guarantee
A debt fund's normal XIRR is much lower; a short lucky period can show very high or negative XIRR
If your XIRR lags the fund's headline return:
That gap is usually the behaviour gap — the fund's advertised number assumes a lump sum held for the full period, while your XIRR reflects when you actually invested. Investing more after rises and less after falls drags your personal XIRR below the fund's. It is a useful, honest reality check on your own behaviour.
Calculate Your Portfolio XIRR
Enter your dated cash flows and current value to get your true annualised return in seconds.
XIRR (Extended Internal Rate of Return) is the annualised return of an investment that accounts for multiple cash flows happening on different dates. It is the single percentage rate that, applied to every investment and withdrawal on its actual date, makes their present value match. For a SIP — where you invest different amounts on many dates — XIRR is the correct way to express your annualised return, because it weights each instalment by how long it was actually invested. Most fund platforms and portfolio trackers report your returns as XIRR for exactly this reason.
Absolute return is simply total gain divided by amount invested, ignoring time — useful only for a single lump sum over a known period. CAGR (Compound Annual Growth Rate) annualises the return of a single lump-sum investment over time, assuming one entry and one exit. XIRR generalises CAGR to handle many cash flows on different dates — multiple SIP instalments, lump sums, and withdrawals. For a one-time investment, XIRR and CAGR give the same answer; for a SIP or any portfolio with irregular contributions, XIRR is the only one that is correct.
Because in a SIP each instalment is invested for a different length of time — your first instalment may have been invested for 5 years, your most recent for one month. A simple average or absolute return ignores this and overstates or understates your true return. XIRR correctly weights each instalment by its actual investment duration, giving the genuine annualised rate your money earned. This is why a SIP showing, say, a 60% absolute gain might have an XIRR of around 12% — the absolute figure looks bigger because it ignores that most of the money was invested for only part of the period.
The easiest way is a spreadsheet. In Excel or Google Sheets, list every cash flow with its date — investments as negative numbers, redemptions and the final current value as positive — then use the formula =XIRR(values, dates). The function solves for the annualised rate that balances all the cash flows. Alternatively, use an online XIRR calculator or your fund platform's built-in XIRR display. You do not need to do the maths by hand; the calculation is iterative and tools handle it instantly. Just make sure every contribution, withdrawal, and the latest valuation is included with the correct date.
There is no universal 'good' number, because it depends on the asset class, period, and risk taken. As a rough reference, long-term Indian equity (via index funds or diversified equity funds) has historically delivered annualised returns broadly in the low-to-mid teens over long periods, though with large swings and no guarantee. For a debt fund a much lower XIRR is normal; for a short, lucky period equity XIRR can be very high or negative. The right way to judge your XIRR is against an appropriate benchmark for the same period and asset class — not against a fixed target.
Usually because of timing — yours and the fund's. A fund's advertised return is typically a point-to-point or trailing CAGR assuming a lump sum held for the full period. Your XIRR reflects when you actually invested. If you invested more after prices had risen and less when they were low (common behaviour), or started recently, your personal XIRR will lag the fund's headline number. This gap between the fund's return and the investor's actual return is the behaviour gap. It is a useful reality check: it measures the return your behaviour earned, not just the fund's.
📖 New to finance terms? Our glossary covers 150+ Indian finance terms — plain English, no jargon.
