Extraction oil & gas, inc. (XOG)

CashFlow / TTM
Mar'20Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16
Cash flows from operating activities:
Net loss

-1,264,351

-1,367,420

83,188

114,414

79,818

121,855

-8,565

-103,511

-105,119

-44,408

-259,441

-266,911

-401,765

-456,001

0

0

0

Reconciliation of net income (loss) to net cash provided by operating activities:
Depletion, depreciation, amortization and accretion

481,818

524,537

477,613

469,932

458,338

435,775

411,812

398,717

360,553

314,999

277,514

229,973

210,693

205,348

0

0

0

Abandonment and impairment of unproved properties

176,736

73,729

36,407

34,775

25,674

25,704

25,587

17,170

16,996

15,808

0

0

0

-

-

-

-

Impairment of long lived assets

1,330,523

1,337,996

65,867

82,033

79,176

70,928

17,266

1,100

972

1,647

750

1,216

23,654

23,425

0

0

0

Gain on sale of property and equipment

-1,653

-1,431

-6,308

-6,361

53,444

53,222

59,849

59,902

0

-451

0

0

0

-

-

-

-

Gain on repurchase of 2026 Senior Notes

3,169

10,486

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of debt issuance costs

5,226

5,482

4,746

4,708

4,306

13,250

13,382

13,916

13,857

4,260

3,939

18,376

18,735

19,088

0

0

0

Non-cash lease expense

13,531

11,146

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Increase (Decrease) in Contract with Customer, Asset

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Deferred rent

-

-

-

-

-

348

377

142

390

-294

-278

9

410

551

0

0

0

Commodity derivatives (gain) loss

347,999

-37,107

206,581

82,713

-80,317

-8,554

-258,507

-260,469

-137,082

-36,332

7,900

62,001

-46,489

-100,947

0

0

0

Settlements on commodity derivatives

27,792

-678

-59,669

-102,263

-115,869

-134,624

-96,574

-53,024

-25,149

-11,985

-9,081

-12,597

4,626

42,827

0

0

0

Premiums paid on commodity derivatives

-

-

-

-

-

22,749

17,746

17,746

12,592

475

0

0

581

611

0

0

0

Earnings in unconsolidated subsidiaries

2,442

2,300

2,231

2,433

2,899

2,900

2,030

1,453

739

400

0

0

0

-

-

-

-

Loss on deconsolidation of Elevation Midstream, LLC

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Distributions from unconsolidated subsidiaries

1,449

3,200

2,630

3,048

3,096

1,684

1,968

1,041

754

415

0

0

0

-

-

-

-

Make-whole premium expense on 2021 Senior Notes

-

-

-

-

-

35,600

35,600

35,600

35,600

0

0

0

0

-

-

-

-

Deferred income tax expense (benefit)

-77,976

-109,176

55,450

62,850

51,950

66,850

-43,844

-83,150

-82,930

-63,700

0

0

0

-

-

-

-

Stock-based compensation

30,946

43,954

56,772

62,830

65,636

68,349

69,783

70,474

65,583

65,607

232,093

226,299

214,685

200,308

0

0

0

Changes in current assets and liabilities:
Accounts receivable—trade

17,405

-3,630

-2,594

-7,624

-35,821

-8,562

-11,038

16,915

39,081

22,634

33,562

-563

5,585

574

0

0

0

Accounts receivable—oil, natural gas and NGL sales

-50,276

12,996

-32,234

-7,343

-3,430

-2,076

36,741

48,324

60,608

59,235

45,981

23,473

14,571

18,128

0

0

0

Inventory, prepaid expenses and other

-116

332

-862

-559

364

853

980

1,232

1,016

523

1,017

960

1,222

1,110

0

0

0

Accounts payable and accrued liabilities

-2,814

-5,753

1,476

440

6,573

-6,835

14,769

24,140

15,069

31,202

708

-5,706

-9,362

-19,187

0

0

0

Increase (Decrease) in Accounts Payable and Accrued Liabilities, Related Party

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Revenue payable

12,218

-7,598

-16,393

7,585

18,110

66,276

72,542

51,445

44,966

17,643

-10,783

-1,843

-3,633

-6,602

0

0

0

Production taxes payable

39,040

40,957

41,660

55,904

77,180

79,106

68,389

55,102

47,849

32,252

21,886

15,007

18,017

14,585

0

0

0

Accrued interest payable

222

-1,624

-1,520

-2,764

-1,285

-1,558

4,724

2,434

9,957

4,186

5,276

19,831

-2,570

19,171

0

0

0

Asset retirement expenditures

-33,707

-27,702

-18,313

-16,682

-16,300

-13,669

-12,197

-8,250

-5,493

-4,168

-1,723

-1,493

-1,193

-687

0

0

0

Net cash provided by operating activities

570,945

557,957

573,132

616,287

699,790

684,933

643,591

538,228

416,886

316,965

164,861

145,337

102,481

120,688

0

0

0

Cash flows from investing activities:
Oil and gas property additions

590,826

635,853

709,799

754,220

888,357

958,399

1,129,874

1,317,836

1,294,250

1,370,787

1,241,616

862,059

705,120

449,600

0

0

0

Acquired oil and gas properties

-

-

-

-

-

-

-

-

-

17,225

0

0

0

-

-

-

-

Sale of property and equipment

51,901

56,305

50,516

28,516

97,400

80,879

72,345

75,500

3,155

5,155

5,663

2,508

2,508

2,656

0

0

0

Gathering systems and facilities additions, net of cost reimbursements

149,145

202,513

209,227

180,688

124,585

81,406

0

0

0

-

-

-

-

-

-

-

-

Other property and equipment additions

33,857

39,090

36,622

38,440

23,047

15,991

27,758

14,659

15,663

17,737

6,242

10,863

9,300

7,655

0

0

0

Investment in unconsolidated subsidiaries

35,116

30,012

22,487

20,669

10,929

6,000

0

0

0

-

-

-

-

-

-

-

-

Distributions from unconsolidated subsidiary, return of capital

-1,448

0

569

1,209

1,311

0

402

518

655

518

0

0

0

-

-

-

-

Net cash used in investing activities

-757,481

-850,153

-926,040

-880,680

-864,595

-897,305

-1,045,399

-1,277,277

-1,329,946

-1,404,528

-1,630,324

-1,306,648

-1,134,751

-873,608

0

0

0

Cash flows from financing activities:
Borrowings under credit facility

470,000

465,000

420,000

450,000

455,000

635,000

905,000

995,000

810,000

565,000

453,000

253,000

253,000

263,000

0

0

0

Repayments under credit facility

325,000

280,000

160,000

160,000

230,000

440,000

615,000

805,000

710,000

475,000

0

0

0

-

-

-

-

Repayments of 2021 Senior Notes

-

-

-

-

-

-

0

0

550,000

-

0

0

0

-

-

-

-

Make-whole premium paid on 2021 Senior Notes

-

-

-

-

-

-

0

0

-35,600

-

0

0

0

-

-

-

-

Repurchase of 2026 Senior Notes

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from the issuance of Senior Notes

-

-

-

-

-

739,664

739,664

1,133,664

1,133,664

394,000

0

0

0

-

-

-

-

Repurchase of common stock

0

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

Payment of employee payroll withholding taxes

1,432

1,851

3,629

3,378

3,476

5,327

1,834

4,335

4,109

1,804

0

0

0

-

-

-

-

Dividends on Series A Preferred Stock

0

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

Debt and equity issuance costs

2,032

2,104

2,127

1,087

966

3,175

6,125

9,707

8,584

6,295

0

0

0

-

-

-

-

Preferred Unit issuance Costs

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Preferred Unit issuance costs

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

Preferred Unit issuance costs

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Payments of Stock Issuance Costs

-

-

-

-

-

-

-

-

-

-

63,989

65,795

65,822

64,554

0

0

0

Effect of deconsolidation of Elevation Midstream, LLC

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by financing activities

113,486

89,592

136,571

232,051

262,213

440,590

561,734

710,209

621,554

463,395

1,578,216

1,154,730

1,273,231

1,286,750

0

0

0

(Decrease) increase in cash and cash equivalents

-80,778

-202,604

-216,337

-32,342

97,408

228,218

159,926

-28,840

-291,506

-624,168

112,753

-6,581

240,961

533,830

0

0

0

Supplemental cash flow information:
Property and equipment included in accounts payable and accrued liabilities

74,586

118,152

151,974

167,902

147,677

141,952

169,705

214,665

217,706

151,571

182,101

190,259

116,738

105,450

0

0

0

Cash paid for interest

92,684

93,084

89,429

88,265

84,955

84,224

76,462

73,843

57,277

54,492

45,452

26,589

50,965

31,280

0

0

0

Accretion of beneficial conversion feature of Series A Preferred Stock

6,814

6,640

6,470

6,303

6,142

5,984

5,831

5,681

5,536

5,394

0

0

0

-

-

-

-

Preferred Units commitment fees and dividends paid-in-kind

22,177

19,992

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Series A Preferred Stock Dividends

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-