'roblem 3-29 Spreadsheet Problem: DuPont Analysis (LG3-6) se the following financial statements for Lake of Egypt...

Transcribed Image Text:

'roblem 3-29 Spreadsheet Problem: DuPont Analysis (LG3-6) se the following financial statements for Lake of Egypt Marina, Incorporated Assets Current assets: 2024 LAKE OF EGYPT MARINA, INCORPORATED Balance Sheet as of December 31, 2024 and 2023 2023 Cash and marketable securities Accounts receivable $ 125 88 $ 60 66 Inventory 248 156 $ 461 $ 282 Total Fixed assets: Gross plant and equipment Less: Depreciation Net plant and equipment $416 88 (in millions of dollars) Liabilities and Equity Current liabilities: Accrued wages and taxes Accounts payable Notes payable Total Long-term debt: $ 330 Stockholders' equity: 36 48 Other long-term assets Total $ 328 40 $ 282 $ 368 $ 318 Total assets $ 829 Preferred stock (6 million shares) Common stock and paid-in surplus (48 million shares) Retained earnings Total $ 600 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 $ 800 368 2023 $ 600 240 $ 432 $ 360 40 24 392 336 40 36 $ 352 32 $ 300 30 $ 320 $ 270 67 81 $ 253 $ 189 $ 6 $ 247 $ 6 $ 183 48 $ 199 48 $ 135 $ 5.146 $ 3.813 $ 1.000 $ 1.000 $ 8.396 $ 4.250 $ 15.350 $ 13.150 Construct the DuPont ROA and ROE breakdowns for Lake of Egypt Marina, Incorporated for the year ended 2024. Note: Do not round Intermediate calculations. Round your answers to 2 decimal places. DuPont Analysis ROA 29.80 % x ROE 59.45 % x times times 96 times = 96 'roblem 3-29 Spreadsheet Problem: DuPont Analysis (LG3-6) se the following financial statements for Lake of Egypt Marina, Incorporated Assets Current assets: 2024 LAKE OF EGYPT MARINA, INCORPORATED Balance Sheet as of December 31, 2024 and 2023 2023 Cash and marketable securities Accounts receivable $ 125 88 $ 60 66 Inventory 248 156 $ 461 $ 282 Total Fixed assets: Gross plant and equipment Less: Depreciation Net plant and equipment $416 88 (in millions of dollars) Liabilities and Equity Current liabilities: Accrued wages and taxes Accounts payable Notes payable Total Long-term debt: $ 330 Stockholders' equity: 36 48 Other long-term assets Total $ 328 40 $ 282 $ 368 $ 318 Total assets $ 829 Preferred stock (6 million shares) Common stock and paid-in surplus (48 million shares) Retained earnings Total $ 600 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 $ 800 368 2023 $ 600 240 $ 432 $ 360 40 24 392 336 40 36 $ 352 32 $ 300 30 $ 320 $ 270 67 81 $ 253 $ 189 $ 6 $ 247 $ 6 $ 183 48 $ 199 48 $ 135 $ 5.146 $ 3.813 $ 1.000 $ 1.000 $ 8.396 $ 4.250 $ 15.350 $ 13.150 Construct the DuPont ROA and ROE breakdowns for Lake of Egypt Marina, Incorporated for the year ended 2024. Note: Do not round Intermediate calculations. Round your answers to 2 decimal places. DuPont Analysis ROA 29.80 % x ROE 59.45 % x times times 96 times = 96