The rubicon project, inc. (RUBI)
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'13
OPERATING ACTIVITIES:
Net loss

-9,675

1,523

-6,174

-8,281

-12,546

-2,230

-13,792

-17,984

-27,816

-23,817

-103,571

-11,555

-15,840

-21,190

3,530

-2,677

2,284

20,405

-3,009

-11,943

-5,031

1,429

-4,622

-9,366

-6,114

-37

-4,945

-2,105

-2,162

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

7,524

7,285

8,027

8,174

8,640

8,983

8,767

8,878

8,710

9,071

8,178

8,855

10,121

13,401

10,954

9,782

8,626

8,540

8,621

9,459

4,390

4,394

3,070

2,678

2,375

2,305

2,032

2,040

2,061

Stock-based compensation

4,057

4,948

4,713

4,795

4,369

3,266

3,860

4,612

4,544

4,316

4,646

5,303

6,239

6,646

6,531

7,126

8,391

8,547

8,800

7,739

5,498

7,119

7,150

7,099

2,478

1,785

1,549

1,514

1,504

Loss on disposal of property and equipment

6

-22

-76

-12

-4

-94

-29

0

-120

74

2

-13

-258

-209

0

-2

-3

-29

0

-1

-28

-3

0

-175

-24

-5

12

0

0

Provision for doubtful accounts

2

-

-

-

800

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Provision for doubtful accounts

-

-

-

-

-

541

2

119

96

98

-84

357

209

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accretion of available-for-sale securities

0

0

0

0

-24

38

56

164

154

113

87

19

57

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash lease expense

23

260

-90

-379

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Change in fair value of preferred stock warrant liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

1,742

-1,010

2,054

1,090

428

549

Change in fair value of contingent consideration

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

442

-139

-135

138

66

0

0

0

-

-

-

-

Unrealized foreign currency gains, net

1,083

432

1,168

-960

183

691

-560

993

-227

-598

758

-1,011

-119

1,122

-1,179

2,151

-972

14

566

-1,562

1,054

-593

1,477

68

-189

595

-181

-68

-414

Deferred income taxes

161

153

4

1

-753

-42

0

0

0

-111

-1,727

-8

282

-1,650

-5,542

4,908

-4,351

-3,143

-2,132

-11

0

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

-58,600

42,854

-5,318

19,615

-46,446

51,006

2,024

15,917

-28,259

32,825

-5,959

5,375

-58,292

39,722

-5,981

259

-59,303

60,160

11,293

13,234

-12,227

32,722

9,061

16,380

-20,140

24,598

4,629

6,511

-8,636

Prepaid expenses and other assets

738

723

-79

47

-640

-1,600

-568

-2,521

170

-1,091

922

-1,056

1,449

-320

3,163

292

-179

2,126

-899

1,374

-1,471

216

1,145

211

580

1,170

388

303

105

Accounts payable and accrued expenses

-64,250

50,306

-6,451

21,915

-49,482

41,027

872

7,871

-23,158

49,470

-5,411

10,233

-54,794

30,176

-3,889

4,928

-64,180

81,567

-8,277

14,281

5,564

20,746

10,752

16,221

-17,858

32,259

4,505

16,366

-13,962

Other liabilities

152

524

10

1,259

-1,386

-1,638

-248

-269

-422

33

-64

53

-499

869

16

621

-559

863

-345

-155

-795

83

80

467

-1,453

293

-785

939

822

Net cash used in operating activities

-5,233

22,175

4,275

8,985

-3,452

-134

-1,462

-11,326

-9,764

12,322

-3,592

9,924

2,881

11,310

15,561

22,582

10,668

55,671

-7,441

6,190

22,436

1,393

4,704

2,357

-1,809

12,301

-1,402

12,436

-2,243

INVESTING ACTIVITIES:
INVESTING ACTIVITIES:
Purchases of property and equipment

2,274

5,820

3,393

2,070

142

5,959

4,258

977

239

17,884

9,715

1,755

3,084

12,086

7,460

2,490

1,443

12,347

3,511

1,987

2,259

2,142

4,044

3,393

1,127

1,344

3,081

578

1,782

Capitalized internal use software development costs

2,337

2,463

1,840

2,062

2,098

1,938

1,752

2,244

2,573

1,861

1,800

2,042

2,285

2,396

2,497

2,723

2,306

2,275

1,997

1,945

2,116

2,160

2,170

2,454

1,995

1,542

1,193

418

773

Investments in available-for-sale securities

-

-

-

-

-

-

-

4,753

19,238

28,805

34,630

16,841

14,948

18,374

7,035

15,687

0

-

-

-

-

-

-

-

-

-

-

-

-

Maturities of available-for-sale securities

0

0

0

0

7,500

7,000

14,500

18,550

22,600

13,400

22,600

28,100

16,950

16,760

7,800

6,400

6,400

10,401

1,600

0

0

-

-

-

-

-

-

-

-

Change in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

152

-1,252

-245

0

-50

-50

-49

-50

-50

1,300

Net cash (used in) provided by investing activities

-4,611

-19,283

-5,233

-4,132

5,260

-897

11,632

16,662

550

-35,150

-62,155

7,462

-3,367

-16,096

-9,430

-14,500

2,651

-24,238

-15,740

-30,783

-3,123

-8,040

-6,214

-5,797

-3,072

-2,837

-4,224

-946

-3,855

FINANCING ACTIVITIES:
FINANCING ACTIVITIES:
Payments of initial public offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

139

1,425

1,473

496

0

0

0

Proceeds from exercise of stock options

23

59

146

132

251

0

0

39

6

3

7

16

368

453

937

6,141

6,718

2,859

3,964

2,679

4,031

2,304

124

126

944

388

260

87

131

Taxes paid related to net share settlement

7,485

0

0

12

1,835

980

0

618

40

336

19

2,048

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayment of debt and capital lease obligations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

53

52

51

52

3,838

135

260

303

302

301

Net cash used in financing activities

-7,462

636

146

597

-1,584

-809

0

-436

-34

-148

-12

-1,588

368

30

937

2,392

6,718

4,140

3,964

3,385

3,979

-71

-67

84,596

-664

-368

-43

-215

-170

EFFECT OF EXCHANGE RATE CHANGES ON CASH, CASH EQUIVALENTS AND RESTRICTED CASH

-299

238

-177

-53

38

-62

-63

-169

122

13

46

78

62

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

CHANGE IN CASH, CASH EQUIVALENTS AND RESTRICTED CASH

-17,605

3,766

-989

5,397

262

-1,902

10,107

4,731

-9,126

-22,963

-65,713

15,876

-56

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

EFFECT OF EXCHANGE RATE CHANGES ON CASH, CASH EQUIVALENTS AND RESTRICTED CASH

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

31

38

-152

106

-152

-175

-22

68

53

-99

490

-130

-355

CHANGE IN CASH, CASH EQUIVALENTS AND RESTRICTED CASH

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

20,068

35,611

-19,369

-21,102

23,140

-6,893

-1,599

81,224

-5,492

8,997

-5,179

11,145

-6,623

SUPPLEMENTAL DISCLOSURES OF OTHER CASH FLOW INFORMATION:
Cash paid for income taxes

-

-

-

-

-

-

-

30

137

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for income taxes

50

-

-

-

92

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for interest

15

-

-

-

10

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for interest

-

-

-

-

-

-

-

15

15

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Capitalized assets financed by accounts payable and accrued expenses

338

-1,864

1,887

-391

509

3

-709

475

237

-1,956

-1,879

3,690

254

-127

56

1,031

667

-578

-990

1,462

448

748

81

332

711

194

-1,375

1,016

359

Capitalized stock-based compensation

161

166

102

154

145

126

110

139

145

105

87

85

166

180

235

331

206

233

226

188

172

132

162

223

107

78

48

22

33

Deferred offering costs included in accounts payable and accrued expenses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-1,022

1,161

-

-

-

-

Unpaid deferred offering costs in accounts payable and accrued expenses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0