Question: Mohawk UNITS (eg Billions, Millions, Thousands - Please input) Millions FY 2019 FY 2018 FY 2017 FY 2016 Comments Total Revenue (or Sales) 9491 8959

Mohawk
UNITS (eg Billions, Millions, Thousands - Please input) Millions
FY 2019 FY 2018 FY 2017 FY 2016 Comments
Total Revenue (or Sales) 9491 8959
Cost of Goods Sold/Cost of Sales 6495 6146
Total Selling, General & Administrative (SG&A) 1642 1533
Total Interest Expense 31 41 Interest, net
Gross Profit (Gross Income) 2996 2812 Rev - COS
Gross Margin 32% 31% GP/Rev
Net Profit (Net Income) 972 930
Net Margin 10% 10% NP/Rev
SG&A as % of Sales 17% 17% SG&A/Rev
Interest Expense as % of Sales 0% 0% Int Exp/Rev
Return on Sales (ROS) 10% 10% NP/Rev
Return on Total Assets (ROA) 8% 9% NP/Total Assets
Return on Equity (ROE) 14% 16% NP/Total Equity

Part A: Financial Analysis Snapshot All work is to be completed and submitted in the attached Excel template. Go to the Investor Relations section of each companys website and download their annual reports. You may need to download more than one report to get all required historical data. Use the Annual Reports/10K to populate the Excel template. o Some entries simply require finding the respective line item amounts, while others will require calculations (these are indicated in in template). o Note that some historical data and ratios have already been provided in the template.

Dixie
Millions
FY 2019 FY 2018 FY 2017 FY 2016 Comments
412 397
311 302
96 97
6 5
101 95
25% 24% GP/Rev
-10 -5
-2% -1% NP/Rev
23% 24% SG&A/Rev
1% 1% Int Exp/Rev
-2% -1% NP/Rev
-4% -2% NP/Total Assets
-13% -6% NP/Total Equity
0 0
46 44
114 97
164 145
283 269
59 64
123 98 LTD + Op Lease Liab
204 182
-125 -116 Accumulated Deficit
79 87
2.78 2.27 CA/CL
0.78 0.69 (Cash + Ar)/CL
1.56 1.13 LTD/Total Equity
2.58 2.09 Tot Debt/Tot Equity
2.95 COS/avg Inv
123.82 365/Inv Turns
9.2 Revenue/Avg AR
40 365/AR Turnover
-10 24 Source/(Use)
-13 -5
22 -19
-13 -5
24 -18

Sum of all Payment/Proceed (ex st=hort term borring)

0 0
0 0
0 0
-23 19 CFFO - CapEx

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!