Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What supply chain drivers and metrics might explain this difference in performance? Q1 Financial Measures Walmart Macys 1. ROE =Earnings Before Interest/Share holders Equity =17,756/81,738

What supply chain drivers and metrics might explain this difference in performance?

Q1

Financial Measures

Walmart

Macys

1. ROE

=Earnings Before Interest/Share holders Equity

=17,756/81,738

=.2172 or 21.72%

=1,486/6,051=

= 0.2455 or 24.56%

chain2. ROA

=Net Income + [Interest Expense * (1-0.35)] / Average Total Assets

=17,756 + [2251 * .65]/203,105

= 17,756 + 1463.15 = 19,219

=19219.15/203,105

=.0946 or 9.46%

=1,486 + [388 * (1- 0.35)]/20,991

= 1,486 + 252.20 =1,738.20

=1,738.20/20,991

= 0.0828

=8.28%

3. ROFL

=ROE-ROA

=21.72-9.46

=12.26%

= 25-8.28

=16.72%

4. Profit Margin

= Net Income + [Interest Expense * (1-0.35)] /Sales Revenue * 100

=17,756 + [2251 * .65] = 19,219

=19,219/469,162=.0410* 100

=4.10%

=1,738.20/27,931=.0622* 100

=6.22%

5. Asset Turnover

=Sales Revenue/Total Assets

=496,162/203,105

=2.31

=27,031/20,991

=1.33

6. APT

=Cost of Goods Sold/Accounts Payable

=352,488/59,099

=5.96

=16,752/4,951

=3.38

7. ART

=Sales Revenue/Accounts Receivable

=469,162/6,768

=69.32

=27,931/371

=75.29

8. INVT

=Cost of Goods Sold/Inventory

=352,488/43,803

=8.05

=16,752/5,308

=3.16

9. PPET

=Sales Revenue/PP&E

=469,162/116,861

=4.02

=27,931/8,196

=3.41

10. C2C

=negative Weeks Payable (1/APT) + Weeks in Inventory (1/INVT) + Weeks Receivable (1/ART)

= negative 1/5.96 + 1/8.05 + 1/69.32

= -0.17 + 0.12 + 0.01

= -.04 times 52 weeks

= -2.08

= negative 1/3.38 + 1/3.16 + 1/75.29

= -0.30 + 0.32 + 0.01

= 0.03 times 52 weeks

= 1.56 weeks

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Financial Reporting

Authors: Alan Melville

7th Edition

1292293128, 9781292293127

More Books

Students also viewed these Accounting questions