Microsoft Excel LibreOffice Calc

ConocoPhillips (COP)

Cash Flow Statement
Quarterly Data

Low level of difficulty

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 balance sheet.

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 cash flow statement (quarterly data)

US$ in millions

Microsoft Excel LibreOffice Calc
3 months ended Sep 30, 2019 Jun 30, 2019 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 (loss) 3,071  1,597  1,846  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,566  1,490  1,546  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 24  1  1  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 293  41  27  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 86  87  86  87  89  89  88  86  89  92  95  96  108  112  109  118  122  122  121  127  120  120  117 
Deferred taxes (83) (220) (1) (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 (102) 338  24  163  (105) 128  (34) (39) (72) (78) (43) (115) 192  (30) 252  180  (38) (121) 80  (257) (347) (450) 1,131 
Gain on dispositions (1,785) (82) (17) (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 (426) 170  (564) 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 (128) 282  179  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 75  (73) (4) 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 120  (211) 62  (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 (150) (184) (142) (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 (224) (345) (149) (25) 359  121  (34) 385  162  (4) 79  (90) (46) (374) (416) (83) 138  (15) (630) (623) (66) (472) 595 
Working capital adjustments (307) (531) (54) 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 (734) 1,294  1,048  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 2,337  2,891  2,894  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,675) (1,729) (1,637) (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 (7) (83) 107  (11) 35  (120) 28  150  95  (87) (26) 70  (38) (229) (134) (126) (164) (480) (198) —  —  —  — 
Proceeds from asset dispositions 2,219  559  142  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 (180) (484) (1) 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 65  —  62  —  60  —  59  —  58  —  57  —  55  —  53  —  53  —  52  460  66  15  62 
Other (272) 276  (150) 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 150  (1,461) (1,477) (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 (21) (19) (19) (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 (3) 2  (38) —  79  60  (18) 2  (2) (17) (46) (11) (7) (3) (42) (13) (23) (12) (34) 8  (19) 78  (32)
Repurchase of company common stock (749) (1,250) (752) (926) (927) (646) (500) (955) (970) (963) (112) (126) —  —  —  —  —  —  —  —  —  —  — 
Dividends paid (341) (346) (350) (354) (334) (337) (338) (319) (324) (331) (331) (313) (314) (313) (313) (923) (922) (909) (910) (907) (907) (856) (855)
Other (18) (41) (14) (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,132) (1,654) (1,173) (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 (94) (49) 75  (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 1,261  (273) 319  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-Q (filing date: 2019-10-31), 10-Q (filing date: 2019-08-01), 10-Q (filing date: 2019-05-02), 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).

Cash flow statement 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 declined from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 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. ConocoPhillips’s net cash (used in) provided by investing activities increased from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 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. ConocoPhillips’s net cash provided by (used in) financing activities declined from Q1 2019 to Q2 2019 but then increased from Q2 2019 to Q3 2019 exceeding Q1 2019 level.