How this calculation works
Estimate an annualised money-weighted return when investments and receipts occur on irregular dates. Enter payments into the investment as negative cash flows and amounts received as positive. For an unsold holding, a positive ending market value on the valuation date closes the calculation without pretending that it was actually sold.
Worked example
This example uses illustrative inputs. Your current result is shown above.
Enter two lines: 2023-01-01,-100000 and 2024-01-01,110000. The dates are 365 days apart. Solving −₹1,00,000 + ₹1,10,000/(1+r) = 0 gives a 10% XIRR; invested is ₹1,00,000, received ₹1,10,000 and net cash flow ₹10,000.
Assumptions and limits
- Each line contains an ISO date and a signed amount separated by a comma.
- The exponent uses actual elapsed days divided by 365, including across leap years.
- At least one negative and one positive cash flow are needed; some cash-flow patterns have no usable root or more than one mathematical root.
Questions people ask
Where does the current value of an unsold investment go?
Enter it as a positive final cash flow on the valuation date. It closes the valuation mathematically; do not also enter it as an actual withdrawal unless that withdrawal really occurred.
Why can XIRR differ from CAGR?
XIRR accounts for the dates and sizes of multiple contributions and receipts. CAGR only connects a starting and ending value without external cash flows.
Why might a complicated cash-flow sequence fail?
Alternating investments and receipts can create multiple roots or a root outside the solver’s search range. A failed solve is not evidence that the return is zero.