Problem 13-5A Comparative ratio analysis LO A1, P3 Please Solve the following Problem.

Please Fill in the Following including necessary formulas:

Required information Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows Barco Kyan Barco Kyan Company Company Company Company Data from the current year-end balance sheets Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Data from the current year' s income statement Sales $770,000 $880,200 594,100 638,500 13,000 $21,500 36,000 Cost of goods sold 40,400 59,400 Interest expense 84,940 134,500Income tax expense 8,600 14,800 24,300 152,500 204,400 4.96 5,900 7,500 Net income 320,000 307,400Basic earnings per share $472,740 $544,800 Cash dividends per share 3.63 3.76 3.97 Liabilities and Equity Current liabilities Long-term notes payable Common stock, $5 par value Retained earnings Total liabilities and equity Beginning-of-year balance sheet data s 27,800 s 57,200 63,600 111, 400 438,000 372,500 210,000 206,000 90,664 $ 66,340 $100,300 Accounts receivable, net 85,800 107,000 Merchandise inventory 210,000 206,000 Total assets 110,600 131 500 Common stock, $5 par value $472,740 $544,800 Retained earnings 116,020