Scenario: The production department is intending on acquiring a more energy-efficient machine. The production manager has asked for your help with evaluating two alternative machine models. Model 1: Requires initial investment of $80,000. The expected cash inflow for the first year is $26,000 and this is expected to grow at 2% per annum. Model 2: Requires initial investment of $120,000. The expected cash inflow 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. Requirements: 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 flows (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) d. 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)