Problem 3-28 Spreadsheet Problem: Calculating Ratios (LG3-1, LG3-2, LG3-3, LG3-4, LG3-5) Use the following financial statements for Lake of Egypt Marina, Incorporated Assets LAKE OF EGYPT MARINA, INCORPORATED Balance Sheet as of December 31, 2024 and 2023 (in millions of dollars) 2024 2023 Liabilities and Equity Current assets: Current liabilities: Cash and marketable securities Accounts receivable $131 $ 63 Accrued wages and taxes Less: Depreciation Inventory Total Fixed assets: Gross plant and equipment Net plant and equipment Other long-term assets Total Total assets 80 371 77 217 Accounts payable Notes payable $ 582 $ 357 Total Long-term debt: $ 520 121 $399 $ 371 Stockholders' equity: 70 $ 301 50 42 $ 449 $1,031 $ 343 Total Preferred stock (7 million shares) Common stock and paid-in surplus (56 million shares) Retained earnings $700 Total liabilities and equity LAKE OF EGYPT MARINA, INCORPORATED Income Statement for Years Ending December 31, 2024 and 2023 (in millions of dollars) Net sales (all credit) Less: Cost of goods sold Gross profits 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) 2024 $ 850 340 $ 510 68 2023 $ 650 247 $ 403 52 442 351 51 39 $ 391 51 $ 312 52 $ 340 $ 260 71 78 $ 269 $ 182 $ 7 $ 7 $ 262 $ 175 56 56 $ 206 $ 119 $ 4.679 $ 3.125 $ 1.000 $ 1.000 $ 7.929 $ 4.250 $ 15.150 $ 12.950 Calculate the following ratios for Lake of Egypt Marina, Incorporated, as of year-end 2024. Note: Use sales when computing the Inventory turnover and use total stockholders' equity when computing the equity multiplier. Round your answers to 2 decimal places. Use 365 days a year. LAKE OF EGYPT MARINA, INCORPORATED a. Current ratio b. Quick ratio c. Cash ratio d. Inventory turnover e. Days' sales in inventory g. Average payment period h. Fixed asset turnover Sales to working capital j. Total asset turnover Debt ratio m. Debt-to-equity o. Times interest earned 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 y. PE ration times times times times days days times times times % times times 96 96 % %6 96 96 96 times times 2024 2023 $ 80 $ 84 100 91 80 84 $ 260 $ 259 $ 320 $196 $ 7 $ 7 56 56 388 182 $ 451 $ 245 $ 1,031 $ 700