Dril-quip, inc. (DRQ)
CashFlow / TTM
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

-11,927

1,720

-80,591

-89,643

-94,363

-95,695

-92,273

-111,170

-108,116

-100,639

-27,847

20,425

56,546

93,221

140,273

172,037

175,113

192,008

202,741

207,647

219,758

208,712

196,688

181,000

172,603

169,827

153,716

143,378

130,254

119,209

116,381

109,987

102,392

95,267

88,017

92,411

98,201

102,226

0

0

0

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

34,537

34,020

34,501

34,921

35,427

35,312

34,709

35,503

39,383

40,974

40,996

39,070

33,914

31,857

30,792

30,838

30,797

30,477

31,158

31,168

30,930

31,155

30,397

30,113

30,019

29,340

28,531

28,146

27,167

26,224

25,450

24,838

23,316

23,013

22,562

21,401

21,746

20,875

0

0

0

Stock-based compensation expense

14,035

15,721

19,255

13,957

14,347

13,459

13,743

15,072

15,028

14,270

13,252

12,746

12,241

12,217

12,773

12,897

12,954

13,125

13,010

12,678

12,393

11,856

11,283

10,424

9,635

8,900

8,083

7,273

6,379

5,748

5,026

4,759

4,798

4,542

4,787

4,959

4,972

4,960

0

0

0

Impairments

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Restructuring and other charges

31,616

174

98,764

98,916

99,873

98,602

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Gain on sale of assets

1,965

1,511

2,568

2,302

6,189

6,198

5,202

5,179

190

168

89

162

90

103

97

35

-119

-69

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loss (gain) on sale of equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-760

-282

-239

116

636

456

568

214

0

0

0

Deferred income taxes

-10,191

598

-3,711

-4,505

-4,159

-4,091

47,846

19,295

18,347

17,231

-31,494

-1,058

-3,559

-3,400

520

-2,358

-1,672

-3,465

-12,444

-5,573

-5,031

-3,145

4,087

-1,991

-962

-1,235

-2,646

-1,077

-470

338

-1,134

-2,118

-1,628

-1,512

-3,574

3,065

3,653

-1,933

0

0

0

Changes in operating assets and liabilities:
Trade receivables, net

24,429

-10,783

17,776

5,735

-32,561

-17,988

14,773

-18,030

-351

-6,200

-35,740

-37,521

-122,530

-106,544

-68,475

-30,421

35,050

-36,729

-12,802

-1,084

54,539

102,696

90,149

65,725

48,732

17,250

4,349

25,607

27,252

81,566

54,132

31,933

34,627

22,699

56,287

49,615

16,666

28,746

0

0

0

Unbilled receivables

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Inventories, net

26,891

14,054

-1,692

-26,193

-29,982

-49,926

-37,656

-31,127

-43,295

-37,642

-52,984

-36,356

-17,565

-7,873

-7,031

-25,954

-37,448

-28,539

-16,226

758

17,491

36,814

42,534

18,612

25,212

10,562

23,748

43,392

68,230

81,884

78,203

83,390

55,624

37,490

23,253

14,310

4,735

-7,257

0

0

0

Prepaids and other assets

16,703

-10,980

-7,335

6,107

-4,952

15,084

16,876

-2,519

-2,980

-10,107

7,226

6,371

-4,817

-9,816

-25,214

-5,733

8,574

17,883

19,264

19,391

16,056

13,239

-853

-10,276

-7,285

-6,161

11,333

8,314

5,436

8,510

-2,757

3,368

5,189

1,192

2,395

10,776

6,719

6,468

0

0

0

Excess tax benefits of stock options and awards

-

-

-

-

-

-

-

-

-

-

-

-

-

135

71

39

57

70

306

364

533

558

1,279

1,432

2,306

2,863

2,161

2,160

2,040

1,487

2,094

1,932

1,177

1,172

1,955

1,909

1,985

2,770

0

0

0

Accounts payable and accrued expenses

22,609

15,343

-5,047

-2,650

-25,830

-18,755

41,083

6,617

16,593

1,765

-37,444

-16,057

-38,365

-11,368

-31,999

-35,443

-55,469

-89,374

-38,582

-30,917

18,557

54,188

14,810

-1,250

-6,605

-20,213

-3,569

12,007

7,695

13,530

24,497

15,441

25,948

41,862

28,142

52,113

24,944

9,994

0

0

0

Other, net

637

-63

-490

-515

-440

-118

40

65

-646

-269

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) operating activities

-7,397

14,678

19,520

32,687

34,953

45,503

65,865

92,759

107,905

107,993

99,763

122,361

205,475

246,522

252,911

240,005

155,609

190,155

205,467

195,652

187,779

149,313

123,959

142,800

135,849

162,229

142,645

110,437

68,308

-8,159

40,659

33,917

59,799

101,854

57,387

98,862

124,822

107,160

0

0

0

Investing activities
Purchase of property, plant and equipment

12,161

11,501

13,998

17,054

25,017

32,061

34,742

34,291

33,346

27,622

25,037

23,423

22,878

25,763

30,622

31,151

28,655

27,079

28,131

30,535

35,485

42,549

43,760

42,750

43,783

42,633

40,204

46,137

48,976

50,773

51,705

51,111

50,271

56,213

71,344

85,674

87,031

74,815

0

0

0

Proceeds from sale of equipment

3,376

3,030

8,045

7,936

17,158

16,888

13,254

13,077

2,802

3,170

1,236

828

720

357

522

427

379

424

618

644

743

978

1,075

931

950

760

699

983

1,783

1,774

1,071

1,093

1,138

2,026

2,894

2,810

2,429

1,865

0

0

0

Acquisition of business, net of cash acquired

-

-

-

-

-

-

-

-

-

20,440

153,732

153,732

152,312

132,443

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-8,785

-8,471

-5,953

-9,118

-7,859

-15,173

-20,639

-20,365

-31,115

-44,892

-177,533

-176,327

-174,470

-157,849

-30,100

-30,724

-28,276

-26,655

-27,513

-29,891

-34,742

-41,571

-42,685

-41,819

-42,833

-41,873

-39,505

-45,154

-47,193

-48,999

-50,634

-50,018

-49,133

-54,187

-68,450

-82,864

-84,602

-72,950

0

0

0

Financing activities
Principal payments on debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

269

426

589

680

679

0

0

0

Proceeds from exercise of stock options

-

-

-

-

-

1,616

1,211

799

209

560

1,721

2,101

2,454

2,206

1,158

726

2,043

2,170

2,937

3,415

2,668

2,849

3,008

4,143

7,902

10,506

10,131

11,354

13,385

10,809

13,831

11,013

4,376

4,195

7,093

8,703

9,136

12,543

0

0

0

Excess tax benefits of stock options and awards

-

-

-

-

-

-

-

-

-

-

-

-

-

135

71

39

57

70

306

364

533

558

1,279

1,432

2,306

2,863

2,161

2,160

2,040

1,487

2,094

1,932

1,177

1,172

1,955

1,909

1,985

2,770

0

0

0

Repurchase of common shares

50,454

26,570

24,428

92,166

101,116

100,000

0

0

0

-

-

-

-

24,234

59,132

31,624

75,805

75,805

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-48,541

-24,572

-21,830

-91,192

-100,367

-99,199

-80,541

-9,846

209

560

1,802

2,214

-21,656

-21,893

-57,903

-79,335

-73,705

-73,565

-87,641

-116,376

-187,033

-186,827

-145,976

-94,449

206

3,367

12,253

13,475

15,386

12,257

15,913

12,923

5,456

5,098

8,622

10,023

10,441

14,634

0

0

0

Effect of exchange rate changes on cash activities

-6,613

-789

-2,688

-2,673

-7,510

-6,211

-13,677

-6,113

4,402

6,022

6,383

-2,990

-18,525

-24,619

-19,247

-20,890

-4,393

-7,304

-8,308

-9,333

-12,811

-6,566

-1,276

10,548

8,742

3,442

2,128

-1,360

-3,015

3,516

1,911

1,203

1,090

-39

39

-1,806

196

-786

0

0

0

Decrease in cash and cash equivalents

-71,336

-19,154

-10,951

-70,296

-80,783

-75,080

-48,992

56,435

81,401

69,683

-69,585

-54,742

-9,176

42,161

145,661

109,056

49,235

82,631

82,005

40,052

-46,807

-85,651

-65,978

17,080

101,964

127,165

117,521

77,398

33,486

-41,385

7,849

-1,975

17,212

52,726

-2,402

24,215

50,857

48,058

0

0

0