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
Get step-by-step solutions from verified subject matter experts
