Rapid7, inc. (RPD)
CashFlow / Quarterly
Mar'20Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15
Cash flows from operating activities:
Net loss

-22,924

-14,346

-14,406

-13,420

-11,673

-13,020

-11,831

-14,333

-16,361

-13,004

-10,284

-11,637

-10,545

-9,774

-10,194

-13,452

-15,580

-21,106

-11,825

-9,244

-7,682

Adjustments to reconcile net loss to net cash used in operating activities:
Depreciation and amortization

4,843

4,559

4,598

3,944

3,427

3,360

2,660

2,678

2,399

2,324

2,067

1,613

1,624

1,395

1,911

1,708

1,711

1,652

1,339

1,227

1,134

Amortization of debt discount and issuance costs

2,743

2,730

2,679

2,594

2,510

2,535

1,296

0

0

-

-

-

-

-

-

-

-

0

853

138

138

Stock-based compensation expense

13,347

11,174

10,426

10,430

8,634

6,594

7,424

7,350

6,225

4,803

5,288

5,171

4,279

3,979

4,177

3,641

5,519

7,852

1,427

831

575

Provision for doubtful accounts

527

459

429

916

437

260

24

300

156

396

31

162

316

427

110

270

124

252

200

211

165

Foreign currency re-measurement loss

-447

315

-379

58

-249

-191

-95

-324

-147

-46

172

282

-44

-224

47

-104

223

-63

-37

188

-241

Other non-cash (income) expense

138

254

345

568

722

161

274

19

52

5

-39

-78

-97

-390

38

52

78

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

-22,608

25,660

-6,311

10,180

-14,729

20,972

5,299

10,136

-34,722

25,347

1,110

13,942

-15,182

11,329

-189

9,103

-14,048

11,721

5,809

5,019

-4,179

Deferred contract acquisition and fulfillment costs

516

5,903

2,231

2,078

1,094

6,405

1,854

2,818

1,713

0

0

0

0

-

-

-

-

-

-

-

-

Prepaid expenses and other assets

-135

3,813

544

3,394

5,940

-2,147

-1,168

412

3,190

675

-189

1,054

-1,466

2,447

-325

685

716

1,266

-546

289

778

Accounts payable

4,010

-1,040

-1,052

2,118

66

3,110

-1,826

-828

3,219

-1,935

1,335

-1,413

-244

1,070

-1,355

2,404

-500

-701

-233

-680

-688

Accrued expenses

-14,563

9,581

2,490

6,378

-13,690

8,192

5,632

3,511

-11,317

5,955

2,925

5,094

-7,216

3,185

1,855

3,965

-7,427

5,111

2,673

2,846

-3,928

Deferred revenue

-16,671

30,810

-7,058

7,038

-12,104

25,183

-1,312

5,494

-6,495

35,857

8,214

12,782

-1,416

19,800

4,543

12,865

1,540

19,800

12,643

8,837

3,588

Other liabilities

-1,063

-274

163

-476

1,605

989

47

-225

-444

15

-146

-553

-266

392

238

94

-166

-61

-140

38

44

Net cash used in operating activities

-7,215

7,824

1,839

2,483

-13,566

11,934

-4,050

-9,114

7,296

8,202

5,744

-3,981

3,321

7,051

1,790

1,863

-1,592

73

2,273

-1,241

-3,012

Cash flows from investing activities:
Purchases of property and equipment

2,756

2,375

9,341

9,249

8,463

4,409

2,754

3,503

2,147

1,318

928

1,243

1,335

1,192

1,465

750

1,092

1,297

1,644

622

573

Capitalization of internal-use software costs

1,474

1,401

1,534

1,551

1,601

760

1,092

720

693

406

440

316

0

-

-

-

-

-

-

-

-

Purchases of investments

24,272

33,839

41,776

9,403

63,029

54,476

168,290

6,195

4,460

13,506

5,856

8,427

7,401

38,976

0

0

0

-

-

-

-

Sales/maturities of investments

113,924

37,693

36,985

67,564

72,738

30,650

6,448

19,066

14,062

9,150

9,917

13,705

900

0

0

0

0

-

-

-

-

Net cash provided by (used in) investing activities

85,422

78

-15,652

32,740

-355

-43,455

-165,688

8,648

6,762

-6,080

-12,024

3,719

-7,836

-40,168

-1,465

-750

-1,092

-36,764

-1,644

-3,966

-573

Cash flows from financing activities:
Proceeds from follow-on public offering, net of offering costs of $608

-

-

-

-

-

0

0

-324

31,231

0

0

0

0

-

-

-

-

-

-

-

-

Payments of capital lease obligations

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

68

66

64

64

59

Taxes paid related to net share settlement of equity awards

1,533

2,026

2,087

1,860

979

485

707

543

462

230

207

92

169

288

66

673

3,087

-

-

-

-

Proceeds from employee stock purchase plan

3,346

0

2,887

0

2,634

0

2,005

0

1,632

0

1,415

0

1,499

0

1,628

0

2,096

-

-

-

-

Proceeds from stock option exercises

1,561

2,295

1,866

3,340

2,718

1,085

1,864

2,696

1,961

853

884

3,336

775

406

1,087

884

547

29

570

297

408

Net cash provided by financing activities

3,374

269

2,666

1,480

4,373

192

199,781

1,829

34,362

623

2,092

2,448

2,105

-1,187

2,649

211

-512

-678

96,408

-1,293

349

Effect of exchange rate changes on cash, cash equivalents and restricted cash

-560

317

-497

-3

-148

-266

-114

-278

-36

-38

175

220

-76

-263

-14

-77

151

-62

-53

157

-244

Net increase (decrease) in cash, cash equivalents and restricted cash

81,021

8,488

-11,644

36,700

-9,696

-31,595

29,929

1,085

48,384

2,707

-4,013

2,406

-2,486

-34,567

2,960

1,247

-3,045

-37,431

96,984

-6,343

-3,480

Supplemental cash flow information:
Cash paid for interest on convertible senior notes

1,438

0

1,437

0

1,342

0

0

0

0

-

-

-

-

4

0

0

1

3

317

558

549

Cash paid for income taxes, net of refunds

33

-4

85

231

88

-35

-92

262

53

42

136

558

65

76

146

60

274

50

200

33

58

Non-cash investing activities:
Leasehold improvements acquired through tenant improvement allowance

0

0

0

6,703

7,313

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Reconciliation of cash, cash equivalents and restricted cash: