XIRR Explained
What is it?
XIRR (Extended Internal Rate of Return) is the annualized return that accounts for the exact date and amount of every cash flow into and out of an investment — every SIP installment, lump sum, and withdrawal — rather than treating the investment as a single point-in-time transaction.
Why should you care?
Most investors add money over time through SIPs, not as one lump sum. A simple return calculation ignores when each rupee was invested, which can badly misrepresent performance. XIRR is the correct way to measure the true annualized return of a portfolio built through irregular contributions.
Real-life example
An investor SIPs ₹5,000/month into a fund for 3 years (₹1.8 lakh total invested) and the portfolio is worth ₹2.25 lakh today. A naive calculation might say '25% total return,' but since the money was invested gradually — not all 3 years ago — the true annualized return (XIRR) works out closer to 14-15% p.a., because later installments had less time to grow.
Common mistakes
- Using simple absolute return (%) on a SIP portfolio instead of XIRR, which overstates or understates the true annualized rate.
- Comparing XIRR figures from portfolios with very different cash flow patterns as if they're directly comparable.
- Not including withdrawals or switches as cash flows, which skews the XIRR calculation.
Simple return vs XIRR for a 3-year SIP (illustrative)
| Metric | What it captures | Approx. value |
|---|---|---|
| Absolute return | Total gain / total invested, ignoring timing | ≈25% |
| XIRR | Annualized return accounting for when each rupee was invested | ≈14-15% p.a. |
FAQ
Do I need to calculate XIRR myself?
No — most portfolio trackers and analytics platforms, including FundSageAI, calculate XIRR automatically once your transaction history is available.
Is a higher XIRR always better?
Generally yes for comparing similar-risk investments, but XIRR should be viewed alongside risk (see Standard Deviation Explained) — a higher XIRR earned with much higher volatility isn't a like-for-like comparison.
Can XIRR be negative?
Yes — if a portfolio's current value plus any withdrawals is less than what was invested, XIRR will be negative, reflecting an annualized loss.
What's the difference between XIRR and CAGR?
See CAGR vs XIRR — CAGR works for a single lump sum, while XIRR generalizes to any number of cash flows at any dates.
See this concept applied to your own portfolio
Get Started - It's FreeFundSageAI is an analytics platform. Academy lessons are for educational purposes only and do not constitute financial advice. Always consult a SEBI-registered investment advisor for personalised recommendations.