Problem 1 Computer Technology Enterprises is trying to select the best investment from among four alteratives. The company's required rate of return is 14%. The initial cost and future cash flows of the alternatives are presented below. You can use Excel to solve this problem. If you do, please submit your homework document and the Excel file. Alternative DTS 200,000 Alternative A S) Alternative B (S) Alternative 30000 -200,000 200.000 ROXXO 0 601000 NTNO 60,000 70000 907000 TODO TO00 60000 30000 100000 60000 TOOOOO TOTO (If you are not submitting an Excel file, PLEASE SHOW YOUR WORK for parts C, E, and ) A) Calculate the Puyback period for each alternative and complete the following table rundt fedecimal Alterative Active B Alterative Alternative Payback B) Which of the alternatives would you select under the payback method? Please explain why. Alternative because it has the lowest payback period of 2.10 years so it will recover its initial investment in the shortest amount of time the of 2 the 420 words Y chance that Focus 1 TB - + 80% Calculate the net present value (NPV) for each alternative and complete the following table (round to whole numbers): temative A Altemative B Alterative C Alterative D NPV D) Which of the alternative would select under the net present value? Please explain why. 5) Calculate the internal rate of return (TRR) for each alternative and complete the following table (round to two decimal places): Alternative A Alterative B Alterative Alternative D ? Which of the alternative would you select under the internal rate of return? Please explain why G) Calculate the modified Internal rate of return (MIRR) for each alternative and complete the following table (round to two decimal places): VIRR Alternative 150 Alterative B TOT Alterative 136 Assmative D 16 95% H) Which of the alternative would you select under the modified internal rate of return? Please explain why. Alternative because it has the Highest MIRR rate at 16.55% and it will generate more profits of 2 420 words Focus F C E - + 8C