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.
Please fill in the yellow spaces and show your calculations.
Selected Financial Ratios Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA A REVIEW VIEW Calibri Paste B I U A Alignment Number Conditional Format as Cell Cells Editing Formatting. Table Styles Clipboard Font | | Recent financial statements for Zimmer, Inc. are as follows: 1 Recent financial statements for Zim mer, Inc. are as follows Zimmer Com Zimmer Com Comparative Balance Sheet Income Statement This Year Last Year This Year 5 Assets Curre nt assets 7 Cash 360,000 310,000 Sales (all on account 220,000 775,000 925,000 $4,980,000 80,000 Cost of goods sold 700,000 Gross margin 50,000 Selling and administrative expenses Marketable securities Accounts receivable, net 10 Inventory 11 Other current assets 12 Total current assets 13 Plant and equipment, net 14 Other assets 15 Total assets 16 Liabilities and Stockholders' Equity 17 Current Liabilities: 18 Accounts payable 19 Short-term bank loans 20 Accrued payables 21 Other current liabilities 22 Total current liabilities 23 Bonds payable 10% 24 Total liabilities 25 Stockholders' equity 26 Common stock 27 Retained e amings 28 Total stockholders' equity 29 Total liabilities andockholders' equity S- 4685 000 , a935000 30 31 Required 2 Compute the following ratios for the curre nt year only 33 Gross margin percentage 54 Curre nt ratio (rounded to two decimal places 35 Acid-test ratio (roundedto two decimal places 36 Accounts receivable turnover (rounded to two decimal places 37 Average colle ction period (rounded to the nearest whole day) 38 Inve ntory turnover ratio (rounded to two decimal place s) 39 Average sales period (rounded to the ne are st whole 40 Debt-to-equity ratio (rounded to two de cimal places) 41 Times intere st earned (roundedtotwo decimal places) 42 Book value per share (rounded to two decimalplaces) 43 Earnings per share (rounde d to two decimal places) 44 Dividend payout ratio (rounded to three decimal places) 45 Dividend yie ld ratio (rounded to three decimal places 46 Price-earnings ratio (rounded to two decimal places) 985,500 Operating expenses Depreciation and amortization General and administrative expenses 2,635,000 2,035,000 410,500 1,975,000 1,800,000 Total se lling and adm inist rative expenses $ 3935.00Net ope rating income 446,000 Interest expense Net income before taxes 386,000 250,000 225,000 Income taxes 750,000 550,000 600,000 Net income 395,000 Additional information: 1,825,000 443,400 Dividend per share paid in current year Market price of shares at year end Par value of common stock per share 42.00 20.00 1,150,000 1,150,000 Number of share outstanding Sheetl ... t
