Question: PLEASE HELP ONE ATTEMPT LEFT. Need free cash flow answers for Amazon and W almart. THANK YOU Question 10 of 11 2.25/3 Your answer is
PLEASE HELP ONE ATTEMPT LEFT. Need free cash flow answers for Amazon and W









almart. THANK YOU
Question 10 of 11 2.25/3 Your answer is partially correct. Amazon.com, Inc.'s financial statements are presented in Appendix D. Click here to view Appendix D. Financial statements of Wal-Mart Stores, Inc. are presented in Appendix E. Wal-Mart's fiscal year ends January 31. Click here to view Appendix E. (a) For Amazon calculate the following values for December 31, 2016 and for Wal-Mart calculate the values for January 31, 2017. (Round current ratio to 2 decimal places, e.g. 15.25:1 and Debt to assets ratio to 1 decimal place, e.g. 15.2% and all other answers to thousands. Enter negative amounts using either a negative sign preceding the number e.g.-45 or parentheses e.g. (45).) (1) Working capital. Working capital Amazon.com, Inc. $ 1,965 Wal-Mart Stores, Inc. $ (9,239) (2) Current ratio. Amazon.com, Inc. Wal-Mart Stores, Inc. (3) Debt to assets ratio. Amazon.com, Inc. Wal-Mart Stores, Inc. (4) Free cash flow. Amazon.com, Inc. Wal-Mart Stores, Inc. Current ratio 1.04 :1 0.86 :1 Debt to assets ratio Free cash flow $ $ ; 76.9 % 59.5 % 9,590 20,911 AMAZON.COM, INC. CONSOLIDATED STATEMENTS OF CASH FLOWS (in millions) 2014 $ CASH AND CASH EQUIVALENTS, BEGINNING OF PERIOD OPERATING ACTIVITIES: Net income (loss) Adjustments to reconcile net income (loss) to net cash from operating activities: Depreciation of property and equipment, including internal-use software and website development, and other amortization, including capitalized content costs Stock-based compensation Other operating expense, net Other expense (income), net Deferred income taxes Excess tax benefits from stock-based compensation Changes in operating assets and liabilities: Inventories Accounts receivable, net and other Accounts payable Accrued expenses and other Additions to unearned revenue Amortization of previously unearned revenue Net cash provided by (used in) operating activities INVESTING ACTIVITIES: Purchases of property and equipment, including internal-use software and website development, net 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: Excess tax benefits from stock-based compensation 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 and cash equivalents Net increase (decrease) in cash and cash equivalents CASH AND CASH EQUIVALENTS, 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 Year Ended December 31. 2015 14,557 $ 596 8,658 S (241) 4,746 1,497 129 59 (316) (6) (1,193) (1,039) 1,759 706 4,433 (3,692) 6,842 (4,893) (979) 3,349 (2,542) (5,065) 6 6,359 (513) (1,285) (135) 4,432 (310) 5,899 14,557 $ 91 $ 86 $ $ 177 4,008 920 See accompanying notes to consolidated financial statements. 6,281 2,119 155 250 81 (119) (2,187) (1,755) 4,294 913 7,401 (6,109) 11,920 (4,589) (795) 3,025 (4,091) (6,450) 119. 353 (1,652) (2,462) (121) (3,763) (374) 1,333 15,890 $ 325 $ 153 273 4,717 544 2016 15,890 2,371 8,116 2,975 160 (20) (246) (829) (1,426) (3,367) 5,030 1,724 11,931 (9,976) 16,443 (6,737) (116) 4,733 (7,756) (9,876) 829 621 (354) (3,860) (147) (2,911) (212) 3,444 19,334 290 206 412 5,704 1,209 AMAZON.COM, INC. CONSOLIDATED STATEMENTS OF OPERATIONS (in millions, except per share data) $ 2014 70,080 $ 18,908 88,988 62,752 10,766 4,332 9,275 1,552 133 88,810 178 39 (210) (118) (289) (111) (167) 37 $ (241) $ $ (0.52) $ (0.52) $ $ 462 462 See accompanying notes to consolidated financial statements. Net product sales Net service sales Total net sales Operating expenses: Cost of sales Fulfillment Marketing Technology and content General and administrative Other operating expense, net Total operating expenses Operating income Interest income Interest expense Other income (expense), net Total non-operating income (expense) Income (loss) before income taxes Provision for income taxes Equity-method investment activity, net of tax Net income (loss) Basic earnings per share Diluted earnings per share Weighted-average shares used in computation of earnings per share: Basic Diluted Year Ended December 31, 2015 79,268 $ 27,738 107,006 71,651 13,410 5,254 12,540 1,747 171 104,773 2,233 50 (459) (256) (665) 1,568 (950) (22) 596 $ 1.28 $ 1.25 $ 467 477 2016 94,665 41,322 135,987 88,265 17,619 7,233 16,085 2,432 167 131,801 4,186 100 (484) 90 (294) 3,892 (1,425) (96) 2,371 5.01 4.90 474 484 AMAZON.COM, INC. CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (LOSS) (in millions) Year Ended December 31, 2015 2014 Net income (loss) $ (241) $ 596 $ Other comprehensive income (loss): Foreign currency translation adjustments, net of tax of $(3), $10, and $(49) (325) (210) 2 (7) Net change in unrealized gains (losses) on available-for-sale securities: Unrealized gains (losses), net of tax of $1, $(5), and $(12) Reclassification adjustment for losses (gains) included in "Other income (expense), net," net of tax of $(1), $0, and $0 (3) 5 (1) Net unrealized gains (losses) on available-for-sale securities Total other comprehensive income (loss) (2) (212) (326) Comprehensive income (loss) $ (567) $ See accompanying notes to consolidated financial statements. 384 $ 2016 2,371 (279) 9 8 17 (262) 2,109 Current assets: Cash and cash equivalents Marketable securities Inventories Accounts receivable, net and other Total current assets Property and equipment, net Goodwill Other assets Current liabilities: AMAZON.COM, INC. CONSOLIDATED BALANCE SHEETS (in millions, except per share data) ASSETS Total assets LIABILITIES AND STOCKHOLDERS' EQUITY 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- 494 and 500 Outstanding shares-471 and 477 Treasury stock, at cost Additional paid-in capital Accumulated other comprehensive loss Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $ $ $ See accompanying notes to consolidated financial statements. 2015 December 31, 15,890 $ 3,918 10,243 5,654 35,705 21,838 3,759 3,445 64,747 $ 20,397 $ 10,372 3,118 33,887 8,227 9,249 I 5 (1,837) 13,394 (723) 2,545 13,384 64,747 $ 2016 19,334 6,647 11,461 8,339 45,781 29,114 3,784 4,723 83,402 25,309 13,739 4,768 43,816 7,694 12,607 I 5 (1,837) 17,186 (985) 4,916 19,285 83,402 AMAZON.COM, INC. CONSOLIDATED STATEMENTS OF STOCKHOLDERS' EQUITY (in millions) Common Stock Additional Paid-In Capital Treasury Stock Amount 5 $ (1,837) $ 9,573 $ - 2 6 1,510 44 (1,837) 11,135 - Balance as of January 1, 2014 Net loss. Other comprehensive income (loss) Exercise of common stock options Excess tax benefits from stock-based compensation Stock-based compensation and issuance of employee benefit plan stock Issuance of common stock for acquisition activity Balance as of December 31, 2014 Net income Other comprehensive income (loss) Exercise of common stock options Excess tax benefits from stock-based compensation Stock-based compensation and issuance of employee benefit plan stock Issuance of common stock for acquisition activity Balance as of December 31, 2015 Net income Other comprehensive income (loss) Exercise of common stock options Excess tax benefits from stock-based compensation Stock-based compensation and issuance of employee benefit plan stock Balance as of December 31, 2016 Shares 459 $ 6 465 6 4 119 2,131 5 471 (1,837) 13,394 6 1 829 2,962 477 S 5 $ (1,837) $ 17,186 $ See accompanying notes to consolidated financial statements. - |||| Accumulated Other Comprehensive Retained Income (Loss) Earnings (185) $ 2,190 $ (241) (326) (511) 1,949 596 (212) (723) 2,545 2,371 (262) - (985) $ 4,916 $ I I Total Stockholders' Equity 9,746 (241) (326) 2 6 1,510 44 10,741 596 (212) 4 119 2,131 5 13,384 2,371 (262) 1 829 2,962 19,285 Wal-Mart Stores, Inc. Consolidated Statement of Income (Amounts in millions, except per share data) Revenues: Net sales Membership and other income Total revenues Costs and expenses: Cost of sales Operating, selling, general and administrative expenses Operating income Interest: Debt Capital lease and financing obligations Interest income Interest, net Income from continuing operations before income taxes Provision for income taxes Income from continuing operations Income from discontinued operations, net of income taxes Consolidated net income Consolidated net income attributable to noncontrolling interest Consolidated net income attributable to Walmart Basic net income per common share: Basic income per common share from continuing operations attributable to Walmart Basic income per common share from discontinued operations attributable to Walmart Basic net income per common share attributable to Walmart Diluted net income per common share: Diluted income per common share from continuing operations attributable to Walmart Diluted income per common share from discontinued operations attributable to Walmart Diluted net income per common share attributable to Walmart Weighted-average common shares outstanding: Basic Diluted Dividends declared per common share See accompanying notes. Fiscal Years Ended January 31, 2016 $478,614 3,516 482,130 360,984 97,041 24,105 2,027 521 2017 $481,317 4,556 485,873 361,256 101,853 22,764 2,044 323 (100) 2,267 20,497 6,204 14,293 14,293 (650) $ 13,643 $ 4.40 - $ 4.40 $ 4.38 - $ 4.38 3,101 3,112 2.00 $ 2015 $482,229 3,422 485,651 365,086 93,418 27,147 2,161 300 (113) 2,348 24,799 7,985 16,814 285 17,099 (386) (736) $ 14,694 $ 16,363 $ 4.58 $ 5.01 - 0.06 $ 4.58 $ 5.07 4.57 $ 4.99 0.06 4.57 $ 5.05 3,207 3,230 3,217 3,243 1.96 1.92 $ $ $ (81) 2,467 21,638 6,558 15,080 15,080 $ Wal-Mart Stores, Inc. Consolidated Statement of Comprehensive Income 2017 $14,293 (650) 13,643 (2,882) 413 21 (397) (2,845) 210 (2,635) 11,448 $11,008 (Amounts in millions) Consolidated net income Less consolidated net income attributable to nonredeemable noncontrolling interest Consolidated net income attributable to Walmart Other comprehensive income (loss), net of income taxes Currency translation and other Net investment hedges Cash flow hedges Minimum pension liability Other comprehensive income (loss), net of income taxes Less other comprehensive income (loss) attributable to nonredeemable noncontrolling interest Other comprehensive income (loss) attributable to Walmart Comprehensive income, net of income taxes Less comprehensive income (loss) attributable to nonredeemable noncontrolling interest Comprehensive income attributable to Walmart See accompanying notes. Fiscal Years Ended January 31, 2016 $15,080 (386) (440) 14,694 (5,220) 366 (202) 86 (4,970) 541 (4,429) 10,110 155 $10,265 2015 $17,099 (736) 16,363 (4,558) 379 (470) (69) (4,718) 546 (4,172) 12,381 (190) $12,191 (Amounts in millions) ASSETS Current assets: Cash and cash equivalents Receivables, net Inventories Prepaid expenses and other Total current assets Property and equipment: Wal-Mart Stores, Inc. Consolidated Balance Sheets 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 Goodwill Other assets and deferred charges Total assets LIABILITIES AND EQUITY 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 Nonredeemable noncontrolling interest Total equity Total liabilities and equity See accompanying notes. Property under capital lease and financing obligations, net As of January 31, 2017 2016 $ 8,705 $ 6,867 5,835 5,624 43,046 44,469 1,941 1,441 57,689 60,239 179,492 176,958 (71,782) (66,787) 107,710 110,171 11,637 11,096 (5,169) (4,751) 6,468 6,345 17,037 16,695 9,921 6,131 $198,825 $199,581 $ 1,099 $ 2,708 41,433 38,487 20,654 19,607 921 521 2,256 2,745 565 551 66,928 64,619 36,015 38,214 6,003 5,816 9,344 7,321 305 317 2,371 1,805 89,354 90,021 (14,232) (11,597) 77,798 80,546 2,737 3,065 80,535 83,611 $198,825 $199,581 Wal-Mart Stores, Inc. Consolidated Statements of Shareholders' Equity and Redeemaole Noncontrolling Interest Redeemable Capital in Excess of Accumulated Total Other Walmart Comprehensive Shareholders' Loss Common Stock Retained Nonredeemable Noncontrolling Interest Total Noncontrolling Equity (Amounts in millions) Amount Par Value Earnings Equity Interest $323 $2,362 $ (2,996) $76,255 $5,084 $81,339 $ 1,491 Balances as of February 1, 2014 Consolidated net income $76,566 16,363 16,363 736 17,099 - (4,172) (4,172) (546) (4,718) Other comprehensive loss, net of income taxes Cash dividends declared ($1.92 per share) Purchase of Company stock (6,185) (6,185) (6,185) (29) (950) (980) (980) Purchase of redeemable noncontrolling interest Other (17) 113 (731) (618) Balances as of January 31, 2015 85,777 81,394 85,937 Consolidated net income 14,694 14,694 15,080 Other comprehensive loss, net of income taxes Cash dividends declared (4,429) (4,970) (6,294) ($1.96 per share) Purchase of Company stock (6,294) (4,256) (4,256) Cash dividend declared to noncontrolling interest (691) Other (563) (1,195) Balances as of January 31, 2016 Consolidated net income Other comprehensive loss, net of income taxes Cash dividends declared ($2.00 per share) Purchase of Company stock Cash dividend declared to (120) (12) (174) noncontrolling interest Other 6 740 Balances as of January 31, 2017 3,048 $305 $2,371 See accompanying notes. Shares 3,233 | (13) 8 3,228 (65) (1) 3,162 | T (1) 1 323 T I T (6) 129 2,462 T I i (102) (555) (8) 317 1,805 90,021 13,643 (6,216) (8,090) (4) $89,354 T T (6,294) (4,148) (7,168) (4,429) | 1 (11,597) (2,635) 80,546 13,643 (2,635) (6,216) (8,276) 736 $(14,232) $77,798 4,543 386 (541) L (691) (632) 3,065 83,611 650 14,293 (210) (2,845) (6,216) (8,276) (519) (519) (249) 487 $2,737 $80,535 | | (1,491) $ T ||||| T | | Wal-Mart Stores, Inc. Consolidated Statements of Cash Flow (Amounts in millions) Cash flows from operating activities: Consolidated net income Income from discontinued operations, net of income taxes Income from continuing operations Adjustments to reconcile income from continuing operations to net cash provided by operating activities: Depreciation and amortization Deferred income taxes 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 Investment and business acquisitions, net of cash acquired Other investing activities Net cash used in investing activities Cash flows from financing activities: Net change in short-term borrowings Proceeds from issuance of long-term debt Payments of long-term 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 rates on cash and cash equivalents Net increase (decrease) in cash and cash equivalents Cash and cash equivalents at beginning of year Cash and cash equivalents at end of year Supplemental disclosure of cash flow information: Income taxes paid Interest paid See accompanying notes. Fiscal Years Ended January 31, 2016 $ 15,080 15,080 9,454 (672) 1,410 (19) (703) 2017 $ 14,293 14,293 10,080 761 206 (402) 1,021 3,942 1,137 492 31,530 (10,619) 456 662 (1,901) (2,463) (122) (13,987) (1,673) 137 (2,055) (6,216) (8,298) (479) (90) (255) (18,929) (452) (1,838) 8,705 $ 6,867 4,507 2,351 2,008 1,303 (472) 27,389 (11,477) 635 246 (79) (10,675) 1,235 39 (4,432) (6,294) (4,112) (719) (1,326) (513) (16,122) (1,022) (430) 9,135 $ 8,705 8,111 2,540 2015 $ 17,099 (285) 16,814 9,173 (503) 785 (569) (1,229) 2,678 1,249 166 28,564 (12,174) 570 671 (192) (11,125) (6,288) 5,174 (3,904) (6,185) (1,015) (600) (1,844) (409) (15,071) (514) 1,854 7,281 $ 9,135 8,169 2,433
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
