Finance
XIRR Calculator
XIRR (Extended Internal Rate of Return) is what mutual fund statements quote. Add as many cashflows as you want — investments are negative, withdrawals/maturity are positive — pick a date for each, and we'll return the same number Excel's XIRR function gives. Built with the Newton-Raphson method and a Brent-style bisection fallback so it works on tricky cashflow patterns.
Cashflows
Negative = money out (investment). Positive = money in (redemption / dividend).
XIRR (annualised)
Total invested
₹2,00,000
Total received
₹3,20,000
Net gain
₹1,20,000
Cashflows
4
XIRR matches Excel's XIRR function within ~6 decimals. The first cashflow date is the reference date for time-weighting all others.
Related tools
Need a finance read next?
Our blog and finance hub explain the ideas behind these tools — clearly and without jargon.
Frequently asked
- Why is my SIP CAGR so different from absolute return?
- SIPs invest at different times, so each instalment compounds for a different period. XIRR handles this correctly; absolute return doesn't and tends to massively understate the per-investment performance.
- Why does my XIRR sometimes look 'wrong'?
- Make sure your cashflow signs are correct — investments must be negative, redemptions positive. Also confirm dates are in YYYY-MM-DD format.
- Is the answer the same as Excel's XIRR?
- Yes — typically within 6 decimal places. We solve the same NPV equation Excel does, with the same convention of treating the first cashflow as the reference date.
Try CAGR next →
CAGR