Question: Need help with this any body up for the challenge? Selected financial data of Target and Wal-Mart for a recent year are presented here (in
Need help with this any body up for the challenge?
Selected financial data of Target and Wal-Mart for a recent year are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales $61,471 $374,526 Cost of goods sold 41,895 286,515 Selling and administrative expenses 16,200 70,847 Interest expense 647 1,798 Other income (expense) 1,896 4,273 Income tax expense 1,776 6,908 $ 2,849 $ 12,731 Net income Balance Sheet Data (End of Year) Current assets $18,906 $ 47,585 25,654 115,929 Total assets $44,560 $163,514 Current liabilities $11,782 $ 58,454 Long-term debt 17,471 40,452 Total stockholders' equity 15,307 64,608 $44,560 $163,514 Noncurrent assets Total liabilities and stockholders' equity Beginning-of-Year Balances Total assets $37,349 $151,587 Total stockholders' equity 15,633 61,573 Current liabilities 11,117 52,148 Total liabilities 21,716 90,014 Other Data Average net accounts receivable $ 7,124 $ 3,247 Average inventory 6,517 34,433 Net cash provided by operating activities 4,125 20,354 (a) For each company, compute the following ratios. (Round all answers to 1 decimal place, e.g.1.6, or 1.6% .) Ratio (1) Current (2) Accounts receivable turnover Target :1 Wal-Mart :1 (3) Average collection period (4) Inventory turnover (5) Days in inventory (6) Profit margin % % (8) Return on assets % % (9) Return on common stockholders' equity % % (10 Debt to total assets ) % % (7) Asset turnover (11) Times interest earned
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
