Guidewire software, inc. (GWRE)
Balance Sheet / 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'12Jul'11
ASSETS
CURRENT ASSETS:
Cash and cash equivalents

218,463

179,089

254,101

368,869

360,169

391,322

437,140

476,101

205,287

255,399

263,176

180,166

225,363

131,063

223,582

204,605

216,922

192,731

212,362

156,942

125,224

121,510

148,101

159,336

217,629

437,145

79,767

90,530

101,465

185,472

205,718

201,850

169,633

59,625

Short-term investments

836,939

832,127

870,136

636,333

706,203

693,265

630,008

518,151

299,891

305,685

310,027

297,307

357,442

399,279

404,655

374,081

374,022

343,800

359,273

393,051

420,161

378,725

296,231

271,033

226,563

91,561

76,932

63,591

64,384

-

0

-

-

-

Restricted cash, current

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

174

-

203

206

2,121

3,726

3,726

3,834

2,230

Accounts receivable, net of allowances of $1,841 and $1,441, respectively

101,171

79,480

138,443

108,844

119,699

84,928

124,849

101,146

100,046

78,408

79,433

94,955

64,626

55,132

62,792

61,222

59,392

54,303

62,062

59,554

61,797

40,118

49,839

58,319

56,471

47,093

40,885

48,137

41,779

38,132

32,313

35,468

34,602

23,278

Unbilled accounts receivable, net

50,297

59,778

36,728

59,710

47,493

54,423

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred tax assets, current

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

13,832

13,845

12,015

12,056

11,394

11,431

2,917

2,908

2,895

2,897

18,199

15,430

14,359

13,442

427

2,203

6,044

Prepaid expenses and other current assets

41,114

39,251

35,566

35,479

30,234

28,024

30,464

31,229

33,714

28,142

26,604

30,743

23,868

20,019

16,643

14,457

13,486

14,416

14,102

12,770

9,279

11,581

10,828

11,589

8,708

8,263

9,612

6,906

6,598

6,275

7,266

6,354

4,960

3,665

Total current assets

1,247,984

1,189,725

1,334,974

1,209,235

1,263,798

1,251,962

1,222,461

1,126,627

638,938

667,634

679,240

603,171

671,299

605,493

707,672

654,365

663,822

619,082

661,644

634,332

628,517

563,328

516,430

503,194

512,279

587,131

210,093

227,566

229,862

246,359

262,465

247,825

215,232

94,842

Long-term investments

274,563

300,797

213,524

242,994

171,873

144,359

190,952

164,206

64,273

92,388

114,585

113,913

146,125

155,856

107,565

102,161

109,820

127,118

106,117

93,824

81,779

130,769

203,449

169,780

144,203

48,192

51,040

49,471

37,394

-

0

-

-

-

Unbilled accounts receivable, net

12,824

9,428

9,375

12,910

11,459

10,676

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Property and equipment, net

66,673

67,440

65,809

55,375

30,017

19,031

18,595

15,929

16,205

13,806

14,376

11,896

11,738

13,010

12,955

13,251

13,040

13,418

12,160

12,427

12,372

12,401

12,607

12,459

12,651

12,434

12,914

12,348

11,608

11,535

11,924

5,614

4,264

4,455

Operating lease assets

88,520

90,673

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Intangible assets, net

52,633

59,375

66,542

73,759

81,037

88,346

95,654

103,001

110,671

66,538

71,315

76,091

26,510

28,166

14,204

15,205

3,279

3,639

3,999

4,359

4,719

5,079

5,439

5,799

6,159

6,519

6,879

-

-

-

0

-

-

-

Restricted cash, net of current portion

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,215

3,820

Goodwill

340,877

340,877

340,877

340,877

340,877

340,877

340,877

342,469

343,248

141,924

141,851

142,027

45,605

46,343

30,080

29,585

9,205

9,205

9,205

9,205

9,205

9,205

9,205

9,205

9,143

9,143

9,048

-

-

-

0

-

-

-

Deferred tax assets, net

94,424

97,387

90,308

88,345

83,922

80,811

90,369

58,597

89,701

146,005

37,430

42,960

41,521

45,571

31,364

32,231

21,430

12,795

5,896

15,936

11,504

9,667

8,681

31,786

30,822

28,526

14,494

9,313

9,313

9,313

9,313

22,073

22,073

22,073

Other assets

43,092

43,322

45,554

35,204

35,330

32,731

22,525

21,704

20,658

21,853

20,104

13,156

9,116

8,955

12,338

11,623

3,681

1,675

926

817

924

1,333

1,416

1,485

1,034

1,103

1,205

467

511

534

545

559

1,068

1,350

TOTAL ASSETS

2,221,590

2,199,024

2,166,963

2,058,699

2,018,313

1,968,793

1,981,433

1,832,533

1,283,694

1,150,148

1,078,901

1,003,214

951,914

903,394

916,178

858,421

824,277

786,932

799,947

770,900

749,020

731,782

757,227

733,708

716,291

693,048

305,673

299,165

288,688

267,741

284,247

276,071

244,852

126,540

LIABILITIES AND STOCKHOLDERS’ EQUITY
CURRENT LIABILITIES:
Accounts payable

25,988

25,666

34,255

33,058

20,967

22,720

30,635

19,357

18,570

14,233

13,416

11,768

8,269

10,566

9,929

8,614

7,259

5,943

8,816

10,205

7,008

7,106

7,030

6,418

5,728

6,925

6,517

7,034

6,384

6,517

9,781

5,563

5,905

4,317

Accrued employee compensation

44,425

33,494

73,365

54,459

44,448

30,540

60,135

43,427

33,681

24,579

48,882

37,451

25,762

19,594

41,267

29,333

21,990

17,318

37,235

25,409

20,875

17,271

34,912

24,214

21,303

16,514

26,302

21,101

18,808

14,695

26,502

17,983

14,763

18,112

Deferred revenue, net

89,043

85,845

108,304

90,651

90,979

84,792

127,107

113,894

109,047

86,661

95,994

104,335

86,572

63,023

60,270

62,654

57,796

46,973

50,766

62,016

51,181

44,897

48,937

52,746

46,273

39,819

37,351

48,439

43,043

41,549

52,947

54,279

46,396

48,482

Litigation settlement obligation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

10,000

Other current liabilities

23,130

19,681

16,348

11,236

13,276

11,066

20,280

12,016

11,431

9,959

10,075

10,511

7,972

6,887

7,617

7,503

7,411

6,477

7,592

5,730

5,085

4,617

4,507

5,088

3,987

3,719

4,614

4,707

5,848

3,942

3,957

3,858

3,781

1,390

Total current liabilities

182,586

164,686

232,272

189,404

169,670

149,118

238,157

188,694

172,729

135,432

168,367

164,065

128,575

100,070

119,083

108,104

94,456

76,711

104,409

103,360

84,149

73,891

95,386

88,466

77,291

66,977

74,784

81,281

74,083

66,703

93,187

81,683

70,845

82,301

Lease liabilities

102,083

105,624

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Convertible senior notes, net

323,676

320,477

317,322

314,210

311,141

308,114

305,128

302,184

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred revenue, net

19,205

21,277

23,527

21,169

21,381

22,643

23,758

20,667

21,845

24,519

19,892

2,848

2,774

5,788

9,745

5,638

4,167

2,658

1,800

1,812

1,290

1,975

6,395

5,552

5,211

3,686

3,845

3,022

2,014

2,057

2,569

6,953

14,992

25,313

Other liabilities

1,475

1,435

19,641

7,915

1,739

1,195

774

1,121

1,631

1,796

2,112

2,393

2,866

3,317

3,415

3,472

3,762

3,951

4,350

4,381

4,510

4,603

4,760

4,695

4,900

5,029

5,212

5,388

5,555

5,362

4,529

384

241

774

Total liabilities

629,025

613,499

592,762

532,698

503,931

481,070

567,817

512,666

196,205

161,747

190,371

169,306

134,215

109,175

132,243

117,214

102,385

83,320

110,559

109,553

89,949

80,469

106,541

98,713

87,402

75,692

83,841

89,691

81,652

74,122

100,285

89,020

86,078

108,388

Commitments and contingencies (Note 7)

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

0

-

-

-

0

-

-

-

0

-

-

-

0

-

-

0

STOCKHOLDERS’ EQUITY:
Common stock

8

8

8

8

8

8

8

8

8

8

8

7

7

7

7

7

7

7

7

7

7

7

7

7

7

7

6

6

6

5

5

5

5

1

Additional paid-in capital

1,444,597

1,417,037

1,391,904

1,366,899

1,346,620

1,321,878

1,296,380

1,276,379

993,559

850,705

828,415

799,491

781,635

761,906

742,690

715,253

697,628

679,080

662,869

645,349

640,573

633,939

629,076

657,027

650,148

636,904

215,151

230,013

224,730

216,850

207,624

214,151

189,036

20,231

Accumulated other comprehensive income (loss)

-7,259

-6,683

-7,758

-7,944

-7,554

-8,713

-7,748

-6,598

-4,778

-6,567

-5,796

-7,718

-7,890

-7,667

-6,593

-5,787

-7,881

-6,700

-6,343

-4,971

-5,458

-2,606

-1,367

-1,386

-1,971

-1,152

-1,574

-652

-477

-512

-496

-386

-399

-209

Retained earnings

155,219

175,163

190,047

167,038

175,308

174,550

124,976

50,078

98,700

144,255

65,903

42,128

43,947

39,973

47,831

31,734

32,138

31,225

32,855

20,962

23,949

19,973

22,970

-20,653

-19,295

-18,403

8,249

-19,893

-17,223

-22,724

-23,171

-26,719

-29,868

-38,371

Total stockholders’ equity

1,592,565

1,585,525

1,574,201

1,526,001

1,514,382

1,487,723

1,413,616

1,319,867

1,087,489

988,401

888,530

833,908

817,699

794,219

783,935

741,207

721,892

703,612

689,388

661,347

659,071

651,313

650,686

634,995

628,889

617,356

221,832

209,474

207,036

193,619

183,962

187,051

158,774

18,152

TOTAL LIABILITIES AND STOCKHOLDERS’ EQUITY

2,221,590

2,199,024

2,166,963

2,058,699

2,018,313

1,968,793

1,981,433

1,832,533

1,283,694

1,150,148

1,078,901

1,003,214

951,914

903,394

916,178

858,421

824,277

786,932

799,947

770,900

749,020

731,782

757,227

733,708

716,291

693,048

305,673

299,165

288,688

267,741

284,247

276,071

244,852

126,540