Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, if you could please answer the empty blank spaces, please. Thank you so much for the help and if you need a better picture
Hi, if you could please answer the empty blank spaces, please. Thank you so much for the help and if you need a better picture or any questions let me know. Thank you!
2018 2017 $ 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 $ 120 $ 84 Accrued wages and taxes Accounts receivable 110 98 Accounts payable Inventory 306 196 Notes payable Total $ 536 $378 Total Fixed assets: Long-term debt: Gross plant and equipment $ 520 $350 Stockholders' equity: Less: Depreciation 106 70 Preferred stock (7 million shares) Common stock and paid-in surplus Net plant and equipment $ 414 $280 (42 million shares) Other long-term assets 50 42 Retained earnings Total $ 464 $322 Total Total assets $1,800 $700 Total liabilities and equity 60 79 80 210 356 $ 63 56 49 $168 $301 $ $ $ 7 $ 7 42 385 $ 434 $1,000 42 182 $231 $700 $ 2017 800 320 480 64 $ $ LAKE OF EGYPT MARINA, INC. Income Statement for Years Ending December 31, 2018 and 2017 (in millions of dollars) 2018 Net sales (all credit) $ 900 Less: Cost of goods sold 414 Gross profits $ 486 Less: Other operating expenses 54 Earnings before interest, taxes, depreciation, and amortization (EBITDA) 432 Less: Depreciation 36 Earnings before interest and taxes (EBIT) $ 396 Less: Interest 36 Earnings before taxes (EBT) $ 360 Less: Taxes 108 Net income $ 252 Less: Preferred stock dividends $ 7 Net income available to common stockholders $ 245 Less: Common stock dividends 42 Addition to retained earnings $ 283 Per (common) share data: Earnings per share (EPS) $ 5.833 Dividends per share (DPS) $ 1.000 Book value per share (BVPS) $10.167 Market value (price) per share (MPS) $15.480 416 48 368 48 320 96 $ 224 $ $ $ $ 7 217 42 175 $ $ 5.167 $ 1.000 $ 5.333 $13.200 Calculate the following ratios for Lake of Egypt Marina, Inc. as of year-end 2018. (Use sales when computing the Inventory turno and use total equity when computing the equity multiplier. Round your answers to 2 decimal places. Use 365 days a year.) LAKE OF EGYPT MARINA, INC. a. Current ratio Quick ratio times b. times $ $ $ 396 36 360 108 368 48 320 96 $ $ 252 224 Earnings before interest and taxes (EBIT) Less: Interest Earnings before taxes (EBT) Less: Taxes Net income Less: Preferred stock dividends Net income available to common stockholders Less: Common stock dividends Addition to retained earnings Per (common) share data: Earnings per share (EPS) Dividends per share (DPS) Book value per share (BVPS) Market value (price) per share (MVPS) $ $ $ $ 7 245 42 203 7 217 42 175 $ $ $ 5.833 $ 1.000 $10.167 $15.400 $ 5.167 $ 1.000 $ 5.333 $13.200 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 C times times times days days days times times times LAKE OF EGYPT MARINA, INC. a. Current ratio b. Quick ratio Cash ratio d. Inventory turnover e Days' sales in inventory f. Average collection period 9. Average payment period h. Fixed asset turnover i Sales to working capital j Total asset tumover k Capital intensity L Debt ratio m. Debt-to-equity n. Equity multiplier Times interest earned p. Cash coverage 9. Profit margin Gross profit margin Operating profit margin t. Basic earnings power u. ROA ROE W. Dividend payout Market-to-book ratio times % times times o times times % r. % S % % % V. % % X times y. PE ratio timesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started