Costar group, inc. (CSGP)
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

302,587

314,963

310,545

290,685

271,272

238,334

199,029

174,447

152,796

122,695

108,064

97,088

90,480

85,071

78,488

49,925

19,383

-3,465

-12,532

5,787

29,002

44,869

43,745

41,840

41,884

29,734

21,649

17,376

2,373

9,915

10,377

5,909

15,256

14,656

0

0

0

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

85,762

81,165

76,978

78,589

80,419

77,743

73,366

68,052

63,328

63,643

65,401

68,362

69,942

70,165

117,128

104,309

91,865

78,532

73,728

72,395

71,020

70,372

14,410

13,739

13,126

12,495

12,024

11,498

10,818

10,053

9,248

8,466

8,270

8,435

0

0

0

Amortization of deferred commissions costs

55,761

53,421

51,260

49,588

48,714

48,313

36,242

24,275

12,006

0

0

0

0

-

-

-

-

-

0

0

0

-

46,144

36,625

26,617

27,563

28,766

29,965

28,780

22,699

16,160

9,250

4,470

4,417

0

0

0

Amortization of debt issuance costs

949

876

876

878

876

876

803

1,252

1,750

2,303

2,977

3,104

3,188

3,227

3,232

3,265

3,295

3,311

3,339

3,413

3,429

3,312

3,200

3,056

2,977

3,014

3,027

3,030

2,736

1,989

0

0

0

-

-

-

-

Impairment loss

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,778

2,778

3,524

2,148

1,799

1,799

1,053

1,053

0

0

0

0

-

-

-

-

-

-

-

-

Realized loss on investments

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash lease expense

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

8,209

9,139

7,072

28,406

32,347

36,654

35,709

19,585

15,660

9,948

7,038

198

1,051

1,294

2,411

2,541

0

0

0

Stock-based compensation expense

55,406

52,255

49,605

45,419

42,831

41,214

40,420

41,210

40,085

39,030

38,571

38,139

37,375

36,349

36,349

36,350

35,426

34,537

32,530

29,865

27,830

28,267

30,185

31,326

32,102

41,549

35,885

31,836

27,421

12,282

10,660

8,766

8,226

8,103

0

0

0

Deferred income taxes, net

7,343

8,220

9,310

5,734

5,517

3,666

-1,346

-2,046

-3,143

-2,903

16,168

15,595

16,020

15,635

13,464

13,466

-7,972

-5,792

-13,832

-19,583

-2,570

-1,366

-7,528

-4,188

7

-12,740

-4,633

-1,006

5,807

13,643

11,332

5,884

-17,390

-17,104

0

0

0

Credit loss expense

14,976

10,978

9,481

8,909

7,296

6,542

6,217

6,198

5,321

5,690

4,888

4,599

6,940

7,358

7,974

8,560

7,662

7,002

6,514

6,336

5,394

4,822

4,296

3,310

2,982

2,317

1,857

1,524

1,419

1,456

1,903

1,635

1,346

1,525

0

0

0

Changes in operating assets and liabilities:
Accounts receivable

25,792

5,014

17,578

33,628

31,143

27,819

20,753

17,436

17,275

17,524

18,045

10,353

9,509

16,044

4,528

217

4,654

3,999

14,057

16,645

8,494

12,353

9,877

7,480

10,726

6,607

3,398

6,861

6,998

-1,295

1,321

4,818

1,011

4,573

0

0

0

Income taxes payable

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses and other current assets

12,612

14,244

-547

-17,755

-8,077

1,651

3,063

13,440

12,835

3,672

3,320

6,428

2,058

1,157

1,294

1,526

-1,475

-367

277

363

1,903

2,846

-1,161

1,262

-1,750

-2,934

2,001

696

3,779

3,316

221

732

476

-1,046

0

0

0

Deferred commissions

-69,482

-66,688

-60,867

-57,340

-50,963

-53,497

-41,421

-29,554

-16,263

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other assets

626

-648

17,934

12,751

3,565

212

2,030

-1,302

-3,256

39

-3,102

173

402

758

748

1,059

1,008

686

322

85

-279

-157

111

67

116

399

106

135

1,635

1,172

620

705

-642

-154

0

0

0

Accounts payable and other liabilities

18,247

17,751

-5,028

6,624

-3,352

-14,132

-13,806

-5,699

4,225

11,525

-2,496

-5,871

1,656

-1,520

-7,283

-10,918

5,119

9,938

11,451

20,812

25,300

6,078

3,417

-3,672

-13,460

-3,882

14,820

6,995

10,299

1,629

2,287

5,051

84

2,228

0

0

0

Lease liabilities

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred revenue

17,451

7,911

13,950

15,966

11,315

7,879

6,489

4,827

8,519

6,004

7,653

6,173

3,677

2,070

-1,230

2,928

3,446

3,817

5,370

1,555

3,968

3,972

3,391

2,906

-1,083

1,708

2,234

5,547

9,260

5,787

8,698

5,844

3,345

4,334

0

0

0

Net cash provided by operating activities

440,750

457,780

464,791

449,708

410,967

335,458

292,080

258,657

243,131

234,703

215,489

209,311

216,843

200,642

218,517

199,511

157,960

139,773

117,589

127,531

180,633

143,909

131,506

110,065

91,035

108,298

102,396

97,115

90,453

86,126

64,636

43,079

26,480

27,785

0

0

0

Investing activities:
Proceeds from sale and settlement of investments

0

-

-

-

0

-

-

-

-

-

-

-

-

5,950

4,700

5,250

5,950

1,900

6,425

6,475

6,325

5,675

1,139

548

-7

76

832

4,975

14,203

15,365

18,716

15,146

6,123

4,911

0

0

0

Proceeds from sale of building, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

83,553

0

0

0

Purchases of property and equipment and other assets

43,901

46,197

51,993

28,168

30,444

29,632

26,546

27,676

26,970

24,499

26,828

24,046

21,118

18,766

18,800

24,525

27,111

35,061

34,532

33,937

35,039

27,444

24,576

21,567

18,548

19,042

21,163

17,629

16,465

14,834

11,843

11,243

12,253

15,013

0

0

0

Cash paid for acquisitions, net of cash acquired

437,988

437,556

92,016

92,016

78,295

418,369

340,075

342,774

374,169

47,768

47,767

44,716

23,626

10,443

15,308

20,469

182,831

182,341

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) investing activities

-471,630

-483,753

-144,009

-120,184

-108,739

-448,001

-366,621

-370,450

-401,139

-72,267

-73,345

-67,512

-43,494

-23,259

-29,408

-39,744

-203,992

-215,502

-205,583

-200,129

-612,932

-605,987

-607,655

-605,237

-18,555

-18,966

-20,331

-12,654

-643,191

-640,398

-649,141

-652,111

-21,215

58,366

0

0

0

Financing activities:
Proceeds from long-term debt

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments of long-term debt

-

-

-

-

-

-

-

-

-

345,000

35,000

35,000

50,000

20,000

25,000

30,000

20,000

20,000

20,000

20,000

318,750

318,125

317,500

316,875

17,500

17,500

13,125

10,938

8,750

4,375

0

0

0

-

-

-

-

Payments of debt issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

11,546

11,546

11,546

125

0

0

0

0

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

8,209

9,139

7,072

28,406

32,347

36,654

35,709

19,585

15,660

9,948

7,038

198

1,051

1,294

2,411

2,541

0

0

0

Repurchase of restricted stock to satisfy tax withholding obligations

39,042

27,577

25,701

26,158

27,614

24,327

24,259

23,840

24,513

14,902

16,160

15,913

17,370

16,424

15,193

15,030

16,068

16,436

16,373

16,173

13,203

50,555

50,904

51,020

47,880

8,469

7,950

9,168

5,737

4,204

4,152

2,770

2,442

2,307

0

0

0

Proceeds from exercise of stock options and employee stock purchase plan

23,314

25,080

24,273

29,552

28,516

27,071

26,598

16,419

19,270

9,888

10,128

9,707

5,915

5,861

6,845

6,537

4,529

7,404

5,933

6,897

6,794

5,740

7,444

12,771

14,327

18,133

18,047

13,745

16,218

9,868

9,307

7,114

5,923

6,622

0

0

0

Payments of deferred consideration

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,344

-1,344

-1,344

-1,344

-1,344

-1,344

-1,344

-1,344

0

0

0

0

-

-

-

-

Net cash provided by (used in) financing activities

727,615

-4,154

-1,551

3,271

902

2,744

523,426

513,023

515,201

480,430

-41,675

-41,206

-61,455

-30,563

-41,318

-46,045

-33,634

-29,032

-22,231

-20,137

751,304

733,513

739,434

749,577

-16,688

10,405

11,288

2,243

171,004

164,941

163,185

164,805

251,591

252,680

0

0

0

Effect of foreign currency exchange rates on cash and cash equivalents

-1,629

442

-1,398

-1,261

-1,742

-1,248

-94

410

1,764

1,374

427

-106

-1,142

-1,415

-1,201

-1,352

-385

-433

-461

-341

-677

-376

-28

351

257

189

123

59

32

78

42

-52

-12

44

0

0

0

Net increase in cash, cash equivalents and restricted cash

695,106

-29,685

317,833

331,534

301,388

-111,047

448,791

401,640

358,957

644,240

100,896

100,487

110,752

145,405

146,590

112,370

-80,051

-105,194

-110,686

-93,076

318,328

271,059

263,257

254,756

56,049

99,926

93,476

86,763

-381,702

-389,253

-421,278

-444,279

256,844

338,875

0

0

0

Supplemental cash flow disclosures:
Interest paid

1,978

1,998

1,922

2,047

1,559

1,421

1,323

2,936

5,490

6,445

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Income taxes paid

69,525

68,935

52,135

39,688

35,968

35,980

40,564

39,818

41,382

41,283

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Supplemental non-cash investing and financing activities:
Stock issued in connection with acquisition - ForRent

-

-

-

-

-

36,366

36,366

36,366

36,366

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-