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

62,128

63,655

67,755

71,900

74,048

76,588

71,574

63,857

57,629

51,778

46,878

45,640

44,245

42,707

45,328

45,728

46,723

46,514

44,714

42,716

41,986

41,635

40,949

39,437

37,092

35,277

33,165

30,995

27,530

24,025

19,860

18,646

18,031

17,972

0

0

0

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

31,383

30,864

29,892

28,986

27,934

26,754

24,455

22,523

20,483

18,474

18,193

18,038

17,946

17,485

16,535

15,333

14,516

14,126

13,864

13,395

12,431

11,138

9,737

8,670

7,941

7,569

7,228

6,894

6,486

6,080

5,635

5,150

4,699

4,264

0

0

0

Stock-based compensation expense

10,774

10,781

12,680

12,420

11,661

10,928

10,385

9,634

9,149

8,558

7,674

7,192

6,759

6,775

6,827

6,714

6,472

6,082

5,763

5,470

5,153

4,809

4,427

3,973

3,594

3,461

3,272

3,155

3,054

3,039

2,750

2,339

1,782

1,130

0

0

0

Deferred taxes

9,119

6,106

11,765

11,901

11,703

11,936

2,229

1,186

1,392

1,174

3,000

3,985

3,085

2,780

3,642

2,620

2,583

2,837

-2,672

-1,362

-1,639

-1,875

1,015

267

426

467

0

0

0

-

-

-

-

-

-

-

-

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,299

3,836

4,083

4,470

6,058

5,567

6,703

9,873

0

0

0

-

-

-

-

-

-

-

-

Amortization of held-to-maturity securities

-44

-5

-33

-105

-227

-374

-548

-747

-925

-1,063

-1,143

-1,175

-1,185

-1,173

-1,179

-1,192

-1,218

-1,234

-1,259

-1,295

-1,340

-1,517

-1,655

-1,689

-1,646

-1,468

0

0

0

-

-

-

-

-

-

-

-

Other

489

-391

912

905

489

619

14

223

-9

153

139

369

1,597

1,541

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Provision for doubtful accounts

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Changes in operating assets and liabilities:
Accounts receivable

850

-1,848

2,492

6,911

4,471

6,098

8,247

5,667

9,169

9,933

8,153

7,215

3,900

-900

4,170

4,951

6,985

11,371

7,829

4,781

6,113

5,304

6,530

6,180

4,095

2,470

2,837

4,136

3,121

4,372

2,811

2,642

4,313

3,457

0

0

0

Inventories

1,216

-60

-38

186

257

189

473

771

613

985

-151

-498

-633

-136

1,183

1,621

1,916

2,097

1,674

1,253

973

896

538

525

562

579

696

1,000

912

829

1,456

2,009

2,135

2,195

0

0

0

Prepaid expenses and other

484

-545

202

1,015

602

2,098

1,602

975

1,710

691

1,352

941

443

1,312

558

2,724

2,615

2,047

1,783

-10

54

-107

621

457

-409

-1,630

86

199

1,523

1,887

754

800

656

591

0

0

0

Income taxes

2,708

6,555

235

-1,952

-6,033

-6,652

-234

10

-1,018

1,646

4,251

3,992

7,962

8,207

6,350

7,361

257

-2,310

4,795

3,255

8,151

9,373

6,778

8,210

10,077

8,845

8,063

6,720

5,042

4,314

1,863

703

882

37

0

0

0

Accounts payable

1,825

-719

2,441

1,382

-1,154

1,942

2,769

5,050

5,148

3,176

2,314

2,786

-662

-1,116

-6

1,036

4,870

5,781

3,765

-331

-1,718

1,435

1,501

5,711

4,465

1,651

2,182

1,752

77

306

292

589

2,179

1,545

0

0

0

Accrued liabilities and other

5,518

-4,039

513

2,775

2,890

10,734

6,478

6,425

6,363

7,128

4,397

3,667

2,369

850

3,068

4,048

1,644

5,691

3,587

4,448

2,880

-259

1,231

-269

-1,838

885

1,807

672

2,669

1,277

606

1,037

2,926

3,267

0

0

0

Net cash provided by operating activities

120,460

116,052

121,746

118,500

114,786

122,929

107,710

101,638

89,101

81,748

78,357

78,448

78,037

77,499

80,954

74,741

66,933

64,096

58,490

59,026

57,361

57,210

53,545

55,010

52,562

48,441

41,141

33,621

29,409

25,675

23,634

24,600

24,950

23,535

0

0

0

Investing activities
Purchases of property, equipment and other capital assets

62,916

62,230

71,357

78,046

74,326

87,104

70,369

62,528

50,336

32,635

26,799

24,501

33,153

33,616

48,084

51,061

46,407

44,362

34,838

27,599

39,845

43,507

41,705

44,309

26,097

18,753

15,938

10,802

11,681

17,397

23,355

25,317

25,005

19,003

0

0

0

Cash used for acquisitions, net of cash acquired

-

-

-

-

-

90

110,623

110,623

110,623

110,533

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of other assets and investments

3,000

4,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of marketable securities

84,032

46,403

17,443

33,238

37,995

41,384

41,384

17,129

6,906

20,037

53,139

71,048

87,041

89,315

79,932

79,308

73,612

66,393

55,522

47,112

39,376

60,186

70,979

87,451

97,595

106,298

0

0

0

-

-

-

-

-

-

-

-

Proceeds from maturities of marketable securities

62,024

68,330

74,770

65,253

68,594

65,139

58,603

51,834

50,768

47,972

50,359

58,611

62,466

62,176

57,201

56,843

51,012

52,193

53,061

42,726

59,114

74,058

77,803

87,731

74,847

66,570

62,741

56,398

40,431

22,368

10,290

250

500

500

0

0

0

Net cash (used in) provided by investing activities

-87,924

-44,303

-18,030

-50,157

-47,569

-63,281

-171,843

-146,390

-125,839

-123,975

-30,093

-37,452

-57,728

-60,755

-75,847

-78,558

-74,039

-63,594

-37,299

-31,985

-53,971

-63,499

-68,745

-77,893

-48,845

-58,481

-58,874

-61,936

-96,926

-79,617

-74,633

-59,433

-24,505

-18,503

0

0

0

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

71,530

0

0

0

-

-

-

-

Payments on debt

-

-

-

-

-

5,000

5,000

5,000

5,000

0

0

0

0

-

-

-

-

152

156

177

1,053

1,054

1,052

1,046

216

258

310

363

386

388

383

355

2,859

4,049

0

0

0

Proceeds from issuance of debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

Proceeds from exercises of stock options

4,352

4,391

4,152

6,482

6,229

8,935

10,122

9,507

11,288

8,602

7,296

5,777

4,295

5,715

5,254

7,773

6,987

6,251

6,023

5,221

5,033

4,820

5,823

5,432

5,542

6,496

6,882

5,808

4,564

2,975

728

37

355

547

0

0

0

Purchases of shares withheld for tax obligations

2,941

2,487

2,543

3,172

2,110

2,144

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisition-related contingent consideration

-

-

-

-

-

-

-

-

-

-

-

-

-

400

400

800

800

1,400

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repurchases of common stock

27,397

33,521

0

0

0

-

-

-

-

4,410

0

0

2,662

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,299

3,836

4,083

4,470

6,058

5,567

6,703

9,873

0

0

0

-

-

-

-

-

-

-

-

Net cash used in financing activities

-25,986

-31,617

-44,141

-30,329

-25,419

-10,438

8,101

8,117

8,912

9,192

2,886

1,367

1,633

5,315

-403

5,909

5,574

4,699

9,366

7,080

5,863

7,036

10,029

9,553

12,029

16,111

20,804

20,043

16,769

82,786

75,167

71,232

69,191

-2,845

0

0

0

Effect of exchange rate changes on cash and cash equivalents

5

47

-600

-84

-1,543

-871

-658

44

1,033

947

-85

-498

-680

-917

-617

-1,085

-395

-877

-694

-651

-901

-457

57

738

526

209

21

-668

-1,002

-220

-231

-14

356

-153

0

0

0

Net (decrease) increase in cash and cash equivalents

6,555

40,179

58,975

37,930

40,255

48,339

-56,690

-36,591

-26,793

-32,088

51,065

41,865

21,262

21,142

4,087

1,007

-1,927

4,324

29,863

33,470

8,352

290

-5,114

-12,592

16,272

6,280

3,092

-8,940

-51,750

28,624

23,937

36,385

69,992

2,034

0

0

0