Please give me a complete answer with calculations and place answers in tables where required

Question 2 (20 marks) Leasing arrangement cash flow template Yummy plc specialises in the production and sale of pizzas. It is considering increasing production and plans to invest in a new kitchen oven costing Rs2,400,000 payable immediately. The company can acquire the equipment in one of two ways: 1. Outright purchase via a 4 year bank loan at an annual interest rate of 5%. The terms of the loan agreement would entail an upfront transaction cost of Rs100,000 and the loan would be repayable by four equal annual instalments starting one year from now. Depreciation is a tax-allowable expense and is available to the owner of the oven. II A lease arrangement with anual rentals of Rs700,000 payable by Yummy Ltd over 4 years payable at the end of each year. Rentals payable by the lessee under the lease arrangement are fully taxedeductible. Tax is levied at the rate of 15%. Required: (a) Prepare the loan amortization table ( 5 marks) (b) Using the template below, establish the cash flow pattern under each financing option (S marks) (c) Using a discount rate of 8% as the cost of capital, evaluate which financing option the company should go for. (7 marks) Loan arrangement cash flow template Question 2 (20 marks) Leasing arrangement cash flow template Yummy plc specialises in the production and sale of pizzas. It is considering increasing production and plans to invest in a new kitchen oven costing Rs2,400,000 payable immediately. The company can acquire the equipment in one of two ways: 1. Outright purchase via a 4 year bank loan at an annual interest rate of 5%. The terms of the loan agreement would entail an upfront transaction cost of Rs100,000 and the loan would be repayable by four equal annual instalments starting one year from now. Depreciation is a tax-allowable expense and is available to the owner of the oven. II A lease arrangement with anual rentals of Rs700,000 payable by Yummy Ltd over 4 years payable at the end of each year. Rentals payable by the lessee under the lease arrangement are fully taxedeductible. Tax is levied at the rate of 15%. Required: (a) Prepare the loan amortization table ( 5 marks) (b) Using the template below, establish the cash flow pattern under each financing option (S marks) (c) Using a discount rate of 8% as the cost of capital, evaluate which financing option the company should go for. (7 marks) Loan arrangement cash flow template