Diplomat pharmacy, inc. (DPLO)
CashFlow / Quarterly
Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15Dec'14Sep'14Jun'14Mar'14
Cash flows from operating activities:
Net loss

-177,280

-159,462

-14,301

-298,025

170

-3,964

-450

6,513

961

3,489

4,225

-1,284

2,828

8,293

15,183

3,304

15,683

3,113

2,672

-3,355

4,541

1,675

1,690

Adjustments to reconcile net loss to net cash provided by operating activities:
Depreciation and amortization

17,059

20,064

21,395

24,565

24,377

24,219

23,951

17,753

16,878

16,538

15,397

13,960

13,696

12,270

10,119

10,018

9,948

8,069

2,806

2,808

2,786

1,233

1,312

Share-based compensation expense

4,777

4,283

3,572

2,401

5,649

6,961

3,161

1,794

1,689

2,826

972

904

1,356

1,649

1,503

1,434

1,270

670

562

1,043

693

873

262

Net provision for doubtful accounts

3,523

3,120

2,447

2,798

1,943

1,597

2,322

1,901

2,122

2,617

2,784

3,156

2,368

1,764

2,246

2,683

-2,052

5,129

230

788

2,260

1,092

-95

Amortization of debt issuance costs

1,180

960

961

1,030

961

1,610

1,132

1,763

297

298

297

298

297

296

285

298

294

296

75

90

94

98

84

Changes in fair value of contingent consideration

106

-267

210

-

-

-

-

-

-

-

-

0

0

149

-9,071

8,384

-6,829

4,841

328

-

-

-

-

Contingent consideration payments

-

-

-

-1,058

-477

-2,234

-470

-

-

-

-

0

-3,792

18

-400

0

-3,438

0

-300

-

-

-

-

Deferred income tax benefit

-2,094

320

452

-9,813

-1,402

-85

-547

-10,158

-1,616

-767

1,746

-45

-2,354

3,545

7,633

-5,800

-265

-709

2,159

-4,581

1,181

-387

2,492

Equity loss and impairment of non-consolidated entities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-5,121

-377

-309

-401

Excess tax benefits related to share-based awards (Note 10)

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

6,457

9,365

3,184

1,799

-

-

-

-

Loss on sale or disposal of property and equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4

10

-3

Other

-

-

633

-

-

-

-3

-

-

-

-

1

0

0

1

25

-150

0

210

-

-

-

-

Changes in operating assets and liabilities, net of business acquisition
Accounts receivable

5,311

2,834

5,726

-28,757

8,358

22,753

-21

-3,618

-7,141

24,430

-21,406

-8,511

-25,607

33,263

15,983

7,258

-4,717

38,732

9,498

24,567

-8,591

8,964

18,190

Inventories

1,822

5,289

-36,779

40,649

-310

-24,504

-11,903

8,566

14,800

-22,360

-14,819

18,148

14,836

-3,554

14,912

13,278

-6,166

35,476

-931

43,421

-2,304

15,358

-6,141

Accounts payable

39,299

42,651

-24,191

-7,185

-68,701

-12,991

8,465

26,143

11,298

6,287

-20,640

-11,296

-47,488

57,759

-4,881

24,558

6,423

16,341

-4,120

30,313

-22,066

43,991

4,267

Rebates payable

2,495

-609

-1,691

-6,688

4,696

-6,775

3,288

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other assets and liabilities

-3,688

1,730

-3,112

2,857

-7,021

-5,649

4,201

2,101

-463

6,266

-3,289

795

-2,970

4,506

-2,698

-9,004

-20,535

-3,184

-1,647

-6,171

542

2,164

-708

Net cash provided by operating activities

41,250

43,098

23,652

1,835

-33,445

18,080

48,572

41,608

26,393

22,958

44,295

-79

-14,544

51,528

-5,579

26,915

43,087

-36,458

-4,097

-28,872

-1,523

21,752

-925

Cash flows from investing activities:
Expenditures for property and equipment

1,116

-3,995

6,840

-6,741

2,393

4,920

567

619,653

1,125

-24,243

26,532

62,144

1,307

2,389

1,316

2,250

1,365

534

475

-

-

-

-

Expenditures for capitalized software for internal use

3,343

9,810

897

1,738

2,858

3,576

2,302

3,400

793

1,174

1,285

-3,580

2,448

2,917

4,432

2,876

3,027

2,674

3,444

3,712

1,865

2,543

1,350

Payments to acquire businesses, net of cash acquired

-

-

-

-

-

-

-

-73,141

23,075

53,002

569

-

-

-

-

-

-

-

-

-

-

-

-

Capital investments in and loans to non-consolidated entities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,500

0

0

500

Net proceeds from sales of property and equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4

11

6

Other

-1

-7

-14

-

0

-43

-3

-

-5

0

43

-

0

0

-1

-19

0

0

-8

-

-

-

-

Net cash used in investing activities

-11,506

-5,808

-7,723

6,474

-5,101

-9,742

-2,866

-549,969

-24,988

-29,933

-28,429

-1,987

-3,855

-74,378

-5,747

-528

-3,949

-303,185

-3,911

-7,564

-2,566

-54,125

-1,829

Cash flows from financing activities:
Net repayment of related parties' notes receivable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

135

15

Net payments on revolving line of credit

-20,000

-31,500

-19,800

-1,950

43,150

-4,900

-48,250

166,658

19,071

-3,197

-33,537

-

-

-

-

-

-

-

-

-76,562

-3,314

41,129

-23,875

Proceeds from long-term debt

-

-

-

-

-

-

-

550,000

0

0

25,000

-

-

-

-

-

-

-

-

-

-

-

-

Payments on long term debt

2,874

2,876

2,875

2,875

2,875

2,875

76,875

129,969

2,718

1,813

1,500

1,500

1,500

1,500

1,500

-

-

-

-

19,849

992

3,594

1,107

Payments of debt issuance costs

-

-

-

70

0

650

171

-

-

-

-

-

-

-

-

-1

-75

5,118

13

-

-

-

-

Proceeds from issuance of stock upon stock option exercises

-

-

-

99

648

1,442

1,909

278

1,590

3,208

2,799

690

2,555

693

510

-

-

-

-

-

-

-

-

Contingent consideration payments

-

-

-

2,242

1,523

35

530

-

-

-

-

0

1,959

122

600

0

2,312

0

700

-

-

-

-

Proceeds from public offering, net of transaction costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

750

-33

-10

187,281

-

-

-

-

Payments made to repurchase stock options

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

36,298

0

0

6,300

3,100

Excess tax benefits related to share-based awards (Note 10)

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

6,457

9,365

3,184

1,799

-

-

-

-

Net cash used in financing activities

-27,140

-34,258

-22,675

-7,038

39,400

-7,018

-123,917

565,460

17,943

-1,802

-7,238

-7,073

27,585

16,072

-1,590

-14,452

-40,778

194,930

152,069

38,606

-5,674

57,923

-6,355

Net decrease in cash and equivalents

-

-

-6,746

-

-

-

-78,211

57,099

19,348

-8,777

8,628

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sale of preferred stock, net of transaction costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

53,188

48,627

Payments made to repurchase common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

26,500

26,900

Net increase (decrease) in cash and equivalents

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-12,916

-

-1,640

-144,713

144,061

2,170

-9,763

25,550

-9,109

Supplemental disclosures of cash flow information:
Cash paid for interest

9,748

9,210

9,254

10,144

9,118

8,429

10,160

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for interest

-

-

-

-

-

-

-

-

1,739

1,676

1,710

-

1,475

1,443

875

1,219

1,513

1,005

212

837

698

1,168

-455

Cash paid for income taxes

-

-

-67

1,378

401

1,789

-48

1,160

258

4,575

-117

-563

890

-42

443

5

130

170

46

-

-

-

-