Common Size the following Line Items 12/31/2017 12/31/2018 Gross Profit SG&A EBIT Net Income 12/31/2017 12/31/2018 8,296.0 8,400.0 6,200.0 6,000.0 1,485.0 1,700.0 156.5 140.0 454,5 560.0 29.0 45.0 425.5 515.0 140.4 170.0 285.1 345.1 S's in Millions Revenue 8 Total Revenue COGS SG&A 11 D&A Operating Income (EBIT) Interest 14 Earnings Before Taxes (EBT) 15 Income Tax Expense (339) Net Income (Earnings) 17 78 1 Period Ending 20 Cash 21 Accounts Recievable 22 Inventory 23 Total Current Assets 24 Property Plant and Equipment 25 Goodwill 26 Intangible Assets 27 Other Assets 20 Total Assets 1/31/2015 500.0 700.0 1,273.3 -2,473.3 454.2 1,390,4 237.8 101.4 4,657.1 1/30/2016 650.0 730.0 1.200.0 2,580,0 484,5 1.476.7 330.4 104.5 4.976.1 1,634.6 1.600.0 50 Accounts Payable 34 shoc Town Nh Sheet1 Type here to search B D E 9 30 Accounts Payable 31 Short Term Debt 32 Current Portion of Long Term Debt 33 Total Current Liabilities 34 Long Term Debt 35 Other Liabilities 36 Total Liabilities 37 Total Stockholder Equity 38 1,634,6 30.0 67.0 1,731.6 350.6 188.3 2,270.5 2,386.6 1,600.0 60.0 118.6 1,778.6 380.0 109.5 2,268.1 2.708.0 40 NWC (Prof. Goch Definition = A/R + INV - A/P) 41 42 Cash Operating Earnings (EBITDA) 43 44 45 ANWC (Professor Goch Definition) 8 9 9 9 8 X 300.0 47 Capital Expenditures (CAPX) 48 49 Free Cash Flow (FCF) 51 52 53 COMPLETE THE FOLLOWING RATIOS 54 Short Term Solvency Ratios SS Quick Ratio 52 53 COMPLETE THE FOLLOWING RATIOS 54 Short Term Solvency Ratios 55 Quick Ratio 56 57 Long Term Solvency Ratios/Coverage Ratios 58 Debt-to-EBITDA Ratio 59 60 Turnover Ratios 61 Account Receivable (A/R) Days 62 Accounts Payables (A/P) Days 63 64 s 65 Operating Profitability 66 Gross Profit Margin 67 SG&A Expense Ratio 68 69 Market Value Ratios 70 Share Price 71 Share Outstanding (in millions) 72 Earnings Per Share (EPS) 73 Price - Earnings Ratio 74 TEV-to-EBITDA Ratio 75 76 77 12.00 $ 200 15.00 200