Question: why does xirr return 0?
Answer: XIRR and XNPV in Excel XIRR is closely related to the XNPV function because the result of XIRR is the discount rate that leads to a zero net present value. In other words, XIRR is XNPV = 0.