Dril-quip, inc. (DRQ)
CashFlow / Quarterly
Mar'20Dec'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'11Dec'10Sep'10Jun'10Mar'10
Operating activities
Net loss

-19,698

7,399

-1,310

1,682

-6,051

-74,912

-10,362

-3,038

-7,383

-71,490

-29,259

16

94

1,302

19,013

36,137

36,769

48,354

50,777

39,213

53,664

59,087

55,683

51,324

42,618

47,063

39,995

42,927

39,842

30,952

29,657

29,803

28,797

28,124

23,263

22,208

21,672

20,874

27,657

27,998

25,697

Adjustments to reconcile net loss to net cash provided by (used in) operating activities:
Depreciation and amortization

8,873

8,865

8,304

8,495

8,356

9,346

8,724

9,001

8,241

8,743

9,518

12,881

9,832

8,765

7,592

7,725

7,775

7,700

7,638

7,684

7,455

8,381

7,648

7,446

7,680

7,623

7,364

7,352

7,001

6,814

6,979

6,373

6,058

6,040

6,367

4,851

5,755

5,589

5,206

5,196

4,884

Stock-based compensation expense

3,176

-25

7,663

3,221

4,862

3,509

2,365

3,611

3,974

3,793

3,694

3,567

3,216

2,775

3,188

3,062

3,192

3,331

3,312

3,119

3,363

3,216

2,980

2,834

2,826

2,643

2,121

2,045

2,091

1,826

1,311

1,151

1,460

1,104

1,044

1,190

1,204

1,349

1,216

1,203

1,192

Impairments

7,719

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Restructuring and other charges

32,713

12

-152

-957

1,271

98,602

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Gain on sale of assets

467

28

280

1,190

13

1,085

14

5,077

22

89

-9

88

0

10

64

16

13

4

2

-138

63

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loss (gain) on sale of equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-206

-36

2

-520

272

7

357

0

92

119

3

Deferred income taxes

-10,862

1,132

-698

237

-73

-3,177

-1,492

583

-5

48,760

-30,043

-365

-1,121

35

393

-2,866

-962

3,955

-2,485

-2,180

-2,755

-5,024

4,386

-1,638

-869

2,208

-1,692

-609

-1,142

797

-123

-2

-334

-675

-1,107

488

-218

-2,737

5,532

1,076

-5,804

Changes in operating assets and liabilities:
Trade receivables, net

19,444

-46,249

18,750

32,484

-15,768

-17,690

6,709

-5,812

-1,195

15,071

-26,094

11,867

-7,044

-14,469

-27,875

-73,142

8,942

23,600

10,179

-7,671

-62,837

47,527

21,897

47,952

-14,680

34,980

-2,527

30,959

-46,162

22,079

18,731

32,604

8,152

-5,355

-3,468

35,298

-3,776

28,233

-10,140

2,349

8,304

Unbilled receivables

-11,224

-

-

-

21,365

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Inventories, net

15,537

-1,570

14,622

-1,698

2,700

-17,316

-9,879

-5,487

-17,244

-5,046

-3,350

-17,655

-11,591

-20,388

13,278

1,136

-1,899

-19,546

-5,645

-10,358

7,010

-7,233

11,339

6,375

26,333

-1,513

-12,583

12,975

11,683

11,673

7,061

37,813

25,337

7,992

12,248

10,047

7,203

-6,245

3,305

472

-4,789

Prepaids and other assets

11,723

1,764

-6,884

10,100

-15,960

5,409

6,558

-959

4,076

7,201

-12,837

-1,420

-3,051

24,534

-13,692

-12,608

-8,050

9,136

5,789

1,699

1,259

10,517

5,916

-1,636

-1,558

-3,575

-3,507

1,355

-434

13,919

-6,526

-1,523

2,640

2,652

-401

298

-1,357

3,855

7,980

-3,759

-1,608

Excess tax benefits of stock options and awards

-

-

-

-

-

-

-

-

-

-

-

-

-

77

32

15

11

13

0

33

24

249

58

202

49

970

211

1,076

606

268

210

956

53

875

48

201

48

1,658

2

277

833

Accounts payable and accrued expenses

-7,212

1,676

10,936

17,209

-14,478

-18,714

13,333

-5,971

-7,403

41,124

-21,133

4,005

-22,231

1,915

254

-18,303

4,766

-18,716

-3,190

-38,329

-29,139

32,076

4,475

11,145

6,492

-7,302

-11,585

5,790

-7,116

9,342

3,991

1,478

-1,281

20,309

-5,065

11,985

14,633

6,589

18,906

-15,184

-317

Other, net

1

0

0

636

-699

-427

-25

711

-377

-269

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) operating activities

-21,237

8,054

-4,026

9,812

838

12,896

9,141

12,078

11,388

33,258

36,035

27,224

11,476

25,028

58,633

110,338

52,523

31,417

45,727

25,942

87,069

46,729

35,912

18,069

48,603

21,375

54,753

11,118

74,983

1,791

22,545

-31,011

-1,484

50,609

15,803

-5,129

40,571

6,142

57,278

20,831

22,909

Investing activities
Purchase of property, plant and equipment

4,187

2,881

4,022

1,071

3,527

5,378

7,078

9,034

10,571

8,059

6,627

8,089

4,847

5,474

5,013

7,544

7,732

10,333

5,542

5,048

6,156

11,385

7,946

9,998

13,220

12,596

6,936

11,031

12,070

10,167

12,869

13,870

13,867

11,099

12,275

13,030

19,809

26,230

26,605

14,387

7,593

Proceeds from sale of equipment

687

629

836

1,224

341

5,644

727

10,446

71

2,010

550

171

439

76

142

63

76

241

47

15

121

435

73

114

356

532

-71

133

166

471

213

933

157

-232

235

978

1,045

636

151

597

481

Acquisition of business, net of cash acquired

-

-

-

-

-

-

-

-

-

-849

0

1,420

19,869

132,443

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-3,500

-2,252

-3,186

153

-3,186

266

-6,351

1,412

-10,500

-5,200

-6,077

-9,338

-24,277

-137,841

-4,871

-7,481

-7,656

-10,092

-5,495

-5,033

-6,035

-10,950

-7,873

-9,884

-12,864

-12,064

-7,007

-10,898

-11,904

-9,696

-12,656

-12,937

-13,710

-11,331

-12,040

-12,052

-18,764

-25,594

-26,454

-13,790

-7,112

Financing activities
Principal payments on debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

12

10

75

172

169

173

166

171

Proceeds from exercise of stock options

-

-

-

-

-

510

464

590

52

105

52

0

403

1,266

432

353

155

218

0

1,670

282

985

478

923

463

1,144

1,613

4,682

3,067

769

2,836

6,713

491

3,791

18

76

310

6,689

1,628

509

3,717

Excess tax benefits of stock options and awards

-

-

-

-

-

-

-

-

-

-

-

-

-

77

32

15

11

13

0

33

24

249

58

202

49

970

211

1,076

606

268

210

956

53

875

48

201

48

1,658

2

277

833

Repurchase of common shares

25,000

21,205

3,369

880

1,116

19,063

71,107

9,830

0

-

-

-

-

-4

48,476

-24,238

0

34,894

20,968

19,943

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other

-85

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-25,085

-21,295

-1,281

-880

-1,116

-18,553

-70,643

-10,055

52

105

52

0

403

1,347

464

-23,870

166

-34,663

-20,968

-18,240

306

-48,739

-49,703

-88,897

512

-7,888

1,824

5,758

3,673

998

3,046

7,669

544

4,654

56

202

186

8,178

1,457

620

4,379

Effect of exchange rate changes on cash activities

-5,652

1,337

-1,531

-767

172

-562

-1,516

-5,604

1,471

-8,028

6,048

4,911

3,091

-7,667

-3,325

-10,624

-3,003

-2,295

-4,968

5,873

-5,914

-3,299

-5,993

2,395

331

1,991

5,831

589

-4,969

677

2,343

-1,066

1,562

-928

1,635

-1,179

433

-850

-210

823

-549

Decrease in cash and cash equivalents

-55,474

-14,156

-10,024

8,318

-3,292

-5,953

-69,369

-2,169

2,411

20,135

36,058

22,797

-9,307

-119,133

50,901

68,363

42,030

-15,633

14,296

8,542

75,426

-16,259

-27,657

-78,317

36,582

3,414

55,401

6,567

61,783

-6,230

15,278

-37,345

-13,088

43,004

5,454

-18,158

22,426

-12,124

32,071

8,484

19,627