Commvault systems inc (CVLT)
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'11Dec'10Sep'10Jun'10Mar'10Dec'09Sep'09Jun'09
Cash flows from operating activities
Net income (loss)

-5,645

-16,743

-2,693

5,282

3,561

4,063

-68,282

-70,183

-61,900

-60,042

862

1,818

-508

6,673

9,592

410

1,720

-2,306

-4,111

11,621

25,650

37,955

52,473

63,331

64,064

65,392

60,001

56,546

53,209

46,066

41,026

35,026

31,940

26,933

27,025

24,545

21,004

21,981

20,169

19,468

18,405

0

0

0

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

17,065

14,566

12,042

11,919

12,060

12,451

12,290

12,072

11,785

11,105

10,795

10,502

10,232

10,243

10,467

10,824

11,179

11,323

11,316

10,233

9,046

7,845

6,636

6,404

6,207

5,928

5,595

5,252

4,939

4,740

4,648

4,581

4,484

4,374

4,236

4,046

3,906

3,766

3,663

3,631

3,630

0

0

0

Noncash stock-based compensation

65,888

77,482

74,340

77,233

80,487

68,577

70,498

72,569

74,129

75,913

77,270

76,152

73,928

71,833

69,950

66,315

64,196

62,678

61,465

61,469

60,663

60,089

58,321

54,031

49,124

43,573

38,311

33,678

30,098

27,443

24,688

22,903

21,426

19,519

17,478

16,489

15,623

14,654

13,982

15,308

14,912

0

0

0

Excess tax benefits from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

6,242

5,177

1,966

5,171

6,664

7,099

7,569

4,053

5,057

12,445

14,881

22,841

28,337

25,079

32,636

28,305

23,080

27,097

19,982

17,467

16,009

9,507

7,386

8,092

7,044

5,289

5,408

3,794

3,395

0

0

0

Deferred income taxes

-1,783

314

437

269

164

-95

56,253

54,962

53,737

49,612

-7,413

-8,710

-11,468

-8,323

-11,122

-11,447

-8,805

-5,611

10

2,949

4,072

-4,192

-5,687

-2,759

-6,430

-4,642

-6,118

-6,325

-2,094

-2,515

-2,024

-4,437

-4,993

6,457

9,071

7,927

7,798

4,655

2,686

4,080

6,471

0

0

0

Equity in loss of affiliate

-

-

-

-

-

-

-

-

-3,621

-695

-837

-833

-958

-627

-327

-169

-83

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of deferred commissions cost

17,717

17,492

17,162

17,236

17,348

17,279

17,164

16,601

16,587

16,595

16,716

16,826

16,065

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Impairment of operating lease assets

2,761

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
Trade accounts receivable

-26,096

-6,561

-38

-10,401

24,092

38,409

16,026

27,507

25,082

14,312

12,184

19,359

16,372

7,077

21,348

9,918

-1,760

4,440

-8,590

-1,045

6,581

12,734

15,892

24,396

33,482

35,207

17,723

19,193

17,939

5,736

-126

-1,236

-5,419

-549

16,547

11,091

14,206

13,774

4,700

3,594

11,801

0

0

0

Operating lease assets and liabilities, net

-1,226

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses and other current assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

13,533

5,922

-1,335

-3,948

-6,762

1,371

220

2,684

5,035

2,405

2,200

4,198

4,424

2,438

2,997

3,756

-52

1,157

2,737

786

0

0

0

Other current assets and Other assets

1,246

-6,561

-4,720

-2,600

-11,400

-10,650

-10,786

-5,268

6,876

8,216

9,380

6,608

55

-2,479

-814

-2,065

-3,867

8,808

10,973

11,750

10,678

-63

462

5

160

-104

-57

2,461

1,844

2,118

2,892

2,583

3,720

3,160

2,467

533

314

641

692

637

97

0

0

0

Deferred commissions cost

16,063

16,554

17,063

17,294

18,967

19,487

19,336

19,416

17,984

18,092

18,325

18,515

18,393

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accounts payable

-2,474

-878

1,442

644

1,485

1,184

176

-86

618

40

72

283

-190

12

-620

-81

-454

-938

-616

-980

-267

-1,717

-2,244

-2,717

-2,695

269

1,389

1,869

2,036

-158

176

61

204

1,071

148

-614

-261

337

119

1,267

27

0

0

0

Accrued liabilities

-1,997

-2,288

17,796

-3,025

5,075

12,493

8,869

12,634

3,496

578

-4,777

7,565

15,088

8,810

8,588

11,467

1,972

11,148

8,372

11,393

13,221

31,223

36,652

39,159

43,187

32,904

35,063

32,551

32,358

35,126

26,825

19,293

29,038

18,422

15,507

17,536

13,469

10,492

9,957

7,009

8,757

0

0

0

Deferred revenue

-6,230

6,089

13,436

10,499

21,719

25,376

22,762

29,851

33,971

38,347

36,016

41,219

36,666

30,233

29,026

20,050

16,935

17,360

18,481

32,074

35,818

37,759

31,705

21,468

25,156

32,930

37,430

46,463

38,041

29,322

29,704

29,843

35,599

28,410

26,710

20,673

17,892

19,451

18,566

20,282

19,967

0

0

0

Other liabilities

-616

-1,691

-980

-780

-60

-487

-1,571

-1,419

-1,933

-944

-77

-131

330

313

243

397

258

-774

-230

-399

-2,040

-2,529

-2,992

-3,003

-1,445

-835

-602

-507

-357

-119

302

560

810

193

-227

-305

-1,701

-57

-25

-70

1,157

0

0

0

Net cash provided by operating activities

88,464

92,594

122,769

116,550

110,180

96,935

97,081

89,006

84,169

89,813

85,371

95,925

100,039

108,233

97,230

86,563

84,413

83,216

87,690

110,300

123,847

127,784

137,707

130,007

119,137

122,099

119,396

119,348

112,683

99,919

100,192

86,816

100,000

88,837

71,110

67,584

52,410

55,627

57,160

60,213

57,247

0

0

0

Cash flows from investing activities
Purchase of short-term investments

43,645

64,988

97,619

151,886

130,338

130,393

130,769

109,604

142,424

112,576

106,871

107,079

96,306

120,747

117,831

107,932

99,071

84,710

72,806

89,373

68,933

59,456

49,970

32,974

28,976

25,978

22,982

0

1,948

1,948

1,948

1,948

3,146

3,146

3,146

3,396

2,751

0

0

0

-

-

-

-

Proceeds from maturity of short-term investments

130,338

130,544

130,919

131,315

131,637

130,842

131,108

131,316

131,480

102,330

93,445

83,546

74,685

84,710

72,805

60,883

49,935

49,956

49,969

53,463

43,973

34,478

22,983

8,000

5,948

2,948

1,948

1,948

3,146

3,146

3,146

3,146

1,150

2,150

5,943

7,794

6,644

0

0

0

-

-

-

-

Purchases for corporate campus headquarters

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,111

11,100

25,982

43,248

59,297

69,043

73,768

71,659

62,214

51,144

32,469

17,702

9,209

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of property and equipment

3,203

3,367

4,019

3,880

6,560

6,854

8,411

9,094

7,047

7,236

6,978

6,865

6,424

5,758

5,245

5,635

6,280

7,049

6,443

6,090

5,784

4,724

4,786

4,976

4,916

7,693

7,665

7,674

7,821

5,441

5,641

5,737

5,796

5,282

4,961

4,610

3,865

4,019

3,391

3,230

3,370

0

0

0

Net cash used in investing activities

-74,005

-95,306

29,281

-24,451

-5,261

-6,405

-8,072

12,618

-17,991

-17,482

-20,404

-30,398

-28,045

-41,881

-54,933

-57,346

-62,189

-57,479

-55,262

-85,248

-90,041

-98,745

-105,541

-101,609

-90,158

-81,867

-61,168

-23,428

-15,832

-5,787

-5,055

-4,761

-7,792

-6,278

-2,164

-212

28

-1,876

-9,334

-10,774

-8,413

0

0

0

Cash flows from financing activities
Repurchase of common stock

77,198

80,040

134,420

147,708

132,697

113,592

139,262

137,233

112,218

0

0

0

-

-

-

-

-

-

-

-

155,125

205,155

155,115

155,115

50,030

0

0

0

-

-

-

-

-

-

-

-

31,506

0

0

0

-

-

-

-

Debt issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,262

1,262

1,175

1,081

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from stock-based compensation plans

37,795

40,099

18,683

29,249

41,984

45,230

43,005

37,942

30,114

24,763

26,603

25,341

21,321

19,336

18,319

14,679

14,843

15,411

15,150

17,227

17,690

16,297

18,462

16,735

17,615

17,426

20,602

18,434

18,128

18,186

18,930

16,672

18,123

17,301

13,702

16,951

17,158

18,155

17,572

14,161

10,284

0

0

0

Excess tax benefits from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

6,242

5,177

1,966

5,171

6,664

7,099

7,569

4,053

5,057

12,445

14,881

22,841

28,337

25,079

32,636

28,305

23,080

27,097

19,982

17,467

16,009

9,507

7,386

8,092

7,044

5,289

5,408

3,794

3,395

0

0

0

Net cash used in financing activities

-39,403

-39,941

-115,737

-118,459

-90,713

-68,362

-96,257

-99,291

-82,104

-90,081

-29,613

-18,707

-22,435

-57,381

-46,201

-71,627

-69,970

-12,070

-52,399

-28,941

-133,640

-177,675

-122,947

-116,620

-4,078

42,505

53,238

46,739

41,208

45,283

38,912

-11,500

-11,507

-18,831

-24,551

6,442

-7,304

-8,062

-8,526

5,050

13,679

0

0

0

Effects of exchange rate — changes in cash

-6,966

-4,720

-11,869

-4,731

-16,998

-9,264

-2,902

57

17,219

15,832

6,183

455

-8,175

-8,955

-1,506

-5,812

-1,820

-12,217

-17,399

-19,185

-20,226

-11,951

-6,812

2,947

-1,132

-2,502

-1,284

-1,976

-1,183

1,877

1,192

-3,431

-783

-1,115

-509

4,307

2,518

1,354

1,078

-813

1,800

0

0

0

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

-31,910

-47,373

24,444

-31,091

-2,792

12,904

-10,150

2,390

1,293

-1,918

41,537

47,275

41,384

16

-5,410

-48,222

-49,566

1,450

-37,370

-23,074

-120,060

-160,587

-97,593

-85,275

23,769

80,235

110,182

140,683

136,876

141,292

135,241

67,124

79,918

62,613

43,886

78,121

47,652

47,043

40,378

53,676

64,313

0

0

0

Supplemental disclosures of cash flow information
Purchases for corporate campus headquarters in accounts payable and accrued liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,111

6,899

5,095

5,991

6,805

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-