Carbonite, inc. (CARB)
CashFlow / TTM
Sep'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
Operating activities
Net (loss) income

-22,508

-7,966

-2,379

7,562

5,229

1,040

347

-4,002

-3,058

652

8,192

-4,099

-8,028

-14,101

-20,081

-21,615

-22,149

-16,882

-14,598

-9,350

-3,899

-4,387

-4,168

-10,605

-13,142

-15,325

-17,239

-18,936

-22,848

-26,894

-27,315

-23,536

0

0

0

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

69,849

58,237

46,858

41,786

35,314

29,102

22,924

21,731

19,681

17,883

16,414

15,869

15,565

15,174

14,619

13,634

13,388

13,011

12,668

12,469

12,506

12,567

12,587

12,590

12,383

12,028

11,553

10,799

10,096

9,422

8,636

7,870

0

0

0

Amortization of right-of-use assets

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of deferred costs

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Gain on disposal of equipment

60

67

285

191

259

120

849

907

663

648

-316

-748

-351

-309

-273

192

25

33

33

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Accretion of discount on marketable securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

9

23

31

38

34

22

17

14

13

5

-30

-92

-158

0

0

0

-

-

-

-

Impairment of other long-lived assets

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Stock-based compensation expense

19,151

18,846

18,075

17,607

16,983

15,255

13,702

12,742

11,492

10,367

9,334

8,900

9,426

9,841

10,091

10,216

9,188

8,084

7,276

6,065

5,414

5,147

4,715

4,777

4,815

4,656

4,494

4,131

3,456

2,852

2,177

1,445

0

0

0

Benefit for deferred income taxes

-15,528

-12,549

-6,281

-16,625

-16,566

-16,745

-18,212

-15,392

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash interest expense related to amortization of debt discount

7,888

7,194

6,509

6,340

6,203

6,069

5,977

4,434

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Gain on sale of businesses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

(Reduction of) provision for reserves on accounts receivable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

41

32

73

48

38

47

-2

0

0

0

Non-cash restructuring charges

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

237

301

220

1,145

0

0

0

-

-

-

-

Other non-cash items, net

893

465

204

139

30

220

82

533

467

461

677

-68

-171

-145

-176

77

-426

-564

-613

-506

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Re-measurement of preferred stock warrant liability

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

8

0

0

0

Changes in assets and liabilities:
Accounts receivable

-7,591

-3,842

1,736

5,996

5,725

4,562

4,042

-1,786

-341

43

3,248

13,412

13,468

13,819

9,543

1,406

531

540

436

-80

195

134

127

303

447

830

534

332

634

288

516

298

0

0

0

Prepaid expenses and other current assets

2,441

2,571

9,234

3,718

2,833

1,094

-724

-254

-1,081

-286

-3,477

1,547

1,866

1,345

3,324

-1,019

-2,448

-15

1,863

830

3,459

1,161

644

586

-207

554

150

575

116

382

743

1,186

0

0

0

Other assets

2,711

2,982

2,907

5,241

5,026

4,214

1,864

580

261

121

870

-17

-1,559

-1,500

-1,771

-2,029

-435

-416

-219

1

747

740

915

947

93

61

6

-42

-76

-1,309

-276

112

0

0

0

Accounts payable

3,117

1,089

-4,015

-7,359

-1,122

513

-2,501

5,035

2,188

1,395

2,500

-3,345

-3,635

-1,667

-831

2,864

3,851

1,611

3,903

1,952

1,552

1,078

-998

-1,395

-964

-930

258

-611

1,836

3,115

1,142

1,935

0

0

0

Accrued expenses and other current liabilities

550

-3,167

9,969

5,636

4,499

3,894

2,710

-995

-297

2,002

3,945

8,183

5,524

4,312

4,755

595

1,690

1,358

-573

1,715

-1,120

-1,352

615

2,373

1,994

2,814

775

-1,151

-958

-404

1,395

833

0

0

0

Other long-term liabilities

-9,327

-7,147

-1,876

-236

-17

-14

401

53

-73

-113

-301

-586

-1,461

-1,641

-1,913

-1,348

207

3,601

4,725

4,496

3,786

686

-181

-99

41

72

64

48

195

162

205

203

0

0

0

Deferred revenue

18,615

17,266

12,869

11,345

8,360

5,720

5,213

6,169

8,135

7,416

3,258

2,384

4,160

6,462

7,900

7,511

7,802

7,504

6,092

5,610

5,812

6,439

7,324

8,794

9,841

12,640

13,317

14,445

16,429

18,215

20,182

20,388

0

0

0

Net cash provided by operating activities

88,064

75,764

69,043

53,590

47,678

37,608

26,925

31,195

27,132

25,271

27,483

13,165

8,021

4,977

3,869

13,197

16,631

18,625

17,925

22,678

19,669

18,035

18,164

14,625

14,806

14,841

12,835

9,195

8,794

8,295

6,583

7,572

0

0

0

Investing activities
Purchases of property and equipment

12,715

11,360

12,602

13,132

15,334

15,107

14,071

17,351

14,811

13,812

11,226

6,582

5,172

7,633

8,365

9,730

12,166

14,361

14,639

14,495

13,409

9,496

9,815

9,801

10,173

10,345

11,622

13,417

14,214

14,771

14,011

13,544

0

0

0

Proceeds from sale of property and equipment and businesses

341

403

581

860

676

929

1,285

1,250

0

0

0

-

-

-

-

286

113

33

33

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from maturities of derivatives

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of derivatives

31

31

31

1,428

1,614

4,010

6,040

5,040

4,829

2,433

1,341

1,476

1,476

1,790

1,288

750

7,016

10,935

13,999

16,499

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from maturities of marketable securities and derivatives

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

13,704

0

0

0

-

-

-

-

Proceeds from sale of businesses

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Decrease in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-693

135

135

964

828

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Payment for intangibles

0

4,500

4,500

5,750

7,000

2,500

2,500

1,250

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payment for acquisition, net of cash acquired

621,703

622,009

489,634

144,597

144,597

154,197

154,661

69,798

69,798

60,198

60,365

11,625

11,958

12,950

12,325

1,325

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-630,878

-633,820

-502,163

-160,030

-165,109

-173,041

-175,823

-91,655

-85,631

-72,810

-68,859

-16,275

-15,606

-16,413

-14,459

8,323

-12,226

-16,260

-18,911

-31,126

-13,388

-8,992

-9,061

-9,297

-30,552

-30,020

-30,507

-29,802

-22,414

-24,175

-16,154

-18,187

0

0

0

Financing activities
Proceeds from exercise of stock options

461

581

664

1,260

1,968

2,592

3,268

4,987

5,698

6,516

5,691

3,560

2,421

1,013

1,292

2,254

4,207

4,453

5,025

4,239

2,702

4,768

4,706

4,728

4,252

1,753

1,166

1,102

826

982

800

990

0

0

0

Payments of withholding taxes in connection with restricted stock unit vesting

1,613

2,583

3,066

2,862

2,700

2,225

2,076

2,050

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from long-term borrowings, net of debt issuance costs

528,980

529,483

530,977

88,068

88,068

88,068

227,718

177,797

177,797

177,797

39,063

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repurchase of common stock

-

-

-

-

-

-

-

-

-

-

-

4,481

7,070

6,976

8,586

5,340

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

22

0

0

0

Net cash provided by financing activities

444,257

573,212

618,939

176,830

198,905

80,702

175,798

127,622

127,616

128,802

42,512

-1,404

-4,980

-6,294

-7,625

-3,417

1,184

1,463

5,025

4,239

2,702

4,768

4,706

4,728

4,252

1,753

1,166

1,102

749

56,614

56,432

56,600

0

0

0

Effect of currency exchange rate changes on cash

-1,448

-321

-1,538

-534

82

614

2,296

1,782

1,066

498

-467

-270

49

4

185

-251

-435

-255

-292

-99

188

-5

-21

-5

-5

-5

-3

4

6

4

5

2

0

0

0

Net decrease in cash, cash equivalents and restricted cash

-

0

184,281

-

-

-54,117

29,196

68,944

70,183

81,761

669

-4,784

-12,516

-17,726

-18,030

17,852

5,154

3,573

3,747

-4,308

9,171

13,806

13,788

10,051

-11,499

-13,431

-16,509

-19,501

-12,865

40,738

46,866

45,987

0

0

0

Supplemental disclosure of cash flow information
Cash (refund) paid for income taxes, net

-

-

0

-

-

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Supplemental disclosure of non-cash investing and financing activities:
Capitalization of stock-based compensation

39

55

2

65

105

145

256

218

201

165

126

83

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accretion of redeemable convertible preferred stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-128

0

0

0

Acquisition of property and equipment included in accounts payable and accrued expenses

-183

1,009

-2,887

-146

-2,931

404

2,392

-641

3,881

-93

1,253

894

-776

-2,060

-716

-1,805

-2,050

1,729

-1,261

853

5,242

2,657

1,069

1,755

0

0

0

-

-

-

-

-

-

-

-

Accrued payment for intangibles

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisition of treasury stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-