X cut 11 - General AA == A 2 Wrap Test Merge & Center WE ormat Painter Clipboard $ % -98 Conditional Formatas Cell Formatting Table Styles Insert Delete format 199 D E G H B C LAKE OF EGYPT MARINA, INC Balance Sheet as of December 31, 2018 and 2017 in millions of dollars) 2017 Current assets: Cash and marketable securities 2018 liabilities and Equity Current liabilities: Accrued's Accounts payable Notes payable 100 $ 8 ACCO 104 424 9 Inventory 10 11 Total 12 Fixed assets 13 Gross plant and equipment 14 Less: Depreciation 120 Long term debt: 435 Stockholders' equity Preferres 8S Common stock and 72 surplus (72 million shares) Retained earnings 275 72 1 3455 17! Net plant and equipment 18 Other long-term assets 20 Total Total $ 355 S 22 Total assets S 1,000 $ Total abils 1,000 $ LAKE OF EGYPT MARINA, INC. Income Statement for Years Ending December 31, 2018 and 2017 Sheet1 Select destination and press ENTER or choose Paste Type here to search $ o Search AutoSave of File Home Insert X Cut View Help 8 Book1 - Excel Draw Page Layout Formulas Data Review Calibri 11 AA == BIU-B OA ESSE General L m Copy 23 Wrap Text Merge & Center Paste $ % Format Painter Number Alignment Clipboard fx LAKE OF EGYPT MARINA, INC. Income Statement for Years Ending December 31, 2018 and 2017 in millions of dollars) 30 Net sales(all credit) 31 Less: Cost of goods sold 33 Gross profits 34 Less: Other operating expenses | 188 189 1 36 Earnings before interest, taxes, depreciation, and Jamortization (EBITDA) 38 Less: Depreciation 40 Earnings before interest and taxes (EBIT) 41 Less: Interest 43 Farnings before taxes (EBT) 44 Less: Taxes 46 Net income 48 Les Preferred stock dividends S 50 Net income available to common stockholders 51 Less: Common stock dividends 53 Addition to retained earnings 54 Per common) share data: 55 Earnings per share (EPS) 56 Dividends per share (OPS) 57 Book value per share (BVPS) 50 Market value (price) per share (MVPS) Sheet1 Select destination and press ENTER or choose Paste Type here to search Orte 39 MNO VE days a year) 61 Calculate the following ratios for Lake of E t Marina, in as of year end 2018 2 (Use sales when computing the inventory turnover and uncommon stockholders equity when computing the equity multiplier Round your answers to decimal places. Use Lake of egypt marina, INC 64 Currenet ratio 65 Quick ratio 66 Cash ratio 67 inventory turnover 68 Day's sales in inventory 69 Average collection period TO Average payment period 71 Fixed asset turnover 72 Sales to working capital 73 Total asset turnover 74 Captial intensity 75 Debt raito 76 Debt-to-equity 77 Equity multiplier 79 Cash cover 61 GTOSS profit margin ne power BERETE Market-to-book ratio