Guidewire software, inc. (GWRE)
CashFlow / Quarterly
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)

-19,944

-14,991

23,005

-8,581

-1

6,309

58,777

-31,051

-45,555

-8,914

23,775

-1,819

3,974

-7,858

16,097

-404

913

-1,630

11,893

-2,987

3,976

-2,997

19,757

-1,913

7,492

-10,615

21,380

-2,670

5,501

447

7,012

3,149

3,691

4,812

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

10,758

10,886

10,813

9,699

9,789

9,652

9,494

9,802

9,681

6,634

6,517

5,825

3,309

3,074

3,007

2,293

1,751

1,791

1,930

1,929

1,848

1,773

1,773

1,770

1,617

1,591

1,639

1,137

945

1,100

770

783

685

679

Amortization of debt discount and issuance costs

3,198

3,156

3,112

3,069

3,027

2,986

2,944

1,568

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Stock-based compensation

26,736

24,558

22,780

21,029

24,372

23,335

21,120

23,839

25,032

19,623

18,133

17,197

18,587

17,877

18,246

16,193

16,545

15,147

13,495

12,394

13,498

11,988

10,846

10,367

6,625

14,700

-2,925

8,272

10,374

9,784

-955

4,274

6,292

3,312

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

6,536

0

91

475

3,538

0

0

0

6,569

209

157

132

2,263

137

72

114

486

0

0

0

Charges to bad debt and revenue reserves

521

357

-

-

-

238

1,062

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred income tax

3,014

-7,375

-2,162

-5,074

-3,380

-3,382

-10,542

405

47,995

-23,708

5,552

-1,162

4,885

-10,502

199

-3,064

5,202

-6,905

8,151

-4,397

-2,504

-955

635

2,583

1,495

-7,431

4,514

-2,776

-1,086

-917

1,618

1,776

1,022

2,819

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

652

1,360

1,872

1,880

2,026

1,790

1,384

395

-151

-210

-261

-333

-401

-467

156

-834

-961

-877

-851

-1,104

-1,470

-1,414

-

-

-

-

-

-

-

-

-

-

-

-

Other non-cash items affecting net income (loss)

-572

0

-

60

-201

-374

-

-

-

0

-

-

-

-

-

977

-5

-18

-

-

-

-

2,128

-1,088

-1,455

316

-

-355

83

0

-

-

-

-

Loss on disposals of property and equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

22,308

-58,567

29,826

-10,355

23,786

-28,200

24,023

464

17,200

-855

-15,995

24,922

9,505

-8,682

1,643

653

5,417

-7,638

2,942

-2,718

22,268

-9,493

-8,544

1,702

9,908

6,210

-7,471

6,435

3,667

5,847

-3,072

832

3,816

7,749

Unbilled accounts receivable

-

23,103

-

-

-

25,661

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses and other assets

2,081

1,446

10,439

4,927

4,783

-3,898

584

-986

-436

3,575

2,291

3,483

3,880

-191

2,691

2,669

1,237

1,071

1,522

3,383

-2,541

814

-815

3,290

232

-1,335

3,093

305

308

-1,016

937

976

2,072

-1,543

Operating lease assets

-2,153

-2,340

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accounts payable

-1,023

-3,009

5,615

3,339

-6,544

-7,931

12,225

-265

2,966

1,868

765

2,261

-2,617

902

1,294

700

1,151

-2,542

-1,497

2,946

730

87

258

578

-1,327

884

-345

-24

-103

827

1,583

-919

-249

644

Accrued employee compensation

10,986

-39,780

18,890

10,197

13,786

-29,048

16,467

10,310

6,406

-23,953

10,727

11,495

6,216

-21,300

12,209

6,869

4,876

-19,840

12,003

4,473

4,017

-17,232

10,542

2,858

5,010

-9,947

5,196

2,442

4,113

-11,604

8,272

3,187

5,785

-9,000

Deferred revenue

1,126

-24,709

20,011

-2,149

5,246

-32,736

11,816

3,852

16,622

68

8,521

15,671

20,553

-3,192

1,730

4,924

12,343

-2,859

-11,073

11,265

5,860

-8,315

-2,991

6,687

8,260

2,225

-10,036

6,452

1,436

-11,900

-5,593

-285

1,869

-13,779

Lease liabilities

-44

285

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other liabilities

377

-2,514

16,813

4,676

2,802

-1,691

6,472

1,582

1,160

-356

7,697

-470

636

-1,251

6,549

-435

918

-1,039

5,262

534

447

10

4,466

1,507

614

-1,299

2,615

-1,142

2,172

929

4,754

95

1,610

-10,366

Net cash provided by (used in) operating activities

19,474

-18,138

102,933

26,152

14,288

-27,247

103,844

20,169

47,694

-31,248

87,222

21,888

42,559

-12,910

49,259

23,611

37,920

-10,890

33,013

26,597

9,615

-5,548

49,438

20,324

20,312

-14,583

24,435

5,003

19,388

-16,279

19,110

10,252

14,817

-27,085

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

194,641

406,762

431,301

315,109

209,433

253,469

324,347

424,490

43,977

66,843

118,274

52,150

90,718

200,893

159,543

150,484

146,654

195,336

130,485

124,300

123,111

113,730

166,414

166,904

310,944

43,157

41,522

54,784

115,729

0

-

-

-

-

Sales and maturities of available-for-sale securities

216,512

360,237

-

316,519

172,194

238,389

-

106,370

77,277

93,039

-

144,159

141,508

157,163

-

152,790

132,640

188,867

-

138,170

129,356

102,539

-

95,818

79,126

31,102

-

43,367

13,889

0

-

-

-

-

Purchases of property and equipment

1,629

9,625

16,175

17,740

8,061

2,945

4,688

90

2,721

1,899

2,650

619

143

2,474

1,868

1,376

851

3,016

1,225

1,425

2,402

1,249

1,324

1,088

1,375

1,206

2,167

1,205

1,046

4,810

3,501

1,118

510

490

Capitalized software development costs

864

1,346

1,693

1,080

704

459

763

1,081

252

517

410

374

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisitions of business, net of acquired cash

-

-

-

-

-

-

-

-

-

-

0

154,056

-59

33,593

0

39,530

0

0

-

-

-

-

0

62

0

95

14,749

0

0

0

-

-

-

-

Decrease in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-12

0

-1,915

-1,605

0

-2,323

0

0

Net cash provided by (used in) investing activities

19,378

-57,496

-219,535

-17,410

-46,004

-18,484

-142,342

-318,973

-100,049

23,780

-16,534

-67,717

50,706

-79,797

-38,303

-38,600

-14,865

-9,485

19,222

12,445

3,843

-12,440

-61,635

-72,236

-233,193

-13,356

-32,115

-12,622

-100,971

-3,205

-3,501

1,205

-510

-490

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

389,949

0

0

0

0

-

-

-

-

Proceeds from issuance of common stock upon exercise of stock options

871

368

2,103

748

414

689

958

328

362

365

2,144

1,385

922

1,112

2,419

1,432

2,526

1,463

1,499

936

2,414

1,445

1,401

3,211

2,080

2,063

1,159

2,333

2,468

3,163

1,391

1,179

2,095

402

Taxes remitted on RSU awards vested

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

614

874

-

8,554

9,278

8,570

-

10,456

7,896

7,302

-

5,498

5,033

4,164

-

0

0

0

Costs paid in connection with stock offerings

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-2

303

107

0

0

0

0

920

893

716

973

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

6,536

0

91

475

3,538

0

0

0

6,569

209

157

132

2,263

137

72

114

486

0

0

0

Net cash provided by (used in) financing activities

871

368

2,103

748

414

689

958

571,315

362

365

10,574

423

922

1,112

8,955

1,432

2,003

1,064

4,256

-7,618

-6,864

-7,125

825

-7,034

-5,962

384,735

-2,213

-3,028

-2,493

-887

-11,473

20,626

124,425

-571

Effect of foreign exchange rate changes on cash and cash equivalents

-349

254

-269

-790

149

-776

-1,421

-1,697

1,881

-674

1,748

209

113

-924

-934

1,240

-867

-320

-1,071

294

-2,880

-1,478

137

653

-673

582

-870

-288

69

125

-268

134

-270

-308

NET INCREASE (DECREASE) IN CASH AND CASH EQUIVALENTS

39,374

-75,012

-114,768

8,700

-31,153

-45,818

-38,961

270,814

-50,112

-7,777

83,010

-45,197

94,300

-92,519

18,977

-12,317

24,191

-19,631

55,420

31,718

3,714

-26,591

-11,235

-58,293

-219,516

357,378

-10,763

-10,935

-84,007

-20,246

3,868

32,217

138,462

-28,454

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

1,607

1,061

847

1,170

1,687

853

958

2,109

394

1,283

1,213

231

1,194

1,062

688

1,994

831

394

-559

937

1,015

506

105

790

573

673

697

5

883

681

296

620

687

455

Accruals for purchase of property and equipment

1,349

5,167

-13,350

10,039

2,018

1,591

-199

-1,109

1,123

374

-398

48

333

188

-802

409

216

177

-378

233

-558

703

-

96

133

180

-

698

-25

280

-

892

0

0

Accruals for capitalized software costs

-58

95

-

-

-

22

-

395

40

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Unpaid offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

299

-

-

-

0

-

-

-

-