Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Your answer is partially correct. Iry again Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions) Target Corporation Wal-Mart

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Your answer is partially correct. Iry again Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions) Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income $65,000 46,000 14,800 660 (70) 1,300 $2,170 $406,000 306,000 76,000 2,200 (390) 6,500 $14,910 Balance Sheet Data (End of Year) Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity $19,000 26,100 $45,100 $12,000 17,400 15,700 $49,000 123,000 $172,000 $55,000 43,000 74,000 Total stockholders' equity Total liabilities and stockholders' equity 15,700 $45,100 74,000 $172,000 Beginning-of-Year Balances Total assets Total stockholders' equity Current liabilities Total liabilities $45,000 12,900 10,300 32,100 $162,000 66,000 57,000 96,000 Other Data Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends $8,000 6,800 5,900 1,700 510 $3,800 33,200 27,400 11,600 4,200 For each company, compute the following ratios. (Round all answers to 2 decimal places, eg, 1.85 or 1.85%.) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.85 or 1.85%.) Ratio Target Wal-Mart (1) Current ratio 1.58 :1 0.901 :1 (2) Accounts receivable turnover 8.12 times 107 times (3) Average collection period 0.04 days 0.09 days (4) Inventory turnover 0.05 times 0.01 times (5) Days in inventory days days (6) Profit margin (7) Asset turnover (8)Return on assets 0.03% 0.03% 1.44 times 2.36 times (9) Return on common stockholders' equity (10) Debt to assets ratio (11) Times interest earned times times (12) Free cash flow 4,200 15,800 Click if you would like to Show Work for this question: Open Show Work

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

Recommended Textbook for

Managerial Accounting

Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer

13th Edition

978-0697789938

Students also viewed these Accounting questions