Diplomat pharmacy, inc. (DPLO)
Balance Sheet / Quarterly
Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15Dec'14Sep'14Dec'13
ASSETS
Current assets:
Cash and equivalents

8,400

5,771

2,739

9,485

8,214

7,360

6,040

84,251

27,152

7,804

16,581

7,953

17,092

7,906

14,684

27,600

15,665

17,305

162,018

17,957

15,787

9,109

Receivables, net

338,321

329,595

329,881

326,602

358,158

349,845

329,749

332,091

277,840

279,604

255,461

275,568

289,162

317,200

268,419

254,682

258,158

257,913

167,463

155,273

135,396

110,294

Inventories

181,401

179,083

174,507

210,573

169,863

170,175

194,755

206,603

194,958

178,131

200,286

215,351

197,025

182,151

181,014

165,950

153,293

159,462

109,766

110,683

67,230

56,454

Deferred income taxes

-

-

-

-

-

-

-

-

-

-

-

-

17,992

13,630

18,007

5,311

2,503

2,168

1,813

1,813

603

-

Prepaid expenses and other current assets

14,035

27,007

10,544

9,596

13,491

18,012

13,410

11,125

9,321

10,477

7,378

6,235

7,528

8,462

10,153

7,427

7,551

15,886

3,732

5,360

2,897

1,924

Total current assets

542,177

541,456

517,671

556,256

549,726

545,392

543,954

634,070

509,271

476,016

479,706

505,107

528,799

529,349

492,277

460,970

437,170

452,734

444,792

291,086

221,913

177,781

Property and equipment

54,462

54,246

-

55,929

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accumulated depreciation

26,258

24,682

-

21,404

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Property and equipment, net

28,204

29,564

31,244

34,525

40,924

38,838

39,719

38,990

20,575

20,963

19,923

20,372

20,059

19,546

17,479

16,538

14,988

14,187

13,589

13,150

12,967

12,378

Capitalized software for internal use, net

28,899

28,354

29,844

30,506

29,842

33,865

31,719

36,520

38,760

42,953

46,838

50,247

51,659

53,517

39,770

37,250

35,904

35,417

15,562

13,236

10,217

6,564

Operating lease right-of-use assets

26,863

26,329

27,325

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Goodwill

371,569

486,563

609,592

609,592

834,580

836,427

835,633

832,624

383,015

358,178

336,775

316,616

315,373

315,380

256,318

256,318

253,426

250,544

23,148

23,148

23,172

1,537

Definite-lived intangible assets, net

155,798

195,273

227,005

240,810

340,651

357,841

375,001

392,011

194,721

195,100

197,638

199,862

208,722

222,121

216,810

224,644

233,677

242,882

43,252

44,973

46,762

7,100

Assets held for sale

3,642

3,450

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred income taxes

-

-

-

-

-

-

-

-

6,647

5,031

4,263

6,010

-

-

-

-

-

-

-

-

-

-

Investment in non-consolidated entity

-

-

-

-

-

-

-

-

-

-

-

-

4,959

4,959

4,959

4,959

3,500

3,500

3,500

3,500

4,990

5,577

Deferred debt issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,312

5,681

-

921

-

-

Other noncurrent assets

5,451

4,121

4,387

4,670

4,938

5,507

5,883

6,208

1,060

1,081

1,045

1,040

783

850

874

900

179

234

962

72

2,641

840

Total assets

1,162,603

1,315,110

1,447,068

1,476,359

1,800,661

1,817,870

1,831,909

1,940,423

1,154,049

1,099,322

1,086,188

1,099,254

1,130,354

1,145,722

1,028,487

1,001,579

984,156

1,005,179

544,805

390,086

322,662

211,777

LIABILITIES AND SHAREHOLDERS' EQUITY
Current liabilities:
Accounts payable

368,410

326,544

283,893

308,084

315,268

383,969

393,185

384,719

327,504

307,718

301,392

320,684

331,979

379,468

291,706

296,587

271,988

265,565

198,375

202,495

172,183

142,353

Rebates payable to PBM customers

23,459

20,964

21,573

23,264

29,954

25,257

32,032

28,744

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Borrowings on revolving line of credit

105,000

125,000

156,500

176,300

178,250

135,100

140,000

188,250

21,592

2,521

5,718

39,255

45,519

17,057

-

-

21,756

70,994

-

-

76,562

62,622

Current portion of long-term debt

443,324

11,500

-

11,500

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Current portion of long-term debt

-

-

11,500

-

11,500

11,500

11,500

11,500

10,875

10,875

9,925

7,500

6,750

6,000

6,000

6,000

6,000

6,000

-

-

3,960

6,693

Current portion of operating lease liabilities

4,566

4,255

4,239

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accrued expenses:
Compensation and benefits

13,481

11,184

12,228

13,348

16,771

13,641

14,460

9,584

9,685

6,511

7,905

5,674

7,115

5,028

7,905

5,563

6,126

5,682

3,332

2,257

-

2,703

Contingent consideration

5,523

6,838

5,225

5,075

5,200

5,300

7,100

8,100

2,000

-

-

-

-

5,750

42,594

52,665

44,281

47,681

6,324

6,282

-

650

Accrued compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,424

-

Income taxes payable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

272

-

Other

27,779

39,012

22,361

21,014

21,542

22,005

16,901

20,560

9,357

12,792

14,279

12,233

11,371

11,579

14,337

11,087

8,372

6,142

4,659

4,394

6,447

1,646

Total current liabilities

991,542

545,297

517,519

558,585

578,485

596,772

615,178

651,457

381,013

340,417

339,219

385,346

402,734

424,882

362,542

371,902

358,523

402,064

212,690

215,428

261,848

216,667

Long-term debt, less current portion

-

434,005

436,187

438,369

440,552

442,734

444,916

521,098

116,543

119,006

121,514

100,184

102,179

104,147

105,449

106,706

112,500

114,000

-

-

15,888

18,849

Noncurrent operating lease liabilities

23,538

23,017

23,950

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred income taxes

1,459

3,553

-

2,781

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred income taxes

-

-

3,233

-

12,423

13,515

13,820

14,367

-

-

-

-

12,027

10,018

10,851

7,425

11,128

11,081

2,677

518

3,889

-

Contingent consideration

4,948

-

1,880

1,820

4,050

5,870

4,000

4,000

9,300

4,365

3,735

-

-

-

-

-

-

5,179

4,695

5,409

-

650

Derivative liability

10,084

9,777

6,419

4,292

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred gain

-

-

-

5,175

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other

-

-

-

253

295

1,507

-

-

-

-

-

-

-

-

-

-

-

-

-

4

2,927

23

Mandatory redeemable common shares, $1.00 par value; 3,187,500 shares outstanding at December 31, 2013

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

53,370

Total liabilities

1,031,571

1,015,649

989,188

1,011,275

1,035,805

1,060,398

1,077,914

1,190,922

506,856

463,788

464,468

485,530

516,940

539,047

478,842

486,033

482,151

532,324

220,062

221,359

316,059

289,559

Commitments and contingencies (Note 16)

-

-

-

-

0

0

0

-

0

0

0

0

0

0

0

0

0

0

-

0

-

-

Shareholders' equity:
Preferred stock (10,000,000 shares authorized; none issued and outstanding)

-

-

-

-

0

0

0

-

0

0

0

0

0

0

0

0

0

0

-

0

-

-

Common stock (no par value; 590,000,000 shares authorized; 75,973,963 and 74,474,677 shares issued and outstanding at September 30, 2019 and December 31, 2018, respectively)

641,557

636,331

634,214

629,411

629,283

625,354

621,853

619,235

525,172

515,820

507,381

503,828

502,695

499,472

452,234

451,620

448,736

445,280

299,884

148,901

-

-

Additional paid-in capital

55,529

51,597

49,313

50,544

48,172

45,804

40,902

38,450

36,718

35,372

33,486

33,268

32,807

32,119

30,620

29,221

21,868

11,857

12,254

9,893

-108,504

4,186

Accumulated deficit

-555,970

-378,690

-219,228

-210,579

87,445

87,276

91,240

91,816

85,280

84,264

80,673

76,306

77,404

71,996

63,462

31,130

27,564

11,603

8,212

5,354

8,484

-81,972

Accumulated other comprehensive loss

-10,084

-9,777

-6,419

-4,292

-44

-962

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Total shareholders' equity

131,032

299,461

457,880

465,084

764,856

757,472

753,995

749,501

647,170

635,456

621,540

613,402

612,906

603,587

546,316

511,971

498,168

468,740

320,350

164,148

-100,016

-77,782

Noncontrolling interests

-

-

-

-

-

-

-

-

23

78

180

322

508

3,088

3,329

3,575

3,837

4,115

4,393

4,579

4,804

-

Total shareholders' equity

-

-

-

-

-

-

-

-

647,193

635,534

621,720

613,724

613,414

606,675

549,645

515,546

502,005

472,855

324,743

168,727

-95,212

-77,782

Total liabilities and shareholders' equity

1,162,603

1,315,110

1,447,068

1,476,359

1,800,661

1,817,870

1,831,909

1,940,423

1,154,049

1,099,322

1,086,188

1,099,254

1,130,354

1,145,722

1,028,487

1,001,579

984,156

1,005,179

544,805

390,086

322,662

211,777