AutoSave O Off Excel Project - Part 3 - Excel File Home Insert Page Layout Formulas Data Review View Help X Cut Calibri v 11 A ap w Paste [A Copy Format Painter BIU Clipboard Font Alignment G11 X Y fx B C D E F G W N - Apple Inc. Historical Balance Sheets As of September 29, 2018, September 30 2017, and September 24, 2016 (In Millions) Assets Years Ended Sept. 29, 2018 Sept. 30, 2017 Sept. 24, 2016 Current Assets 8 Cash and Cash Equivalents S 25,913 5 20,289 5 20,484 9 Short-term marketable securities 40,388 53,892 46,671 10 Accounts Receivable, net 23.186 17.874 15.754 11 Inventories 3,956 4.855 2,132 12 Vendor non-trade receivables 25,809 17,799 13,545 13 Other current assets 12,087 13.936 8.283 14 15 Total current assets 131,339 S 128,645 106,869 16 17 Non-Current Assets 18 Marketable securities S 170,799 S 194, 714 5 170,430 19 Property, plant and equipment, net 41.304 33,783 27,010 20 Other non-current assets 22.283 18.177 17.377 21 Total Non-Current Assets S 234,386 246,674 214,817 22 Total Assets 365,725 5 375,319 321,686 23 24 Liabilities and Shareholders Equity 25 Current Liabilities 26 Accounts Payable S 55,888 S 44,242 S 37,294 27 Other Current Liabilities 32,687 30.551 22,027 28 Deferred Revenue 7,543 7,548 8,080 29 Commercial Paper 11,964 11,977 8,105 30 Term Debt 8.784 6.496 3.500 31 Total Current Liabilities 116,866 100,814 19,006 32 33 Non-Current Liabilities 34 Deferred Revenue 2,797 5 2,836 5 2,930 35 Term Debt 93,735 97,207 75,427 36 Other non-current liabilities 45.180 40.415 36.074 37 Total Non-Current Liabilities 141,712 140,458 114,431 38 Total Liabilities 258,578 241,272 193,437 39 40 Commitments and contingencies 41 42 Shareholders' equity 43 Common Stock Outstanding $ 4.745.398 $ 5.134.312 5 5.332.313 Company Information Historical Income Statements Historical BalanAutoSave (C Off ) Excel Project - Part 3 - Excel Sea File Home Insert Page Layout Formulas Data Review View Help X Cut Times New Roman ~ 11 [ Copy A A ab Wrap Text Paste Format Painter BIU Merge & Center Clipboard Font Alignment A16 X v fx Other expense, net A B C D E F IN - Apple Inc. Historical Income Statement As of Sept. 29, 2018, Sept. 30, 2017, and Sept. 24, 2016 (In Millions) Years Ended Sept. 29, 2018 Sept. 30, 2017 Sept. 24, 2016 Total Revenue $ 265,595 229,234 215,639 8 Costs of Revenue (163, 756) (141,048) (131,376) 9 Gross Margin $ 101,839 38,186 $ 84,263 10 Research and development (14,236) (11,581) (10,045) 11 Selling, general, and administrative (16,705) (15,261) (14,194) 12 Operating Expenses $ (30,941) $ (26,842) $ (24,239) 13 Operating Income $ 70,898 $ 51,344 $ 60,024 14 Interest and dividend income 5,686 5,201 3,999 15 Interest Expense (3,240) (2,323) (1,456) 16 Other expense, net (441) (133) (1,195) 17 Other Income (expense), net $ 2,005 $ 2,745 1,348 18 Income before provision for Income Tax $ 72,903 64,089 61,372 19 Provision for Income Taxes (13,372) (15,738) (15,685) 20 Net Income $ 59,531 $ 48,351 $ 45,687 21 22 23 Fields Using Formulas 24 25 26 27 28 29 Company Information Historical Income Statements Historical Balance Sheets HiAutoSave (C Off ) Excel Project - Part 3 - Excel File Home Insert Page Layout Formulas Data Review View Help X Cut Times New Roman ~ 11 [ Copy ae Wrap Paste Format Painter BIU A Merge Clipboard Font Alignment A46 X V fx Cash paid for interest 4 A B C D E F G Apple Inc. Historical Statements of Cash Flows As of Sept. 29, 2018, Sept. 30, 2017, and Sept. 24, 2016 (In Millions) Sept. 29, 201 Sept. 30, 201 Sept. 24, 2016 Cash and cash equivalents, beginning of the year $ 20,289 $ 20,484 $ 21.120 Operating activities: Net income 59,931 48.351 45.687 Adjustments to reconcile net income to cash generated by operating act Depreciation and amortization 10,903 10,157 10,505 11 Share-based compensation expense 5.240 4,840 4,210 Deferred income tax expense [ benefit] (32,590) 5,966 4,938 13 (166 486 14 Other [444) Changes in operating assets and liabilities: 15 Accounts receivable, net (5,322 (2,093 527 16 Inventories 828 2.723 217 Vendor non-trade receivables (8,010) 4,254) [51) Other current and non-current assets 423 5,318) 1,055 19 Accounts payable 9,175 8,966 2.117 20 Deferred revenue 144 626] 1,554) 21 Other current and non-current liabilities 38,490 1,125 1,9061 Cash generated by operating activities 77,734 64,225 66,231 Purchases of marketable securities Investing activities: (71,356] 159,486) (142.428) Proceeds from maturities of marketable securities 55,881 21,258 Proceeds from sales of marketable securities 47.838 31.775 94.564 90.536 Payments for acquisition of property, plant and equipment Payments made in connection with business acquisitions, net 13,313 [12,451) 12.734) (721) (329) (297 29 Purchases of non-marketable securities 1,871) 521) 1,388 30 353 126 31 Other Proceeds from non-marketable securities 745 (1241 924) 32 Cash generated by![used in) investing activities $ 16,066 33 [46,446] $ (45,977) Financing activities: 34 Proceeds from issuance of common stock 669 655 495 35 Payments for taxes related to net share settlement of equity awards 36 Payments for dividends and dividend equivalents [2.527) (13.712) [1.874) (1.570) [12,769 12.150 37 Repurchases of common stock (72.738) (32,900) 29.722) 38 Proceeds from issuance of term debt, net 6,969 28.662 24,954 39 Repayments of term debt (6,500] (3,500 2.500 40 Change in commercial paper, net (37) 3.852 397) 41 Cash used in financing activities $ [87,876] [17 974) $ [20,890) 42 Increasel[ Decrease) in cash and cash equivalents 5624 -195 -636 43 Cash and cash equivalents, end of the year 25,913 20,289 20,484 44 Cash paid for income taxes, net Supplemental cash flow disclosure: 10,417 $ 11,591 $ 10,444 46 Cash paid for interest 3,022 $ 2,092 $ 1,316 47 48 49 Fields Using Formulas Company Information Historical Income Statements Historical Balance S