Pandora media, inc. (P)
CashFlow / TTM
Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15Dec'14Sep'14Jun'14Mar'14Dec'13Oct'13Sep'13Jul'13Jun'13Apr'13Mar'13Jan'13Dec'12Oct'12Jul'12Apr'12Jan'12Oct'11Jul'11Apr'11
Operating activities
Net loss

-332,102

-334,679

-517,833

-518,395

-563,655

-558,946

-360,143

-342,978

-272,378

-296,774

-236,506

-169,661

-137,974

-54,069

-49,732

-30,406

-20,021

-22,088

-41,391

-27,017

-

-47,628

-

-48,951

0

0

-38,148

-

0

0

0

-

-

-

0

Adjustments to reconcile net loss to net cash used in operating activities
Loss on dispositions

-2,092

-11,551

-11,551

-9,378

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Depreciation and amortization

57,994

55,895

59,047

62,948

66,398

68,235

65,160

60,757

52,744

42,730

33,395

24,458

19,401

17,687

16,425

15,431

13,618

12,686

11,529

10,112

-

9,529

-

8,141

0

0

7,076

-

0

0

0

-

-

-

0

Loss on retirement of fixed assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-23

-

0

0

0

-

-

-

-

Stock-based compensation

112,906

114,169

125,249

128,431

132,944

135,597

129,421

138,458

136,013

132,053

127,105

111,645

106,412

99,729

92,858

87,055

71,331

61,384

50,543

40,041

-

35,899

-

29,772

0

0

25,500

-

0

0

0

-

-

-

0

Amortization (accretion) of premium on investments

1,197

662

90

-81

-144

-725

-598

-405

-3,962

-2,893

-2,390

-1,911

2,439

2,682

2,758

2,833

2,256

1,537

871

237

-

137

-

217

0

297

-

329

0

0

0

-

-

-

-

Accretion of discount on convertible promissory note receivable

1,050

1,221

1,221

687

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Remeasurement of preferred stock warrants

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Other operating activities

959

492

147

447

902

888

351

881

-1,145

-569

257

196

2,179

1,864

2,077

1,366

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of debt discount

20,610

20,772

20,663

20,153

19,662

19,176

18,767

18,315

14,671

10,022

5,518

1,084

0

0

0

-

-

-

-

0

-

258

-

264

0

0

264

-

0

0

0

-

-

-

0

Interest income

1,633

1,891

1,891

1,081

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Provision for bad debt

5,320

4,453

10,506

12,211

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities
Accounts receivable

45,626

33,243

14,541

36,760

38,666

35,255

29,283

35,710

18,446

27,642

46,572

55,904

67,132

58,059

41,925

55,478

67,697

60,095

39,438

60,613

-

44,535

-

41,393

0

0

36,672

-

0

0

0

-

-

-

0

Prepaid content acquisition costs

-57,013

-15,490

-12,641

9,358

-22,471

30,499

29,668

44,211

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses and other assets

3,503

8,766

12,575

16,566

17,621

12,598

14,933

12,321

23,777

24,284

15,410

17,519

10,913

7,370

8,496

8,519

4,948

542

11,274

7,891

-

8,306

-

12,205

0

0

3,752

-

0

0

0

-

-

-

0

Accounts payable, accrued and other current liabilities

35,503

-2,418

610

9,053

10,027

37,775

21,953

5,294

-16,511

-11,288

6,526

18,080

28,624

15,694

11,516

4,830

3,324

-1,198

12,715

11,745

-

17,043

-

17,548

0

0

4,963

-

0

0

0

-

-

-

0

Accrued content acquisition costs

24,112

37,531

16,281

4,016

-6,480

-35,320

-21,582

-3,668

-56,812

42,216

30,992

23,736

91,615

9,160

5,919

7,608

10,540

15,422

12,959

13,027

-

11,980

-

10,044

0

0

19,261

-

0

0

0

-

-

-

0

Accrued compensation

2,517

3,682

1,181

-10,679

-7,652

-3,324

-440

15,364

13,415

6,978

14,365

7,378

5,490

8,885

10,081

13,736

11,431

6,934

-13,969

-3,393

-

-5,098

-

2,623

0

0

9,598

-

0

0

0

-

-

-

0

Other long-term liabilities

-11,761

-12,210

-3,549

-3,007

254

1,559

481

1,384

5,103

7,602

8,190

6,005

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred revenue

-

0

5,326

-

-

3,724

4,776

8,420

9,289

1,073

258

4,946

3,858

4,334

-1,383

-28,238

-24,730

-19,356

-3,433

13,384

-

16,538

-

18,088

0

0

10,034

-

0

0

0

-

-

-

0

Reimbursement of cost of leasehold improvements

-919

-919

-382

-5,261

-5,236

-5,236

-5,389

-4,397

-4,407

-4,672

-4,519

-1,024

-2,022

-1,757

-4,918

-4,169

0

0

0

-

-

-

-

-

-

-

-

1,243

0

0

0

-

-

-

-

Net cash used in operating activities

-51,183

-105,757

-157,376

-210,709

-221,245

-260,023

-204,521

-181,691

-250,092

-117,719

-82,167

-42,082

53,996

47,340

50,132

21,029

4,697

5,265

7,769

-2,986

-

-1,399

-

-8,067

0

-595

-

1,702

-6,736

-5,747

-7,997

5,358

0

0

0

Investing activities
Purchases of property and equipment

10,085

12,105

17,086

15,656

26,230

33,746

47,378

59,769

48,576

43,498

33,544

23,512

23,322

23,619

17,917

25,465

29,268

26,593

31,468

21,180

-

17,485

-

15,749

0

0

7,580

-

0

0

0

-

-

-

0

Internal-use software costs

21,444

19,841

17,881

20,157

21,819

26,794

30,798

30,210

24,904

19,503

14,147

8,562

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments related to acquisition, net of cash acquired

-

-

-

-

-

-

-

676

247,214

270,042

270,242

269,566

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from maturities of short-term investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

0

-

0

-

-

-

0

0

0

-

-

-

-

Purchases of investments

244,744

164,586

89,341

0

0

1,322

7,420

12,413

14,672

40,530

89,183

140,980

205,973

258,098

281,880

340,679

473,342

395,237

326,773

224,549

-

34,069

-

47,900

0

55,283

-

59,559

0

0

0

-

-

-

-

Proceeds from maturities of investments

152,168

55,558

32,112

42,082

49,924

52,923

50,544

47,656

84,015

116,886

158,841

228,998

251,650

273,806

302,997

258,518

184,587

129,351

57,390

42,210

-

0

-

0

-

0

-

-

-

-

-

-

-

-

-

Proceeds from cancellation of convertible promissory note receivable

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sales of investments

-

-

-

-

-

-

-

-

-

-

-

111,356

41,317

3,662

640

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) investing activities

-155,522

-49,479

66,223

129,946

124,787

-5,932

-31,795

-52,155

-178,055

-148,743

-137,559

-102,266

30,073

-12,392

-2,326

-112,200

-318,023

-297,279

-306,532

-211,919

-

-13,255

-

-9,700

0

166

-

8,235

4,763

-43,599

-47,248

-58,550

0

0

0

Financing activities
Proceeds from employee stock purchase plan

7,070

7,054

8,165

10,926

11,318

12,010

10,812

9,701

8,858

8,114

7,620

7,552

7,139

7,231

7,194

6,438

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayments of debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Proceeds from exercise of stock options

0

0

0

-

0

0

0

-

0

0

4,618

-

5,444

7,194

8,237

16,894

17,801

23,749

25,420

17,273

-

16,138

-

9,223

0

0

6,669

-

0

0

0

-

-

-

0

Tax withholdings related to net share settlements of restricted stock units

1,651

477

287

0

243

608

2,075

3,369

3,371

4,394

2,946

2,540

2,328

2,926

2,907

2,019

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) financing activities

2,027

208,738

375,005

380,193

380,073

265,999

104,030

99,757

392,871

300,822

302,223

303,135

10,603

11,847

12,872

21,661

19,548

403,955

401,578

394,997

-

394,039

-

8,396

0

7,982

-

5,877

5,823

3,578

56,217

54,270

0

0

0

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

-361

-87

5

223

-5

-87

-287

-634

-10

-96

-57

-77

-575

-540

-460

-288

0

0

0

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

Net increase (decrease) in cash, cash equivalents and restricted cash

-205,039

53,415

283,857

299,653

283,610

-43

-132,573

-134,723

-35,286

34,264

82,440

158,710

94,097

46,255

60,218

-69,798

-293,984

111,949

102,774

180,030

-

379,357

-

-9,426

0

7,546

-

15,813

3,849

-45,768

972

1,078

0

0

0

Supplemental disclosures of cash flow information
Purchases of property and equipment recorded in accounts payable and accrued liabilities

1,327

986

-653

2,106

-4,898

-2,294

-1,129

1,129

12,883

7,561

12,163

5,890

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid during the period for interest

6,849

7,618

8,334

8,981

9,677

8,821

8,011

7,222

3,344

3,360

-2,325

351

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Stock dividend payable to preferred stockholders

29,682

25,090

18,212

10,849

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Employee stock purchase plan (ESPP) purchases

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-