Please complete in excel and include cell forumla so that I can undstand what to put inside the cell and how to arrive at the answer. Thank you.

D H -70,000 -80,000 90,000 Use "data table" function to calculate various of NPV for Project B. Use the following information to create the two variable datatable: WACC: 3%, 4%, 5%, 6%, 7%, 8%, 9%, 10%, 11%, 12%, and The initial investment: 40,000, 33 50,000, 60,000, 70,000, 80,000,90,000. (Present your answer at the coresponding space below) 54 55 56 57 Project B -40,000 -50,000 -60,000 59 3% 60 4% 51 5% 6% 63 795 64 894 65 9% 66 10% 67 11% 68 12% 69 70 71 72 73 74 75 76 77 79 1 2 Question 2: (60%) Your firm is considering two projects with the following cash flows. 3 4 WACC 12% 12% 5 year Project A 6 0 7 1 -55,000 25,000 19,000 17,000 11,000 10,000 Project B -70,000 25,000 21,000 19,000 14,000 12,000 8 2 9 3 10 4 11 5 12 a. Calculate NPV and IRR for both projects 13 (10%) 14 NPV 15 IRR 7,233.34 (1,707.30) 11% 18%