Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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% |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started