$ 11,946 121,822 133,768 26,481 2,662 6.751 Assets Current assets Cash and cash equivalents Short-term investments Total cash, cash equivalents, and short-term investments Accounts receivable, net of allowance for doubtful accounts of $377 and $345 Inventories Other Total current assets Property and equipment, net of accumulated depreciation of $29,223 and $24,179 Operating lease right-of-use assets Equity and other investments Goodwill Intangible assets, net Other long-term assets Total assets 169,662 29,460 6,686 1.862 35,683 8,053 7.442 $ 7.663 125,318 132,981 22.431 2,181 5,103 162,696 23,734 6,555 6,023 35,122 10,106 5076 $ 250,312 $ 258.848 $ 8,617 $ Liabilities and stockholders' equity Current Labies Accounts payable Short-term debt Current portion of long-term debt Accrued compensation Short-term income taxes Short-term uneared revenue Other Total current liabilities Long-term debt Long-term income taxes Long-term unearned revenue Deferred income taxes Operating lease liabilities Other long-term liabilities Total liabilities Commitments and contingencies Stockholders' equity Common stock and paid in capital - shares authorized 24,000, outstanding 7,677 and 7.708 Retained earnings Accumulated other comprehensive income (loss) Total stockholders' equity Total liabilities and stockholders' equity 3.998 6,103 2,121 28,905 8,744 58,488 72,242 30,265 3,815 541 5,568 5,211 176,130 7,390 9,072 1.049 5,819 718 24,013 7,684 55,745 76,073 13.485 2,643 5,734 5.372 3,549 162,601 69,315 17.789 627 71,223 13.682 (2,187) 82,718 $ 258,848 87,711 $ 250,312 efer to accompanying notes 2017 2016 $ 7,563 125.318 1322981 19,792 2,181 4897 6,510 108.730 113.240 18277 2251 5.892 159 851 23,734 6,023 35.122 10.106 6,250 $ 241,086 139.680 18.30 10,431 17.872 3.733 3.416 $ 193,468 $ BALANCE SHEETS pe miliona June 30 Assets Current assets: Cash and cash equivalents Short-term investments (including securities loaned of $3,694 and $204) Total cash, cash equivalents, and short-term investments Accounts receivable net of allowance for doubtful accounts of $405 and 5426 Inventories Other Total current assets Property and equipment, net of accumulated depreciation of $24,179 and 519,800 Equity and other investments Goodwill Intangible assets net Other long-term assets Total assets Liabilities and stockholders' equity Current abilities Accounts payable Short-term debt Current portion of long-term debt Accrued compensation Income taxes Short-term unearned revenue Securities lending payable Other Total current liabilities Long-term debt Long-term unearned revenue Deferred income taxes Other long-term liabilities Total abilities Commitments and contingencies Stockholders' equity Common stock and paid in capital - shares authorized 24,000; outstanding 7,708 and 7.000 Retained earnings Accumulated other comprehensive Income Total stockholders' equity Total abilities and stockholders' equity 6.898 12,904 7.390 3,072 1,049 5,819 718 34,102 97 6,280 64,527 76,073 10,377 531 17,184 168,692 5,254 580 27.468 294 5,049 59.357 40,557 8.441 1.476 13,640 121,471 69,315 2.648 88,178 2282 1.537 72,394 $ 241,086 71.997 $ 193,468 See accompanying notes FINANCIAL STATEMENTS AND SUPPLEMENTARY DATA INCOME STATEMENTS fin milions, except per share amounta $ 64,497 45,863 110,360 $63.811 32.760 A 571 $ 67,336 23 818 91,154 Year Ended June 30, Revenue Product Service and other Total revenue Cost of revenue Product Service and other Total cost of revenue Gross margin Research and development Sales and marketing General and administrative Impairment and restructuring Operating income Other income (expense), net Income before income taxes Provision for income taxes 15,420 22.833 38,353 72,007 14.726 17.469 4,754 15,175 19.086 34 251 62 310 13.037 15.451 4,481 17.880 14.900 32.780 SA 374 11,98B 14.635 4.563 1.110 26,078 (439) 25.639 5. 100 $ 20.539 306 29.025 876 35,058 1.416 36,474 19,903 $ 16,571 29,901 4.412 $25.489 Net Income $ $ 2.15 2.13 $ $ 3.29 3.25 $ $ 2.59 2.56 Earnings per share: Basic Diluted Weighted average shares outstanding Basic Diluted Cash dividends declared per common share 7.700 7,794 1.68 7,746 7,8328 1.56 $ 7.925 ,013 1.44 $ Refer to accompanying notes CASH FLOWS STATEMENTS $ 16,571 $25,489 $ 20.539 630 6.672 10.261 3,940 (2,212) (5,143) 8.778 3.200 (2 073) (829) (223) 2.479 (1,216) (1.862) (465) (952) (285) 1,148 5.922 18,183 562 600 (1.212) (1.1102 1.028 (9173 2.565 3.820 1.792 (208) (179) (406) (20) 43,884 (118) 39.507 33 325 (4.063) Operations Net Income Adjustments to reconcile net income to net cash from operations Asset impaments Depreciation, amortization, and other Stock-based compensation expense Net recognized gains on investments and derivatives Deferred income taxes Changes in operating assets and liabilities: Accounts receivable Inventories Other current assets Other long-term assets Accounts payable Unearned revenue Income taxes Other current liabilities Other long-term liabilities Net cash from operations Financing Proceeds from Issuance (repayments) of short-term debt, maturities of 90 days or less net Proceeds from Issuance of debt Repayments of debt Common stock issued Common stock repurchased Common stock cash dividends paid Othernet Net cash from (used in) financing Investing Additions to property and equipment Acquisition of companies, net of cash acquired, and purchases of intangible and other assets Purchases of investments Maturities of investments Sales of investments Securities lending payable Net cash used in investing Effect of foreign exchange rates on cash and cash equivalents Net change in cash and cash equivalents Cash and cash equivalents, beginning of period Cash and cash equivalents, end of period (7,324) 7.183 (10,060) 7.922) 1,002 772 (10,721) (12,699) (971) (33,590) (11.788) (11,845) (190) 8,408 7,195 13,884 (2,796) 668 (15.089) (11.006) (369) (8,393) (11,632) (8,129) (8.343) (388) (137.380) 26.360 17,577 (25,944) (178,905) 28.044 136.360 (10) (46,781) (1.393) (129,758) 22.064 93,287 200 (6,061) (23,950) (67 1,153 6.510 5.595 $ 11.946 $ 7.663 $ 6,510 Refer to accompanying notes. Calculate each of the following the income statement, balance sheet, cash flous for 2016, 2017 and financial and 2018. Ratios statement Debt Ratio Total Total liabilitics Assets 1 Tima interest Net operating income interest Expense Carned Sales Total Asst Turnover Total Assets Fixed Asset Turnour Sales net plant and equiptment IGRAL orolit gross profits Calc each of the following financial Ratios using the income Statement, balance sheets and Statement of cash flows for 3. Gross margin. profit gross Sales profits operating margin profit net operating income (EBIT) Sales net protit Margin net income sales Operating on Assets Return Net operating Income EBIT) Total Assets