Yelp inc. (YELP)
CashFlow / Quarterly
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'11
Operating Activities
Net (loss) income attributable to common stockholders

-15,503

17,152

10,061

12,303

1,365

31,946

14,986

10,704

-2,286

141,121

7,996

7,904

-4,026

11,222

2,070

449

-15,452

-22,229

-8,082

-1,305

-1,284

32,728

3,637

2,743

-2,635

-2,069

-2,322

-878

-4,799

-5,318

-2,011

-1,982

-9,802

-9,046

-3,751

-1,165

-2,706

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

12,358

12,849

12,391

12,240

11,876

11,557

10,713

10,509

10,028

9,728

10,657

10,662

10,151

9,434

9,159

8,564

8,189

7,980

7,562

7,167

6,895

5,291

4,604

4,034

3,661

3,524

2,816

2,637

2,478

2,421

1,780

1,661

1,361

1,448

1,047

924

819

Provision for doubtful accounts

15,933

7,284

6,543

4,452

4,264

5,230

6,367

5,282

7,636

5,678

4,447

4,891

5,901

6,768

4,714

2,334

5,091

6,387

4,325

2,642

3,434

3,344

1,313

1,395

1,186

1,126

877

750

551

1,720

85

118

-10

625

6

61

-65

Stock-based compensation

31,750

30,506

29,236

30,451

31,319

28,654

29,193

28,805

27,734

25,408

25,308

25,365

24,334

23,865

22,560

20,726

19,110

15,972

15,683

15,516

13,671

11,816

10,918

10,083

9,456

8,789

7,015

5,713

5,160

3,257

2,334

1,858

7,429

1,366

1,460

948

1,103

Noncash lease cost

10,378

9,986

9,946

11,682

9,751

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred income taxes

-7,450

-2,126

1,239

-653

-1,259

-15,469

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loss on disposal of assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

14

-92

-52

-9

0

5

0

29

-94

-44

-50

-89

-12

36

1

-22

3

1

5

Premium amortization, net, on marketable securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-346

-598

117

-135

-121

-93

0

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit from stock-based award activity

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,285

346

3,137

815

935

439

421

39

353

0

0

0

-

-

-

-

-

-

-

-

Other adjustments, net

-287

-438

-927

-473

-1,159

2,071

-2,572

185

-406

1,232

13

14

253

1,659

430

404

480

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

-5,024

12,675

12,252

10,883

6,260

10,708

9,748

8,213

6,995

16,336

10,149

5,203

4,458

10,451

10,930

8,002

5,235

7,506

9,918

5,005

2,850

7,519

7,056

5,467

1,249

5,286

3,153

3,200

1,204

1,461

684

3,063

-1,090

1,105

1,191

555

-577

Prepaid expenses and other assets

4,118

-963

-3,023

43

5,292

3,107

-4,839

1,850

5,074

504

656

-232

1,653

910

-146

-608

-2,884

7,646

7,978

1,034

6,045

-3,327

1,358

52

5,928

-1,448

702

803

1,515

792

842

366

552

902

-214

540

-129

Operating lease liabilities

6,663

-72,810

10,703

10,351

9,948

0

0

0

0

-350

-134

210

274

90

-110

362

43

387

-2

-1,109

683

864

-20

5

-438

382

-595

-366

281

386

-33

277

-1,073

244

426

-421

384

Accounts payable, accrued liabilities and other liabilities

-636

2,819

2,865

8,092

6,372

-6,102

1,400

-22,781

7,659

37,406

14,156

-8,987

10,459

2,085

7,238

-2,814

8,769

-8,010

8,288

3,605

12,011

-1,972

7,332

-1,742

5,309

1,792

2,964

1,391

-1,176

1,377

95

1,794

-1,217

1,984

719

522

750

Net cash provided by operating activities

40,786

55,514

51,422

56,817

41,029

44,072

55,178

22,641

38,296

39,686

51,638

35,088

41,235

45,113

35,277

22,631

23,879

3,835

9,862

18,030

25,635

18,893

19,050

10,666

9,323

9,324

6,994

5,288

-174

1,629

712

333

-2,773

546

-1,067

-225

996

Investing Activities
Sales and maturities of marketable securities — available-for-sale

164,215

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of intangible assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

333

0

314

390

1,334

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Maturities of investment securities, held-to-maturity

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

21,000

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of marketable securities — held-to-maturity

87,438

-

-

-

157,567

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

26,133

122,226

0

-

-

-

-

-

-

-

-

-

-

-

-

Maturities of marketable securities — held-to-maturity

93,200

-

-

-

201,497

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of marketable securities

-

-

-

-

-

178,449

169,464

122,431

280,893

175,338

54,702

50,884

73,971

53,194

59,917

69,753

92,101

73,443

78,803

57,794

36,120

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Maturities of marketable securities

-

-

-

-

-

152,900

170,800

147,000

143,000

73,000

51,000

72,000

68,000

53,000

60,000

62,000

90,500

71,000

68,000

45,620

18,250

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisition, net of cash received

-

-

-

-

-

-

-

-

-

0

0

19,711

30,833

0

0

0

0

0

0

1,876

71,546

14,340

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of property, equipment and software

7,053

7,572

10,736

10,223

8,991

11,035

8,780

9,532

15,625

22,353

3,813

1,627

2,452

5,196

5,360

4,793

7,645

5,769

7,299

7,178

10,881

16,311

5,531

2,966

4,246

6,696

4,581

4,023

943

4,040

1,557

1,560

367

2,038

1,282

665

813

Proceeds from sale of property, equipment and software

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

12

97

0

0

14

0

-

-

-

-

-

-

-

-

-

-

-

-

Capitalized website and software development costs

-

-

-

-

-

-

-

-

-

-

-

3,822

4,208

3,595

3,603

3,868

3,125

3,076

2,646

2,816

3,196

3,380

3,642

2,735

1,592

1,591

1,126

1,170

969

596

744

978

612

898

553

518

537

Other investing activities

-295

-78

-107

-61

-215

-181

-30

-7

-27

-88

-11

-29

-29

-836

-21

128

820

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

8

-1,677

5

5,008

9,359

0

397

-4,944

0

1,768

0

-35

40

4,896

1,112

-216

0

365

0

Net cash provided by investing activities

163,219

-8,797

15,223

82,755

35,154

-18,508

-7,414

15,044

-153,491

140,296

-11,710

-4,015

-43,435

-8,149

-16,859

-16,542

-13,191

-11,523

-21,089

-22,355

-103,715

-69,527

-24,999

-127,913

-6,235

-3,343

-7,764

-5,808

-1,912

-28,726

-2,341

-7,434

-2,091

-2,720

-1,835

-1,548

-1,350

Financing Activities
Proceeds from initial public offering, net of underwriter fees

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,749

0

-1,150

113,407

0

0

0

0

Proceeds from follow-on offering, net of offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-2,824

2,062

251

511

-1,025

629

235

161

Proceeds from issuance of common stock for employee stock-based plans

2,585

16,450

4,615

10,053

1,145

7,944

5,614

10,539

5,682

11,361

10,202

16,067

3,287

11,467

10,200

6,810

1,045

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repurchases of common stock

0

6,018

77,380

295,487

102,126

115,389

6,204

32,480

33,309

4,813

7,743

0

0

-

-

-

-

0

86

228

168

283

393

281

361

306

175

112

81

-

-

0

0

-

-

-

-

Issuance of common stock upon exercise of employee stock options

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,398

-

6,475

4,106

6,735

-9,702

5,098

2,947

1,657

-

-

-

-

-

-

-

-

Excess tax benefit from share-based award activity

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,285

346

3,137

815

935

439

421

39

353

0

0

0

-

-

-

-

-

-

-

-

Taxes paid related to the net share settlement of equity awards

11,514

9,987

10,179

10,108

12,497

9,063

13,128

15,606

12,347

1,199

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-8,929

445

-82,944

-295,542

-113,478

-116,508

-13,718

-37,547

-39,974

5,349

2,459

16,067

3,287

11,467

10,200

6,810

1,045

7,676

1,615

13,106

4,045

8,282

6,521

8,333

6,413

282,386

4,923

2,835

1,576

-908

2,062

-899

113,918

557

629

235

161

Effect of exchange rate changes on cash, cash equivalents and restricted cash

-486

-373

282

41

-65

163

-12

309

-100

77

316

410

138

-290

-22

-109

159

-182

-41

50

-648

-903

-391

-20

55

183

266

-18

-116

46

37

-124

-53

225

258

-84

-116

Change in cash, cash equivalents and restricted cash

194,590

46,789

-16,017

-155,929

-37,360

-90,781

34,034

447

-155,269

185,408

42,703

47,550

1,225

48,141

28,596

12,790

11,892

-194

-9,653

8,831

-74,683

-43,255

181

-108,934

9,556

288,550

4,419

2,297

-626

-27,959

470

-8,124

109,001

-1,392

-2,015

-1,622

-309

Supplemental Disclosures of Other Cash Flow Information
Refunds received for income taxes, net

-290

1,210

2,859

3,251

-408

339

5

28,609

206

448

81

108

-107

125

117

55

516

215

141

-426

422

1,486

226

145

115

175

33

70

13

30

32

31

17

62

-5

22

13

Supplemental Disclosures of Noncash Investing and Financing Activities
Purchases of property, equipment and software recorded in accounts payable and accrued liabilities

3,015

-366

-415

436

1,835

2,047

99

52

2,242

7,938

2,157

802

596

-3,384

1,059

1,587

1,727

-3,213

3,400

-1,498

3,544

4,383

975

-695

1,880

-1,193

2,142

440

1,296

-221

75

-84

779

-794

1,251

-52

285

Deferred offering costs recorded in accounts payable and accrued liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,150

-

-

-

0

Capitalized website and software development costs recorded in accounts payable and accrued liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

15

-

165

-42

67

-14

31

0

0

-

-

-87

97

-6

6

0

0

Goodwill measurement period adjustment

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

146

-306

0

0

51

0

0

0

0

-

-

-

1,153

-

-

-

0

-

-

-

-

Tax liability related to net share settlement of equity awards included in accrued liabilities

1,043

16

-86

-190

1,172

-708

591

-4

1,092

1,323

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repurchases of common stock recorded in accrued liabilities

0

-

-

-6,129

8,510

-

-

-3,684

3,684

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Operating lease right-of-use assets obtained in exchange for new operating lease liabilities

11,833

0

0

0

6,325

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisition consideration included in accruals

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,876

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Issuance of common stock in connection with acquisition

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

59,158

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accretion of redeemable convertible preferred stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1

0

0

31

48

47

47

47

Vesting of early exercised options

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

15

15

16

15

22

20

24

21