2 The following information was gathered from a company's balance sheet and income statement. 3 4 5 Cash 67 Accounts receivable Inventory S Long-term assets 9 Total assets 10 11 12 Current liabilities 13 Long-term liabilities 14 Total liabilities 15 Stockholders' equity 16 Total liabilities and equity 17 18 19 Net sales 20 Cost of goods sold 21 Operating expenses 22 Interest expense 23 Income tax expense 24 Net income 25 26 Required: Current Previous $60,000 $50,000 $30,000 $35,000 $35,000 $45,000 $250,000 $160,000 $375,000 $290,000 Current Previous $50,000 $70,000 $90,000 $80,000 $140,000 $150,000| $235,000 $140,000 $375,000 $290,000 Current $360,000 $170,000 $61,000 $12,000 $22,000 $95,000 27 Use the information above to calculate the financial ratios listed below. 28 After you complete column D, ratio values will auto-populate (Use cells A2 to C24 from the given information abo 29 when calculating averages.) 30 D