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)
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 | $ | 60 | $ | 28 | Accrued wages and taxes | $ | 40 | $ | 32 | |||
Accounts receivable | 50 | 36 | Accounts payable | 50 | 40 | |||||||
Inventory | 140 | 132 | Notes payable | 50 | 32 | |||||||
Total | $ | 250 | $ | 196 | Total | $ | 140 | $ | 104 | |||
Fixed assets: | Long term debt: | $ | 11 | $ | 124 | |||||||
Gross plant and equipment | $ | 300 | $ | 220 | Stockholders equity: | |||||||
Less: Depreciation | 75 | 40 | Preferred stock (8 million shares) | $ | 8 | $ | 8 | |||||
Common stock and paid-in surplus (60 million shares) | 60 | 60 | ||||||||||
Net plant and equipment | $ | 225 | $ | 180 | Retained earnings | 281 | 104 | |||||
Other long-term assets | 25 | 24 | ||||||||||
Total | $ | 250 | $ | 204 | Total | $ | 349 | $ | 172 | |||
Total assets | $ | 500 | $ | 400 | Total liabilities and equity | $ | 500 | $ | 400 | |||
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) | $ | 700 | $ | 500 | |
Less: Cost of goods sold | 210 | 140 | |||
Gross profits | $ | 490 | $ | 360 | |
Less: Other operating expenses | 49 | 30 | |||
Earnings before interest, taxes, depreciation, and amortization (EBITDA) | $ | 441 | $ | 330 | |
Less: Depreciation | 35 | 25 | |||
Earnings before interest and taxes (EBIT) | $ | 406 | $ | 305 | |
Less: Interest | 56 | 35 | |||
Earnings before taxes (EBT) | $ | 350 | $ | 270 | |
Less: Taxes | 105 | 81 | |||
Net income | $ | 245 | $ | 189 | |
Less: Preferred stock dividends | $ | 8 | $ | 8 | |
Net income available to common stockholders | $ | 237 | $ | 181 | |
Less: Common stock dividends | 60 | 60 | |||
Addition to retained earnings | $ | 177 | $ | 121 | |
Per (common) share data: | |||||
Earnings per share (EPS) | $ | 3.950 | $ | 3.020 | |
Dividends per share (DPS) | $ | 1.000 | $ | 1.000 | |
Book value per share (BVPS) | $ | 5.680 | $ | 2.730 | |
Market value (price) per share (MVPS) | $ | 15.050 | $ | 12.850 | |
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 | % | |
References
eBook & Resources
WorksheetProblem 3-31 DuPont Analysis (LG3-6)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started