SOLVE FOR : INVENTORY TURNOVER, DSO, DEBT RATIO, P/E

AutoSave OFF AOFC. Chapter 04 HW (1) Insert Draw Home - Page Layout Formulas Data Review View Tell me Share Comments Calibrl (Body) v 11 X [G v AA 2 Wrap Text General 2Y0 v Paste BIU Av = = = - Merge & Center v Insert Delete Format Y Conditional Format Cell Formatting es Table Styles - Sort & v Filter Find Select Analyze Data V D17 fx C D E F G . K TL M N 0 P R R 5 1.352669 1.325684 Current Ratio Quick Ratio Inventory Turnover OSO Debt Ratio ROL P/E 14.20 In Millions of USD (except for per share items) 2 Cash and Short Term Investments 3 Total Receivable Net 4 Total Inventory 5 Other Current Arts E Total Current Assets 7 Property/Plant/Equipment, Total Gross 8 Goodwill, Net 9 Intangibles, Net 10 Lang Term Investments 11 Other Long Term Assets 12 Total Assets 13 Accounts Payable 14 Nccruals 15 Notes Payable/Short Term Debt 16 Other Ourrentities 17 Total Current Liabilities 12 Lang Term Debt 19 Other Libilities 20 Total Liabilities 21 Comman Stock 22 Retained Earnings Acumulated Deficit) 23 Other Equity 24 Tot quity 25 Total Lisbilities & Shareholders' Equity 26 27 28 In Millions of USD lexcept for per share items) 29 Total Revenue 30 Cost of Revenue, Total 31 Seling/General/Admin Expenses 32 Research & Development 33 Total Other incorre 34 EBIT 35 Interst Expense 36 Income Before Tax 37 Income Tax Expen 38 Net Income 39 Ao Shares 40 EPS 41 Stock Price As of 2016-09-24 57,155.00 15,754,00 2,232.00 21,828.00 106,869.00 27.010.00 5,414.00 3,206.00 170,430.00 8,757.00 321,680.00 37,294.00 22,027.00 8,205.00 11,500.00 79,000.00 75,427.00 39,000.00 193,437,00 31,251.00 96,364.00 634 120,249.00 321,686.00 52 weeks ending 2016-09-24 215,639.00 131,376.00 14,194.00 10,045.00 1348 61,372.00 0 61,372.00 15,685.00 45,687.00 5,470.22 R.35 $170 Probler 1 Chapter 4 Apple Assignment + Ready # 2 - + 100%