Question
Problem 13-5A Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Target Corporation Wal-Mart Stores, Inc. Income Statement Data
Problem 13-5A
Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions).
Target Corporation | Wal-Mart Stores, Inc. | ||||||
Income Statement Data for Year | |||||||
Net sales | $66,400 | $407,000 | |||||
Cost of goods sold | 46,000 | 306,000 | |||||
Selling and administrative expenses | 15,500 | 79,000 | |||||
Interest expense | 670 | 1,800 | |||||
Other income (expense) | (85 | ) | (390 | ) | |||
Income tax expense | 1,300 | 7,500 | |||||
Net income | $ 2,845 | $ 12,310 | |||||
Balance Sheet Data (End of Year) | |||||||
Current assets | $19,000 | $47,000 | |||||
Noncurrent assets | 27,300 | 123,000 | |||||
Total assets | $46,300 | $170,000 | |||||
Current liabilities | $11,000 | $56,000 | |||||
Long-term debt | 18,100 | 45,000 | |||||
Total stockholders equity | 17,200 | 69,000 | |||||
Total liabilities and stockholders equity | $46,300 | $170,000 | |||||
Beginning-of-Year Balances | |||||||
Total assets | $43,000 | $164,000 | |||||
Total stockholders equity | 14,300 | 66,000 | |||||
Current liabilities | 10,800 | 57,000 | |||||
Total liabilities | 28,700 | 98,000 | |||||
Other Data | |||||||
Average net accounts receivable | $7,900 | $4,100 | |||||
Average inventory | 6,800 | 34,000 | |||||
Net cash provided by operating activities | 5,600 | 26,300 | |||||
Capital expenditures | 1,800 | 11,500 | |||||
Dividends | 520 | 4,200 |
(a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.83 or 1.83%.)
I need help with section 2,3,9,10,11, and 12
Ratio | Target | Wal-Mart | ||||||
(1) | Current ratio | 1.73 | :1 | 0.84 | :1 | |||
(2) | Accounts receivable turnover | ________ | times | _______ | times | |||
(3) | Average collection period | ________ | days | _______ | days | |||
(4) | Inventory turnover | 6.76 | times | 9 | times | |||
(5) | Days in inventory | 54 | days | 40.56 | days | |||
(6) | Profit margin | 4.28 | % | 3.02 | % | |||
(7) | Asset turnover | 1.49 | times | 2.44 | times | |||
(8) | Return on assets | 6.32 | % | 7.37 | % | |||
(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 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