2018 2017 Problem 3-30 Calculating Ratios (LG3-1, LG3-2, LG3-3, LG3-4, LG3-5) Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC. Balance Sheet as of December 31, 2018 and 2017 (in millions of dollars) 2018 2017 Assets Liabilities and Equity Current assets Current liabilities Cash and marketable securities $.50 $ 56 Accrued wages and taxes Accounts receivable 60 52 Accounts payable Inventory 96 Notes payable Total $315 $204 Total Fixed assets Long-term debt: Gross plant and equipment $250 5232 Stockholders' equity. Less: Depreciation 90 60 Preferred stock (4 million shares) Common stock and paid-in surplus Net plant and equipment $160 $172 (24 million shares) Other long-term assets 25 24 Retained earnings Total $185 $196 Total Total Asseto $500 $400 Total liabilities and equity 205 $50 55 60 $165 $ 42 $ 48 44 40 $132 $136 $4 $ 4 24 265 $293 $500 24 104 $132 $400 $ 2017 400 120 280 24 $ 30 $ LAKE OF EGYPT MARINA, INC. Income Statement for Years Ending December 31, 2018 and 2017 (in millions of dollars) 2018 Net sales (all credit) $ 600 Less: Cost of goods sold 216 Gross profits $ 384 Less: Other operating expenses 36 Earnings before interest, taxes, depreciation, and amortization (EBITDA) 348 Less: Depreciation Earnings before interest and taxes (EBIT) $ 318 Less! Interest 48 Earnings before taxes (ET) $ 270 Less: Taxes 81 Net income $ 189 Less: Preferred stock dividends $ 4 Net income available to common stockholders $ 185 Less: Common stock dividends 24 Addition to retained earnings $ 161 Per common) share data: Earnings per share (EPS) $ 7.708 Dividends per share (DPS) $ 1.000 Book value per share (BVPS) $12.042 Market value (price) per share (MVPS) $15.550 256 24 232 32 200 60 140 S $ $ 136 S 112 $5.667 $ 1.000 $5.333 $13.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.) times times times times days days days times times times times % LAKE OF EGYPT MARINA, INC. a. Current ratio b. Quick ratio Cash ratio d. Inventory turnover e Days' sales in inventory Average collection period 9. Average payment period h. Fixed asset turnover Sales to working capital Total asset turnover k Capital Intensity 1 Debt ratio m. Debt-to-equity n. Equity multiplier Times interest comed . Chi tivi 9. Profit margin Gross profit margin Operating profit margin 1 Basi oaming power ROA ROE w Dividend payout Markoto-book ratio y PE to times times times 0 times % % % % % % % times times