Yelp inc. (YELP)
Balance Sheet / 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'11
Assets
Current assets:
Cash and cash equivalents

364,576

170,281

123,402

139,464

295,276

332,764

423,495

389,416

392,335

547,850

362,401

319,754

272,279

272,201

224,891

196,295

183,505

171,613

171,807

181,460

172,629

247,312

290,567

290,386

399,320

389,764

101,214

96,795

94,498

95,124

123,083

122,613

130,737

21,736

Short-term marketable securities

122,618

242,000

258,414

272,754

331,139

423,096

414,002

413,946

422,283

273,366

195,768

192,041

213,197

207,332

207,404

201,806

191,952

199,214

197,132

186,673

158,603

118,498

73,527

60,429

-

0

-

-

-

-

-

-

-

-

Restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

29

-

-

-

Accounts receivable (net of allowance for doubtful accounts of $14,588 and $7,686 at March 31, 2020 and December 31, 2019, respectively)

85,875

106,832

101,441

95,732

89,301

87,305

81,835

78,452

75,533

76,173

68,483

68,778

68,119

68,725

66,588

59,887

54,774

52,755

46,942

41,339

38,969

35,593

31,175

25,450

21,376

21,317

17,192

14,769

12,327

11,738

10,722

10,120

7,179

8,257

Prepaid expenses and other current assets

21,804

14,196

16,042

23,338

59,326

17,104

17,567

20,621

19,975

15,700

15,694

14,298

14,459

12,921

15,609

15,753

17,109

19,700

31,952

22,713

22,706

19,355

9,485

7,960

9,087

5,752

6,809

6,441

6,880

4,470

2,867

2,630

2,508

1,733

Assets held for sale

-

-

-

-

-

-

-

-

-

-

143,873

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Total current assets

594,873

533,309

499,299

531,288

775,042

860,269

936,899

902,435

910,126

913,089

786,219

594,871

568,054

561,179

514,492

473,741

447,340

443,282

447,833

432,185

392,907

420,758

404,754

384,225

429,783

416,833

125,215

118,005

113,705

111,332

136,701

135,363

140,424

31,726

Long-term marketable securities

3,500

53,499

34,964

45,379

49,646

0

0

0

14,898

25,032

-

-

-

0

-

6,000

8,272

-

0

0

16,495

38,612

53,621

61,704

-

0

-

-

-

-

-

-

-

-

Property, equipment and software, net

110,141

110,949

113,935

114,105

111,477

114,800

110,899

109,673

107,889

103,651

94,348

91,714

91,727

92,440

93,838

89,502

84,776

80,467

78,342

72,603

68,594

62,761

43,333

37,462

33,298

30,666

25,921

19,779

15,772

14,799

12,623

11,632

10,649

9,881

Operating lease right-of-use assets

199,053

197,866

207,852

217,798

229,480

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Goodwill

103,976

104,589

103,459

105,313

104,662

105,620

106,323

106,526

109,420

107,954

107,186

216,440

197,489

170,667

173,626

172,908

173,733

172,197

173,996

173,296

172,160

67,307

55,808

59,271

59,635

59,690

58,814

46,678

45,993

48,605

-

-

-

0

Intangibles, net

9,304

10,082

10,778

11,588

12,477

13,359

14,242

15,125

16,009

16,893

17,815

45,411

43,393

32,611

34,302

35,992

37,590

39,294

41,068

42,458

44,187

5,786

4,541

3,996

4,615

5,235

5,772

4,716

5,183

5,936

-

-

-

131

Restricted cash

22,300

22,000

22,100

22,100

22,199

22,100

22,121

22,166

18,800

18,554

18,595

18,539

18,464

17,317

17,311

17,306

17,306

16,486

16,253

16,285

17,899

17,943

12,986

3,684

3,655

3,247

8,168

8,102

6,332

6,400

6,401

6,362

1,497

365

Other non-current assets

42,045

38,369

36,355

35,880

32,877

59,444

42,773

42,299

41,357

40,428

2,952

3,140

3,044

10,992

12,019

4,349

3,950

3,701

6,913

4,560

3,644

16,483

2,356

2,814

2,488

306

440

262

309

624

807

491

517

1,718

Total assets

1,085,224

1,070,700

1,028,769

1,083,433

1,337,860

1,175,563

1,233,257

1,198,224

1,218,499

1,225,601

1,027,115

970,115

922,171

885,206

845,588

799,798

772,967

755,427

764,405

741,387

715,886

629,650

577,399

553,156

533,474

515,977

224,330

197,542

187,294

187,696

156,532

153,848

153,087

43,821

Liabilities and Stockholders' Equity
Current liabilities:
Accounts payable and accrued liabilities

74,702

72,333

-

-

-

61,062

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accounts payable

-

-

3,139

2,882

2,931

-

6,829

9,808

6,620

9,033

2,269

3,183

3,963

2,003

1,005

1,325

3,200

3,388

3,305

1,706

1,836

1,398

2,226

1,680

1,578

3,364

2,839

1,929

3,020

2,284

2,221

2,698

3,441

2,973

Accounts payable- merchant share

-

-

-

-

-

-

-

-

-

-

878

17,210

18,832

18,352

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accrued liabilities

-

-

71,739

71,708

68,091

-

58,564

52,469

83,413

73,665

48,320

40,936

45,971

36,730

59,330

51,563

52,764

43,458

49,246

37,716

41,888

29,581

27,415

21,621

23,992

19,004

22,040

17,689

15,153

14,974

10,110

9,194

8,030

7,685

Operating lease liabilities — current

62,342

57,507

57,013

56,500

55,805

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred revenue

3,637

4,315

4,222

4,617

3,924

3,843

3,392

3,668

3,474

3,469

3,667

3,800

3,588

3,314

3,227

3,337

2,977

2,931

2,543

2,546

3,657

2,994

2,145

2,186

2,184

2,621

2,221

2,739

3,086

2,856

1,243

1,276

999

2,072

Liabilities held for sale

-

-

-

-

-

-

-

-

-

-

25,170

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Total current liabilities

140,681

134,155

136,113

135,707

130,751

64,905

68,785

65,945

93,507

86,167

80,304

65,129

72,354

60,399

63,562

56,225

58,941

49,777

55,094

41,968

47,381

33,973

31,786

25,487

27,754

24,989

27,100

22,357

21,259

20,114

13,574

13,168

12,470

12,730

Operating lease liabilities — long-term

175,073

174,756

186,056

197,272

208,318

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other long-term liabilities

7,038

6,798

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other long-term liabilities

-

-

4,036

3,999

3,953

35,140

34,978

33,845

32,839

30,737

21,515

18,320

17,882

17,621

16,445

14,466

13,332

12,030

12,849

13,254

11,849

7,527

6,990

6,424

5,784

4,505

799

688

601

1,920

2

2

3

3

Total liabilities

322,792

315,709

326,205

336,978

343,022

100,045

103,763

99,790

126,346

116,904

101,819

83,449

90,236

78,020

80,007

70,691

72,273

61,807

67,943

55,222

59,230

41,500

38,776

31,911

33,538

29,494

27,899

23,045

21,860

22,034

13,576

13,170

12,473

12,733

Commitments and contingencies (Note 12)

-

-

-

-

-

-

0

0

0

-

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Stockholders' equity:
Redeemable convertible preferred stock (Note 11)

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

55,435

Common stock, $0.000001 par value, 200,000,000 shares authorized – 71,887,846 and 71,185,468 shares issued and outstanding at March 31, 2020 and December 31, 2019, respectively

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Additional paid-in capital

1,283,885

1,259,803

1,220,048

1,194,486

1,160,254

1,139,462

1,109,199

1,086,727

1,059,168

1,038,017

1,001,633

965,049

921,441

892,983

856,115

822,385

793,468

774,022

752,795

734,867

705,397

627,742

607,012

588,829

569,925

553,753

262,675

240,752

231,525

225,245

197,872

193,657

191,448

16,625

Treasury stock

-

-

-

5,952

-

-

0

0

15,000

46

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accumulated other comprehensive loss

-12,863

-11,759

-13,297

-11,163

-11,732

-11,021

-10,225

-10,032

-6,845

-8,444

-9,107

-10,972

-14,505

-15,576

-12,050

-12,724

-11,777

-13,519

-11,679

-12,130

-13,474

-5,609

-1,678

2,764

3,102

3,186

2,143

-190

-904

805

152

79

242

271

Accumulated deficit

-508,590

-493,053

-504,187

-430,916

-153,684

-52,923

30,520

21,739

54,830

79,170

-67,230

-67,411

-75,001

-70,221

-78,484

-80,554

-80,997

-66,883

-44,654

-36,572

-35,267

-33,983

-66,711

-70,348

-73,091

-70,456

-68,387

-66,065

-65,187

-60,388

-55,068

-53,058

-51,076

-41,243

Total stockholders' equity

762,432

754,991

702,564

746,455

994,838

1,075,518

1,129,494

1,098,434

1,092,153

1,108,697

925,296

886,666

831,935

807,186

765,581

729,107

700,694

693,620

696,462

686,165

656,656

588,150

538,623

521,245

499,936

486,483

196,431

174,497

165,434

165,662

142,956

140,678

140,614

-24,347

Total liabilities and stockholders' equity

1,085,224

1,070,700

1,028,769

1,083,433

1,337,860

1,175,563

1,233,257

1,198,224

1,218,499

1,225,601

1,027,115

970,115

922,171

885,206

845,588

799,798

772,967

755,427

764,405

741,387

715,886

629,650

577,399

553,156

533,474

515,977

224,330

197,542

187,294

187,696

156,532

153,848

153,087

43,821