Obtain the balance sheet and income statement from Apple from their latest 10-K annual reports.

Cut and paste all years shown of the balance sheet and income statement into a new EXCEL spreadsheet. Omit any extraneous information (e.g., # shares of stock issued, outstanding, eps for other than the net income, etc.), Compute the ratios and financial analysis for each company as indicated below:

1. Horizonal analysis of the balance sheet and income statement (% change from year to year) for all the years presented.

Dont list the ratios*

CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) shares in Thousands, $ in Millions 12 Months Ended Sep. 30, 2017 Sep. 24, 2016 Sep. 26, 2015 $ 229,234 141,048 88,186 $215,639 131,376 84,263 $ 233,715 140,089 93,626 Income Statement [Abstract] Net sales Cost of sales Gross margin Operating expenses: Research and development Selling, general and administrative Total operating expenses Operating income Other income/(expense), net Income before provision for income taxes Provision for income taxes Net income Earnings per share: Basic (in dollars per share) Diluted (in dollars per share) Shares used in computing earnings per share: Basic (in shares) Diluted (in shares) Cash dividends declared per share in dollars per share 11,581 15,261 26,842 61,344 2,745 64,089 15,738 $ 48,351 10,045 14,194 24,239 60,024 1,348 61,372 15,685 $ 45,687 8,067 14,3291 22,396 71,230 1,285 72,5151 19,121 $ 53,394 $9.27 $ 9.21 $ 8.35 $ 8.31 $ 9.28 $ 9.22 5,217,242 5,470,820 5,753,421 5,251,692 5,500,281 5,793,069 -------$2.4.....$2.18....$1.98 Sep. 30, 2017 Sep. 24, 2016 $20.289 53.892 17,514 4,855 17,799 12,935 128,645 194,714 33,783 5,717 2.298 10.162 375,319 $ 20,484 46,671 15,754 2,132 13,545 8,283 106,069 170,430 27,010 5.414 3.206 8,757 321,686 CONSOLIDATED BALANCE SHEETS - USD ($) Sin Millions Current assets: Cash and cash equivalents Short-term marketable securities Accounts receivable, less allowances of $58 and $53, respectively Inventories Vendor non-trade receivables Other current assets Total current assets Long-term marketable securities Property, plant and equipment, net Goodwill Acquired intangible assets, net Other non-current assets Total assets Current liabilities: Accounts payable Accrued expenses Deferred revenue Commercial paper Current portion of long-term debt Total current liabilities Deferred revenue, non-current Long-term debt Other non-current liabilities Total liabilities Commitments and contingencies Shareholders' equity: Common stock and additional paid in capital, $0.00001 par value: 12,500,000 shares authorized: 5,126,201 and 5,336,166 shares issued and outstanding, respectively Retained earnings Accumulated other comprehensive income/loss) Total shareholders' equity Total liabilities and shareholders' equity 49.049 25,744 7,548 11.977 6,496 100,814 2,835 97,207 40,415 241,272 22,027 BOBO 8,105 3,500 79,006 2,930 75,427 36,074 193,437 35,867 58,330 (150) 134,047 $ 375,319 31,251 96,364 634 128,249 321.686 CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) shares in Thousands, $ in Millions 12 Months Ended Sep. 30, 2017 Sep. 24, 2016 Sep. 26, 2015 $ 229,234 141,048 88,186 $215,639 131,376 84,263 $ 233,715 140,089 93,626 Income Statement [Abstract] Net sales Cost of sales Gross margin Operating expenses: Research and development Selling, general and administrative Total operating expenses Operating income Other income/(expense), net Income before provision for income taxes Provision for income taxes Net income Earnings per share: Basic (in dollars per share) Diluted (in dollars per share) Shares used in computing earnings per share: Basic (in shares) Diluted (in shares) Cash dividends declared per share in dollars per share 11,581 15,261 26,842 61,344 2,745 64,089 15,738 $ 48,351 10,045 14,194 24,239 60,024 1,348 61,372 15,685 $ 45,687 8,067 14,3291 22,396 71,230 1,285 72,5151 19,121 $ 53,394 $9.27 $ 9.21 $ 8.35 $ 8.31 $ 9.28 $ 9.22 5,217,242 5,470,820 5,753,421 5,251,692 5,500,281 5,793,069 -------$2.4.....$2.18....$1.98 Sep. 30, 2017 Sep. 24, 2016 $20.289 53.892 17,514 4,855 17,799 12,935 128,645 194,714 33,783 5,717 2.298 10.162 375,319 $ 20,484 46,671 15,754 2,132 13,545 8,283 106,069 170,430 27,010 5.414 3.206 8,757 321,686 CONSOLIDATED BALANCE SHEETS - USD ($) Sin Millions Current assets: Cash and cash equivalents Short-term marketable securities Accounts receivable, less allowances of $58 and $53, respectively Inventories Vendor non-trade receivables Other current assets Total current assets Long-term marketable securities Property, plant and equipment, net Goodwill Acquired intangible assets, net Other non-current assets Total assets Current liabilities: Accounts payable Accrued expenses Deferred revenue Commercial paper Current portion of long-term debt Total current liabilities Deferred revenue, non-current Long-term debt Other non-current liabilities Total liabilities Commitments and contingencies Shareholders' equity: Common stock and additional paid in capital, $0.00001 par value: 12,500,000 shares authorized: 5,126,201 and 5,336,166 shares issued and outstanding, respectively Retained earnings Accumulated other comprehensive income/loss) Total shareholders' equity Total liabilities and shareholders' equity 49.049 25,744 7,548 11.977 6,496 100,814 2,835 97,207 40,415 241,272 22,027 BOBO 8,105 3,500 79,006 2,930 75,427 36,074 193,437 35,867 58,330 (150) 134,047 $ 375,319 31,251 96,364 634 128,249 321.686