Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Problem 9-5 Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions Net sales Cost of goods sold Selling and
Problem 9-5 Suppose selected financial data of Target and Wal-Mart for 2017 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 Wal-Mart Target Stores, Corporation Inc. Income Statement Data for Year $65,400 $418,000 44,000 309,000 15,000 79,000 740 2,100 (90) (380) 1,400 7,300 $ 4,170 $ 20,220 Current assets Noncurrent assets Balance Shelt Data (End of Year) $19,000 $50,000 26,700 121,000 $45,700 $171,000 $11,000 $55,000 Total assets Current liabilities 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 $50,000 26,700 121,000 $45,700 $171,000 $11,000 $55,000 18,500 45,000 16,200 71,000 $45,700 $171,000 Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $44,000 $165,000 12,800 64,000 10,600 58,000 31,200 101,000 Average net accounts receivable Averano inventory Other Data $8,000 $3,900 onn 34 500 PDF Midterm_Review...pdf 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 Dividendi 450 4.500 (a) For each company, compute the following ratios. (Round current ratio to 2 decimal places 1.8.) and all other answers to I decimal place 0 18 or 2.54 365 days in calcul Ratio Target Wal-Mart Current ratio 21 1 Accounts receivable turnover times times 13 Average collection period days Inventory turnover times Days in Inventory days dan (6) Profit margin Times Ratio Target Wal-Mart Current ratio :1 :1 times times (2) Accounts receivable turnover (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