For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, e.g. 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, e.g. 1.8 or 1.83 %.) (1) (2) (3) Ratio Current ratio Accounts receivable turnover Average collection period Target :1 times days Wal-Mart times days

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question

K 10

Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions).
Wal-Mart
Target
Corporation Stores, Inc.
Net sales
Cost of goods sold
Selling and administrative expenses
Interest expense
Other income (expense)
Income tax expense
Net income
Current assets
Noncurrent assets.
Total assets
Current liabilities
Long-term debt
Total stockholders' equity
Total liabilities and stockholders' equity
(1)
Total assets
Total stockholders' equity
Current liabilities
(2)
(3)
Total liabilities
(4)
(5)
(6)
(7)
(8)
Average net accounts receivable
Average inventory
Net cash provided by operating activities
Capital expenditures
Dividends
(9)
(10)
(11)
(12)
Ratio
Current ratio
Accounts
receivable
turnover
Average collection
period
Inventory
turnover
Days in inventory
Profit margin
Asset turnover
Return on assets
Return on
common
stockholders'
equity
Debt to assets
ratio
Times interest
earned
Income Statement Data for
Year
Free cash flow
$65,900
46,000
$
14,500
Target
660
(85)
1,400
$3,255
$16,000
26,100
$42,100
$10,000
17,100
15,000
$42,100
Balance Sheet Data
(End of Year)
For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, e.g.
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, e.g. 1.8 or 1.83%.)
:1
times
days
%
times
days
%
$411,000
307,000
%
77,000
times
%
2,000
Beginning-of-Year Balances
$164,000
7,100
$ 17,490
$49,000
123.000
times
$172,000
$43,000
13,900
10,900
29,100
(410)
$54,000
45,000
$7,800
7,000
73,000
$172,000
Other Data
5,600
1,800
470
$
65,000
57,000
99,000
$4,100
33,800
27,400
12,500
3,700
Wal-Mart
:1
times
days
times
days
%
times
xe
%
%
times
Transcribed Image Text:Selected hypothetical financial data of Target and Wal-Mart for 2022 are presented here (in millions). Wal-Mart Target Corporation Stores, Inc. Net sales Cost of goods sold Selling and administrative expenses Interest expense Other income (expense) Income tax expense Net income Current assets Noncurrent assets. Total assets Current liabilities Long-term debt Total stockholders' equity Total liabilities and stockholders' equity (1) Total assets Total stockholders' equity Current liabilities (2) (3) Total liabilities (4) (5) (6) (7) (8) Average net accounts receivable Average inventory Net cash provided by operating activities Capital expenditures Dividends (9) (10) (11) (12) Ratio Current ratio Accounts receivable turnover Average collection period Inventory turnover Days in inventory Profit margin Asset turnover Return on assets Return on common stockholders' equity Debt to assets ratio Times interest earned Income Statement Data for Year Free cash flow $65,900 46,000 $ 14,500 Target 660 (85) 1,400 $3,255 $16,000 26,100 $42,100 $10,000 17,100 15,000 $42,100 Balance Sheet Data (End of Year) For each company, compute the following ratios. (Round current ratio answers to 2 decimal places, e.g. 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, e.g. 1.8 or 1.83%.) :1 times days % times days % $411,000 307,000 % 77,000 times % 2,000 Beginning-of-Year Balances $164,000 7,100 $ 17,490 $49,000 123.000 times $172,000 $43,000 13,900 10,900 29,100 (410) $54,000 45,000 $7,800 7,000 73,000 $172,000 Other Data 5,600 1,800 470 $ 65,000 57,000 99,000 $4,100 33,800 27,400 12,500 3,700 Wal-Mart :1 times days times days % times xe % % times
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Financial Statements
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.
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