On each data tab, use formulas to calculate the following financial indicators for each year of data: o Current ratio o Debt/equity ratio o Free cash flow o Earnings per share o Price/earnings ratio o Return on equity o Net profit margin

F49 Apple Inc (NMS: AAPL) Exchange rate used is that of the Year End 3 reported date 6 As Reported Annual Income Statement 09/30/2017 09/24/2016 09/26/2015 Currency Audit Status Not Qualified Not Qualified ot Qualified 10 Consolidated Thousands 229234000 141048000 88186000 1581000 15261000 26842000 61344000 5201000 2323000 133000 2745000 64089000 7842000 5980000 13822000 259000 Thousands 215639000 131376000 84263000 10045000 14194000 24239000 60024000 3999000 1456000 -1195000 1348000 61372000 7652000 5043000 2695000 990000 138000 852000 2105000 Thousands 233715000 140089000 93626000 8067000 14329000 22396000 71230000 2921000 733000 903000 1285000 72515000 11730000 3408000 15138000 1265000 -220000 1045000 4744000 1806000 2938000 19121000 53394000 5753421 5793069 5578753 Net sales 13 Cost of sales 15 Research & development expense 16 Selling, general & administrative expense 17 Total operating expenses 18 Operating income (loss) 19 Interest÷nd income 20 Interest expense 21 Other income (expense), net 22 Other income (expenses), net 23 Income (loss) before provision for income taxes 24 Current federal income tax expense (benefit) 25 Deferred federal income tax expense (benefit) 26 Total federal income tax expense (benefit) 27 Current state income tax expense (benefit) 28 Deferred state income tax expense (benefit) 29 Total state income tax expense (benefit) 30 Current foreign income tax expense (benefit) 31 Deferred foreign income tax expense (benefit) 32 Total foreign income tax expense (benefit) 33 Provision for (benefit from) income taxes 34 Net income (loss) 35 Weighted average shares outstanding basic 36 Weighted average shares outstanding - diluted 37 Year end shares outstanding 38 Net earnings (loss) per common share-basic 39 Net earnings (loss) per common share-diluted 40 Cash dividends declared per common share 41 Number of full time employees 42 Number of common stockholders 43 Foreign currency translation adjustments 261000 1671000 -16000 1655000 5738000 48351000 5217242 5251692 5126201 2138000 15685000 45687000 5470820 5500281 5336166 123000 25333 224000 116000 25924 411000 75000 Mergent Online. (2017). Apple. Retrieved from: 2017 Balance Sheet 2017 Income Statement 2017 Cash Flow Stock Prices