Scenario: The production department is intending on acquiring a more energy-efcient machine. The production manager has asked for your help with evaluating two alternative machine models. 0 Model 1: Requires initial investment of $80,000. The expected cash inow for the rst year is $26,000 and this is expected to grow at 2% per annum. 0 Model 2: Requires initial investment of $120,000. The expected cash inow for the first year is $38,000 and this is expected to grow at 2.5% per annum. The expected useful life of both machines are six years. The business requires a rate of return of 10%. Create a new Excel workbook and complete the requirements below on one sheet. Present everything in a tidy and formatted manner. Submit the Excel workbook onto Moodle. Reg uirements: 1. Set up columns A and B for the input data and input relevant information from the scenario above. (10 marks) 2. Calculate the following for Model 1 and Model 2 using cell references and functions (i.e., no hard coding): a. Projected future cash ows (15 marks) b. Net present value (use the NPV function) (15 marks) c. Profitability index (compute as net present value over initial investment) (15 marks) (:1. Internal rate of return (use the IRR function) (15 marks) e. Payback period (15 marks) 3. Insert a text box below your completed analysis and comment on which model you recommend the production manager acquire. (Maximum 150 words. Proofread thoroughly.) (15 marks)