Red hat inc (RHT)
CashFlow / Quarterly
May'19Feb'19Nov'18Aug'18May'18Feb'18Nov'17Aug'17May'17Feb'17Nov'16Aug'16May'16Feb'16Nov'15Aug'15May'15Feb'15Nov'14Aug'14May'14Feb'14Nov'13Aug'13May'13Feb'13Nov'12Aug'12May'12Feb'12Nov'11Aug'11May'11Feb'11Nov'10Aug'10May'10Nov'09Aug'09
Cash flows from operating activities:
Net Income (Loss) Attributable to Parent

141,120

139,494

94,450

86,854

113,190

-12,160

101,609

97,088

75,314

67,491

67,943

58,772

61,184

53,036

46,848

51,395

48,086

47,700

47,933

46,823

37,745

45,068

52,025

40,808

40,391

42,973

34,765

35,005

37,461

35,968

38,240

39,968

32,450

33,534

26,017

23,656

24,071

16,414

28,937

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

36,754

28,551

26,775

26,666

27,054

25,597

25,588

24,136

21,817

21,577

21,870

21,160

20,702

19,145

19,858

18,538

18,547

19,149

18,651

19,539

18,924

19,079

18,955

18,439

17,932

17,568

16,126

14,568

14,079

13,094

12,392

13,147

12,739

12,757

11,829

11,689

11,722

11,595

11,442

Amortization of debt discount and transaction costs

1,885

4,295

4,062

4,570

5,838

5,661

5,630

5,570

5,540

5,480

5,453

5,393

5,365

5,307

5,279

5,222

5,195

-

3,085

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayments of convertible notes attributable to debt discount

13,981

26,878

552

32,563

0

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred income taxes

-

-

1,983

-293

-

-26,526

273

-359

7,917

6,259

13,818

-5,467

-2,152

-17,585

5,841

-3,843

1,914

20,392

-780

975

2,930

4,168

-1,412

1,208

9,812

-24,118

6,686

13,036

10,026

9,477

17,015

8,155

11,055

4,151

7,911

13,434

8,352

9,578

-940

Share-based compensation expense

50,168

54,127

56,278

52,686

46,005

49,266

52,318

46,947

43,718

51,157

54,741

45,357

41,275

45,768

43,407

40,537

36,522

36,290

33,623

36,605

28,714

30,579

30,190

29,874

23,131

25,955

26,678

23,859

22,206

23,557

20,770

18,753

16,187

16,408

15,340

15,675

13,174

12,557

11,013

Excess tax benefits from share-based payment arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

-2,244

-8,756

-2,812

-6,419

-

-

-

-

-

-

-

-

-

8,100

9,600

10,200

5,633

7,626

8,112

8,560

10,292

10,800

10,192

11,007

9,524

3,556

Net amortization of bond premium on debt securities available for sale

-271

-81

-256

-543

-743

-1,417

-2,113

-2,439

-2,436

-2,669

-3,120

-3,294

-3,540

-3,378

-3,055

-3,139

-2,597

-2,349

-2,407

-2,525

-2,033

-10,732

-2,301

2,285

2,051

-11,983

1,675

1,748

1,671

-

-

-

-

-

-

-

-

-

-

Gain on sale of investments in equity securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,726

601

-516

4,584

3,465

Other

872

-5,457

-274

-2,553

2,298

12,818

214

-571

-961

-397

-986

-328

765

-1,657

-853

-1,078

-830

2,946

175

-595

948

-926

-438

96

-143

233

552

-529

2,370

636

233

240

77

3,436

-673

-319

-203

-198

-80

Changes in operating assets and liabilities:
Accounts receivable

-445,186

247,186

219,184

22,049

-299,439

266,018

113,898

-17,036

-208,761

205,599

73,149

30,684

-190,330

112,919

96,964

17,908

-179,387

123,850

75,917

18,349

-96,580

52,536

75,330

6,341

-72,422

47,447

35,291

18,735

-54,560

46,981

35,014

20,457

-32,042

30,481

23,762

6,794

-19,525

21,742

5,666

Other receivables

12,278

-45,618

23,310

-14,915

35,160

-16,192

-135

949

19,397

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses

-28,844

51,014

-2,903

-6,280

-25,382

61,397

7,062

11,793

-12,024

59,230

18,897

-8,883

9,373

28,104

9,032

-13,077

427

27,239

5,922

2,391

5,189

21,619

1,109

5,645

-3,251

10,412

-2,652

-833

7,799

12,866

3,096

-65

3,293

7,863

4,613

4,153

591

-1,810

-2,945

Accounts payable and accrued expenses

-58,271

15,441

40,325

26,937

-28,642

179,588

35,562

2,010

-55,326

85,874

-4,413

19,763

-30,186

58,483

21,886

34,415

-52,346

14,865

26,254

27,266

2,655

-10,129

12,272

38,902

-12,609

-2,612

19,879

13,502

9,427

-15,609

22,206

3,328

-3,939

-

-

-

-

-

-

Deferred revenue

-158,729

449,049

153,111

-33,786

-104,592

461,199

57,275

-40,575

-45,717

357,399

64,181

-26,953

-46,093

220,410

96,664

-25,017

-31,562

224,739

83,912

-6,209

-19,749

164,358

56,019

1,880

-16,900

106,059

35,207

26,430

-5,122

120,688

32,046

22,851

1,270

73,540

26,803

13,439

-1,058

23,446

10,155

Accounts payable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,544

2,187

-5,069

-843

4,790

Accrued expenses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

16,343

6,712

1,540

14,651

5,214

Other

143

-451

643

521

800

-2,062

-978

-775

176

1,205

-706

3,044

1,530

1,122

-1,908

356

-15

-793

83

-358

-991

-2,728

-805

2,385

-2,191

544

-431

-2,678

-465

-437

144

357

-338

-1,156

-1,261

1,087

-704

-989

-1,216

Net cash provided by operating activities

459,954

397,103

136,728

132,792

346,159

362,063

160,307

142,896

257,872

318,259

136,359

96,802

232,297

249,698

148,359

123,089

215,177

222,991

132,988

107,737

164,686

184,682

95,154

118,929

141,815

136,884

100,156

103,853

124,404

128,014

96,556

77,101

90,212

95,000

70,820

64,284

60,644

54,149

62,005

Cash flows from investing activities:
Cash flows from investing activities:
Purchase of investment in debt securities available for sale

0

0

99,890

9,725

108,336

14,016

26,580

109,669

149,524

85,053

118,152

163,043

134,601

199,367

180,744

196,613

406,211

107,482

141,928

50,567

268,574

324,029

101,636

217,433

129,643

244,341

123,318

185,028

322,741

231,958

329,730

220,436

180,850

216,327

314,729

110,021

110,343

245,788

131,437

Proceeds from maturities of investment in debt securities available for sale

110,431

143,384

66,406

106,050

87,004

77,789

130,941

105,303

112,041

79,445

108,722

170,510

99,033

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sales of investment in debt securities available for sale

64,899

0

0

7,966

525

179,997

5,293

0

14,324

13,069

5,037

7,018

18,149

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sales of strategic equity investments

0

0

0

0

1,300

14,204

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sales and maturities of investment in debt securities available for sale

-

-

-

-

-

-

-

-

-

-

-

-

-

-

235,931

170,617

182,583

-

93,578

140,101

269,431

166,271

118,084

153,917

325,850

153,779

169,743

190,094

227,685

213,318

196,991

208,693

172,583

165,472

191,259

215,811

198,318

93,089

83,655

Acquisition of businesses, net of cash acquired

-

-

11,550

0

-

-

0

83,965

-

-

0

28,667

-

-

125,011

1,700

-

0

78,317

66,183

151,621

-

-

0

-

-

21,188

10,051

-

-

135,210

0

-

-

31,381

-

-

0

-

Proceeds from sales of investment in equity securities available for sale

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

665

-

1,843

609

548

4,312

3,838

Purchase of strategic equity investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

1,368

-

Purchase of developed software and other intangible assets

4,134

3,416

1,003

3,258

2,866

3,849

3,426

7,671

1,774

3,062

2,323

3,521

2,868

5,870

2,097

2,068

3,929

2,212

2,160

1,198

553

4,769

682

10,177

2,344

1,927

5,577

24,341

2,522

1,104

643

1,059

2,543

1,667

9,481

1,324

1,621

847

1,081

Payments for property and equipment

23,513

16,421

18,229

13,653

12,963

16,699

16,587

25,781

25,900

18,687

17,244

15,539

17,653

12,094

8,486

10,277

10,696

10,563

12,201

14,290

8,594

17,754

13,327

21,829

26,677

21,119

28,309

20,344

15,899

14,974

11,115

11,523

8,657

7,587

10,079

8,371

6,722

8,655

6,635

Other

124

379

0

0

986

84

-84

189

0

500

92

0

111

320

90

1,159

2,000

-8,366

-482

1,038

-3,472

0

150

2,126

-192

-353

66

0

-330

-

1,622

319

-

-

-

-

-

-

-

Net cash provided by (used in) investing activities

147,559

123,168

-64,266

87,380

-36,322

6,226

89,725

-121,972

-50,833

-14,788

-24,052

-33,242

-38,051

-150,158

-80,497

-41,200

-240,253

-34,843

-140,546

6,825

-156,439

-180,281

2,289

-97,648

167,378

-217,517

-8,715

-49,670

-113,147

-34,085

-281,329

-24,644

-18,802

-59,171

-172,568

96,704

80,180

-159,257

-51,660

Cash flows from financing activities:
Proceeds from exercise of common stock options

369

244

767

189

875

354

711

862

2,968

555

1,205

689

1,380

284

723

480

2,109

1,280

465

644

45

811

223

635

453

668

4,294

2,626

3,890

1,260

7,139

3,370

5,043

4,090

24,654

18,011

37,688

44,985

14,189

Proceeds from employee stock purchase program

7,501

18,706

14,409

13,685

15,262

16,809

10,575

10,952

11,761

-

7,155

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments related to net settlement of share-based compensation awards

81,274

4,290

32,873

17,638

77,094

3,276

37,807

7,413

41,010

3,283

25,769

6,398

31,079

6,091

27,879

7,726

25,211

4,148

21,754

3,831

13,729

4,279

18,307

3,833

10,983

4,372

22,924

3,856

18,832

-

20,118

2,952

-

3,161

14,899

1,135

7,055

-

-

Purchase of treasury stock

0

0

12,791

250,035

150,019

0

100,000

75,015

61,987

139,479

125,318

127,386

66,478

-

78,172

70,079

-

1

375,000

80,028

80,033

0

40,018

20,009

179,336

35,762

52,018

2,871

30,011

76,268

0

38,006

18,946

10,790

0

4,994

74,362

52,289

47,186

Proceeds from issuance of convertible notes, net of issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

790,394

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of convertible note hedges

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

148,040

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from issuance of warrants

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

79,776

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds (payments) on other borrowings, net

26

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

335

-

-

0

-

Proceeds (payments) on other borrowings, net

-

163

201

250

299

340

346

418

443

3,054

-462

-463

-445

1,194

615

385

-351

390

402

1,635

355

325

362

312

305

334

205

213

264

269

70

94

594

-319

0

0

877

0

0

Excess tax benefits from share-based payment arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,488

423

986

3,766

3,428

2,610

3,033

6,319

8,100

9,600

10,200

5,633

7,626

8,112

8,560

10,292

10,800

10,192

11,007

9,524

3,556

Repayments of convertible notes attributable to principal

102,163

196,431

4,036

211,990

25,953

30

6

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other

-

-

-

-

-

-

-

-

-

-

-84

415

500

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-9,033

-

-

-

-

-6,754

-502

Net cash used in financing activities

-175,541

-181,934

-34,725

-466,039

-237,228

13,517

-126,873

-71,032

-88,711

-131,655

-143,273

-133,143

-96,122

-120,691

-105,943

-77,710

-23,453

-8,781

328,927

-84,427

-93,086

-27

-55,036

-20,909

-187,138

-33,481

-62,753

5,286

-35,017

-73,873

-5,423

-29,570

-14,970

415

20,890

22,074

-33,599

-4,534

-29,943

Effect of foreign currency exchange rates on cash, cash equivalents and restricted cash

-19,672

5,487

-1,980

-19,098

-28,261

11,154

-2,295

29,959

21,321

2,314

-22,925

8,587

5,663

6,892

-11,489

-3,494

-8,022

-15,883

-22,761

-8,902

2,245

257

2,910

-1,576

-11,141

-4,713

5,647

3,491

-16,841

2,496

-20,597

4,348

11,153

11,472

6,545

7,795

-16,973

6,299

2,034

Net increase in cash, cash equivalents and restricted cash

412,300

343,824

35,757

-264,965

44,348

392,960

120,864

-20,149

139,649

174,130

-53,891

-60,996

103,787

-14,259

-49,570

685

-56,551

163,484

298,608

21,233

-82,594

4,631

45,317

-1,204

110,914

-118,827

34,335

62,960

-40,601

22,552

-210,793

27,235

67,593

47,716

-74,313

190,857

90,252

-103,343

-17,564

Supplemental cash flow information: