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 | - |