Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part-2 Case-1-Part-2 Excel file contains the financial results for Walmart and Macy's for 2012. a) Evaluate the financial performance of each company, such as
Part-2 Case-1-Part-2 Excel file contains the financial results for Walmart and Macy's for 2012. a) Evaluate the financial performance of each company, such as ROA, ROE, APT, C2C, ART, INVT, and PPET. Performance Metrics Walmart Macy's Return on Assets Return on Equity APT ART INVT PPET C2C (Weeks) b) Which metrics does each company perform better on? c) What might supply chain drivers explain this difference in performance? A B C 1 2 Walmart Macy's 3 Net operating revenues 469,162 27,686 4 Cost of goods sold 352,488 16,538 5 Gross profit 116,674 11,148 6 Selling, general, and administrative expense 88,873 8,482 7 Operating income 27,801 2,661 8 Interest expense 2,251 425 9 Other income (loss) - net 187 (134) 10 Income before income taxes 11 Income taxes 12 Net income 13 Assets 14 Cash and cash equivalents 15 Net receivables 16 Inventories 17 Total current assets 25,737 2,102 7,981 767 17,756 1,198 7,781 1,836 6,768 371 43,803 5,308 59,940 7,876 18 Property, plant and equipment 116,681 8,196 19 Goodwill 20,497 3,743 20 Other assets 5,987 615 21 Total assets 203,105 20,991 22 Liabilities and Stockholder Equity 23 Accounts payable 59,099 4,951 24 Short-term debt 12,719 124 25 Total current liability 71,818 5,075 26 Long-term debt 41,417 6,806 27 Total liabilities 126,243 14,940 28 Stockholder equity 76,343 6,051
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