please solve :

- please use the same format when solving the problem.

- show on excel

- show work

- show formulas

-explain

Thank you!

B A D D E F G H 2 P11-7M (Use the data and instructions provided below) 3 u WN 4 6 The cash flows for 4 Independent projects are shown below. A. Calculate the IRR for each project. B. If the discount rate for all three projects is 10 percent, which project or projects would you want to undertake? D. Calculate the MIRR for each project using 10% for the Finance Rate and Reinvest Rate and indicate which projects should be accepted or rejected 7 8 9 Year $ 10 11 12 13 14 15 16 17 18 19 20 21 22 ANO 1 2 3 4 5 Project A (10,000.00) $ 2,950.00 2,950.00 2,950.00 2,950.00 2,950.00 Project B Project C (57,950.00) $ (10,000.00) $ 12,000.00 3,950.00 14,000.00 3,950.00 16,000.00 3,950.00 18,000.00 17,950.00 Project D (350,000.00) 140,000.00 140,000.00 140,000.00 A IRR B 23 24 25 Discount Rate 10.00% 10.00% 10.00% 10.00% 26 A B D E F G 14 15 1 2 3 4 5 16 2,950.00 2,950.00 2,950.00 2,950.00 2,950.00 3,950.00 3,950.00 3,950.00 12,000.00 14,000.00 16,000.00 18,000.00 17,950.00 140,000.00 140,000.00 140,000.00 17 18 19 20 21 22 A. IRR B. 23 Discount Rate 10.00% 10.00% 10.00% 10.00% 24 25 26 27 D MIRR 28 29 30 31 32 33 34