Determine what amounts are needed to calculate the ratios requested. For example you need Current Assets and Current Liabilities to compute the Current Ratio. Enter the names of the items needed in the boxes in column A for each of the ratios. See Ratios Tab, column A for Current Ratio. Next, use the cell reference function and any other necessary formulas to enter the numbers for each of the items for each of the companies in the boxes under the requested ratios. Again see Ratios Tab Columns C and E for the Current Ratio for Walmart and for Amazon. Next use the numbers you have entered to calculate the ratios requested. Again see the Ratios Tab Columns C and E for Current Ratio for Walmart and for Amazon. Final step - So that we can see your use of formulas you must use the following steps to display your formulas for the ratios on the Ratios Formula Tab. Copy all of the Ratios information from the Ratios Tab to the Ratios formulas tab. Highlight the entire ratios information area and press the "ctrl" key and the "~" key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed on the Ratio Formulas Tab page and the numbers displayed on the Ratios Tab.

When you have downloaded both sets of statements, you will copy over the following 2018 statement information for both companies to this file under each company's Tab and you will need to complete the project in this file. This file is the file you must upload: Consolidated Income Statement, Consolidated Balance Sheet, Consolidated Statements of Cash Flows You will see three columns with the headings of 2018, 2017, 2016, with the financial data underneath it. SUGGESTED STEPS FOR COMPLETION OF THE PROJECT: Determine what amounts are needed to calculate the ratios requested. For example you need Current Assets and Current Liabilities to compute the Current Ratio. Enter the names of the items needed in the boxes in column A for each of the ratios. I have completed the first set of account titles. Next, use the cell reference function and any other necessary formulas to enter the numbers for each of the items for each of the companies in the boxes under the requested ratios. Next use the numbers you have entered to calculate the ratios requested. ROUND ALL RATIO AMOUNTS TO 3 DECIMAL PLACES. Repeat the steps for each of the ratios listed on the Ratio Tab. Assume all sales were on credit where necessary. Final step - So that we can see your use of formulas you must use the following steps to display your formulas for the ratios on the Ratios Formula Tab. Copy all of the Ratios information from the Ratios Tab to the Ratios formulas tab. Highlight the entire ratios information area and press the "ctrl" key and the "-"key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed on the Ratio Formulas Tab page and the numbers displayed on the Ratios Tab. -------- ------------- ------ Ratios WALMART AMAZON 5 Current Ratio 0.799 1.098 & Current Assets 61,897 75,101 10 Current Liabilities 77.477 68,391 13 Debt to Asset Ratio 14 16 Totalities 17 18 Total Assets 21 Return on Equity 22 28 Return on Assets 35 Inventory Turnover UUU UUU UUU 42 Dags in Inventory 49 Accounts Receivable Turnover 50 53 56 Times Interest Earned 60 65 Free Cash Flow Gross Profit Rate Profit Margin - - 86 Turnover - - N Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 $ 21,856 $ 19,934 $ 16,175 10,073 3,033 2,371 15,341 11,478 8,116 5,418 274 Statement of Cash Flows [Abstract] CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, BEGINNING OF PERIOD OPERATING ACTIVITIES: Net income Adjustments to reconcile net income to net cash from operating activities: Depreciation of property and equipment and other amortization, including capitalized content costs Stock-based compensation Other operating expense, net Other expense (income), net Deferred income taxes Changes in operating assets and liabilities: Inventories Accounts receivable, net and other Accounts payable Accrued expenses and other Unearned revenue Net cash provided by (used in) operating activities INVESTING ACTIVITIES: Purchases of property and equipment 4.215 202 (292) (29) 2,975 160 (20) (246) 219 441 (1,314) (4,615) 3,263 472 1,151 30,723 (3,583) (4,780) 7,100 283 (1,426) (3,436) 5,030 1,724 1,955 17,203 738 18,365 13,427 (11,955) (7,804) Proceeds from property and equipment incentives 2,104 1,897 1,067 (2,186) 8,240 (7,100) (12,369) (13,972) 9,677 (12,731) (27,084) (116) 4,577 (7,240) 9,516) Acquisitions, net of cash acquired, and other Sales and maturities of marketable securities Purchases of marketable securities Net cash provided by (used in) investing activities FINANCING ACTIVITIES: Proceeds from long-term debt and other Repayments of long-term debt and other Principal repayments of capital lease obligations Principal repayments of finance lease obligations Net cash provided by (used in) financing activities Foreign currency effect on cash, cash equivalents, and restricted cash Net increase (decrease) in cash, cash equivalents, and restricted cash CASH, CASH EQUIVALENTS, AND RESTRICTED CASH, END OF PERIOD SUPPLEMENTAL CASH FLOW INFORMATION: Cash paid for interest on long-term debt Cash paid for interest on capital and finance lease obligations Cash paid for income taxes, net of refunds Property and equipment acquired under capital leases Property and equipment acquired under build-to-suit leases 768 (668) (7,449) (337) (7,686) (351) 10,317 32,173 16,228 (1,301) (4,799) (200) 9,928 713 1,922 21,856 618 (327) (3,860) (147) (3,716) (212) 3,759 19,934 290 854 575 1,184 10,615 $ 3,641 328 319 957 9,637 S3,541 206 412 5,704 $ 1,209 F 1 Amazon Financial Statement Dec 31, 2018 Dec 31, 2017 Consolidated Statements of Operations - USD ($) shares in Millions, $ in Millions 12 Months Ended Dec 31, 2018 Dec 31, 2017 $ 232,887 $177,866 Dec 31, 2016 $135,987 $ 31,750 Consolidated Balance Sheets - USD (5) Sin Millions Current assets: Cash and cash equivalents Marketable securities Inventories Accounts receivable, net and other Total current assets Property and equipment, net 4 Total net sales 5 Operating expenses: 6 Cost of sales 7 Fulfillment 8 Marketing Expense Technology and content 9,500 139,156 34,027 13,814 28,837 111,934 25,249 10,069 22,620 88,265 17,619 7,233 16,085 17,174 16,677 75,101 61,797 $ 20,522 10,464 16,047 13,164 60,197 48,866 14,548 11,202 162,648 13,350 8,897 131,310 10 General and administrative 11 Other operating expense, net 12 Total operating expenses 13 Operating income (loss) 14 Interest income 15 Interest expense 16 Other income (expense), net 17 Total non-operating income (expense) 18 Income before income taxes 19 Provision for income taxes 20 Equity-method investment activity, net of tax 21 Net income Basic earnings per share 4,336 296 220,466 12,421 440 1,417 (183) (1,160) 11,261 1,197 3,674 214 173,760 4,106 202 (848) 346 (300) 3,806 (769) 2,432 167 131,801 4,186 100 (484) 90 (294) 3,892 (1,425) (96) $ 2,371 $5.01 38,192 23,663 6,536 68,391 23,495 27,213 34,616 18,170 5,097 57,883 24,743 20,975 Goodwill Other assets Total assets Current liabilities: Accounts payable Accrued expenses and other Unearned revenue Total current liabilities Long-term debt Other long-term liabilities Commitments and contingencies (Note 7) Stockholders' equity: Preferred stock, $0.01 par value: Authorized shares - 500 Issued and outstanding shares - none Common stock, $0.01 par value: Authorized shares - 5,000 Issued shares - 507 and 514 Outstanding shares - 484 and 491 Treasury stock, at cost Additional paid-in capital Accumulated other comprehensive loss Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $ 10,073 $20.68 $3,033 $6.32 Diluted earnings per share $ 20.14 $6.15 $4.90 487 500 480 493 474 484 24 Weighted average shares used in computation of earnings per share: 25 Basic (in shares) 26 Diluted in shares) 27 Net product sales 28 Total net sales 29 Net service sales 30 Total net sales (1,837) 26,791 (1,035) 19,625 43,549 $ 162,648 (1,837) 21,389 (484) 8,636 27,709 $ 131,310 $ 141,915 $118,573 $94,665 $ 90,972 $59,293 $41,322 Walmart Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions 12 Months Ended Jan. 31, 2017 Jan. 31, 2018 Jan. 31, 2016 $ 495,761 4,582 500,343 $ 481,317 4,556 485,873 $ 478,614 3,516 482,130 373,396 106,510 20,437 361,256 101,853 22,764 360,984 97,041 24,105 2,027 521 2,044 323 (100) 2,267 3 Revenues: 4 Net sales 5 Membership and other income 6 Total revenues 7 Costs and expenses: 8 Cost of sales 9 Operating, selling, general and administrative expenses 10 Operating income 11 Interest: 12 Debt 13 Capital lease and financing obligations 14 Interest income 15 Interest, net 16 Gain (loss) on extinguishment of debt 17 Income before income taxes 18 Provision for income taxes 19 Consolidated net income 20 Consolidated net income attributable to noncontrolling interest 21 Consolidated net income attributable to Walmart 22 Net income per common share: 23 Basic net income per common share attributable to Walmart 24 Diluted net income per common share attributable to Walmart 25 Weighted average common shares outstanding: 26 Basic 27 Diluted 28 Dividends declared per common share 0 1,978 352 (152) 2,178 3,136 15,123 4,600 10,523 (661) $ 9,862 20,497 6,204 14,293 (650) $ 13,643 (81) 2,467 0 21,638 6,558 15,080 (386) $ 14,694 $3.29 $ 3.28 $4.40 $ 4.38 $ 4.58 $ 4.57 2,995 3,010 $2.04 3,101 3,112 $ 2 3,207 3,217 $ 1.96 29 30 Walmart Consolidated Statements of Comprehensive Income - USD ($) $ in Millions 12 Months Ended Jan. 31, 2018 Jan. 31, 2017 $ 10,523 $ 14,293 (661) (650) 9,862 13,643 Jan. 31, 2016 $ 15,080 (386) 14,694 (5,220) 3 Consolidated net income Consolidated net income attributable to noncontrolling interest 5 Consolidated net income attributable to Walmart 6 Other comprehensive income (loss), net of income taxes 7 Currency translation and other 8 Unrealized gain on available-for-sale securities 9 Minimum pension liability 10 Other comprehensive income (loss), net of income taxes 11 Less other comprehensive income (loss) attributable to noncontrolling interest 12 Other comprehensive income (loss) attributable to Walmart 13 Comprehensive income, net of income taxes 14 Comprehensive (income) loss attributable to noncontrolling interest 15 Comprehensive income attributable to Walmart 16 Net investment hedging 17 Other comprehensive income (loss), net of income taxes 18 Derivative instruments 19 Cash flow hedging 20 Other comprehensive income (loss), net of income taxes 21 Derivative instruments 22 2,540 1,501 147 4,220 (169) 4,051 14,743 (830) 13,913 (3,027) 145 (397) (2,845) 210 (2,635) 11,448 (440) 11,008 86 (4,970) 541 (4,429) 10,110 155 10,265 (405) 413 366 $ 437 $ 21 $ (202) 24 Jan 31, 2018 Jan. 31, 2017 $ 6,756 5,614 43,783 3,511 59,664 $6,867 5.835 43,046 1,941 57,689 185,154 177.479) 107,675 179.492 171,782) 107,710 12,703 (5,560) 7.143 18,242 11,798 204,522 11,637 (5.169) 6,468 17,037 9.921 198,825 Walmart Consolidated Balance Sheets - USD $ $ In Millions 2 Current assets: 3 Cash and cash equivalents 4 Receivables, net 5 Inventories 6 Prepaid expenses and other 7 Total current assets 8 Property and equipment: 9 Property and equipment 10 Less accumulated depreciation 11 Property and equipment, net 12 Property under capital lease and financing obligations: 13 Property under capital lease and financing obligations 14 Less accumulated amortization 15 Property under capital lease and financing obligations, net 16 Goodwill 17 Other assets and deferred charges 18 Total assets 19 Current liabilities: 20 Short-term borrowings 21 Accounts payable 22 Accrued abilities 23 Accrued income taxes 24 Long-term debt due within one year 25 Capital lease and financing obligations due within one year 26 Total current liabilities 27 Long-term debt 28 Long-term capital lease and financing obligations 29 Deerred income taxes and other Commitments and contingencies 31 Equity 32 Common stock 33 Capital in excess of par value 34 Retained earnings 35 Accumulated other comprehensive loss 36 Total Walmart shareholders' equity 37 Noncontrolling interest 38 Total equity 39 Total liabilities and equity 5,257 46,092 22,122 6.45 3,738 667 78,521 30,045 6,780 8,354 1,099 41 433 20,654 921 2,256 565 66,928 36,015 6,003 9.344 295 2,648 85,107 (10,181) 77.869 2.953 80,822 $ 204,522 305 2,371 89,354 (14,232) 77,798 2737 80,535 $198.825