Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Select a financial ratio measurement and describe its purpose and importance of the company Amazon . What is the ratio measuring? Is a higher ratio
Select a financial ratio measurement and describe its purpose and importance of the company Amazon.
What is the ratio measuring?
Is a higher ratio good or bad?
Is there a level that would indicate that Amazon is healthy in the measured area?
Growth Profitability and Financial Ratios for Amazon.com Inc | |||||||||||
Financials | |||||||||||
2007-12 | 2008-12 | 2009-12 | 2010-12 | 2011-12 | 2012-12 | 2013-12 | 2014-12 | 2015-12 | 2016-12 | TTM | |
Revenue USD Mil | 14,835 | 19,166 | 24,509 | 34,204 | 48,077 | 61,093 | 74,452 | 88,988 | 107,006 | 135,987 | 150,124 |
Gross Margin % | 22.6 | 22.3 | 22.6 | 22.3 | 22.4 | 24.8 | 27.2 | 29.5 | 33 | 35.1 | 36 |
Operating Income USD Mil | 655 | 842 | 1,129 | 1,406 | 862 | 676 | 745 | 178 | 2,233 | 4,186 | 3,462 |
Operating Margin % | 4.4 | 4.4 | 4.6 | 4.1 | 1.8 | 1.1 | 1 | 0.2 | 2.1 | 3.1 | 2.3 |
Net Income USD Mil | 476 | 645 | 902 | 1,152 | 631 | -39 | 274 | -241 | 596 | 2,371 | 1,922 |
Earnings Per Share USD | 1.12 | 1.49 | 2.04 | 2.53 | 1.37 | -0.09 | 0.59 | -0.52 | 1.25 | 4.9 | 3.93 |
Dividends USD | |||||||||||
Payout Ratio % * | |||||||||||
Shares Mil | 424 | 432 | 442 | 456 | 461 | 453 | 465 | 462 | 477 | 484 | 489 |
Book Value Per Share * USD | 2.88 | 6.23 | 11.84 | 15.22 | 17.07 | 18.04 | 19.8 | 22.23 | 26.39 | 37.28 | 48.32 |
Operating Cash Flow USD Mil | 1,405 | 1,697 | 3,293 | 3,495 | 3,903 | 4,180 | 5,475 | 6,842 | 11,920 | 16,443 | 17,057 |
Cap Spending USD Mil | -224 | -333 | -373 | -979 | -1,811 | -3,785 | -3,444 | -4,893 | -4,589 | -6,737 | -8,209 |
Free Cash Flow USD Mil | 1,181 | 1,364 | 2,920 | 2,516 | 2,092 | 395 | 2,031 | 1,949 | 7,331 | 9,706 | 8,848 |
Free Cash Flow Per Share * USD | 2.79 | 3.16 | 6.61 | 5.52 | 3.33 | 0.87 | 0.84 | 2.33 | 11.41 | 17.76 | |
Working Capital USD Mil | 1,450 | 1,411 | 2,433 | 3,375 | 2,594 | 2,294 | 1,645 | 3,238 | 2,575 | 1,965 | |
Key Ratios -> Profitability | |||||||||||
Margins % of Sales | 2007-12 | 2008-12 | 2009-12 | 2010-12 | 2011-12 | 2012-12 | 2013-12 | 2014-12 | 2015-12 | 2016-12 | TTM |
Revenue | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
COGS | 77.4 | 77.72 | 77.43 | 77.65 | 77.56 | 75.25 | 72.77 | 70.52 | 66.96 | 64.91 | 64.02 |
Gross Margin | 22.6 | 22.28 | 22.57 | 22.35 | 22.44 | 24.75 | 27.23 | 29.48 | 33.04 | 35.09 | 35.98 |
SG&A | 12.61 | 12.62 | 12.49 | 12.86 | 14.28 | 15.92 | 17.26 | 18.71 | 19.07 | 20.06 | 20.87 |
R&D | 5.51 | 5.39 | 5.06 | 5.07 | 6.05 | 7.47 | 8.82 | 10.42 | 11.72 | 11.83 | 12.68 |
Other | 0.06 | -0.13 | 0.42 | 0.31 | 0.32 | 0.26 | 0.15 | 0.15 | 0.16 | 0.12 | 0.12 |
Operating Margin | 4.42 | 4.39 | 4.61 | 4.11 | 1.79 | 1.11 | 1 | 0.2 | 2.09 | 3.08 | 2.31 |
Net Int Inc & Other | 0.03 | 0.31 | 0.13 | 0.27 | 0.15 | -0.22 | -0.32 | -0.32 | -0.62 | -0.22 | -0.12 |
EBT Margin | 4.45 | 4.7 | 4.74 | 4.38 | 1.94 | 0.89 | 0.68 | -0.12 | 1.47 | 2.86 | 2.18 |
Profitability | 2007-12 | 2008-12 | 2009-12 | 2010-12 | 2011-12 | 2012-12 | 2013-12 | 2014-12 | 2015-12 | 2016-12 | TTM |
Tax Rate % | 27.88 | 27.41 | 21.79 | 23.51 | 31.16 | 78.68 | 31.82 | 60.59 | 36.61 | 40.84 | |
Net Margin % | 3.21 | 3.37 | 3.68 | 3.37 | 1.31 | -0.06 | 0.37 | -0.27 | 0.56 | 1.74 | 1.28 |
Asset Turnover (Average) | 2.74 | 2.59 | 2.22 | 2.1 | 2.18 | 2.11 | 2.05 | 1.88 | 1.78 | 1.83 | 1.96 |
Return on Assets % | 8.78 | 8.72 | 8.15 | 7.07 | 2.86 | -0.13 | 0.75 | -0.51 | 0.99 | 3.19 | 2.51 |
Financial Leverage (Average) | 5.42 | 3.11 | 2.63 | 2.74 | 3.26 | 3.97 | 4.12 | 5.07 | 4.89 | 4.32 | 3.78 |
Return on Equity % | 58.48 | 33.34 | 22.75 | 19.01 | 8.63 | -0.49 | 3.06 | -2.35 | 4.94 | 14.52 | 9.67 |
Return on Invested Capital % | 22.02 | 21.7 | 20.65 | 17.56 | 7.6 | -0.05 | 2.55 | -0.68 | 3.31 | 8.42 | 7.76 |
Interest Coverage | 9.57 | 13.69 | 35.15 | 39.38 | 15.37 | 6.91 | 4.59 | 0.47 | 4.42 | 9.04 | 7.15 |
Key Ratios -> Growth | |||||||||||
2007-12 | 2008-12 | 2009-12 | 2010-12 | 2011-12 | 2012-12 | 2013-12 | 2014-12 | 2015-12 | 2016-12 | Latest Qtr | |
Revenue % | |||||||||||
Year over Year | 38.5 | 29.19 | 27.88 | 39.56 | 40.56 | 27.07 | 21.87 | 19.52 | 20.25 | 27.08 | 24.84 |
3-Year Average | 28.93 | 31.18 | 31.77 | 32.11 | 35.87 | 35.59 | 29.6 | 22.78 | 20.54 | 22.24 | |
5-Year Average | 30.41 | 29.49 | 28.77 | 32.14 | 35.03 | 32.72 | 31.18 | 29.42 | 25.62 | 23.12 | |
10-Year Average | 58.55 | 41.16 | 31.05 | 28.61 | 31.45 | 31.56 | 30.33 | 29.1 | 28.84 | 28.93 | |
Operating Income % | |||||||||||
Year over Year | 68.38 | 28.55 | 34.09 | 24.54 | -38.69 | -21.58 | 10.21 | -76.11 | 1154.49 | 87.46 | -51.13 |
3-Year Average | 14.14 | 24.91 | 42.64 | 29 | 0.79 | -15.71 | -19.08 | -40.89 | 48.93 | 77.78 | |
5-Year Average | 59.16 | 25.49 | 20.72 | 26.62 | 17.25 | 0.63 | -2.42 | -30.89 | 9.69 | 37.17 | |
10-Year Average | 26.56 | 10.66 | -8.66 | 17.85 | 26.82 | ||||||
Net Income % | |||||||||||
Year over Year | 150.53 | 35.5 | 39.85 | 27.72 | -45.23 | 297.82 | |||||
3-Year Average | -6.83 | 21.57 | 68.07 | 34.26 | -0.73 | -38.04 | 105.3 | ||||
5-Year Average | 78.81 | 8.92 | 26.26 | 27.13 | -15.74 | -12.35 | 30.31 | ||||
10-Year Average | 22.75 | 5.2 | 28.71 | ||||||||
EPS % | |||||||||||
Year over Year | 148.89 | 33.04 | 36.91 | 24.02 | -45.85 | 292 | -77.53 | ||||
3-Year Average | -6.95 | 21.05 | 65.5 | 31.21 | -2.76 | -38.45 | 102.51 | ||||
5-Year Average | 79.48 | 7.98 | 24.67 | 24.94 | -16.91 | -13.15 | 29.03 | ||||
10-Year Average | 22.12 | 4.06 | 26.97 | ||||||||
Key Ratios -> Cash Flow | |||||||||||
Cash Flow Ratios | 2007-12 | 2008-12 | 2009-12 | 2010-12 | 2011-12 | 2012-12 | 2013-12 | 2014-12 | 2015-12 | 2016-12 | TTM |
Operating Cash Flow Growth % YOY | 613 | 710 | |||||||||
Free Cash Flow Growth % YOY | -404 | ||||||||||
Cap Ex as a % of Sales | 1.51 | 1.74 | 1.52 | 2.86 | 3.77 | 6.2 | 4.63 | 5.5 | 4.29 | 4.95 | 5.47 |
Free Cash Flow/Sales % | 7.96 | 7.12 | 11.91 | 7.36 | 4.35 | 0.65 | 2.73 | 2.19 | 6.85 | 7.14 | 5.89 |
Free Cash Flow/Net Income | 2.48 | 2.11 | 3.24 | 2.18 | 3.32 | -10.13 | 7.41 | -8.09 | 12.3 | 4.09 | 4.6 |
Key Ratios -> Financial Health | |||||||||||
Balance Sheet Items (in %) | 2007-12 | 2008-12 | 2009-12 | 2010-12 | 2011-12 | 2012-12 | 2013-12 | 2014-12 | 2015-12 | 2016-12 | Latest Qtr |
Cash & Short-Term Investments | 47.99 | 44.83 | 46.09 | 46.61 | 37.88 | 35.17 | 30.99 | 31.95 | 30.27 | 31.15 | 24.44 |
Accounts Receivable | 10.87 | 9.95 | 7.15 | 8.44 | 10.17 | 10.33 | 11.87 | 10.3 | 9.81 | 10 | 9.17 |
Inventory | 18.5 | 16.83 | 15.72 | 17.03 | 19.75 | 18.53 | 18.45 | 15.23 | 15.65 | 13.74 | 13.11 |
Other Current Assets | 2.27 | 2.45 | 1.97 | 1.04 | 1.39 | 1.39 | |||||
Total Current Assets | 79.63 | 74.06 | 70.93 | 73.13 | 69.19 | 65.42 | 61.32 | 57.48 | 55.73 | 54.89 | 46.72 |
Net PP&E | 8.37 | 10.27 | 9.34 | 12.84 | 17.47 | 21.69 | 27.26 | 31.13 | 33.37 | 34.91 | 42.24 |
Intangibles | 3.82 | 7.19 | 13.04 | 10.17 | 10.29 | 10.07 | 8.22 | 6.09 | 5.74 | 4.54 | 4.85 |
Other Long-Term Assets | 8.17 | 8.48 | 6.7 | 3.85 | 3.04 | 2.83 | 3.2 | 5.31 | 5.15 | 5.66 | 6.19 |
Total Assets | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Accounts Payable | 43.1 | 43.23 | 40.58 | 42.83 | 44.09 | 40.91 | 37.68 | 30.2 | 31.17 | 30.35 | 24.42 |
Short-Term Debt | 0.71 | ||||||||||
Taxes Payable | |||||||||||
Accrued Liabilities | 14.17 | 13.15 | 12.73 | 12.35 | 14.84 | 17.46 | 16.65 | 17.99 | 15.87 | 16.47 | 15.97 |
Other Short-Term Liabilities | 2.89 | 3.34 | 4.76 | 5.72 | 5.77 | ||||||
Total Current Liabilities | 57.27 | 57.08 | 53.31 | 55.18 | 58.93 | 58.37 | 57.22 | 51.53 | 51.8 | 52.54 | 46.16 |
Long-Term Debt | 19.77 | 4.92 | 0.79 | 0.98 | 1.01 | 9.47 | 7.95 | 15.16 | 12.58 | 9.23 | 8.75 |
Other Long-Term Liabilities | 4.5 | 5.86 | 7.84 | 7.33 | 9.38 | 6.99 | 10.56 | 13.6 | 15.17 | 15.12 | 18.64 |
Total Liabilities | 81.54 | 67.86 | 61.94 | 63.48 | 69.31 | 74.84 | 75.73 | 80.29 | 79.55 | 76.88 | 73.55 |
Total Stockholders' Equity | 18.46 | 32.14 | 38.06 | 36.52 | 30.69 | 25.16 | 24.27 | 19.71 | 20.45 | 23.12 | 26.45 |
Total Liabilities & Equity | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Liquidity/Financial Health | 2007-12 | 2008-12 | 2009-12 | 2010-12 | 2011-12 | 2012-12 | 2013-12 | 2014-12 | 2015-12 | 2016-12 | Latest Qtr |
Current Ratio | 1.39 | 1.3 | 1.33 | 1.33 | 1.17 | 1.12 | 1.07 | 1.12 | 1.08 | 1.04 | 1.01 |
Quick Ratio | 1.03 | 0.96 | 1 | 1 | 0.82 | 0.78 | 0.75 | 0.82 | 0.77 | 0.78 | 0.72 |
Financial Leverage | 5.42 | 3.11 | 2.63 | 2.74 | 3.26 | 3.97 | 4.12 | 5.07 | 4.89 | 4.32 | 3.78 |
Debt/Equity | 1.12 | 0.2 | 0.05 | 0.09 | 0.18 | 0.47 | 0.53 | 1.16 | 1.06 | 0.79 | 0.33 |
Key Ratios -> Efficiency Ratios | |||||||||||
Efficiency | 2007-12 | 2008-12 | 2009-12 | 2010-12 | 2011-12 | 2012-12 | 2013-12 | 2014-12 | 2015-12 | 2016-12 | TTM |
Days Sales Outstanding | 13.58 | 14.59 | 13.51 | 13.74 | 15.78 | 17.73 | 19.93 | 21.29 | 20.53 | 19.81 | 17.19 |
Days Inventory | 33.01 | 31.84 | 34.33 | 36.92 | 40.1 | 43.76 | 45.28 | 45.69 | 47.23 | 44.87 | 40.06 |
Payables Period | 73.29 | 78.28 | 88.46 | 93.83 | 93.95 | 97.12 | 95.83 | 91.88 | 93.87 | 94.5 | 71.33 |
Cash Conversion Cycle | -26.7 | -31.85 | -40.62 | -43.17 | -38.06 | -35.63 | -30.62 | -24.9 | -26.12 | -29.82 | -14.08 |
Receivables Turnover | 26.88 | 25.02 | 27.01 | 26.57 | 23.13 | 20.59 | 18.31 | 17.15 | 17.78 | 18.42 | 21.23 |
Inventory Turnover | 11.06 | 11.46 | 10.63 | 9.89 | 9.1 | 8.34 | 8.06 | 7.99 | 7.73 | 8.13 | 9.11 |
Fixed Assets Turnover | 29.67 | 27.44 | 22.86 | 18.47 | 14.08 | 10.65 | 8.27 | 6.38 | 5.52 | 5.34 | 4.82 |
Asset Turnover | 2.74 | 2.59 | 2.22 | 2.1 | 2.18 | 2.11 | 2.05 | 1.88 | 1.78 | 1.83 | 1.96 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started