What is XIRR (Extended Internal Rate of Return)? — Meaning, Definition & Example
Definition
XIRR calculates the annualized return on investments with multiple cash flows at irregular intervals, like SIPs. It is more accurate than CAGR for SIP investments because it considers the timing and amount of each investment and redemption.
Your SIP of ₹10,000/month for 5 years grew to ₹9 lakh. CAGR can't calculate this accurately, but XIRR gives the true annualized return of ~14%.
🇮🇳 XIRR (Extended Internal Rate of Return) in Hindi / हिंदी में
XIRR — XIRR अनियमित अंतराल पर कई नकद प्रवाह वाले निवेशों पर वार्षिक रिटर्न की गणना करता है। SIP के लिए CAGR से अधिक सटीक है।
XIRR (Hinglish) — XIRR multiple cash flows (jaise SIP) ke investments ka accurate annualized return calculate karta hai. CAGR se zyada accurate hai SIP ke liye.
The Problem XIRR Exists to Solve
CAGR answers 'what did ONE lumpsum do between two dates?' But real investing is messy — SIPs, top-ups, skipped months, partial redemptions. Each rupee was invested for a DIFFERENT length of time, and a single point-to-point growth rate is mathematically wrong for that. XIRR (Extended Internal Rate of Return) fixes it: one annualised rate that's consistent with every cash flow on its actual date. When your app shows 'returns: 13.2%' on a SIP — that's XIRR.
Compute It Yourself in 2 Minutes (Excel/Sheets)
List every flow with its date — investments as NEGATIVE, redemptions/current value as POSITIVE — and call =XIRR(values, dates). Example: 12 monthly SIPs of ₹10,000 through 2025 (twelve −10000 entries) and today's value ₹1,29,500 as the final +ve row → XIRR ≈ 15.6%. Portfolio-level XIRR works the same way: dump ALL flows across all funds into one column and the final total value at the end — one number for your whole investing life.
Reading It Right: Three Traps
① Short-period madness — XIRR annualises: a fund up 6% in 3 months shows XIRR ≈ 26%, which nobody will earn for the full year. Trust XIRR only after 1+ year of flows. ② Comparing your XIRR to a fund's advertised CAGR — different questions (your timing vs the fund's point-to-point); your SIP XIRR can be lower than fund CAGR in rising markets and higher in choppy ones, with nobody at fault. ③ Sign errors — one investment typed positive silently corrupts the result; sanity-check against your platform's number.
XIRR vs CAGR vs Absolute Return — Cheat Table
| Metric | Right For | Wrong For |
|---|---|---|
| Absolute return (%) | Quick glance at total growth | Anything across different durations |
| CAGR | One lumpsum, point to point; fund factsheets | SIPs / multiple flows |
| XIRR | SIPs, portfolios, real life — any dated flows | Periods under ~1 year (annualisation distorts) |
Rule of thumb: lumpsum → CAGR; everything else → XIRR. For goal planning both feed the same intuition — long-run equity XIRRs in the 10-14% band are the historical base rate (see SIP), never a promise.
Rules verified as of July 2026 (incl. GST 2.0 structure effective 22 Sep 2025 and FY 2026-27 tax framework). Facts last checked: 18 July 2026 by Priyanka Dhawan.