Excel SIM: Selected Financial Ratios

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.

All answers must be entered as a formula. Click OK to begin. Simulation i Simulation i READY Attempt(s) All answers must be entered as a formula. Click OK to begin. Excel Simulation (i) Simulation 1 Saved Simulation i \begin{tabular}{lll} Al & v & fx \\ \hline & Recent financial statements for Zimmer, Inc. are as follows: \end{tabular} 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 (rounded 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 yield ratio (rounded to three decimal places) 46 Price-eamings ratio (rounded to two decimal places)