Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Selected financial data of two competitors, Target and Wal-Mart, are presented here. (All dollars are in millions.) Suppose the data were taken from the 2017
Selected financial data of two competitors, Target and Wal-Mart, are presented here. (All dollars are in millions.) Suppose the data were taken from the 2017 financial statements of each company. Target Wal-Mart (1/31/17) (1/31/17) Income Statement Data for Year $64,600 $401,244 43,799 301,334 16,279 68,211 Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income Income taxes 1,098 2,809 27 1,423 4,213 20,623 $ 12,480 Net income $ 2,028 Current assets Noncurrent assets Total assets Current liabilities Long-term liabilities Total stockholders' equity Total liabilities and stockholders' equity Target Wal-Mart Balance Sheet Data (End of Year) $14,560 $ 33,120 35,440 157,880 $50,000 $191,000 $10,400 $ 55,200 20,600 40,300 19,000 95,500 $50,000 $191,000 Net cash provided by operating activities $4,440 $24,600 $4.440 Net cash provided by operating activities Cash paid for capital expenditures Dividends declared and paid on common stock Weighted average shares outstanding (millions) $3,600 $480 $24,600 $11,700 $3,650 3,900 780 For each company, compute these values and ratios. (All Dollars Are in Millions) (Round Current ratio and Earnings per share to 2 decimal places, e.g. 15.25 and Debt to assets ratio to 1 decimal place, e.g. 78.9%. If answer is negative enter it with a negative sign preceding the number e.g. -15,000 or in parentheses e.g. (15,000).) Target Wal-Mart (a) Working capital $ 5800 $ (3600) (b) Current ratio 1.54 :1 0.93 :1 (c) Debt to assets ratio 71.3 % 56.8 % (d) Free cash flow $ 450 $ 8500 (e) Earnings per share $ 4.16 $ 4.66 (f) Which company has better liquidity? Target Which company has better solvency? Wal-Mart Selected financial data of two competitors, Target and Wal-Mart, are presented here. (All dollars are in millions.) Suppose the data were taken from the 2017 financial statements of each company. Target Wal-Mart (1/31/17) (1/31/17) Income Statement Data for Year $64,600 $401,244 43,799 301,334 16,279 68,211 Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income Income taxes 1,098 2,809 27 1,423 4,213 20,623 $ 12,480 Net income $ 2,028 Current assets Noncurrent assets Total assets Current liabilities Long-term liabilities Total stockholders' equity Total liabilities and stockholders' equity Target Wal-Mart Balance Sheet Data (End of Year) $14,560 $ 33,120 35,440 157,880 $50,000 $191,000 $10,400 $ 55,200 20,600 40,300 19,000 95,500 $50,000 $191,000 Net cash provided by operating activities $4,440 $24,600 $4.440 Net cash provided by operating activities Cash paid for capital expenditures Dividends declared and paid on common stock Weighted average shares outstanding (millions) $3,600 $480 $24,600 $11,700 $3,650 3,900 780 For each company, compute these values and ratios. (All Dollars Are in Millions) (Round Current ratio and Earnings per share to 2 decimal places, e.g. 15.25 and Debt to assets ratio to 1 decimal place, e.g. 78.9%. If answer is negative enter it with a negative sign preceding the number e.g. -15,000 or in parentheses e.g. (15,000).) Target Wal-Mart (a) Working capital $ 5800 $ (3600) (b) Current ratio 1.54 :1 0.93 :1 (c) Debt to assets ratio 71.3 % 56.8 % (d) Free cash flow $ 450 $ 8500 (e) Earnings per share $ 4.16 $ 4.66 (f) Which company has better liquidity? Target Which company has better solvency? Wal-Mart
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