Question: why does xirr show 0?
Answer: This might occur when you build a financial model that has a sensitivity around its start date and the first cash flow could be this month or in 12 months time depending on the scenario chosen. The XIRR returns a 0% even when it is obvious there must be another answer and the XNPV formula is generating an answer.