XIRR vs IRR

The decision between using the IRR versus the XIRR function can be very significant in waterfall calculations. You should check your JV Agreements and other legal documents to see if the XIRR or IRR function is specifically required. If it is not specified, then the XIRR function is preferred, especially if you need to calculate preferred returns to a specific day.