Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EG
ID: 2816126 • Letter: U
Question
Use the following financial statements for Lake of Egypt Marina, Inc.
LAKE OF EGYPT MARINA, INC.
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 _____% * _____times = _______%
ROE______% * _____times * ________times =________%
ROA= Profit margin * Total asset turnover
ROE= ROA * Equity Multiplier
LAKE OF EGYPT MARINA, INC. Balance Sheet as of December 31, 2018 and 2017 (in millions of dollars) 2018 2017 2018 2017 Assets Liabilities and Equity Current assets: Current liabilities: Cash and marketable securities $ 72 $ 30 Accrued wages and taxes $ 40 $ 30 Accounts receivable 104 50 Accounts payable 80 55 Inventory 184 150 Notes payable 48 50 Total $ 360 $ 230 Total $ 168 $ 135 Fixed assets: Long-term debt: $ 320 $ 181 Gross plant and equipment $ 504 $ 305 Stockholders’ equity: Less: Depreciation 104 65 Preferred stock (4 million shares) $ 4 $ 4 Net plant and equipment $ 400 $ 240 Common stock and paid-in surplus 50 50 (50 million shares) Other long-term assets 40 30 Retained earnings 258 130 Total $ 440 $ 270 Total $ 312 $ 184 Total assets $ 800 $ 500 Total liabilities and equity $ 800 $ 500Explanation / Answer
DuPont Analysis
For FY2017
ROA= Profit Margin*Total Asset Turnover
= (Net Income/Sales)*(Sales/Total Assets)
= (112/400)*(400/500)
= 22.40%
ROE = ROA*Equity Multiplier
= ROA*(Total Assets/totalshareholder equity)
= 0.224(500/184)
= 60.87%
Similarly, for FY2018
ROA= Profit Margin*Total Asset Turnover
= (Net Income/Sales)*(Sales/Total Assets)
=(182/650)*(650/800)
= 22.75%
ROE = ROA*(Equity Multiplier)
= ROA(Total Assets/Total shareholder's Equity)
= 0.2275*(800/312)
= 58.33%
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.