Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 9-5 Your answer is partially correct. Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions). Net sales Cost

image text in transcribed
image text in transcribed
image text in transcribed
Problem 9-5 Your answer is partially correct. 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 Corporation Stores Inc. Income Statement Data for Year $66,900 $417,000 44,000 308,000 14,400 79,000 750 1,800 (95) (400) 1,500 6,600 $ 6,155 $ 21,200 Current assets Noncurrent assets Total assets Balance Sheet Data (End of Year) $17,000 $45,000 26,800 120,000 $43,800 $165,000 $10,000 $56,000 17,300 44,000 16,500 65,000 $43,800 $165,000 Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Beginning-of-Year Balances $43,000 $165,000 Total assets Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity $17,000 26,800 $43,800 $10,000 17,300 16,500 $43,800 $45,000 120,000 $165,000 $56,000 44,000 65,000 $165,000 Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $43,000 $165,000 13,400 64,000 10,000 56,000 29,600 101,000 32,800 Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends Other Data $7,500 $3,900 7,200 5,500 25,900 1,800 12,400 450 4,400 (a) For each company, compute the following ratios. (Round current ratio to 2 decimal places, e.g 1.83 or 2.5%. Use 365 days in calculation.) idends 450 4,400 For each company, compute the following ratios. (Round current ratio to 2 decimal places, e.g 1.83 a 2.5%. Use 365 days in calculation.) Ratlo Target Wal-Mart Current ratio 1.70 :1 0.80 :1 Accounts receivable turnover 8.9 times 106.0 times Average collection period 40.9 days 3.4 days > Inventory turnover 6.1 times 9.4 times 2 Days in inventory 59.71 days U 38.9 days Profit margin 9.20 % 5.08 % ) Asset turnover 1.54 times 0.27 times ) Return on assets 14.1 % 12.81 % X :) Return on common stockholders' equity 37.3 % 32.6 % -0) Debt to assets ratio 62.31 % 60.6 % 1) Times interest earned 9.08 times 12.5 times 2) Free cash flow 3250 9100 Cudent did not submit Show Work for this attempt

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Monitoring And Auditing Practices For Effective Compliance

Authors: John E. Steiner

2nd Edition

0977843017, 978-0977843015

More Books

Students also viewed these Accounting questions

Question

List the general rights of common stockholders.

Answered: 1 week ago