MULLID VIEW Be careful-tiles from the Internet can contain vituses. Unless you need to edit, it's safe to stay in G7 Revenue 8 Total Revenue 9 COGS 10 SG&A 11 D&A 12 Operating Income (EBIT) 13 Interest 14 Earnings Before Taxes (EBT) 15 Income Tax Expense (33%) 16 Net Income (Earnings) 17 18 19 Period Ending 20 Cash 21 Accounts Recievable 22 Inventory 23 Total Current Assets 24 Property Plant and Equipment 25 Goodwill 26 Intangible Assets Shett 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 1/31/2015 500.0 700.0 1,273.3 2,478.3 454.2 1,390.4 237.8 1/30/2016 650.0 730.0 1,200.0 2,580.0 484.5 1,476.7 330.4 Type here to search o PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay X G7 B 454.2 1,390.4 237.8 101.4 4,657.1 484.5 1,476.7 330.4 104.5 4,976.1 A 24 Property Plant and Equipment 25 Goodwill 26 Intangible Assets 27 Other Assets 28 Total Assets 29 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 39 40 NWC (Prof. Goch Definition - A/R + INV - A/P) 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 42 Cash Operating Earnings (EBITDA) Sheet1 FH Type here to search 19 Home Insert Draw Page Layout Formulas Data Review View Hels PROTECTED VIEW Be careful-Files from the Internet can contain viruses. Unless you need to edit, it's safer to sto G7 A B 42 Cash Operating Earnings (EBITDA) 43 44 45 ANWC (Professor Goch Definition) 46 47 Capital Expenditures (CAPX) 300.0 48 49 Free Cash Flow (FCF) 50 51 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 Anitta Sheet1 D Type here to search ANA (5) - Protected View Home Insert Draw Page Layout Formulas Data Review View Help D PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safet to stay in Prat 57 fo 3 Debt-to-EBITDA Ratio 9 - Turnover Ratios 51 Account Receivable (A/R) Days 52 Accounts Payables (A/P) Days 63 64 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 12.00 $ 200 15.00 200 76 77 75 Sheet1 HE p Type here to search E H Common Size the following Line Items 12/31/2017 12/31/2018 Gross Profit SG&A EBIT Net Income 535 PM