Part 2: The following screen shot shows a part of an EXCEL worksheet that will be used to do an NPV calculation for a proposed investment and to calculate the IRR of the investment. Goal Seek will be used to calculate the IRR and the pop-up Goal Seek dialogue box is shown in the screen shot. D Set call By changing cell Cancel B 1 Investment Assessment (NPV Calculation) 2 Discount Rate 6% 3 4 Year Return ($) 5 0 -65000 6 1 12000 7 2 18000 8 3 24000 9 4 20000 10 11 NPV (years 1-4) $63,333.43 12 Total NPV ($1,666.57) 13 14 15 IRR Calculation 16 IRR 6% 17 Total NPV $ (1,666.57) Question 2: Is the actual IRR (still to be calculated) i) Less than 6%, More than 6%, or 6% Questions continue on the next page MATH105-12 Fall 2020 Problem Set 2.6 Due by Noon on Monday, October 19, 2020 Question 3: Which cell reference (address) should be typed in the "Set cell" box? Question 4: What value should be typed in the "To value" box? Question 5: Which cell reference (address) should be typed in the "By changing cell" box