Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with question 7 & 12 please. Selected hypothetical financial data of Target and Wal-Mart for 2022 are pre Target Corporation Wal-Mart Stores,
I need help with question 7 & 12 please.
Selected hypothetical financial data of Target and Wal-Mart for 2022 are pre Target Corporation Wal-Mart Stores, Inc Income Statement Data for Yea Net sales $65,400 $418,000 Cost of goods sold 44,000 309.000 15,000 79,000 Selling and administrative expenses Interest expense Other income (expense) 740 2,100 (90) (380) Income tax expense 1.400 7.300 Net income $4,170 $ 20,220 Balance Sheet Data (End of Year) Current assets 519.000 $50.000 Noncurrent assets 26.700 121.000 Total assets $45.700 5171.000 Current liabilities $11.000 $55.000 Long-term debt 18.500 45,000 Total stockholders' equity 16,200 71,000 Total liabilities and stockholders' equity $45,700 $171,000 Beginning-of-Year Balances Total assets $44,000 $165,000 Total stockholders' equity 12,800 64,000 Current liabilities 10,600 58,000 Total liabilities 31,200 101,000 Other Data Average net accounts receivable $8,000 $3,900 Average inventory 6,900 34.500 Net cash provided by operating activities 5.500 25.800 Capital expenditures 1.800 11.700 Dividends 450 4.500 For each company, compute the following ratios. (Round current ratio answers to 2 decimal plac 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.73 1 0.91 1 (2) Accounts receivable turnover 83 times 107.18 times (3) Average collection period 44.0 days 3.6 days (4) Inventory turnover 6.3 times 9.1 times (5) Days in inventory 57.6 days 402 days (6) Profit margin 6.38 484 % (7) Asset tumover 15 times 249 times (8) Return on assets 9.3 %6 1204 % (9) Return on common stockholders equity 28.76 % 29.96 96 (10) Debt to assets ratio 64 % 58 % (11) Times interest earned 8.6 times 14.10 times (12) Free cash flow $ 3700 14100 Step 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