Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions