PLEASE DO ON EXCEL FORMAT. Thank you!

Problem 13-2A Ratios, common-size statements, and trend percents P1 P2 P3 Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31 2019 2018 2017 Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total expenses Income before taxes Income tax expense Net income $555,000 $340,000 $278,000 283,500 212,500 153,900 271,500 127,500 124,100 102,900 46,920 50,800 50,668 29,920 22,800 153,568 76,840 73,600 117,932 50,660 50,500 40,800 10,370 15,670 $ 77,132 $ 40,290 $ 34,830 KORBIN COMPANY Comparative Balance Sheets At December 31 2019 2018 2017 0 Assets Current assets $ 52,390 $ 37,924 $ 51,748 Long-term investments 500 3,950 Plant assets, net 100,000 96,000 60,000 Total assets $152,390 $134,424 $115,698 Liabilities and Equity Current liabilities $ 22,800 $ 19,960 $ 20,300 Common stock 72,000 72,000 60,000 Other paid-in capital 9,000 9,000 6,000 Retained earnings 48,590 33,464 29,398 Total liabilities and equity $152,390 $134,424 $115,698 Required 1. Compute each year's current ratio. Round ratios to one decimal. 2. Express the income statement data in common-size percents. Round percents to two decimals. 3. Express the balance sheet data in trend percents with 2017 as base year. Round percents to two decimals. Check (3) 2019, Total assets trend, 131.71% Analysis Component 4. Refer to the results from parts 1, 2, and 3. (a) Did cost of goods sold make up a greater portion of sales for the most recent year? (b) Did income as a percent of sales improve in the most recent year? (c) Did plant assets grow over this period