P18-5 Selected financial data of Target and Wal-Mart for a recent year are presented here (in millions). Target Corporation Income Statement Data for Year $61,471 Wal-Mart Stores, Inc Net sales $374,526 Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense 41,895 16,200 647 286,515 70,847 1,798 4,273 6,908 1,896 1,776 $ 2,849 Balance Sheet Data (End of Year) $18,906 25,654 $44,560 Net income 12,731 Current assets Noncurrent assets $ 47,585 115,929 Total assets $163,514 $ 58,454 40,452 64,608 Current liabilities $11,782 Long-term debt Total stockholders' equity 17,471 15,307

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
P18-5
Selected financial data of Target and Wal-Mart for a recent year are presented here
ity, (in millions).
Target
Corporation
Income Statement Data for Year
$61,471
Wal-Mart
Stores, Inc.
Net sales
$374,526
Cost of goods sold
Selling and administrative expenses
Interest expense
41,895
286,515
16,200
70,847
1,798
647
1,896
Other income (expense)
Income tax expense
4,273
1,776
6,908
$ 2,849
$ 12,731
Net income
Balance Sheet Data (End of Year)
Current assets
$ 47,585
$18,906
25,654
Noncurrent assets
115,929
Total assets
$44,560
$163,514
Current liabilities
$11,782
$ 58,454
Long-term debt
Total stockholders' equity
17,471
40,452
64,608
15,307
Total liabilities and stockholders' equity
$44,560
$163,514
Beginning-of-Year Balances
$151,587
61,573
Total assets
$37,349
Total stockholders' equity
15,633
Current liabilities
11,117
52,148
Total liabilities
21,716
90,014
Other Data
$ 7,124
6,517
4,125
$ 3,247
Average net receivables
Average inventory
Net cash provided by operating activities
34,433
20,354
Instructions
(a) For each company, compute the following ratios.
(1) Current.
(2) Receivables turnover.
(3) Average collection period.
(4) Inventory turnover.
(5) Days in inventory.
(6) Profit margin.
(b) Compare the liquidity, profitability, and solvency of the two companies.
(7) Asset turnover.
(8) Return on assets.
(9) Return on common stockholders' equity.
(10) Debt to total assets.
(11) Times interest earned.
Transcribed Image Text:P18-5 Selected financial data of Target and Wal-Mart for a recent year are presented here ity, (in millions). Target Corporation Income Statement Data for Year $61,471 Wal-Mart Stores, Inc. Net sales $374,526 Cost of goods sold Selling and administrative expenses Interest expense 41,895 286,515 16,200 70,847 1,798 647 1,896 Other income (expense) Income tax expense 4,273 1,776 6,908 $ 2,849 $ 12,731 Net income Balance Sheet Data (End of Year) Current assets $ 47,585 $18,906 25,654 Noncurrent assets 115,929 Total assets $44,560 $163,514 Current liabilities $11,782 $ 58,454 Long-term debt Total stockholders' equity 17,471 40,452 64,608 15,307 Total liabilities and stockholders' equity $44,560 $163,514 Beginning-of-Year Balances $151,587 61,573 Total assets $37,349 Total stockholders' equity 15,633 Current liabilities 11,117 52,148 Total liabilities 21,716 90,014 Other Data $ 7,124 6,517 4,125 $ 3,247 Average net receivables Average inventory Net cash provided by operating activities 34,433 20,354 Instructions (a) For each company, compute the following ratios. (1) Current. (2) Receivables turnover. (3) Average collection period. (4) Inventory turnover. (5) Days in inventory. (6) Profit margin. (b) Compare the liquidity, profitability, and solvency of the two companies. (7) Asset turnover. (8) Return on assets. (9) Return on common stockholders' equity. (10) Debt to total assets. (11) Times interest earned.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Income Statement Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education