Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions).
Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales Cost of goods sold Selling and administrative expenses $65,357 45,583 15,101 Interest expense 707 $408,214 304,657 79,607 2,065 (411) 7,139 $ 14,335 Other income (expense) Income tax expense (94) 1,384 $ 2,488 Net income Balance Sheet Data (End of Year) Current assets Noncurrent assets $18,424 26,109 $44,533 $48,331 122,375 $170,706 Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity $11,327 17,859 15,347 $44,533 $55,561 44,089 71,056 $170,706 Beginning-of-Year Balances Total assets Total stockholders' equity $44,106 13,712 10,512 30,394 $163,429 65,682 55,390 97,747 Current liabilities Total liabilities Other Data Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends $7,525 6,942 5,881 1,729 $4,025 33,836 26,249 12,184 4,217 496 For each company, compute the following ratios. (Enter free cash flow in millions. Round Current ratio to 2 decimal places, e.g. 1.67. Round Debt to assets ratio to 0 decimal places, e.g. 18 or 18%. Round all other answers to 1 decimal place, e.g. 1.6, or 1.6%. Use 365 days for calculation.) Ratio Target Wal-Mart (1) Current ratio :1 :1 (2) Accounts receivable turnover times times (3) Average collection period days days (4) Inventory turnover times times (5) Days in inventory days days (6) Profit margin % % (7) Asset turnover times times (8) Return on assets % % (9) Return on common stockholders' equity % % (10) Debt to assets ratio % % (11) Times interest earned times times (12) Free cash flow million million $ AStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started