Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

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

Accounting Principles

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

9th Edition

978-0470317549, 9780470387085, 047031754X, 470387084, 978-0470533475

More Books

Students also viewed these Accounting questions

Question

When is the application deadline?

Answered: 1 week ago