Microsoft Excel LibreOffice Calc

ConocoPhillips (COP)

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.

ConocoPhillips, Consolidated Statement of Cash Flows (quarterly data)

USD $ in millions

Microsoft Excel LibreOffice Calc
3 months ended 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 (loss) 1,878  1,873  1,654  900  1,598  436  (3,426) 599  (19) (1,026) (1,058) (1,456) (3,437) (1,056) (164) 286  (24) 2,727  2,098  2,137 
Depreciation, depletion and amortization 1,612  1,494  1,438  1,412  1,633  1,608  1,625  1,979  2,061  2,425  2,329  2,247  2,382  2,271  2,329  2,131  2,271  2,096  2,070  1,892 
Impairments 6  44  (35) 12  126  6  6,294  175  (182) 123  62  136  2,127  24  78  16  730  108  17  1 
Dry hole costs and leasehold impairments 31  28  16  20  131  7  22  406  174  187  463  360  1,827  525  402  311  498  265  334  69 
Accretion on discounted liabilities 87  89  89  88  86  89  92  95  96  108  112  109  118  122  122  121  127  120  120  117 
Deferred taxes (115) 136  197  65  (911) (222) (1,234) (1,314) (69) (695) (630) (827) (1,488) (682) 35  (637) (315) 391  403  230 
Undistributed equity earnings 163  (105) 128  (34) (39) (72) (78) (43) (115) 192  (30) 252  180  (38) (121) 80  (257) (347) (450) 1,131 
Gain on dispositions (888) (113) (55) (7) (33) (246) (1,876) (22) (158) (51) (128) (23) (469) (18) (52) (52) (78) (4) (7) (9)
Income from discontinued operations –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  (1,078) (33) (20)
Other 414  15  (267) 29  (62) (542) 222  (47) (35) (33) 109  (126) 580  195  (321) (133) 303  (344) (308) 116 
(Increase) decrease in accounts and notes receivable 382  (602) 316  139  (951) (248) 235  78  (292) 15  548  549  (103) 494  51  1,368  593  554  370  (290)
(Increase) decrease in inventories 251  (144) (33) 12  (40) (12) 73  (76) 22  45  (84) 61  7  117  (35) 77  (31) (59) (76) (27)
(Increase) decrease in prepaid expenses and other current assets (4) 97  (126) (22) 81  123  (145) 10  59  97  (60) 9  (16) 102  (81) 234  (1) 49  (221) (17)
Increase (decrease) in accounts payable (9) 239  (101) (181) 477  (34) (49) (129) (9) (61) –  (454) (29) (260) (254) (1,104) (596) (258) (282) 353 
Increase (decrease) in taxes and other accruals (25) 359  121  (34) 385  162  (4) 79  (90) (46) (374) (416) (83) 138  (15) (630) (623) (66) (472) 595 
Working capital adjustments 595  (51) 177  (86) (48) (9) 110  (38) (310) 50  30  (251) (224) 591  (334) (55) (658) 220  (681) 614 
Adjustments to reconcile net income (loss) to net cash provided by operating activities 1,905  1,537  1,688  1,499  883  619  5,177  1,191  1,462  2,306  2,317  1,877  5,033  2,990  2,138  1,782  2,621  1,427  1,465  4,141 
Net cash provided by operating activities 3,783  3,410  3,342  2,399  2,481  1,055  1,751  1,790  1,443  1,280  1,259  421  1,596  1,934  1,974  2,068  2,597  4,154  3,563  6,278 
Capital expenditures and investments (1,617) (1,599) (1,999) (1,535) (1,517) (1,088) (1,020) (966) (999) (916) (1,133) (1,821) (2,137) (2,174) (2,407) (3,332) (4,356) (4,588) (4,246) (3,895)
Working capital changes associated with investing activities (11) 35  (120) 28  150  95  (87) (26) 70  (38) (229) (134) (126) (164) (480) (198) –  –  –  – 
Proceeds from asset dispositions 688  86  139  169  120  2,998  10,707  35  867  56  228  135  1,629  29  121  173  169  1,371  15  48 
Net (purchases) sales of short-term investments 624  (261) (336) 1,593  793  70  (2,450) (203) 178  1,063  (990) (302) –  –  –  –  362  (101) (71) 63 
Collection of advances/loans, related parties –  60  –  59  –  58  –  57  –  55  –  53  –  53  –  52  460  66  15  62 
Other 138  41  367  (392) (15) (125) 47  129  (63) 55  2  4  8  7  300  (9) 8  (550) 50  46 
Net cash (used in) provided by investing activities (178) (1,638) (1,949) (78) (469) 2,008  7,197  (974) 53  275  (2,122) (2,065) (626) (2,249) (2,466) (3,314) (3,357) (3,802) (4,237) (3,676)
Issuance of debt –  –  –  –  –  –  –  –  –  –  –  4,594  –  –  2,498  –  2,994  –  –  – 
Repayment of debt (25) (18) (2,064) (2,888) (1,282) (2,515) (3,240) (839) (1,412) (12) (763) (64) (11) (30) (5) (57) (1,509) (55) –  (450)
Issuance of company common stock –  79  60  (18) 2  (2) (17) (46) (11) (7) (3) (42) (13) (23) (12) (34) 8  (19) 78  (32)
Repurchase of company common stock (926) (927) (646) (500) (955) (970) (963) (112) (126) –  –  –  –  –  –  –  –  –  –  – 
Dividends paid (354) (334) (337) (338) (319) (324) (331) (331) (313) (314) (313) (313) (923) (922) (909) (910) (907) (907) (856) (855)
Other (12) (63) (16) (32) (32) (16) (48) (16) (44) (14) (41) (38) (28) (15) (17) (18) (44) 8  (11) (17)
Net cash provided by (used in) financing activities (1,317) (1,263) (3,003) (3,776) (2,586) (3,827) (4,599) (1,344) (1,906) (347) (1,120) 4,137  (975) (990) 1,555  (1,019) 542  (973) (789) (1,354)
Net cash provided by discontinued operating activities –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  26  59  58 
Net cash used in discontinued investing activities –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  (9) (28) (22)
Net cash provided by discontinued operations –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  –  17  31  36 
Effect of exchange rate changes on cash, cash equivalents and restricted cash (77) (26) (139) 125  (12) 141  76  27  (70) 19  (20) 5  (40) (95) 86  (133) (128) (130) 54  (10)
Net change in cash, cash equivalents and restricted cash 2,211  483  (1,749) (1,330) (586) (623) 4,425  (501) (480) 1,227  (2,003) 2,498  (45) (1,400) 1,149  (2,398) (346) (734) (1,378) 1,274 

Based on: 10-K (filing date: 2019-02-19), 10-Q (filing date: 2018-10-30), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-05-01), 10-K (filing date: 2018-02-20), 10-Q (filing date: 2017-10-31), 10-Q (filing date: 2017-08-01), 10-Q (filing date: 2017-05-04), 10-K (filing date: 2017-02-21), 10-Q (filing date: 2016-11-01), 10-Q (filing date: 2016-08-02), 10-Q (filing date: 2016-05-03), 10-K (filing date: 2016-02-23), 10-Q (filing date: 2015-11-03), 10-Q (filing date: 2015-08-04), 10-Q (filing date: 2015-05-05), 10-K (filing date: 2015-02-24), 10-Q (filing date: 2014-11-04), 10-Q (filing date: 2014-08-05), 10-Q (filing date: 2014-05-06).

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. ConocoPhillips’s net cash provided by operating activities increased from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.
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. ConocoPhillips’s net cash (used in) provided by investing activities increased from Q2 2018 to Q3 2018 and from Q3 2018 to Q4 2018.
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. ConocoPhillips’s net cash provided by (used in) financing activities increased from Q2 2018 to Q3 2018 but then slightly declined from Q3 2018 to Q4 2018.