XIRR is good for calculating the returns on investments with irregular cash flows, varying rates of return over the investment period or no fixed holding period. For example, SIP mutual funds, private equity funds or venture capital where there is no fixed holding period.