Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

compare and contrast the the companies ratios, focusing on the Dupont Analysis ratios for all three companies why is the NPM ratio for Walmart bigger

compare and contrast the the companies ratios, focusing on the Dupont Analysis ratios for all three companies

why is the NPM ratio for Walmart bigger than the the NPM for Amazon?

Are the differences stable or are they changing over time

Is Sales growing faster than Assets

Are assets growing at all? Are there one particular type of asset that is growing faster than others

FINANCIAL STATEMENTS AMZN HD WMT
Income Statement 2016-12 2015-12 2014-12 2013-12 2012-12 2017-01 2016-01 2015-01 2014-01 2013-01 2017-01 2016-01 2015-01 2014-01 2013-01
Revenue ($ million) 135,987 107,006 88,988 74,452 61,093 94,595 88,519 83,176 78,812 74,754 485,873 482,130 485,651 476,294 469,162
Cost of Goods Sold 88,265 71,651 62,752 54,181 45,971 62,282 58,254 54,222 51,422 48,912 361,256 360,984 365,086 358,069 352,488
Gross Profit 47,722 35,355 26,236 20,271 15,122 32,313 30,265 28,954 27,390 25,842 124,617 121,146 120,565 118,225 116,674
SG&A Expense 35,420 26,841 21,312 16,273 12,287 16,913 16,628 16,699 16,467 16,392 91,773 87,587 84,245 82,483 80,372
Depreciation & Amort 8,116 6,281 4,746 3,253 2,159 1,973 1,863 1,786 1,757 1,684 10,080 9,454 9,173 8,870 8,501
Operating Income 4,186 2,233 178 745 676 13,427 11,774 10,469 9,166 7,766 22,764 24,105 27,147 26,872 27,801
Nonoperating Inc (Expn) 190 -206 -79 -98 -40 972 919 830 711 632 100 81 113 119 187
Interest Expense 484 459 210 141 92 36 166 337 12 87 2,367 2,548 2,461 2,335 2,251
Income Before Taxes 3,892 1,568 -111 506 544 12,491 11,021 9,976 8,467 7,221 20,497 21,638 24,799 24,656 25,737
Income Taxes 1,521 972 130 232 583 4,534 4,012 3,631 3,082 2,686 6,204 6,558 7,985 8,105 7,981
Net Income After Taxes 2,371 596 -241 274 -39 7,957 7,009 6,345 5,385 4,535 14,293 15,080 16,814 16,551 17,756
Abbreviated Cash Flow Statement 2016-12 2015-12 2014-12 2013-12 2012-12 2017-01 2016-01 2015-01 2014-01 2013-01 2017-01 2016-01 2015-01 2014-01 2013-01
Net income 2,371 596 -241 274 -39 7,957 7,009 6,345 5,385 4,535 14,293 15,080 17,099 16,695 17,756
Depreciation & amortization 8,116 6,281 4,746 3,253 2,159 1,973 1,863 1,786 1,757 1,684 10,080 9,454 9,173 8,870 8,501
Other Noncash expenses 2,975 2,119 1,497 1,134 833 267 100 -98 228 315 206 1,410 785 938 527
Aggregate Changes in Net Working Capital 2,981 2,924 840 814 1,227 -414 401 209 258 441 6,951 1,445 1,507 -3,246 -1,193
Cash Flow from Operating Activities 16,443 11,920 6,842 5,475 4,180 9,783 9,373 8,242 7,628 6,975 31,530 27,389 28,564 23,257 25,591
Investments in prop, plant, and equip -6,737 -4,589 -4,893 -3,444 -3,785 -1,621 -1,503 -1,442 -1,389 -1,312 -10,163 -10,842 -11,604 -12,388 -12,366
Other investing activities -3,139 -1,861 -172 -832 190 38 -1,479 171 -118 -120 -3,824 167 479 90 -245
Cash Flow from Investing Activities -9,876 -6,450 -5,065 -4,276 -3,595 -1,583 -2,982 -1,271 -1,507 -1,432 -13,987 -10,675 -11,125 -12,298 -12,611
Net debt issuance (repayment) -3,740 -3,882 4,426 -617 2,790 2,274 4,012 2,232 3,933 -32 -3,591 -3,158 -5,018 3,015 1,487
Common stock repurchased 0 0 0 0 -960 -6,662 -6,772 -6,748 -8,305 -3,200 -8,298 -4,112 -1,015 -6,683 -7,600
Dividend paid 0 0 0 0 0 -3,404 -3,031 -2,530 -2,243 -1,743 -6,216 -6,294 -6,185 -6,139 -5,361
Other financing activities 829 119 6 78 429 -78 4 -25 -37 -59 -824 -2,558 -2,853 -1,210 -498
Cash Flow from Financing Activities -2,911 -3,763 4,432 -539 2,259 -7,870 -5,787 -7,071 -6,652 -5,034 -18,929 -16,122 -15,071 -11,017 -11,972
Free Cash Flow 9,706 7,331 1,949 2,031 395 8,162 7,870 6,800 6,239 5,663 21,367 16,547 16,960 10,869 13,225

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

Introductory Econometrics For Finance

Authors: Chris Brooks

2nd Edition

052169468X, 9780521694681

More Books

Students also viewed these Finance questions

Question

Explain the concept of a microservice architecture.

Answered: 1 week ago