Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 3-31 DuPont Analysis (LG3-6) Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC. Balance Sheet as of
Problem 3-31 DuPont Analysis (LG3-6)
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 | $ | 33 | Accrued wages and taxes | $ | 40 | $ | 27 | ||||
Accounts receivable | 40 | 30 | Accounts payable | 35 | 24 | ||||||||
Inventory | 204 | 90 | Notes payable | 30 | 21 | ||||||||
Total | $ | 289 | $ | 153 | Total | $ | 105 | $ | 72 | ||||
Fixed assets: | Long term debt: | $ | 163 | $ | 132 | ||||||||
Gross plant and equipment | $ | 255 | $ | 165 | Stockholders equity: | ||||||||
Less: Depreciation | 69 | 36 | Preferred stock (3 million shares) | $ | 3 | $ | 3 | ||||||
Common stock and paid-in surplus (15 million shares) | 15 | 15 | |||||||||||
Net plant and equipment | $ | 186 | $ | 129 | Retained earnings | 214 | 78 | ||||||
Other long-term assets | 25 | 18 | |||||||||||
Total | $ | 211 | $ | 147 | Total | $ | 232 | $ | 96 | ||||
Total assets | $ | 500 | $ | 300 | Total liabilities and equity | $ | 500 | $ | 300 | ||||
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) | $ | 550 | $ | 350 | |
Less: Cost of goods sold | 220 | 133 | |||
Gross profits | $ | 330 | $ | 217 | |
Less: Other operating expenses | 44 | 28 | |||
Earnings before interest, taxes, depreciation, and amortization (EBITDA) | $ | 286 | $ | 189 | |
Less: Depreciation | 33 | 21 | |||
Earnings before interest and taxes (EBIT) | $ | 253 | $ | 168 | |
Less: Interest | 33 | 28 | |||
Earnings before taxes (EBT) | $ | 220 | $ | 140 | |
Less: Taxes | 66 | 42 | |||
Net income | $ | 154 | $ | 98 | |
Less: Preferred stock dividends | $ | 3 | $ | 3 | |
Net income available to common stockholders | $ | 151 | $ | 95 | |
Less: Common stock dividends | 15 | 15 | |||
Addition to retained earnings | $ | 136 | $ | 80 | |
Per (common) share data: | |||||
Earnings per share (EPS) | $ | 10.070 | $ | 6.330 | |
Dividends per share (DPS) | $ | 1.000 | $ | 1.000 | |
Book value per share (BVPS) | $ | 15.270 | $ | 6.200 | |
Market value (price) per share (MVPS) | $ | 15.650 | $ | 13.450 | |
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 | % |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started