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

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter9: Long-term Liabilities
Section: Chapter Questions
Problem 89E: Ratio Analysis Rising Stars Academy provided the following information on its 2019 balance sheet and...
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College