How this calculator works
XIRR finds the annual rate that balances a list of dated investments and receipts using their actual timing.
- Step 1Read the dates1461 actual daysElapsed time includes leap days.
- Step 2Discount each flowActual days ÷ 365Each amount is valued at its own date.
- Step 3Solve for the rate10.66%The sample result is an annualised rate.
Negative amounts represent money invested. Positive amounts represent money received. The calculator sorts dates before solving, so the order of pasted rows does not change the calculation.
Formula
- Dated net present value
Σ amount ÷ (1 + rate)^((date − first date) / 365) = 0- Elapsed time
actual calendar days; leap days included
- Total invested in the sample₹1,00,000
- Total received in the sample₹1,50,000
- Annualised XIRR10.66%
The solver samples rates from -99% to 1,000% per year, then uses bisection where sampled NPV values change sign. It reports ambiguity if it detects multiple roots. Closely spaced or tangent roots may be missed.
What this result leaves out
- Taxes and feesThese are not deducted from the cash flows.
- Future performanceThe result describes only the flows entered.
- Risk or benchmarkNo investment is evaluated or recommended.
Reading your result
The example ₹1,00,000 invested and ₹1,50,000 received produces an annualised XIRR of 10.66% over 1461 actual days.
XIRR is sensitive to both amounts and dates. Check that the list includes every contribution and receipt in the period.
XIRR, IRR or CAGR?
- XIRRCash flows on any dates, such as SIP instalments.
- IRRCash flows at equal intervals, such as yearly.
- CAGROne amount in and one out, nothing between.
For evenly spaced flows, the IRR calculator gives the same answer with less typing. For a single investment held to a sale, the CAGR calculator is enough. To plan future monthly investing, use the SIP calculator.
Common mistakes
Mistake: Entering investments as positive numbers.
Instead: Use negative amounts for money invested and positive amounts for money received.
Mistake: Using a month or year label instead of an exact date.
Instead: Use the actual transaction date in YYYY-MM-DD format.
Mistake: Treating this historical result as a future projection.
Instead: Use it only to describe the cash flows you entered.
The result does not include taxes, fees or inflation and is not investment advice. Past cash flows do not predict future performance.
Checking the method
A separate script re-solves every test case by bisection and by Newton's method, and reproduces Microsoft's published XIRR example.
Microsoft publishes 37.34% for its example; this calculator gives 37.34%. Read how we test our calculators, or browse more money calculators.