Financial Management - Annual Report Analysis.

profileMercy123
ExcelWorkbook.xlsx
Home>Business & Finance homework help>Management homework help>Financial Management - Annual Report Analysis.

Sheet1

Assignment 1 Student Name:
Data and Analytics Submission Template
Mohawk Dixie
UNITS (eg Billions, Millions, Thousands - Please input) Millions Millions
FY 2019 FY 2018 FY 2017 FY 2016 Comments FY 2019 FY 2018 FY 2017 FY 2016 Comments
Total Revenue (or Sales) 9,971 9,983,634 9491 8959 374 405 412 397
Cost of Goods Sold/Cost of Sales 7,294.63 7,145.56 6495 6146 288 318 311 302
Total Selling, General & Administrative (SG&A) 1,849 1,743 1642 1533 84 92 96 97
Total Interest Expense 41 39 31 41 Interest, net 6 6 6 5
Gross Profit (Gross Income) 2,676 2,838 2996 2812 Rev - COS 86 87 101 95
Gross Margin 32% 32% 32% 31% GP/Rev 23% 21% 25% 24% GP/Rev
Net Profit (Net Income) 744 862 972 930 -15 -21 -10 -5
Net Margin 7% 0% 10% 10% NP/Rev -4% -5% -2% -1% NP/Rev
SG&A as % of Sales 19% 0% 17% 17% SG&A/Rev 22% 23% 23% 24% SG&A/Rev
Interest Expense as % of Sales 0% 0% 0% 0% Int Exp/Rev 1% 1% Int Exp/Rev
Return on Sales (ROS) 7% 0% 10% 10% NP/Rev -5% -2% -1% NP/Rev
Return on Total Assets (ROA) 6% 7% 8100% 9% NP/Total Assets -8% -4% -2% NP/Total Assets
Return on Equity (ROE) 14% 16% NP/Total Equity -13% -6% NP/Total Equity
Cash 135 119 85 122 1 0 0 0
Accounts Receivable 1,527 1,606 1558 1376 37 43 46 44
Inventory 2,282 2,288 1949 1676 96 105 114 97
Total Current Assets 4,429 4,509 4073 3472 151 153 164 145
Total Assets 13,393 13,001 12 10231 248 253 283 269
Total Current Liabilities 2,713 3,266 2655 2718 51 56 59 64
Long Term Debt (including LT Cap Lease) 1,051 1,742 1560 1129 81 120 123 98 LTD + Op Lease Liab
Total Debt 5,260 5,659 4998 4423 Total Liab 174 194 204 182
Retained Earnings 7232 6588 6004 5033 131 146 -125 -116 Accumulated Deficit
Total Equity 8,126 7,440 7067 5786 73 59 79 87
Current Ratio 1.60 1.38 1.53 1.28 CA/CL 2.96 2.73 2.78 2.27 CA/CL
Quick Ratio 0.61 0.53 0.62 0.55 (Cash + Ar)/CL 0.75 0.77 0.78 0.69 (Cash + Ar)/CL
Long Term Debt to Equity 0.13 0.23 0.22 0.20 LTD/Total Equity 1.11 2.03 1.56 1.13 LTD/Total Equity
Total Debt to Equity 0.65 0.76 0.71 0.76 Tot Debt/Tot Equity 2.38 3.29 2.58 2.09 Tot Debt/Tot Equity
Inventory Turnover (time per year) 3.19 3.37 3.58 COS/avg Inv 2.87 2.90 2.95 COS/avg Inv
Inventory Days on Hand (in days) 114.33 108.21 101.86 365/Inv Turns 127.37 125.68 123.82 365/Inv Turns
AR Turnover (times per year) 6.4 6310.8 6.5 Revenue/Avg AR 9.4 9.1 9.2 Revenue/Avg AR
Days Sales Outstanding (in days) 57 0 56 365/AR Turnover 39 40 40 365/AR Turnover
Cash Flow From Operations 1419 1818 1194 1345 Source/(Use) 12 5 -10 24 Source/(Use)
Cash Flow from Investing 616 1332 -1241 -672 33 2 -13 -5
Cash Flow from Financing 800 198 -7 -641 44 2 22 -19
Capital Expenditures -545 -794 -906 -672 Payments for P&E -4 -4 -13 -5
Change in Long Term Debt (Proceeds - Payments) -31,309 -35,721 7 -632 Proceeds - payments of LTD -106 -15 24 -18 Sum of all Payment/Proceed (ex st=hort term borring)
Dividends 0 0 0 0 3 4 0 0
Purchase of Tresaury Stock -100 -274 0 0 Purch of Company Stk -827 -58 0 0
Cash used in Acquisitions -81 -569 -251 0 0 0 0 0
Free Cash Flow 874 1024 288 673 CFFO - CapEx 8 1 -23 19 CFFO - CapEx
Free Cash Flow as % of Net Income 117% 119% 30% 72% FCF/NI -53% -5% 230% -380% FCF/NI
Indicates Financial Ratio (calculations required)
Note: FY 2017 and 2016 data from FY 2017 10-K