Lexicon pharmaceuticals, inc./de (LXRX)
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
Cash flows from operating activities:
Net loss

85,319

130,133

164,488

-88,994

-100,525

-120,548

-126,086

-129,412

-129,922

-122,993

-123,107

-128,400

-131,453

-131,445

-22,260

-21,527

-11,489

-4,682

-94,365

-99,581

-97,535

-100,294

-114,775

-105,935

-108,987

-104,126

-111,585

-109,466

-106,317

-110,211

-119,183

-115,747

-116,454

-116,215

0

0

0

Adjustments to reconcile net loss to net cash used in operating activities:
Depreciation and amortization

3,659

3,654

3,631

3,641

3,659

3,683

3,695

3,700

3,690

3,399

2,983

2,571

2,169

2,056

1,614

1,163

893

727

865

1,331

1,639

1,928

2,393

2,443

2,714

2,863

3,110

3,589

3,858

4,190

4,409

4,535

4,705

4,887

0

0

0

Impairment of assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

13,544

0

0

0

-

-

0

0

-

-

-

-

704

0

0

0

Increase in fair value of Symphony Icon, Inc. purchase liability

-

-

-

-

-

-

-

-

-

2,101

2,101

-45

433

-703

79

5,629

5,139

5,927

6,055

1,579

2,039

1,428

-4,771

-2,361

-2,332

-2,210

2,879

7,385

9,070

9,887

11,655

8,147

7,789

6,766

0

0

0

Stock-based compensation

15,239

14,218

13,586

12,901

12,033

11,696

11,107

10,810

10,315

9,472

8,944

8,294

7,848

7,452

7,152

6,894

6,725

6,843

6,910

6,732

6,784

7,081

7,277

7,533

7,562

7,421

7,318

7,160

6,886

6,495

6,258

6,098

5,953

5,707

0

0

0

Amortization of debt issuance costs

1,481

1,465

1,466

1,452

1,375

1,336

1,144

937

796

599

550

531

512

527

529

529

583

520

443

316

162

100

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Deferred tax benefit

-

-

-

-

-

-

-

-

-

-12,700

-8,652

-8,652

-8,652

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loss on disposal of property and equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

-

0

0

0

-

-

0

0

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
(Increase) decrease in accounts receivable

25,745

50,608

53,928

1,174

-92

1,099

-5,183

1,893

-1,750

-166

7,358

1,495

5,491

4,080

666

702

571

-124

-795

-667

-1,003

-457

-730

-733

-392

-588

662

832

677

1,028

-256

-323

-645

-394

0

0

0

(Increase) decrease in inventory

-459

-437

-279

2,135

2,494

2,732

2,606

1,331

1,876

1,948

2,149

811

236

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

(Increase) decrease in prepaid expenses and other current assets

3,509

2,652

2,578

2,672

402

-1,766

-1,062

-6,220

-6,091

557

2,015

-1,029

4,373

-6,259

-6,878

-1,920

-11,077

-5,373

-5,016

191

3,376

-128

1,320

-658

1,868

1,713

1,747

-102

-3,295

-2,601

-4,667

-2,708

-1,695

-865

0

0

0

Decrease in other assets

-440

-429

-474

-330

-238

-144

-1

0

3

-33

-25

-1

-1

32

78

-3

-23

-416

-495

-439

-404

0

-45

-27

-19

-9

88

92

93

96

146

96

123

414

0

0

0

Decrease in accounts payable and other liabilities

43,405

20,097

-15,652

-26,911

-37,466

-19,913

-5,043

3,550

22,210

-11,875

-16,859

-2,867

-7,283

13,584

15,426

-15,347

-11,341

-6,203

2,397

4,752

-1,840

-1,266

-3,022

-3,560

-2,148

-3,119

-7,576

-1,573

1,049

995

-4,654

-7,688

-5,665

-10,365

0

0

0

Decrease in deferred revenue

-25,999

-25,990

-23,340

1,733

-3,962

-22,940

-39,639

-55,544

-55,718

-51,133

-54,943

-121,993

-95,833

-69,262

-223,541

-139,790

-159,444

-171,353

13

-370

-437

-697

626

472

451

438

241

303

298

293

45

19

66

95

0

0

0

Net cash provided by (used in) operating activities

117,373

113,807

111,050

-101,829

-127,452

-148,607

-155,190

-166,971

-146,673

-185,394

-200,474

-201,731

-217,384

-175,628

139,087

148,821

164,521

184,776

-85,606

-81,311

-68,788

-75,622

-92,905

-95,650

-97,127

-91,079

-89,770

-90,904

-91,729

-94,460

-96,519

-91,668

-93,400

-87,938

0

0

0

Cash flows from investing activities:
Purchases of property and equipment

0

70

107

110

125

95

62

120

176

228

372

327

269

231

329

497

947

910

698

521

69

80

261

522

910

1,721

1,619

1,401

1,097

492

588

720

933

1,206

0

0

0

Proceeds from disposal of property and equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

335

697

987

1,365

2,170

1,830

1,545

882

130

186

186

142

85

10

110

2,582

2,625

0

0

0

Purchases of investments

268,351

322,385

212,499

177,055

160,351

119,987

293,111

257,522

253,860

267,873

148,261

266,225

277,592

425,673

580,541

475,378

464,454

326,446

283,856

271,807

272,280

221,953

51,187

51,187

51,187

111,490

162,428

162,428

162,428

233,250

177,243

195,742

225,973

108,092

0

0

0

Maturities of investments

163,000

166,600

224,900

277,135

315,263

289,658

268,232

263,353

269,166

318,623

391,380

456,149

472,208

444,156

418,525

357,400

285,400

210,000

120,258

50,480

51,006

111,444

151,686

151,966

162,220

212,625

216,905

208,089

224,258

135,850

104,775

142,403

170,022

176,628

0

0

0

Net cash (used in) provided by investing activities

-105,351

-155,855

12,294

99,970

154,787

169,576

-24,941

5,711

15,130

50,522

242,747

189,597

194,347

18,252

-162,345

-118,474

-179,670

-117,021

-163,599

-220,861

-219,978

-108,419

102,068

101,802

111,005

99,544

53,044

44,446

60,875

-97,807

-73,046

-53,949

-54,302

69,955

0

0

0

Cash flows from financing activities:
Proceeds from issuance of common stock, net of fees

-

-

-

-

-

732

3,056

2,952

6,901

7,987

6,162

8,299

4,551

3,624

2,943

866

298

114

202,059

202,108

202,194

202,270

535

899

911

1,084

37,928

38,180

38,306

38,109

161,647

160,869

160,673

160,781

0

0

0

Repurchase of common stock

923

941

941

941

941

972

972

972

972

1,679

1,679

1,679

1,679

621

621

621

621

357

357

357

357

887

887

887

887

873

873

873

873

285

285

285

285

108

0

0

0

Repayment of debt borrowings, net of fees

1,285

1,285

1,284

14,007

14,273

14,533

14,778

2,287

2,325

2,280

2,235

2,190

2,061

2,016

1,975

1,935

1,894

1,859

1,821

1,783

1,746

1,710

1,675

1,640

1,607

1,574

1,542

1,510

1,477

1,443

1,413

1,380

3,658

3,589

0

0

0

Other financing activities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

70

88

88

-17

0

0

0

0

-

-

-

-

0

-146

-136

-136

0

0

0

0

Net cash used in financing activities

-2,208

-2,226

-2,043

-2,079

-1,978

-2,244

145,740

145,598

149,509

149,933

2,248

4,430

811

987

356

-1,681

-2,130

-2,032

284,104

284,191

284,209

283,808

-1,969

-1,681

-1,609

-1,389

35,548

35,933

36,092

36,381

159,803

159,068

156,594

157,084

0

0

0

Net increase (decrease) in cash and cash equivalents

9,814

-44,274

121,301

-3,938

25,357

18,725

-34,391

-15,662

17,966

15,061

44,521

-7,704

-22,226

-156,389

-22,902

28,666

-17,279

65,723

34,899

-17,981

-4,557

99,767

7,194

4,471

12,269

7,076

-1,178

-10,525

5,238

-155,886

-9,762

13,451

8,892

139,101

0

0

0

Supplemental disclosure of cash flow information:
Cash paid for interest

19,171

19,211

19,238

19,349

19,389

16,465

13,068

9,640

6,312

5,870

5,916

5,960

6,004

6,050

6,090

6,132

6,236

6,270

3,992

4,049

1,726

1,761

1,815

1,831

1,864

1,897

1,930

1,961

1,992

2,028

2,057

2,091

2,379

2,447

0

0

0

Supplemental disclosure of noncash investing and financing activities:
Common stock issued in satisfaction of Symphony Icon base payment obligation

-

-

-

-

-

-

-

-

-

10,499

10,499

10,499

10,499

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Unrealized gain on investments

-

-

-

-

-

-

0

0

-130

-

-141

-550

-561

24

20

238

274

-156

56

93

13

-65

-36

-26

-32

-21

17

51

99

2

-13

-91

-97

16

0

0

0