Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions).

image text in transcribedimage text in transcribedimage text in transcribed

Target Corporation Wal-Mart Stores, Inc. Income Statement Data for Year Net sales Cost of goods sold Selling and administrative expenses $65,357 45,583 15,101 Interest expense 707 $408,214 304,657 79,607 2,065 (411) 7,139 $ 14,335 Other income (expense) Income tax expense (94) 1,384 $ 2,488 Net income Balance Sheet Data (End of Year) Current assets Noncurrent assets $18,424 26,109 $44,533 $48,331 122,375 $170,706 Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity $11,327 17,859 15,347 $44,533 $55,561 44,089 71,056 $170,706 Beginning-of-Year Balances Total assets Total stockholders' equity $44,106 13,712 10,512 30,394 $163,429 65,682 55,390 97,747 Current liabilities Total liabilities Other Data Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends $7,525 6,942 5,881 1,729 $4,025 33,836 26,249 12,184 4,217 496 For each company, compute the following ratios. (Enter free cash flow in millions. Round Current ratio to 2 decimal places, e.g. 1.67. Round Debt to assets ratio to 0 decimal places, e.g. 18 or 18%. Round all other answers to 1 decimal place, e.g. 1.6, or 1.6%. Use 365 days for calculation.) Ratio Target Wal-Mart (1) Current ratio :1 :1 (2) Accounts receivable turnover times times (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 million million $ A

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

Auditing And Assurance Services An Integrated Approach

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley

10th Edition

0131457349, 978-0131457348

More Books

Students also viewed these Accounting questions

Question

2. Whats involved in listening?

Answered: 1 week ago

Question

1. How do listening and hearing diff er?

Answered: 1 week ago