Selected financial data of Target and Wal-Mart for 2017 arebelow (in millions).TargetWal-MartIncome...Selected financial data...

90.2K

Verified Solution

Question

Accounting

Selected financial data of Target and Wal-Mart for 2017 arebelow (in millions).

Target

Wal-Mart

Income Statement Data for Year

Net sales

$65,357

$408,214

Cost of goods sold

45,583

304,657

Selling and administrative expenses

15,101

79,607

Interest expense

707

2,065

Other income (expense)

(94)

(411)

Income tax expense

1,384

7,139

Net income

$ 2,488

$ 14,335

Balance Sheet Data (End of Year)

Current assets

$18,424

$ 48,331

Noncurrent assets

26,109

122,375

Total assets

$44,533

$170,706

Current liabilities

$11,327

$ 55,561

Long-term debt

17,859

44,089

Total stockholders’ equity

15,347

71,056

Total liabilities and stockholders’ equity

$44,533

$170,706

Beginning-of-Year Balances

Total assets

$44,106

$163,429

Total stockholders’ equity

13,712

65,682

Current liabilities

10,512

55,390

Total liabilities

30,394

97,747

Other Data

Average net accounts receivable

$ 7,525

$ 4,025

Average inventory

6,942

33,836

Net cash provided by operating activities

5,881

26,249

Capital expenditures

1,729

12,184

Dividends

496

4,217

(a) For each company, compute the following ratios.

Ratio

Target

Wal-Mart

(1) Current ratio.

1.626556017

0.869872752

(2) Accounts receivable turnover.

8.685315615

101.4196273

(3) Average collection period.

42.02495525

3.598908906

(4) Inventory turnover.

6.566263325

9.003930725

(5) Days in inventory.

55.58717066

40.53785076

(6) Gross profit margin %

4%

4%

(7) Return on assets (use net income).

6%

9%

(8) Debt to assets ratio.

66%

58%

Note: Gross profit margin % = (Revenues - COGS)/Revenues, orgross margin/revenues

(b) Below, briefly compare the two companies in terms ofliquidity (items 1-5), solvency (item 8), and profitability (items6, 7). By briefly, I mean 1 -3 sentences per category.

Liquidity:

Solvency:

Profitability:

Answer & Explanation Solved by verified expert
4.2 Ratings (780 Votes)
Liquidity Target companys current ratio is higher than Walmart companys current ratio that clearly indicates that Target compani is more liquid than Walmart Account receivable turnover ratio tells how    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

In: AccountingSelected financial data of Target and Wal-Mart for 2017 arebelow (in millions).TargetWal-MartIncome...Selected financial data of Target and Wal-Mart for 2017 arebelow (in millions).TargetWal-MartIncome Statement Data for YearNet sales$65,357$408,214Cost of goods sold45,583304,657Selling and administrative expenses15,10179,607Interest expense7072,065Other income (expense)(94)(411)Income tax expense1,3847,139Net income$ 2,488$ 14,335Balance Sheet Data (End of Year)Current assets$18,424$ 48,331Noncurrent assets26,109122,375Total assets$44,533$170,706Current liabilities$11,327$ 55,561Long-term debt17,85944,089Total stockholders’ equity15,34771,056Total liabilities and stockholders’ equity$44,533$170,706Beginning-of-Year BalancesTotal assets$44,106$163,429Total stockholders’ equity13,71265,682Current liabilities10,51255,390Total liabilities30,39497,747Other DataAverage net accounts receivable$ 7,525$ 4,025Average inventory6,94233,836Net cash provided by operating activities5,88126,249Capital expenditures1,72912,184Dividends4964,217(a) For each company, compute the following ratios.RatioTargetWal-Mart(1) Current ratio.1.6265560170.869872752(2) Accounts receivable turnover.8.685315615101.4196273(3) Average collection period.42.024955253.598908906(4) Inventory turnover.6.5662633259.003930725(5) Days in inventory.55.5871706640.53785076(6) Gross profit margin %4%4%(7) Return on assets (use net income).6%9%(8) Debt to assets ratio.66%58%Note: Gross profit margin % = (Revenues - COGS)/Revenues, orgross margin/revenues(b) Below, briefly compare the two companies in terms ofliquidity (items 1-5), solvency (item 8), and profitability (items6, 7). By briefly, I mean 1 -3 sentences per category.Liquidity:Solvency:Profitability:

Other questions asked by students