compose a summation as to how amazon.com is performing in relation to its compet
ID: 2420731 • Letter: C
Question
compose a summation as to how amazon.com is performing in relation to its competitors based on the spreadsheet.
Margins % of Sales
2012-12
2013-12
2014-12
Industry trends/averages
Revenue
100.00
100.00
100.00
100.00
COGS
75.25
72.77
70.52
67.58
Gross Margin
24.75
27.23
29.48
32.42
SG&A
15.92
17.26
18.71
19.00
R&D
7.47
8.82
10.42
11.54
Other
0.26
0.15
0.15
0.17
Operating Margin
1.11
1.00
0.20
1.70
Net Int Inc & Other
-0.22
-0.32
-0.32
-0.65
EBT Margin
0.89
0.68
-0.12
1.0
Profitability
2012-12
2013-12
2014-12
Industry averages
Net Margin %
-0.06
0.37
-0.27
0.33
Asset Turnover (Average)
2.11
2.05
1.88
2.08
Return on Assets %
-0.13
0.75
-0.51
0.68
Financial Leverage (Average)
3.97
4.12
5.07
4.52
Return on Equity %
-0.49
3.06
-2.35
2.88
Return on Invested Capital %
-0.05
2.55
-0.68
3.35
Interest Coverage
6.91
4.59
0.47
3.53
Liquidity/Financial Health
2012-12
2013-12
2014-12
Industry 6 years averages
Current Ratio
1.12
1.07
1.12
1.08
Quick Ratio
0.78
0.75
0.82
0.75
Financial Leverage
3.97
4.12
5.07
4.52
Debt/Equity
0.47
0.53
1.16
0.66
Current Valuation
AMZN
Industry Avg
S&P 500
AMZN 5Y Avg*
Data as of 12/31/2015, *Price/Cash Flow uses 3-year average.
Price/Earnings
975.2
34.7
19.3
610.7
Price/Book
25.5
7.8
2.7
15.2
Price/Sales
3.2
1.9
1.8
2.1
Price/Cash Flow
32.6
9.3
11.7
28.8
Dividend Yield %
—
0.2
2.2
—
Price/Fair Value
Premium
—
—
—
Margins % of Sales
2012-12
2013-12
2014-12
Industry trends/averages
Revenue
100.00
100.00
100.00
100.00
COGS
75.25
72.77
70.52
67.58
Gross Margin
24.75
27.23
29.48
32.42
SG&A
15.92
17.26
18.71
19.00
R&D
7.47
8.82
10.42
11.54
Other
0.26
0.15
0.15
0.17
Operating Margin
1.11
1.00
0.20
1.70
Net Int Inc & Other
-0.22
-0.32
-0.32
-0.65
EBT Margin
0.89
0.68
-0.12
1.0
Explanation / Answer
Margins % of Sales 2012-12 2013-12 2014-12 Industry trends/averages Analysis Revenue 100 100 100 100 The company is at par with the Industry all the years COGS 75.25 72.77 70.52 67.58 Cost of Goods sold is at decreasing trend which is a good sign how evr it is more than the industry average. Gross Margin 24.75 27.23 29.48 32.42 Contribution margin is at increasing trend which is a good sign how ever it is less than the industry average and neededs further improvement. SG&A 15.92 17.26 18.71 19 SG&A is at increasing trend which is not a good sign how ever it is less than the industry average and may be due to inflation effect. R&D 7.47 8.82 10.42 11.54 R&D is at increasing trend which is a good sign that company is thinking of betterment in production processes how ever it is less than the industry average . Other 0.26 0.15 0.15 0.17 others is at decreasing trend which is a good sign and also less than industry standard and hence be appreciated.. Operating Margin 1.11 1 0.2 1.7 it is at decreasing trend which is not a good sign and also far less than industry standard and hence be may be rethink of boosting the same. Net Int Inc & Other -0.22 -0.32 -0.32 -0.65 it is at increasing trend which is not a good sign that company. how ever it is less than the industry average . EBT Margin 0.89 0.68 -0.12 1 EBT margin is also at decreasing trend and needs to be rectified. Profitability 2012-12 2013-12 2014-12 Industry averages Net Margin % -0.06 0.37 -0.27 0.33 net Margin is also at fluctuatinh trend and needs to be rectified Also it is far less than the industry standard. Asset Turnover (Average) 2.11 2.05 1.88 2.08 It is of a good sign as it is at decreasing trend Return on Assets % -0.13 0.75 -0.51 0.68 It is of a bad sign as it is at decreasing trend Financial Leverage (Average) 3.97 4.12 5.07 4.52 It is highlt volatile Return on Equity % -0.49 3.06 -2.35 2.88 It is also poorly performed Return on Invested Capital % -0.05 2.55 -0.68 3.35 It is also poorly performed Interest Coverage 6.91 4.59 0.47 3.53 It must be very high and hence it is also poorly performed. Liquidity/Financial Health 2012-12 2013-12 2014-12 Industry 6 years averages Current Ratio 1.12 1.07 1.12 1.08 It is of good sign as it is having higher back up of currennt assets than liabilities Quick Ratio 0.78 0.75 0.82 0.75 It is of good sign as it is having higher back up of Quick assets than liabilities Financial Leverage 3.97 4.12 5.07 4.52 It is highlt volatile Debt/Equity 0.47 0.53 1.16 0.66 It is good as it is having high debt and will lead to tax savings and fixed expenses Current Valuation AMZN Industry Avg S&P 500 AMZN 5Y Avg* Data as of 12/31/2015, *Price/Cash Flow uses 3-year average. Price/Earnings 975.2 34.7 19.3 610.7 It is of good sign as PE ratio is very high Price/Book 25.5 7.8 2.7 15.2 It is of good sign as PB ratio is very high Price/Sales 3.2 1.9 1.8 2.1 It is of good sign as PS ratio is very high Price/Cash Flow 32.6 9.3 11.7 28.8 It is of good sign as PC ratio is very high Dividend Yield % — 0.2 2.2 — it seems poor Price/Fair Value Premium — — —
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.