please provide detail steps please. I want to know howto make these calculations since i am poor in accounting. thanks for helping me ;)
Question 1 Suppose you are the assistant manager of Gamma Corporation. This morning, your boss asked you to study the financial statements of the company and prepare a written report to him. Following are the income statement and the balance sheet of Gamma Corporation. Gamma Corporation Income Statement (Sthousands) Year ended 31 December 2017 2018 2019 2020 Sales 13,895.75 14,554.78 12,88123 11,583.13 Cost of goods sold 8.419.73 9.006.88 7.972.38 6.973.83 Gross Profit 5,476.02 5,547.90 4,908.85 4,609.30 Selling & administrative expensive 4,257.80 4,269.78 4,165.93 3,882 35 Depreciation 159.78 171.75 179.75 171.75 Operating profit 1,058.44 1,106.37 563.17 555.20 Interest Expense 167.75 255.63 243.65 199.70 Non-operating income (-) /expense -59.93 -19.98 31.95 -4.00 Special Items 231.65 139.80 247.65 Earnings before taxes 950.62 639.07 147.77 111.85 Income Taxes 375.45 75.88 104.28 91.18 Net income 575.17 563.19 43.49 20.67 Balance Sheet (S thousands) 31 December 2017 2018 2019 2020 Assets Cash and equivalents 924.65 838.78 718.95 1,126,35 Account receivables 2,358.55 2,244.73 2,068 98 1.665.58 Inventories 2,176,83 2,252.73 2.136.88 1.657.58 Other current assets 383.45 519.25 515.25 515.25 Total current assets 5.843.48 5,855.49 5,440.06 4,964.76 Gross plant, property and equipment 1,425.93 1,413.95 1,593.68 1.685.55 less: Accumulated depreciation 687.00 786.85 902.68 974.58 Net plant, property and equipment 738.93 627.10 691.00 710.97 Other assets 551.20 535.18 818.83 571.18 Total assets 7,133.61 7,017.77 6,949.89 6,246.91 Liabilities Current portion of long-term debt 211.70 483.30 347.50 738.93 Notes payable 131.80 163.75 111.83 Accounts payable 782.85 766.88 810.83 615.10 Taxes payable 263.63 15.98 331.53 31.95 Other current liabilities 675.03 874.73 766.88 994.55 Total current liabilities 2,065.01 2,304.64 2,448.47 2.492.36 Long-term debt 3,411.03 2,552.28 2.212.78 1,477.85 Other liabilities 135.80 127.83 127.83 163.75 Total Liabilities 5,611.84 4.984.75 4,789.08 4.133.96 Equity Common stock 4.00 4.00 71.90 4.00 Retained earnings 3,986,20 4,489.45 4,557.35 4,577.35 less: treasury stock 2,468.43 2,460.43 2,468.43 2,468,40 Common equity 1,521.77 2.033.02 2.160.82 2,112.95 Total liabilities & equity 7.133.61 7,017.77 6.949.90 6,246,91 191.73 Requirements: With 1,500 word limit, provide a financial performance analysis report to your boss. The content should include the following sections: (a) Based on the figures appeared in the financial statements, show your (26 marks) calculation to find out the following financial ratios: 1. Current ratio 2. Acid-test ratio 3. Average collection period 4. Account receivable turnover 5. Inventory turnover 6. Operating income return on investment 7. Gross profit margin 8. Operating profit margin 9. Total asset turnover 10. Fixed asset turnover 11. Total debt ratio 12. Times interest earned 13. Return on equity (b) Comment the performance of the company during 2017 to 2020 in (42 marks) four areas (liquidity, profitability, finance and return on shareholders' investment). (c) Based on your findings in part (a) and (b), suggest one solution in (32 marks) each area in order to enhance the financial performance of Gamma Corporation