Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 13-05A a Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Wal-Mart Target Stores, Corporation Inc. Income Statement

image text in transcribed
image text in transcribed
image text in transcribed
Problem 13-05A a Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions). Wal-Mart Target Stores, Corporation Inc. Income Statement Data for Year Net sales $66,300 $411,000 Cost of goods sold 44,000 305,000 Selling and administrative expenses 14,300 77,000 Interest expense 660 1,900 Other income (expense) (80) (420) Income tax expense 1,500 7,200 Net income $5,760 $19,480 Current assets Noncurrent assets Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity Balance Sheet Data (End of Year) $17,000 $48,000 26,800 122,000 $43,800 $170,000 $11,000 $55,000 17,700 45,000 15,100 70,000 $43,800 $170,000 Beginning-of-Year Balances here to search N (hp) Total assets Total stockholders' equity Current liabilities Total liabilities Beginning-of-Year Balances $43,000 $164,000 12,700 66,000 10,500 55,000 30,300 98,000 Other Data Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends $7,400 7,000 5,500 1,800 470 $3,900 33,200 26,200 11,900 3,900 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 :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 % wo re to search OL N A 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 :1 (2) Accounts receivable turnover times times (3) days days (4) Average collection period Inventory turnover Days in inventory times times (5) days days 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 $

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

Connect For Computer Accounting With Quickbooks Online

Authors: Donna Kay

2nd Edition

1264152272, 9781264152278

More Books

Students also viewed these Accounting questions

Question

How we can improve our listening skills?

Answered: 1 week ago

Question

How do artifacts affect interaction between members of the team?

Answered: 1 week ago