solve in excel

Explain XIRR and XNPV. How is guess used in IRR function of IRR? Discount rate for a company XYZ is 12% for the cash flows given below. You are required to calculate IRR using a loan table. Also calculate NPV, use data table to tabulate the NPV at various discount rate with an appropriate interval and show the existence of two IRRs on graph. Cash Year flows -400 0 1 150 250 W NI 3 -50 4 40 5 22