Mid-con energy partners, lp (MCEP)
CashFlow / TTM
Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15Dec'14Sep'14Jun'14Mar'14Dec'13Sep'13Jun'13Mar'13Dec'12Sep'12Jun'12Mar'12Dec'11Sep'11Jun'11Mar'11
Cash flows from operating activities
Net loss

-599

9,639

329

-11,623

-18,253

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net (loss) income

-

-

-

-

-

-

-

-

-

-

-

-17,059

-24,814

-79,464

-102,521

-94,696

-95,495

-37,452

5,028

16,819

22,492

31,745

19,000

25,691

28,189

25,763

20,369

32,259

29,862

19,967

32,812

18,661

18,968

0

0

0

Adjustments to reconcile net loss to net cash provided by operating activities
Depreciation, depletion and amortization

10,621

13,131

15,384

16,408

16,751

15,509

15,047

16,285

17,713

19,374

20,689

21,858

23,074

26,032

30,022

32,413

34,174

33,669

29,579

26,060

21,877

17,364

15,385

14,621

14,421

13,961

12,986

11,475

10,324

10,162

9,451

7,947

7,160

0

0

0

Debt issuance costs amortization

702

708

705

702

678

864

1,033

1,202

1,384

1,376

1,378

1,371

1,372

1,336

1,271

1,214

1,156

1,043

815

584

348

186

176

169

168

176

161

146

131

0

0

0

-

-

-

-

Accretion of discount on asset retirement obligations

1,596

1,141

1,122

896

721

882

620

565

520

520

505

528

577

599

563

497

432

351

324

290

250

224

207

187

173

158

146

137

126

0

0

0

-

-

-

-

Gain on settlement of ARO

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Impairment of proved oil and natural gas properties

-

-

0

22,409

-

-

16,784

33,497

24,746

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Dry holes and abandonments of unproved properties

-

-

-

-

612

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

813

0

0

0

Loss (gain) on settlements of asset retirement obligations

-

-

-

-

10

-12

17

-51

-37

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for settlements of asset retirement obligations

-

-

-

-

128

167

139

113

95

0

0

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loss (gain) on derivatives, net

-10,246

21,842

9,754

-3,142

5,674

-24,101

-20,492

-8,459

-1,945

-1,322

983

-11,638

-12,202

1,858

22,073

23,290

22,366

39,564

29,073

33,053

29,361

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Cash settlements paid for matured derivatives, net

-949

-1,690

-4,009

-5,461

-6,928

-6,881

-4,075

-1,537

-369

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash settlements (paid) received for matured derivatives, net

-949

-1,690

-4,009

-5,461

-6,928

-6,881

-4,075

-1,537

-369

2,568

3,427

9,261

20,511

31,444

38,645

34,877

28,543

20,210

11,067

6,572

891

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Cash settlements received for early terminations and modifications of derivatives, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

11,069

11,069

11,069

11,069

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Cash premiums paid for derivatives

-

-

-

-

-

-

-

-

5,048

6,404

5,475

5,789

5,161

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

(Gain) loss on sales of oil and natural gas properties

9,671

9,572

9,571

9,360

-509

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,621

0

0

0

(Gain) loss on unsettled derivative instruments, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-7,968

-8,570

4,984

2,004

-2,325

12,132

-184

3,437

0

0

0

Non-cash equity-based compensation

696

651

833

839

744

695

466

508

434

632

869

959

1,184

1,208

1,538

1,650

3,204

3,451

3,946

3,824

7,394

7,857

7,372

7,264

6,376

6,548

8,401

8,297

6,323

0

0

0

-

-

-

0

Changes in operating assets and liabilities
Accounts receivable

2,856

-3,230

749

211

-1,367

3,766

1,333

153

-40

-106

-979

740

751

-1,481

-1,787

-2,013

-3,500

-2,303

-1,183

-1,716

1,273

1,479

1,426

1,147

365

1,557

2,779

1,220

1,395

3,397

1,272

3,303

4,454

0

0

0

Other receivables

-

-

-

-203

-

-

-

363

-150

-280

-1,263

-2,991

-4,935

-2,897

31

1,963

566

2,506

708

496

3,966

222

-125

-313

-499

0

0

0

-

-

-

-

-

-

-

-

Prepaid expenses and other assets

-70

69

-1,250

99

61

1,094

2,444

1,085

655

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Prepaids and other

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-10

-29

238

247

65

461

362

364

517

526

400

481

543

-2,159

0

0

0

-

-

-

-

Other current assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Accounts payable - trade and accrued liabilities

97

-1,125

-218

-97

-210

107

561

129

427

998

-655

494

69

138

451

-34

-3,388

-5,151

-4,140

-2,281

2,067

4,578

2,959

57

158

-2,122

2,045

2,079

1,498

9,400

8,393

6,432

4,608

0

0

0

Accounts payable - related parties

1,554

793

138

-934

1,708

1,531

1,826

69

-1,478

735

-1,233

300

-76

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by operating activities

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Revenues payable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

32

0

0

0

Advance billings and other

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-120

0

0

0

Net cash provided by operating activities

11,809

16,874

17,100

17,019

22,585

0

0

0

-

-

-

-

-

-

-

52,246

48,425

42,218

43,783

46,897

50,464

53,729

52,510

53,513

56,634

52,417

52,916

48,629

47,717

47,344

43,305

35,298

24,113

0

0

0

Cash flows from investing activities
Acquisitions of oil and natural gas properties

3,331

2,913

15,248

15,140

21,243

21,992

9,625

13,799

5,034

0

0

0

-

-

-

0

-

-

-

-

155,354

38,869

13,960

35,039

28,057

0

0

0

-

-

-

-

16,026

0

0

0

Additions to oil and natural gas properties

13,868

11,908

9,978

10,209

8,617

8,738

9,330

9,245

9,947

9,393

8,069

7,792

7,223

7,754

8,760

10,115

13,893

21,140

26,535

32,952

33,969

27,299

23,895

21,604

22,366

26,075

30,927

26,469

23,960

28,315

28,395

31,448

32,654

0

0

0

Additions to other property and equipment

-

-

-

-

-

-

-

-

137

0

0

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

679

0

0

0

Proceeds from sales of oil and natural gas properties

33,453

32,395

32,395

32,395

1,044

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sale of other property and equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,219

0

0

0

Net cash provided by (used in) investing activities

16,377

17,697

7,169

7,046

-28,816

0

0

0

-

-

-

-

-

-

-

-10,116

-13,894

-137,661

-167,283

-181,060

-189,323

-66,168

-37,855

-56,643

-50,423

-86,099

-91,784

-75,312

-72,539

-50,772

-52,686

-40,371

-42,045

0

0

0

Cash flows from financing activities
Proceeds from line of credit

11,000

10,000

22,000

27,000

22,000

0

0

0

-

-

-

-

-

-

-

-

28,000

87,000

130,000

152,000

168,000

127,000

100,000

116,000

105,000

0

0

0

-

-

-

-

68,564

0

0

0

Payments on line of credit

36,000

41,000

43,000

48,238

28,000

46,000

43,000

39,262

29,000

11,900

45,018

48,500

58,000

66,100

42,982

51,000

53,000

61,000

69,000

72,000

75,000

71,000

72,000

73,000

71,000

88,800

77,800

58,800

47,800

0

0

0

-

-

-

-

Borrowings on note payable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

412

0

0

0

Payments on note payable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

84

0

0

0

Repurchase of common units

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

Offering costs

-

-

-

-

-

-

-

-

99

92

59

70

16

122

122

123

194

88

88

87

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Distributions to common units

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

11,266

23,469

30,774

38,054

44,564

42,480

41,536

40,395

39,830

39,068

37,637

36,368

27,705

0

0

0

-

-

-

-

Debt issuance costs

-

-

-

-

681

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Distributions to convertible preferred units

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) financing activities

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash (used in) provided by financing activities

-28,398

-34,230

-24,261

-24,492

4,866

0

0

0

-

-

-

-

-

-

-

-42,325

-37,148

94,834

122,449

134,080

140,657

13,350

-13,626

2,605

-5,830

33,284

35,715

21,984

25,647

4,299

12,905

9,783

17,938

0

0

0

Net increase (decrease) in cash and cash equivalents

-

-

-

-

-

-

-

-

-

-

-

2,694

1,744

1,154

3,230

-195

-2,617

-609

-1,051

-83

1,798

911

1,029

-525

381

-398

-3,153

-4,699

825

871

3,524

4,710

6

0

0

0

Net decrease in cash and cash equivalents

-

-

-

-427

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for interest

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

3,759

3,287

3,109

2,803

2,747

2,227

1,781

1,561

1,209

1,019

807

535

0

0

0

Accrued capital expenditures - oil and natural gas properties

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

1,596

1,269

1,037

926

593

515

2,383

1,005

2,695

3,953

884

3,331

0

0

0

Class B Convertible Preferred Units [Member]
Proceeds from sale of Class B convertible preferred units, net of offering costs

-

-

-

-

14,847

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Distributions to convertible preferred units

1,200

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Class A Convertible Preferred Units [Member]
Distributions to convertible preferred units

2,000

2,000

2,000

2,000

2,500

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-