Problem 3-30 Calculating Ratios (LG3-1, LG3-2, LG3-3, LG3-4, LG3-5) 2018 2017 $40 Use the following financial statements for Lake of Egypt Marina, Inc. LAKH OF CYPT MARTHA, INC. Balance sheet as of December 31, 2017 and 2017 in millions of dollars) 2018 2017 Assets Liabilities and Equity current annet Current liabilities Cash and marketable securities 5.50 Accrued wage and take Accounts receivable 60 52 Accounts payable Inventory 205 Notes payable Total 5204 Total Fixed assets Long-term debt Cross plant and not 5250 stockholders' equity LOS Depreciation 60 Preferred to 14 million shares) Common stock and paid-in surplus Net plant and equipment 5160 5172 (24 million shares) Other long-term aseta 25 24 Hetained earning Total S185 $190 Total $500 5400 Total assets Total liabilities and equity 50 55 60 $165 $42 40 12 5136 24 265 24 104 3500 5400 2017 400 120 280 5 256 24 232 32 200 $ LAKE OF YOYPT HARTA, INC. Income statement for Years Ending December 31, 2018 and 2017 tin millons of dollars) 2010 Net sales (all credit) $ 600 Le cost of goods sold 216 Gross protita 5 Les Other operating expenses Warninge before interest, taxes, depreciation, and Amortization (EBITDA) 348 Last Depreciation 30 Tarning before interest and taxes ( ET) 31 Lost interest 48 Earnings before taxes (ET) $ 270 Lost Taxes Net Income 189 Los Preferred stock dividends 4 Net income available to common stockholders Lot Common stock dividende 24 Addition to retained earnings 5 161 per (common) share data Earnings per share (EPS) 5.7.708 Dividends per share (DPS) $ 1.000 Book value per share (BTS) $12.042 Market value (price) per share (MPS) $15.550 5 140 4 24 112 $5.667 $ 1.000 55.333 513.350 Calculate the following ratios for Lake of Egypt Marina, Inc, as of year-end 2018. (Use sales when computing the inventory turnover and use total equity when computing the equity multiplier, Round your answers to 2 decimal places. Use 365 days a year.) a. b. C. d. e. f. h. i. j. k. LAKE OF EGYPT MARINA, INC. Current ratio 1.91 times Quick ratio 0.67 times Cash ratio 0.30 times Inventory turnover 2.93 times Days' sales in inventory 124.71 days Average collection period 36.50 days Average payment period 33.46 X days Fixed asset turnover 3.75 times Sales to working capital 2.85 X times Total asset turnover 1.20 times Capital intensity 0.83 times Debt ratio 41.40 % Debt-to-equity 70.64 times Equity multiplier 1.70 times Times interest earned 6.62 times Cash coverage times Profit margin % Gross profit margin % Operating profit margin % Basic earnings power % ROA % ROE % Dividend payout % Market-to-book ratio times PE ratio times 000 1. m. n. >> 0. p. 9. r. S. t. u. V. w. y