4. (15 points) Create an Excel template in order to make break even analysis as shown below? YEAR Discount Rate 3 Costs TRUE Costs 0.000 42.000 44.100 46.300 48.600 51.000 0,86 0,82 0,70,75 38.095 38.095 38.095 38.091 38.079 38.057 5.000 31.200 39.000 48.700 60.800 76.000 ,950,910,86,8 0,78 0,75 8 PV of BenefitsTRUE PV of Benefits 23.810 28.299 33.690 40.066 47.638 56.712 72.000 0,95 0,91 Multiplier PV of Costs [y] pV of Costs [y] Benefits TRUE TRUE Benefits 228.513 280.700 Multiplier 230.215 10 Is this project acceptable? 12 13 Yes 15 16 17 18 PV of Cost PV of Benefit -Benefits a. In this template, you should be able to change "discount rate", to select" which variable to appear on the chart" and to make a project selection decision? b. If the decision to select the project is "Yes", show how you can use "Excel Goal Seek" data analysis tool to make the project selection decision "No" just by changing the G4 cell c. Provide the discount rate where the difference will be "O" 4. (15 points) Create an Excel template in order to make break even analysis as shown below? YEAR Discount Rate 3 Costs TRUE Costs 0.000 42.000 44.100 46.300 48.600 51.000 0,86 0,82 0,70,75 38.095 38.095 38.095 38.091 38.079 38.057 5.000 31.200 39.000 48.700 60.800 76.000 ,950,910,86,8 0,78 0,75 8 PV of BenefitsTRUE PV of Benefits 23.810 28.299 33.690 40.066 47.638 56.712 72.000 0,95 0,91 Multiplier PV of Costs [y] pV of Costs [y] Benefits TRUE TRUE Benefits 228.513 280.700 Multiplier 230.215 10 Is this project acceptable? 12 13 Yes 15 16 17 18 PV of Cost PV of Benefit -Benefits a. In this template, you should be able to change "discount rate", to select" which variable to appear on the chart" and to make a project selection decision? b. If the decision to select the project is "Yes", show how you can use "Excel Goal Seek" data analysis tool to make the project selection decision "No" just by changing the G4 cell c. Provide the discount rate where the difference will be "O