Aspen technology, inc. (AZPN)
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'10
Cash flows from operating activities:
Net income

231,945

250,011

270,952

262,734

196,889

173,137

151,999

148,688

165,019

163,018

161,951

162,196

141,171

138,508

138,180

139,951

137,431

132,429

126,211

118,407

114,279

106,953

99,751

85,783

79,504

69,174

55,848

45,262

19,475

8,442

2,341

-13,808

33,261

28,094

13,989

10,257

0

0

0

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

9,108

8,573

8,179

8,143

0

0

0

-

0

0

6,367

-

6,535

6,341

6,305

6,061

6,119

6,378

6,411

6,216

5,976

5,594

5,365

5,215

4,970

5,021

5,114

5,229

5,408

5,272

5,183

5,278

5,395

5,429

5,387

5,336

0

0

0

Reduction in the carrying amount of right-of-use assets

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net foreign currency losses

1,091

1,731

330

1,251

0

0

0

-

0

0

-645

-

7,107

4,523

3,222

3,666

-2,584

1,617

2,081

1,552

2,225

524

-710

-1,934

-1,159

-431

267

952

498

569

443

-953

-898

-699

-1,287

2,167

0

0

0

Stock-based compensation

30,252

29,207

27,983

27,573

0

0

0

-

0

0

20,256

-

17,721

17,422

16,262

15,727

15,775

14,853

14,803

14,584

14,076

14,184

13,873

14,056

14,444

14,407

14,709

14,637

14,097

13,395

13,013

12,406

11,905

11,436

10,710

9,699

0

0

0

Deferred income taxes

22,626

20,625

17,649

-26,839

-51,121

-48,577

-41,444

3,193

-988

-172

-4,273

-4,286

2,973

2,814

2,453

2,499

-510

-1,794

4,552

20,112

30,086

39,578

41,538

34,596

15,286

12,060

9,523

5,127

14,506

7,341

4,749

-4,827

-67,973

-66,648

-69,664

-64,264

0

0

0

Provision for bad debts

3,562

1,082

1,593

645

0

0

0

-

0

0

226

-

311

140

227

260

132

-675

842

-513

571

1,326

444

1,793

1,209

1,132

412

489

-51

587

-31

22

-1,724

-3,255

-3,322

-2,755

0

0

0

Tax benefits from stock-based compensation

-

-

-

-

-

-

-

-

0

0

5,381

-

2,674

1,409

1,215

2,208

17,059

31,171

38,673

37,024

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefits from stock-based compensation

-

-

-

-

-

-

-

-

0

0

5,381

-

2,674

1,409

1,215

2,208

17,059

31,171

38,529

37,024

22,433

8,328

758

727

615

561

519

478

0

0

0

-

-

-

-

-

-

-

-

Other non-cash operating activities

-511

-427

-429

-429

0

0

0

-

0

0

-512

-

-494

-90

-252

-321

-475

-1,108

-1,316

-1,619

-1,890

-1,733

-2,236

-1,847

-1,811

-1,686

-888

-818

1,816

1,680

1,705

1,695

-512

-51

-466

-453

0

0

0

Changes in assets and liabilities:
Accounts receivable

18,871

-5,299

-3,823

6,626

7,546

24,447

16,217

4,327

-6,500

6,318

6,629

7,480

14,075

3,844

742

-9,382

-5,644

-5,229

-1,807

-8,028

-2,001

-8,865

-10,659

3,179

2,772

-8,338

13,837

6,094

1,499

4,174

984

4,285

-274

5,096

-6,334

-5,981

0

0

0

Contract assets

23,669

39,915

53,848

59,322

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Contract costs

2,179

2,766

4,031

4,482

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Lease liabilities

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Unbilled services

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-120

-634

-301

-932

-185

224

380

1,108

565

-161

-734

-555

-798

-421

477

0

0

0

Prepaid expenses, prepaid income taxes, and other assets

4,813

5,923

3,648

2,411

0

0

0

-

0

0

2,014

-

5,904

4,438

5,033

6,106

-1,609

-3,311

-3,802

-4,232

-2,689

-2,325

-1,319

-947

-3,266

542

-254

-3,827

-1,040

-1,219

662

3,918

4,538

6,150

4,377

773

0

0

0

Installment receivables

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-6,242

-10,831

-13,607

-18,987

-22,663

-31,418

-39,419

-46,858

-55,376

-59,704

-57,003

-60,066

-69,341

-69,180

-72,752

0

0

0

Accounts payable, accrued expenses, income taxes payable and other liabilities

-31,811

-38,902

-25,744

21,921

0

0

0

-

0

0

-14,826

-

8,041

3,902

5,683

-4,489

1,548

7,880

16,242

5,933

956

1,303

2,422

906

4,513

-2,573

-1,649

-5,425

-3,560

-1,494

-7,938

-1,583

2,346

-6,754

-3,218

-12,758

0

0

0

Deferred revenue

13,517

11,581

5,041

17,799

43,382

69,440

65,140

13,700

20,340

17,631

6,281

18,477

3,727

11,577

1,183

-6,196

-8,344

-7,750

-2,637

14,919

25,052

13,951

24,338

42,325

32,518

32,696

51,866

44,605

41,439

47,347

44,437

58,357

52,425

41,852

34,422

41,446

0

0

0

Net cash provided by operating activities

228,765

237,423

248,003

238,313

232,243

215,271

200,146

206,936

201,177

183,731

168,496

182,386

153,887

167,989

161,548

153,744

162,463

157,382

170,488

191,985

196,659

201,650

214,161

200,131

175,827

164,678

154,014

146,562

134,291

130,497

117,825

104,637

93,402

70,397

62,215

63,330

0

0

0

Cash flows from investing activities:
Purchases of marketable securities

-

-

-

-

-

-

-

-

0

0

490,000

-

683,748

683,748

193,748

0

0

11,017

38,080

50,065

82,879

88,412

72,367

68,356

57,426

116,589

105,571

97,597

0

0

0

-

-

-

-

-

-

-

-

Maturities of marketable securities

-

-

-

-

-

-

-

-

0

0

633,162

-

675,224

640,303

101,787

58,973

71,577

78,572

81,392

85,535

93,826

86,853

70,240

60,265

37,911

16,973

9,087

4,549

0

0

0

-

-

-

-

-

-

-

-

Purchases of property, equipment and leasehold improvements

1,341

1,224

940

436

0

0

0

-

0

0

1,945

-

3,104

3,076

3,262

3,483

4,261

5,098

5,873

7,645

7,295

6,615

5,987

4,011

4,119

3,664

3,622

4,507

6,084

5,886

5,655

4,241

1,692

1,885

2,637

2,839

0

0

0

Payments for business acquisitions, net of cash acquired

80,558

80,317

80,317

6,098

0

0

0

-

0

0

30,771

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments for capitalized computer software costs

178

1,012

1,050

1,131

0

0

0

-

0

0

419

-

395

369

320

269

44

222

223

359

399

318

602

685

1,164

1,225

1,375

1,156

617

554

311

511

810

2,002

2,014

1,990

0

0

0

Net cash used in investing activities

-82,396

-82,553

-82,307

-7,665

0

0

0

-

0

0

110,027

-

198,873

-91,061

-108,943

47,221

-187,795

62,235

37,216

27,466

3,253

-8,892

-9,116

-13,187

-25,198

-104,880

-101,856

-97,391

-81,094

-7,362

-6,888

-7,369

-5,119

-3,887

-4,651

-4,829

0

0

0

Cash flows from financing activities:
Issuance of shares of common stock

10,347

9,112

7,828

10,864

0

0

0

-

0

0

8,595

-

8,954

6,322

6,402

3,924

5,478

5,592

4,223

4,662

3,281

5,795

6,827

8,710

13,188

16,453

20,028

21,143

17,762

13,927

10,729

8,913

8,580

10,389

11,798

9,703

0

0

0

Proceeds from secured borrowings

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,982

4,982

4,982

1,984

2,500

0

0

0

Repayments of secured borrowings

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

11,010

33,632

35,482

48,054

44,892

27,657

36,230

24,942

32,051

0

0

0

Repurchases of common stock

225,653

252,655

300,085

299,214

0

0

0

-

0

0

274,979

-

371,118

321,398

275,192

178,604

177,496

238,131

307,279

297,246

255,735

178,762

137,857

121,776

114,345

106,744

96,433

84,677

73,237

62,717

54,096

46,105

38,487

29,529

19,703

10,531

0

0

0

Payments of tax withholding obligations related to restricted stock

10,807

10,674

14,464

14,477

0

0

0

-

0

0

6,117

-

5,422

5,078

4,652

4,480

5,229

5,313

5,413

5,699

5,770

6,168

6,793

7,831

7,882

7,654

8,178

7,705

7,230

7,116

5,386

4,597

4,277

4,654

4,276

3,885

0

0

0

Insurance proceeds

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,222

2,222

2,222

2,222

0

0

0

0

-

-

-

-

Purchase of technology intangibles

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

902

902

527

527

0

0

0

0

-

-

-

-

Deferred business acquisition payments

-

-

-

-

-

-

-

-

0

0

600

-

0

0

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefits from stock-based compensation

-

-

-

-

-

-

-

-

0

0

5,381

-

2,674

1,409

1,215

2,208

17,059

31,171

38,529

37,024

22,433

8,328

758

727

615

561

519

478

0

0

0

-

-

-

-

-

-

-

-

Proceeds from borrowings

215,163

129,163

150,000

50,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments of debt issuance costs

-

-

-

-

-

-

-

-

0

0

351

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) financing activities

-19,083

-129,008

-158,421

-254,527

0

0

0

-

0

0

-268,071

-

-365,032

-180,452

-133,934

-38,659

-21,775

-206,681

-269,940

-261,259

-235,791

-170,807

-137,065

-120,170

-108,424

-97,384

-89,680

-81,771

-96,337

-91,388

-93,233

-81,699

-56,859

-55,044

-35,139

-34,264

0

0

0

Effect of exchange rate changes on cash and cash equivalents

-706

196

-690

-360

0

0

0

-

0

0

154

-

-86

-73

-33

-219

55

-756

-1,159

-1,469

-1,642

-985

-450

320

236

-161

-237

-210

-382

222

303

-312

102

147

-230

803

0

0

0

Increase (decrease) in cash and cash equivalents

126,580

26,058

6,585

-24,239

0

0

0

-

0

0

10,606

-

-12,358

-103,597

-81,362

162,087

-47,052

12,180

-63,395

-43,277

-37,521

20,966

67,530

67,094

42,441

-37,747

-37,759

-32,810

-43,522

31,969

18,007

15,257

31,526

11,613

22,195

25,040

0

0

0

Supplemental disclosure of non-cash activities:
Change in purchases of property, equipment and leasehold improvements included in accounts payable and accrued expenses

5

3

275

104

0

0

0

-

0

0

-623

-

160

-24

312

-825

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Change in repurchases of common stock included in accounts payable and accrued expenses

-653

-2,655

-85

786

0

0

0

-

0

0

21

-

3,882

3,602

-192

1,462

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Lease liabilities arising from obtaining right-of-use assets

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Supplemental disclosure of cash flow information:
Income taxes paid, net

40,389

55,074

60,682

53,153

0

0

0

-

0

0

65,540

-

59,158

59,531

67,372

69,028

52,391

35,588

5,056

3,712

4,373

4,733

7,378

7,157

7,670

7,878

4,941

4,645

3,800

4,181

3,110

2,707

2,475

3,187

5,015

-2,112

0

0

0

Interest paid

10,639

9,772

9,384

8,121

0

0

0

-

0

0

3,562

-

3,118

2,528

1,812

963

0

0

0

-

-

-

0

-

-

-

185

424

1,873

2,472

3,371

4,206

3,779

4,512

4,987

5,476

0

0

0