Income Statement

Balance sheet

Task: Use the information in the income statement and balance sheet to complete the blanks in yellow

2016-12 7000 5401 1599 2017-12 11759 9536 2222 2018-12 21461 17419 4042 2019-12 24578 20509 4069 2020-12 31536 24906 6630 834 1432 1378 2476 1491 3145 Fiscal year ends in December. USD in millions except per share data. Revenue Cost of revenue Gross profit Operating expenses Research and development Sales, General and administrative Restructuring, merger and acquisition Other operating expenses Total operating expenses Operating income Interest Expense Other income (expense) Income before taxes Provision for income taxes Net income from continuing operations Other Net income Net income available to common shareholders Earnings per share Basic Diluted Weighted average shares outstanding Basic Diluted EBITDA 1460 2834 135 -135 4295 -253 663 -89 -1005 2267 -667 199 120 -746 27 -773 98 -675 -675 3855 -1632 471 -106 -2209 32 -2241 279 -1961 -1961 1343 2646 149 -149 3989 80 685 -60 -665 110 -775 -87 -862 -862 4636 1994 748 -92 1154 292 862 -172 690 690 58 -1063 86 -976 -976 -0.94 -0.94 -2.37 -2.37 -1.14 -1.14 -0.98 -0.98 0.74 0.64 721 721 400 829 829 -102 853 853 1559 885 885 2174 933 1083 4224 2017-12 2018-12 2019-12 2020-12 3368 3368 515 2264 268 155 6571 3686 3686 949 3113 366 193 8306 6268 6268 1324 3552 713 246 12103 19384 19384 1886 4101 1346 26717 22436 -1944 20492 60 362 1171 22085 28655 22886 -3195 19691 68 282 1391 21433 29740 31925 -11726 20199 198 339 1470 22206 34309 29447 -6072 23375 207 313 1536 25431 52148 Fiscal year ends in December. USD in millions except per share data 2016-12 Assets Current assets Cash Cash and cash equivalents 3393 Total cash 3393 Receivables 499 Inventories 2067 Prepaid expenses 194 Other current assets 106 Total current assets 6260 Non-current assets Property, plant and equipment Gross property, plant and equipment 16055 Accumulated Depreciation -1018 Net property, plant and equipment 15037 Goodwill Intangible assets 376 Other long-term assets 991 Total non-current assets 16404 Total assets 22664 Liabilities and stockholders' equity Liabilities Current liabilities Short-term debt 1150 Capital leases 52 Accounts payable 1860 Taxes payable 153 Accrued liabilities 1005 Deferred revenues 1427 Other current liabilities 180 Total current liabilities 5827 Non-current liabilities Long-term debt 5978 Capital leases 1408 Deferred taxes liabilities Accrued liabilities 150 Deferred revenues 852 Minority interest 785 Other long-term liabilities 2911 Total non-current liabilities 12084 Total liabilities 17911 Stockholders' equity Common stock 0 Additional paid-in capital 7774 Retained earnings -2997 Accumulated other comprehensive income -24 Total stockholders' equity 4753 Total liabilities and stockholders' equity 22664 2222 489 3404 349 1399 671 3771 611 897 67 2390 186 1257 1869 1008 7675 1758 660 6051 777 2134 2210 658 1122 1423 983 9992 1534 1889 792 10667 14248 9418 1734 8410 2706 10402 2225 276 1178 997 3140 16743 24418 547 991 834 1336 14824 24816 745 1207 849 1596 17024 27691 8513 2348 151 989 1284 850 1540 15675 29923 0 1 12737 -6083 0 9178 -4974 33 4237 28655 10249 -5318 -8 4923 29740 -36 27260 -5399 363 22225 52148 6618 34309 2016-12 2017-12 2018-12 2019-12 2020-12 7,000 11,759 21,461 24,578 31,536 22.8 -667 -1,632 -253 80 1994 -9.5 -13.9 -1.2 0.3 6.3 -675 -1,961 -976 -862 690 -0.94 -2.37 -1.14 -0.98 0.64 Revenue USD Mil Gross Margin Operating Income USD Mil Operating Margin / Net Income USD Mil Earnings Per Share USD Dividends USD Shares Mil Book Value Per Share ' USD Operating Cash Flow USD Mil Free Cash Flow USD Mil Free Cash Flow Per Share ' USD Working Capital USD Mil 721 3.32 -124 -1,564 -1.27 433 830 5.58 -61 -4.142 -6 -1,104 853 5.22 2,098 -222 -1.77 -1,686 887 6.67 2,405 968 1 1,436 1,083 16.7 5,943 2,701 1.8 12,469 Price/Earnings PricelBook 2016-12 2017-12 2018-12 2019-12 2020-12 NIA NIA NIA NIA 1341.58 12.88 11.15 12.74 12.54 42.26 Margins % of Sales Revenue COGS Gross Margin SG&A R&D Other Operating Margin Net Int Inc & Other EBT Margin 2016-12 2017-12 2018-12 2019-12 2020-12 100 100 100 100 100 77.15 81.1 81.17 83.44 78.98 22.85 18.9 18.83 16.56 21.02 20.46 21.06 13.21 10.77 9.97 11.92 11.72 6.8 5.46 4.73 -9.53 -1.13 -10.66 -13.88 -4.91 - 18.79 -1.18 -3.5 -4.68 0.33 -3.03 -2.71 6.32 -2.66 3.66 2016-12 2017-12 2018-12 2019-12 2020-12 2.19 0.46 0.46 0.73 0.77 0.73 Net Margin% Asset Turnover (Average) Return on Assets Financial Leverage (Average) Return on Equity Return on Invested Capital Interest Coverage 4.77 -23.11 -6.54 -2.75 6.76 -43.63 -11.39 -3.69 6.04 -21.31 -2.91 -0.52 5.18 -14.94 -1.65 0.03 2.35 4.78 4.32 2.54 2016-12 2017-12 2018-12 2019-12 2020-12 Current Ratio Quick Ratio Financial Leverage Debt/Equity Debt/Asset 0.67 4.77 1.55 0.51 6.76 2.63 0.46 6.04 2.26 0.71 5.18 1.9 1.49 2.35 0.49 Days Sales Outstanding Days Inventory Payables Period Cash Conversion Cycle Receivables Turnover Inventory Turnover Fixed Assets Turnover Asset Turnover 2016-12 2017-12 2018-12 2019-12 2020-12 18.58 56.08 93.82 81.35 60.71 63.85 71.97 36.64 17.28 8.08 12.34 2.68 20.96 3.23 0.69 0.66 107 1.23 1.45 0.46 0.46 0.73 0.77 0.73