Excel Formulas

You skipped this question in B C 27 Retained earnings 1135.000 541.000 28 Total stockholders' equity 225.000 29 total bibilities and stockholders' equity S WASSA 30 31 Required: 32 Compute the following ratios for the current year only: 33 Grass margin percentage 40 34 Current ratio (rounded to two decimal places) 1.40 Acid-test ratio (rounded to two decimal places) 30. 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 amnings per share rounded to two decimal places) 44 Dividend payout ratio (rounded to the decimal places 45 Dividend yield catto (rounded to three decimal places 46 Price camins ratio (rounded to two decimal places) 47 49 Sheet READY Attempts) 2/3