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 and mark it Invested (money you put in) or Received (money you got back, or the current value of what you still hold, dated today). The calculator solves for the rate that makes them all balance — the same equation as Excel's XIRR.
How it works
- Each flow is discounted by (1 + r) raised to (days since the first flow ÷ 365).
- Flows on the same date are netted, then the calculator searches every rate from −99.9999% to +10,000% a year for the r where the discounted flows sum to zero, refining each by bisection.
- If more than one rate balances the flows (they change direction more than once), it shows the one nearest 10% — where Excel starts — and lists the others.
- To value an open portfolio, add its current value as a final Received 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?
Money leaving your pocket (purchases, SIP instalments) is an outflow — Excel writes it as a negative number; here you mark the row Invested. Money coming back (redemptions, dividends, the current value of holdings) is an inflow — positive in Excel, Received here. You need at least one of each, on different dates, 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.