XIRR Calculator
XIRR is the annualised return of a series of cash flows that happen on different dates — exactly what real investing looks like: SIP instalments, lump-sum top-ups, partial redemptions, a final value today. It is the number your mutual fund statement means by 'annualised return'.
Add each cash flow with its date. Money you invested goes in as negative; money you received (or the current value of what you still hold, dated today) goes in as positive. The calculator solves for the rate that makes them all balance — the same algorithm as Excel's XIRR.
How it works
- Each flow is discounted by (1 + r) raised to (days since the first flow ÷ 365).
- The calculator finds the r where the discounted flows sum to zero (Newton-Raphson with a bisection fallback).
- To value an open portfolio, add its current value as the final positive flow dated today.
Frequently asked questions
XIRR vs CAGR — which one do I need?
CAGR handles exactly two numbers: a start value and an end value. The moment there are instalments, top-ups or withdrawals in between, CAGR is meaningless and XIRR is the right measure — it weights every rupee by how long it was actually invested.
What is the sign convention?
Outflows from your pocket (purchases, SIP instalments) are negative; inflows to your pocket (redemptions, dividends, the current value of holdings) are positive. You need at least one of each, and the result is meaningful only if the dates are right.
Will this match Excel and my mutual fund app?
Yes — it solves the same equation Excel's XIRR does (Actual/365 day count). Small differences vs your app usually come from the app including dividends, charges or same-day NAV conventions you did not enter here.
My XIRR looks absurdly high — why?
Very short holding periods annualise dramatically: a 5% gain in one month is an XIRR of about 80%. Read XIRR alongside the actual time invested; for periods under a year, the absolute gain is often the more honest number.
Related tools
Stop calculating. Start getting alerted.
MarketPing watches every NSE & BSE filing in real time — results, dividends, buybacks, order wins — AI-summarised with likely price impact and delivered to your WhatsApp.
This tool is an educational estimate, not investment or tax advice. Rates and rules change — verify current figures and consult a professional before acting.