Suppose selected financial data of Target and Walmart for 2022 are as follows (in millions). Net...

Transcribed Image Text:

Suppose selected financial data of Target and Walmart for 2022 are as follows (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Target Corporation Walmart, Inc. Income Statement Data for Year $413,000 301,000 75,000 2,200 (410) $67,00 44,000 14,000 660 (70) 1,400 $6,870 7,000 $27,390 Balance Sheet Data (End of Year) $17,000 26,000 $43,000 $10,000 17,400 15,600 $43,000 $49,000 123,000 $172,000 $54,000 43,000 75,000 $172,000 Total assets Total stockholders' equity Current liabilities Total liabilities Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends P Beginning-of-Year Balances $162,000 64,000 54,000 98,000 $43,000 14,100 10,800 28,900 Other Data $7,800 7,100 5,700 1,800 450 $3,800 33,400 27.400 12,000 4,400 For each company, compute the following ratios. (Round current ratio to 2 decimal places, eg 1.83. Round accounts receivable turnover overage collection period, inventory turnover, days in inventory, profit margin, asset turnover, return on asets, retiam on common stockholders equity and times interest earned to 1 decimal places, es 18 or 1.8%. Round debt to assets ratio to O decimal ploces, eg 15%) E B (5) 16) S (8) ( (10) (13) (12) Ratio Current ratio Accounts receivable turnover Average collection period Inventory turnover Days in inventory Profit margin Asset turnover Return on assets Return on common stockholders' equity Debit to assets ratio Free castiflow Target 11 times days times days times Walmart 1 times days Suppose selected financial data of Target and Walmart for 2022 are as follows (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Target Corporation Walmart, Inc. Income Statement Data for Year $413,000 301,000 75,000 2,200 (410) $67,00 44,000 14,000 660 (70) 1,400 $6,870 7,000 $27,390 Balance Sheet Data (End of Year) $17,000 26,000 $43,000 $10,000 17,400 15,600 $43,000 $49,000 123,000 $172,000 $54,000 43,000 75,000 $172,000 Total assets Total stockholders' equity Current liabilities Total liabilities Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends P Beginning-of-Year Balances $162,000 64,000 54,000 98,000 $43,000 14,100 10,800 28,900 Other Data $7,800 7,100 5,700 1,800 450 $3,800 33,400 27.400 12,000 4,400 For each company, compute the following ratios. (Round current ratio to 2 decimal places, eg 1.83. Round accounts receivable turnover overage collection period, inventory turnover, days in inventory, profit margin, asset turnover, return on asets, retiam on common stockholders equity and times interest earned to 1 decimal places, es 18 or 1.8%. Round debt to assets ratio to O decimal ploces, eg 15%) E B (5) 16) S (8) ( (10) (13) (12) Ratio Current ratio Accounts receivable turnover Average collection period Inventory turnover Days in inventory Profit margin Asset turnover Return on assets Return on common stockholders' equity Debit to assets ratio Free castiflow Target 11 times days times days times Walmart 1 times days

Answer rating: 100% (QA)

Here are the computed ratios for both Target and Walmart based on the provided financial data Target Corporation 1 Current Ratio Current Assets Curren... View the full answer