Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone please help me with my Finance class. I need to compare Amazon and Walmart A nnual Report for 2019 only. You can calculate

Can someone please help me with my Finance class. I need to compare Amazon and Walmart Annual Report for 2019 only. You can calculate in the numbers for all the following ratios in the data below. I also attached the financial statement for Amazon and Walmart below. (Please show all your work for the table A. and the formulas used)

a.

Ratio Walmart Amazon
a. Net Income
b. EPS
c. Gross Profit Margin
d. Net profit margin
e. Return on Assets
f. Return on Equity
g. P/E ratio
h. Debt to Equity
i. Current Ratio

b. Compare all the ratios and stock price of the two companies. Using 2-3 sentences per ratio, compare and contrast the two competitors and analyze which one you think would be a better investment. (i.e. which one do you think has a greater chance of growing in the future?)

image text in transcribed

image text in transcribed

ITEM 6. SELECTED FINANCIAL DATA Five-Year Financial Summary Walmart Inc. As of and for the Fiscal Years Ended January 31, 2018 2017 2016 2019 2015 S $ S S (Amounts in millions, except per share and unit count data) Operating results Total revenues Percentage change in total revenues from previous fiscal year Net sales Percentage change in net sales from previous fiscal year Increase (decrease) in calendar comparable sales in the U.S. Walmart U.S. Sam's Club Gross profit margin Operating, selling, general and administrative expenses, as a percentage of net sales Operating income Interest, net Loss on extinguishment of debt Other (gains) and losses Income from continuing operations attributable to Walmart Diluted income per common share from continuing operations attributable to Walmart Dividends declared per common share 514,405 2.8% 510,329 2.9% 4.0% 3.7% 5.4% 24.5% 500,343 3.0% 495,761 3.0% 2.2% 2.1% 2.8% 24.7% s 485,873 0.8% S481,317 0.6% 1.4% 1.6% 0.5% 24.9% $ 482,130 (0.7)% $ 478,614 (0.7)% 0.3 % 1.0 % (3.2)% 24.6% $ 485,651 2.0% S 482,229 1.9% 0.5% 0.6% 0.0% 24.3% 21.0% 21.5% 21.2% 20.3 % 19.4% S 21,957 $ 20,437 S 22,764 $ 24,105 S 27,147 2,34 3,136 8,368 6,670 9.862 13,643 14,694 16,182 S 2.26 S 3.28 s 4.38 $ 4.57 S 4.99 2.08 2.04 2.00 1.96 1.92 s $ $ $ $ Financial position Inventories Property, equipment, capital lease and financing obligation assets, net Total assets Long-term debt and long-term capital lease and financing obligations (excluding amounts due within one year) Total Walmart shareholders' equity 44,269 111,395 219,295 43,783 114,818 204,522 43,046 114,178 198,825 44,469 116,516 199,581 45,141 116,655 203,490 50,203 36,825 42,018 44,030 43,495 72,496 77,869 77,798 80,546 81,394 Unit counts(2) Walmart U.S. segment Walmart International segment Sam's Club segment Total units 4,769 5,993 599 11,361 4,761 6,360 597 11,718 4,672 6,363 660 11,695 4,574 6,299 655 4,516 6,290 647 11,453 11,528 AMAZON.COM, INC. CONSOLIDATED STATEMENTS OF OPERATIONS (in millions, except per share data) 2019 $ Year Ended December 31, 2017 2018 118,573 $ 141,915 S 59,293 90,972 177,866 232,887 160,408 120,114 280,522 Net product sales Net service sales Total net sales Operating expenses: Cost of sales Fulfillment Technology and content Marketing General and administrative Other operating expense (income), net Total operating expenses Operating income Interest income Interest expense Other income (expense), net Total non-operating income (expense) Income before income taxes Provision for income taxes Equity-method investment activity, net of tax Net income Basic earnings per share Diluted earnings per share Weighted-average shares used in computation of earnings per share: Basic Diluted 111,934 25,249 22,620 10,069 3,674 214 173,760 4,106 202 (848) 346 (300) 3,806 (769) 139,156 34,027 28,837 13,814 4,336 296 220,466 12,421 440 (1,417) (183) (1,160) 11,261 (1,197) 9 10,073 $ 20.68 S 20.14 S 165,536 40,232 35,931 18,878 5,203 201 265,981 14,541 832 (1,600) 203 (565) 13,976 (2,374) (14) 11,588 23.46 23.01 $ $ 3,033 $ 6.32 $ 6.15 $ $ 480 487 494 493 500 504 See accompanying notes to consolidated financial statements. ITEM 6. SELECTED FINANCIAL DATA Five-Year Financial Summary Walmart Inc. As of and for the Fiscal Years Ended January 31, 2018 2017 2016 2019 2015 S $ S S (Amounts in millions, except per share and unit count data) Operating results Total revenues Percentage change in total revenues from previous fiscal year Net sales Percentage change in net sales from previous fiscal year Increase (decrease) in calendar comparable sales in the U.S. Walmart U.S. Sam's Club Gross profit margin Operating, selling, general and administrative expenses, as a percentage of net sales Operating income Interest, net Loss on extinguishment of debt Other (gains) and losses Income from continuing operations attributable to Walmart Diluted income per common share from continuing operations attributable to Walmart Dividends declared per common share 514,405 2.8% 510,329 2.9% 4.0% 3.7% 5.4% 24.5% 500,343 3.0% 495,761 3.0% 2.2% 2.1% 2.8% 24.7% s 485,873 0.8% S481,317 0.6% 1.4% 1.6% 0.5% 24.9% $ 482,130 (0.7)% $ 478,614 (0.7)% 0.3 % 1.0 % (3.2)% 24.6% $ 485,651 2.0% S 482,229 1.9% 0.5% 0.6% 0.0% 24.3% 21.0% 21.5% 21.2% 20.3 % 19.4% S 21,957 $ 20,437 S 22,764 $ 24,105 S 27,147 2,34 3,136 8,368 6,670 9.862 13,643 14,694 16,182 S 2.26 S 3.28 s 4.38 $ 4.57 S 4.99 2.08 2.04 2.00 1.96 1.92 s $ $ $ $ Financial position Inventories Property, equipment, capital lease and financing obligation assets, net Total assets Long-term debt and long-term capital lease and financing obligations (excluding amounts due within one year) Total Walmart shareholders' equity 44,269 111,395 219,295 43,783 114,818 204,522 43,046 114,178 198,825 44,469 116,516 199,581 45,141 116,655 203,490 50,203 36,825 42,018 44,030 43,495 72,496 77,869 77,798 80,546 81,394 Unit counts(2) Walmart U.S. segment Walmart International segment Sam's Club segment Total units 4,769 5,993 599 11,361 4,761 6,360 597 11,718 4,672 6,363 660 11,695 4,574 6,299 655 4,516 6,290 647 11,453 11,528 AMAZON.COM, INC. CONSOLIDATED STATEMENTS OF OPERATIONS (in millions, except per share data) 2019 $ Year Ended December 31, 2017 2018 118,573 $ 141,915 S 59,293 90,972 177,866 232,887 160,408 120,114 280,522 Net product sales Net service sales Total net sales Operating expenses: Cost of sales Fulfillment Technology and content Marketing General and administrative Other operating expense (income), net Total operating expenses Operating income Interest income Interest expense Other income (expense), net Total non-operating income (expense) Income before income taxes Provision for income taxes Equity-method investment activity, net of tax Net income Basic earnings per share Diluted earnings per share Weighted-average shares used in computation of earnings per share: Basic Diluted 111,934 25,249 22,620 10,069 3,674 214 173,760 4,106 202 (848) 346 (300) 3,806 (769) 139,156 34,027 28,837 13,814 4,336 296 220,466 12,421 440 (1,417) (183) (1,160) 11,261 (1,197) 9 10,073 $ 20.68 S 20.14 S 165,536 40,232 35,931 18,878 5,203 201 265,981 14,541 832 (1,600) 203 (565) 13,976 (2,374) (14) 11,588 23.46 23.01 $ $ 3,033 $ 6.32 $ 6.15 $ $ 480 487 494 493 500 504 See accompanying notes to consolidated financial statements

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions