Answered step by step
Verified Expert Solution
Link Copied!

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

  1. In each of five focus areas (liquidity, profitability, ), provide your view/thoughts for the company's CEO consideration.
  2. List, in order of priority (#1 being the highest), the three greatest concerns you have about the historical performance and explain your thoughts.
  3. 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.
  4. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investments An Introduction

Authors: Herbert B Mayo

9th Edition

324561385, 978-0324561388

More Books

Students also viewed these Finance questions