Lexicon pharmaceuticals, inc./de (LXRX)
Balance Sheet / Yearly
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'11Dec'10
Current assets:
Cash and cash equivalents

55,592

36,112

170,203

11,106

45,778

80,386

48,902

15,044

20,421

61,661

83,293

30,706

2,455

46,600

38,772

38,410

24,681

202,989

61,674

9,744

41,960

137,266

26,775

27,725

46,517

37,499

19,581

23,254

34,248

30,423

20,759

33,779

29,010

186,309

30,521

20,328

47,208

Short-term investments

193,545

235,547

126,101

94,871

87,367

79,666

138,395

194,645

241,851

249,127

113,524

200,481

257,288

299,904

356,784

390,955

452,465

318,363

194,748

272,739

273,137

202,073

31,094

51,319

51,850

91,629

131,629

152,124

162,915

192,785

186,089

197,734

224,646

95,383

113,634

144,486

163,903

Accounts receivable, net

30,135

56,532

56,841

5,580

4,390

5,924

2,913

4,406

4,482

4,825

10,597

5,014

8,733

7,492

738

1,018

741

911

72

316

170

1,035

165

281

471

790

895

1,014

863

1,378

233

182

186

350

489

505

744

Inventory

4,147

4,243

4,476

4,277

4,606

4,680

4,755

2,142

2,112

1,948

2,149

811

236

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Assets held for sale

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

21,500

23,849

23,849

23,849

23,849

-

-

0

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses and other current assets

8,195

5,320

5,973

6,625

4,686

2,668

3,395

3,954

4,284

4,434

4,458

10,174

10,376

3,878

2,443

9,071

14,271

10,137

10,953

7,151

3,194

4,764

5,937

7,342

6,570

4,636

7,257

6,684

8,438

6,349

9,004

6,582

5,143

3,748

4,337

3,874

2,883

Total current assets

291,614

337,754

363,594

122,459

146,827

173,324

198,360

220,191

273,150

321,995

214,021

247,186

279,088

357,874

398,737

439,454

492,158

532,400

288,947

313,799

342,310

368,987

87,820

86,667

105,408

134,554

159,362

183,076

206,464

230,935

216,085

238,277

258,985

285,790

148,981

169,193

214,738

Property and equipment, net of accumulated depreciation and amortization of $61,302 and $61,741, respectively

13,582

14,047

14,540

15,007

15,475

15,865

16,299

16,772

17,244

17,687

18,167

18,588

18,995

19,390

19,854

20,350

20,753

21,227

795

684

732

1,080

1,494

39,177

39,959

41,362

41,838

42,152

42,623

42,634

43,515

44,526

45,526

46,417

47,344

48,370

53,427

Goodwill

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

44,543

Intangible assets, net of accumulated amortization of $5,444 and $5,003, respectively

19,275

19,716

20,157

49,236

49,678

50,119

50,561

51,002

51,444

51,885

52,327

52,768

53,210

53,357

53,357

53,357

53,357

53,357

53,357

53,357

53,357

53,357

53,557

53,557

53,557

53,557

53,557

53,557

53,557

53,557

53,557

53,557

53,557

53,557

53,557

53,557

53,557

Other assets

1,553

1,655

1,754

1,898

1,993

285

429

429

432

429

429

428

428

461

454

430

530

433

3,498

3,581

3,740

3,409

108

120

133

144

158

65

88

109

135

157

181

205

281

253

619

Total assets

370,567

417,715

444,588

233,143

258,516

284,136

310,192

332,937

386,813

436,539

329,487

363,513

396,264

475,625

516,945

558,134

611,341

651,960

391,140

415,964

444,682

471,376

187,522

224,064

243,600

274,160

299,458

323,393

347,275

371,778

357,835

381,060

402,792

430,512

294,706

315,916

366,884

Current liabilities:
Accounts payable

18,236

12,178

20,907

10,028

13,874

12,052

51,480

50,451

66,553

57,652

52,628

43,857

41,945

52,877

41,545

28,225

25,544

19,725

16,355

11,291

12,142

13,064

9,741

8,350

7,072

9,715

9,709

6,281

5,442

7,661

4,306

4,579

5,324

6,042

5,526

3,671

3,159

Accrued liabilities

51,349

42,151

11,511

9,083

10,800

21,245

13,794

12,865

12,863

12,282

12,729

10,959

10,191

32,114

32,906

23,950

23,615

24,757

14,913

10,807

11,769

10,120

13,134

10,886

7,952

7,674

11,529

11,321

9,704

8,922

12,782

15,045

13,710

13,786

7,703

8,037

6,264

Current portion of deferred revenue

-

-

1,117

2,243

2,432

2,339

2,117

5,124

7,437

40,099

48,738

63,201

69,172

63,372

78,870

61,528

70,764

76,499

1,743

2,218

2,311

1,618

785

877

903

195

685

623

628

128

421

421

421

119

164

138

214

Current portion of long-term debt, net of deferred issuance costs

10,734

11,012

11,289

1,115

1,115

1,115

1,115

12,896

13,517

14,094

14,633

15,156

15,753

16,280

16,792

17,289

2,020

1,976

18,788

19,255

19,711

20,167

20,609

1,783

1,746

1,710

1,675

22,678

1,607

1,574

1,542

1,510

1,478

1,443

1,413

1,380

1,138

Total current liabilities

80,319

65,341

44,824

22,469

28,221

36,751

68,506

81,336

100,370

124,127

128,728

133,173

137,061

164,643

170,113

130,992

121,943

122,957

51,799

43,571

45,933

44,969

44,269

21,896

17,673

19,294

23,598

40,903

17,381

18,285

19,051

21,555

20,933

21,390

14,806

13,226

10,775

Deferred revenue, net of current portion

-

-

0

24,268

24,623

23,651

20,991

18,195

22,077

22,428

26,545

28,308

28,750

48,934

55,438

92,188

102,699

109,151

11,708

11,708

11,708

12,679

12,679

12,679

12,679

13,405

13,405

13,405

13,405

13,910

13,910

13,910

13,910

14,212

14,212

14,212

14,212

Long-term debt, net of deferred issuance costs

234,488

234,171

233,837

243,953

243,912

243,887

243,830

232,198

231,879

231,576

85,512

85,383

85,268

85,167

85,038

84,909

100,550

100,960

87,500

87,500

87,500

87,500

0

19,255

19,711

20,167

20,609

0

21,457

21,877

22,284

22,678

23,063

23,451

23,826

24,188

27,345

Deferred tax liabilities

-

-

0

6,014

6,014

6,014

6,014

6,014

6,014

6,014

10,023

10,023

10,023

18,675

18,675

18,675

18,675

18,675

18,675

18,675

18,675

18,675

18,745

18,745

18,745

18,745

18,745

18,745

18,745

18,745

18,745

18,745

18,745

18,745

18,745

18,745

18,745

Other long-term liabilities

983

1,102

1,215

1,325

1,433

238

252

265

279

292

303

313

559

805

2,500

14,037

14,593

14,367

23,520

23,036

23,259

23,535

34,005

34,821

34,017

32,386

37,391

35,256

34,079

32,283

31,086

59,276

57,170

55,146

53,636

51,357

48,783

Total liabilities

315,790

300,614

279,876

298,029

304,203

310,541

339,593

338,008

360,619

384,437

251,111

257,200

261,661

318,224

331,764

340,801

358,460

366,110

193,202

184,490

187,075

187,358

109,698

107,396

102,825

103,997

113,748

108,309

105,067

105,100

105,076

136,164

133,821

132,944

125,225

121,728

119,860

Commitments and contingencies

-

-

-

-

-

-

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

Equity:
Preferred stock, $.01 par value; 5,000 shares authorized; no shares issued and outstanding

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

0

0

0

Common stock, $.001 par value; 225,000 shares authorized; 107,711 and 106,679 shares issued, respectively

108

106

106

106

106

106

106

106

106

106

106

105

105

105

104

104

104

104

104

104

727

104

516

516

516

514

514

514

514

512

495

481

481

480

338

338

338

Additional paid-in capital

1,466,604

1,462,172

1,458,693

1,455,131

1,451,365

1,447,954

1,444,925

1,441,890

1,438,625

1,435,526

1,433,263

1,430,630

1,423,911

1,411,222

1,406,311

1,402,190

1,399,665

1,397,646

1,396,207

1,394,421

1,391,932

1,390,619

1,181,015

1,179,358

1,177,432

1,175,108

1,173,205

1,170,928

1,168,961

1,166,605

1,127,832

1,090,485

1,088,666

1,087,033

925,230

923,797

920,324

Accumulated deficit

-1,408,055

-1,341,444

-1,290,306

-1,516,392

-1,493,374

-1,471,577

-1,471,485

-1,443,973

-1,409,267

-1,381,404

-1,353,026

-1,322,304

-1,287,245

-1,250,363

-1,217,944

-1,181,929

-1,143,817

-1,108,934

-1,195,684

-1,160,402

-1,132,328

-1,104,252

-1,101,319

-1,060,821

-1,034,793

-1,003,958

-986,544

-954,886

-925,806

-899,832

-874,959

-845,420

-819,489

-789,621

-755,776

-729,673

-673,406

Accumulated other comprehensive loss

860

84

36

86

33

-12

-71

-218

-394

-222

-63

-214

-264

-195

78

336

297

-219

58

98

23

-63

2

5

10

2

38

31

42

23

21

-20

-57

21

34

71

5

Treasury stock, at cost, 741 and 407 shares, respectively

4,740

3,817

3,817

3,817

3,817

2,876

2,876

2,876

2,876

1,904

1,904

1,904

1,904

3,368

3,368

3,368

3,368

2,747

2,747

2,747

2,747

2,390

2,390

2,390

2,390

1,503

1,503

1,503

1,503

630

630

630

630

345

345

345

237

Total stockholder's equity (deficit)

54,777

117,101

164,712

-64,886

-45,687

-26,405

-29,401

-5,071

26,194

52,102

78,376

106,313

134,603

157,401

185,181

217,333

252,881

285,850

197,938

231,474

257,607

284,018

77,824

116,668

140,775

170,163

185,710

215,084

242,208

266,678

252,759

244,896

268,971

297,568

169,481

194,188

247,024

Total liabilities and equity

370,567

417,715

444,588

233,143

258,516

284,136

310,192

332,937

386,813

436,539

329,487

363,513

396,264

475,625

516,945

558,134

611,341

651,960

391,140

415,964

444,682

471,376

187,522

224,064

243,600

274,160

299,458

323,393

347,275

371,778

357,835

381,060

402,792

430,512

294,706

315,916

366,884