Use the following financial statements for Lake of Egypt Marina, Incorporated LAKE OF EGYPT MARINA, INCORPORATED...

Transcribed Image Text:

Use the following financial statements for Lake of Egypt Marina, Incorporated LAKE OF EGYPT MARINA, INCORPORATED Balance Sheet as of December 31, 2024 and 2023 2024 (in millions of dollars) 2023 Assets Current assets: Liabilities and Equity Current liabilities: Cash and marketable securities Accounts receivable $ 63 $ 30 Accrued wages and taxes Inventory 32 175 39 60 Accounts payable Notes payable Total $ 270 $ 129 Total Fixed assets: Long-term debt: Gross plant and equipment $ 208 $ 189 Stockholders' equity: Less: Depreciation 75 36 Net plant and equipment $ 133 $ 153 Other long-term assets Total 20 18 $ 153 $ 171 Total Total assets $ 423 Preferred stock (3 million shares) Common stock and paid-in surplus (24 million shares) Retained earnings $ 300 Total liabilities and equity LAKE OF EGYPT MARINA, INCORPORATED Income Statement for Years Ending December 31, 2024 and 2023 (in millions of dollars) LAKE OF EGYPT MARINA, INCORPORATED 2024 2023 a. Current ratio 2.60 times b. Quick ratio 0.91 times $ 32 $ 24 c. Cash ratio 0.61 times 40 27 32 30 d. Inventory turnover 3.71 times $ 104 $ 81 $ 36 $ 114 e. Days' sales in inventory days $ 3 $ 3 f. Average collection period 17.97 days 24 256 24 78 g. Average payment period days $ 283 $ 105 h. Fixed asset turnover 4.25 times $ 423 $ 300 i. Sales to working capital 3.92 times j. Total asset turnover 1.54 times k. Capital intensity I. Debt ratio m. Debt-to-equity 0.65 times 33.10% Net sales (all credit) Less: Cost of goods sold Gross profits 2024 $ 650 260 2023 $ 500 190 0.49 times Less: Other operating expenses Earnings before interest, taxes, depreciation, and amortization (EBITDA) Less: Depreciation 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) Calculate the following ratios for Lake of Egypt Marina, Incorporated, as of year-end 2024. $ 390 52 $ 310 35 n. Equity multiplier 1.49 times 338 275 o. Times interest earned 7.67 times 39 30 $ 299 $ 245 p. Cash coverage 8.67 times 39 35 $ 260 $ 210 q. Profit margin % 55 63 $ 205 $ 147 r. Gross profit margin $ 3 $ 3 $ 202 $ 144 24 24 t. Basic earnings power s. Operating profit margin 60.00 % 46.00% 70.69 % $ 178 $ 120 u. ROA $ 8.417 $ 6.000 v. ROE % % $ 1.000 $ 1.000 $ 11.667 $ 4.250 w. Dividend payout 11.88 % $ 15.200 $ 13.000 x. Market-to-book ratio 1.30 times y. PE ratio 1.81 times Note: Use sales when computing the Inventory turnover and use total stockholders' equity when computing the equity multiplier. Use the following financial statements for Lake of Egypt Marina, Incorporated LAKE OF EGYPT MARINA, INCORPORATED Balance Sheet as of December 31, 2024 and 2023 2024 (in millions of dollars) 2023 Assets Current assets: Liabilities and Equity Current liabilities: Cash and marketable securities Accounts receivable $ 63 $ 30 Accrued wages and taxes Inventory 32 175 39 60 Accounts payable Notes payable Total $ 270 $ 129 Total Fixed assets: Long-term debt: Gross plant and equipment $ 208 $ 189 Stockholders' equity: Less: Depreciation 75 36 Net plant and equipment $ 133 $ 153 Other long-term assets Total 20 18 $ 153 $ 171 Total Total assets $ 423 Preferred stock (3 million shares) Common stock and paid-in surplus (24 million shares) Retained earnings $ 300 Total liabilities and equity LAKE OF EGYPT MARINA, INCORPORATED Income Statement for Years Ending December 31, 2024 and 2023 (in millions of dollars) LAKE OF EGYPT MARINA, INCORPORATED 2024 2023 a. Current ratio 2.60 times b. Quick ratio 0.91 times $ 32 $ 24 c. Cash ratio 0.61 times 40 27 32 30 d. Inventory turnover 3.71 times $ 104 $ 81 $ 36 $ 114 e. Days' sales in inventory days $ 3 $ 3 f. Average collection period 17.97 days 24 256 24 78 g. Average payment period days $ 283 $ 105 h. Fixed asset turnover 4.25 times $ 423 $ 300 i. Sales to working capital 3.92 times j. Total asset turnover 1.54 times k. Capital intensity I. Debt ratio m. Debt-to-equity 0.65 times 33.10% Net sales (all credit) Less: Cost of goods sold Gross profits 2024 $ 650 260 2023 $ 500 190 0.49 times Less: Other operating expenses Earnings before interest, taxes, depreciation, and amortization (EBITDA) Less: Depreciation 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) Calculate the following ratios for Lake of Egypt Marina, Incorporated, as of year-end 2024. $ 390 52 $ 310 35 n. Equity multiplier 1.49 times 338 275 o. Times interest earned 7.67 times 39 30 $ 299 $ 245 p. Cash coverage 8.67 times 39 35 $ 260 $ 210 q. Profit margin % 55 63 $ 205 $ 147 r. Gross profit margin $ 3 $ 3 $ 202 $ 144 24 24 t. Basic earnings power s. Operating profit margin 60.00 % 46.00% 70.69 % $ 178 $ 120 u. ROA $ 8.417 $ 6.000 v. ROE % % $ 1.000 $ 1.000 $ 11.667 $ 4.250 w. Dividend payout 11.88 % $ 15.200 $ 13.000 x. Market-to-book ratio 1.30 times y. PE ratio 1.81 times Note: Use sales when computing the Inventory turnover and use total stockholders' equity when computing the equity multiplier.