Use "data table" function to calculate various of NPV for Project B. Use the following information to create the two variables datatable: WACC: 3%, 4%, 5%, 6%, 7%, 8%, 9%, 10%, 11%, 12%, and The initial investment: 40,000, 50,000, 60,000, 70,000, 80,000, 90,000. (Present your answer at the coresponding space below) Project B -40,000 -50,000 -60,000 3% 1 -2 53 64 65 66 4% 5% 6% 7% 8% 9% 10% 11% 12% 67 68 69 70 71 72 73 74 75 76 77 78 79 A B D 1 2 Question 2: (60%) Your firm is considering two projects with the following cash flows. 3 4 WACC 12% 12% 5 year 0 Project A 6 -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% 16 17 b Spin button (20%) Calculate the NPV for project A again then create a spin button to change the value of WACC to get various NPVs accordingly. Limit the WACC value from 5% to 15% with 18 1% incremental. 19 20 21 Project A year Faste ili nsert B I U A $ % 9 68 -28 Format as Table Cell Styles Delete -7 x fx b Spin button (20%) Format D H Use "data table" function to calculate various of NPV for Project B. Use the following information to create the two variables datatable: WACC: 3%, 4%, 5%, 6%, 7%, 8%, 9%, 10%, 11%, 12%, and The initial investment: 40,000, 50,000, 60,000, 70,000, 80,000, 90,000. (Present your answer at the coresponding space below) Project B -40,000 -50,000 -60,000 -70,000 -80,000 -90,000 . 2 3 3% 4% 5% 6% 7% 8% 9% 10% 11% 12% 5 56 57 69 70 71 72 73 74 75 76 77 28 79 81 83 Sheet3 Sheet2 new + Shooti Pivot A Pivot B Pivot Use "data table" function to calculate various of NPV for Project B. Use the following information to create the two variables datatable: WACC: 3%, 4%, 5%, 6%, 7%, 8%, 9%, 10%, 11%, 12%, and The initial investment: 40,000, 50,000, 60,000, 70,000, 80,000, 90,000. (Present your answer at the coresponding space below) Project B -40,000 -50,000 -60,000 3% 1 -2 53 64 65 66 4% 5% 6% 7% 8% 9% 10% 11% 12% 67 68 69 70 71 72 73 74 75 76 77 78 79 A B D 1 2 Question 2: (60%) Your firm is considering two projects with the following cash flows. 3 4 WACC 12% 12% 5 year 0 Project A 6 -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% 16 17 b Spin button (20%) Calculate the NPV for project A again then create a spin button to change the value of WACC to get various NPVs accordingly. Limit the WACC value from 5% to 15% with 18 1% incremental. 19 20 21 Project A year Faste ili nsert B I U A $ % 9 68 -28 Format as Table Cell Styles Delete -7 x fx b Spin button (20%) Format D H Use "data table" function to calculate various of NPV for Project B. Use the following information to create the two variables datatable: WACC: 3%, 4%, 5%, 6%, 7%, 8%, 9%, 10%, 11%, 12%, and The initial investment: 40,000, 50,000, 60,000, 70,000, 80,000, 90,000. (Present your answer at the coresponding space below) Project B -40,000 -50,000 -60,000 -70,000 -80,000 -90,000 . 2 3 3% 4% 5% 6% 7% 8% 9% 10% 11% 12% 5 56 57 69 70 71 72 73 74 75 76 77 28 79 81 83 Sheet3 Sheet2 new + Shooti Pivot A Pivot B Pivot