Castlight health, inc. (CSLT)
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

-85,798

-40,002

-32,295

-30,224

-35,801

-39,706

-42,824

-53,551

-51,972

-51,902

-53,981

-47,392

-51,705

-58,686

-68,508

-77,112

-81,632

-79,920

-80,546

-80,738

-81,302

-85,940

-86,229

-82,633

-75,030

-62,182

0

0

0

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

6,111

5,920

5,955

5,972

6,342

6,858

7,312

7,428

7,775

6,613

5,333

4,341

3,083

3,168

3,053

2,699

2,353

2,024

1,788

1,660

1,526

1,354

1,176

1,024

815

633

0

0

0

Goodwill impairment

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Stock-based compensation

14,212

15,003

15,970

17,227

17,517

18,132

0

0

0

-

-

-

-

21,256

21,040

20,347

19,455

17,830

17,644

16,794

15,517

14,201

10,656

7,077

4,602

2,427

0

0

0

Amortization and impairment of deferred commissions

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization and impairment of deferred professional service costs

5,198

5,242

5,027

5,185

5,291

5,268

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash operating lease expense

0

-

0

0

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of deferred commissions

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,091

3,966

3,815

3,510

3,549

3,507

3,573

4,092

4,919

4,460

3,788

2,541

0

0

0

Lease exit and related charges

-

-

-

-

-

2,634

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Release of deferred tax valuation allowance due to business combination

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accretion and amortization of marketable securities

110

238

368

463

511

516

0

0

0

-

-

-

-

-481

-665

-863

-1,118

-1,385

-1,594

-1,819

-1,808

-1,489

-1,150

-790

-610

-714

0

0

0

Expense related to expiration of SAP warrant

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,639

2,794

2,634

2,564

135

0

0

0

Changes in operating assets and liabilities:
Accounts receivable and other, net

3,374

4,581

5,207

4,426

1,570

4,883

3,323

5,934

15,686

2,799

6,919

5,655

-695

2,278

2,243

1,443

3,545

1,654

2,367

656

4,173

6,032

7,568

6,643

3,978

2,703

0

0

0

Deferred commissions

4,246

5,344

5,058

5,426

5,980

5,735

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred professional service costs

1,633

1,686

1,926

2,247

2,462

2,735

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-8,690

-8,806

-7,284

-7,633

-4,581

-5,243

-5,217

-4,861

-5,284

-5,061

-4,674

-4,959

0

0

0

Prepaid expenses and other assets

-359

-102

-475

-210

779

-178

-919

-608

-668

-1,645

-123

-402

-1,595

-448

-1,286

-1,333

-334

-328

999

2,036

784

1,895

1,904

1,394

1,233

252

0

0

0

Accounts payable

2,665

9,278

6,377

7,097

3,112

5,744

2,108

1,783

2,370

764

-934

-1,433

-1,463

-1,035

230

-722

-261

646

670

1,021

900

147

833

973

2,197

868

0

0

0

Operating lease liabilities

5,592

5,726

0

0

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accrued expenses and other liabilities

-2,437

-3,760

-4,427

-6,023

223

290

0

0

0

-

-

-

720

1,743

-3,464

1,548

-487

-1,158

-2,623

-96

843

1,870

2,698

580

813

2,892

0

0

0

Deferred revenue

-10,400

-10,478

-9,794

-7,697

-8,907

-9,219

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accounts payable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,300

3,934

7,443

6,752

7,024

12,013

12,922

15,887

16,569

12,099

13,001

7,268

0

0

0

Accrued compensation

-700

2,795

-314

-4,361

-2,546

-7,966

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in operating activities

-19,620

-17,392

-13,878

-12,413

-11,710

-18,551

-26,137

-28,517

-31,517

-23,457

-25,087

-26,093

-33,893

-36,971

-47,218

-52,371

-57,669

-56,868

-56,455

-49,403

-51,765

-54,637

-57,636

-63,540

-53,971

-50,064

0

0

0

Investing activities:
Purchase of property and equipment

3,013

1,953

831

1,303

1,830

2,014

2,163

2,918

3,098

2,544

2,391

1,390

1,070

1,702

3,464

4,925

4,955

5,376

3,961

2,586

2,091

1,860

1,706

2,436

2,533

2,587

0

0

0

Purchase of marketable securities

32,578

30,589

29,613

21,775

21,949

31,974

31,236

54,862

88,690

62,658

81,873

68,767

52,691

98,184

106,706

162,101

136,319

119,867

106,252

87,099

207,617

230,316

210,388

187,983

69,923

42,288

0

0

0

Sales of marketable securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,000

5,000

5,000

5,000

13,000

13,000

13,000

13,000

5,000

0

0

0

Maturities of marketable securities

26,692

25,745

31,530

38,213

48,913

53,210

0

0

0

-

-

-

122,670

146,508

166,249

209,145

208,568

180,111

162,781

130,080

101,707

76,527

67,065

36,060

72,135

72,135

0

0

0

Net cash provided by investing activities

-8,899

-6,797

1,086

15,135

25,134

19,222

24,394

7,009

21,321

34,610

14,456

47,237

36,563

46,622

57,079

42,119

63,169

55,743

52,443

41,270

-102,900

-142,548

-131,928

-141,258

12,679

32,260

0

0

0

Financing activities:
Proceeds from exercise of stock options

1,535

3,060

3,791

4,083

5,670

4,480

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from ESPP offering

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from the exercise of stock options

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

3,944

4,546

4,492

3,412

3,294

2,478

2,292

2,340

864

0

0

0

Proceeds from the issuance of common stock and warrants to SAP

-

-

-

-

-

-

-

-

-

-

-

-

-

17,358

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Principal payments on long-term debt

1,859

1,859

1,859

1,395

930

465

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from initial public offering

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

189,943

186,162

189,943

189,943

0

0

0

0

Payments of issuance costs related to equity

-

-

-

-

-

-

-

-

-

731

731

807

-490

122

122

46

0

94

3,875

94

1,773

3,781

0

0

0

-

-

-

-

Net cash (used in) provided by financing activities

-138

1,201

1,932

2,688

4,740

4,015

3,657

3,767

2,353

1,625

834

913

18,561

20,065

20,576

20,370

3,570

3,850

4,452

4,398

1,639

189,456

188,200

188,014

189,741

424

0

0

0

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

-28,657

-22,988

-10,860

5,410

18,164

4,686

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Reconciliation of cash, cash equivalents and restricted cash:
Net increase (decrease) in cash and cash equivalents

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

8,070

-

440

-3,735

-153,026

-7,729

-1,364

-16,784

148,449

-17,380

0

0

0