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   ...
3. Job design (Connect/Perform) Select the best answer based on your knowledge of different approaches to...
3. Job design (Connect/Perform) Select the best answer based on your knowledge of different approaches to job design. An online clothing retailer wants to provide superior customer service in its call centers. Based on an analysis of customer satisfaction surveys, the company decided to give customer service representatives as much discretion as possible in terms of taking appropriate actions to delight customers. This included making exceptions to policies on returns and refunds among other things. This is an example of...
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...
Consider the following SQL script. QUESTION: Which best completes the following statement(Select 3): Table SELECT TABLE...
Consider the following SQL script. QUESTION: Which best completes the following statement(Select 3): Table SELECT TABLE NAME is in SELECT NORMAL FORM and is SELECT FORM TYPE ***Note: The answer choices are at the bottom Assume also that even if there are some issues you cannot resolve them. Report on the current state of the database based on the code that you have been provided. CREATE TABLE ASSIGNMENT ( ASSIGN_NUM int, ASSIGN_DATE datetime, PROJ_NUM varchar(3), EMP_NUM varchar(3), ASSIGN_HOURS float(8), ASSIGN_CHG_HOUR...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT