001 [Compatibility Model Microsoft Excel Data Review view Insert Page Layout For
ID: 2769352 • Letter: 0
Question
001 [Compatibility Model Microsoft Excel Data Review view Insert Page Layout Formulas Home General Normal .0g Conditional Format as Neutral Format painter Formatting Table Current Assets A7 3 Amazon company 204 2013 2012 2011 2010 2009 7 Current Assets 8 Current Liabilities 3 Net Sales 10 Cost of Goods Sold 11 Net Income 12 Average (Net) Receivables for the year 13 Average inventories for the year 14 Average Total Assets 15 Average common Stockholder's Equity 16 Average current Liabilities 17 Average Total Liabilities 18 Total Assets 22 Total Liabilities 26 Income Taxes 27 Interest Expense 28 Cash Provided by operating Activities 29 Capital Expenditures 30 Cash Dividends 31 Common Stockholders' Equity 32 (Net) Receivables 33 Inyentories 34 Preferred Stockholder's Dividends 40 Current Ratio 41 Debt Ratio 42 Times Interest Earned 43 Gross Profit Margin 44 Net Profit Margin 45 Return on Equity 46 Price Earnings Ratio 47 Earnings per share (EPS) 48 Free Cash Flow 49 Stock Price at Vlof each year Dl Data & Ratios Calculation Insert Delete Format e AutoSum A 2 Clear Filter Select 1 AM 4/29/2016Explanation / Answer
current ratio=CA/CL CA 9900 CL 4400 current ratio=CA/CL 2.25 QR=(CA-inventories)/CL CA 9900 inventories 4200 5700 CL 4400 QR=(CA-inventories)/CL 1.30 Times int earned EBIT 4500 Interest 1200 Times int earned 3.75 Asset Turnover = Sales or Revenues / Total Assets Sales 19000 total assets 23700 Asset turnover 0.80 Working capital (CA-CL) 5500 Working capital turnover 3.45 Net income 1860 Total avg assets 22850 Reurn on assets 8.14% Profit Margin Sales 19000 COGS 12000 Gross Margin 7000 Gross Margin ratio 36.84% Margin 1860 Margin ratio 9.79%
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.