Microsoft Excel LibreOffice Calc

Facebook Inc. (FB)

Statement of Cash Flows
Quarterly Data

Difficulty: Beginner

The cash flow statement provides information about a company’s cash receipts and cash payments during an accounting period, showing how these cash flaws link the ending cash balance to the beginning balance shown on the company’s statement of financial position.

The cash flow statement consists of three parts: cash flows provided by (used in) operating activities, cash flows provided by (used in) investing activities, and cash flows provided by (used in) financing activities.

Facebook Inc., Consolidated Statement of Cash Flows (quarterly data)

USD $ in millions

Microsoft Excel LibreOffice Calc
3 months ended Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Net income 2,429  6,882  5,137  5,105  4,988  4,269  4,706  3,895  3,064  3,569  2,627  2,283  1,738  1,561  896  719  512  701  806  791  642 
Depreciation and amortization 1,355  1,225  1,107  1,034  949  853  772  729  671  614  591  585  552  543  486  459  457  433  289  257  264 
Share-based compensation 1,010  972  1,039  1,186  955  814  1,010  1,032  867  831  824  817  746  746  757  763  694  845  353  314  274 
Deferred income taxes 183  203  29  101  (47) (225) (94) 26  (84) (256) (23) (101) (77) (123) (383) (66) (223) (180) 4  (33) (1)
Tax benefit from share-based award activity –  –  –  –  –  –  –  –  –  –  –  –  –  566  346  386  423  499  479  530  345 
Excess tax benefit from share-based award activity –  –  –  –  –  –  –  –  –  –  –  –  –  (566) (346) (386) (423) (504) (482) (535) (348)
Other 6  (83) 1  10  8  6  6  7  5  7  4  6  13  4  6  1  6  2  (3) (19) (4)
Accounts receivable 1,070  (1,564) (489) (627) 788  (1,374) (458) (386) 609  (1,011) (253) (492) 267  (568) (207) (282) 84  (346) (182) (187) 105 
Prepaid expenses and other current assets 84  199  9  (533) (365) 442  (57) (212) (365) 155  (57) (150) (107) 1  (55) (47) (43) (78) (55) 14  (4)
Other assets 41  (60) (40) (81) 22  24  48  51  31  (32) 42  (11) 15  (7) 29  7  (32) (58) (176) 2  16 
Operating lease right-of-use assets, net (1,190) –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  – 
Accounts payable (96) 133  38  49  1  50  31  (28) (10) 35  18  (41) 2  11  (9) 31  (15) 19  (57) 79  (10)
Partners payable (1) 41  63  51  2  73  32  (7) (3) 47  6  17  (3) (23) 59  (6) (13) (6) (17) (12) 7 
Accrued expenses and other current liabilities 3,154  373  354  (17) 707  214  (62) 96  61  372  228  432  (18) 222  50  107  134  130  123  102  (27)
Deferred revenue and deposits (4) 33  24  1  (5) (8) 16  6  (10) 14  (2) 25  (2) 9  (1) (7) (10) 7  (12) 15  – 
Operating lease liabilities, non-current 1,083  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  – 
Other liabilities 184  (736) 226  19  (143) 2,533  177  151  222  585  31  295  351  451  564  201  149  119  178  23  26 
Changes in assets and liabilities 4,325  (1,581) 185  (1,138) 1,007  1,954  (273) (329) 535  165  13  75  505  96  430  4  254  (213) (198) 36  113 
Adjustments to reconcile net income to net cash provided by operating activities 6,879  736  2,361  1,193  2,872  3,402  1,421  1,465  1,994  1,361  1,409  1,382  1,739  1,266  1,296  1,161  1,188  882  442  550  643 
Net cash provided by operating activities 9,308  7,618  7,498  6,298  7,860  7,671  6,127  5,360  5,058  4,930  4,036  3,665  3,477  2,827  2,192  1,880  1,700  1,583  1,248  1,341  1,285 
Purchases of property and equipment, net (3,837) (4,301) (3,342) (3,460) (2,812) (2,263) (1,755) (1,444) (1,271) (1,269) (1,095) (995) (1,132) (692) (780) (549) (502) (517) (482) (469) (363)
Purchases of marketable securities (6,603) (1,998) (4,375) (4,261) (4,022) (5,272) (6,273) (7,145) (6,992) (4,973) (7,733) (6,509) (3,126) (5,605) (4,773) (2,505) (3,055) (2,889) (1,733) (1,508) (2,974)
Sales of marketable securities 1,512  1,254  2,492  4,282  4,330  1,795  3,651  2,236  1,762  4,103  5,633  2,145  2,013  2,803  1,399  2,118  608  1,047  5,423  1,121  847 
Maturities of marketable securities 2,210  1,381  1,053  1,071  1,267  760  730  899  599  227  131  366  537  747  848  376  339  199  636  455  619 
Acquisitions of businesses, net of cash acquired, and purchases of intangible assets –  –  (72) (16) (49) (16) (98) (8) –  (42) (61) (19) (1) (4) (27) (25) (257) (4,221) (735) (19) – 
Change in restricted cash and deposits –  –  –  –  –  3  31  22  11  (21) 8  41  33  25  33  21  23  (235) (111) (2) – 
Other investing activities, net (50) (21) (3) –  (1) –  –  –  –  –  –  –  –  –  –  –  –  –  (1) –  (1)
Net cash (used in) provided by investing activities (6,768) (3,685) (4,247) (2,384) (1,287) (4,993) (3,714) (5,440) (5,891) (1,975) (3,117) (4,971) (1,676) (2,726) (3,300) (564) (2,844) (6,616) 2,997  (422) (1,872)
Taxes paid related to net share settlement of equity awards (512) (545) (905) (926) (832) (886) (865) (724) (771) –  –  –  –  –  –  –  –  –  –  –  – 
Proceeds from exercise of stock options –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  11  5  1  1 
Repurchases of Class A common stock (613) (3,500) (4,256) (3,349) (1,774) (958) (640) (150) (228) –  –  –  –  –  –  –  –  –  –  –  – 
Principal payments on finance leases (125) –  –  –  –  –  –  –  –  –  –  –  (312) (12) (23) (37) (47) (44) (49) (66) (84)
Net change in overdraft in cash pooling entities (177) 500  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  – 
Excess tax benefit from share-based award activity –  –  –  –  –  –  –  –  –  –  –  –  –  566  346  386  423  504  482  535  348 
Other financing activities, net 4  4  4  4  3  1  (26) 5  7  4  (8) 4  2  –  (8) (7) (5) (70) –  –  (3)
Net cash provided by (used in) financing activities (1,423) (3,541) (5,157) (4,271) (2,603) (1,843) (1,531) (869) (992) 4  (8) 4  (310) 554  315  342  371  401  438  470  262 
Effect of exchange rate changes on cash, cash equivalents, and restricted cash (44) (12) (18) (185) 36  43  67  97  26  (94) 19  (46) 58  (56) (22) 46  (123) (52) (68) (3) – 
Net increase (decrease) in cash, cash equivalents, and restricted cash 1,073  380  (1,924) (542) 4,006  878  949  (852) (1,799) 2,865  930  (1,348) 1,549  599  (815) 1,704  (896) (4,684) 4,615  1,386  (325)

Based on: 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-01-31), 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-04-26), 10-K (filing date: 2018-02-01), 10-Q (filing date: 2017-11-02), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-28), 10-K (filing date: 2016-01-28), 10-Q (filing date: 2015-11-05), 10-Q (filing date: 2015-07-31), 10-Q (filing date: 2015-04-23), 10-K (filing date: 2015-01-29), 10-Q (filing date: 2014-10-30), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-25).

Item Description The company
Net cash provided by operating activities Amount of cash inflow (outflow) from operating activities, excluding discontinued operations. Operating activity cash flows include transactions, adjustments, and changes in value not defined as investing or financing activities. Facebook Inc.’s net cash provided by operating activities increased from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.
Net cash (used in) provided by investing activities Amount of cash inflow (outflow) of investing activities, excluding discontinued operations. Investing activity cash flows include making and collecting loans and acquiring and disposing of debt or equity instruments and property, plant, and equipment and other productive assets. Facebook Inc.’s net cash (used in) provided by investing activities increased from Q3 2018 to Q4 2018 but then declined significantly from Q4 2018 to Q1 2019.
Net cash provided by (used in) financing activities Amount of cash inflow (outflow) of financing activities, excluding discontinued operations. Financing activity cash flows include obtaining resources from owners and providing them with a return on, and a return of, their investment; borrowing money and repaying amounts borrowed, or settling the obligation; and obtaining and paying for other resources obtained from creditors on long-term credit. Facebook Inc.’s net cash provided by (used in) financing activities increased from Q3 2018 to Q4 2018 and from Q4 2018 to Q1 2019.