Answered step by step
Verified Expert Solution
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
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