Medidata solutions, inc. (MDSO)
Balance Sheet / TTM
Jun'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
ASSETS
Current assets:
Cash and cash equivalents

139,104

109,052

105,440

83,496

120,298

226,588

237,325

128,435

110,708

90,422

93,519

65,165

64,346

87,669

49,562

63,179

43,366

71,472

39,517

26,654

35,192

25,406

22,328

191,645

38,560

37,291

32,683

37,404

58,723

58,387

45,214

26,049

21,783

16,025

Marketable securities

66,914

97,060

135,105

115,083

287,603

296,816

246,967

269,351

256,401

274,602

281,285

264,903

253,930

235,859

220,126

224,135

222,625

226,136

233,284

231,460

183,000

196,140

218,892

166,970

101,820

83,086

89,871

86,230

55,177

52,840

62,463

76,646

72,402

69,473

Accounts receivable, net of allowance for doubtful accounts

198,166

177,853

170,744

163,180

137,169

133,453

110,685

105,961

111,233

102,491

115,216

114,886

90,433

77,654

90,590

86,931

93,507

80,358

68,475

50,898

61,971

66,326

45,534

40,516

41,639

48,398

42,359

31,627

36,067

30,727

22,970

19,456

27,840

34,268

Prepaid commission expense

24,426

23,186

22,247

18,422

17,612

17,615

12,404

4,115

3,511

2,550

1,842

2,830

2,665

2,472

1,670

1,735

2,232

2,155

2,819

3,325

3,495

4,116

3,615

3,489

3,230

3,113

2,281

2,032

2,013

2,011

1,743

1,798

1,976

3,087

Prepaid expenses and other current assets

37,615

36,817

28,949

27,898

37,109

33,056

33,636

34,997

30,846

24,472

20,382

22,301

17,546

19,469

21,165

17,344

15,701

14,725

13,661

15,347

14,440

12,434

13,511

16,637

9,203

7,717

8,042

7,853

7,664

4,761

4,380

6,064

5,787

6,297

Deferred income taxes

-

-

-

-

-

-

-

0

0

0

6,536

104

102

94

88

97

4,158

97

96

660

669

2,310

665

3,706

3,558

6,731

7,465

5,401

7,563

10,612

10,896

3,901

3,887

3,731

Total current assets

466,225

443,968

462,485

408,079

599,791

707,528

641,017

542,859

512,699

494,537

518,780

470,189

429,022

423,217

383,201

393,421

381,589

394,943

357,852

328,344

298,767

306,732

304,545

422,963

198,010

186,336

182,701

170,547

167,207

159,338

147,666

133,914

133,675

132,881

Restricted cash

7,223

7,212

7,205

5,532

5,523

5,520

5,518

5,515

5,513

5,511

5,760

5,759

5,758

5,756

5,755

5,582

5,582

5,118

5,118

5,118

5,118

5,118

5,118

4,137

0

0

388

388

388

388

388

388

388

532

Operating lease assets

83,554

86,383

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Furniture, fixtures and equipment, net

114,210

111,035

98,983

96,753

93,088

92,905

88,091

81,619

71,162

63,284

58,461

54,296

54,683

51,919

51,043

43,929

42,491

39,664

38,579

39,763

41,237

40,482

41,229

23,759

14,017

10,542

10,474

9,233

9,183

9,370

9,825

8,955

9,300

10,993

Marketable securities- long-term

-

-

-

19,878

69,476

121,790

179,041

155,826

167,896

148,359

140,418

154,161

164,596

153,096

209,041

205,609

206,426

168,165

183,842

185,890

200,283

181,947

195,105

69,337

-

3,655

0

-

-

-

-

-

-

-

Goodwill

213,976

215,958

216,017

215,000

198,780

47,597

47,435

47,913

47,678

39,075

30,780

30,232

30,320

18,662

18,797

18,910

19,083

18,808

19,025

15,409

15,655

15,533

15,487

15,377

15,087

15,081

15,382

15,386

15,214

15,330

15,164

15,360

9,799

9,799

Intangible assets, net

26,406

28,276

29,546

31,429

54,938

16,374

17,587

18,801

20,014

13,036

5,090

5,489

5,887

1,067

1,172

1,282

1,394

1,595

1,816

484

650

774

904

1,025

1,099

1,230

1,708

2,159

2,552

3,040

3,425

3,889

2,245

2,945

Deferred income taxes- long-term

53,475

46,503

45,982

43,242

37,414

35,054

35,789

37,697

41,268

43,276

40,415

50,668

12,668

12,144

12,128

7,595

8,004

7,771

8,066

3,435

356

348

345

0

10,760

10,752

11,055

11,563

11,582

11,578

11,581

-

-

116

Other assets

58,697

57,367

52,994

47,875

43,775

49,213

46,755

23,484

22,625

20,350

18,181

14,972

9,080

8,065

3,043

7,442

7,756

7,995

7,919

8,880

9,161

9,804

10,620

9,777

2,347

2,823

2,923

2,929

2,569

1,673

1,786

3,028

3,220

679

Total assets

1,023,766

996,702

913,212

867,788

1,102,785

1,075,981

1,061,233

913,714

888,855

827,428

817,885

785,766

712,014

673,926

684,180

683,770

672,325

644,059

622,217

587,323

571,227

560,738

573,353

546,375

241,320

230,419

224,631

212,205

208,695

200,717

189,835

165,534

158,627

157,945

LIABILITIES AND STOCKHOLDERS' EQUITY
Current liabilities:
Accounts payable

10,672

8,137

7,482

6,661

6,527

8,164

5,009

2,408

12,257

6,699

6,202

1,185

1,406

1,918

6,283

2,270

2,766

6,254

3,738

3,713

5,283

5,812

7,524

3,930

1,781

1,319

2,998

3,640

2,324

1,994

3,861

2,483

1,214

2,797

Accrued payroll and other compensation

34,047

31,823

51,270

36,639

23,061

21,347

32,537

29,455

19,630

16,034

29,260

24,740

17,688

13,472

23,744

20,604

15,430

12,896

15,574

14,695

10,654

9,862

27,773

14,778

12,034

7,716

14,140

10,833

9,146

5,806

9,854

8,612

7,193

11,520

Accrued expenses and other

41,298

46,785

37,487

40,195

37,624

35,704

36,041

35,438

34,120

23,829

20,958

20,394

18,951

13,804

15,469

14,380

16,086

13,330

12,638

9,471

9,686

8,978

12,265

8,147

9,329

7,134

6,729

5,806

5,346

6,337

5,886

3,866

5,178

4,058

Operating lease liabilities

15,318

14,286

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred revenue

80,435

71,591

74,463

78,464

72,075

87,369

77,375

80,319

86,314

80,122

75,911

77,252

76,466

71,031

75,582

67,208

80,583

74,826

62,890

55,158

57,909

57,446

52,628

52,159

50,431

53,213

50,348

49,926

58,723

56,834

51,225

51,554

54,825

63,228

1.00% convertible senior notes, net

-

-

-

0

285,748

281,894

278,094

274,345

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Capital lease obligations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

56

56

55

-

57

63

78

114

173

300

712

Total current liabilities

181,770

172,622

170,702

161,959

425,035

434,478

429,056

421,965

152,321

126,684

132,331

123,571

114,511

100,225

121,078

104,462

114,865

107,306

94,840

83,037

83,532

82,098

100,190

79,070

73,631

69,437

74,215

70,262

75,602

71,049

70,940

66,688

68,710

82,315

Noncurrent liabilities:
1.00% convertible senior notes, net

-

-

-

-

-

-

-

0

270,647

266,999

263,401

259,851

256,350

252,895

249,487

249,745

246,748

243,795

240,886

238,020

235,228

232,446

229,705

227,006

-

-

0

-

-

-

-

-

-

-

Term loans, net

84,844

86,606

88,366

89,512

91,906

93,052

92,841

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred revenue, less current portion

2,291

2,424

3,843

2,901

3,993

4,702

5,256

2,926

2,159

1,607

1,703

3,312

2,820

2,748

2,993

5,089

933

1,346

1,374

1,126

440

3,255

1,430

2,451

3,452

3,722

4,323

11,488

11,385

13,168

12,037

14,066

17,654

20,540

Deferred tax liabilities

101

98

99

98

100

105

99

124

124

124

322

446

444

429

414

241

232

241

238

136

2,588

5,654

5,651

12,401

280

293

624

627

622

612

629

3,904

3,447

3,418

Operating lease liabilities, noncurrent

92,611

96,585

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Capital lease obligations, less current portion

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

58

72

86

-

114

128

142

136

2

9

68

Other long-term liabilities

1,690

1,641

18,754

19,332

20,395

21,441

21,371

21,011

20,812

20,642

18,138

19,475

23,238

23,276

26,052

22,082

21,069

19,983

20,180

15,867

15,205

12,085

10,564

9,994

3,008

2,739

3,378

1,004

1,911

2,013

1,976

2,254

435

478

Total noncurrent liabilities

181,537

187,354

111,062

111,843

116,394

119,300

119,567

24,061

293,742

289,372

283,564

283,084

282,852

279,348

278,946

277,157

268,982

265,365

262,678

255,149

253,461

253,440

247,350

251,910

6,812

6,840

8,325

13,233

14,046

15,935

14,778

20,226

21,545

24,504

Total liabilities

363,307

359,976

281,764

273,802

541,429

553,778

548,623

446,026

446,063

416,056

415,895

406,655

397,363

379,573

400,024

381,619

383,847

372,671

357,518

338,186

336,993

335,538

347,540

330,980

80,443

76,277

82,540

83,495

89,648

86,984

85,718

86,914

90,255

106,819

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

Stockholders' equity:
Preferred stock

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

679

674

661

659

643

637

628

626

626

622

614

612

610

606

594

577

576

573

563

560

558

556

550

273

272

269

528

262

260

253

250

249

248

241

Additional paid-in capital

629,451

596,725

574,667

550,446

527,336

501,718

486,147

467,645

454,856

431,479

418,497

403,765

395,817

376,747

364,973

350,075

339,408

317,042

301,465

289,962

273,664

259,179

248,336

228,855

180,106

168,102

160,373

153,639

148,171

143,187

137,556

130,682

127,620

122,015

Treasury stock

198,003

181,553

152,849

152,216

150,964

149,319

132,705

130,499

128,991

127,822

114,204

113,070

112,430

109,464

100,806

62,082

61,204

53,671

45,049

44,899

44,513

36,244

26,414

16,375

16,088

5,752

5,626

5,626

5,314

2,236

2,186

2,186

2,098

474

Accumulated other comprehensive loss

-4,544

-4,103

-4,869

-4,422

-4,490

-3,075

-3,377

-3,055

-3,826

-4,784

-5,276

-3,715

-2,930

-2,183

-3,404

-2,402

-1,604

-2,345

-1,912

-668

504

-16

-199

-316

-1,098

-1,056

-63

149

-303

-100

-362

-251

-42

-117

Retained earnings

232,876

224,983

213,838

199,519

188,831

172,242

161,917

132,971

120,127

111,877

102,359

91,519

33,584

28,647

22,799

15,983

11,302

9,789

9,632

4,182

4,021

1,725

3,540

2,958

-2,315

-7,421

-13,121

-19,714

-23,767

-27,371

-31,141

-49,874

-57,356

-70,539

Total stockholders' equity

660,459

636,726

631,448

593,986

561,356

522,203

512,610

467,688

442,792

411,372

401,990

379,111

314,651

294,353

284,156

302,151

288,478

271,388

264,699

249,137

234,234

225,200

225,813

215,395

160,877

154,142

142,091

128,710

119,047

113,733

104,117

78,620

68,372

51,126

Total liabilities and stockholders' equity

1,023,766

996,702

913,212

867,788

1,102,785

1,075,981

1,061,233

913,714

888,855

827,428

817,885

785,766

712,014

673,926

684,180

683,770

672,325

644,059

622,217

587,323

571,227

560,738

573,353

546,375

241,320

230,419

224,631

212,205

208,695

200,717

189,835

165,534

158,627

157,945