Background: Aurora Company is considering the purchase of a new machine. The invoice price of the new machine is RM 140,000, freight charges are estimated to be RM 4,000, and installation costs are expected to be RM 6,000. Salvage value of the new machine is expected to be zero after a useful life of 5 years. Existing equipment could be retained and used for an additional 5 years if the new machine is not purchased. At end of the additional 5 years, the salvage value of the existing equipment would be zero. If the new machine is purchased now, the existing equipment would have to be scrapped at its current book value. Aurora's accountant has accumulated the following data regarding annual sales and expenses with and without the new machine: 1. Without the new machine, Aurora can sell 12,000 units of product annually at a per unit selling price of RM 100. If the new machine is purchased, the number of units produced and sold would increase by 10%, and the selling price would remain the same. 2. The new machine is faster than the existing equipment, and it is more efficient in its usage of materials. With the existing equipment the gross profit rate will be 25% of sales, whereas the rate will be 30% with the new machine. 3. Annual selling expenses are RM 180,000 with the existing equipment. Because the new machine would produce a greater number of units to be sold, annual selling expenses are expected to increase by 10% if it is purchased. Annual administrative expenses are expected to be RM 100,000 with the existing equipment, and RM 113,000 with the new machine. 5. The current book value of the existing equipment is RM 36,000. Aurora uses straight- line depreciation method. 6. Aurora has two options for funding the purchase price of the new machine: a. 100% internal funding; or b. 50% internal funding and 50% bank loan at 5% APR for 5 years with the principal paid at the end of the loan period. 7. The income tax rate is 23% applied on the Profit Before Taxes (PBT). Tasks: In groups of up to 3 people, carry out the following analysis: i. Prepare analysis (of your choice) for the next 5 years; andii. Based on your analysis determine whether Aurora should keep the existing equipment or buy the new machine and what funding would be the most appropriate if buying the new machine