Cornerstone ondemand, inc. (CSOD)
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'13Dec'12Sep'12Jun'12Mar'12Dec'11Sep'11Jun'11Mar'11
Cash flows from operating activities
Net loss

-14,365

-4,054

-16,658

-17,888

-21,090

-33,842

-39,674

-52,082

-61,340

-61,335

-70,949

-68,482

-64,805

-66,837

-67,062

-74,823

-80,497

-85,516

-84,839

-79,001

-72,371

-64,899

-57,488

-54,231

-46,282

-40,426

-37,088

-33,661

-33,212

-31,390

-28,929

-25,579

-24,419

-63,900

0

0

0

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

42,705

41,599

40,757

39,075

38,287

35,260

33,700

33,618

33,880

35,377

35,553

34,919

34,162

32,392

31,482

30,059

28,842

27,512

25,152

21,705

18,242

15,086

12,534

11,538

10,648

9,700

9,095

8,507

8,000

7,037

5,958

4,982

4,052

3,714

0

0

0

Accretion of debt discount and amortization of debt issuance costs

4,270

4,207

4,141

4,550

6,530

8,929

10,603

12,019

10,906

9,833

9,473

9,357

9,242

9,130

9,018

8,908

8,799

8,691

8,585

8,480

8,376

8,274

8,173

8,073

6,304

4,273

0

0

0

-

-

-

-

-

-

-

-

Amortization (accretion) of purchased investment premium or discount, net

700

957

1,488

698

295

160

-1,036

-541

-899

-1,135

-548

-85

-185

-240

-575

-712

-537

-262

-497

-271

175

-816

-1,225

1,374

1,105

2,031

0

0

0

-

-

-

-

-

-

-

-

Change in fair value of preferred stock warrant liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-42,559

0

0

0

Non-cash interest expense

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

0

0

0

Net foreign currency and other loss

-4,662

629

-2,586

-2,360

-210

440

1,615

3,001

2,287

2,461

229

-58

-449

7

1,231

1,824

1,289

-1,584

-1,996

-3,719

-3,672

-1,656

-1,196

189

173

-242

-230

-209

-305

182

0

0

0

-

-

-

-

Stock-based compensation expense

78,555

72,430

71,229

67,242

64,123

66,557

65,937

67,988

69,554

65,924

64,978

62,142

57,552

54,699

53,163

50,584

47,360

43,081

39,844

36,155

34,505

33,680

31,081

28,520

24,733

20,840

18,173

15,572

13,707

12,207

9,840

7,544

6,196

4,502

0

0

0

Non-cash charitable contribution of common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-193

0

0

0

Deferred Income Tax Expense (Benefit)

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-865

-663

-982

-1,094

-965

0

0

0

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

2,993

5,554

4,658

-5,978

-18,266

-27,199

-26,809

-9,407

10,686

14,317

24,517

17,543

15,224

38,092

11,258

26,501

27,804

21,837

7,277

13,923

12,215

18,674

31,921

22,795

13,701

19,046

10,241

11,802

11,927

12,254

21,169

12,242

9,827

13,308

0

0

0

Deferred commissions

22,385

27,241

22,342

21,306

19,062

15,316

11,996

9,998

7,495

5,249

4,588

2,258

2,780

2,543

6,481

7,330

9,315

10,296

8,697

9,168

9,864

10,097

7,571

7,446

4,503

7,085

8,160

7,282

7,253

5,691

1,300

1,230

1,248

1,274

0

0

0

Prepaid expenses and other assets

-2,643

-12,834

-10,638

-12,334

-1,039

11,443

8,163

15,307

4,112

2,704

3,849

5,294

7,726

3,623

1,593

1,552

2,390

2,575

4,389

4,233

4,774

-1,245

963

936

2,478

6,057

5,029

6,817

4,994

4,188

3,680

859

996

1,804

0

0

0

Accounts payable

-5,455

-8,759

-5,278

3,965

-672

-5,496

-4,802

-3,988

60

-6,820

2,600

-2,068

-2,228

5,939

552

3,471

488

4,444

1,480

218

1,112

4,562

4,108

3,802

4,922

5,082

1,545

3,495

12

190

2,222

1,729

867

915

0

0

0

Accrued expenses

13,636

8,428

3,707

938

1,063

9,291

10,658

14,594

7,247

8,530

6,831

2,185

2,875

3,727

9,127

9,344

8,754

14,724

6,707

6,411

4,893

6,446

4,645

7,803

4,704

6,828

7,509

5,286

5,349

6,325

2,659

1,843

1,023

3,314

0

0

0

Deferred revenue

8,037

19,635

10,450

6,112

10,595

10,803

13,457

31,979

34,715

35,829

34,546

28,669

33,933

43,379

40,740

57,661

58,687

64,774

56,096

53,462

56,192

55,216

44,332

40,536

37,421

45,230

36,146

35,272

35,418

35,327

31,819

24,368

23,214

22,161

0

0

0

Other liabilities

5,572

3,549

4,736

3,297

3,010

-1,212

-493

-1,392

-2,567

2,377

-200

-279

-2,028

-2,416

-2,129

-590

-475

-947

8

866

1,894

-295

-772

-1,547

-1,922

746

1,233

3,392

3,357

3,735

3,979

1,248

1,034

666

0

0

0

Net cash provided by operating activities

114,243

115,549

97,943

106,082

102,127

90,253

96,848

85,769

70,165

67,510

49,461

40,755

42,871

35,252

54,798

48,014

31,592

43,796

35,156

24,955

29,480

33,009

8,064

11,267

17,832

17,431

12,023

11,540

7,743

10,294

1,079

3,068

3,470

1,832

0

0

0

Cash flows from investing activities
Purchases of marketable investments

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of marketable investments

-

-

-

-

-

-

-

-

-

321,913

266,926

235,501

271,272

210,534

233,184

177,858

155,429

220,383

162,191

145,555

188,184

124,191

124,191

286,634

221,463

203,959

0

0

0

-

-

-

-

-

-

-

-

Maturities and sales of investments

337,895

236,401

256,590

310,818

315,735

185,733

229,755

263,785

289,608

314,418

241,150

197,660

196,834

151,533

187,174

169,749

144,049

138,360

144,644

166,629

201,563

203,078

140,572

88,437

22,194

6,182

0

0

0

-

-

-

-

-

-

-

-

Capital expenditures

14,762

18,034

20,721

16,542

16,579

14,895

10,579

10,987

6,961

7,100

8,565

6,607

7,466

6,228

4,972

10,485

12,029

15,633

15,509

12,265

12,893

11,025

12,817

13,654

10,491

8,762

8,243

4,312

3,544

2,123

283

203

766

784

0

0

0

Capitalized software costs

24,658

24,668

25,407

27,340

26,875

25,515

23,688

21,511

20,854

20,571

19,999

19,544

17,523

16,409

15,523

14,880

14,454

13,283

12,525

11,496

10,651

9,529

8,919

8,155

7,320

6,906

6,355

5,982

5,701

5,030

4,467

4,122

3,623

3,022

0

0

0

Cash paid for acquisition, net of cash acquired

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by investing activities

-32,009

-97,727

-14,516

100,171

106,082

-20,876

-39,743

-5,161

15,661

-36,666

-54,340

-63,992

-99,427

-81,638

-66,505

-33,474

-37,863

-110,939

-88,909

-46,015

-53,493

15,005

-5,355

-220,006

-217,080

-213,445

-213,098

-10,294

-21,673

-19,581

-178

17,247

-4,468

-3,885

0

0

0

Cash flows from financing activities
Payment of debt issuance costs

-

-

-

-

-

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from initial public offering, net of underwriting discounts and commissions

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

90,539

0

0

0

Payments of initial public offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,436

0

0

0

Proceeds from issuance of preferred stock upon warrant exercises

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,163

0

0

0

Proceeds from the issuance of debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,914

2,957

2,957

2,957

1,043

0

0

0

-

-

-

-

Repayment of debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

352

429

494

544

559

562

543

3,816

4,038

4,161

4,290

1,661

1,510

1,306

1,108

345

9,207

0

0

0

Principal payments under capital lease obligations

-

-

-

-

-

-

-

-

-

-

-

-

-

33

50

87

140

202

370

516

663

886

1,059

1,278

1,606

1,747

1,912

1,977

1,929

1,919

2,214

2,134

2,028

1,977

0

0

0

Proceeds from employee stock plans

45,890

42,600

44,000

38,566

54,477

54,402

46,261

36,245

15,801

12,509

15,500

17,383

22,937

23,548

20,132

20,377

14,260

11,559

11,761

8,605

8,059

12,285

13,930

16,645

17,330

13,447

9,953

5,797

3,830

2,698

0

0

0

-

-

-

-

Repurchases of common stock

-

-

-

-

-

79,266

75,485

59,342

35,434

20,734

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from common stock warrant exercises

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Net cash provided by financing activities

18,065

14,775

486

-260,561

-263,089

-278,016

2,701

261,828

265,292

276,852

15,500

17,383

22,937

23,515

20,025

20,154

13,892

11,005

10,962

7,595

6,852

10,840

12,309

14,445

231,260

228,928

226,189

222,218

3,197

312

-661

-1,642

-2,740

80,639

0

0

0

Effect of exchange rate changes on cash and cash equivalents

-1,160

-286

-1,733

-1,517

-1,450

-1,341

319

1,493

2,367

2,580

522

281

-1,048

-1,520

-955

-1,498

258

-2,728

-3,276

-3,734

-4,876

-1,880

-665

608

503

227

35

-168

-283

8

0

0

0

-

-

-

-

Net increase in cash and cash equivalents

99,139

32,311

82,180

-55,825

-56,330

-209,980

60,125

343,929

353,485

310,276

11,143

-5,573

-34,667

-24,391

7,363

33,196

7,879

-58,866

-46,067

-17,199

-22,037

56,974

14,353

-193,686

32,515

33,141

25,149

223,296

-11,016

-8,967

117

18,310

-3,859

78,342

0

0

0

Supplemental cash flow data
Cash paid for interest

17,296

17,356

17,356

17,356

19,313

13,628

13,628

6,946

4,943

3,841

3,841

3,796

3,796

3,796

3,797

3,799

3,805

1,915

3,824

3,840

3,858

3,880

4,055

2,186

2,245

2,294

293

340

345

341

325

311

293

543

0

0

0

Cash paid for income taxes

2,269

1,704

1,774

1,955

1,797

1,859

2,016

2,129

2,047

2,243

2,297

2,226

2,262

2,334

2,148

1,972

2,107

1,520

1,252

835

528

546

531

456

470

485

476

446

69

103

170

78

261

104

0

0

0

Proceeds from employee stock plans received in advance of stock issuance

-

-

-

-

-

-

0

0

798

-

1,002

795

716

489

548

224

607

193

1,130

171

752

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

0

Cash paid for operating leases

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

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

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash investing and financing activities:
Assets acquired under capital leases and other financing arrangements

791

1,276

47,376

48,772

47,555

47,070

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

88

977

958

2,035

3,722

2,741

3,580

2,713

1,131

0

0

0

Conversion of convertible preferred stock to common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

132,775

0

0

0

Capitalized assets financed by accounts payable and accrued expenses

-1,123

490

-25

717

-1,846

1,566

3,994

2,775

6,407

1,829

718

3,809

1,425

2,080

2,160

-4,218

907

705

2,680

7,392

1,748

2,925

1,808

-447

2,869

1,175

-1

3,533

1,205

693

0

0

0

-

-

-

-

Capitalized stock-based compensation

6,285

4,847

4,722

4,704

4,541

5,042

5,024

4,978

5,116

4,998

4,862

4,838

4,443

4,252

3,925

3,497

3,264

2,833

2,469

2,122

1,773

1,563

1,415

1,190

1,036

941

815

750

677

556

449

354

279

234

0

0

0

Unsettled share repurchase in other liabilities

-

-

-

-

-

-

-

-

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred offering costs included in accounts payable and accrued expenses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0