Rosetta stone inc (RST)
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'13Dec'12Sep'12Jun'12Mar'12Dec'11Sep'11Jun'11Mar'11
CASH FLOWS FROM OPERATING ACTIVITIES:
Net loss

-6,181

-6,688

-2,917

-2,807

-544

-4,424

-6,489

-4,158

-6,402

2,366

-3,231

-1,135

454

-5,613

-5,452

-8,978

-7,507

-11,436

-7,301

-8,175

-19,884

-21,536

-16,178

-15,751

-20,241

-3,848

-4,169

-3,213

-4,904

4,635

-32,173

-4,544

-1,903

-4,642

-1,177

-4,550

-9,281

Non-cash adjustments to reconcile net loss to cash used in operating activities:
Stock-based compensation expense

2,261

371

1,412

1,356

1,220

1,087

1,452

1,353

583

1,083

1,552

1,359

147

1,449

1,639

1,397

421

1,826

1,974

2,108

1,287

1,294

2,109

1,953

1,406

3,012

2,525

2,036

1,668

1,801

2,477

2,096

1,635

7,376

1,836

1,704

1,437

Loss on foreign currency transactions

-22

-418

-10

517

-708

324

94

125

-245

112

9

175

277

-382

488

818

1,525

-126

350

-323

-1,372

-1,927

756

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Bad debt expense (recovery)

258

105

165

136

-13

58

49

136

-75

92

157

64

-364

238

191

89

191

54

651

542

410

382

551

515

957

738

455

465

-238

485

739

431

165

519

401

92

216

Depreciation and amortization

4,420

4,257

3,938

3,457

3,529

3,725

3,802

3,479

3,610

2,932

3,015

2,987

3,075

3,510

3,226

3,178

3,408

3,485

3,492

3,333

3,350

3,675

3,335

3,460

3,434

2,630

2,409

2,224

2,372

1,847

1,748

2,046

2,436

2,285

2,184

2,141

2,114

Operating lease costs

535

553

545

533

526

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred income tax expense (benefit)

115

334

-195

77

-592

355

320

81

36

-5,164

333

330

300

305

349

336

172

277

193

84

295

-6,551

-652

292

-756

658

-3,904

-912

289

107

27,002

158

-1,314

-1,557

-2,493

5,941

-2,977

Gain loss on disposal or sale of assets

-

0

-5

-1

1,395

-

-

-

-

10

-5

-1

1

-47

-96

-36

0

71

-58

1

1

-3

-72

-3

-106

-32

-41

-64

-141

-31

-372

-348

-32

-300

-2

-1

-15

Amortization of deferred financing costs

19

17

18

19

14

12

34

34

34

58

82

85

71

71

71

70

62

56

36

36

32

21

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Loss on impairment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

358

160

291

-

0

0

2,199

-

0

0

0

-

-

-

-

-

-

-

-

Loss from equity method investments

-

-

-

-

-

-

-

-

-

0

0

-105

5

1

-6

-13

-27

-32

0

9

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net change in:
Restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-6

401

-41

-40

21

-7

-17

-8

38

43

-60

28

18

23

-32

14

13

-5

-23

8

4

5

-28

Accounts receivable

-7,082

-10,202

7,726

12,063

-8,237

-10,533

9,445

9,907

-11,038

-5,226

1,837

6,993

-11,188

-5,769

3,177

5,466

-17,555

-36

5,325

-7,119

-24,546

16,571

12,759

5,064

-17,916

15,149

2,338

3,125

-11,135

10,840

5,165

1,261

-17,575

17,403

-4,358

10,332

-18,319

Inventory

-168

22

-129

-111

829

-747

-433

44

-1,467

-661

-1,673

-571

-361

-1,261

101

738

-116

-378

464

-790

1,957

307

-995

-687

1,034

-398

1,058

-1,298

746

-184

479

-1,189

709

-1,807

-1,121

-652

412

Deferred sales commissions

-1,579

-425

3,470

-335

-1,997

-412

2,841

7

-1,655

-170

1,806

-539

-1,588

-367

1,429

-198

-1,783

-180

2,854

1,506

-59

1,279

2,055

2,557

1,377

-

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses and other current assets

-197

-761

220

30

789

500

-785

-729

639

-276

209

-136

807

-538

-998

372

1,331

-1,140

-1,439

177

1,322

-1,604

183

113

-536

-173

-1,693

298

2,446

-1,207

-13

-146

-503

1,261

-820

-485

-66

Income tax receivable or payable

-71

115

90

320

-271

-337

50

256

91

151

51

-292

537

-671

-1,238

1,527

-337

-1,505

304

189

444

-284

-221

13

639

-436

420

-398

-413

-8,595

-660

1,504

1,236

-6,420

3,991

6,237

2,004

Other assets

71

109

-331

233

-144

118

6

235

166

522

125

-190

-2

-303

-39

-238

-88

479

46

-155

314

527

-236

-47

-690

-64

174

63

-105

-304

-987

-144

1,209

-183

-1,108

1,253

63

Accounts payable

-685

-1,244

304

1,129

-1,595

40

-1,645

1,667

-58

319

-830

426

-1,680

849

707

-2,199

569

294

1,808

-6,337

-4,401

7,509

1,565

-1,192

512

2,741

-1,986

3,156

-209

-863

2,491

-2,281

-587

-1,185

-2,019

3,770

-1,013

Accrued compensation

2,178

933

1,483

-3,468

2,441

-884

3,609

-6,185

1,597

-376

3,842

-5,128

1,731

-722

1,762

-649

2,310

-511

-884

-2,944

-1,146

-3,718

2,681

4,666

-8,123

3,283

-2,621

4,853

-6,412

3,617

-298

3,850

-2,076

2,662

-1,859

3,264

-2,867

Other current liabilities

-1,934

1,723

-574

1,298

-2,622

1,084

-421

-1,135

-2,413

51

-849

-2,663

-2,989

-184

-7,156

2,268

-8,189

7,158

-1,506

-10,834

-9,041

17,620

5,751

-2,592

-9,461

12,342

1,704

-5,543

-4,253

7,325

1,123

207

-8,020

7,691

-4,069

1,476

-1,119

Operating lease liabilities

478

676

515

516

544

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit from stock options exercised

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-334

-13

-18

Other long-term liabilities

-

0

0

0

-31

-

-

-

-

-493

-265

-9,247

8,762

515

206

-64

-99

-68

-97

-96

-225

-78

787

-78

-172

152

-7

-35

371

-55

-1,640

9

1,587

-204

164

-6

-6

Deferred revenue

-13,038

-1,712

36,439

-3,345

-16,700

-1,443

24,949

274

-10,839

242

15,865

8,006

-15,263

-2,545

12,720

608

-10,975

3,761

17,036

2,312

-6,231

18,347

18,854

11,305

358

6,341

9,353

1,206

-2,953

5,807

7,562

2,391

-4,246

4,407

1,942

-69

-1,503

Net cash used in operating activities

-3,482

9,533

29,072

-14,847

-6,567

10,706

14,471

-14,316

-418

6,648

17,312

-10,756

5,756

7,564

6,479

-9,879

-2,546

13,728

7,233

-13,299

-13,307

18,729

6,048

-4,475

-13,629

11,802

-587

2,488

-5,635

23,409

5,424

3,412

2,656

7,390

-2,010

-2,939

932

Purchases of property and equipment

3,786

3,046

4,011

4,995

4,714

5,189

3,564

4,188

3,948

4,041

3,510

3,080

2,313

2,886

3,694

3,348

2,586

1,651

2,052

2,771

2,382

2,509

2,683

3,178

1,366

2,526

2,203

1,684

2,528

1,248

941

1,031

967

2,032

2,443

2,814

2,651

Proceeds from sale of assets

-

0

0

400

996

-

-

-

-

10

0

0

2

0

0

38

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Decrease in restricted cash for Vivity acquisition

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-24,628

0

0

12,314

12,314

0

0

0

-

-

-

-

-

-

-

-

Proceeds from sales of available-for-sale securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-1,599

-4,805

-3,307

1,500

-105

99

1,807

Acquisitions, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

1,688

0

0

1,526

40,161

0

17,495

8,180

0

-

-

-

-

0

0

0

75

Net cash used in investing activities

-3,786

-3,046

-4,011

-4,595

-3,718

-5,189

-3,564

-4,171

-3,948

-4,031

-3,510

-2,970

-2,311

-2,886

-3,694

-3,310

-2,586

-9

-2,244

-3,051

-4,070

-2,509

-2,683

-4,704

-29,213

-14,840

-19,698

-9,864

-2,528

-1,248

658

3,774

2,340

-3,532

-2,338

-2,913

-4,533

Proceeds from the exercise of stock options

42

0

669

2,143

744

689

231

849

467

213

22

367

74

11

10

8

29

0

77

0

37

23

4

188

454

78

581

1,449

349

-

-

-

-

161

559

40

40

Tax benefit of stock options exercised

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

334

13

18

Payment of deferred financing costs

66

0

0

45

2

-

-

-

-

-

-

-

-

1

82

0

100

5

91

7

27

381

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Payments under financing lease liabilities

115

113

109

112

110

105

111

110

115

109

109

102

242

93

102

94

244

243

93

93

282

113

114

305

61

28

17

3

193

210

2

1

2

279

1

2

3

Net cash (used in) provided by financing activities

-139

-113

-9,340

11,886

632

584

116

739

352

104

-176

122

-168

-83

-174

-86

-315

-248

-107

-100

-272

-471

-110

-117

393

-11,385

507

235

156

-178

810

17

-2

-118

892

51

55

Decrease in cash, cash equivalents, and restricted cash

-7,407

6,374

15,721

-7,556

-9,653

6,101

11,023

-17,748

-4,014

2,721

13,626

-13,604

3,277

4,595

2,611

-13,275

-5,447

13,471

4,882

-16,450

-17,649

15,749

3,255

-9,296

-42,449

-14,423

-19,778

-7,141

-8,007

22,144

7,272

6,701

5,557

3,449

-3,747

-5,725

-3,217

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

-486

440

-277

21

-180

176

-124

-469

193

119

162

-95

233

-299

-95

-15

660

-56

-318

329

-1,084

-453

-733

161

-402

144

812

-100

-872

161

380

-502

563

-291

-291

76

329

Net decrease in cash, cash equivalents, and restricted cash

-7,893

6,814

15,444

-7,535

-9,833

6,277

10,899

-18,217

-3,821

2,840

13,788

-13,699

3,510

4,296

2,516

-13,290

-4,787

13,415

4,564

-16,121

-18,733

15,296

2,522

-9,135

-42,851

-14,279

-18,966

-7,241

-8,879

-

-

-

-

-

-

-

-

(Decrease) increase in cash and cash equivalents

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

6,892

7,203

4,994

3,740

-3,456

-5,801

-3,546

SUPPLEMENTAL CASH FLOW DISCLOSURE:
Cash paid during the periods for:
Interest

34

21

101

80

46

55

47

48

49

50

56

45

44

47

50

50

50

51

54

56

57

58

47

50

56

8

9

0

1

-

-

-

-

0

1

1

3

Income taxes, net of refund

207

-88

-110

317

258

284

314

591

437

422

437

144

893

241

210

214

-61

-621

182

577

463

446

242

214

820

545

707

863

1,175

553

1,167

889

1,431

16

463

666

538

Noncash operating, investing and financing activities:
Operating right-of-use assets obtained in exchange for operating lease liabilities

59

-

-

-

656

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accrued purchase price of business acquisition

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

3,375

0

0

-

-

-

-

-

-

-

-

Accrued liability for purchase of property and equipment

1,126

-158

-206

308

1,033

-516

725

-53

1,121

-301

578

82

608

-295

-14

222

357

159

-163

-470

732

183

4

21

353

-955

114

270

763

912

177

-445

584

-449

-576

-540

1,769

Equipment acquired under finance leases

-

-

-

-

-

-

-

-

25

-

0

0

0

0

0

0

27

462

0

0

0

-

-

-

-

-

-

0

586

-

-

-

-

0

0

0

16