Selected hypothetical financial data of Targetand Wal-Mart for 2022 are presented here (in millions).
Target | Wal-Mart | ||||||
---|---|---|---|---|---|---|---|
Income Statement Data for Year | |||||||
Net sales | $66,400 | $414,000 | |||||
Cost of goods sold | 45,000 | 302,000 | |||||
Selling and administrative expenses | 15,500 | 81,000 | |||||
Interest expense | 650 | 1,900 | |||||
Other income (expense) | (80 | ) | (400 | ) | |||
Income tax expense | 1,400 | 7,300 | |||||
Net income | $ 3,770 | $ 21,400 | |||||
Balance Sheet Data | |||||||
Current assets | $17,000 | $47,000 | |||||
Noncurrent assets | 26,700 | 120,000 | |||||
Total assets | $43,700 | $167,000 | |||||
Current liabilities | $11,000 | $56,000 | |||||
Long-term debt | 16,800 | 45,000 | |||||
Total stockholders’ equity | 15,900 | 66,000 | |||||
Total liabilities and stockholders’ equity | $43,700 | $167,000 | |||||
Beginning-of-Year Balances | |||||||
Total assets | $45,000 | $164,000 | |||||
Total stockholders’ equity | 13,300 | 64,000 | |||||
Current liabilities | 10,500 | 58,000 | |||||
Total liabilities | 31,700 | 100,000 | |||||
Other Data | |||||||
Average net accounts receivable | $7,500 | $3,900 | |||||
Average inventory | 7,000 | 33,600 | |||||
Net cash provided by operating activities | 5,500 | 27,400 | |||||
Capital expenditures | 1,800 | 11,800 | |||||
Dividends | 500 | 4,500 |
For each company, compute the following ratios. (Round
current ratio answers to 2 decimal places, e.g. 15.50, debt to
assets ratio and free cash flow answers to 0 decimal places, e.g.
5,275 and all answers to 1 decimal place, e.g. 1.8 or
1.83%.)
Ratio | Target | Wal-Mart | ||||||
---|---|---|---|---|---|---|---|---|
(1) | Current ratio | enter the current ratio | :1 | enter the current ratio | :1 | |||
(2) | Accounts receivable turnover | enter accounts receivable turnover in times | times | enter accounts receivable turnover in times | times | |||
(3) | Average collection period | enter average collection period in days | days | enter average collection period in days | days | |||
(4) | Inventory turnover | enter inventory turnover in times | times | enter inventory turnover in times | times | |||
(5) | Days in inventory | enter days in inventory ratio | days | enter days in inventory ratio | days | |||
(6) | Profit margin | enter percentages | % | enter percentages | % | |||
(7) | Asset turnover | enter asset turnover in times | times | enter asset turnover in times | times | |||
(8) | Return on assets | enter percentages | % | enter percentages | % | |||
(9) | Return on common stockholders’ equity | enter percentages | % | enter percentages | % | |||
(10) | Debt to assets ratio | enter percentages | % | enter percentages | % | |||
(11) | Times interest earned | enter times interest earned | times | enter times interest earned | times | |||
(12) | Free cash flow | $enter a dollar amount | $enter a dollar amount |
According to the HOMEWORKLIB POLICY we can answer first 4 question but for you I solved 6 questions. If you want another to be answered plz post as another question. If you have any query ask in comment section. If you like my work plz rate. Thanks
Selected hypothetical financial data of Targetand Wal-Mart for 2022 are presented here (inmillions).Target...