Pegasystems inc. (PEGA)
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'11
Operating activities
Net (loss)

-87,088

-90,433

-74,938

-52,187

-30,300

10,617

34,799

43,674

57,785

98,548

84,731

86,744

87,578

45,015

39,195

42,219

40,787

36,322

35,468

31,025

29,425

33,255

28,712

35,540

38,739

38,043

42,891

33,850

26,880

21,868

-396

4,894

9,434

10,108

0

0

0

Adjustments to reconcile net (loss) to cash (used in) provided by operating activities
Stock-based compensation

85,734

80,909

76,531

71,094

67,103

63,862

60,957

58,038

55,914

53,313

50,116

47,445

44,394

40,821

37,683

34,956

32,720

30,054

28,489

25,666

22,179

19,205

16,877

14,609

12,732

12,869

12,597

12,381

12,086

11,506

10,928

10,466

9,345

9,028

0

0

0

Loss on capped call transactions

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefits from exercise or vesting of equity awards

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

7,519

7,243

6,681

6,435

5,540

5,524

5,134

6,031

3,191

4,872

7,203

6,658

0

0

0

Deferred income taxes

0

-

-

-

0

-

-

-

-

-

-

-

-

-4,398

-2,051

-1,764

-1,446

-2,099

-14,940

-14,522

-13,855

-13,896

-9,390

-8,180

-6,996

-7,008

6,190

6,132

6,322

6,164

16,872

15,491

15,197

15,269

0

0

0

Amortization of deferred contract costs

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Lease expense

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of debt discount and issuance costs

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of intangible assets and depreciation

19,560

21,396

44,175

38,162

21,728

25,295

37,752

33,278

28,947

24,713

24,944

24,818

24,759

24,137

23,419

23,510

22,935

23,093

23,755

23,198

23,130

23,352

23,029

22,028

21,154

20,035

18,753

19,009

18,607

18,566

18,800

18,210

18,137

17,462

0

0

0

Amortization of investments

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Foreign currency transaction loss

-4,570

-2,335

-1,714

655

-206

2,421

0

0

0

-

-

-

-

9,360

2,938

1,444

170

-4,168

-5,584

-8,017

-7,053

-3,769

-2,454

1,052

619

-1,593

-1,223

-1,446

-715

780

26

-659

-1,264

-935

0

0

0

Other non-cash

1,911

521

664

1,062

2,799

1,678

15,556

7,411

8,686

1,383

-11,261

776

-4,346

1,382

154

-4,848

-3,373

-822

557

692

808

747

127

85

-651

-1,670

-2,072

-2,669

-2,885

-3,357

-5,242

-4,273

-3,375

-1,749

0

0

0

Change in operating assets and liabilities, net

0

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Change in operating assets and liabilities:
Accounts receivable, unbilled revenue, and contract assets

-

-

-

-

-

-

-

-

-

-

-

-

-

49,503

80,264

68,027

55,239

62,235

30,871

28,301

51,381

-6,209

11,878

14,497

32,768

28,316

9,991

2,474

-36,209

33,664

1,776

-3,486

-1,641

18,450

0

0

0

Income taxes receivable and other current assets

-

-

-

-

-

-

-

-

-

-

-

-

-

10,818

11

10,273

-7,425

-3,223

2,055

-1,759

3,256

-2,776

-638

-4,271

-7,136

-7,076

-10,637

-6,491

-8,295

-6,570

-13,954

-8,020

-10,762

-10,519

0

0

0

Accounts payable, accrued compensation, and accrued expenses

-

-

-

-

-

-

-

-

-

-

-

-

-

1,531

4,002

7,820

13,371

16,572

10,696

2,755

13,322

13,356

10,108

15,939

8,185

5,794

7,073

-3,554

-5,773

-7,656

-2,470

-2,354

-9,812

9,038

0

0

0

Deferred revenue

-

-

-

-

-

-

-

-

-

-

-

-

-

2,639

6,895

4,068

-15,122

17,668

-39

13,765

26,755

11,173

34,485

20,982

37,888

26,362

18,204

27,916

26,902

24,787

9,092

-1,763

2,068

14,595

0

0

0

Other long-term assets and liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-253

-756

458

1,372

2,023

-3,398

-3,908

-3,398

-2,908

-5,296

-5,724

-6,342

-7,244

-4,782

-7,835

-10,630

-9,801

-15,118

-8,745

-5,493

-5,909

0

0

0

Cash (used in) provided by operating activities

-83,191

-42,165

23,806

36,644

71,404

104,356

111,397

147,898

181,446

158,235

133,244

114,074

62,278

39,874

33,431

39,973

50,322

67,803

59,937

68,740

57,939

103,276

95,535

90,358

87,515

80,703

97,930

95,332

127,399

43,579

49,252

35,122

30,156

39,815

0

0

0

Investing activities
Purchases of investments

5,690

11,424

12,499

28,596

41,514

69,494

70,208

62,457

59,600

27,718

27,042

19,683

19,098

23,969

31,370

65,140

65,775

75,702

86,234

57,477

62,010

55,520

40,235

57,505

56,499

60,648

63,513

41,134

25,504

20,204

20,896

43,648

58,702

57,249

0

0

0

Proceeds from maturities and called investments

5,086

13,634

20,601

35,990

36,544

33,991

30,329

17,719

30,692

26,997

24,074

22,473

9,198

22,788

29,948

42,045

41,367

42,026

45,004

38,368

38,772

33,244

28,841

35,270

35,085

27,814

27,240

18,909

21,546

24,576

24,375

27,117

22,690

20,648

0

0

0

Sales of investments

90,830

89,406

0

0

0

-

-

-

-

-

-

-

-

62,210

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other

-

-

-

-

-

-

-

-

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments to Acquire Businesses, Net of Cash Acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

49,113

49,113

50,249

1,391

1,671

2,989

2,860

3,660

3,918

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Investment in property and equipment

20,314

10,608

0

0

0

-

-

-

-

-

-

-

-

19,088

16,323

15,224

11,996

11,020

15,604

15,892

13,510

11,463

7,249

6,490

5,631

5,598

5,893

10,633

20,538

23,610

26,602

21,221

13,012

9,835

0

0

0

Cash (used in) investing activities

58,978

70,074

54,847

15,383

-18,384

-48,196

-52,388

-59,969

-42,310

-14,759

-16,279

-401

-20,269

-7,172

-4,575

-34,170

-29,701

-44,452

-57,908

-37,861

-40,408

-37,657

-46,808

-55,883

-53,403

-63,997

-42,166

-32,858

-24,496

-19,238

-26,123

-37,751

-47,976

-45,388

0

0

0

Financing activities
Proceeds from issuance of convertible senior notes

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payment of debt issuance costs

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of capped calls related to convertible senior notes

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Issuance of common stock for share-based compensation plans

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,034

-

1,094

1,250

1,125

1,001

1,869

1,747

1,961

2,210

1,345

1,222

1,106

1,128

1,211

1,622

2,559

2,622

0

0

0

Excess tax benefits from exercise or vesting of equity awards

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

7,519

7,243

6,681

6,435

5,540

5,524

5,134

6,031

3,191

4,872

7,203

6,658

0

0

0

Dividend payments to shareholders

9,511

9,486

9,470

9,460

9,451

9,432

9,403

9,366

9,323

9,277

9,232

9,195

9,175

9,174

9,181

9,192

9,197

9,194

9,189

9,178

8,023

6,874

0

0

0

-

-

-

-

5,680

4,534

4,529

4,509

4,495

0

0

0

Common stock repurchases for tax withholdings for net settlement of equity awards

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

8,640

8,338

7,158

6,907

6,128

8,161

13,527

10,761

7,345

12,164

4,462

708

4,391

-15,400

-12,682

-2,673

-6,262

0

0

0

Common stock repurchases

27,922

22,135

44,673

52,948

56,950

54,434

31,833

15,211

11,347

4,335

38,597

38,270

23,375

27,248

31,575

34,975

37,967

22,825

20,152

14,034

13,215

15,418

15,534

13,630

13,564

12,446

10,447

9,928

7,877

5,179

5,285

5,277

4,617

4,835

0

0

0

Cash provided by (used in) financing activities

453,503

-74,258

-91,737

-100,002

-103,995

-101,460

-81,853

-65,194

-61,287

-54,229

-52,725

-54,910

-47,888

-51,716

-58,028

-59,091

-54,144

-40,659

-35,678

-29,366

-27,169

-27,419

-20,028

-17,176

-17,027

-14,567

-12,983

-12,052

-10,115

-8,091

-9,841

-8,856

-6,181

-6,312

0

0

0

Effect of exchange rate changes on cash and cash equivalents

-1,515

290

-1,007

-816

-4,448

-2,557

-1,529

-70

4,103

2,438

-55

-1,398

-2,463

-3,418

-1,723

-3,315

-1,777

-4,251

-5,618

-7,760

-7,212

-3,846

-981

5,967

3,514

567

-191

-1,404

-2,530

922

1,346

-671

1,122

1,111

0

0

0

Net increase (decrease) in cash and cash equivalents

427,775

-46,059

-14,091

-48,791

-55,423

-47,857

-24,373

22,665

81,952

91,685

64,185

57,365

-8,342

-22,432

-30,895

-56,603

-35,300

-21,559

-39,267

-6,247

-16,850

34,354

27,718

23,266

20,599

2,706

42,590

49,018

90,258

17,172

14,634

-12,156

-22,879

-10,774

0

0

0