Question

In: Finance

Select the best answer. Based upon a comparison of Table 1 (2011 figures) and Table 2...

Select the best answer. Based upon a comparison of Table 1 (2011 figures) and Table 2

(2017 figures), it is fair to say______________.

Table 1: Selected Financials

Discount Retailing Industry 2011

($ in '000s except per share) Amazon CostCo Target Walmart

Net Sales or Revenues $48,077 $88,915 $69,865 $446,950

Gross Profit Margin-Merch 11.2% 10.7% 30.1% 24.5%

Operating Margin 1.8% 2.7% 7.6% 5.9%

Net Margin 1.3% 1.6% 4.2% 3.7%

EPS $1.37 $3.30 $4.28 $4.52

Return on Average Assets 2.8% 5.8% 6.5% 8.8%

Table 2: Discount Retailing Industry 2017

($ in 000s) except per share Amazon CostCo Target Walmart

Net Sales or Revenues $177,866 $129,025 $71,879 $500,343

Gross Profit Margin-Merch 5.6% 11.3% 28.9% 25.4%

Operating Margin 2.3% 3.2% 6.0% 4.1%

Net Margin 1.7% 2.1% 4.1% 2.0%

EPS $6.32 $6.08 $5.33 $3.28

Return on Average Assets 2.8% 7.7% 7.7% 4.9%


A. Walmart had a competitive advantage in 2017 versus Amazon, CostCo, and Target

B. Based upon ROAA, Costco and Target were at competitive disadvantages in 2011 but had

become the industry leaders versus their rivals - Amazon, and Walmart by 2017.

C. Amazon's astonishing 24% average annual revenue growth from 2011-2017 shows that the

company has a competitive advantage relative to its major competitors - Walmart, Target and

Costco.

D. Walmart maintained its competitive advantage, but Amazon narrowed "the gap" between the

two companies significantly over the period.

Solutions

Expert Solution

Amazon's astonishing 24% average annual revenue growth from 2011-2017 shows that the company has a competitive advantage relative to its major competitors - Walmart, Target and Costco. (which is Option C)

____

Explanation:

The average annual growth rate can be calculated with the use of Rate function/formula of EXCEL/Financial calculator. The function/formula for Rate is Rate(Nper,PMT,-PV,FV) where Nper = Period, PMT = Payment (if any), PV = Present Value and FV = Future Value.

Here, Nper will remain constant at 6 Years (2017 - 2011) and PMT will be 0 for all the companies. We will take sales value in 2011 as the PV and the sales value in 2017 as FV.

Now, we can calculate Average Annual Growth Rate for each company as below:

Amazon = RATE(6,0,-48077,177866) = 24.36% or 24%

Costco = RATE(6,0,-88915,129025) = 6.40% or 6%

Target = RATE(6,0,-69865,71879) = .47% or .5%

Walmart = RATE(6,0,-446950,500343) = 1.90% or 2%

Based on the above calculations, it is clear that Amazon's sales has increased considerably as compared to its competitors indicating its competitive advantage over the rivals. It also indicates that Amazon has increased its market share over the years while its rivals have not shown any significant improvement in their market share.


Related Solutions

1. Read each question. 2. Answer based upon your knowledge of the chapter and your own...
1. Read each question. 2. Answer based upon your knowledge of the chapter and your own experience. 3. Indicate by number (1 or 2) which question you are answering first. 4. Proofread your answer--demonstrate your best writing ability. CHAPTER 12 Effective Business Presentations 1. What role do visuals play in business presentations? 2. The four Ps: Planning, preparing, practicing, and presenting, are very important to presentations. Explain how you understand each of them. Is one more important than the others?
2) Please answer questions A and B based on the following Best Subsets Regression. Best Subsets...
2) Please answer questions A and B based on the following Best Subsets Regression. Best Subsets Regression: Sales versus Price, Promotional exp, Quality Response is Sales P r o m o t i o n Q a u P l a r l i e i Mallows c x t Vars R-Sq R-Sq(adj)       Cp S e p y    1 81.3       79.8 6.1 7.8239 X    1 58.0       54.5 26.2 11.734 X    1   9.5        2.0 68.1 17.221 X   ...
Based upon the readings and the videos in this module, select one of the following questions...
Based upon the readings and the videos in this module, select one of the following questions to respond to for this module for your initial response. Try to pick a question of personal and/or of professional interest to you. Copy and paste the question you select in bold type as part of your initial response so that everyone can see your question choice. Discuss the potential view that the costs of establishing and maintaining accounting standards enforcement bodies in every...
Select the best answer for each question. 1. In the short run, a firm will shut...
Select the best answer for each question. 1. In the short run, a firm will shut down if (a) the market price is less than the firm’s average total cost. (b) the market price is less than the minimum of the firm’s average variable cost. (c) the market price is less than the quantity produced. (d) the market price is less than the number of firms in the market. 2. Suppose a firm in a perfectly competitive market is making...
Please answer the following question: 1) Based upon the knowledge relating to fraud examination and the...
Please answer the following question: 1) Based upon the knowledge relating to fraud examination and the fraud triangle, “Understand the Person, Understand the Fraud” concept, means to you. 2) Discuss how you, a fraud examiner, would approach and conduct an interview of a fraud suspect(s) in a case you have been assigned. Remember to include techniques, theory and approaches in your answer. Make sure your answer demonstrates your understanding of the fraud triangle and fraud examination.
Select best choice and breifly explain your answer. 1. Smallest Radius? Sc Ti V 2. Greatest...
Select best choice and breifly explain your answer. 1. Smallest Radius? Sc Ti V 2. Greatest Volume S2- Ar Ca2+
Based on the EViews result in Table 1, answer the following questions. Table 1: Estimated Regression...
Based on the EViews result in Table 1, answer the following questions. Table 1: Estimated Regression Result Dependent Variable: LGDP Method: Least Squares Sample: 2000Q1 2012Q4 Included observations: 52 Variable Coefficient Std. Error t-Statistic Prob. LM2 0.796910 0.032383 24.60868 0.0000 LREER -0.060125 0.065220 -0.921892 0.3613 LSDR 0.051745 0.074618 0.693465 0.4914 LTBR 0.029174 0.007715 3.781436 0.0004 C 2.795406 0.427355 6.541183 0.0000 R-squared 0.986591 Mean dependent var 13.28409 Adjusted R-squared 0.985450 S.D. dependent var 0.429315 S.E. of regression 0.051786 Akaike info criterion...
Based on the EViews result in Table 1, answer the following questions. Table 1: Estimated Regression...
Based on the EViews result in Table 1, answer the following questions. Table 1: Estimated Regression Result Dependent Variable: LGDP Method: Least Squares Sample: 2000Q1 2012Q4 Included observations: 52 Variable Coefficient Std. Error t-Statistic Prob.   LM2 0.796910 0.032383 24.60868 0.0000 LREER -0.060125 0.065220 -0.921892 0.3613 LSDR 0.051745 0.074618 0.693465 0.4914 LTBR 0.029174 0.007715 3.781436 0.0004 C 2.795406 0.427355 6.541183 0.0000 R-squared 0.986591     Mean dependent var 13.28409 Adjusted R-squared 0.985450     S.D. dependent var 0.429315 S.E. of regression 0.051786     Akaike info criterion...
Select one answer as the best response and explain your reason for the selection. 1. Generally...
Select one answer as the best response and explain your reason for the selection. 1. Generally speaking technological progress leads to higher output purely because it raises the productivity of capital purely because it raises the steady-state capital stock because it raises both the productivity of capital and the steady state capital stock purely because it increases the capital stock for a given production function purely because it raises the output produced by a given capital stock Explain your answer:...
Select the best answer for the question. 1.   Which of the following statements about engine configurations...
Select the best answer for the question. 1.   Which of the following statements about engine configurations is true?         A. V-type engines are less expensive to overhaul than inline engines.    B. The most popular diesel engine configuration is the V-type engine.    C. In an inline engine, the cylinders are set at an angle to the crankshaft.    D. V-type engines are normally shorter in length and lower in height than inline engines.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT