XIRR Calculator
CAGR works for one investment. Real life is messier — SIPs every month, a lumpsum here, a partial withdrawal there. XIRR (Extended Internal Rate of Return) is the one number that fairly annualises all of it, and it's what mutual-fund statements use for your personal returns.
Example: invest ₹1 lakh, then ₹50,000 six months later, redeem ₹1.98 lakh after two years — that's a 16.27% XIRR, even though the 'simple' return is 32% over two years. XIRR accounts for when each rupee was invested.
Four steps, thirty seconds.
Add your cash flows. Investments as negative amounts, redemptions/withdrawals as positive — with their actual dates.
Click Calculate XIRR. The calculator solves for the rate that makes the net present value of all flows zero.
Read your true return. This is the annualised rate your money actually earned, timing included.
Compare with CAGR. For a single lumpsum both agree; for SIPs, XIRR is the honest number — try our CAGR calculator to see the difference.
The equation: Σ CFi / (1 + r)ti = 0, where ti is years from the first cash flow. Solved by Newton–Raphson iteration (the same method Excel's XIRR uses).
Worked example: −₹1L on 15 Jan 2023, −₹50k on 15 Jul 2023, +₹1.98L on 15 Jan 2025 → XIRR = 16.27%. Absolute return is 32%, but annualised it's 16.27%.
XIRR definition per SEBI-mandated portfolio disclosures; Newton–Raphson method as implemented in spreadsheet XIRR functions.
CAGR for a single investment held start-to-end. XIRR for anything with multiple cash flows — SIPs, step-ups, partial withdrawals. Your fund statement's 'personal returns' are XIRR.
In rising markets, later SIP instalments buy at higher NAVs and get less time to compound — so your XIRR trails the fund's since-inception CAGR. That's normal, not a problem.
Yes — add your investments so far and use today's date with the current portfolio value as a positive 'redemption'. That gives your XIRR to date.
XIRR needs at least one negative and one positive flow, and sensible dates. All-negative flows (no redemption yet) have no defined XIRR — add a notional current value.
XIRR is IRR with exact dates (365-day years). Plain IRR assumes evenly-spaced periods — fine for yearly flows, wrong for SIPs.
Disclaimer: Educational illustration only — not financial advice. Computed in your browser via Newton–Raphson; your data never leaves your device.