excel formulas needed. thanks.

(Excel Formulas) You are considering an investment in two projects, A and B. Both projects will cost $140,000, and the projected cash flows are as follows: A 1 Year 2 0 3 1 4 2 S 3 6 4 7 5 8 9 WACC 10 11 NPV 12 Profitability Index 13 IRR 14 MIRR B Project A (140.000) 17,188 29,562 43.250 57.315 67,500 Project B (140,000) 51.750 48,812 43,750 29,563 17,375 9.0% $13,227.66 $16.530.22 1.12 13.03% 13.65% 11.39% Type in the Excel formulas you should enter in the cells with bold borders in the table above to solve problems a and b. Assume the WACC is 9%. a. Calculate the Profitability Index of Project B. (2 Points) 14 MIRR 11.39% Type in the Excel formulas you should enter in the cells with bold borders in the table above to solve problems a and b. Assume the WACC is 9%. a. Calculate the Profitability Index of Project B. (2 Points) b. Calculate the MIRR of Project A assuming that the reinvestment rate is the same as the WACC. (2 Points) c. Based on the information provided in the table above, in which project will you choose to invest assuming the two projects are mutually exclusive? Why? (2 Points)