Proto labs inc (PRLB)
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'11
Operating activities
Net income

13,984

15,186

16,792

16,166

15,511

19,286

20,937

18,314

18,051

14,272

13,220

12,086

12,200

9,372

11,982

10,691

10,662

11,993

12,382

11,686

10,453

10,193

10,384

10,956

10,102

9,507

8,872

8,611

8,287

7,395

6,702

5,146

4,782

3,230

5,488

4,531

4,723

Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization

7,958

8,206

7,677

7,542

7,439

7,234

6,771

6,490

6,259

4,935

4,839

4,450

4,250

4,654

4,684

4,358

3,789

3,704

3,482

3,541

3,399

3,442

3,013

2,577

2,106

2,041

1,946

1,848

1,734

1,700

1,612

1,440

1,328

1,255

1,127

989

893

Stock-based compensation expense

3,033

1,043

3,212

3,486

3,040

2,942

2,952

2,727

2,307

2,399

2,201

2,242

1,716

1,515

1,719

1,809

1,732

1,567

1,606

1,567

1,342

1,248

1,313

1,250

998

866

859

871

865

677

742

770

850

388

331

213

198

Deferred taxes

3,392

4,507

14

1,206

379

10,166

150

1,008

612

459

-893

1,214

394

2,285

92

314

89

3,147

-930

277

343

-2,362

380

0

107

528

-368

159

148

-

-

-

-

-

-

-

-

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,223

479

510

87

2,760

726

897

1,675

2,269

1,862

4,067

-

-

-

-

-

-

-

-

Amortization of held-to-maturity securities

-55

-10

12

9

-16

-38

-60

-113

-163

-212

-259

-291

-301

-292

-291

-301

-289

-298

-304

-327

-305

-323

-340

-372

-482

-461

-374

-329

-304

-

-

-

-

-

-

-

-

Other

644

-524

-146

515

-236

779

-153

99

-106

174

56

-133

56

160

286

1,095

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Provision for doubtful accounts

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

8

Changes in operating assets and liabilities:
Accounts receivable

5,084

-7,235

1,926

1,075

2,386

-2,895

6,345

-1,365

4,013

-746

3,765

2,137

4,777

-2,526

2,827

-1,178

-23

2,544

3,608

856

4,363

-998

560

2,188

3,554

228

210

103

1,929

595

1,509

-912

3,180

-966

1,340

759

2,324

Inventories

537

491

-159

347

-739

513

65

418

-807

797

363

260

-435

-339

16

125

62

980

454

420

243

557

33

140

166

199

20

177

183

316

324

89

100

943

877

215

160

Prepaid expenses and other

1,240

-707

186

-235

211

40

999

-648

1,707

-456

372

87

688

205

-39

-411

1,557

-549

2,127

-520

989

-813

334

-456

828

-85

170

-1,322

-393

1,631

283

2

-29

498

329

-142

-94

Income taxes

-841

-2,610

4,332

1,827

3,006

-8,930

2,145

-2,254

2,387

-2,512

2,389

-3,282

5,051

93

2,130

688

5,296

-1,764

3,141

-6,416

2,729

5,341

1,601

-1,520

3,951

2,746

3,033

347

2,719

1,964

1,690

-1,331

1,991

-487

530

-1,152

1,146

Accounts payable

1,739

-2,198

-2,369

4,653

-805

962

-3,428

2,117

2,291

1,789

-1,147

2,215

319

927

-675

-1,233

-135

2,037

367

2,601

776

21

-3,729

1,214

3,929

87

481

-32

1,115

618

51

-1,707

1,344

604

348

-117

710

Accrued liabilities and other

595

154

1,052

3,717

-8,962

4,706

3,314

3,832

-1,118

450

3,261

3,770

-353

-2,281

2,531

2,472

-1,872

-63

3,511

68

2,175

-2,167

4,372

-1,500

-964

-677

2,872

-3,069

1,759

245

1,737

-1,072

367

-426

2,168

817

708

Net cash provided by operating activities

22,410

32,273

28,891

36,886

18,002

37,967

25,645

33,172

26,145

22,748

19,573

20,635

18,792

19,357

19,664

20,224

18,254

22,812

13,451

12,416

15,417

17,206

13,987

10,751

15,266

13,541

15,452

8,303

11,145

6,241

7,932

4,091

7,411

4,200

8,898

4,441

5,996

Investing activities
Purchases of property, equipment and other capital assets

13,421

16,079

12,015

21,401

12,735

25,206

18,704

17,681

25,513

8,471

10,863

5,489

7,812

2,635

8,565

14,141

8,275

17,103

11,542

9,487

6,230

7,579

4,303

21,733

9,892

5,777

6,907

3,521

2,548

2,962

1,771

4,400

8,264

8,920

3,733

4,088

2,262

Cash used for acquisitions, net of cash acquired

-

-

-

-

-

0

0

0

90

110,533

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of other assets and investments

3,000

0

0

0

4,000

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of marketable securities

37,629

28,960

8,460

8,983

0

0

24,255

13,740

3,389

0

0

3,517

16,520

33,102

17,909

19,510

18,794

23,719

17,285

13,814

11,575

12,848

8,875

6,078

32,385

23,641

25,347

16,222

41,088

-

-

-

-

-

-

-

-

Proceeds from maturities of marketable securities

10,700

13,978

25,182

12,164

17,006

20,418

15,665

15,505

13,551

13,882

8,896

14,439

10,755

16,269

17,148

18,294

10,465

11,294

16,790

12,463

11,646

12,162

6,455

28,851

26,590

15,907

16,383

15,967

18,313

12,078

10,040

0

250

0

0

250

250

Net cash (used in) provided by investing activities

-43,350

-31,061

4,707

-18,220

271

-4,788

-27,420

-15,632

-15,441

-113,350

-1,967

4,919

-13,577

-19,468

-9,326

-15,357

-16,604

-34,560

-12,037

-10,838

-6,159

-8,265

-6,723

-32,824

-15,687

-13,511

-15,871

-3,776

-25,323

-13,904

-18,933

-38,766

-8,014

-8,920

-3,733

-3,838

-2,012

Financing activities
Proceeds from initial public offering, net of offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-145

71,675

-

-

-

-

Payments on debt

-

-

-

-

-

0

0

0

5,000

0

0

0

0

-

-

-

-

45

30

28

49

49

51

904

50

47

45

74

92

99

98

97

94

94

70

2,601

1,284

Proceeds from issuance of debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

637

Proceeds from exercises of stock options

135

1,905

243

2,069

174

1,666

2,573

1,816

2,880

2,853

1,958

3,597

194

1,547

439

2,115

1,614

1,086

2,958

1,329

878

858

2,156

1,141

665

1,861

1,765

1,251

1,619

2,247

691

7

30

0

0

325

222

Purchases of shares withheld for tax obligations

1,048

67

2

1,824

594

123

631

762

628

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisition-related contingent consideration

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

400

0

400

0

1,000

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repurchases of common stock

11,185

0

12,111

4,101

17,309

-

-

-

-

0

0

1,748

2,662

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,223

479

510

87

2,760

726

897

1,675

2,269

1,862

4,067

-

-

-

-

-

-

-

-

Net cash used in financing activities

-12,098

1,838

-11,870

-3,856

-17,729

-10,686

1,942

1,054

-2,748

7,853

1,958

1,849

-2,468

1,547

439

2,115

1,214

-4,171

6,751

1,780

339

496

4,465

563

1,512

3,489

3,989

3,039

5,594

8,182

3,228

-235

71,611

563

-707

-2,276

-425

Effect of exchange rate changes on cash and cash equivalents

-282

607

-695

375

-240

-40

-179

-1,084

432

173

523

-95

346

-859

110

-277

109

-559

-358

413

-373

-376

-315

163

71

138

366

-49

-246

-50

-323

-383

536

-61

-106

-13

27

Net (decrease) increase in cash and cash equivalents

-33,320

3,657

21,033

15,185

304

22,453

-12

17,510

8,388

-82,576

20,087

27,308

3,093

577

10,887

6,705

2,973

-16,478

7,807

3,771

9,224

9,061

11,414

-21,347

1,162

3,657

3,936

7,517

-8,830

469

-8,096

-35,293

71,544

-4,218

4,352

-1,686

3,586