Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started