Using the financial statements in the attached workbook (Walmart Macys Financials.xlsx), calculate ROA, Profit Margin, Asset Turn-over, and Cash-to-cash cycle for Walmart and Macy's as of 2013. For returns when you calculate ROA, use a corporate tax rate of 21%.

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
A
Comparison of Firm Performance
1
2 2013 Financials
3
Net operating revenues
4 Cost of goods sold
5 Gross profit
6 Selling, general, and administrative expense
7 Other costs
8 Operating income
9
Interest expense
10 Other income (loss) - net
11 Income before income taxes
12 Income taxes
13 Net income
14 Assets
15 Cash and cash equivalents
16 Net receivables
17 Inventories
18 Prepaid expenses and other
19 Total current assets
20 Property, plant and equipment
21 Goodwill
22 Other assets
23 Total assets
24 Liabilities and Stockholder Equity
25 Accounts payable
26 Short-term debt
27 Total current liability
28 Long-term debt
29 Other liabilities
30 Total liabilities
31 Stockholder equity
32
B
Walmart
469,162
352,488
116,674
88,873
27,801
2,251
187
25,737
7,981
17,756
7,781
6,768
43,803
1,588
59,940
116,681
20,497
5,987
203,105
59,099
12,719
71,818
41,417
113,235
89,870
C
Macy's
27,931
16,725
11,206
8,440
88
2,678
388
(134)
2,156
767
1,389
1,836
371
5,308
361
7,876
8,196
3,743
1,176
20,991
4,951
124
5,075
6,806
3,059
14,940
6,051
D
Transcribed Image Text:A Comparison of Firm Performance 1 2 2013 Financials 3 Net operating revenues 4 Cost of goods sold 5 Gross profit 6 Selling, general, and administrative expense 7 Other costs 8 Operating income 9 Interest expense 10 Other income (loss) - net 11 Income before income taxes 12 Income taxes 13 Net income 14 Assets 15 Cash and cash equivalents 16 Net receivables 17 Inventories 18 Prepaid expenses and other 19 Total current assets 20 Property, plant and equipment 21 Goodwill 22 Other assets 23 Total assets 24 Liabilities and Stockholder Equity 25 Accounts payable 26 Short-term debt 27 Total current liability 28 Long-term debt 29 Other liabilities 30 Total liabilities 31 Stockholder equity 32 B Walmart 469,162 352,488 116,674 88,873 27,801 2,251 187 25,737 7,981 17,756 7,781 6,768 43,803 1,588 59,940 116,681 20,497 5,987 203,105 59,099 12,719 71,818 41,417 113,235 89,870 C Macy's 27,931 16,725 11,206 8,440 88 2,678 388 (134) 2,156 767 1,389 1,836 371 5,308 361 7,876 8,196 3,743 1,176 20,991 4,951 124 5,075 6,806 3,059 14,940 6,051 D
Using the financial statements in the attached workbook (Walmart Macys Financials.xlsx), calculate ROA, Profit Margin, Asset Turn-over, and Cash-to-cash
cycle for Walmart and Macy's as of 2013. For returns when you calculate ROA, use a corporate tax rate of 21%.
Transcribed Image Text:Using the financial statements in the attached workbook (Walmart Macys Financials.xlsx), calculate ROA, Profit Margin, Asset Turn-over, and Cash-to-cash cycle for Walmart and Macy's as of 2013. For returns when you calculate ROA, use a corporate tax rate of 21%.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
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