Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions).
Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Target Wal-Mart Corporation Stores, Inc. Income Statement Data for Year $64,900 $405,000 44,000 300,000 14,000 75,000 650 1,800 (70) (380) 1,300 6,500 $ 4,880 $ 21,320 Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Balance Sheet Data (End of Year) $16,000 $45,000 25,000 120,000 $41,000 $165,000 $10,000 $54,000 16,800 43,000 14,200 68,000 $41,000 $165,000 Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $43,000 $162,000 12,500 64,000 10,000 54,000 30,500 98,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $7,400 $3,800 6,800 32,800 5,500 25,500 1,600 11,500 450 3,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 :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 $ $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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