1 Compute and interpret financial ratios that managers use to assess liquidity 2. Compute and interpret financial ratlos that managers use for asset management purposes 3. Compute and interpret financial ratios that managers use for debt management purposes Selected Financial Ratios - Excel ? D FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in X 1 Calibri 10 Paste BIU- RE - A A 96 M Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles Recent financial statements for Zimmer, Inc. are as follows: Opboard Font A1 A C 1 25 Stockholders' equity 26 Common stock 27 Betained earnings 28 Total stockholders' equity 29 Total liabilities and stockholders equity 30 31 Required: 32 the 1,150,000 1,150,000 Number of shares outstanding 1.195.000 941.600 2,285.000 2.091.500 1685.000 1.935.000 Number of shares outstanding 25 Stockholders' equity 26 Common stock 1,150,000 1,150,000 27 Retained earnings 1,135 000 941,600 28 Total stockholders' equity 2.285 000 2,091,600 29 Total abilities and stockholders equity S 4.685.000 S 31.935.000 30 31 Required: 32 Compute the following ratios for the current year only 33 Gross margin percentage 34 Current ratio (rounded to two decimal places) 35 Acid-test ratio (rounded to two decimal places) 36 Accounts receivable turnover (rounded to two decimal places) 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 Earnings per share (rounded to two decimal places) 44 Dividend payout ratio (rounded to three decimal places) 45 Dividend Vield ratio (rounded to three decimal places) 45 Price-carnings ratio frounded to two decimal places) 47 Chaos 1 Compute and interpret financial ratios that managers use to assess liquidity 2. Compute and interpret financial ratlos that managers use for asset management purposes 3. Compute and interpret financial ratios that managers use for debt management purposes Selected Financial Ratios - Excel ? D FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in X 1 Calibri 10 Paste BIU- RE - A A 96 M Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles Recent financial statements for Zimmer, Inc. are as follows: Opboard Font A1 A C 1 25 Stockholders' equity 26 Common stock 27 Betained earnings 28 Total stockholders' equity 29 Total liabilities and stockholders equity 30 31 Required: 32 the 1,150,000 1,150,000 Number of shares outstanding 1.195.000 941.600 2,285.000 2.091.500 1685.000 1.935.000 Number of shares outstanding 25 Stockholders' equity 26 Common stock 1,150,000 1,150,000 27 Retained earnings 1,135 000 941,600 28 Total stockholders' equity 2.285 000 2,091,600 29 Total abilities and stockholders equity S 4.685.000 S 31.935.000 30 31 Required: 32 Compute the following ratios for the current year only 33 Gross margin percentage 34 Current ratio (rounded to two decimal places) 35 Acid-test ratio (rounded to two decimal places) 36 Accounts receivable turnover (rounded to two decimal places) 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 Earnings per share (rounded to two decimal places) 44 Dividend payout ratio (rounded to three decimal places) 45 Dividend Vield ratio (rounded to three decimal places) 45 Price-carnings ratio frounded to two decimal places) 47 Chaos