You are working with Dewina Food Industries Private Limited as Junior Analyst. Your company is famously known for its brand name Brahim's and is a producer of premium quality instant retort pouched foods in Southeast Asia. You are working at their manufacturing plant located in Selangor. Your manager is considering to purchase new packaging machine and shortlisted these four machines from two different suppliers. Your manager had projected the followings cash flows and discount rates. Your company standard payback period is maximum 4 years. Assume there's no limitation / restriction on the purchase. Year 0 1 2 3 4 5 6 Discount rate Machine 123-M Machine 123-A (RM) (RM) (330,000) (668,500) 82,500 52,000 82,500 82,500 82,500 82,500 82,500 10% 78,000 117,000 175,500 263,250 394,875 10% Machine 789-M (RM) -280,000 72,000 72,000 72,000 72,000 72,000 7.5% Machine 789-A (RM) -550,000 120,000 120,000 120,000 120,000 120,000 7.5% You are required to provide analysis in regards with these machines. Based on the above information, construct a spreadsheet in Excel. In your analysis, including the following: a) Calculation of Payback Period. b) Calculation of Net Present Value. c) Calculation of Internal Rate of Return. d) Calculation of Profitability Index. e) Based on the above results, a) - d), explain your decisions. f) The company budgeted RM1 million for this investment. Advise your manager, which machine(s) should the company buy and reject? Why? How much is the total initial cost? [5 marks] [8 marks] [8 marks] [2 marks] [4 marks] [12 marks] g) From the previous question f), how would you decision change, if there's no capital limitation? State your decision and reasons. Rank your preferred machine(s). [4 marks] h) Assume this is mutually exclusive project, state your decision and reason. [2 marks]