Zimmer, Inc. has provided its recent financial statements. The Controller has asked you to use this information to compute and interpret financial ratios that managers are going to use to assess liquidity and use for asset and debt management purposes. For an answer to be graded as correct, you must use an Excel Formula, Example: =BC+C3

Recent financial statements for Zimmer, Inc. are as follows: Zimmer, Inc. Comparative Balance Sheet Assets Current assets: Cash Marketable securities Accounts receivable, net Inventory Other current assets Total current assets Plant and eqipment, net Other assets Total assets 'Liabilities and Stockholders' Equity Current Liabilities: Accounts payable Short-term bank loans Accrued payables Other current liabilities Total current liabilities Bonds payable, 10% Total liabilities Stockholders' equity: Common stock Retained earnings Total stockholders' equity 'Total liabilities and stockholders' equity ! tements for Zimmer, Inc. are as follows: Comparative Balance Sheet This Year Last Year \begin{tabular}{|r|r|} \hline$360,000 & $310,000 \\ \hline 220,000 & 80,000 \\ \hline 775,000 & 700,000 \\ \hline 925,000 & 750,000 \\ \hline 355,000 & 195,000 \\ \hline 2,635,000 & 2,035,000 \\ \hline 1,975,000 & 1,800,000 \\ \hline 75,000 & 100,000 \\ \hline$4,685,000 & $3,935,000 \\ \hline \hline \end{tabular} A B Zimmer, Inc. Income Statement Sales (all on acount) Cost of goods sold Gross margin Selling and administrative expenses Operating expenses Depreciation and amortization General and administrative expenses Total selling and administrative expenses Earnings before interest and taxes Interest expense Net income before taxes Income taxes Net income Additional information: Dividend per share paid in current year Market price of shares at year end Par value of common stock per share Number of shares outstanding A This Year $4,980,000 2,988,0001,992,000 985,500 410,500 1,546,000 446,00060,000386,000 \begin{tabular}{r} 386,000 \\ 135,100 \\ \hline$250,900 \\ \hline \end{tabular} $250,900 Market price of shares at year end Par value of common stock per share Number of shares outstanding Required: Compute the following ratios for the current year only: (Use cells B8 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 ROUND function rounded to the nearest whole day) Inventory turnover ratio (use the Excel ROUND function rounded to two decimal places) Days' sales in inventory (use the Excel ROUND 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 yield ratio (use the Excel ROUND function rounded to one decimal place) Price-earnings ratio (use the Excel ROUND function rounded to two decimal places)