Open text corp (OTEX)
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'09Mar'09Dec'08Sep'08
Cash flows from operating activities:
Net income for the period

279,960

326,753

323,696

285,637

275,515

261,522

241,978

242,300

226,665

189,577

149,694

1,025,915

1,065,990

1,113,386

1,156,094

284,495

266,931

224,314

211,066

234,406

253,785

273,090

252,096

218,074

172,098

152,113

159,721

148,520

114,319

123,282

109,617

125,174

145,795

146,851

136,518

123,203

147,778

125,062

109,153

89,212

55,526

64,447

44,007

56,938

0

0

0

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

489,514

459,806

463,454

470,928

471,459

470,161

467,509

456,929

442,323

421,832

380,329

345,715

305,206

267,889

253,779

242,368

244,391

248,236

244,417

240,147

231,756

220,914

197,244

186,177

176,977

170,895

184,973

186,851

179,768

173,650

167,539

159,485

154,971

148,514

139,116

129,130

123,688

118,383

115,734

113,837

104,339

101,978

98,550

93,004

0

0

0

Share-based compensation expense

28,148

28,004

27,106

26,770

27,273

25,641

25,914

27,594

28,607

30,188

30,602

30,507

29,271

28,576

27,585

25,978

25,187

25,783

24,131

22,047

20,139

17,995

19,743

19,906

21,129

20,588

17,085

15,575

14,844

16,132

16,355

18,097

16,283

14,212

13,552

11,308

11,042

9,282

8,675

9,765

8,229

8,319

7,299

5,032

0

0

0

Employee long-term incentive plan

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

Excess tax (benefits) expense on share-based compensation expense

-

-

-

-

-

-

-

-

-

-

-

1,534

1,559

732

451

230

321

88

1,064

1,675

1,780

2,390

2,166

1,844

1,978

1,385

636

915

625

2,839

2,743

2,723

3,021

1,821

1,788

1,888

1,816

1,008

884

1,143

1,153

2,675

15,951

8,631

0

0

0

Undistributed earnings related to minority interest

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Pension Cost (Reversal of Cost)

5,535

5,265

4,915

4,624

4,316

4,123

3,848

3,738

3,774

3,701

3,738

3,893

4,071

4,313

4,600

4,577

4,653

4,699

4,743

4,796

4,870

4,864

4,099

3,232

2,720

1,768

1,559

1,448

1,340

1,289

1,230

1,125

642

627

566

552

36

32

142

211

815

881

1,569

1,377

0

0

0

Amortization of debt issuance costs

4,599

4,449

4,379

4,330

4,045

4,271

4,426

4,646

5,068

4,892

4,989

5,014

4,989

5,020

4,845

4,678

4,616

4,593

4,569

4,556

4,541

4,422

3,809

3,191

2,592

2,095

2,111

2,123

2,128

2,197

1,910

1,703

1,513

1,270

1,356

1,359

1,338

1,323

1,457

1,390

1,332

1,283

1,141

1,099

0

0

0

Amortization of deferred charges and credits

-

-

-

-

-

-

-

4,242

3,035

4,240

5,269

6,298

9,091

9,597

9,432

9,903

9,882

9,860

10,511

10,525

10,560

10,636

10,971

11,307

11,835

11,891

11,853

11,815

11,742

12,058

11,836

11,579

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Unrealized gain on financial instruments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

878

2,426

6,361

4,794

1,682

0

0

0

Loss on sale and write down of property and equipment

0

-10

-1,649

-9,438

-11,183

-11,499

-9,860

-2,234

-1,273

-947

-947

-784

0

0

0

-

-

-

-

-

-

-

-

-15

-15

-15

-43

-24

-24

-24

-36

-203

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Release of unrealized gain on marketable securities to income

-

-

-

-

-

-

-

841

841

841

841

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,353

0

0

0

-

-

0

0

Deferred taxes

72,829

72,684

45,900

47,425

38,403

54,271

91,558

89,736

81,689

41,412

10,576

-871,195

-929,013

-914,825

-926,101

-54,461

-26,233

-23,666

-17,217

-14,578

-12,168

-7,917

-12,010

-12,334

-2,637

-7,842

-8,526

-5,796

-65,062

-72,986

-63,082

-78,792

-28,082

-20,906

-32,447

-17,779

-31,294

-26,750

-21,443

-24,219

-10,051

-15,129

-12,615

-9,914

0

0

0

Income (Loss) from Equity Method Investments

9,523

7,700

12,000

13,700

17,152

14,100

8,900

6,000

-700

-200

-29

6,000

6,200

6,000

5,529

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other non-cash charges

-

-

-

-

-

-

-

-

-

-

-

1,033

1,033

1,033

1,033

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Impairment and other non cash charges

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

44

2,744

1,389

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

-108,919

-44,558

-60,064

-75,508

-85,909

-60,440

-46,147

22,566

145,387

176,698

137,791

126,784

50,262

1,439

26,952

-8,985

11,219

-13,820

-39,752

-43,189

-40,245

-13,887

-9,579

17,186

-21,707

-6,735

-27,301

-17,965

-29,970

-25,752

-3,107

-5,319

13,602

9,497

6,024

-200

-5,106

-32,804

-44,471

-24,521

-19,817

-12,358

-79,635

-43,761

0

0

0

Contract assets

35,416

41,882

39,478

37,623

28,872

13,400

5,346

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses and other current assets

7,679

13,852

12,163

819

-2,766

-10,641

-5,266

7,274

12,067

25,034

9,385

7,766

3,329

-11,588

6,707

-316

2,122

2,224

-2,449

3,534

-25,770

-14,610

-14,429

-11,146

12,322

1,303

2,214

-4,242

1,033

8,736

4,897

2,079

1,398

-10,563

-10,203

-1,833

-616

-1,820

124

814

641

4,933

8,224

3,080

0

0

0

Income taxes

-28,323

9,076

21,783

27,291

11,751

-15,582

-27,910

-31,323

-25,321

9,520

4,244

-1,683

4,574

-3,620

5,718

6,294

4,869

-8,372

-11,076

2,933

7,084

20,498

21,612

11,308

3,432

-756

-13,924

-17,053

54,644

51,830

57,950

68,601

-13,326

-24,532

-8,394

9,444

45,124

49,929

42,715

5,066

-4,620

8,801

13,756

23,274

0

0

0

Deferred charges and credits

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-9,870

2,984

350

6,138

9,274

-5,623

7,818

13,425

22,035

23,977

14,457

10,392

29,071

0

0

0

-

-

-

-

-

-

-

-

Accounts payable and accrued liabilities

-33,351

-25,219

-44,710

-21,732

-30,016

-48,899

-67,175

-91,650

-55,309

4,986

19,613

53,490

38,284

-14,847

12,052

-5,671

3,599

-207

-36,897

-22,714

-57,347

-62,958

-52,524

-36,478

-47,649

-32,173

-39,785

-41,947

-24,218

-22,215

-17,242

-18,394

-20,527

-16,684

-16,613

-21,197

-21,896

-26,118

-30,479

-11,340

-8,735

-6,487

-4,482

-15,999

0

0

0

Deferred revenue

12,319

3,231

-5,593

-1,827

-14,941

15,324

16,706

35,629

71,271

2,380

-8,887

3,484

-10,428

-3,850

1,503

-4,781

12,634

-9,153

1,137

6,775

3,284

23,990

8,406

16,601

7,248

2,022

4,928

5,418

5,114

16,487

10,347

-4,581

6,422

-22,296

-15,026

10,738

16,919

2,334

8,280

3,077

-6,586

-5,277

132

-6,861

0

0

0

Other assets

-3,132

2,566

-3,236

4

-7,668

-7,002

-5,024

-497

17,935

17,865

18,342

21,699

6,705

6,780

5,558

-2,163

806

-1,912

488

5,031

4,550

8,592

6,718

5,858

4,753

1,469

1,688

494

-4,509

-4,750

-1,623

-2,419

1,134

2,490

527

2,660

29,086

27,265

25,916

23,196

-1,139

2,099

1,125

2,622

0

0

0

Operating lease assets and liabilities, net

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by operating activities

904,063

860,459

842,324

876,278

850,561

835,153

812,236

708,081

607,601

493,315

434,148

440,353

455,893

489,534

506,451

525,722

538,419

491,586

477,222

523,031

526,128

524,431

475,734

417,127

347,430

322,844

336,663

318,502

333,131

312,901

282,905

266,490

238,601

224,330

219,635

223,221

236,484

232,158

224,623

180,191

153,598

148,484

155,859

176,170

0

0

0

Cash flows from investing activities:
Additions of property and equipment

68,410

68,585

57,956

63,837

72,712

82,845

99,364

105,318

112,559

103,255

89,376

79,592

71,183

72,384

73,477

70,009

65,357

58,684

64,008

77,046

74,411

70,301

64,188

42,268

35,758

33,418

26,384

23,107

20,239

19,058

22,964

25,828

31,507

38,767

37,621

36,662

30,581

22,132

18,592

19,314

21,111

21,820

23,702

12,150

0

0

0

Proceeds from maturity of short-term investments

-

-

-

-

-

-

-

-

-

-

-

9,212

11,270

15,185

18,254

11,297

19,164

22,341

19,272

17,017

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of business, net of cash acquired

-

-

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

Other investing activities

20,106

16,134

17,998

16,966

15,059

16,346

14,832

18,034

14,103

13,435

10,020

5,937

6,282

6,276

8,590

9,393

7,783

5,821

4,126

10,574

8,915

10,006

8,421

2,547

6,297

4,724

5,250

3,750

0

0

0

-

-

-

-

-518

0

0

0

-

-

-

-

8,930

0

0

0

Purchase of Vignette Corporation, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Purchase of eMotion LLC, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Purchase of a division of Spicer Corporation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Purchase consideration for prior period acquisitions

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

812

887

887

887

887

887

880

875

840

935

1,056

1,113

1,297

2,372

3,445

4,577

5,642

7,417

9,448

12,843

17,011

18,668

30,888

22,794

0

0

0

Maturity of short-term investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

45,525

0

0

0

-

-

0

0

Net cash used in investing activities

-1,471,097

-1,375,666

-457,398

-464,526

-471,563

-433,290

-145,520

-444,441

-447,682

-2,039,638

-2,016,493

-2,190,964

-2,438,123

-816,794

-836,662

-361,176

-89,798

-401,296

-386,248

-398,395

-403,431

-1,158,302

-1,150,574

-1,153,368

-1,162,842

-100,624

-94,433

-374,394

-356,915

-336,808

-339,978

-281,539

-286,064

-482,909

-540,398

-287,268

-315,000

-112,471

-42,943

-109,821

-84,603

-99,892

-211,465

-160,829

0

0

0

Cash flows from financing activities:
Proceeds from Revolver

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from issuance of Common Shares from exercise of stock options and ESPP

68,899

56,720

50,879

57,889

51,968

70,599

72,237

75,935

74,989

54,514

52,108

35,593

34,937

22,810

20,155

20,097

14,241

14,090

13,393

15,240

17,917

28,517

30,084

24,808

28,535

15,374

14,177

16,347

10,464

16,411

17,426

21,270

20,464

18,220

16,103

11,512

10,418

8,382

8,740

9,971

10,856

19,696

18,528

19,593

0

0

0

Excess tax benefits (expense) on share-based compensation expense

-

-

-

-

-

-

-

-

-

-

-

1,534

1,559

732

451

230

321

88

1,064

1,675

1,780

2,390

2,166

1,844

1,978

1,385

636

915

625

2,839

2,743

2,723

3,021

1,821

1,788

1,888

1,816

1,008

884

1,143

1,153

2,675

2,693

8,631

0

0

0

Proceeds from long-term debt and Revolver

-

-

-

-

-

-

-

1,200,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

648,500

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Repayment of long-term debt and Revolver

1,713,631

10,000

10,000

10,000

1,051,300

1,150,740

1,150,180

1,149,620

157,760

57,760

57,820

57,880

7,940

8,000

8,000

8,000

15,799

507,454

518,867

530,284

533,897

53,654

51,660

45,911

40,168

34,426

30,678

30,677

30,675

30,669

405,354

349,187

342,434

335,671

-45,803

3,575

3,539

3,511

3,499

3,485

3,463

3,439

5,157

3,426

0

0

0

Debt issuance costs

18,170

979

0

322

4,697

4,697

4,697

4,375

1,040

3,085

5,910

7,240

12,965

10,920

8,095

6,765

195

16,868

18,088

18,271

18,729

17,815

16,868

16,685

0

0

0

-

-

-

-

9,834

0

0

0

-

-

-

-

1,024

0

0

0

-

-

0

0

Payments for Repurchase of Common Stock

12,400

14,400

27,200

26,500

26,500

24,500

11,700

0

0

0

0

-

-

-

-

-

-

-

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of non-controlling interests

0

0

0

583

583

583

583

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments of Dividends

188,400

181,800

175,400

168,900

162,500

157,000

151,100

145,600

139,647

134,750

127,809

120,600

113,588

107,384

103,741

99,262

96,082

93,057

89,896

87,629

84,175

81,325

78,017

74,693

71,395

53,171

35,424

17,703

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) financing activities

1,275,091

599,561

-161,724

-148,374

-193,629

-266,906

-246,004

-23,673

-27,750

275,049

1,120,218

909,544

1,564,384

1,340,209

474,660

430,164

-182,525

110,536

127,454

170,605

181,645

676,695

684,286

687,944

701,499

-71,111

-51,289

-31,118

-30,474

-22,832

243,509

302,584

319,717

323,561

50,250

-2,703

-17,833

-20,649

-7,875

-7,395

7,522

17,908

16,774

24,798

0

0

0

Foreign exchange gain (loss) on cash held in foreign currencies

-19,977

-1,996

-11,965

-3,826

-23,798

-15,633

-9,520

-2,186

25,023

25,580

4,817

1,767

-10,559

-16,421

-290

-10,952

-1,868

-17,673

-20,129

-23,132

-27,236

-15,368

-8,107

5,742

3,073

-3,013

-2,029

-2,292

-7,737

86

-3,495

-11,928

-1,095

8,146

5,115

24,698

12,768

-5,885

-1,303

-12,602

7,763

8,260

889

-19,236

0

0

0

Increase (decrease) in cash, cash equivalents and restricted cash during the period

688,080

82,358

211,237

259,552

161,571

119,324

411,192

237,781

157,192

-1,245,694

-457,310

-839,300

-428,405

996,528

144,159

583,758

264,228

183,153

198,299

272,109

277,106

27,456

1,339

-42,555

-110,840

148,096

188,912

-89,302

-61,995

-46,653

182,941

275,607

271,159

73,128

-265,398

-42,052

-83,581

93,153

172,502

50,373

84,280

74,760

-37,943

20,903

0

0

0

Guidance Software Inc.
Purchase of business, net of cash acquired

-

-

-

-

-

-

-

229,275

229,275

229,275

220,765

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Covisint Corporation
Purchase of business, net of cash acquired

-

-

-

-

-

-

-

71,279

71,279

71,279

71,279

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

HP Inc. CCM Business
Purchase of business, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

315,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Recommind, Inc.
Purchase of business, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

170,107

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

HP Inc. CEM Business
Purchase of business, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-