Please show all excel work and formulas

6. Morrison Inc. is considering Projects S and L, whose cash flows are shown below. These projects are mutually exclusive, equally risky, and not repeatable. If the decision is made by choosing the project with the higher IRR, how much value will be forgone? Show your calculations and discuss your results. Note that under some conditions choosing projects on the basis of the IRR will cause $0.00 value to be lost. (2 points) Conduct a sensitivity analysis discussing what is the impact of change in WACC on to the net present values of each project Build a chart of the sensitivity analysis of the two projects. WACC 12% 1 2 3 4 Year CF for Projects 0 (1,025) 375 380 385 390 1 2 3 4 Year CF for Project L (2,153) 750 759 768 777 Project S Project L 0% 2% 4% 6% 8% 10% 12% 14% 16% 18% 20% 22% Value Lost 24%