Rosetta stone inc (RST)
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

-18,593

-12,956

-10,692

-14,264

-15,615

-21,473

-14,683

-11,425

-8,402

-1,546

-9,525

-11,746

-19,589

-27,550

-33,373

-35,222

-34,419

-46,796

-56,896

-65,773

-73,349

-73,706

-56,018

-44,009

-31,471

-16,134

-7,651

-35,655

-36,986

-33,985

-43,262

-12,266

-12,272

-19,650

0

0

0

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

5,400

4,359

5,075

5,115

5,112

4,475

4,471

4,571

4,577

4,141

4,507

4,594

4,632

4,906

5,283

5,618

6,329

7,195

6,663

6,798

6,643

6,762

8,480

8,896

8,979

9,241

8,030

7,982

8,042

8,009

13,584

12,943

12,551

12,353

0

0

0

Loss on foreign currency transactions

67

-619

123

227

-165

298

86

1

51

573

79

558

1,201

2,449

2,705

2,567

1,426

-1,471

-3,272

-2,866

-2,543

-1,171

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Bad debt expense (recovery)

664

393

346

230

230

168

202

310

238

-51

95

129

154

709

525

985

1,438

1,657

1,985

1,885

1,858

2,405

2,761

2,665

2,615

1,420

1,167

1,451

1,417

1,820

1,854

1,516

1,177

1,228

0

0

0

Depreciation and amortization

16,072

15,181

14,649

14,513

14,535

14,616

13,823

13,036

12,544

12,009

12,587

12,798

12,989

13,322

13,297

13,563

13,718

13,660

13,850

13,693

13,820

13,904

12,859

11,933

10,697

9,635

8,852

8,191

8,013

8,077

8,515

8,951

9,046

8,724

0

0

0

Operating lease costs

2,166

2,157

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred income tax expense (benefit)

331

-376

-355

160

164

792

-4,727

-4,714

-4,465

-4,201

1,268

1,284

1,290

1,162

1,134

978

726

849

-5,979

-6,824

-6,616

-7,667

-458

-3,710

-4,914

-3,869

-4,420

26,486

27,556

25,953

24,289

-5,206

577

-1,086

0

0

0

Gain loss on disposal or sale of assets

-

1,389

0

0

0

-

-

-

-

5

-52

-143

-178

-179

-61

-23

14

15

-59

-73

-77

-184

-213

-182

-243

-278

-277

-608

-892

-783

-1,052

-682

-335

-318

0

0

0

Amortization of deferred financing costs

73

68

63

79

94

114

160

208

259

296

309

298

283

274

259

224

190

160

125

89

53

21

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Loss on impairment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

Loss from equity method investments

-

-

-

-

-

-

-

-

-

-100

-99

-105

-13

-45

-78

-72

-50

-23

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net change in:
Restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

314

341

-67

-43

-11

6

56

13

49

29

9

37

23

18

-10

-1

-7

-16

-6

-11

0

0

0

Accounts receivable

2,505

1,350

1,019

2,738

582

-2,219

3,088

-4,520

-7,434

-7,584

-8,127

-6,787

-8,314

-14,681

-8,948

-6,800

-19,385

-26,376

-9,769

-2,335

9,848

16,478

15,056

4,635

2,696

9,477

5,168

7,995

6,131

-309

6,254

-3,269

5,802

5,058

0

0

0

Inventory

-386

611

-158

-462

-307

-2,603

-2,517

-3,757

-4,372

-3,266

-3,866

-2,092

-783

-538

345

708

-820

1,253

1,938

479

582

-341

-1,046

1,007

396

108

322

-257

-148

-185

-1,808

-3,408

-2,871

-3,168

0

0

0

Deferred sales commissions

1,131

713

726

97

439

781

1,023

-12

-558

-491

-688

-1,065

-724

-919

-732

693

2,397

4,121

5,580

4,781

5,832

7,268

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses and other current assets

-708

278

1,539

534

-225

-375

-1,151

-157

436

604

342

-865

-357

167

-435

-876

-1,071

-1,080

-1,544

78

14

-1,844

-413

-2,289

-2,104

878

-156

1,524

1,080

-1,869

599

-208

-547

-110

0

0

0

Income tax receivable or payable

454

254

-198

-238

-302

60

548

549

1

447

-375

-1,664

155

-719

-1,553

-11

-1,349

-568

653

128

-48

147

-5

636

225

-827

-8,986

-10,066

-8,164

-6,515

-4,340

311

5,044

5,812

0

0

0

Other assets

82

-133

-124

213

215

525

929

1,048

623

455

-370

-534

-582

-668

114

199

282

684

732

450

558

-446

-1,037

-627

-517

68

-172

-1,333

-1,540

-226

-105

-226

1,171

25

0

0

0

Accounts payable

-496

-1,406

-122

-2,071

-1,533

4

283

1,098

-143

-1,765

-1,235

302

-2,323

-74

-629

472

-3,666

-8,636

-1,421

-1,664

3,481

8,394

3,626

75

4,423

3,702

98

4,575

-862

-1,240

-1,562

-6,072

-21

-447

0

0

0

Accrued compensation

1,126

1,389

-428

1,698

-1,019

-1,863

-1,355

-1,122

-65

69

-277

-2,357

2,122

2,701

2,912

266

-2,029

-5,485

-8,692

-5,127

2,483

-4,494

2,507

-2,795

-2,608

-897

-563

1,760

757

5,093

4,138

2,577

1,991

1,200

0

0

0

Other current liabilities

513

-175

-814

-661

-3,094

-2,885

-3,918

-4,346

-5,874

-6,450

-6,685

-12,992

-8,061

-13,261

-5,919

-269

-13,371

-14,223

-3,761

3,496

11,738

11,318

6,040

1,993

-958

4,250

-767

-1,348

4,402

635

1,001

-4,191

-2,922

3,979

0

0

0

Operating lease liabilities

2,185

2,251

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit from stock options exercised

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-365

0

0

0

Other long-term liabilities

-

-31

0

0

0

-

-

-

-

-1,243

-235

236

9,419

558

-25

-328

-360

-486

-496

388

406

459

689

-105

-62

481

274

-1,359

-1,315

-99

-248

1,556

1,541

-52

0

0

0

Deferred revenue

18,344

14,682

14,951

3,461

7,080

12,941

14,626

5,542

13,274

8,850

6,063

2,918

-4,480

-192

6,114

10,430

12,134

16,878

31,464

33,282

42,275

48,864

36,858

27,357

17,258

13,947

13,413

11,622

12,807

11,514

10,114

4,494

2,034

4,777

0

0

0

Net cash used in operating activities

20,276

17,191

18,364

3,763

4,294

10,443

6,385

9,226

12,786

18,960

19,876

9,043

9,920

1,618

7,782

8,536

5,116

-5,645

-644

-1,829

6,995

6,673

-254

-6,889

74

8,068

19,675

25,686

26,610

34,901

18,882

11,448

5,097

3,373

0

0

0

Purchases of property and equipment

15,838

16,766

18,909

18,462

17,655

16,889

15,741

15,687

14,579

12,944

11,789

11,973

12,241

12,514

11,279

9,637

9,060

8,856

9,714

10,345

10,752

9,736

9,753

9,273

7,779

8,941

7,663

6,401

5,748

4,187

4,971

6,473

8,256

9,940

0

0

0

Proceeds from sale of assets

-

1,396

0

0

0

-

-

-

-

12

2

2

40

38

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Decrease in restricted cash for Vivity acquisition

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-12,314

24,628

24,628

24,628

12,314

0

0

0

-

-

-

-

-

-

-

-

Proceeds from sales of available-for-sale securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-9,711

-8,211

-6,717

-1,813

3,301

0

0

0

Acquisitions, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,688

1,688

1,688

3,214

41,687

41,687

59,182

65,836

25,675

0

0

0

-

-

-

-

75

0

0

0

Net cash used in investing activities

-15,438

-15,370

-17,513

-17,066

-16,642

-16,872

-15,714

-15,660

-14,459

-12,822

-11,677

-11,861

-12,201

-12,476

-9,599

-8,149

-7,890

-9,374

-11,874

-12,313

-13,966

-39,109

-51,440

-68,455

-73,615

-46,930

-33,338

-12,982

656

5,524

3,240

244

-6,443

-13,316

0

0

0

Proceeds from the exercise of stock options

2,854

3,556

4,245

3,807

2,513

2,236

1,760

1,551

1,069

676

474

462

103

58

47

114

106

114

137

64

252

669

724

1,301

2,562

2,457

0

0

0

-

-

-

-

800

0

0

0

Tax benefit of stock options exercised

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

365

0

0

0

Payment of deferred financing costs

111

47

0

0

0

-

-

-

-

-

-

-

-

183

187

196

203

130

506

415

408

381

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Payments under financing lease liabilities

449

444

436

438

436

441

445

443

435

562

546

539

531

533

683

674

673

711

581

602

814

593

508

411

109

241

423

408

406

215

284

283

284

285

0

0

0

Net cash (used in) provided by financing activities

2,294

3,065

3,762

13,218

2,071

1,791

1,311

1,019

402

-118

-305

-303

-511

-658

-823

-756

-770

-727

-950

-953

-970

-305

-11,219

-10,602

-10,250

-10,487

720

1,023

805

647

707

789

823

880

0

0

0

Decrease in cash, cash equivalents, and restricted cash

7,132

4,886

4,613

-85

-10,277

-4,638

-8,018

-5,415

-1,271

6,020

7,894

-3,121

-2,792

-11,516

-2,640

-369

-3,544

-15,746

-13,468

-15,095

-7,941

-32,741

-62,913

-85,946

-83,791

-49,349

-12,782

14,268

28,110

41,674

22,979

11,960

-466

-9,240

0

0

0

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

-302

4

-260

-107

-597

-224

-281

5

379

419

1

-256

-176

251

494

271

615

-1,129

-1,526

-1,941

-2,109

-1,427

-830

715

454

-16

1

-431

-833

602

150

-521

57

-177

0

0

0

Net decrease in cash, cash equivalents, and restricted cash

6,830

4,890

4,353

-192

-10,874

-4,862

-8,299

-5,410

-892

6,439

7,895

-3,377

-2,968

-11,265

-2,146

-98

-2,929

-16,875

-14,994

-17,036

-10,050

-34,168

-63,743

-85,231

-83,337

-49,365

0

0

0

-

-

-

-

-

-

-

-

(Decrease) increase in cash and cash equivalents

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

22,829

12,481

-523

-9,063

0

0

0

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

236

248

282

228

196

199

194

203

200

195

192

186

191

197

201

205

211

218

225

218

212

211

161

123

73

18

0

0

0

-

-

-

-

5

0

0

0

Income taxes, net of refund

326

377

749

1,173

1,447

1,626

1,764

1,887

1,440

1,896

1,715

1,488

1,558

604

-258

-286

77

601

1,668

1,728

1,365

1,722

1,821

2,286

2,935

3,290

3,298

3,758

3,784

4,040

3,503

2,799

2,576

1,683

0

0

0

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

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accrued purchase price of business acquisition

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,375

0

0

0

-

-

-

-

-

-

-

-

Accrued liability for purchase of property and equipment

1,070

977

619

1,550

1,189

1,277

1,492

1,345

1,480

967

973

381

521

270

724

575

-117

258

282

449

940

561

-577

-467

-218

192

2,059

2,122

1,407

1,228

-133

-886

-981

204

0

0

0

Equipment acquired under finance leases

-

-

-

-

-

-

-

-

0

-

0

0

0

27

489

489

489

462

0

0

0

-

-

-

-

-

-

0

0

-

-

-

-

16

0

0

0