Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following is the financial statement of Executive Dynamic Mattress for the year ended December 2018. Refer Table 18.2 INCOME STATEMENT, 2018 Revenue $ 3,300.0
The following is the financial statement of Executive Dynamic Mattress for the year ended December 2018. Refer Table 18.2
INCOME STATEMENT, 2018 | |||
Revenue | $ | 3,300.0 | |
Cost of goods sold | 3,069.0 | ||
Depreciation | 35.1 | ||
EBIT | $ | 195.9 | |
Interest expense | 9.8 | ||
Earnings before taxes | $ | 186.1 | |
Taxes (50% of 6) | 93.1 | ||
Net income | $ | 93.1 | |
Dividends | 80.6 | ||
Reinvested earnings | $ | 12.5 | |
Operating cash flow | $ | 128.2 | |
BALANCE SHEET, YEAR-END | ||||||||||||||||
2017 | 2018 | |||||||||||||||
Assets | ||||||||||||||||
Net working capital | $ | 329.0 | $ | 429.0 | ||||||||||||
Fixed assets | 439.0 | 445.5 | ||||||||||||||
Total net assets | $ | 768.0 | $ | 874.5 | ||||||||||||
Liabilities and Shareholders Equity | ||||||||||||||||
Long-term debt | $ | 98.0 | $ | 192.1 | ||||||||||||
Shareholders equity | 670.0 | 682.5 | ||||||||||||||
Total liabilities and shareholders equity | $ | 768.0 | $ | 874.5 | ||||||||||||
BALANCE SHEET, YEAR-END | ||||||||
2018 | ||||||||
Sources and Uses of Funds | ||||||||
Operating cash flow | $ | 128.2 | ||||||
Increase in working capital | 100.0 | |||||||
Investments in fixed assets | 41.6 | |||||||
Dividends | 80.6 | |||||||
Total uses of cash | 222.2 | |||||||
Required external capital | 94.1 | |||||||
Financial Ratios | ||||||||
Debt ratio | 0.2 | |||||||
Interest coverage | 20.0 | |||||||
Use the revised model to generate a new financial plan for 2021. How would its financial plan change if the dividend payout ratio were cut to 50%? What would be required external financing? (Input all amounts as positive values. Do not round intermediate calculations. Round "Debt ratio" to 2 decimal places and other answers to 1 decimal place.)
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