please use excel formulas to show how to get the answer

Bruin, Inc., has identified the following two mutually exclusive projects. What is the IRR for each of these projects? If the required return is 11 percent, what is the NPV for each of these projects? Input area: B Year o Year 1 Year 2 Year 3 Year 4 Required return ($41,300) 19,100 17,800 15,200 8,400 11% ($41,300) 6,300 14,200 17,900 30,300 (Use cells A6 to C12 from the given information to complete this question. You must use the built-in Excel function to answer this question.) Output area: IRRA IRR B NPVA NPVB