Question

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

Use the following financial statements for Lake of Egypt Marina, Inc.

LAKE OF EGYPT MARINA, INC.
Balance Sheet as of December 31, 2015 and 2014
(in millions of dollars)
2015 2014 2015 2014
  Assets   Liabilities and Equity
  Current assets:   Current liabilities:
     Cash and marketable securities $ 96 $ 60      Accrued wages and taxes $ 48 $ 60
     Accounts receivable 88 66      Accounts payable 56 72
     Inventory 248 156      Notes payable 64 78
        Total $ 432 $ 282         Total $ 168 $ 210
  Fixed assets:   Long term debt: $ 252 $ 180
     Gross plant and equipment $ 416 $ 330   Stockholders’ equity:
     Less: Depreciation 88 48      Preferred stock (6 million shares) $ 6 $ 6
     Common stock and paid-in surplus
       (48 million shares)
48 48
     Net plant and equipment $ 328 $ 282      Retained earnings 326 156
     Other long-term assets 40 36
        Total $ 368 $ 318         Total $ 380 $ 210
  
  Total assets $ 800 $ 600   Total liabilities and equity $ 800 $ 600
LAKE OF EGYPT MARINA, INC.
Income Statement for Years Ending December 31, 2015 and 2014
(in millions of dollars)
2015 2014
  Net sales (all credit) $ 800 $ 600
  Less: Cost of goods sold 368 240
  Gross profits $ 432 $ 360
  Less: Other operating expenses 40 24
     
  Earnings before interest, taxes, depreciation, and
amortization (EBITDA)
$ 392 $ 336
  Less: Depreciation 40 36
  Earnings before interest and taxes (EBIT) $ 352 $ 300
  Less: Interest 32 30
  Earnings before taxes (EBT) $ 320 $ 270
  Less: Taxes 96 81
  Net income $ 224 $ 189
  Less: Preferred stock dividends $ 6 $ 6
  Net income available to common stockholders $ 218 $ 183
  Less: Common stock dividends 48 48
  Addition to retained earnings $ 170 $ 135
  Per (common) share data:
     Earnings per share (EPS) $ 4.540 $ 3.810
     Dividends per share (DPS) $ 1.000 $ 1.000
     Book value per share (BVPS) $ 7.790 $ 4.250
     Market value (price) per share (MVPS) $ 15.350 $ 13.150

Construct the DuPont ROA and ROE breakdowns for Lake of Egypt Marina, Inc. (Do not round intermediate calculations. Round your answers to 2 decimal places.)

DuPont Analysis
  ROA %
  ROE %  

Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC. Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) 2015 2014 2015 2014 Assets Liabilities and Equity Current assets: Current liabilities: Cash and marketable securities $ 96 $ 60 Accrued wages and taxes $ 48 $ 60 Accounts receivable 88 66 Accounts payable 56 72 Inventory 248 156 Notes payable 64 78 Total $ 432 $ 282 Total $ 168 $ 210 Fixed assets: Long term debt: $ 252 $ 180 Gross plant and equipment $ 416 $ 330 Stockholders’ equity: Less: Depreciation 88 48 Preferred stock (6 million shares) $ 6 $ 6 Common stock and paid-in surplus (48 million shares) 48 48 Net plant and equipment $ 328 $ 282 Retained earnings 326 156 Other long-term assets 40 36 Total $ 368 $ 318 Total $ 380 $ 210 Total assets $ 800 $ 600 Total liabilities and equity $ 800 $ 600 LAKE OF EGYPT MARINA, INC. Income Statement for Years Ending December 31, 2015 and 2014 (in millions of dollars) 2015 2014 Net sales (all credit) $ 800 $ 600 Less: Cost of goods sold 368 240 Gross profits $ 432 $ 360 Less: Other operating expenses 40 24 Earnings before interest, taxes, depreciation, and amortization (EBITDA) $ 392 $ 336 Less: Depreciation 40 36 Earnings before interest and taxes (EBIT) $ 352 $ 300 Less: Interest 32 30 Earnings before taxes (EBT) $ 320 $ 270 Less: Taxes 96 81 Net income $ 224 $ 189 Less: Preferred stock dividends $ 6 $ 6 Net income available to common stockholders $ 218 $ 183 Less: Common stock dividends 48 48 Addition to retained earnings $ 170 $ 135 Per (common) share data: Earnings per share (EPS) $ 4.540 $ 3.810 Dividends per share (DPS) $ 1.000 $ 1.000 Book value per share (BVPS) $ 7.790 $ 4.250 Market value (price) per share (MVPS) $ 15.350 $ 13.150 Construct the DuPont ROA and ROE breakdowns for Lake of Egypt Marina, Inc. (Do not round intermediate calculations. Round your answers to 2 decimal places.) DuPont Analysis ROA % ROE %

Homework Answers

Answer #1
Average Total Assets=(800+600)/2= $700
Average Total Equity=(380+210)/2 $        295
Net Income $        224
Net Income available to equity holders $        218
ROE(Return on Equity)=Net Profit margin*Asset Turnover Ratio*Financial Leverage
ROE=(Net Income/Sales)*(Sales/Total assets)*(Total assets/Total Equity)
ROE=(218/800)*(800/700)*(700/295) 0.738983
ROE= 73.90%
ROA=Net Income /Total Assts=224/700 0.32
ROA= 32.0%
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC....
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC. Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) 2015 2014 2015 2014   Assets   Liabilities and Equity   Current assets:   Current liabilities:      Cash and marketable securities $ 50 $ 56      Accrued wages and taxes $ 50 $ 48      Accounts receivable 60 52      Accounts payable 55 44      Inventory 205 96      Notes payable 60 40         Total $ 315 $ 204         Total $ 165...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) 2015       2014           2015       2014 Assets                           Liabilities and Equity                   Current assets:                           Current liabilities:                   Cash and marketable securities   $   45       $   36       Accrued wages and taxes   $  ...
Use the following financial statements for Lake of Egypt Marina, Inc.    LAKE OF EGYPT MARINA,...
Use the following financial statements for Lake of Egypt Marina, Inc.    LAKE OF EGYPT MARINA, INC. Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) 2015 2014 2015 2014   Assets   Liabilities and Equity   Current assets:   Current liabilities:      Cash and marketable securities $ 73 $ 64      Accrued wages and taxes $ 41 $ 44      Accounts receivable 117 112      Accounts payable 91 81      Inventory 202 192      Notes payable 81 71         Total $ 392 $ 368         Total $...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) 2015 2014 2015 2014   Assets   Liabilities and Equity   Current assets:   Current liabilities:      Cash and marketable securities $ 44 $ 42      Accrued wages and taxes $ 28 $ 30      Accounts receivable 36 36      Accounts payable 32 36      Inventory 153 63      Notes payable 36 42         Total $ 233 $ 141         Total $ 96...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) 2015 2014 2015 2014   Assets   Liabilities and Equity   Current assets:   Current liabilities:      Cash and marketable securities $ 44 $ 42      Accrued wages and taxes $ 28 $ 30      Accounts receivable 36 36      Accounts payable 32 36      Inventory 153 63      Notes payable 36 42         Total $ 233 $ 141         Total $ 96...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC....
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) 2021 2020 2021 2020 Assets Liabilities and Equity Current assets: Current liabilities: Cash and marketable securities $ 75 $ 65 Accrued wages and taxes $ 40 $ 43 Accounts receivable 115 110 Accounts payable 90 80 Inventory 200 190 Notes payable 80 70 Total $ 390 $ 365 Total $ 210...
Some recent financial statements for Smolira Golf, Inc., follow. SMOLIRA GOLF, INC. Balance Sheets as of...
Some recent financial statements for Smolira Golf, Inc., follow. SMOLIRA GOLF, INC. Balance Sheets as of December 31, 2015 and 2016 2015 2016 2015 2016 Assets Liabilities and Owners’ Equity Current assets Current liabilities Cash $ 3,061 $ 3,057 Accounts payable $ 2,178 $ 2,650 Accounts receivable 4,742 5,731 Notes payable 1,775 2,166 Inventory 12,578 13,732 Other 95 112 Total $ 20,381 $ 22,520 Total $ 4,048 $ 4,928 Long-term debt $ 12,900 $ 15,660 Owners’ equity Common stock and...
Use the balance sheet and income statement below : CLANCY’S DOG BISCUIT CORPORATION Balance Sheet as...
Use the balance sheet and income statement below : CLANCY’S DOG BISCUIT CORPORATION Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) Assets 2015 2014 Liabilities and Equity 2015 2014 Current assets: Current liabilities: Cash and marketable securities $ 8 $ 8 Accrued wages and taxes $ 13 $ 7 Accounts receivable 38 30 Accounts payable 27 25 Inventory 41 35 Notes payable 25 23 Total $ 87 $ 73 Total $ 65 $ 55 Fixed...
Use the balance sheet and income statement below: VALIUM’S MEDICAL SUPPLY CORPORATION Balance Sheet as of...
Use the balance sheet and income statement below: VALIUM’S MEDICAL SUPPLY CORPORATION Balance Sheet as of December 31, 2015 and 2014 (in thousands of dollars) 2015 2014 2015 2014 Assets Liabilities and Equity Current assets: Current liabilities: Cash and marketable securities $ 74 $ 73 Accrued wages and taxes $ 50 $ 43 Accounts receivable 191 183 Accounts payable 156 143 Inventory 316 293 Notes payable 133 133 Total $ 581 $ 549 Total $ 339 $ 319 Fixed assets:...
P3-1. Calculating Ratios Below are the financial statements for Mowing and Maintenance, Inc. Paul’s Plowing, Inc....
P3-1. Calculating Ratios Below are the financial statements for Mowing and Maintenance, Inc. Paul’s Plowing, Inc. Balance Sheet as of December 31, 2018 and 2017 (in millions of dollars) Assets 2018 2017 Cash and marketable securities $ 140 $ 120 Accounts receivable $240 $230 Inventory $ 500 $425 Total Current Assets $ 880 $ 775 Liabilities & Equity 2018 2017 Current liabilities: Accrued wages and taxes $ 80 $ 90 Accounts payable $ 130 $ 120 Notes payable $240 $210...