Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the cash flow statement of Amazon the past three years, prepare a 2 year forecast of statement of cash flow. Detailed explanation is appreciated.

Given the cash flow statement of Amazon the past three years, prepare a 2 year forecast of statement of cash flow.

Detailed explanation is appreciated.

EDIT: Updating with Balance sheet. Cannot submit question if I send as excel table. JPEG images only for submission. I am told question is "too big" if I try excel.

Edit 2: Adding Operation and Income sheet

image text in transcribed

image text in transcribed

image text in transcribed

Balance Sheet:

image text in transcribed

Consolidated Statements of Comprehensive Income - USD ($) $ in Millions 12 Months Ended Dec 31, 2019 Dec 31, 2018 Dec. 31, 2017 $ 11,588 $ 10,073 $ 3,033 (538) 533 78 108 (30) (538) Statement of Comprehensive Income [Abstract] Net income Net change in foreign currency translation adjustments: Foreign currency translation adjustments, net of tax of $5, $6, and $(5) Reclassification adjustment for foreign currency translation included in "Other operating expense (income), net," net of tax of $0, $0, and $29 Net foreign currency translation adjustments Net change in unrealized gains (losses) on available-for-sale debt securities: Unrealized gains (losses), net of tax of $5, $0, and $(12) Reclassification adjustment for losses (gains) included in "Other income (expense), net," net of tax of $0, $0, and $0 Net unrealized gains (losses) on available-for-sale debt securities Total other comprehensive income (loss) Comprehensive income 533 (17) (39) 79 49 $ 11,637 (9) (547) $ 9,526 (32) 501 $3,534 Consolidated Statements of Operations - USD ($) shares in Millions, $ in Millions 12 Months Ended Dec. 31, 2019 Dec. 31, 2018 $ 280,522 $ 232,887 Dec. 31, 2017 $ 177,866 111,934 25,249 22,620 10,069 3,674 214 173,760 4,106 202 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 (in shares) Diluted in shares) Net product sales Total net sales Net service sales Total net sales 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 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) (848) 346 (300) 3,806 (769) (4) $ 10,073 $20.68 $ 20.14 $ 3,033 $6.32 $6.15 494 504 487 500 480 493 $ 160,408 $ 141,915 $ 118,573 $ 120,114 $ 90,972 $ 59,293 Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended Dec 31, 2018 Dec. 31, 2019 Dec 31, 2017 $ 32,173 $ 21,856 $ 19,934 11,588 10,073 3,033 21,789 15,341 11,478 4,215 202 6,864 164 (249) 796 5,418 274 219 441 (292) (29) (3,278) (7,681) 8,193 (1,383) 1,711 38,514 (1,314) (4,615) 3,263 472 1,151 30,723 (3,583) (4,780) 7,100 283 738 18,365 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 and amortization of property and equipment and capitalized content costs, operating lease assets, and other Stock-based compensation Other operating expense (income), 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 Proceeds from property and equipment sales and incentives 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 finance leases Principal repayments of financing 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 operating leases Cash paid for interest on capital leases Cash paid for interest on finance leases Cash paid for interest on financing obligations Cash paid for income taxes, net of refunds Assets acquired under operating leases Property and equipment acquired under capital leases Property and equipment acquired under finance leases Property and equipment acquired under build-to-suit arrangements (16,861) 4,172 (2,461) 22,681 (31,812) (24,281) (13,427) 2,104 (2,186) 8,240 (7,100) (12,369) (11,955) 1,897 (13,972) 9,677 (12,731) (27,084) 2,273 (2,684) (9,628) (27) (10,066) 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 70 4,237 36,410 854 328 875 3,361 0 381 200 119 647 39 881 7,870 194 (1,184) (957) 10,615 9,637 13,723 $ 1,362 $ 3,641 $ 3,541 Dec 31, 2019 Dec. 31, 2018 $36,092 18,929 20,497 20,816 96,334 72,705 25,141 14,754 16,314 225,248 $ 31,750 9,500 17,174 16,677 75,101 61,797 14,548 11,202 162,648 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 Operating leases Goodwill Other assets Total assets Current liabilities: Accounts payable Accrued expenses and other Unearned revenue Total current liabilities Long-term lease 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 income (loss) Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 47,183 32,439 8,190 87,812 39,791 23,414 12,171 38,192 23,663 6,536 68,391 9,650 23,495 17,563 (1,837) 33,658 (986) 31,220 62,060 $ 225,248 (1,837) 26,791 (1,035) 19,625 43,549 $ 162,648 Consolidated Statements of Comprehensive Income - USD ($) $ in Millions 12 Months Ended Dec 31, 2019 Dec 31, 2018 Dec. 31, 2017 $ 11,588 $ 10,073 $ 3,033 (538) 533 78 108 (30) (538) Statement of Comprehensive Income [Abstract] Net income Net change in foreign currency translation adjustments: Foreign currency translation adjustments, net of tax of $5, $6, and $(5) Reclassification adjustment for foreign currency translation included in "Other operating expense (income), net," net of tax of $0, $0, and $29 Net foreign currency translation adjustments Net change in unrealized gains (losses) on available-for-sale debt securities: Unrealized gains (losses), net of tax of $5, $0, and $(12) Reclassification adjustment for losses (gains) included in "Other income (expense), net," net of tax of $0, $0, and $0 Net unrealized gains (losses) on available-for-sale debt securities Total other comprehensive income (loss) Comprehensive income 533 (17) (39) 79 49 $ 11,637 (9) (547) $ 9,526 (32) 501 $3,534 Consolidated Statements of Operations - USD ($) shares in Millions, $ in Millions 12 Months Ended Dec. 31, 2019 Dec. 31, 2018 $ 280,522 $ 232,887 Dec. 31, 2017 $ 177,866 111,934 25,249 22,620 10,069 3,674 214 173,760 4,106 202 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 (in shares) Diluted in shares) Net product sales Total net sales Net service sales Total net sales 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 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) (848) 346 (300) 3,806 (769) (4) $ 10,073 $20.68 $ 20.14 $ 3,033 $6.32 $6.15 494 504 487 500 480 493 $ 160,408 $ 141,915 $ 118,573 $ 120,114 $ 90,972 $ 59,293 Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended Dec 31, 2018 Dec. 31, 2019 Dec 31, 2017 $ 32,173 $ 21,856 $ 19,934 11,588 10,073 3,033 21,789 15,341 11,478 4,215 202 6,864 164 (249) 796 5,418 274 219 441 (292) (29) (3,278) (7,681) 8,193 (1,383) 1,711 38,514 (1,314) (4,615) 3,263 472 1,151 30,723 (3,583) (4,780) 7,100 283 738 18,365 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 and amortization of property and equipment and capitalized content costs, operating lease assets, and other Stock-based compensation Other operating expense (income), 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 Proceeds from property and equipment sales and incentives 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 finance leases Principal repayments of financing 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 operating leases Cash paid for interest on capital leases Cash paid for interest on finance leases Cash paid for interest on financing obligations Cash paid for income taxes, net of refunds Assets acquired under operating leases Property and equipment acquired under capital leases Property and equipment acquired under finance leases Property and equipment acquired under build-to-suit arrangements (16,861) 4,172 (2,461) 22,681 (31,812) (24,281) (13,427) 2,104 (2,186) 8,240 (7,100) (12,369) (11,955) 1,897 (13,972) 9,677 (12,731) (27,084) 2,273 (2,684) (9,628) (27) (10,066) 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 70 4,237 36,410 854 328 875 3,361 0 381 200 119 647 39 881 7,870 194 (1,184) (957) 10,615 9,637 13,723 $ 1,362 $ 3,641 $ 3,541 Dec 31, 2019 Dec. 31, 2018 $36,092 18,929 20,497 20,816 96,334 72,705 25,141 14,754 16,314 225,248 $ 31,750 9,500 17,174 16,677 75,101 61,797 14,548 11,202 162,648 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 Operating leases Goodwill Other assets Total assets Current liabilities: Accounts payable Accrued expenses and other Unearned revenue Total current liabilities Long-term lease 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 income (loss) Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 47,183 32,439 8,190 87,812 39,791 23,414 12,171 38,192 23,663 6,536 68,391 9,650 23,495 17,563 (1,837) 33,658 (986) 31,220 62,060 $ 225,248 (1,837) 26,791 (1,035) 19,625 43,549 $ 162,648

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