Required: Compute the following ratios for the current year only. Note: 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' salles 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' salles 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 payout ratio (Use the Excel ROUND function to display one decimal place) Dividend yield ratio (Use the Excel ROUND function to display one decimal place) Price-earnings ratio (use the Excel ROUND function rounded to two decimal places) 40% 1.44 0.74 6.75 57 3.57 102 1.05 7.43 $39.74 $4.36 Recent financial statements for Zimmer, Incorporated are as follows: Zimmer, Incorporated Comparative Balance Sheet This Year Last Year Zimmer, Incorporated Income Statement This Year $4,980,000 2,988,000 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 $250,000 750,000 $225,000 550,000 275,000 395,000 1,825,000 575,000 2,400,000 400,000 1,843,400 1,150,000 1,150,000 Retained earnings Total stockholders' equity 1,135,000 2,285,000 941,600 80,000 $360,000 $310,000 220,000 775,000 700,000 925,000 750,000 355,000 2,635,000 2,035,000 1,975,000 1,800,000 75,000 $4,685,000 100,000 $3,935,000 195,000 600,000 223,400 1,443,400 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 Net operating income 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 Required: Compute the following ratios for the current year only: Total liabilities and stockholders' equity $4,685,000 2,091,600 $3,935,000 1,992,000 985,500 410,500 150,000 1,546,000 446,000 60,000 386,000 135,100 $250,900 $1.00 $42.00 $20.00 57,500