Question

In: Accounting

Below are some key financial ratios for Amazon and Walmart, two competitors in the retail market,...

Below are some key financial ratios for Amazon and Walmart, two competitors in the retail market, over a three year period. Pick one of the financial ratios, complete a time-series and cross sectional analysis.

Amazon
12-2017 12-2016 12-2015
Days in Inventory 36.59 37.41 39.78
Receivables Turnover 16.54 18.42 17.78
Asset Turnover 1.66 1.83 1.78
Current Ratio 1.04 1.04 1.08
Debt/Equity 1.37 0.79 1.06
Return on Equity 12.91% 14.52% 4.94%
Interest Coverage 5.49 9.04 4.42
Profit Margin 1.71% 1.74% 0.56%
Walmart
01-2018 01-2017 01-2016
Days in Inventory 42.44 44.21 45.30
Receivables Turnover 87.40 84.80 77.75
Asset Turnover 2.48 2.44 2.39
Current Ratio 0.76 0.86 0.93
Debt/Equity 0.47 0.54 0.55
Return on Equity 12.67% 17.23% 18.15%
Interest Coverage 7.49 9.66 9.49
Profit Margin 1.97% 2.81% 3.05%

When responding to a peers, make at least 2 points about the results of their analysis.

Solutions

Expert Solution

1)Inventory turnover ratio = cost of goods sold / average inventory

2)Days in inventory = 365 / inventory turnover ratio

3)Days in inventory is a measure of how fast the inventory is moving. means, it measures how many days the average inventory is held during the year. It indicates the efficiency of inventory management. A higher ratio means that the average inventory is relatively high, and the average inventory is sold less number of times during the year. A lower ratio means that the average inventory is relatively low, and the average inventory is sold more number of times during the year

4)the days in inventory of Amazon is decreasing which leads to amazon managing its inventory more efficiently.

5)the days in inventory of Walmart has been decreasing. This means that Walmart has been managing its inventory more efficiently.

6)The days in inventory of Amazon is significantly lower than that of Walmart. This means that Amazon manages its inventory much more efficiently than Walmart.


Related Solutions

Below are some key financial ratios for Amazon and Walmart, two competitors in the retail market,...
Below are some key financial ratios for Amazon and Walmart, two competitors in the retail market, over a three year period. Pick one of the financial ratios, complete a time-series and cross sectional analysis. Amazon 12-2017 12-2016 12-2015 Days in Inventory 36.59 37.41 39.78 Receivables Turnover 16.54 18.42 17.78 Asset Turnover 1.66 1.83 1.78 Current Ratio 1.04 1.04 1.08 Debt/Equity 1.37 0.79 1.06 Return on Equity 12.91% 14.52% 4.94% Interest Coverage 5.49 9.04 4.42 Profit Margin 1.71% 1.74% 0.56% Walmart...
Compare and contrast Walmart ratios with the industry ratios. following the table below. Ratios Walmart (2019)...
Compare and contrast Walmart ratios with the industry ratios. following the table below. Ratios Walmart (2019) Industry (2019) Current Ratio 0.8 1.10 Debt to Equity Ratio 0.97 1.54 Return on Assets 2.33 5.41 Return on Equity 7.04 15.70 Inventory Turnover 8.7 18 Asset Turnover 2.33 65
Using the following table of ratios of Walmart, Amazon, and Target, discuss the variation in return...
Using the following table of ratios of Walmart, Amazon, and Target, discuss the variation in return to equity of the three firms. What is driving the variation (financial/operational) and relate you answer to the firms' business(es)? Target Amazon Walmart 2015 2016 2017 2015 2016 2017 2015 2016 2017 Revenue (Mil) 73,785 69,495 71,879 107,006 135,987 177,866 482,130 485,873 500,343 % of Sales Revenue 100 100 100 100 100 100 100 100 100 COGS 70.8 70.72 71.13 20.51 22.14 22.87 74.87...
write a summary of the results for the Marketability Ratios for Walmart and Target Market to...
write a summary of the results for the Marketability Ratios for Walmart and Target Market to Book: Target -30.24, Wal-Mart:-17.07 P/E: Target: $14.80, Wal-Mart: $40.86 Dividend Yield: Target: 0.22% Wal-Mart: 0.21%
collect and analyze relevant background data on the market and competitors for Amazon Inc.
collect and analyze relevant background data on the market and competitors for Amazon Inc.
What is the stock price, and the market capitalization of the following companies Amazon / Walmart...
What is the stock price, and the market capitalization of the following companies Amazon / Walmart / Apple/ IBM / Ford / Tesla / Google ( Alphabet ) now. What was it five years ago? What was is ten years ago?
What are some key differences in the financial ratios for small banks versus large banks?
What are some key differences in the financial ratios for small banks versus large banks?
RATIOS RETAIL WALMART TARGET Profitability Ratios (%) Gross Margin 16.94 25.37 25.82 EBITD Margin 4.66 9.53...
RATIOS RETAIL WALMART TARGET Profitability Ratios (%) Gross Margin 16.94 25.37 25.82 EBITD Margin 4.66 9.53 7.15 Operating Margin 2.51 4.32 5.16 Pretax Margin 2.97 3.02 4.07 Effective Tax Rate Financial Strength Quick Ratio 0.22 0.20 0.30 Current Ratio 0.76 0.95 LT Debt to Equity 47.29 96.65 Total Debt to Equity 0.15 59.70 98.96 Interest Coverage Valuation Ratios P/E Ratio 26.56 11.47 Price to Sales (P/S) 0.4 0.64 0.56 Price to Book (P/B) 5.42 4.04 3.37 Price to Tangible Book...
Describe key financial ratios and its benchmark for a corporation(atleast 10).Describe some limitation of financial ratio...
Describe key financial ratios and its benchmark for a corporation(atleast 10).Describe some limitation of financial ratio analysis.Describe enterprise value in detail.which financial ratio do you think are most important when evaluating a company? how can a company improve its gross profit margin and net profit margin? how can a company improve its ROA and ROE? how can debt be dangerous for a company? why should a company have a lean balance sheet? how does a company show liquidity on the...
1. Given below are some of the ratios for the year 2012 for Two Store A...
1. Given below are some of the ratios for the year 2012 for Two Store A and B. Ratios Store A Store B Industry Average Current 2.96:1 2.05:1 1.70:1 Acid-Test 1.02:1 1.34:1 0.75:1 Accounts receivable turnover 8 times 10 times 12 times Inventory turnover 4.5 times 6 times 10 times A. Comment on the current ratio of Store A and B. B. Comment on the acid test ratio of Store A and B. C. Comment on the accounts receivable turnover...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT