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

90.2K

Verified Solution

Question

Finance

Below are some key financial ratios for Amazon and Walmart, twocompetitors in the retail market, over a three year period. Pickone of the financial ratios, complete a time-series and crosssectional 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%

Answer & Explanation Solved by verified expert

4.4 Ratings (685 Votes)

Inventory turnover ratio cost of goods sold average inventory Days in inventory 365 inventory turnover ratio Days in inventory is a measure of how fast the inventory is moving In other words it measures See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

Below are some key financial ratios for Amazon and Walmart, twocompetitors in the retail market, over a three year period. Pickone of the financial ratios, complete a time-series and crosssectional analysis.Amazon12-201712-201612-2015Days in Inventory36.5937.4139.78Receivables Turnover16.5418.4217.78Asset Turnover1.661.831.78Current Ratio1.041.041.08Debt/Equity1.370.791.06Return on Equity12.91%14.52%4.94%Interest Coverage5.499.044.42Profit Margin1.71%1.74%0.56%Walmart01-201801-201701-2016Days in Inventory42.4444.2145.30Receivables Turnover87.4084.8077.75Asset Turnover2.482.442.39Current Ratio0.760.860.93Debt/Equity0.470.540.55Return on Equity12.67%17.23%18.15%Interest Coverage7.499.669.49Profit Margin1.97%2.81%3.05%

	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%