Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions)....

90.2K

Verified Solution

Question

Accounting

Suppose selected financial data of Target and Wal-Mart for 2017 are presented here (in millions).

Target Corporation
Wal-Mart Stores, Inc.
Income Statement Data for Year
Net sales
$65,600
$418,000
Cost of goods sold
45,000
310,000
Selling and administrative expenses
14,300
75,000
Interest expense
720
2,200
Other income (expense)
(90
)
(380
)
Income tax expense
1,400
6,900
Net income
$ 4,090
$ 23,520
Balance Sheet Data (End of Year)
Current assets
$18,000
$47,000
Noncurrent assets
26,100
121,000
Total assets
$44,100
$168,000
Current liabilities
$10,000
$55,000
Long-term debt
18,300
43,000
Total stockholders equity
15,800
70,000
Total liabilities and stockholders equity
$44,100
$168,000
Beginning-of-Year Balances
Total assets
$44,000
$165,000
Total stockholders equity
13,200
66,000
Current liabilities
10,800
54,000
Total liabilities
30,800
99,000
Other Data
Average net accounts receivable
$7,900
$4,100
Average inventory
7,100
34,100
Net cash provided by operating activities
5,700
25,900
Capital expenditures
1,600
11,500
Dividends
520
4,200

(a) For each company, compute the following ratios. (Round all answers to 2 decimal places, e.g. 1.83 or 1.83%.)

Ratio
Target
Wal-Mart
(1) Current ratio
image1.80
:1
image0.85
:1
(2) Accounts receivable turnover
image8.30
times
image101.95
times
(3) Average collection period
image43.97
days
image3.58
days
(4) Inventory turnover
image6.33
times
image9.09
times
(5) Days in inventory
image57.66
days
image40.15
days
(6) Profit margin
image
%
image
%
(7) Asset turnover
image
times
image
times
(8) Return on assets
image
%
image
%
(9) Return on common stockholders equity
image
%
image
%
(10) Debt to assets ratio
image
%
image
%
(11) Times interest earned
image
times
image
times
(12) Free cash flow
$
image3580
$
image10200

( are the questions i answered correct? Im trying to figure out if im doing it right.)

Answer & Explanation Solved by verified expert
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

Other questions asked by students