Yelp inc. (YELP)

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'12Dec'11Sep'11Jun'11Mar'11
Operating Activities
Net (loss) income attributable to common stockholders

24,013

40,881

55,675

60,600

59,001

55,350

164,525

157,535

154,735

152,995

23,096

17,170

9,715

-1,711

-35,162

-45,314

-47,068

-32,900

22,057

33,776

37,824

36,473

1,676

-4,283

-7,904

-10,068

-13,317

-13,006

-14,110

-19,113

-22,841

-24,581

-23,764

-16,668

0

0

0

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

49,838

49,356

48,064

46,386

44,655

42,807

40,978

40,922

41,075

41,198

40,904

39,406

37,308

35,346

33,892

32,295

30,898

29,604

26,915

23,957

20,824

17,590

15,823

14,035

12,638

11,455

10,352

9,316

8,340

7,223

6,250

5,517

4,780

4,238

0

0

0

Provision for doubtful accounts

34,212

22,543

20,489

20,313

21,143

24,515

24,963

23,043

22,652

20,917

22,007

22,274

19,717

18,907

18,526

18,137

18,445

16,788

13,745

10,733

9,486

7,238

5,020

4,584

3,939

3,304

3,898

3,106

2,474

1,913

818

739

682

627

0

0

0

Stock-based compensation

121,943

121,512

119,660

119,617

117,971

114,386

111,140

107,255

103,815

100,415

98,872

96,124

91,485

86,261

78,368

71,491

66,281

60,842

56,686

51,921

46,488

42,273

39,246

35,343

30,973

26,677

21,145

16,464

12,609

14,878

12,987

12,113

11,203

4,877

0

0

0

Noncash lease cost

41,992

41,365

31,379

21,433

9,751

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred income taxes

-8,990

-2,799

-16,142

-17,381

-16,728

-15,469

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loss on disposal of assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-139

-153

-56

-4

34

-60

-109

-159

-277

-195

-115

-64

3

18

-17

-13

0

0

0

Premium amortization, net, on marketable securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-962

-737

-232

-349

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit from stock-based award activity

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

6,583

5,233

5,326

2,610

1,834

1,252

813

392

353

0

0

0

-

-

-

-

-

-

-

-

Other adjustments, net

-2,125

-2,997

-488

-2,133

-1,475

-722

-1,561

1,024

853

1,512

1,939

2,356

2,746

2,973

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

30,786

42,070

40,103

37,599

34,929

35,664

41,292

41,693

38,683

36,146

30,261

31,042

33,841

34,618

31,673

30,661

27,664

25,279

25,292

22,430

22,892

21,291

19,058

15,155

12,888

12,843

9,018

6,549

6,412

4,118

3,762

4,269

1,761

2,274

0

0

0

Prepaid expenses and other assets

175

1,349

5,419

3,603

5,410

5,192

2,589

8,084

6,002

2,581

2,987

2,185

1,809

-2,728

4,008

12,132

13,774

22,703

11,730

5,110

4,128

4,011

5,890

5,234

5,985

1,572

3,812

3,952

3,515

2,552

2,662

1,606

1,780

1,099

0

0

0

Operating lease liabilities

-45,093

-41,808

31,002

20,299

9,948

0

-350

-484

-274

0

440

464

616

385

682

790

-681

-41

436

418

1,532

411

-71

-646

-1,017

-298

-294

268

911

-443

-585

-126

-824

633

0

0

0

Accounts payable, accrued liabilities and other liabilities

13,140

20,148

11,227

9,762

-21,111

-19,824

23,684

36,440

50,234

53,034

17,713

10,795

16,968

15,278

5,183

6,233

12,652

15,894

21,932

20,976

15,629

8,927

12,691

8,323

11,456

4,971

4,556

1,687

2,090

2,049

2,656

3,280

2,008

3,975

0

0

0

Net cash provided by operating activities

204,539

204,782

193,340

197,096

162,920

160,187

155,801

152,261

164,708

167,647

173,074

156,713

144,256

126,900

85,622

60,207

55,606

57,362

72,420

81,608

74,244

57,932

48,363

36,307

30,929

21,432

13,737

7,455

2,500

-99

-1,182

-2,961

-3,519

250

0

0

0

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

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of intangible assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,037

2,038

2,038

1,724

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Maturities of investment securities, held-to-maturity

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of marketable securities — held-to-maturity

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Maturities of marketable securities — held-to-maturity

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of marketable securities

-

-

-

-

-

751,237

748,126

633,364

561,817

354,895

232,751

237,966

256,835

274,965

295,214

314,100

302,141

246,160

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Maturities of marketable securities

-

-

-

-

-

613,700

533,800

414,000

339,000

264,000

244,000

253,000

243,000

265,500

283,500

291,500

275,120

202,870

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisition, net of cash received

-

-

-

-

-

-

-

-

-

50,544

50,544

50,544

30,833

0

0

0

1,876

73,422

87,762

87,762

85,886

14,340

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of property, equipment and software

35,584

37,522

40,985

39,029

38,338

44,972

56,290

51,323

43,418

30,245

13,088

14,635

17,801

22,994

23,567

25,506

27,891

31,127

41,669

39,901

35,689

29,054

19,439

18,489

19,546

16,243

13,587

10,563

8,100

7,524

5,522

5,247

4,352

4,798

0

0

0

Proceeds from sale of property, equipment and software

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

109

109

111

14

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Capitalized website and software development costs

-

-

-

-

-

-

-

-

-

-

-

15,228

15,274

14,191

13,672

12,715

11,663

11,734

12,038

13,034

12,953

11,349

9,560

7,044

5,479

4,856

3,861

3,479

3,287

2,930

3,232

3,041

2,581

2,506

0

0

0

Other investing activities

-541

-461

-564

-487

-433

-245

-152

-133

-155

-157

-905

-915

-758

91

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,344

12,695

14,372

14,764

4,812

-4,547

-2,779

-3,176

1,733

1,773

4,901

6,013

5,832

5,792

1,261

149

0

0

0

Net cash provided by investing activities

252,400

124,335

114,624

91,987

24,276

-164,369

-5,565

-9,861

-28,920

81,136

-67,309

-72,458

-84,985

-54,741

-58,115

-62,345

-68,158

-158,682

-216,686

-220,596

-326,154

-228,674

-162,490

-145,255

-23,150

-18,827

-44,210

-38,787

-40,413

-40,592

-14,586

-14,080

-8,194

-7,453

0

0

0

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

114,006

112,257

112,257

113,407

0

0

0

0

Proceeds from follow-on offering, net of offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

1,799

366

350

0

0

0

0

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

33,703

32,263

23,757

24,756

25,242

29,779

33,196

37,784

43,312

40,917

41,023

41,021

31,764

29,522

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repurchases of common stock

378,885

481,011

590,382

519,206

256,199

187,382

76,806

78,345

45,865

12,556

0

0

0

-

-

-

-

482

765

1,072

1,125

1,318

1,341

1,123

954

674

0

0

0

-

-

0

0

-

-

-

-

Issuance of common stock upon exercise of employee stock options

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

7,614

6,237

5,078

0

0

0

0

-

-

-

-

-

-

-

-

Excess tax benefit from share-based award activity

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

6,583

5,233

5,326

2,610

1,834

1,252

813

392

353

0

0

0

-

-

-

-

-

-

-

-

Taxes paid related to the net share settlement of equity awards

41,788

42,771

41,847

44,796

50,294

50,144

42,280

29,152

13,546

1,199

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-386,970

-491,519

-608,472

-539,246

-281,251

-207,747

-85,890

-69,713

-16,099

27,162

33,280

41,021

31,764

29,522

25,731

17,146

23,442

26,442

27,048

31,954

27,181

29,549

303,653

302,055

296,557

291,720

8,426

5,565

1,831

114,173

115,638

114,205

115,339

1,582

0

0

0

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

-536

-115

421

127

395

360

274

602

703

941

574

236

-283

-262

-154

-173

-14

-821

-1,542

-1,892

-1,962

-1,259

-173

484

486

315

178

-51

-157

-94

85

306

346

283

0

0

0

Change in cash, cash equivalents and restricted cash

69,433

-162,517

-300,087

-250,036

-93,660

-211,569

64,620

73,289

120,392

276,886

139,619

125,512

90,752

101,419

53,084

14,835

10,876

-75,699

-118,760

-108,926

-226,691

-142,452

189,353

193,591

304,822

294,640

-21,869

-25,818

-36,239

73,388

99,955

97,470

103,972

-5,338

0

0

0

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

7,030

6,912

6,041

3,187

28,545

29,159

29,268

29,344

843

530

207

243

190

813

903

927

446

352

1,623

1,708

2,279

1,972

661

468

393

291

146

145

106

110

142

105

96

92

0

0

0

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

2,670

1,490

3,903

4,417

4,033

4,440

10,331

12,389

13,139

11,493

171

-927

-142

989

1,160

3,501

416

2,233

9,829

7,404

8,207

6,543

967

2,134

3,269

2,685

3,657

1,590

1,066

549

-24

1,152

1,184

690

0

0

0

Deferred offering costs recorded in accounts payable and accrued liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

0

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

176

42

84

17

0

0

0

-

-

10

97

0

0

0

0

Goodwill measurement period adjustment

-

-

-

-

-

-

-

-

-

-

-

-

-

146

-160

-160

-160

-255

51

51

51

0

0

0

0

-

-

-

0

-

-

-

0

-

-

-

-

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

783

912

188

865

1,051

971

3,002

2,411

2,415

1,323

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repurchases of common stock recorded in accrued liabilities

0

-

-

0

0

-

-

0

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

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

11,833

6,325

6,325

6,325

6,325

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisition consideration included in accruals

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Issuance of common stock in connection with acquisition

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

59,158

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accretion of redeemable convertible preferred stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

32

79

126

173

189

0

0

0

Vesting of early exercised options

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

61

68

73

81

87

0

0

0