Nextier oilfield solutions inc. (FRAC)
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 Income (Loss) Attributable to Parent

-156,107

-106,157

-17,101

10,120

45,768

59,331

97,150

70,436

27,871

-36,141

-118,624

-174,356

-208,149

-187,087

0

0

0

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

306,495

292,150

281,472

281,052

270,570

259,145

237,706

215,623

188,958

159,280

138,352

120,262

115,244

100,979

0

0

0

Amortization of deferred financing fees

1,715

1,400

1,737

2,237

2,713

3,100

2,908

2,538

1,976

5,200

5,994

6,699

7,476

4,152

0

0

0

(Gain) loss on disposal of assets

3,973

-4,470

-709

-1,142

-4,759

-5,047

-2,751

-1,939

1,350

2,555

0

0

0

-

-

-

-

Asset Impairment Charges

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Loss on debt extinguishment/modification, including prepayment premiums

-

-

-

-

-

-

-

-

-

-31,084

-31,084

-31,084

-31,084

0

0

0

0

Loss on contingent consideration liability

-

-

-

-

-

13,254

13,254

13,254

13,254

0

0

0

0

-

-

-

-

Unrealized loss on derivative

7,727

7,628

12,973

9,734

5,953

880

-4,387

-3,090

-2,818

-791

4,989

4,811

2,991

1,784

0

0

0

Realized (gain) loss on derivative

-350

239

724

831

874

697

0

0

0

-

-

-

-

-

-

-

-

Stock-based compensation

31,857

28,977

20,367

19,690

18,093

17,166

15,168

13,620

12,513

10,578

7,493

4,215

1,354

1,985

0

0

0

Accrued interest on loan—related party

-

-

-

-

-

-

-

-

-

-

-

-

-

471

0

0

0

Other non-cash expense, net

0

-

-

0

0

-

-

0

0

-

-

-

-

0

0

0

0

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

-126,597

-172,566

-50,394

-47,984

-49,481

-27,485

27,242

45,531

59,755

113,047

104,852

97,499

65,565

13,027

0

0

0

Decrease in inventories

-18,118

-17,181

-7,188

-13,941

-6,829

2,725

-10,113

8,843

14,782

15,475

23,843

20,456

12,131

-8,485

0

0

0

Decrease in prepaid and other current assets

-6,601

-3,703

-3,571

-5,215

-7,862

-2,734

-10,421

-13,726

-12,236

-20,294

-5,419

-847

809

5,994

0

0

0

Decrease (increase) in other assets

-56,151

242

38,400

44,459

49,751

-362

3,723

2,632

1,508

336

77

245

204

-32

0

0

0

Increase in accounts payable

998

-17,799

11,762

17,607

-3,513

11,304

-10,716

7,346

14,506

-141

39,512

30,321

36,427

14,214

0

0

0

Decrease in accrued expenses

-84,793

-103,609

-34,622

-32,959

-16,115

-32,318

15,929

-7,738

-11,673

41,446

15,582

38,392

27,509

19,735

0

0

0

Increase (decrease) in customer contract liabilities

2,940

0

-809

-2,069

-3,790

-4,940

-3,720

-2,460

-1,150

0

0

0

0

-

-

-

-

Increase (decrease) in other liabilities

-50,812

7,858

49,534

52,078

53,099

-2,396

-30,430

-20,445

-22,462

-21,178

6,424

959

230

346

0

0

0

Net cash provided by operating activities

295,561

305,463

324,786

348,811

374,525

350,311

326,181

261,203

161,272

79,691

925

-61,263

-64,869

-54,054

0

0

0

Cash flows from investing activities:
Proceeds from sale of business

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Payments to Acquire Businesses, Gross

-

-

-

-

-

-

-

-

-

-

-

-

-

203,900

0

0

0

Purchase of property and equipment

184,318

200,385

219,714

261,085

307,121

277,569

268,954

241,583

158,583

141,340

91,870

43,065

27,582

23,126

0

0

0

Advances of deposit on equipment

7,451

7,451

5,401

5,668

4,843

4,153

23,230

23,506

24,181

23,096

0

0

0

-

-

-

-

Payments for leasehold improvements

-

-

-

-

-

1,651

1,574

1,455

1,455

157

157

157

157

0

0

0

0

Implementation of software

6,265

4,408

3,496

2,589

1,577

883

735

427

729

687

804

612

425

453

0

0

0

Proceeds from disposal of assets

25,428

29,114

25,589

21,924

13,657

4,652

22,547

29,248

28,843

30,565

10,495

2,732

2,715

711

0

0

0

Equity method investment

-

-

-

-

-

1,146

1,163

1,163

581

0

0

0

0

-

-

-

-

Proceeds from insurance recoveries

243

223

248

18,248

18,285

18,247

0

0

0

-

-

-

-

-

-

-

-

Net cash provided (used) in investing activities

-50,297

-114,100

-202,834

-264,352

-317,363

-297,506

-281,577

-354,842

-272,747

-250,776

-210,676

-46,389

-30,342

-227,161

0

0

0

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

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from issuance of common stock

-

-

-

-

-

-

-

-

-

255,494

255,494

255,494

255,494

0

0

0

0

Proceeds from the secured notes and term loan facilities

-

-

-

-

-

-

-

-

-

285,000

285,000

150,000

150,000

100,000

0

0

0

Payments on the secured notes and term loan facility

3,500

3,500

3,500

3,500

285,116

284,952

284,789

284,626

2,510

289,902

289,837

291,000

292,500

5,647

0

0

0

Payments on finance leases

6,917

6,035

5,059

4,886

4,668

4,119

3,676

3,317

3,046

2,861

2,678

2,665

2,902

2,668

0

0

0

Payment for Debt Extinguishment or Debt Prepayment Cost

-

-

-

-

-

-

-

-

-

15,800

15,817

15,817

15,817

0

0

0

0

Payment of debt issuance costs

-

-

-

-

-

7,331

8,384

12,242

5,015

13,792

13,145

9,334

10,163

15,052

0

0

0

Shares repurchased and retired related to stock-based compensation

4,272

5,982

3,651

3,605

3,101

3,579

3,415

3,339

3,339

0

0

0

0

-

-

-

-

Contributions

-

-

-

-

-

-

-

-

-

-

-

-

-

-200,000

0

0

0

Net cash provided (used) in financing activities

159,082

-16,746

-47,645

-76,809

-68,766

-68,554

-33,402

127,640

121,090

218,122

219,017

86,678

81,467

276,633

0

0

0

Non-cash effect of foreign translation adjustments

1,328

192

-130

-83

-136

-165

-83

-28

77

163

80

-15

-64

80

0

0

0

Net increase in cash, cash equivalents and restricted cash

405,674

174,809

74,177

7,567

-11,740

-15,914

11,119

33,973

9,692

47,200

9,346

-20,988

-13,808

-4,502

0

0

0

Supplemental disclosure of cash flow information:
Interest expense, net

21,236

20,836

21,921

22,258

23,107

24,528

29,861

28,301

25,466

30,104

27,779

32,869

31,992

25,516

0

0

0

Income taxes

1,728

1,726

1,933

4,963

5,529

5,529

5,226

2,066

0

0

0

0

0

0

0

0

0

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

21,261

-17,274

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash purchases of property and equipment

-

-

-

-

-

-

-

-

32,941

-

26,515

28,140

21,252

9,364

0

0

0

Non-cash proceeds from disposal of assets

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

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

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

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

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

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

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

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

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

Non-cash additions to capital lease obligations

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

Non-cash forgiveness of related party loan

-

-

-

-

-

-

-

-

-

-

-

-

-

22,646

0

0

0

Non-cash issuance of Class A and C Units

-

-

-

-

-

-

-

-

-

-

-

-

-

42,669

0

0

0