Amazon

Walmart

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. Dec. 31, 2018 Dec. 31, 2017 Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cash and cash equivalents Marketable securities Inventories Accounts receivable, net and other Total current assets Property and equipment, net $ 31,750 9,500 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 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 (1,837) 26,791 (1,035) 19,625 43,549 $ 162,648 (1,837) 21,389 (484) 8,636 27,709 $ 131,310 618 (327) (3,860) (147) 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 (3,716) (212) 3,759 19,934 854 575 1,184 10,615 $3,641 328 319 957 9,637 $3,541 290 206 412 5,704 $ 1,209 Jan. 31, 2019 Jan. 31, 2018 12 Months Ended Jan. 31, 2019 Jan. 31, 2018 Jan. 31, 2017 Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cash and cash equivalents Receivables, net Inventories $ 481,317 4,556 $ 7,722 6,283 44,269 $ 6,756 5,614 43,783 4,076 4,582 514,405 500,343 485,873 3,623 61,897 3,511 59,664 385,301 107,147 21,957 373,396 106,510 20,437 361,256 101,853 22,764 185,810 (81,493) 104,317 185,154 77,479 107,675 1,975 1,978 371 352 2,044 323 (100) 2,267 (217) 2,129 (152) 2,178 3,136 12,760 (5,682) 7,078 31,181 14,822 219,295 12,703 (5,560) 7,143 18,242 11,798 204,522 8,368 11,460 4,281 7,179 (509) $ 6,670 15,123 4,600 10,523 (661) $ 9,862 20,497 6,204 14,293 (650) $ 13,643 Prepaid expenses and other Total current assets Property and equipment: Property and equipment Less accumulated depreciation Property and equipment, net Property under capital lease and financing obligations: Property under capital lease and financing obligations Less accumulated amortization Property under capital lease and financing obligations, net Goodwill Other long-term assets Total assets Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Capital lease and financing obligations due within one year Total current liabilities Long-term debt Long-term capital lease and financing obligations Deferred income taxes and other Commitments and contingencies Equity: Common stock Capital in excess of par value Retained earnings Accumulated other comprehensive loss Total Walmart shareholders' equity Noncontrolling interest Total equity Total liabilities and equity $ 2.28 $ 2.26 $ 3.29 $ 3.28 $ 4.40 $4.38 5,225 47,060 22,159 428 1,876 729 77,477 43,520 6,683 11,981 5,257 46,092 22,122 645 3,738 667 78,521 30,045 6,780 8,354 2,929 2,945 $ 2.08 2,995 3,010 $2.04 3,101 3,112 $ 2 288 2,965 80,785 (11,542) 72,496 7,138 79,634 $ 219,295 295 2,648 85,107 (10,181) 77,869 2,953 80,822 $ 204,522 Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended Jan. 31, 2019 Jan. 31, 2018 Jan. 31, 2017 $ 7,179 $ 10,523 $ 14,293 10,529 10,080 10,678 3,516 4,850 (499) 0 1,734 761 (304) 3,136 1,210 0 206 Cash flows from operating activities: Consolidated net income Adjustments to reconcile income from continuing operations to net cash provided by operating activities: Depreciation and amortization Unrealized Gain (Loss) on Investments (Gains) and losses for disposal of business operations Deferred income taxes Loss on extinguishment of debt Other operating activities Changes in certain assets and liabilities, net of effects of acquisitions: Receivables, net Inventories Accounts payable Accrued liabilities Accrued income taxes Net cash provided by operating activities Cash flows from investing activities: Payments for property and equipment Proceeds from the disposal of property and equipment Proceeds from the disposal of certain operations Purchase of available for sale securities Payments for business acquisitions, net of cash acquired Other investing activities Net cash used in investing activities (368) (1,311) 1,831 183 (40) 27,753 (1,074) (140) 4,086 928 (557) 28,337 (402) 1,021 3,942 1,280 492 31,673 10,344 519 876 10,051 378 1,046 10,619 456 662 (1,901) (2,463) (31) (13,896) (14,656) (431) (24,036) (375) (77) (9,079) (53) 15,872 (3,784) (1,673) 137 (2,055) 6,102 (7,410) (431) Cash flows from financing activities: Net change in short-term borrowings Proceeds from issuance of long-term debt Repayments of long-term debt Premiums paid to extinguish debt Dividends paid Purchase of Company stock Dividends paid to noncontrolling interest Purchase of noncontrolling interest Other financing activities Net cash used in financing activities Effect of Exchange Rate on Cash, Cash Equivalents, and Restricted Cash Net increase (decrease) in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash at beginning of year Cash, cash equivalents and restricted cash at end of period Supplemental disclosure of cash flow information: Income taxes paid Interest paid 4,148 7,476 (13,061) (3,059) 6,124 (8,296) (690) (8) (261) (19,875) 487 (130) 7,144 7,014 (629) (2,537) (438) 742 7,014 7,756 6,216 (8,298) (479) (90) (398) (19,072) (452) (1,747) 8,891 7,144 3,982 $ 2,348 6,179 $ 2,450 4,507 $ 2,351 Ratios WALMART AMAZON 5 Current Ratio 0.799 1.098 8 Current Assets 75,101 61,897 77,477 D D 68,391 10 Current Liabilities 11 12 13 Debt to Asset Ratio 14 15 16 18 21 Return on Equity 28 Return on Assets Inventory Turnover 36 Days in Inventory Accounts Receivable Turnover UPP 94 ha annan hon MH - Times Interest Earned Free Cash Flow 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. Dec. 31, 2018 Dec. 31, 2017 Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cash and cash equivalents Marketable securities Inventories Accounts receivable, net and other Total current assets Property and equipment, net $ 31,750 9,500 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 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 (1,837) 26,791 (1,035) 19,625 43,549 $ 162,648 (1,837) 21,389 (484) 8,636 27,709 $ 131,310 618 (327) (3,860) (147) 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 (3,716) (212) 3,759 19,934 854 575 1,184 10,615 $3,641 328 319 957 9,637 $3,541 290 206 412 5,704 $ 1,209 Jan. 31, 2019 Jan. 31, 2018 12 Months Ended Jan. 31, 2019 Jan. 31, 2018 Jan. 31, 2017 Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cash and cash equivalents Receivables, net Inventories $ 481,317 4,556 $ 7,722 6,283 44,269 $ 6,756 5,614 43,783 4,076 4,582 514,405 500,343 485,873 3,623 61,897 3,511 59,664 385,301 107,147 21,957 373,396 106,510 20,437 361,256 101,853 22,764 185,810 (81,493) 104,317 185,154 77,479 107,675 1,975 1,978 371 352 2,044 323 (100) 2,267 (217) 2,129 (152) 2,178 3,136 12,760 (5,682) 7,078 31,181 14,822 219,295 12,703 (5,560) 7,143 18,242 11,798 204,522 8,368 11,460 4,281 7,179 (509) $ 6,670 15,123 4,600 10,523 (661) $ 9,862 20,497 6,204 14,293 (650) $ 13,643 Prepaid expenses and other Total current assets Property and equipment: Property and equipment Less accumulated depreciation Property and equipment, net Property under capital lease and financing obligations: Property under capital lease and financing obligations Less accumulated amortization Property under capital lease and financing obligations, net Goodwill Other long-term assets Total assets Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Capital lease and financing obligations due within one year Total current liabilities Long-term debt Long-term capital lease and financing obligations Deferred income taxes and other Commitments and contingencies Equity: Common stock Capital in excess of par value Retained earnings Accumulated other comprehensive loss Total Walmart shareholders' equity Noncontrolling interest Total equity Total liabilities and equity $ 2.28 $ 2.26 $ 3.29 $ 3.28 $ 4.40 $4.38 5,225 47,060 22,159 428 1,876 729 77,477 43,520 6,683 11,981 5,257 46,092 22,122 645 3,738 667 78,521 30,045 6,780 8,354 2,929 2,945 $ 2.08 2,995 3,010 $2.04 3,101 3,112 $ 2 288 2,965 80,785 (11,542) 72,496 7,138 79,634 $ 219,295 295 2,648 85,107 (10,181) 77,869 2,953 80,822 $ 204,522 Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended Jan. 31, 2019 Jan. 31, 2018 Jan. 31, 2017 $ 7,179 $ 10,523 $ 14,293 10,529 10,080 10,678 3,516 4,850 (499) 0 1,734 761 (304) 3,136 1,210 0 206 Cash flows from operating activities: Consolidated net income Adjustments to reconcile income from continuing operations to net cash provided by operating activities: Depreciation and amortization Unrealized Gain (Loss) on Investments (Gains) and losses for disposal of business operations Deferred income taxes Loss on extinguishment of debt Other operating activities Changes in certain assets and liabilities, net of effects of acquisitions: Receivables, net Inventories Accounts payable Accrued liabilities Accrued income taxes Net cash provided by operating activities Cash flows from investing activities: Payments for property and equipment Proceeds from the disposal of property and equipment Proceeds from the disposal of certain operations Purchase of available for sale securities Payments for business acquisitions, net of cash acquired Other investing activities Net cash used in investing activities (368) (1,311) 1,831 183 (40) 27,753 (1,074) (140) 4,086 928 (557) 28,337 (402) 1,021 3,942 1,280 492 31,673 10,344 519 876 10,051 378 1,046 10,619 456 662 (1,901) (2,463) (31) (13,896) (14,656) (431) (24,036) (375) (77) (9,079) (53) 15,872 (3,784) (1,673) 137 (2,055) 6,102 (7,410) (431) Cash flows from financing activities: Net change in short-term borrowings Proceeds from issuance of long-term debt Repayments of long-term debt Premiums paid to extinguish debt Dividends paid Purchase of Company stock Dividends paid to noncontrolling interest Purchase of noncontrolling interest Other financing activities Net cash used in financing activities Effect of Exchange Rate on Cash, Cash Equivalents, and Restricted Cash Net increase (decrease) in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash at beginning of year Cash, cash equivalents and restricted cash at end of period Supplemental disclosure of cash flow information: Income taxes paid Interest paid 4,148 7,476 (13,061) (3,059) 6,124 (8,296) (690) (8) (261) (19,875) 487 (130) 7,144 7,014 (629) (2,537) (438) 742 7,014 7,756 6,216 (8,298) (479) (90) (398) (19,072) (452) (1,747) 8,891 7,144 3,982 $ 2,348 6,179 $ 2,450 4,507 $ 2,351 Ratios WALMART AMAZON 5 Current Ratio 0.799 1.098 8 Current Assets 75,101 61,897 77,477 D D 68,391 10 Current Liabilities 11 12 13 Debt to Asset Ratio 14 15 16 18 21 Return on Equity 28 Return on Assets Inventory Turnover 36 Days in Inventory Accounts Receivable Turnover UPP 94 ha annan hon MH - Times Interest Earned Free Cash Flow