must use ROUND function for most of the answers

2. Recent financial statements for Zimmer, inci are as follows: Zimener, inc. 4 Comparative Balance sheet 6 Assets 7 Current assets: (f) Cash 9 Marketable securities 10 Accounts receivable, net 11 inventory. 12 Other current assets 17: Iotal current assets 14 Plant and eqipment, net 15 Other assets 16 Total assets Uablities and Stockholders' Equity 18. current Liablities: 19 Accoonts payable 20 Shortterm bank loans 21. Acarued payables Other current liabilities 21. Total current liabdines 24 Eonds nyyable, 100 25 Total liabilities 26 Stockhaldern' equity? 27 Comenon stock Retained earnings Total stockholders' equity. Total liabilties and stocktiolders' equity Limmer, Inc- Income statement Sales (all on acount) Cost of goods sold Gross margin Selling and administrative expenses Operating expenses Depreciation and amortration General and administrative expenses Total selline and administrative expenses Net operating income Interest expense Net income before taxes Income taves Net income. 47 78 46 49 Addinonal intormation: 50 Dwdend per share paid in current year 51 Market price of shares at year end 49 Additional information: 50 Dividend per share paid in current year Market price of shares at year end Par value of common stock per share $1.00 $42.00 $20.00 Number of shares outstanding Required: Compute the following ratios for the current year only: (Use cells 88 to c52 from the given information to complete this question.) Gross margin percentage Current ratio (use the Excel ROUND function rounded to two decimal places) Acid-test ratio (use the Excel ROUND function rounded to two decimal places) Accounts receivable turnover (use the Excel ROUND function rounded to two decimal places) Days' sales uncollected (use the Excel ROUNDUP function rounded to the nearest whole day) Inventory tumover ratio (use the Excel ROUND function rounded to two decimal places) Days' sales in inventory (use the Excel ROUNDUP function rounded to the nearest whole day) Debt-to-equity ratio (use the Excel ROUND function rounded to two decimal places) Times interest earned (use the Excel ROUND function rounded to two decimal places) Book value per share (use the Excel ROUND function rounded to two decimal places) Earnings per share (use the Excel ROUND function rounded to two decimal places) Dividend payout ratio (use the Excel ROUND function rounded to three decimal places) Dividend yield ratio (use the Excel ROUND function rounded to three decimal places) Price-earnings ratio (use the Excel ROUND function rounded to two decimal places) 75