Nextier oilfield solutions inc. (FRAC)
CashFlow / Quarterly
Mar'20Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16
Cash flows from operating activities:
Net Income (Loss) Attributable to Parent

-71,756

-82,928

3,558

-4,981

-21,806

6,128

30,779

30,667

-8,243

43,947

4,065

-11,898

-72,255

-38,536

-51,667

-45,691

-51,193

Adjustments to reconcile net loss to net cash provided by operating activities
Depreciation, Depletion and Amortization

85,821

82,081

68,707

69,886

71,476

71,403

68,287

59,404

60,051

49,964

46,204

32,739

30,373

29,036

28,114

27,721

16,108

Amortization of deferred financing fees

551

434

466

264

236

771

966

740

623

579

596

178

3,847

1,373

1,301

955

523

(Gain) loss on disposal of assets

7,962

-3,639

-680

330

-481

122

-1,113

-3,287

-769

2,418

-301

2

436

-

-

-

-

Asset Impairment Charges

34,327

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Loss on debt extinguishment/modification, including prepayment premiums

-

-

-

-

-

-

-

-

-

0

0

0

-31,084

0

0

0

0

Loss on contingent consideration liability

-

-

-

-

-

0

0

0

13,254

0

0

0

0

-

-

-

-

Unrealized loss on derivative

2,961

-1,036

2,120

3,682

2,862

4,309

-1,119

-99

-2,211

-958

178

173

-184

4,822

0

-1,647

-1,391

Realized (gain) loss on derivative

-341

-261

56

196

248

224

163

239

71

-

-

-

-

-

-

-

-

Stock-based compensation

6,880

13,852

5,488

5,637

4,000

5,242

4,811

4,040

3,073

3,244

3,263

2,933

1,138

159

-15

72

1,769

Accrued interest on loan—related party

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-1,703

2,174

Other non-cash expense, net

0

-

-

0

-8

-

-

0

0

-

-

-

-

0

0

-8

8

Changes in operating assets and liabilities:
Decrease (increase) in trade and other accounts receivable, net

30,833

-158,089

-2,877

3,536

-15,136

-35,917

-467

2,039

6,860

18,810

17,822

16,263

60,152

10,615

10,469

-15,671

7,614

Decrease in inventories

-5,647

-3,097

-5,036

-4,338

-4,710

6,896

-11,789

2,774

4,844

-5,942

7,167

8,713

5,537

2,426

3,780

388

-15,079

Decrease in prepaid and other current assets

-4,888

-4,329

369

2,247

-1,990

-4,197

-1,275

-400

3,138

-11,884

-4,580

1,090

-4,920

2,991

-8

2,746

265

Decrease (increase) in other assets

-4,958

-41,649

-5,059

-4,485

51,435

-3,491

1,000

807

1,322

594

-91

-317

150

335

77

-358

-86

Increase in accounts payable

27,694

-33,602

-7,708

14,614

8,897

-4,041

-1,863

-6,506

23,714

-26,061

16,199

654

9,067

13,592

7,008

6,760

-13,146

Decrease in accrued expenses

-8,478

-81,325

4,857

153

-27,294

-12,338

6,520

16,997

-43,497

35,909

-17,147

13,062

9,622

10,045

5,663

2,179

1,848

Increase (decrease) in customer contract liabilities

2,940

-411

0

411

0

-1,220

-1,260

-1,310

-1,150

0

0

0

0

-

-

-

-

Increase (decrease) in other liabilities

-3,570

-43,149

-2,813

-1,280

55,100

-1,473

-269

-259

-395

-29,507

9,716

-2,276

889

-1,905

4,251

-3,005

1,005

Net cash provided by operating activities

48,487

79,884

83,654

83,536

58,389

99,207

107,679

109,250

34,175

75,077

42,701

9,319

-47,406

-3,689

-19,487

5,713

-36,591

Cash flows from investing activities:
Proceeds from sale of business

53,259

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Payments to Acquire Businesses, Gross

-

-

-

-

-

-

-

-

-

-

-

-

-

0

4,500

0

199,400

Purchase of property and equipment

40,798

46,278

42,413

54,829

56,865

65,607

83,784

100,865

27,313

56,992

56,413

17,865

10,070

7,522

7,608

2,382

5,614

Advances of deposit on equipment

1,775

2,402

2,730

544

1,775

352

2,997

-281

1,085

19,429

3,273

394

0

-

-

-

-

Payments for leasehold improvements

-

-

-

-

-

77

119

0

1,455

0

0

0

157

0

0

0

0

Implementation of software

2,600

1,087

1,538

1,040

743

175

631

28

49

27

323

330

7

144

131

143

35

Proceeds from disposal of assets

5,973

5,665

5,101

8,689

9,659

2,140

1,436

422

654

20,035

8,137

17

2,376

-35

374

0

372

Equity method investment

-

-

-

-

-

-17

0

582

581

0

0

0

0

-

-

-

-

Proceeds from insurance recoveries

58

0

117

68

38

25

18,117

105

0

-

-

-

-

-

-

-

-

Net cash provided (used) in investing activities

14,117

24,705

-41,463

-47,656

-49,686

-64,029

-102,981

-100,667

-29,829

-48,100

-176,246

-18,572

-7,858

-8,000

-11,959

-2,525

-204,677

Cash flows from financing activities:
Proceeds from asset-based revolver

175,000

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from issuance of common stock

-

-

-

-

-

-

-

-

-

0

0

0

255,494

0

0

0

0

Proceeds from the secured notes and term loan facilities

-

-

-

-

-

-

-

-

-

0

135,000

0

150,000

0

0

0

100,000

Payments on the secured notes and term loan facility

875

875

875

875

875

875

875

282,491

711

712

712

375

288,103

647

1,875

1,875

1,250

Payments on finance leases

2,278

2,221

1,261

1,157

1,396

1,245

1,088

939

847

802

729

668

662

619

716

905

428

Payment for Debt Extinguishment or Debt Prepayment Cost

-

-

-

-

-

-

-

-

-

-17

0

0

15,817

0

0

0

0

Payment of debt issuance costs

-

-

-

-

-

0

81

7,227

23

1,053

3,939

0

8,800

406

128

829

13,689

Shares repurchased and retired related to stock-based compensation

1,151

2,495

122

504

2,861

164

76

0

3,339

0

0

0

0

-

-

-

-

Contributions

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

2,645

-202,645

Net cash provided (used) in financing activities

170,696

-6,820

-2,258

-2,536

-5,132

-37,719

-31,422

5,507

-4,920

-2,567

129,620

-1,043

92,112

-1,672

-2,719

-6,254

287,278

Non-cash effect of foreign translation adjustments

1,107

221

0

0

-29

-101

47

-53

-58

-19

102

52

28

-102

7

3

172

Net increase in cash, cash equivalents and restricted cash

234,407

97,990

39,933

33,344

3,542

-2,642

-26,677

14,037

-632

24,391

-3,823

-10,244

36,876

-13,463

-34,157

-3,064

46,182

Supplemental disclosure of cash flow information:
Interest expense, net

5,724

4,989

5,000

5,523

5,324

6,074

5,337

6,372

6,745

11,407

3,777

3,537

11,383

9,082

8,867

2,660

4,907

Income taxes

2

96

130

1,500

0

303

3,160

2,066

0

0

0

0

0

0

0

0

0

Non-cash investing and financing activities:
Change in accrued capital expenditures

29,900

-887

-6,088

-1,664

-8,635

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash purchases of property and equipment

-

-

-

-

-

-

-

-

19,861

-

-9,250

14,288

12,113

9,364

-7,625

7,400

225

Non-cash proceeds from disposal of assets

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

Non-cash additions to finance right-of-use assets

0

-

945

-945

6,029

-

0

0

0

-

-

-

-

-

-

-

-

Non-cash additions to finance lease liabilities, including current maturities

0

-

1,077

-1,077

6,164

-

0

0

0

-

-

-

-

-

-

-

-

Non-cash additions to operating right-of-use assets

1,970

-

1,028

-1,028

62,698

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash additions to operating lease liabilities, including current maturities

-1,970

-

990

-990

62,444

-

0

-935

935

-

-

-

-

-

-

-

-

Non-cash additions to capital lease obligations

-

-

-

-

-

-

-

-

-

-

1,509

180

0

-

-

-

-

Non-cash forgiveness of related party loan

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

2,646

20,000

Non-cash issuance of Class A and C Units

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

42,669