Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Sector Reform And Privatization In Transition Economies

Authors: John Doukas, Victor Murinde, Clas Wihlborg

1st Edition

044482653X, 9780444826534

Students also viewed these Finance questions