how does xirr formula work?
The Microsoft Excel XIRR function returns the internal rate of return for a series of cash flows that may not be periodic. ... It can be used as a worksheet function (WS) in Excel. As a worksheet function, the XIRR function can be entered as part of a formula in a cell of a worksheet.