Guidewire software, inc. (GWRE)
CashFlow / TTM
Jan'20Oct'19Jul'19Apr'19Jan'19Oct'18Jul'18Apr'18Jan'18Oct'17Jul'17Apr'17Jan'17Oct'16Jul'16Apr'16Jan'16Oct'15Jul'15Apr'15Jan'15Oct'14Jul'14Apr'14Jan'14Oct'13Jul'13Apr'13Jan'13Oct'12Jul'12Apr'12Jan'12Oct'11
CASH FLOWS FROM OPERATING ACTIVITIES:
Net income (loss)

-20,511

-568

20,732

56,504

34,034

-11,520

-26,743

-61,745

-32,513

17,016

18,072

10,394

11,809

8,748

14,976

10,772

8,189

11,252

9,885

17,749

18,823

22,339

14,721

16,344

15,587

13,596

24,658

10,290

16,109

14,299

18,664

0

0

0

Adjustments to reconcile net income (loss) to net cash provided by (used in) operating activities:
Depreciation and amortization

42,156

41,187

39,953

38,634

38,737

38,629

35,611

32,634

28,657

22,285

18,725

15,215

11,683

10,125

8,842

7,765

7,401

7,498

7,480

7,323

7,164

6,933

6,751

6,617

5,984

5,312

4,821

3,952

3,598

3,338

2,917

0

0

0

Amortization of debt discount and issuance costs

12,535

12,364

12,194

12,026

10,525

7,498

4,512

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Stock-based compensation

95,103

92,739

91,516

89,856

92,666

93,326

89,614

86,627

79,985

73,540

71,794

71,907

70,903

68,861

66,131

61,380

57,581

54,534

51,375

48,726

46,699

39,826

42,538

28,767

26,672

30,421

25,505

27,475

23,477

19,395

12,923

0

0

0

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

7,102

4,104

4,104

4,013

3,538

6,569

6,778

6,935

7,067

2,761

2,689

2,604

2,586

809

672

600

486

0

0

0

Charges to bad debt and revenue reserves

0

789

-

-

-

1,300

1,062

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred income tax

-11,597

-17,991

-13,998

-22,378

-16,899

34,476

14,150

30,244

28,677

-14,433

-1,227

-6,580

-8,482

-8,165

-4,568

3,384

2,051

-5,655

295

-7,221

-241

3,758

-2,718

1,161

-4,198

-6,779

-265

-3,161

1,391

3,499

7,235

0

0

0

Accretion of discount on available-for-sale securities, net

5,764

7,138

7,568

7,080

5,595

3,418

1,418

-227

-955

-1,205

-1,462

-1,045

-1,546

-2,106

-2,516

-3,523

-3,793

-4,302

-4,839

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Other non-cash items affecting net income (loss)

0

0

-

0

0

0

-

-

-

0

-

-

-

-

-

0

0

0

-

-

-

-

-99

0

0

0

-

0

0

0

-

-

-

-

Loss on disposals of property and equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

-16,788

-15,310

15,057

9,254

20,073

13,487

40,832

814

25,272

17,577

9,750

27,388

3,119

-969

75

1,374

-1,997

14,854

12,999

1,513

5,933

-6,427

9,276

10,349

15,082

8,841

8,478

12,877

7,274

7,423

9,325

0

0

0

Unbilled accounts receivable

-

0

-

-

-

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses and other assets

18,893

21,595

16,251

6,396

483

-4,736

2,737

4,444

8,913

13,229

9,463

9,863

9,049

6,406

7,668

6,499

7,213

3,435

3,178

841

748

3,521

1,372

5,280

2,295

2,371

2,690

534

1,205

2,969

2,442

0

0

0

Operating lease assets

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accounts payable

4,922

-599

-5,521

1,089

-2,515

6,995

16,794

5,334

7,860

2,277

1,311

1,840

279

4,047

603

-2,188

58

-363

2,266

4,021

1,653

-404

393

-210

-812

412

355

2,283

1,388

1,242

1,059

0

0

0

Accrued employee compensation

293

3,093

13,825

11,402

11,515

4,135

9,230

3,490

4,675

4,485

7,138

8,620

3,994

2,654

4,114

3,908

1,512

653

3,261

1,800

185

1,178

8,463

3,117

2,701

1,804

147

3,223

3,968

5,640

8,244

0

0

0

Deferred revenue

-5,721

-1,601

-9,628

-17,823

-11,822

-446

32,358

29,063

40,882

44,813

41,553

34,762

24,015

15,805

16,138

3,335

9,676

3,193

-2,263

5,819

1,241

3,641

14,181

7,136

6,901

77

-14,048

-9,605

-16,342

-15,909

-17,788

0

0

0

Lease liabilities

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other liabilities

19,352

21,777

22,600

12,259

9,165

7,523

8,858

10,083

8,031

7,507

6,612

5,464

5,499

5,781

5,993

4,706

5,675

5,204

6,253

5,457

6,430

6,597

5,288

3,437

788

2,346

4,574

6,713

7,950

7,388

-3,907

0

0

0

Net cash provided by (used in) operating activities

130,421

125,235

116,126

117,037

111,054

144,460

140,459

123,837

125,556

120,421

138,759

100,796

102,519

97,880

99,900

83,654

86,640

58,335

63,677

80,102

73,829

84,526

75,491

50,488

35,167

34,243

32,547

27,222

32,471

27,900

17,094

0

0

0

CASH FLOWS FROM INVESTING ACTIVITIES:
Purchases of available-for-sale securities

1,347,813

1,362,605

1,209,312

1,102,358

1,211,739

1,046,283

859,657

653,584

281,244

327,985

462,035

503,304

601,638

657,574

652,017

622,959

596,775

573,232

491,626

527,555

570,159

757,992

687,419

562,527

450,407

255,192

212,035

0

0

0

-

-

-

-

Sales and maturities of available-for-sale securities

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

Purchases of property and equipment

45,169

51,601

44,921

33,434

15,784

10,444

9,398

7,360

7,889

5,311

5,886

5,104

5,861

6,569

7,111

6,468

6,517

8,068

6,301

6,400

6,063

5,036

4,993

5,836

5,953

5,624

9,228

10,562

10,475

9,939

5,619

0

0

0

Capitalized software development costs

4,983

4,823

3,936

3,006

3,007

2,555

2,613

2,260

1,553

1,301

784

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisitions of business, net of acquired cash

-

-

-

-

-

-

-

-

-

-

187,590

187,590

73,064

73,123

39,530

0

0

0

-

-

-

-

157

14,906

14,844

14,844

14,749

0

0

0

-

-

-

-

Decrease in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-1,927

-3,532

-3,520

-5,843

-3,928

-2,323

0

0

0

Net cash provided by (used in) investing activities

-275,063

-340,445

-301,433

-224,240

-525,803

-579,848

-537,584

-411,776

-160,520

-9,765

-113,342

-135,111

-105,994

-171,565

-101,253

-43,728

7,317

26,025

23,070

-57,787

-142,468

-379,504

-380,420

-350,900

-291,286

-159,064

-148,913

-120,299

-106,472

-6,011

-3,296

0

0

0

CASH FLOWS FROM FINANCING ACTIVITIES:
Proceeds from issuance of common stock, net of issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

389,949

389,949

389,949

389,949

0

0

0

0

-

-

-

-

Proceeds from issuance of common stock upon exercise of stock options

4,090

3,633

3,954

2,809

2,389

2,337

2,013

3,199

4,256

4,816

5,563

5,838

5,885

7,489

7,840

6,920

6,424

6,312

6,294

6,196

8,471

8,137

8,755

8,513

7,635

8,023

9,123

9,355

8,201

7,828

5,067

0

0

0

Taxes remitted on RSU awards vested

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

Costs paid in connection with stock offerings

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

408

408

410

107

0

920

1,813

2,529

3,502

0

0

0

Excess tax benefit from exercise of stock options and vesting of restricted stock units

-

-

-

-

-

-

-

-

-

-

-

-

-

-

7,102

4,104

4,104

4,013

3,538

6,569

6,778

6,935

7,067

2,761

2,689

2,604

2,586

809

672

600

486

0

0

0

Net cash provided by (used in) financing activities

4,090

3,633

3,954

2,809

573,376

573,324

573,000

582,616

11,724

12,284

13,031

11,412

12,421

13,502

13,454

8,755

-295

-9,162

-17,351

-20,782

-20,198

-19,296

372,564

369,526

373,532

377,001

-8,621

-17,881

5,773

132,691

133,007

0

0

0

Effect of foreign exchange rate changes on cash and cash equivalents

-1,154

-656

-1,686

-2,838

-3,745

-2,013

-1,911

1,258

3,164

1,396

1,146

-1,536

-505

-1,485

-881

-1,018

-1,964

-3,977

-5,135

-3,927

-3,568

-1,361

699

-308

-1,249

-507

-964

-362

60

-279

-712

0

0

0

NET INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS

-141,706

-212,233

-183,039

-107,232

154,882

135,923

173,964

295,935

-20,076

124,336

39,594

-24,439

8,441

-61,668

11,220

47,663

91,698

71,221

64,261

-2,394

-92,405

-315,635

68,334

68,806

116,164

251,673

-125,951

-111,320

-68,168

154,301

146,093

0

0

0

SUPPLEMENTAL DISCLOSURES OF CASH FLOW INFORMATION:
Cash paid for income taxes, net of tax refunds

4,685

4,765

4,557

4,668

5,607

4,314

4,744

4,999

3,121

3,921

3,700

3,175

4,938

4,575

3,907

2,660

1,603

1,787

1,899

2,563

2,416

1,974

2,141

2,733

1,948

2,258

2,266

1,865

2,480

2,284

2,058

0

0

0

Accruals for purchase of property and equipment

3,205

3,874

298

13,449

2,301

1,406

189

-10

1,147

357

171

-233

128

11

0

424

248

-526

0

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

Accruals for capitalized software costs

0

0

-

-

-

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Unpaid offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

0

-

-

-

-