Current Attempt in Progress Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here
Question:
Current Attempt in Progress
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions).
Target | Wal-Mart | ||||||
Income Statement Data for Year | |||||||
Net sales | $65,400 | $418,000 | |||||
Cost of goods sold | 44,000 | 309,000 | |||||
Selling and administrative expenses | 15,000 | 79,000 | |||||
Interest expense | 740 | 2,100 | |||||
Other income (expense) | (90 | ) | (380 | ) | |||
Income tax expense | 1,400 | 7,300 | |||||
Net income | $ 4,170 | $ 20,220 | |||||
Balance Sheet Data | |||||||
Current assets | $19,000 | $50,000 | |||||
Noncurrent assets | 26,700 | 121,000 | |||||
Total assets | $45,700 | $171,000 | |||||
Current liabilities | $11,000 | $55,000 | |||||
Long-term debt | 18,500 | 45,000 | |||||
Total stockholders’ equity | 16,200 | 71,000 | |||||
Total liabilities and stockholders’ equity | $45,700 | $171,000 | |||||
Beginning-of-Year Balances | |||||||
Total assets | $44,000 | $165,000 | |||||
Total stockholders’ equity | 12,800 | 64,000 | |||||
Current liabilities | 10,600 | 58,000 | |||||
Total liabilities | 31,200 | 101,000 | |||||
Other Data | |||||||
Average net accounts receivable | $8,000 | $3,900 | |||||
Average inventory | 6,900 | 34,500 | |||||
Net cash provided by operating activities | 5,500 | 25,800 | |||||
Capital expenditures | 1,800 | 11,700 | |||||
Dividends | 450 | 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 |
Financial Accounting Tools for business decision making
ISBN: 978-0470534779
6th Edition
Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso