Pandora media, inc. (P)
CashFlow / Yearly
Dec'17Dec'16Dec'15Dec'14Dec'13Jan'13Dec'12Jan'12Jan'11Jan'10
Operating activities
Net loss

-518,395

-342,978

-169,661

-30,406

-27,017

-38,148

-24,462

-16,107

-1,764

-16,753

Adjustments to reconcile net loss to net cash used in operating activities
Goodwill impairment

131,997

0

0

-

-

-

-

-

-

-

Loss on dispositions

-9,378

0

0

-

-

-

-

-

-

-

Depreciation and amortization

62,948

60,757

24,458

15,431

10,112

7,076

6,406

4,455

1,578

1,143

Loss on retirement of fixed assets

-

-

-

-

-

-23

-23

-296

15

-219

Stock-based compensation

128,431

138,458

111,645

87,055

40,041

25,500

23,283

9,187

1,612

477

Amortization (accretion) of premium on investments

-81

-405

-1,911

2,833

237

360

329

246

-

-

Accretion of discount on convertible promissory note receivable

687

0

0

-

-

-

-

-

-

-

Remeasurement of preferred stock warrants

-

-

-

-

-

-

-

4,499

869

239

Other operating activities

447

881

196

1,366

220

-

-

-

-

-

Amortization of debt discount

20,153

18,315

1,084

0

0

264

242

190

4

2

Interest income

1,081

0

0

-

-

-

-

-

-

-

Provision for bad debt

12,211

3,522

1,938

-

-

-

-

-

-

-

Changes in restricted cash

1,257

0

0

-

-

-

-

-

-

-

Excess tax benefit from stock-based awards

-

-

-

348

0

0

0

-

-

-

Changes in operating assets and liabilities
Accounts receivable

36,760

35,710

55,904

55,478

60,613

36,672

43,487

24,526

22,979

14,873

Prepaid content acquisition costs

9,358

44,211

1,399

700

-

-

-

-

-

-

Prepaid expenses and other assets

16,566

12,321

17,519

8,519

7,891

3,752

2,189

-156

2,421

1,955

Accounts payable, accrued and other current liabilities

9,053

5,294

18,080

4,830

11,745

4,963

10,419

-865

5,482

1

Accrued content acquisition costs

4,016

-3,668

23,736

7,608

13,027

19,261

17,525

15,742

9,036

-2,235

Accrued compensation

-10,679

15,364

7,378

13,736

-3,393

9,598

2,085

8,147

2,375

709

Other long-term liabilities

-3,007

1,384

6,005

7,690

5,607

-

-

-

-

-

Deferred revenue

3,105

8,420

4,946

-28,238

13,384

10,034

10,285

3,322

9,763

5,552

Reimbursement of cost of leasehold improvements

-5,261

-4,397

-1,024

-4,169

-1,555

1,243

1,243

616

-

-

Net cash used in operating activities

-210,709

-181,691

-42,082

21,029

-2,986

-250

1,702

5,358

3,540

-27,474

Investing activities
Purchases of property and equipment

15,656

59,769

23,512

25,465

21,180

7,580

11,809

11,644

8,211

1,892

Internal-use software costs

20,157

30,210

8,562

4,574

-

-

-

-

-

-

Payments related to acquisition, net of cash acquired

0

676

269,566

0

400

0

0

-

-

-

Proceeds from maturities of short-term investments

-

-

-

-

-

-

-

19,984

-

-

Changes in restricted cash

642

250

0

0

-

-

-

-

-

-323

Purchases of patents

-

-

-

-

8,000

0

0

-

-

-

Purchases of investments

0

12,413

140,980

340,679

224,549

65,168

59,559

66,890

-

-

Proceeds from maturities of investments

42,082

47,656

228,998

258,518

42,210

87,933

79,603

-

-

-

Proceeds from sales of investments

0

3,507

111,356

0

0

-

-

-

-

-

Proceeds from sales of subsidiaries, net of cash

124,319

0

0

-

-

-

-

-

-

-

Proceeds from issuance of common stock to directors for cash

-

-

-

-

-

-

-

-

3,800

-

Proceeds from exercise of stock options

9,778

3,457

5,192

-

-

-

-

-

1,705

-

Net cash provided by (used in) investing activities

129,946

-52,155

-102,266

-112,200

-211,919

15,185

8,235

-58,550

-8,211

-1,569

Financing activities
Proceeds from exercise of preferred stock warrants

-

-

-

-

-

-

-

165

-

-

Proceeds from issuance of redeemable convertible preferred stock

480,000

0

0

-

-

-

-

-

22,206

34,124

Proceeds from initial public offering, net

-

-

-

-

-

-

-

90,632

-

-

Payment of dividends to preferred stockholders at initial public offering

-

-

-

-

-

-

-

31,005

-

-

Payments of issuance costs

30,511

32

8,909

0

450

0

0

-

-

-

Proceeds from issuance of convertible notes

0

0

345,000

0

0

-

-

-

-

-

Payments for purchase of capped call

0

0

43,160

0

0

-

-

-

-

-

Repayment of debt arrangements

90,000

0

0

-

-

-

-

-

-

-

Borrowings under debt arrangements

0

90,000

0

0

10,000

0

0

-

3,644

7,650

Proceeds from employee stock purchase plan

10,926

9,701

7,552

6,438

0

0

0

-

-

-

Repayments of debt

-

-

-

-

10,000

0

0

7,596

392

6,297

Proceeds from follow-on offering, net of issuance costs

-

-

-

-

378,654

0

0

-

-

-

Proceeds from exercise of stock options

-

-

-

16,894

17,273

6,669

5,877

2,074

548

122

Tax withholdings related to net share settlements of restricted stock units

0

3,369

2,540

2,019

480

0

0

-

-

-

Proceeds from buyers in investor offer

-

-

-

-

-

-

-

-

7,908

-

Payments to sellers in investor offer

-

-

-

-

-

-

-

-

7,908

-

Excess tax benefit from stock-based awards

-

-

-

348

0

0

0

-

44

-

Net cash provided by (used in) financing activities

380,193

99,757

303,135

21,661

394,997

6,669

5,877

54,270

31,555

35,599

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

223

-634

-77

-288

-62

-5

-1

-

-

-

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

299,653

-134,723

158,710

-69,798

180,030

21,599

15,813

1,078

26,884

6,556

Conversion of preferred stock warrants into common stock warrants

-

-

-

-

-

-

-

-2,151

-

-

Conversion of preferred stock into common stock

-

-

-

-

-

-

-

-124,341

-

-

Issuance of preferred stock warrants

-

-

-

-

-

-

-

-

-

12

Issuance of Series B redeemable convertible preferred stock upon exercise of warrant

-

-

-

-

-

-

-

-

142

-

Accruals of preferred stock dividends, net

-

-

-

-

-

-

-

25,218

-792

6,461

Deemed dividend on Series D and Series E redeemable convertible preferred stock

-

-

-

-

-

-

-

-

-

-1,443

Accretion of preferred stock issuance cost

-

-

-

-

-

-

-

110

300

218

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

2,106

1,129

5,890

751

7,910

1,952

726

-

-

-

Cash paid during the period for income taxes

209

297

389

164

26

0

0

125

-

-

Cash paid during the period for interest

8,981

7,222

351

314

18

289

283

887

371

1,572

Fair value of shares issued related to the acquisition of a business

0

0

146,855

0

0

-

-

-

-

-

Accretion of preferred stock issuance costs

29,317

0

0

-

-

-

-

-

-

-

Stock dividend payable to preferred stockholders

10,849

0

0

-

-

-

-

-

-

-

Fair value of convertible promissory note receivable received as partial consideration for sale of subsidiary

36,203

0

0

-

-

-

-

-

-

-