XIRR Calculator – Annualised Return for Irregular Cash Flows
Calculate XIRR (Extended Internal Rate of Return) for investments with irregular dates and amounts. Enter each cash flow with its date. Ideal for mutual fund SIP, lump sums, dividends, and redemptions. Free, no sign-up.
XIRR Calculator
Calculate the internal rate of return for irregular cash flows with different dates. Enter each cash flow with its date. First row is typically the initial investment (negative).
How XIRR works
XIRR finds the annual rate r such that: Σ (CF_i / (1+r)^(days_i/365)) = 0, where CF_i is each cash flow and days_i is days from the first date. Negative flows = money out (investments); positive = money in (returns/redemptions).
Understanding XIRR and when to use it
XIRR (Extended Internal Rate of Return) is the standard measure for calculating the annualised return on investments where you add or withdraw money on different dates. Mutual fund SIPs, for example, involve monthly investments on varying days. A lumpsum might be added later. Dividends may be received at irregular intervals. XIRR accounts for all these dates and amounts to produce a single annualised return figure.
To use the XIRR calculator, list each cash flow with its date. Outflows (investments) are negative; inflows (redemptions, dividends, final value) are positive. The first entry is usually your initial investment. The last might be the current value if you have not redeemed. The calculator iteratively finds the annual rate that makes the net present value of all flows equal to zero.
XIRR is more accurate than CAGR when cash flows are irregular, because CAGR assumes a single lumpsum at the start and a single value at the end. For SIPs and mixed investments, XIRR reflects the true time-weighted return. Use our XIRR calculator alongside the mutual fund returns calculator and CAGR calculator to compare different scenarios. Results are mathematical projections; actual returns depend on market performance.