Rapid7, inc. (RPD)
CashFlow / TTM
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

-65,096

-53,845

-52,519

-49,944

-50,857

-55,545

-55,529

-53,982

-51,286

-45,470

-42,240

-42,150

-43,965

-49,000

-60,332

-61,963

-57,755

-49,857

0

0

0

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

17,944

16,528

15,329

13,391

12,125

11,097

10,061

9,468

8,403

7,628

6,699

6,543

6,638

6,725

6,982

6,410

5,929

5,352

0

0

0

Amortization of debt discount and issuance costs

10,746

10,513

10,318

8,935

6,341

3,831

0

0

0

-

-

-

-

-

-

-

-

1,129

0

0

0

Stock-based compensation expense

45,377

40,664

36,084

33,082

30,002

27,593

25,802

23,666

21,487

19,541

18,717

17,606

16,076

17,316

21,189

18,439

15,629

10,685

0

0

0

Provision for doubtful accounts

2,331

2,241

2,042

1,637

1,021

740

876

883

745

905

936

1,015

1,123

931

756

846

787

828

0

0

0

Foreign currency re-measurement loss

-453

-255

-761

-477

-859

-757

-612

-345

261

364

186

61

-325

-58

103

19

311

-153

0

0

0

Other non-cash (income) expense

1,305

1,889

1,796

1,725

1,176

506

350

37

-60

-209

-604

-527

-397

-222

0

0

0

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

6,921

14,800

10,112

21,722

21,678

1,685

6,060

1,871

5,677

25,217

11,199

9,900

5,061

6,195

6,587

12,585

8,501

18,370

0

0

0

Deferred contract acquisition and fulfillment costs

10,728

11,306

11,808

11,431

12,171

12,790

6,385

4,531

1,713

0

0

0

0

-

-

-

-

-

-

-

-

Prepaid expenses and other assets

7,616

13,691

7,731

6,019

3,037

287

3,109

4,088

4,730

74

1,846

1,710

1,341

3,523

2,342

2,121

1,725

1,787

0

0

0

Accounts payable

4,036

92

4,242

3,468

522

3,675

-1,370

1,791

1,206

-2,257

748

-1,942

1,875

1,619

-152

970

-2,114

-2,302

0

0

0

Accrued expenses

3,886

4,759

3,370

6,512

3,645

6,018

3,781

1,074

2,657

6,758

3,988

2,918

1,789

1,578

3,504

4,322

3,203

6,702

0

0

0

Deferred revenue

14,119

18,686

13,059

18,805

17,261

22,870

33,544

43,070

50,358

55,437

39,380

35,709

35,792

38,748

38,748

46,848

42,820

44,868

0

0

0

Other liabilities

-1,650

1,018

2,281

2,165

2,416

367

-607

-800

-1,128

-950

-573

-189

458

558

105

-273

-329

-119

0

0

0

Net cash used in operating activities

4,931

-1,420

2,690

-3,199

-14,796

6,066

2,334

12,128

17,261

13,286

12,135

8,181

14,025

9,112

2,134

2,617

-487

-1,907

0

0

0

Cash flows from investing activities:
Purchases of property and equipment

23,721

29,428

31,462

24,875

19,129

12,813

9,722

7,896

5,636

4,824

4,698

5,235

4,742

4,499

4,604

4,783

4,655

4,136

0

0

0

Capitalization of internal-use software costs

5,960

6,087

5,446

5,004

4,173

3,265

2,911

2,259

1,855

1,162

0

0

0

-

-

-

-

-

-

-

-

Purchases of investments

109,290

148,047

168,684

295,198

291,990

233,421

192,451

30,017

32,249

35,190

60,660

54,804

46,377

38,976

0

0

0

-

-

-

-

Sales/maturities of investments

256,166

214,980

207,937

177,400

128,902

70,226

48,726

52,195

46,834

33,672

24,522

14,605

900

0

0

0

0

-

-

-

-

Net cash provided by (used in) investing activities

102,588

16,811

-26,722

-176,758

-200,850

-193,733

-156,358

-2,694

-7,623

-22,221

-56,309

-45,750

-50,219

-43,475

-40,071

-40,250

-43,466

-42,947

0

0

0

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

-

-

-

-

-

30,907

30,907

30,907

31,231

0

0

0

0

-

-

-

-

-

-

-

-

Payments of capital lease obligations

-

-

-

-

-

-

-

-

-

-

-

-

-

68

134

198

262

253

0

0

0

Taxes paid related to net share settlement of equity awards

7,506

6,952

5,411

4,031

2,714

2,197

1,942

1,442

991

698

756

615

1,196

4,114

0

0

0

-

-

-

-

Proceeds from employee stock purchase plan

6,233

5,521

5,521

4,639

4,639

3,637

3,637

3,047

3,047

2,914

2,914

3,127

3,127

3,724

0

0

0

-

-

-

-

Proceeds from stock option exercises

9,062

10,219

9,009

9,007

8,363

7,606

7,374

6,394

7,034

5,848

5,401

5,604

3,152

2,924

2,547

2,030

1,443

1,304

0

0

0

Net cash provided by financing activities

7,789

8,788

8,711

205,826

206,175

236,164

236,595

38,906

39,525

7,268

5,458

6,015

3,778

1,161

1,670

95,429

93,925

94,786

0

0

0

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

-743

-331

-914

-531

-806

-694

-466

-177

321

281

56

-133

-430

-203

-2

-41

193

-202

0

0

0

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

114,565

23,848

-16,235

25,338

-10,277

47,803

82,105

48,163

49,484

-1,386

-38,660

-31,687

-32,846

-33,405

-36,269

57,755

50,165

49,730

0

0

0

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

2,875

2,779

2,779

1,342

1,342

0

0

0

0

-

-

-

-

5

4

321

879

1,427

0

0

0

Cash paid for income taxes, net of refunds

345

400

369

192

223

188

265

493

789

801

835

845

347

556

530

584

557

341

0

0

0

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

6,703

14,016

14,016

14,016

7,313

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Reconciliation of cash, cash equivalents and restricted cash: