Saved 1. Compute and interpret financial ratios that managers use to assess liquidity 2. Compute and interpret financial ratios that managers use for asset management purposes 3. Compute and interpret financial ratios that managers use for debt management purposes ? 1 B5- Selected Financial Ratios - Excel FILE INSERT FORMULAS VIEW PAGE LAYOUT Sign in HOME DATA REVIEW M Calib - 10 Editing Date BIU 73 Saved FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In w F 60.000 386,000 13500 S250.00 X Calib -10 % M Paste Cells BIU Alignment Number Conditional Formatas Cell Editing Formatting Table Styles Clipboard Font Styles A1 X be Recent financial statements for Zimmer, Inc. are as follows: E 16 Liabilities and Stockholders' Equity Interest expense 17 Current Labilities: Net Income before taxes 18 Accounts payable $ 250,000 $ 225,000 Income taxes 19 Short-term bank loans 750,000 600,000 Net Income 20 Accrued payables 550.000 395.000 21 Other current liabilities 225.000 223,400 Additional information: 22 Total current liabilities 1 825,000 1,443,000 Dividend per'share paid in current year 23 Bonds payable, 10% 575009 400.000 Market price of shares at year end 24 Totallabies 2.400.000 14400 Par value of common stock per share 25 Stockholders equity 26 Common stock 1.150,000 1.150.000 Number of shares outstanding 27 Retained earnings 125.000 981 600 28 Total stockholders' equity 2285.000 2091.600 29 Total Babies and stockholders' equity 455.000 1.000 30 21 Required 32 Compute the following rates for the current year only 33 Gros margin percentage 4ON 34 Catenacito (rounded to two decimal places) 35 Acid-test ratio (rounded to two decimal places) 07 36 Accounts receivable turnover rounded to two decimal places 6.75 $ 1.00 42.00 20.00 Sign In FORMULAS DATA REVIEW VIEW PAGE LAYOUT FILE INSERT HOME Calib 10 Paste BTU A A 96 M Alignment Number Conditional Formatas Cell Cells Editing Formatting Table Styles Styles Recent financial statements for Zimmer, Ind are as follows: Clipboard Font A1 E A 29 Total abilities and stockholders' equity AAS S2006200 30 31 Required: 32 Compute the following ratios for the current year only: 33 Gross margin percentage 40% 34 Current ratio (rounded to two decimal places) 35 Acid-test ratio (rounded to two decimal places) 0.74 36 Accounts receivable turnover (rounded to two decimal places) 6.75 37 Average collection period (rounded to the nearest whole day 38 Inventory turnover ratio (rounded to two decimal places) 39 Average sales period (rounded to the nearest whole day) 40 Debt-to-equity ratio (rounded to two decimal places) 41 Times interest earned frounded to two decimal places) 42 Book value per share rounded to two decimal places) 43 Camnings per share rounded to two decimal places) 44 Dividend payout ratio (rounded to three decimal places) 45 Dividend yield rutto (rounded to three decimal places) 46 Preemingsrutto (rounded to two decimal places) 47 49 50