ONLY SHOW HOW TO DO IN EXCEL.

please no hard coded formulas

A. If the appropriate discount rate is 12%, rank the two projects.

B. Which project is preferred if you rank by IRR?

C. Calculate the crossover rate, namely, the discount rate r at which the NPVs of both projects are equal. D. Should you use NPV or IRR to choose between the projects? Give a brief description.

1 Section a. 2 Discount rate 12% 3 4 Year 5 6 72 83 9 4 105 11 Project A Project B -500 -500 180 200 175 250 160 170 100 25 100 30 12 13 NPV 14 IRR 15 16 17 18 19 20