Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In each of five focus areas (liquidity, profitability, ), provide your view/thoughts for the company's CEO consideration. List, in order of priority (#1 being the
- In each of five focus areas (liquidity, profitability, ), provide your view/thoughts for the company's CEO consideration.
- List, in order of priority (#1 being the highest), the three greatest concerns you have about the historical performance and explain your thoughts.
- List, in order of priority, the three greatest concerns your group has with the one-year financial forecast (the year 2020 is forecast) provided by the CEO and explain your thoughts.
- Use your answer in #4 (three greatest concerns about the forecast (the year 2020) to create your own forecast. In Excel, create a new, one-year forecast (balance sheet, income statement, and statement of cash flow) that combines the companys forecast with your responses in #4 to reflect an adjusted forecast that you are more comfortable with.
Profitability | 12/31/2018 | 12/31/2019 | 12/30/2020 | |
Gross Profit Margin | 24.93% | 26.97% | 33.31% | |
Operating Profit Margin | 6.53% | 4.70% | 6.03% | |
Net Profit Margin | 33.89% | 2.13% | 3.81% | |
Efficiency | ||||
A/R DOH | 58.15 | 46.84 | 45.75 | |
INVEN DOH | 178.25 | 144.33 | 144.54 | |
A/P DOH | 60.03 | 50.00 | 59.32 | |
Asset Turnover | 1.17 | 1.45 | 1.46 | |
Leverage | ||||
Debt/Equity | 128.92% | 171.43% | 232.85% | |
LTD/Total Capital | 36.93% | 45.63% | 53.79% | |
Debt/Total Capital | 128.92% | 171.43% | 232.85% | |
Debt/EBITDA | 5.92 | 6.22 | 5.76 | |
Times Interest Earned | 11.98 | 5.53 | 8.75 | |
Fixed Charge Coverage | 11.98 | 5.53 | 8.75 | |
Liquidity | ||||
Current Ratio | 2.42 | 2.21 | 2.07 | |
Quick Ratio | 1.03 | 0.91 | 0.97 | |
Cash Conversion Cycle | 176.37 | 141.18 | 130.98 | |
Returns | ||||
Return on Equity | 90.59% | 8.36% | 18.59% | |
Return on Assets | 39.57% | 3.08% | 5.58% | |
Return on Capital |
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