In: Accounting
Locate the audited financial statements in the 2019 Walmart Annual Report and 2019 Target Annual Report.
Perform the following ratios: Current, Quick, A/R Turnover/Inventory Turnover/Debt to Equity, times interest earned, gross profit, profit margin, return on assets, return on sales
| $ billion | $ billion | ||
| Walmart | Target | ||
| Current assets | 61.897 | 12.52 | |
| Current liability | 77.477 | 15.01 | |
| Inventory | 44.27 | 9.50 | |
| Turnover | 514.40 | 75.36 | |
| cost of goods sold | 385.30 | 53.30 | |
| Accounts receivable | - | - | |
| Debt | 50.20 | 12.23 | |
| Equity | 79.63 | 11.30 | |
| EBIT | 21.96 | 4.11 | |
| Interest expenses | 2.40 | 0.48 | |
| Gross profit- Sales- COGS | 129.10 | 22.06 | |
| Net profit | 6.67 | 2.94 | |
| Operating profit | 21.95 | ||
| Total assets | 219.30 | 41.29 | |
| 1 | Current ratio- (Current Assets/ Current Liability) | 0.80 | 0.83 |
| 2 | Quick ratio- ((Current assets- inventory)/ Current liability) | 0.23 | 0.20 |
| 3 | Inventory Turnover- cost of goods sold / Inventory | 8.70 | 5.61 |
| 4 | AR turnover ratio- Credit sales/ AR | - | - |
| 5 | Debt Equity- Debt/ Equity | 0.63 | 1.08 |
| 6 | times interest earned ratio- EBIT/ Interest | 9.17 | 8.62 |
| 7 | GP Ratio- GP/ COGS | 0.34 | 0.41 |
| 8 | Net Profit ratio- Net profit/ COGS | 0.02 | 0.06 |
| 9 | Profit Margin- Profit/ Sales | 0.01 | 0.04 |
| 10 | Return on assets- Net profit/ Total Assets | 2.35 | 1.83 |
| 11 | Return on sales-Operating profit/ Net sales | 0.04 | - |