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%.
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%.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question

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

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images

Recommended textbooks for you


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education