📊 XIRR Calculator
Calculate the annualized return for investments with irregular cash flows on different dates.
Track your spending — free, private, no ads
Log this in Finance Tracker to see how it fits your monthly budget. No ads, no bank linking, no SMS access — your data stays yours.
Try Finance Tracker →outflow and one inflow
to see results
Frequently Asked Questions
How do I use the XIRR Calculator?
For each cash flow, enter a Date and an Amount — use negative amounts for money invested and positive amounts for money received (including your final redemption or current value). Add as many rows as needed with "+ Add Cash Flow", then click Calculate XIRR to see your annualized return, total invested, total received, net gain, and a cash flow timeline chart.
What is XIRR and how is it different from CAGR?
XIRR (Extended Internal Rate of Return) calculates the annualized return for a series of cash flows that occur on irregular dates — such as multiple SIP installments, top-ups, partial withdrawals, and a final redemption. CAGR only works for a single lump sum investment held for a fixed period. XIRR is more accurate for real-world investments where money goes in and out at different times.
How do I enter my cash flows?
Enter every amount you invested as a negative number (outflow) on the date you invested it, and every amount you received — including your final redemption value or current portfolio value — as a positive number (inflow) on that date. You need at least one negative and one positive cash flow for XIRR to be calculable.
How is XIRR calculated mathematically?
XIRR finds the rate r such that the sum of (cash flow / (1+r)^(days from first date / 365)) across all cash flows equals zero. Since this equation cannot be solved directly for r, an iterative numerical method (Newton's method) is used to converge on the rate that satisfies the equation.
Can XIRR be negative?
Yes. If the total amount you received is less than what you invested (a loss), XIRR will be negative, reflecting an annualized loss rate. This is normal for investments that lost value or for very short holding periods where even small losses appear large when annualized.
Why might my mutual fund statement's XIRR differ slightly from this calculator?
Small differences can occur due to rounding, the exact day-count convention used (365 vs 365.25 days/year), or the precision/iteration limit of the solver. These differences are typically negligible (a fraction of a percent) and don't affect the overall conclusion about your returns.
How do I find the XIRR of multiple SIP installments plus a final redemption?
Add one row for each SIP installment as a negative amount on its actual investment date, then add a final row with today's date (or your redemption date) and the current value of your holdings as a positive amount. The calculator will treat this as a single irregular cash flow series and compute the single annualised rate that makes all of these cash flows consistent.
What happens if my cash flows don't have a solution for XIRR?
If all cash flows are the same sign (all negative or all positive), or if Newton's method fails to converge within its iteration limit for an unusual combination of amounts and dates, the calculator cannot return a valid rate. Double-check that you have at least one investment (negative) and one return (positive) cash flow, with realistic dates and amounts.