please do in detail 16) show your work by using exel

16. NPV and IRR Bausch Company is presented with the following two mutually exclusive projects. The required return for both projects is 15 percent. Year Project M Project N 0 1 2 3 4 - $ 140,000 61,500 73,400 68,100 40,500 -$359,000 159,300 168,400 154,800 110,400 a. What is the IRR for each project? b. What is the NPV for each project? Which, if either, of the projects should the company accept? 17. NPV and Profitability Index Coore Manufacturing has the following two 16. NPV and IRR Bausch Company is presented with the following two mutually exclusive projects. The required return for both projects is 15 percent. Year Project M Project N 0 1 2 3 4 - $ 140,000 61,500 73,400 68,100 40,500 -$359,000 159,300 168,400 154,800 110,400 a. What is the IRR for each project? b. What is the NPV for each project? Which, if either, of the projects should the company accept? 17. NPV and Profitability Index Coore Manufacturing has the following two