• Prepare and discuss a vertical and horizontal Analysis of the income statement for two most recent years

All Numbers in Millions Revenue Cost of Goods Sold Gross Profit Selling, General, & Admin. Expense Research & Development Other Operating Expense Total Operating Expense Operating Income Interest Income Interest Expense Net Interest Income Other Income (Expense) Pre-Tax Income Tax Provision Tax Rate% Net Income (Continuing Operations) Net Income (Discontinued Operations) Other Income (Minority Interest) Net Income Preferred Dividends EPS (Basic) EPS (Diluted) Shares Outstanding (Diluted Average) EBIT Depreciation, Depletion and Amortization EBITDA 1/1/17! 12,350.54 10,223.02 2,127.52 1,908.75 0 2.749 1,911.50 216.019 0.182 -135.84 -143.351 0 72.668 -27.968 38.49 44.7 -0.476 0 44.224 0 0.351 0.338 130.792 208.508 178.325 386.833 1/1/18 1/1/19 1/1/20 1/1/21 TTM 12,754.59 13,007.35 13,190.71 15,430.02 15,500.63 10,513.49 10,646.45 10,763.93 12,451.06 12,531.67 2,241.10 2,360.90 2,426.78 2,978.96 2,968.97 2,017.82 2,051.32 2,059.43 2,326.76 2,336.30 0 0 0 0 0 3.004 6.118 15.152 9.809 7.769 2,020.83 2,057.44 2,074.58 2,336.56 2,344.07 220.272 303.453 352.199 642.392 624.896 0 0 0 0 0 -171.603 -135.808 -101.665 -70.885 -63.055 -175.663 -139.13 -104.41 -73.381 -65.456 -21.061 -25.405 -3.82 -11.004 -16.37 23.548 138.918 243.969 558.007 543.07 28.427 -11.826 -56.212 -136.825 -136.044 -120.72 8.51 23.04 24.52 25.05 51.975 127.092 187.757 421.182 407.026 -1.674 0.169 -0.581 -0.152 -0.151 0 0 0 0 0 50.301 127.261 187.176 421.03 406.875 0 0 0 0 0 0.399 1.09 1.37 3.09 2.98 0.385 1.05 1.35 3.03 2.92 130.792 121.135 139.109 138.876 138.662 195.151 274.726 345.634 628.892 606.125 164.061 162.223 157 167.454 171.001 359.212 436.949 502.634 796.346 777.126 1 Income_Statement Balance Sheet Cashflow_Statement + All Numbers in Millions 1/1/17 1/1/18 1/1/19 1/1/20 1/1/21 TTM 34.954 31.964 166.249 27.146 194.3 30.204 206.353 43.518 172.719 62.954 197.991 190.756 0 0 0 0 0 0 0 o oo 0 0 0 0 0 166.249 190.756 194.3 206.353 172.719 197.991 O O O O O o 0 0 0 0 OC 0 0 0 0 0 0 0 Assets Cash, Cash Equivalents, Marketable Securities Accounts Receivable Notes Receivable Loans Receivable Other Current Receivables Total Receivables Inventories, Raw Materials & Components Inventories, Work In Process Inventories, Inventories Adjustments Inventories, Finished Goods Inventories, Other Total Inventories Other Current Assets Total Current Assets Investments And Advances Land And Improvements Buildings And Improvements Machinery, Furniture, Equipment Construction In Progress Other Gross PPE Gross Property, Plant and Equipment Accumulated Depreciation Property, plant and Equipment Intangible Assets Goodwill Other Long Term Assets Total Long-Term Assets Total Assets 1,031.84 1,019.14 0 0 1,031.84 1,019.14 34.338 91.756 1,264.40 1,336.60 0 0 409.397 404.4 0 0 813.925 924.616 6.848 20.775 171.363 184.165 1,401.53 1,533.96 -637.89 -775.206 763.643 758.75 1,177.29 1,149.01 924.13 924.13 26.888 29.492 1,967.82 1,937.25 3,232.22 3,273.86 0 0 0 0 1,052.31 1,081.50 1,205.70 1,120.33 0 0 0 0 1,052.31 1,081.50 1,205.70 1,120.33 63.454 41.961 48.649 54.258 1,337.21 1,360.02 1,470.58 1,435.54 0 0 0 0 390.243 375.375 385.572 397.254 0 0 0 0 1,039.36 1,135.89 1,298.44 1,336.58 23.749 51.741 23.633 31.283 203.394 2,274.27 2,307.84 2,370.02 1,656.75 3,837.28 4,015.48 4,135.13 -907.968 -1,017.01 -1,158.93 -1,200.20 748.778 2,820.27 2,856.55 2,934.93 1,125.00 1,071.12 1,059.26 1,056.64 924.13 924.13 924.13 924.13 28.297 18.374 25.14 22.101 1,902.08 3,909.76 3,940.95 4,013.67 3,239.29 5,269.78 5,411.53 5,449.21 Liabilites & Shareholder's Equity Accounts Payable Total Tax Payable Other Current Payables Current Accrued Expense Accounts Payable & Accrued Expense Short-Term Debt Short-Term Capital Lease Obligation Short-Term Debt & Capital Lease Obligation Current Deferred Revenue Current Deferred Taxes Liabilities DeferredTaxAndRevenue Other Current Liabilities Total Current Liabilities Long-Term Debt Long-Term Capital Lease Obligation Long-Term Debt & Capital Lease Obligation PensionAndRetirementBenefit NonCurrent Deferred Liabilities Other Long-Term Liabilities Total Long-Term Liabilities Total Liabilities Common Stock Preferred Stock Retained Earnings Accumulated other comprehensive income (loss) Additional Paid-In Capital Treasury Stock Other Stockholders Equity Total Stockholders Equity Minority Interest Total Equity Total Liabilities & Equity 720.632 751.948 816.88 10.058 33.031 29.908 0 0 0 198.775 143.584 154.954 929.465 928.563 1,001.74 20 219.75 254.377 0 0 0 20 219.75 254.377 116.483 143.193 161.215 0 0 0 116.483 143.193 161.215 134.393 178.081 160.354 1,200.34 1,469.59 1,577.69 2,000.12 2,492.66 1,546.47 53.826 50.953 42.467 2,053.94 2,543.61 1,588.94 101.474 93.951 89.973 111.829 74.713 53.285 111.842 121.849 131.485 2,379.09 2,834.13 1,863.68 3,579.43 4,303.71 3,441.37 0.871 0.871 1.381 0 0 0 -356.76 -1,036.01 -915.113 2.281 2.401 -11.315 6.397 2.883 742.072 0 0 - 19.109 0 0 0 -347.211 -1,029.86 -202.084 0 0 0 -347.211 -1,029.86 -202.084 786.412 988.074 1,023.14 39.104 44.591 0 0 0 0 176.413 208.871 669.924 1,001.93 1,241.54 1,693.06 343.377 260 210 123.751 131.513 132.869 467.128 391.513 342.869 174.666 173.698 0 0 0 0 174.666 173.698 0 157.693 224.465 0 1,801.42 2,031.21 2,035.93 1,337.31 846.175 747.311 2,002.02 2,002.96 2,050.95 3,339.33 2,849.13 2,798.26 64.882 88.982 0 62.101 78.268 45.529 56.397 44.608 155.959 3,522.71 3,060.99 2,999.75 5,324.12 5,092.20 5,035.68 1.407 1.434 1.44 0 0 0 -716.369 -295.339 -213.76 -26.586 -20.528 -12.676 773.618 826.377 855.168 -86.414 - 192.617 -216.648 0 0 0 -54.344 0 -54.344 319.327 0 319.327 413.524 0 413.524 All Numbers in Millions TTM 1/1/20 187.176 157 1/1/17 44.224 178.325 26.533 30.01 16.184 26.507 -30.578 68.656 -23.53 11.83 1/1/18 50.301 164.061 -24.507 12.706 -47.867 44.317 15.452 1/1/19 127.261 162.223 -3.976 -33.168 26.338 68.235 -1.655 55.774 -12.314 57.68 3.962 1/1/21 421.03 167.454 33.634 -124.193 -3.496 299.353 33.983 239.281 -9.197 32.15 406.875 171.001 -4.107 -95.397 -5.476 102.555 12.5 10.075 0.101 -11.02 -12.053 -29.196 22.169 -14.828 -6.84 -40.748 10.246 18.8 13.306 0 9.363 355.143 -196.901 21.606 -35.623 9.1 53.94 0 0 0 0 0 17.923 297.428 -114.756 0 0 22.145 210.085 -137.466 0 32.517 427.103 -145.913 0 17.828 868.546 -218.333 25.893 0 0 16.738 647.609 -257.811 42.523 0 0 0 0 0 0 0 0 0 0 Net Income From Continuing Operations Depreciation, Depletion and Amortization Change In Receivables Change In Inventory Change In Prepaid Assets Change In Payables And Accrued Expense Change in Other Working Capital Change In Working Capital Deferred Tax Stock Based Compensation Asset Impairment Charge Cash from Discontinued Operating Activities Cash Flow from Others Cash Flow from Operations Purchase Of Property, Plant, Equipment Sale Of Property, plant, Equipment Purchase of Business Sale Of Business Purchase Of Investment Sale Of Investment Net Intangibles Purchase And Sale Cash From Discontinued Investing Activities Cash From Other Investing Activities Cash Flow from Investing Issuance of Stock Repurchase of Stock Net Issuance of Preferred Stock Issuance of Debt Payments of Debt Net Issuance of Debt Cash Flow for Dividends ther Financing Cash Flow from Financing Effect of Exchange Rate Changes Net Change in Cash Capital Expenditure Free Cash Flow 0 0 0 0 Ooo 0 0 O o o od 0 0 0 0 0 0 -215.288 -137.466 0 0 -124.161 -1.969 0 -114.756 0 -1.427 0 1,166.00 -1,352.70 -186.696 -0.025 0.03 -188. 118 0 -5.446 -114.756 182.672 526.389 -920.984 -394.595 0 2,192.54 -1,498.09 694.45 -735.518 5.592 -69.629 0 -145.913 690.97 - 19.109 0 1,587.00 -2,527.49 -940.491 -0.025 -20.34 -288.998 0 -7.808 -145.913 281.19 -175.295 -192.44 0 0 -67.305 -106.203 0 0 1,394.20 1,001.06 -1,516.44 -1,578.28 -122.239 -577.225 -0.025 -0.025 12.779 0.661 -176.79 -662.792 0 -502.282 0 0 0 2.99 -137.466 3.058 -196.901 158.242 13.314 -218.333 650.213 -69.961 -257.811 389.798 72.619