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

-22,607

-25,478

-29,231

-36,849

-46,552

-61,822

-83,409

-173,188

-166,759

-154,783

-152,156

-45,055

-36,177

-18,053

23,542

17,003

7,737

422

-18,554

-20,167

-17,590

-18,673

-20,139

-20,462

-13,201

-9,249

0

0

0

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

31,010

32,126

33,824

34,564

35,268

35,338

35,426

34,837

34,814

36,225

40,555

43,331

44,258

42,763

37,902

35,569

35,246

31,010

26,864

21,313

14,532

12,517

10,428

9,390

8,752

8,438

0

0

0

Stock-based compensation

18,513

18,825

17,143

16,290

16,107

16,282

17,332

18,118

18,809

20,504

22,834

24,719

26,542

28,694

30,595

32,864

33,477

30,584

29,156

27,506

26,866

23,846

18,512

12,911

7,326

6,352

0

0

0

Loss on disposal of property and equipment

-104

-114

-186

-139

-127

-243

-75

-44

-57

-195

-478

-480

-469

-214

-34

-34

-33

-58

-32

-32

-206

-202

-204

-192

-17

7

0

0

0

Provision for doubtful accounts

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Provision for doubtful accounts

-

-

-

-

-

758

315

229

467

580

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accretion of available-for-sale securities

0

-24

14

70

234

412

487

518

373

276

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash lease expense

-186

-209

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Change in fair value of preferred stock warrant liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

732

2,786

3,876

2,562

4,121

0

0

0

Change in fair value of contingent consideration

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

306

-70

69

204

66

0

0

0

-

-

-

-

Unrealized foreign currency gains, net

1,723

823

1,082

-646

1,307

897

-392

926

-1,078

-970

750

-1,187

1,975

1,122

14

1,759

-1,954

72

-535

376

2,006

763

1,951

293

157

-68

0

0

0

Deferred income taxes

319

-595

-790

-794

-795

-42

-111

-1,838

-1,846

-1,564

-3,103

-6,918

-2,002

-6,635

-8,128

-4,718

-9,637

-5,286

0

0

0

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

-1,449

10,705

18,857

26,199

22,501

40,688

22,507

14,524

3,982

-26,051

-19,154

-19,176

-24,292

-25,303

-4,865

12,409

25,384

72,460

45,022

42,790

45,936

38,023

29,899

25,467

15,598

27,102

0

0

0

Prepaid expenses and other assets

1,429

51

-2,272

-2,761

-5,329

-4,519

-4,010

-2,520

-1,055

224

995

3,236

4,584

2,956

5,402

1,340

2,422

1,130

-780

1,264

101

2,152

3,106

2,349

2,441

1,966

0

0

0

Accounts payable and accrued expenses

1,520

16,288

7,009

14,332

288

26,612

35,055

28,772

31,134

-502

-19,796

-18,274

-23,579

-32,965

18,426

14,038

23,391

93,135

32,314

51,343

53,283

29,861

41,374

35,127

35,272

39,168

0

0

0

Other liabilities

1,945

407

-1,755

-2,013

-3,541

-2,577

-906

-722

-400

-477

359

439

1,007

947

941

580

-196

-432

-1,212

-787

-165

-823

-613

-1,478

-1,006

1,269

0

0

0

Net cash used in operating activities

30,202

31,983

9,674

3,937

-16,374

-22,686

-10,230

-12,360

8,890

21,535

20,523

39,676

52,334

60,121

104,482

81,480

65,088

76,856

22,578

34,723

30,890

6,645

17,553

11,447

21,526

21,092

0

0

0

INVESTING ACTIVITIES:
INVESTING ACTIVITIES:
Purchases of property and equipment

13,557

11,425

11,564

12,429

11,336

11,433

23,358

28,815

29,593

32,438

26,640

24,385

25,120

23,479

23,740

19,791

19,288

20,104

9,899

10,432

11,838

10,706

9,908

8,945

6,130

6,785

0

0

0

Capitalized internal use software development costs

8,702

8,463

7,938

7,850

8,032

8,507

8,430

8,478

8,276

7,988

8,523

9,220

9,901

9,922

9,801

9,301

8,523

8,333

8,218

8,391

8,900

8,779

8,161

7,184

5,148

3,926

0

0

0

Investments in available-for-sale securities

-

-

-

-

-

-

-

87,426

99,514

95,224

84,793

57,198

56,044

41,096

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Maturities of available-for-sale securities

0

7,500

14,500

29,000

47,550

62,650

69,050

77,150

86,700

81,050

84,410

69,610

47,910

37,360

31,001

24,801

18,401

12,001

0

0

0

-

-

-

-

-

-

-

-

Change in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-1,345

-1,345

-1,547

-345

-149

-199

-199

1,151

0

0

0

Net cash (used in) provided by investing activities

-33,259

-23,388

-5,002

11,863

32,657

27,947

-6,306

-80,093

-89,293

-93,210

-74,156

-21,431

-43,393

-37,375

-45,517

-51,827

-68,110

-73,884

-57,686

-48,160

-23,174

-23,123

-17,920

-15,930

-11,079

-11,862

0

0

0

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,037

3,533

3,394

1,969

496

0

0

0

Proceeds from exercise of stock options

360

588

529

383

290

45

48

55

32

394

844

1,774

7,899

14,249

16,655

19,682

16,220

13,533

12,978

9,138

6,585

3,498

1,582

1,718

1,679

866

0

0

0

Taxes paid related to net share settlement

7,497

1,847

2,827

2,827

3,433

1,638

994

1,013

2,443

2,403

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayment of debt and capital lease obligations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

105

156

208

3,993

4,076

4,285

4,536

1,000

1,166

0

0

0

Net cash used in financing activities

-6,083

-205

-1,650

-1,796

-2,829

-1,279

-618

-630

-1,782

-1,380

-1,202

-253

3,727

10,077

14,187

17,214

18,207

15,468

11,257

7,226

88,437

83,794

83,497

83,521

-1,290

-796

0

0

0

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

-291

46

-254

-140

-256

-172

-97

12

259

199

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

CHANGE IN CASH, CASH EQUIVALENTS AND RESTRICTED CASH

-9,431

8,436

2,768

13,864

13,198

3,810

-17,251

-93,071

-81,926

-72,856

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

23

-160

-373

-243

-281

-76

0

512

314

-94

0

0

0

CHANGE IN CASH, CASH EQUIVALENTS AND RESTRICTED CASH

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

15,208

18,280

-24,224

-6,454

95,872

67,240

83,130

79,550

9,471

8,340

0

0

0

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

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for income taxes

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for interest

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for interest

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Capitalized assets financed by accounts payable and accrued expenses

-30

141

2,008

-588

278

6

-1,953

-3,123

92

109

1,938

3,873

1,214

1,627

1,176

130

561

342

1,668

2,739

1,609

1,872

1,318

-138

546

194

0

0

0

Capitalized stock-based compensation

583

567

527

535

520

520

499

476

422

443

518

666

912

952

1,005

996

853

819

718

654

689

624

570

456

255

181

0

0

0

Deferred offering costs included in accounts payable and accrued expenses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

Unpaid deferred offering costs in accounts payable and accrued expenses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0