Tyler technologies, inc. (TYL)
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
Cash flows from operating activities:
Cash flows from operating activities:
Net income

47,550

46,790

40,390

31,999

27,348

31,552

38,924

39,161

37,825

66,196

38,836

31,770

32,769

35,040

35,430

25,007

18,224

8,618

20,142

18,836

17,273

15,317

17,000

14,740

11,883

10,512

11,049

9,047

8,493

9,376

10,832

7,105

5,681

8,699

7,506

5,624

5,728

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

19,985

20,125

19,803

19,436

17,308

16,132

15,978

15,537

14,112

13,695

13,598

13,135

12,967

12,252

12,671

12,674

12,176

7,988

4,102

3,771

3,713

3,669

3,655

3,625

3,656

3,693

3,412

3,359

3,322

3,095

3,280

3,310

3,026

2,898

2,559

2,634

2,585

Share-based compensation expense

17,302

15,598

14,887

15,066

14,416

14,774

14,476

12,933

10,557

9,980

9,791

8,901

8,676

8,399

7,656

7,212

6,480

5,723

5,598

4,603

4,258

3,932

3,885

3,540

3,462

3,114

3,061

2,903

2,575

1,905

1,903

1,768

1,835

1,668

1,616

1,520

1,449

Operating lease right-of-use assets expense

1,457

-

-

-

1,165

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit from exercises of share-based arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,974

5,269

3,558

-

3,511

1,048

2,158

15,007

7,539

4,138

1,523

5,481

1,702

895

686

1,869

29

1,420

272

Deferred income tax benefit

-2,668

4,241

-2,889

-2,655

-4,785

-35

162

-2,538

-2,658

-19,959

-4,858

-4,977

-3,870

-15,143

-11,716

335

92

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities, exclusive of effects of    acquired companies:
Accounts receivable

-56,982

30,194

-33,514

78,680

-9,622

19,523

-17,477

79,097

-30,227

26,419

-25,662

69,876

-37,542

20,119

-20,889

71,280

-35,750

13,816

-22,268

44,944

-8,320

3,061

-32,352

62,501

-24,298

16,286

-30,456

44,216

-22,558

21,256

-22,137

39,743

-32,037

14,967

-14,449

23,240

-15,214

Income tax receivable

-10,175

-2,628

-253

-7,619

12,425

-4,700

-180

-5,815

4,053

8,911

8,844

-16,887

7,576

-19,954

5,269

-12,687

9,187

-29,009

2,019

-5,659

8,394

-45,299

8,436

51

7,695

-10,045

-6,475

3,260

-5,638

-10,324

2,723

-2,457

2,267

-9,309

1,673

-2,040

3,592

Prepaid expenses and other current assets

11,186

1,346

-1,842

5,610

3,862

1,571

-1,798

2,148

-1,333

3,295

-1,134

3,878

919

923

-2,604

3,509

-2,074

3,128

-623

1,312

-763

2,126

-499

522

1,547

1,404

154

1,392

1,204

-412

40

-79

341

-441

-159

471

343

Accounts payable

-2,020

5,855

998

2,051

-1,501

2,313

-130

-2,847

-1,752

3,611

-4,885

3,318

-1,166

1,304

-681

237

-473

1,021

2

-43

-328

722

813

12

39

-1,415

170

1,250

-579

867

401

-1,008

-629

-535

1,405

-115

-180

Operating lease liabilities

-1,743

-

-

-

-1,272

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accrued liabilities

-12,210

2,895

-1,395

3,776

-3,760

-3,968

13,708

5,767

-17,952

4,734

12,377

4,878

-15,939

2,202

3,632

16,621

-11,738

3,839

2,336

10,738

-16,423

8,141

2,422

9,091

-13,328

9,677

-421

5,430

-7,031

1,733

-111

7,227

-9,379

4,909

-1,219

705

492

Deferred revenue

-46,568

17,236

23,727

46,626

-43,147

23,161

9,910

41,646

-31,114

10,777

-7,693

35,012

-29,457

7,893

3,459

44,910

-30,451

30,710

-659

36,187

-24,507

3,369

752

45,280

-17,440

5,228

-4,394

30,519

-15,165

19,759

-5,594

14,955

-15,727

9,338

-2,341

18,663

-10,798

Net cash provided by operating activities

56,706

76,193

130,073

24,497

23,957

70,850

112,123

22,599

44,631

53,374

92,806

1,396

48,179

51,805

79,213

19,520

41,321

64,414

55,100

16,908

-2,095

47,708

66,303

12,268

16,560

7,389

42,115

-498

17,084

16,414

33,829

-9,659

18,084

11,330

25,778

1,860

17,467

Cash flows from investing activities:
Additions to property and equipment

9,349

8,403

4,781

11,732

12,320

3,964

8,508

6,057

8,895

5,323

7,611

10,303

19,820

8,197

7,570

5,237

16,722

3,976

2,399

4,217

1,909

1,306

1,560

2,847

3,630

6,596

6,423

8,750

5,089

2,751

2,017

3,286

1,048

2,352

1,510

612

7,804

Purchase of cost method investment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

15,000

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of marketable security investments

27,271

27,420

17,205

6,527

3,590

22,987

17,788

30,888

43,962

9,874

28,513

14,264

7,128

7,189

2,520

4,197

6,410

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from marketable security investments

18,237

13,942

17,166

19,412

20,276

20,997

21,054

28,077

11,077

7,611

4,146

10,133

6,896

7,581

2,730

3,501

3,025

-

-

-

-

-

-

-

-

1,040

25

0

25

0

50

0

25

0

25

0

25

Purchase of investment in common shares

10,000

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from the sale of investment in preferred shares

15,000

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Investment in software

1,315

1,264

1,308

1,542

690

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cost of acquisitions, net of cash acquired

261

18,864

650

90

199,130

10,785

10,156

157,152

0

-

-

-

-

0

0

7,394

2,000

333,514

0

6,122

325

-

-

-

-

-

-

-

-

10,451

54

9,301

5,874

17,298

0

0

0

(Increase) decrease in other

48

-198

925

132

-564

-825

-1,043

929

-743

419

-486

52

16

69

-229

232

49

-

-

-

-

-3

124

-35

-308

-20

24

-56

-239

-

-

-

-

-518

15

0

-214

Net cash used by investing activities

-15,007

-41,811

-7,703

-611

-194,890

-15,914

-14,355

-166,949

-41,037

-9,588

-35,398

-20,341

-20,068

-7,874

-7,131

-13,559

-22,156

-339,101

-25,327

-16,797

-17,234

-1,303

-4,118

-2,812

-3,322

-5,536

-6,422

-8,875

-4,825

-13,272

-1,919

-12,648

-6,897

-19,132

-1,500

-612

-7,565

Cash flows from financing activities:
Increase in net borrowings on revolving line of credit

0

-

-

-70,000

85,000

-

-

0

0

20,000

0

0

-10,000

-24,000

-101,000

-5,000

74,000

-

-

-

-

-

-

-

-

0

0

0

-18,000

-75,400

37,700

-9,700

4,700

65,700

-26,500

-9,000

4,000

Purchase of treasury shares

15,482

0

0

0

17,786

146,553

0

0

0

442

0

0

7,032

17,339

2

567

93,930

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,277

47,641

14,045

6,839

Payment of contingent consideration

5,619

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from exercise of stock options

46,236

34,613

40,163

15,604

6,528

4,371

26,219

25,019

19,298

16,277

10,208

8,509

14,851

8,438

9,296

4,012

1,781

14,791

1,640

3,304

3,425

7,941

2,622

2,093

2,024

8,888

4,920

2,844

1,637

6,871

3,213

1,435

924

1,983

154

1,073

343

Contributions from employee stock purchase plan

2,469

2,249

2,718

2,260

2,349

2,073

2,218

1,962

1,798

1,702

1,915

1,777

1,650

1,807

1,611

1,580

1,238

1,304

1,124

1,343

900

1,107

1,023

1,165

849

1,007

901

964

670

809

666

657

509

573

548

468

456

Excess tax benefit from exercises of share-based arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,974

5,269

3,558

-

3,511

1,048

2,158

15,007

7,539

4,138

1,523

5,481

1,702

895

686

1,869

29

1,420

272

Net cash provided by financing activities

27,604

36,862

27,881

-52,136

76,091

-140,109

28,437

26,981

21,096

17,537

12,123

10,286

-531

-31,094

-90,095

25

-16,911

69,160

4,738

9,271

7,883

2,331

7,154

-18,509

5,031

24,902

13,360

7,946

-14,170

3,161

-32,119

12,687

-2,581

3,848

-20,410

-2,084

-9,768

Net increase (decrease) in cash and cash equivalents

69,303

71,244

150,251

-28,250

-94,842

-85,173

126,205

-117,369

24,690

61,323

69,531

-8,659

27,580

12,837

-18,013

5,986

2,254

-205,527

34,511

9,382

-11,446

48,736

69,339

-9,053

18,269

26,755

49,053

-1,427

-1,911

6,303

-209

-9,620

8,606

-3,954

3,868

-836

134