Willdan group, inc. (WLDN)
CashFlow / TTM
Apr'20Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Sep'18Jun'18Jun'18Mar'18Mar'18Dec'17Dec'17Sep'17Jun'17Mar'17Dec'16Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15Dec'14Sep'14Jun'14Mar'14Dec'13Sep'13Jun'13Mar'13Dec'12Sep'12Jun'12Mar'12Dec'11Sep'11Jun'11Mar'11
Cash flows from operating activities:
Net loss

-2,896

4,841

2,840

5,735

7,410

10,030

-

12,119

-

11,694

11,691

11,691

-

12,129

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net income

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,842

-

5,926

9,305

9,596

9,416

8,070

4,751

3,546

2,630

2,229

2,174

-15,490

-17,300

-18,379

-17,001

710

1,830

0

0

0

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

17,252

15,472

14,444

9,680

7,849

6,211

-

4,497

-

4,455

4,264

4,264

-

4,082

3,882

3,524

3,529

-

3,220

3,110

2,717

2,253

2,072

1,407

1,176

786

460

462

480

522

585

620

660

712

737

780

812

861

944

0

0

0

Deferred income taxes, net

-2,414

-209

-1,715

-2,265

-2,695

-2,890

-

-2,623

-

-916

467

467

-

621

453

1,114

984

-

1,225

1,834

1,674

1,551

1,758

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Lease abandonment recovery, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-30

-12

-9

-35

-26

0

0

0

-

-

-

-

Lease abandonment expense (recovery), net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

(Gain) loss on sale/disposal of equipment

-1

8

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

37

-22

-12

-4

-11

6

-2

-1

6

0

0

0

-

-

-

-

-2

0

0

0

Provision for doubtful accounts

1,390

1,051

409

328

401

470

-

226

-

175

-101

-101

-

-189

26

135

193

-

216

320

280

464

659

540

759

658

510

283

130

114

101

99

403

680

673

0

0

0

-

-

-

-

Provision for doubtful accounts

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Stock-based compensation

14,890

12,112

9,979

7,577

7,015

6,262

-

5,213

-

4,404

3,362

3,362

-

2,774

2,499

1,871

1,508

-

1,239

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

0

0

0

Stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

206

155

141

150

0

0

0

-

-

-

-

-

-

-

-

Accretion and fair value adjustments of contingent consideration

-79

-302

-1,253

-2,675

-1,653

-1,426

-

-336

-

1,497

1,327

1,327

-

1,156

939

192

216

-

21

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities, net of effects from business acquisitions:
Accounts receivable

10,867

-11,627

2,824

-2,881

-3,473

-3,177

-

-17,141

-

-6,718

-11,298

-11,298

-

7,412

8,921

-1,295

-2,584

-

-1,288

-2,115

-3,401

3,561

4,354

519

6,885

5,882

532

3,990

1,311

-1,169

-2,216

-3,587

-10,405

-1,796

-625

195

11,153

1,062

2,507

0

0

0

Contract assets

-7,965

34,598

13,508

2,777

508

11,539

-

15,796

-

11,904

12,349

12,349

-

5,744

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Costs and estimated earnings in excess of billings on uncompleted contracts

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,057

-

3,491

7,423

541

1,180

3,769

3,416

4,312

2,535

4,481

2,782

-411

-225

-1,589

-365

-12,825

-10,812

-6,166

-5,979

11,089

8,427

0

0

0

Other receivables

2,271

2,714

441

-1,306

-3,537

-4,081

-

-1,463

-

-781

1,749

1,749

-

1,126

-929

833

-573

-

-82

1,950

-210

-15

-31

-743

-126

-138

-4

826

381

249

117

-66

-18

24

-80

-114

-87

-33

-1

0

0

0

Prepaid expenses and other current assets

557

343

-828

-338

-269

154

-

851

-

166

42

42

-

1,096

351

846

842

-

519

715

825

-13

-203

286

195

390

-133

-195

17

644

595

498

-271

-439

58

67

73

157

10

0

0

0

Other assets

5,598

6,520

1,036

1,299

995

778

-

97

-

98

98

98

-

-25

181

252

154

-

169

-12

-66

-413

-31

-94

-188

259

202

240

348

348

26

-39

-51

-150

-76

-42

-37

53

-24

0

0

0

Accounts payable

3,771

-6,294

-5,459

-1,283

3,496

-1,583

-

-4,182

-

-8,901

-4,495

-4,495

-

3,186

3,854

7,084

3,317

-

206

905

-3,653

-317

1,842

1,736

1,941

1,184

-720

766

1,645

-855

-3,026

-1,514

-7,568

-6,065

-1,199

-1,980

7,022

5,866

2,802

0

0

0

Changes in excess of outstanding checks over bank balance

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-327

-511

-1,279

-589

507

-183

1,061

554

0

0

0

Accrued liabilities

-5,441

16,761

891

-631

-1,152

-1,945

-

5,997

-

1,804

-5,640

-5,640

-

4,329

-177

5,064

12,650

-

8,409

5,783

5,055

-826

-1,320

89

3,744

1,986

4,860

2,796

2,031

1,564

502

-1,610

-3,037

-3,061

-4,886

-2,103

-344

2,596

4,206

0

0

0

Contract liabilities

2,313

315

753

-1,049

-1,805

-2,272

-

-2,101

-

-1,472

-2,200

-2,200

-

-1,593

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Billings in excess of costs and estimated earnings on uncompleted contracts

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,159

-

2,464

3,536

3,632

2,285

1,723

3,351

2,447

1,616

1,816

-889

-833

-1,172

-993

1,744

2,125

2,667

2,451

502

-659

-289

0

0

0

Deferred lease obligations

-

-

-

-

-

-

-

-51

-

-50

-32

-32

-100

-

-78

-66

-61

-

-23

450

498

542

573

235

196

145

35

-138

-210

-260

-284

-292

-250

-217

-186

-202

-244

-241

-234

0

0

0

Right-of-use assets

-130

-430

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by operating activities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

8,783

-

11,837

10,321

4,867

11,896

2,830

3,589

5,229

1,213

4,242

5,795

6,211

4,682

859

-1,348

-2,177

-683

0

0

0

Net cash provided by operating activities

17,589

11,621

4,288

16,019

24,782

7,568

-

20,603

-

8,034

5,730

5,730

-

11,069

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash flows from investing activities:
Purchase of equipment and leasehold improvements

6,864

6,637

7,021

5,213

3,890

2,105

-

1,072

-

1,279

1,739

1,739

-

2,178

2,102

2,083

1,988

-

1,662

2,183

2,135

2,521

2,475

1,991

1,491

670

492

237

550

274

306

332

225

351

359

361

352

267

395

0

0

0

Proceeds from sale of equipment

27

45

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

27

0

0

0

-

-

-

-

6

0

0

0

Cash paid for acquisitions, net of cash acquired

-

71,756

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

8,857

8,857

8,857

9,982

8,168

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-56,793

-78,348

-174,847

-148,296

-149,940

-126,390

-

-4,025

-

-18,840

-16,342

-16,342

-

-16,781

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash flows from financing activities:
Net cash used in investing activities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-12,496

-

-10,159

-9,654

-7,708

-487

-221

-534

-252

-279

-310

-202

-326

-339

-347

-3,072

-2,995

-3,122

0

0

0

Payments on contingent consideration

1,610

1,381

1,909

2,478

2,879

4,296

-

3,818

-

3,399

2,823

2,823

-

1,709

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments on notes payable

1,521

1,842

1,465

1,023

566

477

-

1,277

-

2,245

3,275

3,275

-

4,164

4,565

4,581

4,711

-

4,378

3,545

3,058

2,538

2,090

1,273

891

455

162

534

564

573

621

685

633

652

663

745

657

433

211

0

0

0

Proceeds from notes payable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,606

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

667

0

0

0

Borrowings under term loan facility and line of credit

133,000

138,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

11,663

22,946

31,961

32,197

33,965

0

0

0

Repayments under term loan facility and line of credit

89,500

78,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

8,919

22,866

28,961

30,405

34,709

0

0

0

Principal payments on finance leases

647

639

384

460

365

367

-

0

-

0

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Principal payments on capital lease obligations

-

-

-

-

-

-

388

-

375

-

359

-

390

-

434

399

515

-

522

543

588

423

350

272

551

275

261

219

-187

67

62

88

142

152

164

176

189

202

202

0

0

0

Proceeds from stock option exercise

900

931

1,050

850

680

668

-

626

-

567

880

880

-

1,901

1,914

1,953

1,580

-

327

307

214

448

512

539

713

516

450

0

0

0

-

-

-

-

-

-

-

0

-

-

-

-

Proceeds from sales of common stock under employee stock purchase plan

2,064

1,740

1,741

1,433

1,433

1,300

-

1,299

-

1,102

1,102

1,102

-

830

830

440

440

-

209

301

205

205

170

78

126

126

76

76

64

64

73

73

82

92

120

120

126

116

93

0

0

0

Shares used to pay taxes on stock grants

3,231

2,880

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Restricted Stock Award and Units

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash (used in) provided by financing activities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-1,652

-

1,072

1,397

1,862

103

126

290

-3,012

-3,091

-2,808

-2,620

-487

2,662

443

2,748

2,995

164

0

0

0

Net increase (decrease) in cash and cash equivalents

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-5,365

-

2,750

2,064

-979

11,512

2,735

3,345

1,965

-2,157

1,124

2,973

5,398

7,005

955

-1,672

-2,177

-3,641

0

0

0

Net cash (used in) provided by financing activities

40,447

56,920

153,878

148,654

130,866

119,657

-

-5,500

-

-4,292

-3,475

-3,475

-

-2,532

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net increase (decrease) in cash and cash equivalents

1,243

-9,807

-16,681

16,377

5,708

835

-

0

-

0

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net decrease in cash and cash equivalents

-

-

-

-

-

-

-

-

-

-

-14,087

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Supplemental disclosures of cash flow information:
Cash paid during the period for:
Interest

4,939

4,169

3,733

2,597

1,436

494

-

98

-

99

101

101

-

111

130

150

163

-

179

184

193

204

203

161

113

60

16

25

26

77

100

113

136

112

106

105

91

75

77

0

0

0

Income taxes

0

-

-

-

-

3,163

-

2,669

-

1,337

2,537

2,537

-

2,750

1,971

2,369

1,438

-

1,875

2,044

1,716

1,273

949

1,024

381

481

134

221

289

290

324

244

249

171

139

0

0

0

-

-

-

-

Supplemental disclosures of noncash investing and financing activities:
Other working capital adjustment

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Issuance of notes payable related to business acquisitions

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,569

4,569

4,569

4,569

4,250

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Issuance of common stock related to business acquisitions

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,228

2,228

2,230

2,230

1,485

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Contingent consideration related to business acquisitions

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,178

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Equipment acquired under finance leases

0

-

-

688

561

462

-

312

-

334

424

424

-

294

450

447

-479

-

373

0

0

0

-

-

-

-

677

0

0

0

-

-

-

-

151

181

154

154

247

0

0

0