80.2K

Verified Solution

Link Copied!

Question 1 of 10 > 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 $66,700 $409,000 46.000 306,000 14,700 76,000 650 1,800 (95) (420) 1,400 7,200 $ 3,855 $ 17,580 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) $19,000 $48,000 25,600 120,000 $44,600 $168,000 $10,000 $55,000 18.200 44,000 16,400 69,000 $44,600 $168,000 Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $43,000 $162.000 13,500 66,000 10,500 55,000 29,500 96,000 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $7.800 $3,900 7,000 33.700 5,600 26.800 1,800 12,400 460 4,500 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $7,800 $3,900 7,000 33,700 5,600 26,800 1,800 12,400 460 4,500 1 For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, eg. 15.50, debt to assets ratio and free cash flow answers to decimal places, e.g. 5,275 and all answers to 1 decimal place. eg. 1.8 or 1.83%) Ratio Target Wal-Mart (1) Current ratio 1.9 :1 0.87 1 (2) Accounts receivable turnover 8.55 times 104.87 times (3) Average collection period 42.69 days 3.48 days (4) Inventory turnover 6.57 times 9.08 times (5) Days in inventory 55.56 days 41.20 days (6) Profit margin 5.77 430 95 (7) Asset turnover 1.52 times 2.48 times (8) Return on assets 8.80 % 10.65 (9) Return on common stockholders' equity 25.79 % 26.04 (10) Debt to assets ratio 63.23 % 58.93 (11) Times interest earned 9.23 times 15.00 times (12) Free cash flow 3340 S 9900 e Textbook and Media Save for Later Attempts: 2 of 5 used Submit Answer o BE

Answer & Explanation Solved by verified expert

See Answer