Red hat inc (RHT)
CashFlow / TTM
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

461,918

433,988

282,334

289,493

299,727

261,851

341,502

307,836

269,520

255,390

240,935

219,840

212,463

199,365

194,029

195,114

190,542

180,201

177,569

181,661

175,646

178,292

176,197

158,937

153,134

150,204

143,199

146,674

151,637

146,626

144,192

131,969

115,657

107,278

90,158

93,078

0

0

0

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

118,746

109,046

106,092

104,905

102,375

97,138

93,118

89,400

86,424

85,309

82,877

80,865

78,243

76,088

76,092

74,885

75,886

76,263

76,193

76,497

75,397

74,405

72,894

70,065

66,194

62,341

57,867

54,133

52,712

51,372

51,035

50,472

49,014

47,997

46,835

46,448

0

0

0

Amortization of debt discount and transaction costs

14,812

18,765

20,131

21,699

22,699

22,401

22,220

22,043

21,866

21,691

21,518

21,344

21,173

21,003

18,781

0

0

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayments of convertible notes attributable to debt discount

73,974

59,993

33,115

32,563

0

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred income taxes

-

-

-28,231

-29,941

-

-18,695

14,090

27,635

22,527

12,458

-11,386

-19,363

-17,739

-13,673

24,304

17,683

22,501

23,517

7,293

6,661

6,894

13,776

-14,510

-6,412

5,416

5,630

39,225

49,554

44,673

45,702

40,376

31,272

36,551

33,848

39,275

30,424

0

0

0

Share-based compensation expense

213,259

209,096

204,235

200,275

194,536

192,249

194,140

196,563

194,973

192,530

187,141

175,807

170,987

166,234

156,756

146,972

143,040

135,232

129,521

126,088

119,357

113,774

109,150

105,638

99,623

98,698

96,300

90,392

85,286

79,267

72,118

66,688

63,610

60,597

56,746

52,419

0

0

0

Excess tax benefits from share-based payment arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

-20,231

0

0

0

-

-

-

-

-

-

-

-

-

33,533

33,059

31,571

29,931

34,590

37,764

39,844

42,291

41,523

34,279

0

0

0

Net amortization of bond premium on debt securities available for sale

-1,151

-1,623

-2,959

-4,816

-6,712

-8,405

-9,657

-10,664

-11,519

-12,623

-13,332

-13,267

-13,112

-12,169

-11,140

-10,492

-9,878

-9,314

-17,697

-17,591

-12,781

-8,697

-9,948

-5,972

-6,509

-6,889

0

0

0

-

-

-

-

-

-

-

-

-

-

Gain on sale of investments in equity securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

0

0

Other

-7,412

-5,986

12,289

12,777

14,759

11,500

-1,715

-2,915

-2,672

-946

-2,206

-2,073

-2,823

-4,418

185

1,213

1,696

3,474

-398

-1,011

-320

-1,411

-252

738

113

2,626

3,029

2,710

3,479

1,186

3,986

3,080

2,521

2,241

-1,393

-800

0

0

0

Changes in operating assets and liabilities:
Accounts receivable

43,233

188,980

207,812

102,526

63,441

154,119

93,700

52,951

100,671

119,102

26,422

50,237

37,461

48,404

59,335

38,288

38,729

121,536

50,222

49,635

37,627

61,785

56,696

16,657

29,051

46,913

46,447

46,170

47,892

70,410

53,910

42,658

28,995

41,512

32,773

14,677

0

0

0

Other receivables

-24,945

-2,063

27,363

3,918

19,782

4,019

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses

12,987

16,449

26,832

36,797

54,870

68,228

66,061

77,896

57,220

78,617

47,491

37,626

33,432

24,486

23,621

20,511

35,979

40,741

35,121

30,308

33,562

25,122

13,915

10,154

3,676

14,726

17,180

22,928

23,696

19,190

14,187

15,704

19,922

17,220

7,547

-11

0

0

0

Accounts payable and accrued expenses

24,432

54,061

218,208

213,445

188,518

161,834

68,120

28,145

45,898

71,038

43,647

69,946

84,598

62,438

18,820

23,188

16,039

71,040

46,046

32,064

43,700

28,436

35,953

43,560

18,160

40,196

27,199

29,526

19,352

5,986

0

0

0

-

-

-

-

-

-

Deferred revenue

409,645

463,782

475,932

380,096

373,307

432,182

328,382

335,288

348,910

348,534

211,545

244,028

245,964

260,495

264,824

252,072

270,880

282,693

222,312

194,419

202,508

205,357

147,058

126,246

150,796

162,574

177,203

174,042

170,463

176,855

129,707

124,464

115,052

112,724

62,630

45,982

0

0

0

Accounts payable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

0

0

Accrued expenses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

0

0

Other

856

1,513

-98

-1,719

-3,015

-3,639

-372

-100

3,719

5,073

4,990

3,788

1,100

-445

-2,360

-369

-1,083

-2,059

-3,994

-4,882

-2,139

-3,339

-67

307

-4,756

-3,030

-4,011

-3,436

-401

-274

-993

-2,398

-1,668

-2,034

-1,867

-1,822

0

0

0

Net cash provided by operating activities

1,126,577

1,012,782

977,742

1,001,321

1,011,425

923,138

879,334

855,386

809,292

783,717

715,156

727,156

753,443

736,323

709,616

694,245

678,893

628,402

590,093

552,259

563,451

540,580

492,782

497,784

482,708

465,297

456,427

452,827

426,075

391,883

358,869

333,133

320,316

290,748

249,897

241,082

0

0

0

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

109,615

217,951

231,967

158,657

258,601

299,789

370,826

462,398

515,772

500,849

615,163

677,755

711,325

982,935

891,050

852,234

706,188

568,551

785,098

744,806

911,672

772,741

693,053

714,735

682,330

875,428

863,045

1,069,457

1,104,865

962,974

947,343

932,342

821,927

751,420

780,881

597,589

0

0

0

Proceeds from maturities of investment in debt securities available for sale

426,271

402,844

337,249

401,784

401,037

426,074

427,730

405,511

470,718

457,710

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sales of investment in debt securities available for sale

72,865

8,491

188,488

193,781

185,815

199,614

32,686

32,430

39,448

43,273

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sales of strategic equity investments

0

1,300

15,504

15,504

15,504

14,204

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

669,381

693,887

707,703

764,122

751,630

803,289

839,466

741,301

800,840

828,088

846,687

791,585

743,739

738,007

745,125

770,860

698,477

590,873

0

0

0

Acquisition of businesses, net of cash acquired

-

-

0

0

-

-

0

0

-

-

0

0

-

-

0

0

-

296,121

0

0

0

-

-

0

-

-

0

0

-

-

0

0

-

-

0

-

-

0

-

Proceeds from sales of investment in equity securities available for sale

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

7,312

9,307

0

0

0

Purchase of strategic equity investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

0

-

Purchase of developed software and other intangible assets

11,811

10,543

10,976

13,399

17,812

16,720

15,933

14,830

10,680

11,774

14,582

14,356

12,903

13,964

10,306

10,369

9,499

6,123

8,680

7,202

16,181

17,972

15,130

20,025

34,189

34,367

33,544

28,610

5,328

5,349

5,912

14,750

15,015

14,093

13,273

4,873

0

0

0

Payments for property and equipment

71,816

61,266

61,544

59,902

72,030

84,967

86,955

87,612

77,370

69,123

62,530

53,772

48,510

41,553

40,022

43,737

47,750

45,648

52,839

53,965

61,504

79,587

82,952

97,934

96,449

85,671

79,526

62,332

53,511

46,269

38,882

37,846

34,694

32,759

33,827

30,383

0

0

0

Other

503

1,365

1,070

986

1,175

189

605

781

592

703

523

521

1,680

3,569

-5,117

-5,689

-5,810

-11,282

-2,916

-2,284

-1,196

2,084

1,731

1,647

-479

-617

1,358

1,611

0

-

0

0

-

-

-

-

-

-

-

Net cash provided by (used in) investing activities

293,841

109,960

-6,982

147,009

-62,343

-76,854

-97,868

-211,645

-122,915

-110,133

-245,503

-301,948

-309,906

-512,108

-396,793

-456,842

-408,817

-325,003

-470,441

-327,606

-432,079

-108,262

-145,498

-156,502

-108,524

-389,049

-205,617

-478,231

-453,205

-358,860

-383,946

-275,185

-153,837

-54,855

-154,941

-34,033

0

0

0

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

1,569

2,075

2,185

2,129

2,802

4,895

5,096

5,590

5,417

3,829

3,558

3,076

2,867

3,596

4,592

4,334

4,498

2,434

1,965

1,723

1,714

2,122

1,979

6,050

8,041

11,478

12,070

14,915

15,659

16,812

19,642

37,157

51,798

84,443

125,338

114,873

0

0

0

Proceeds from employee stock purchase program

54,301

62,062

60,165

56,331

53,598

50,097

40,443

0

0

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments related to net settlement of share-based compensation awards

136,075

131,895

130,881

135,815

125,590

89,506

89,513

77,475

76,460

66,529

69,337

71,447

72,775

66,907

64,964

58,839

54,944

43,462

43,593

40,146

40,148

37,402

37,495

42,112

42,135

49,984

65,730

45,758

0

-

0

0

-

26,250

0

0

0

-

-

Purchase of treasury stock

262,826

412,845

412,845

500,054

325,034

237,002

376,481

401,799

454,170

458,661

397,354

342,115

0

-

0

0

-

535,062

535,061

200,079

140,060

239,363

275,125

287,125

269,987

120,662

161,168

109,150

144,285

133,220

67,742

67,742

34,730

90,146

131,645

178,831

0

0

0

Proceeds from issuance of convertible notes, net of issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of convertible note hedges

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from issuance of warrants

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds (payments) on other borrowings, net

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

0

-

Proceeds (payments) on other borrowings, net

-

913

1,090

1,235

1,403

1,547

4,261

3,453

2,572

1,684

-176

901

1,749

1,843

1,039

826

2,076

2,782

2,717

2,677

1,354

1,304

1,313

1,156

1,057

1,016

951

816

697

1,027

439

369

275

558

877

877

0

0

0

Excess tax benefits from share-based payment arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

8,663

8,603

10,790

12,837

15,390

20,062

27,052

34,219

33,533

33,059

31,571

29,931

34,590

37,764

39,844

42,291

41,523

34,279

0

0

0

Repayments of convertible notes attributable to principal

514,620

438,410

242,009

237,979

25,989

36

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

0

0

Net cash used in financing activities

-858,239

-919,926

-724,475

-816,623

-421,616

-273,099

-418,271

-434,671

-496,782

-504,193

-493,229

-455,899

-400,466

-327,797

-215,887

218,983

212,266

142,633

151,387

-232,576

-169,058

-263,110

-296,564

-304,281

-278,086

-125,965

-166,357

-109,027

-143,883

-123,836

-49,548

-23,235

28,409

9,780

4,831

-46,002

0

0

0

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

-35,263

-43,852

-38,185

-38,500

10,557

60,139

51,299

30,669

9,297

-6,361

-1,783

9,653

-2,428

-16,113

-38,888

-50,160

-55,568

-45,301

-29,161

-3,490

3,836

-9,550

-14,520

-11,783

-6,716

-12,416

-5,207

-31,451

-30,594

-2,600

6,376

33,518

36,965

8,839

3,666

-845

0

0

0

Net increase in cash, cash equivalents and restricted cash

526,916

158,964

208,100

293,207

538,023

633,324

414,494

239,739

198,892

163,030

-25,359

-21,038

40,643

-119,695

58,048

406,226

426,774

400,731

241,878

-11,413

-33,850

159,658

36,200

25,218

89,382

-62,133

79,246

-165,882

-201,607

-93,413

-68,249

68,231

231,853

254,512

103,453

160,202

0

0

0

Supplemental cash flow information: