Servicenow, inc. (NOW)
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'12
Cash flows from operating activities:
Net Income (Loss) Attributable to Parent

676,474

626,698

34,989

2,796

-38,871

-26,704

-51,065

-81,652

-84,710

-116,846

-94,534

-108,610

-102,431

-414,249

-456,593

-461,365

-473,665

-198,426

-205,711

-205,731

-194,169

-179,387

-158,956

-132,619

-103,661

-73,708

-59,407

-57,747

-45,066

-37,348

0

0

0

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

272,903

252,114

222,895

196,763

171,642

149,604

138,559

130,086

122,060

113,875

105,174

98,037

90,856

83,082

76,115

68,951

63,984

60,356

57,282

54,286

47,945

42,059

36,570

31,079

27,726

24,152

20,981

18,337

15,824

13,506

0

0

0

Amortization of premiums on investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-5,429

-6,251

-6,724

-7,064

-7,420

-7,837

-8,100

-8,084

-7,361

-6,384

-5,477

-4,758

-5,372

-3,668

-2,432

-1,337

0

0

0

Amortization of deferred commissions

177,938

168,014

158,217

158,585

152,496

143,358

138,318

120,323

107,486

99,105

79,977

75,694

73,570

69,565

75,228

71,217

67,977

65,541

62,927

58,916

55,718

51,270

45,937

41,002

35,147

29,364

24,271

20,363

16,733

13,710

0

0

0

Amortization of Debt Issuance Costs and Discounts

33,685

33,283

33,746

36,608

43,837

52,733

60,608

65,941

61,780

53,394

45,113

36,936

33,847

33,278

32,719

32,169

31,628

31,097

30,575

30,061

29,556

29,059

25,106

17,781

10,579

3,498

0

0

0

-

-

-

-

Stock-based compensation

693,030

662,195

634,788

616,262

580,062

543,953

506,936

462,970

425,476

394,004

371,571

352,216

332,215

317,654

302,642

286,666

274,947

257,713

235,527

211,906

183,164

154,319

129,179

105,540

82,764

65,581

54,074

44,436

36,065

27,937

0

0

0

Deferred income taxes

575,812

575,765

4,725

6,327

11,312

34,180

31,966

31,899

26,781

5,724

1,618

-1,017

3,949

658

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Gain on marketable equity securities

-

-

-

-

-

19,257

19,257

19,257

18,455

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayments of convertible senior notes attributable to debt discount

282

0

43,716

57,792

136,689

145,349

101,633

87,557

8,660

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other

-7,374

-8,921

-2,946

4,561

12,706

6,177

5,151

-598

-5,437

-905

3,067

1,218

2,821

3,764

-1,687

-1,451

-4,610

-6,223

-7,889

-7,119

-6,919

-4,469

-2,651

-1,945

484

558

0

0

0

-

-

-

-

Bad debt expense

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Lease abandonment costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Changes in operating assets and liabilities, net of effect of business combinations:
Accounts receivable

202,151

259,835

125,271

140,734

64,545

146,148

138,118

88,939

78,706

99,693

64,775

78,196

93,711

126,415

61,313

55,227

45,480

50,855

55,153

43,348

46,322

56,785

29,453

15,713

26,595

29,506

29,264

46,509

38,337

33,341

0

0

0

Deferred commissions

279,803

255,605

245,170

243,581

243,506

239,382

228,253

213,294

201,765

190,246

187,245

173,471

158,906

151,921

105,164

95,707

88,713

80,142

80,839

78,652

75,954

73,786

67,164

62,129

58,906

54,943

43,544

36,879

33,191

29,175

0

0

0

Prepaid expenses and other assets

16,639

29,907

46,974

50,409

37,737

19,886

15,376

28,642

33,628

34,288

29,824

17,769

20,824

24,164

13,779

12,936

11,882

10,961

12,069

12,465

15,517

5,540

-8

3,225

9,127

-3,471

6,069

2,512

3,388

2,904

0

0

0

Other assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Accounts payable

35,472

21,355

20,273

22,968

930

-4,757

10,642

-276

-5,304

-5,504

-6,017

-11,142

-6,266

-3,554

-2,152

12,879

18,166

14,785

14,643

881

-1,846

10,223

4,048

10,849

13,294

-252

4,585

3,799

1,983

4,887

0

0

0

Deferred revenue

535,726

537,249

430,253

437,957

446,493

468,856

355,009

366,915

368,112

369,242

322,411

314,156

299,199

285,139

231,107

209,742

210,842

195,900

191,854

195,638

182,082

168,393

132,424

117,143

110,848

94,405

76,096

78,633

79,552

64,845

0

0

0

Accrued expenses and other liabilities

23,525

65,097

38,014

62,039

47,153

82,071

76,705

108,462

83,944

66,526

50,449

57,611

-176,929

87,560

57,613

47,238

280,439

33,187

22,302

10,583

18,506

-1,305

6,396

9,051

3,888

16,257

18,823

23,942

14,898

24,902

0

0

0

Other long-term liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Net cash provided by operating activities

1,366,692

1,235,972

1,104,373

1,039,696

921,857

811,089

706,260

702,583

705,412

642,940

590,004

544,898

268,002

159,081

133,788

100,719

329,075

317,754

260,861

222,212

184,086

140,937

127,543

123,263

90,940

81,746

62,150

50,507

47,710

48,766

0

0

0

Cash flows from investing activities:
Purchases of property and equipment

300,975

264,892

274,002

233,120

236,215

224,462

171,003

169,769

152,695

150,510

137,306

121,736

109,671

105,562

109,005

98,590

89,859

87,481

71,468

68,794

70,110

54,379

61,761

60,491

55,874

55,321

48,969

44,075

43,923

42,066

0

0

0

Business combinations, net of cash acquired

90,362

7,414

0

0

0

-

-

-

-

58,203

26,537

21,537

48,832

34,297

34,297

34,297

500

1,100

1,100

100,913

100,913

99,813

0

0

0

-

-

-

-

-

-

-

-

Purchases of other intangibles

-

-

-

-

-

24,400

14,100

11,350

14,520

6,670

14,170

14,170

13,000

18,750

12,500

12,500

7,500

1,750

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of investments

1,684,704

1,595,667

1,724,475

1,716,510

1,358,434

1,295,782

1,379,593

1,215,584

1,346,795

1,194,261

725,933

696,889

561,895

518,664

604,012

561,651

760,783

712,782

703,777

611,577

518,901

521,393

698,018

627,228

649,589

570,679

327,148

401,470

281,228

240,626

0

0

0

Sales and maturities of investments

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of strategic investments

-

-

-

-

-

-

-

-

0

-

-

-

-

500

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Sales of investments

-

-

-

-

-

39,975

47,113

47,113

63,317

85,106

109,678

283,081

226,902

297,998

300,702

231,568

320,518

277,045

311,821

236,466

190,881

166,997

102,562

80,753

80,686

55,158

0

0

0

-

-

-

-

Realized gains on derivatives not designated as hedging instruments, net

49,203

23,435

-21,742

-22,113

-22,148

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Maturities of investments

-

-

-

-

-

1,194,687

951,622

671,797

500,432

440,590

403,682

334,966

301,942

271,537

319,867

316,907

320,519

305,047

260,729

271,207

223,433

191,715

173,716

141,271

170,872

181,554

179,129

149,924

97,823

42,473

0

0

0

Restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

710

-

408

-66

-31

55

58

69

232

177

137

126

-37

-45

0

0

0

Net cash used in investing activities

-908,638

-724,477

-772,884

-739,878

-311,049

-347,422

-618,567

-739,399

-993,429

-883,948

-394,764

-236,174

-204,597

-108,238

-139,659

-159,740

-228,593

-231,521

-214,203

-283,545

-275,579

-316,928

-583,372

-479,094

-467,467

-402,795

-160,052

-252,449

-226,266

-239,149

0

0

0

Cash flows from financing activities:
Repayments of convertible senior notes attributable to principal

2,245

9

118,125

158,460

401,039

429,645

311,524

271,189

28,610

4

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net proceeds from issuance of common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

17,848

0

0

0

Purchases of common stock and restricted stock from stockholders

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

Proceeds from employee stock plans

121,683

107,868

108,950

106,041

104,596

104,160

106,256

103,094

100,417

82,567

88,063

73,119

81,312

66,378

75,064

85,815

82,747

93,348

88,345

82,269

77,656

69,396

62,524

52,940

56,705

55,959

0

0

0

-

-

-

0

Taxes paid related to net share settlement of equity awards

395,922

409,715

390,544

374,098

334,948

281,010

272,076

249,120

214,470

181,938

162,470

147,470

144,477

119,907

88,759

60,135

40,513

12,795

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Payments on financing obligations

-

-

-

-

-

-933

-2,989

-2,930

-3,787

-4,914

-3,543

-4,560

-3,528

-2,223

-1,472

-446

-333

-223

0

0

0

-

-

-

-

0

0

0

0

-

-

-

-

Net cash used in financing activities

-276,484

-301,856

-399,896

-426,874

-632,036

-607,428

-480,333

-420,145

496,731

538,892

565,231

564,270

-66,693

-55,752

-15,167

25,234

41,901

80,330

74,273

68,545

75,320

68,735

574,712

564,295

569,103

568,570

101,198

257,404

244,533

241,839

0

0

0

Foreign currency effect on cash, cash equivalents and restricted cash

-11,914

-186

-12,376

-6,739

-20,942

-15,530

-7,345

2,468

35,347

28,013

20,289

12,398

-9,342

-5,945

-2,768

-2,254

3,286

-6,513

-6,944

-11,133

-13,766

-6,592

-4,891

578

562

-207

822

-711

-1,335

-555

0

0

0

Net increase in cash, cash equivalents and restricted cash

169,656

209,453

-80,783

-133,795

-42,170

-159,291

-399,985

-454,493

244,061

325,897

780,760

885,392

-12,630

-10,854

-23,806

-36,041

145,669

160,050

113,987

-3,921

-29,939

-113,848

113,992

209,042

193,138

247,314

4,118

54,751

64,642

50,901

0

0

0

Supplemental disclosures of other cash flow information:
Income taxes paid, net of refunds

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash investing and financing activities:
Settlement of 2022 Notes conversion feature

3,728

0

218,830

300,148

728,085

773,302

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Benefit from exercise of 2022 Note Hedge

3,552

0

218,857

299,708

722,348

766,858

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Benefit from 2018 Note Hedges

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Property and equipment included in accounts payable and accrued expenses

69,216

56,966

27,315

32,680

30,481

25,767

30,704

24,004

30,438

15,007

15,011

17,353

15,845

15,381

9,737

15,103

14,345

14,427

18,474

11,026

7,700

10,313

4,601

10,654

8,672

3,741

2,826

1,267

4,313

1,234

0

0

0

Financing obligation for property and equipment

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-