Review the company information in the Course Project Folder on the Learning Modules page. You will need this information to complete this part of the project.

Create one chart in Excel that shows your ratio calculations for both companies. Use the template provided.

1) The first column lists the name of each ratio youre calculating.

In your chart, you need to compute all of these ratios for both companies:

Current ratio

Accounts Receivables turnover

Average collection period

Inventory turnover

Days in inventory

Profit margin

Asset turnover

Return on assets

Return on common stockholders equity

Debt to total assets ratio

Times interest earned

Free cash flow

2) Next you have columns for Amazons ratio calculations and results. In the heading for these columns, indicate the company name and fiscal year. Make sure to show your work, so I can view your work and award partial credit if applicable.

Round your answers to 2 decimal places. Also, make notes for each calculation as to where you found the information. This will help you obtain partial information if appropriate.

3) Next, you have columns for Wal-Marts ratio calculations and results. In the heading for these columns, indicate the company name and the fiscal year.

Make sure to show your work so I can view your work. Round your answers to 2 decimal places. Also, make notes for each calculation as to where you found the information. This will help you obtain partial information if appropriate.

4) Finally, you have a column called Company with the More Favorable Result. In this column you will identify which company has the more favorable result for each ratio and why it is more favorable. You must show all of your calculations for your ratio results. If you do not show your calculations, points will be subtracted from your score. See the instructions above for showing your calculations.

AMAZON.COM, INC. CONSOLIDATED BALANCE SHEETS (in millions, except per share data) December 31, 2017 2018 ASSETS Current assets: Cash and cash equivalents $ 20,522 $ 31,750 Marketable securities 10,464 9,500 Inventories 16,047 17,174 Accounts receivable, net and other 13,164 16,677 Total current assets 60,197 75,101 Property and equipment, net 48,866 61,797 Goodwill 13,350 14,548 Other assets 8,897 11,202 Total assets $ 131,310 $ 162,648

AMAZON.COM, INC. CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME STATEMENT (in millions) Year Ended December 31, 2016 2017 2018 Net income $ 2,371 $ 3,033 $ 10,073 Other comprehensive income (loss): Foreign currency translation adjustments, net of tax of $(49), $5, and $6 (279) 533 (538) Net change in unrealized gains (losses) on available-for-sale debt securities: Unrealized gains (losses), net of tax of $(12), $5, and $0 9 (39) (17) Reclassification adjustment for losses (gains) included in Other income (expense), net, net of tax of $0, $0, and $0 878 Net unrealized gains (losses) on available-for-sale debt securities 17 (32) (9) Total other comprehensive income (loss) (262) 501 (547) Comprehensive income $ 2,109 $ 3,534 $ 9,5

Walmart Inc. Consolidated Statements of Comprehensive Income Fiscal Years Ended January 31, (Amounts in millions) 2019 2018 2017 Consolidated net income $ 7,179 $ 10,523 $ 14,293 Consolidated net income attributable to noncontrolling interest (509) (661) (650) Consolidated net income attributable to Walmart 6,670 9,862 13,643 Other comprehensive income (loss), net of income taxes Currency translation and other (226) 2,540 (3,027) Net investment hedges 272 (405) 413 Cash flow hedges (290) 437 21 Minimum pension liability 131 147 (397) Unrealized gain on available-for-sale securities 1,501 145 Other comprehensive income (loss), net of income taxes (113) 4,220 (2,845) Other comprehensive (income) loss attributable to noncontrolling interest 188 (169) 210 Other comprehensive income (loss) attributable to Walmart 75 4,051 (2,635) Comprehensive income, net of income taxes 7,066 14,743 11,448 Comprehensive (income) loss attributable to noncontrolling interest (321) (830) (440) Comprehensive income attributable to Walmart $ 6,745 $ 13,913 $ 11,008

Walmart Inc. Consolidated Balance Sheets As of January 31, (Amounts in millions) 2019 2018 ASSETS Current assets: Cash and cash equivalents $ 7,722 $ 6,756 Receivables, net 6,283 5,614 Inventories 44,269 43,783 Prepaid expenses and other 3,623 3,511 Total current assets 61,897 59,664 Property and equipment: Property and equipment 185,810 185,154 Less accumulated depreciation (81,493) (77,479) Property and equipment, net 104,317 107,675 Property under capital lease and financing obligations: Property under capital lease and financing obligations 12,760 12,703 Less accumulated amortization (5,682) (5,560) Property under capital lease and financing obligations, net 7,078 7,143 Goodwill 31,181 18,242 Other long-term assets 14,822 11,798 Total assets $ 219,295 $ 204,522 LIABILITIES AND EQUITY Current liabilities: Short-term borrowings $ 5,225 $ 5,257 Accounts payable 47,060 46,092 Accrued liabilities 22,159 22,122 Accrued income taxes 428 645 Long-term debt due within one year 1,876 3,738 Capital lease and financing obligations due within one year 729 667 Total current liabilities 77,477 78,521 Long-term debt 43,520 30,045 Long-term capital lease and financing obligations 6,683 6,780 Deferred income taxes and other 11,981 8,354 Commitments and contingencies Equity: Common stock 288 295 Capital in excess of par value 2,965 2,648 Retained earnings 80,785 85,107 Accumulated other comprehensive loss (11,542) (10,181) Total Walmart shareholders' equity 72,496 77,869 Noncontrolling interest 7,138 2,953 Total equity 79,634 80,822 Total liabilities and equity $ 219,295 $ 204,522