Calculate the following ratios for Lake of Egypt Marina, Inc., as of year-end 2021. (Use sales...

Transcribed Image Text:

Calculate the following ratios for Lake of Egypt Marina, Inc., as of year-end 2021. (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.) LAKE OF EGYPT MARINA, INC. Industry a. Current ratio times b. Quick ratio times C. Cash ratio times d. Inventory turnover times e. Days' sales in inventory days f. Average collection period days g. Average payment period days h. Fixed asset turnover times i. Sales to working capital times j. Total asset turnover times k. Capital intensity times I. Debt ratio % m. Debt-to-equity times n. Equity multiplier times 0. Times interest earned times p. Cash coverage times q. Profit margin % r. Gross profit margin % S. Operating profit margin % t. Basic earnings power % u. ROA % V. ROE % W. Dividend payout % x. Market-to-book ratio times y. PE ratio times Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC. Balance Sheet as of December 31, 2021 and 2020 (in millions of dollars) LAKE OF EGYPT MARINA, INC. a Current ratio times 2021 2020 2021 2020 b. Quick ratio times Assets Current assets: Liabilities and Equity Current liabilities: c. Cash ratio times Cash and marketable securities Accounts receivable $ 75 $ 65 Accrued wages and taxes $ 40 $ 43 d. Inventory turnover times 115 110 Accounts payable 90 80 Inventory 200 190 Notes payable 80 70 e. Days' sales in inventory days Total $390 $365 Total $210 $193 Fixed assets: Long-term debt: $300 f. Average collection period days $280 Gross plant and equipment $580 $471 Less: Depreciation 110 Net plant and equipment $470 100 $371 Other long-term assets 50 49 Total $520 $420 Total assets $910 $785 Stockholders' equity: Preferred stock (5 million shares) Common stock and paid-in surplus (65 million shares) Retained earnings Total Total liabilities and equity g. Average payment period days $ 5 $ 5 h. Fixed asset turnover times 65 65 i. Sales to working capital times 330 242 Total asset turnover times $400 $312 $910 $785 k. Capital intensity times L Debt ratio % m. Debt-to-equity times LAKE OF EGYPT MARINA, INC. Less: Taxes Income Statement for Years Ending December 31, 2021 and 2020 (in millions of dollars) 2021 2020 Net sales (all credit) $ 515 $ 432 Less: Cost of goods sold 230 175 Gross profits $ 285 $ 257 Less: Other operating expenses 30 25 Earnings before interest, taxes, depreciation, and amortization (EBITDA) $ 255 $ 232 Less: Depreciation 22 20 t Basic earnings power Earnings before interest and taxes (EBIT) $ 233 $ 212 Less: Interest 33 30 U. ROA Earnings before taxes (EBT) $ 200 $ 182 V. ROE 42 55 Net income $ 158 $ 127 Less: Preferred stock dividends $ 5 $ 5 x. Net income available to common stockholders $ 153 $ 122 y. PE ratio Less: Common stock dividends 65 65 Addition to retained earnings $ 88 $ 57 Per (common) share data: Earnings per share (EPS). $ 2.354 $ 1.877 Dividends per share (DPS) $ 1.000 $ 1.000 Book value per share (BVPS) Market value (price) per share (MVPS). $ 6.077 $ 4.723 $14.750 $12.550 n. Equity multiplier times 0. Times interest earned p. Cash coverage q Profit margin times times % r Gross profit margin s. Operating profit margin % % % % % w. Dividend payout Market-to-book ratio % times times Calculate the following ratios for Lake of Egypt Marina, Inc., as of year-end 2021. (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.) LAKE OF EGYPT MARINA, INC. Industry a. Current ratio times b. Quick ratio times C. Cash ratio times d. Inventory turnover times e. Days' sales in inventory days f. Average collection period days g. Average payment period days h. Fixed asset turnover times i. Sales to working capital times j. Total asset turnover times k. Capital intensity times I. Debt ratio % m. Debt-to-equity times n. Equity multiplier times 0. Times interest earned times p. Cash coverage times q. Profit margin % r. Gross profit margin % S. Operating profit margin % t. Basic earnings power % u. ROA % V. ROE % W. Dividend payout % x. Market-to-book ratio times y. PE ratio times Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC. Balance Sheet as of December 31, 2021 and 2020 (in millions of dollars) LAKE OF EGYPT MARINA, INC. a Current ratio times 2021 2020 2021 2020 b. Quick ratio times Assets Current assets: Liabilities and Equity Current liabilities: c. Cash ratio times Cash and marketable securities Accounts receivable $ 75 $ 65 Accrued wages and taxes $ 40 $ 43 d. Inventory turnover times 115 110 Accounts payable 90 80 Inventory 200 190 Notes payable 80 70 e. Days' sales in inventory days Total $390 $365 Total $210 $193 Fixed assets: Long-term debt: $300 f. Average collection period days $280 Gross plant and equipment $580 $471 Less: Depreciation 110 Net plant and equipment $470 100 $371 Other long-term assets 50 49 Total $520 $420 Total assets $910 $785 Stockholders' equity: Preferred stock (5 million shares) Common stock and paid-in surplus (65 million shares) Retained earnings Total Total liabilities and equity g. Average payment period days $ 5 $ 5 h. Fixed asset turnover times 65 65 i. Sales to working capital times 330 242 Total asset turnover times $400 $312 $910 $785 k. Capital intensity times L Debt ratio % m. Debt-to-equity times LAKE OF EGYPT MARINA, INC. Less: Taxes Income Statement for Years Ending December 31, 2021 and 2020 (in millions of dollars) 2021 2020 Net sales (all credit) $ 515 $ 432 Less: Cost of goods sold 230 175 Gross profits $ 285 $ 257 Less: Other operating expenses 30 25 Earnings before interest, taxes, depreciation, and amortization (EBITDA) $ 255 $ 232 Less: Depreciation 22 20 t Basic earnings power Earnings before interest and taxes (EBIT) $ 233 $ 212 Less: Interest 33 30 U. ROA Earnings before taxes (EBT) $ 200 $ 182 V. ROE 42 55 Net income $ 158 $ 127 Less: Preferred stock dividends $ 5 $ 5 x. Net income available to common stockholders $ 153 $ 122 y. PE ratio Less: Common stock dividends 65 65 Addition to retained earnings $ 88 $ 57 Per (common) share data: Earnings per share (EPS). $ 2.354 $ 1.877 Dividends per share (DPS) $ 1.000 $ 1.000 Book value per share (BVPS) Market value (price) per share (MVPS). $ 6.077 $ 4.723 $14.750 $12.550 n. Equity multiplier times 0. Times interest earned p. Cash coverage q Profit margin times times % r Gross profit margin s. Operating profit margin % % % % % w. Dividend payout Market-to-book ratio % times times