Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Profitability/Net Income Margins What are the after-tax net income margins (i.e., net profit margins) for both companies? How do they compare? Who achieves the

image text in transcribed

1. Profitability/Net Income Margins

What are the after-tax net income margins (i.e., net profit margins) for both companies?

How do they compare?

Who achieves the higher net income margin? Why?

2. Inventory Management

Who does a better job managing their inventory (Inventory Days on Hand ratio)?

What are their respective 3-year trends for Inventory DOH?

What options could the company consider to improve inventory management?

3. Cash Is King

How much net cash from operations did each company generate last year?

Which company has done a better job generating cash from operations?

In layman's terms, how is each company spending their cash with respect to reinvestments in

the business, changes in debt, and returning money to shareholders?

4. Liquidity

How do the companies compare in terms of the current ratio, and what are their respective 3-

year trends?

Do their current ratios indicate that either of these companies could go bankrupt soon?

Mohawk Dixie UNITS (eg Billions, Millions, Thousands - Please input) Millions Millions Total Revenue (or Sales) Cost of Goods Sold/Cost of Sales Total Selling, General & Administrative (SG&A) Total Interest Expense Gross Profit (Gross Income) Gross Margin Net Profit (Net Income) Net Margin SG&A as % of Sales Interest Expense as % of Sales Return on Sales (ROS) Return on Total Assets (ROA) Return on Equity (ROE) FY 2019 FY 2018 FY 2017 FY 2016 Comments 9,971 9,983 9491 8959 7.295 7,145 6495 6146 1,849 1,742 1642 1533 41 39 31 41 Interest, net 2,676 2,838 2996 2812 Rev-cos 2796 2896 3296 319 GP/Rev 744 862 972 930 796 996 1096 1096 NPIRev 1996 1796 1796 1796 SG&A Rev 096 096 096 096 Int Exp/Rev 796 996 1096 1096 NP/Rev 696 796 896 996 NP/Total Assets 996 1296 1496 1695 NP/Total Equity FY 2019 FY 2018 FY 2017 FY 2016 Comments 375 405 412 397 288 318 311 302 84 92 96 97 6 6 6 5 86 27 87 101 95 2396 2196 2596 2496 GP/Rev 15 -21 -10 -5 496 -596 -296 -196 NP/Rev 2296 2396 2396 2496 SG&AIRev 296 296 196 196 Int Exp/Rev 496 -596 -296 -196 NP/Rev 696 -896 -496 -296 NP/Total Assets 2196 -3696 -1396 -696 NP/Total Equity 769 37 96 140 248 51 82 174 19 46 114 164 283 Cash Accounts Receivable Inventory Total Current Assets Total Assets Total Current Liabilities Long Term Debt (including LT Cap Lease) Total Debt Retained Earnings Total Equity Current Ratio Quick Ratio Long Term Debt to Equity Total Debt to Equity Inventory Turnover (time per year) Inventory Days on Hand (in days) AR Turnover (times per year) Days Sales Outstanding (in days) 135 1,527 2,282 4,429 13,389 2,713 1,518 5,260 7,232 8,126 1.63 119 1,606 2,288 4,509 13,100 3,266 1,516 5,659 6,588 7,440 1.38 0.53 0.20 0.76 3.12 116.98 6.2 59 85 1558 1949 4073 12095 2655 1560 4998 6004 7067 1.53 0.62 0.22 0.71 3.58 101.86 6.5 56 122 1376 1676 3472 10231 2718 1129 4423 Total Liab 5033 5786 1.281 CAICI 0.55 (Cash Ar)/CL 0.20 LTD/Total Equity 0.76 Tot Debt/Tot Equity COS/avg Inv 365/Inv Turns Revenue/Avg AR 365/AR Turnover 18 43 105 153 253 56 120 194 -146 59 2.73 1.09 2.03 3.29 3.03 120.46 9.4 39 -131 73 2.75 15.80 1.12 2.38 3.00 121.67 10.1 36 0.61 0.19 0.65 140 44 97 145 269 64 98 LTD + Op Lease Liab 182 -116 Accumulated Defici 87 2.27 CAICL 2.88 (Cash - Ary/CL 1.13 LTD/Total Equity 2.09 Tot Debt/Tot Equity COS/avg Inv 365/Inv Turns Revenue Avg AR 365/AR Turnover 59 123 204 -125 79 2.78 1.10 1.56 2.58 2.95 123.82 9.2 40 3.20 114.06 6.5 56 1,419 -616 -790 -545 1,181 -1,332 198 -794 1194 -1241 -7 -906 1345 Source/(Use) -672 -641 -672 Payments for P&E -632 Proceede payments of LTD 12 33 -44 5 -2 -3 24 Source/(Use) -5 -19 -5 -18 Sum of all Payment/P -4 -4 Cash Flow From Operations Cash Flow from Investing Cash Flow from Financing Capital Expenditures Change in Long Term Debt (Proceeds - Payments) Dividends Purchase of Tresaury Stock Cash used in Acquisitions Free Cash Flow Free Cash Flow as % of Net Income 7 0 0 -10 -13 221 -13 24 0 0 0 0 -23 23096 0 0 -100 -81 874 0 -274 -569 387 4596 -58 0 -251 288 3096 0 -827 0 0 8 -5396 o Purch of Company Stk 0 673 CFFO. CapEx 7296 FCFINI 0 0 19 CFFO. CapEx -38096 FCFINI 1 -595 11796

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_2

Step: 3

blur-text-image_3

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

Cost And Management Accounting Theory And Revision Kit For CA Intermediate

Authors: CA Rajeev Ramanath H

1st Edition

1684666651, 978-1684666652

More Books

Students also viewed these Accounting questions

Question

Write a short note on rancidity and corrosiveness.

Answered: 1 week ago