Assets Current assets: Cash This Year $360,000 Last Year $310,000 Marketable securities 220,000 80,000 Accounts receivable, net Inventory Other current assets Total current assets 775,000 700,000 925,000 750,000 355,000 195,000 2,635,000 2,035,000 Plant and eqipment, net 1,975,000 1,800,000 Other assets 75,000 Total assets $4,685,000 100,000 $3,935,000 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 Sales (all on acount) Cost of goods sold Gross margin Selling and administrative expenses Operating expenses Zimmer, Inc. Income Statement $250,000 $225,000 750,000 600,000 550,000 395,000 275,000 223,400 1,825,000 1,443,400 575,000 400,000 2,400,000 1,843,400 1,150,000 1,150,000 1,135,000 941,600 2,285,000 2,091,600 $4,685,000 $3,935,000 This Year $4,980,000 2,988,000 1,992,000 985.500 Depreciation and amortization 410,500 General and administrative expenses 150,000 Total selling and administrative expenses 1,546,000 Earnings before interest and taxes 446,000 Interest expense Income taxes Net income 60,000 Net income before taxes 386,000 135,100 $250,900 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: (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) $1.00 $42.00 $20.00 0 794% GU