Realpage, inc (RP)
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:
Net income

5,605

20,169

11,704

15,063

11,272

6,272

9,073

8,479

10,901

-20,865

6,834

6,213

8,195

7,361

4,210

2,083

2,996

3,900

-8,192

-3,318

-1,608

110

-3,257

-6,291

-836

2,178

12,886

4,610

1,018

19,231

2,113

-2,372

1,720

241

-1,106

282

-648

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

33,562

28,846

29,266

29,016

27,824

26,168

25,629

25,129

23,260

21,332

16,281

15,093

14,440

13,960

14,052

14,215

12,607

12,104

11,913

11,263

10,611

10,773

10,962

10,067

9,504

8,922

7,605

7,420

7,798

8,063

7,945

7,859

7,878

7,689

7,442

7,243

6,773

Amortization of debt discount and issuance costs

3,474

3,511

3,676

3,279

3,234

3,192

3,151

3,109

3,012

2,956

2,916

1,335

89

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of right-of-use assets

3,603

2,749

2,759

2,920

3,005

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred taxes

-2,992

-5,755

3,795

1,686

2,550

541

253

-1,819

-1,154

24,602

-7,723

-3,331

243

2,962

3,104

781

1,539

3,608

-7,173

454

-2,108

-1,880

-2,161

-2,859

-991

2,370

-7,919

2,361

685

-2,429

782

-1,434

578

1,954

-663

11

-778

Stock-based expense

16,201

15,287

16,498

15,865

14,913

13,149

13,479

13,695

10,318

10,103

11,764

13,876

10,092

9,469

8,255

10,737

8,391

7,456

8,669

11,250

10,747

8,256

9,536

10,033

9,225

8,655

7,736

6,061

7,245

15,380

6,013

4,316

3,988

6,388

6,408

4,969

4,853

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

27

1,325

-331

-637

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Impairment of identified intangible assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

20,274

0

527

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loss on disposal and impairment of other long-lived assets

-12

-2,277

10

17

-286

-3,294

-2,341

-156

-942

-52

-385

-63

-24

-998

-164

-85

0

-102

-692

-1,684

-592

-350

-16

0

-20

-4

-37

-270

-3

73

-8

-201

-178

0

-3

2

-397

Change in fair value of equity investment

0

0

0

0

2,600

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisition-related consideration

489

-87

394

294

405

-522

-318

722

402

302

-642

903

121

-378

-248

-125

-126

-250

-3,511

116

377

-391

630

-233

167

-16

-145

-1,193

2,638

1,706

-604

612

-430

-308

3

-43

-62

Changes in assets and liabilities, net of assets acquired and liabilities assumed in business combinations:
Accounts receivable

-12,674

9,617

1,750

2,354

983

7,650

-118

8,833

-15,648

19,594

5,657

-443

-5,987

10,232

3,258

3,701

-4,952

5,656

3,236

3,841

-4,032

1,114

3,752

-2,680

-4,115

7,662

-499

4,271

2,235

12,646

1,184

1,141

-1,302

7,201

-134

4,061

-27

Prepaid expenses and other current assets

2,199

9,040

4,463

3,480

-3,197

-3,884

6,383

5,657

3,738

-2,895

581

524

845

-2,861

-15,523

-2,673

17

-3,842

2,280

-1,005

1,176

-82

1,258

-22

1,209

-825

-64

101

1,129

3,556

-3,185

-743

713

-3,120

1,570

2,185

-977

Other assets

-1,553

5,278

-355

369

-185

1,786

509

1,233

1,015

611

-358

-191

655

113

-169

360

-117

697

298

-102

-79

-108

-188

397

491

-56

112

136

138

-363

-82

-473

1,248

343

94

-161

654

Accounts payable

-887

1,482

1,797

2,038

4,001

-2,778

-1,855

-1,044

6,943

-3,434

-364

2,982

1,084

296

294

-1,044

1,106

-80

-1,812

916

170

-1,278

-4,359

3,455

4,003

-2,137

910

172

2,820

4,020

-1,868

503

-890

2,751

-468

876

1,065

Accrued compensation, taxes, and benefits

-4,290

470

7,213

1,770

-10,603

714

3,953

6,012

-7,391

2,265

1,932

4,797

-5,556

2,612

780

4,160

-2,332

-1,784

798

3,502

1,372

2,221

-173

1,790

-1,874

863

-745

-677

-700

-2,925

205

2,054

-593

-25

175

294

-1,630

Deferred revenue

2,077

6,179

-1,527

2,954

90

8,671

-3,159

997

-3,031

12,331

1,176

1,797

1,810

7,457

-1,776

368

-1,597

6,855

2,611

2,552

-1,227

5,303

1,552

3,587

-1,999

3,467

-3,308

2,080

-1,270

772

-274

1,869

-1,398

5,904

-369

1,918

357

Customer deposits

-5,007

83,665

45,512

3,706

-50,252

63,591

-11,503

-11,135

16,277

3,765

-16,099

2,666

12,723

-

-

-

-

-

-

-

-

-

-2

0

-1

-1

1

-198

198

-

-89

42

2

-25

20

0

17

Other current and long-term liabilities

-2,293

-4,030

-2,451

-2,986

-2,532

-6,895

-1,528

2,871

-603

-1,719

-349

2,165

-769

536

2,384

1,528

1,360

-848

934

-26

110

-377

-616

-2,732

3,993

76

-483

980

272

103

-7,365

8,439

-332

-575

569

411

-1,557

Net cash provided by operating activities

61,582

130,828

112,768

69,385

3,992

109,845

32,742

31,449

70,771

34,380

10,231

48,669

46,983

24,325

44,523

31,632

28,969

27,498

19,720

26,296

22,498

19,918

7,306

19,122

23,626

17,600

17,026

17,378

17,205

28,054

8,949

21,304

10,902

19,527

10,478

9,960

9,261

Cash flows from investing activities:
Purchases of property, equipment, and software

13,254

12,989

15,045

12,593

10,873

13,646

14,794

9,833

12,660

11,176

11,447

17,204

9,925

14,236

22,519

28,269

10,217

14,600

7,536

5,066

6,182

7,937

9,990

11,873

7,262

10,762

8,797

5,669

7,724

14,351

8,696

6,345

3,560

5,365

5,140

3,688

1,954

Payments to Acquire Businesses, Net of Cash Acquired

59,462

615,785

32,531

17,528

0

-

-

-

-

302,360

224,309

57,138

66,103

-4,960

95

12,153

59,152

-168

0

45,450

0

5

-111

34,874

7,179

17,887

146

146

10,050

18,506

5,244

176

4,303

1,932

67,786

19,847

184

Intangible asset additions

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

327

0

0

600

702

0

150

75

-

-

-

-

Purchase of other investments

-

-

-

-

-

0

0

0

1,800

200

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-72,716

-628,774

-47,576

-31,871

-10,873

-61,735

-107,793

-147,308

-14,460

-313,736

-235,756

-74,342

-76,028

-4,776

-25,614

-40,422

-69,369

-14,432

-7,536

-50,211

-6,182

-8,202

-9,879

-46,747

-14,441

-28,976

-8,943

-5,815

-18,374

-33,559

-13,940

-6,671

-7,938

-9,147

-72,926

-23,535

-2,138

Cash flows from financing activities:
Proceeds from term loans

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

124,688

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments on term loans

3,750

3,748

296,929

4,034

4,033

4,033

4,034

4,033

2,016

2,018

766

767

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

50,000

2,695

2,696

2,695

Payments on revolving credit facility

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

40,000

4,000

13,500

9,000

5,000

18,572

30,000

0

0

-

-

-

10,000

-15,312

10,000

10,000

5,312

-

-

-

-

Payments of deferred financing costs

-

-

-

-

-

1

-4

52

1,087

-292

271

9,467

1,288

0

0

0

392

0

0

0

8

196

992

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Payments on finance lease obligations

811

772

752

1,358

769

8

8

97

114

103

96

35

101

-1

123

274

152

145

143

143

143

142

140

141

139

137

138

137

136

483

0

4

61

87

87

85

266

Stock issuance costs from public offerings

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

775

Payments of acquisition-related consideration

45

-

-

-

11,412

-

-

-

-

418

888

724

6,461

808

2,140

375

2,361

1,576

875

95

1,139

2,412

3,259

28

720

4

1,059

179

307

-

-

-

-

-

-

-

-

Payment for Contingent Consideration Liability, Financing Activities

-

-

-

-

-

-

-

6,595

776

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from public offering, net of underwriters’ discount and offering costs

-

-

-

-

-

-

-

-

-

0

0

-7,927

7,927

-16,139

8,131

5,526

2,482

9,215

1,431

714

755

4,746

152

3,741

1,275

3,754

3,861

1,469

1,524

734

6,871

1,242

1,761

4,175

1,062

4,393

3,044

Proceeds from exercise of stock options

4,906

1,379

1,385

1,192

1,877

3,210

2,214

2,701

5,038

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

27

1,325

-331

-637

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of treasury stock related to stock-based compensation

3,493

4,096

5,663

6,092

5,016

6,908

7,362

6,310

8,450

9,715

10,181

7,432

3,576

2,241

1,600

917

1,262

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other financing activities, net

-26

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of treasury stock under share repurchase program

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

5,106

16,138

4,628

15,309

5,380

9,766

-5,601

15,298

3,831

1,993

1,697

1,098

1,132

933

2,472

764

578

1,046

1,397

310

287

186

Net cash used in financing activities

-3,219

509,852

-11,361

-19,127

-19,353

-35,993

-29,930

377,413

-7,405

242,838

-3,739

300,749

-3,499

14,519

3,486

-1,954

66,892

-651

-22,909

25,522

-15,301

-15,421

-5,965

24,741

-1,577

1,916

1,566

21

-9,852

21,310

-4,631

-18,370

-4,658

-6,593

-2,030

1,325

-878

Net decrease in cash, cash equivalents and restricted cash

-14,353

11,906

53,831

18,387

-26,234

12,117

-104,981

261,554

48,906

-36,518

-229,264

275,076

-32,544

34,068

22,395

-10,744

26,492

12,415

-10,725

1,607

1,015

-3,705

-8,538

-2,884

7,608

-

-

-

-11,021

15,805

-9,622

-3,737

-1,694

3,787

-64,478

-12,250

6,245

Effect of exchange rate on cash

-505

-448

258

118

-99

-150

80

14

-127

-31

88

48

-50

-79

7

-67

96

-70

-31

-72

-164

-29

-9

5

-14

-18

12

-26

-22

-54

5

-1

-4

-5

-16

-8

-12

Supplemental cash flow information:
Cash paid for interest

7,152

333

4,884

9,478

1,378

5,930

3,074

6,314

2,886

3,997

781

1,187

789

887

199

1,235

512

413

323

170

180

136

396

124

158

162

443

174

195

-343

364

427

526

541

567

703

687

Cash paid for income taxes, net

652

202

402

1,332

138

575

1,824

793

-71

150

548

832

325

-827

320

1,009

191

84

127

406

76

154

71

20

267

72

88

295

70

261

7

240

17

227

132

252

413

Right-of-use assets obtained in exchange for operating lease obligations

1,392

2,421

9,163

12,029

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash investing and financing activities:
Accrued property, equipment, and software

3,146

349

-180

634

1,805

-390

736

426

675

2,535

2,291

-8,990

9,941

2,293

-7,227

287

8,640

1,858

159

760

647

-1,336

507

1,149

287

-

-

-

-

-

-

-

-

-

-

-

-

Fixed assets acquired under capital lease

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

1,976

-

-

-

-

-

-

-

-