Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Target Corporation Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Wal-Mart Stores, Inc. Income Statement Data for Year $413,000 301.000 75,000 2.200 $67,000 44,000 14,000 660 (70) 1,400 $6.870 (410) 7,000 $27,390

Principles of Accounting Volume 1
19th Edition
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax
Chapter6: Merchandising Transactions
Section: Chapter Questions
Problem 15EA: The following select account data is taken from the records of Reese Industries for 2019. A. Use the...
icon
Related questions
Question
Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions).
Net sales
Cost of goods sold
Selling and administrative expenses
Interest expense
Other income (expense)
Income tax expense
Net income
Average net accounts receivable
Average inventory
Net cash provided by operating activities
Capital expenditures
Dividends
(1)
(2)
(3)
(4)
B
(5)
(6)
(7)
(8)
Current assets
(9)
Noncurrent assets
Total assets
Total assets
Total stockholders' equity
Current liabilities
Total liabilities
(10)
(11)
(12)
Ratio
Current liabilities
Long-term debt
Total stockholders' equity
Total liabilities and stockholders' equity
$7,800
7,100
5,700
Other Data
1,800
450
Current ratio
Accounts receivable turnover
Average collection period
Inventory turnover
Days in inventory
Profit margin
Asset turnover
Return on assets
Wal-Mart
Stores, Inc.
Income Statement Data for Year
Debt to assets ratio
Times interest earned
$3,800
Free cash flow
33,400
27,400
12,000
Return on common stockholders' equity
4,400
Target
Corporation
$67,000
44,000
14,000
660
For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, eg. 15.50, debt to assets ratio and free cash flow answers to 0 decimal places, e.g. 5,275 and all
answers to 1 decimal place, eg. 1.8 or 1.83%)
(70)
1,400
$6,870
$413,000
301,000
75,000
2,200
7,000
$27,390
Balance Sheet Data
(End of Year)
$17,000
26,000
$43,000
$10,000
17,400
15,600
$43,000
(410)
$43,000
14,100
10,800
28,900
Target
Beginning-of-Year Balances
$162,000
:1
times
days
times
days
%
123,000
$172,000
$54,000
$172,000
%
times
%
$49,000
%
43.000
75,000
times
64,000
54,000
98,000
$
Wal-Mart
:1
times
days
times
days
%
times
%
%
%
times
Transcribed Image Text:Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends (1) (2) (3) (4) B (5) (6) (7) (8) Current assets (9) Noncurrent assets Total assets Total assets Total stockholders' equity Current liabilities Total liabilities (10) (11) (12) Ratio Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity $7,800 7,100 5,700 Other Data 1,800 450 Current ratio Accounts receivable turnover Average collection period Inventory turnover Days in inventory Profit margin Asset turnover Return on assets Wal-Mart Stores, Inc. Income Statement Data for Year Debt to assets ratio Times interest earned $3,800 Free cash flow 33,400 27,400 12,000 Return on common stockholders' equity 4,400 Target Corporation $67,000 44,000 14,000 660 For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, eg. 15.50, debt to assets ratio and free cash flow answers to 0 decimal places, e.g. 5,275 and all answers to 1 decimal place, eg. 1.8 or 1.83%) (70) 1,400 $6,870 $413,000 301,000 75,000 2,200 7,000 $27,390 Balance Sheet Data (End of Year) $17,000 26,000 $43,000 $10,000 17,400 15,600 $43,000 (410) $43,000 14,100 10,800 28,900 Target Beginning-of-Year Balances $162,000 :1 times days times days % 123,000 $172,000 $54,000 $172,000 % times % $49,000 % 43.000 75,000 times 64,000 54,000 98,000 $ Wal-Mart :1 times days times days % times % % % times
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

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
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College