use excel formulas

Consider the following two mutually exclusive projects. What is the IRa for each project? What is the crossover rate between the two projects? What is the NPV for each project at a required return of 11 percent? What is the NPV for each project at the various interest rates shown? 4. Input area: (Use cells A6 to C20 from the given information to complete this question. You must use the bulit-in Excel function to answer this question.) 23 function to answer this question.) 24 25 Output area: 26 27 IRR A 28 IRR B 29 30 31 Year 0 32 Year 1 33 Year 2 34 Year 3 35 Year 4 36 37 Crossover rate 38 NPV A. 40 NPV B 41 42 43 NPV at 0% 44 NPV at 5% 45 NPV at 10% 46 NPV at 15% 47 NPV at 20% 48 NPV at 25% CF difference 49 50 51 52 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. 53 Nothing in this area will be graded, but it will be submitted with your assignment. 54 NPVA NPV B 55 Graded Worksheet Calculation Mode Automatic Workbokstanstics