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:
- Vertical analysis of the balance sheet and income statement for all years shown.
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,329 22,396 71,230 1,285 72,5151 19,121 $53,394 $9.27 $9.21 $ 8.35 $ 8.31 $9.28 $9.221 5,217,242 5,470,820 5,753,421 5,251,692 5,500,281 5,793,069 $ 2.4.----$2.18 ----$1.981 Sep. 30, 2017 Sep. 24, 2016 $ 20,484 46,671 15,754 2.132 $ 20,289 53,892 17,874 4,855 17,799 13,936 128,645 194,714 33,783 5,717 2,298 10,162 375,319 13,545 8,283 106,869 170,430 27,010 5,414 3,206 8,757 321,686 CONSOLIDATED BALANCE SHEETS - USD ($) $ in 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, S0.00001 par value: 12,600,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,836 97,207 40,415 241,272 37,294 22,027 8,080 8,105 3,500 79,006 2,930 75,427 36,074 193,437 35,867 98,330 (150) 134,047 $ 375,319 31,251 96,364 634 128,249 S321,686
