hD

Cash Flow Summary

Diplomat Pharmacy (DPLO) quarterly cash flow statement covering the six quarters from June 2018 to September 2019, as reported to the SEC.

  • Diplomat Pharmacy generated $41.25M in cash from operations in the quarter ended September 30, 2019, after a loss of $33.45M a year earlier.
  • After spending $1.12M on expenditures for property and equipment, free cash flow was $40.13M.
  • Investing activities used $11.51M and financing activities used $27.14M.

A cash flow statement shows the cash that actually came in and went out, split between running the business, investing and financing.

Figures in USD thousands
Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18
Cash flows from operating activities:
Net loss

-177,280

-159,462

-14,301

-298,025

170

-3,964

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net loss

-177,280

-159,462

-14,301

-298,025

170

-3,964

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

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

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Depreciation and amortization

17,059

20,064

21,395

24,565

24,377

24,219

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Share-based compensation expense

4,777

4,283

3,572

2,401

5,649

6,961

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Share-based compensation expense

4,777

4,283

3,572

2,401

5,649

6,961

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net provision for doubtful accounts

3,523

3,120

2,447

2,798

1,943

1,597

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net provision for doubtful accounts

3,523

3,120

2,447

2,798

1,943

1,597

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Amortization of debt issuance costs

1,180

960

961

1,030

961

1,610

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Amortization of debt issuance costs

1,180

960

961

1,030

961

1,610

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Changes in fair value of contingent consideration

106

-267

210

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Changes in fair value of contingent consideration

106

-267

210

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Contingent consideration payments

-

-

-

-1,058

-477

-2,234

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Contingent consideration payments

-

-

-

-1,058

-477

-2,234

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Deferred income tax benefit

-2,094

320

452

-9,813

-1,402

-85

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Deferred income tax benefit

-2,094

320

452

-9,813

-1,402

-85

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Equity loss and impairment of non-consolidated entities

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Equity loss and impairment of non-consolidated entities

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

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

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

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

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Loss on sale or disposal of property and equipment

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Loss on sale or disposal of property and equipment

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Other

-

-

633

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Other

-

-

633

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

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

5,311

2,834

5,726

-28,757

8,358

22,753

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Accounts receivable

5,311

2,834

5,726

-28,757

8,358

22,753

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Inventories

1,822

5,289

-36,779

40,649

-310

-24,504

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Inventories

1,822

5,289

-36,779

40,649

-310

-24,504

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Accounts payable

39,299

42,651

-24,191

-7,185

-68,701

-12,991

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Accounts payable

39,299

42,651

-24,191

-7,185

-68,701

-12,991

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Rebates payable

2,495

-609

-1,691

-6,688

4,696

-6,775

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Rebates payable

2,495

-609

-1,691

-6,688

4,696

-6,775

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Other assets and liabilities

-3,688

1,730

-3,112

2,857

-7,021

-5,649

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Other assets and liabilities

-3,688

1,730

-3,112

2,857

-7,021

-5,649

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net cash provided by operating activities

41,250

43,098

23,652

1,835

-33,445

18,080

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net cash provided by operating activities

41,250

43,098

23,652

1,835

-33,445

18,080

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Cash flows from investing activities:
Expenditures for property and equipment

1,116

-3,995

6,840

-6,741

2,393

4,920

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Expenditures for property and equipment

1,116

-3,995

6,840

-6,741

2,393

4,920

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Expenditures for capitalized software for internal use

3,343

9,810

897

1,738

2,858

3,576

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Expenditures for capitalized software for internal use

3,343

9,810

897

1,738

2,858

3,576

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Payments to acquire businesses, net of cash acquired

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Payments to acquire businesses, net of cash acquired

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Capital investments in and loans to non-consolidated entities

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Capital investments in and loans to non-consolidated entities

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net proceeds from sales of property and equipment

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net proceeds from sales of property and equipment

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Other

-1

-7

-14

-

-

-43

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Other

-1

-7

-14

-

-

-43

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net cash used in investing activities

-11,506

-5,808

-7,723

6,474

-5,101

-9,742

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net cash used in investing activities

-11,506

-5,808

-7,723

6,474

-5,101

-9,742

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

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

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net repayment of related parties' notes receivable

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net payments on revolving line of credit

-20,000

-31,500

-19,800

-1,950

43,150

-4,900

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net payments on revolving line of credit

-20,000

-31,500

-19,800

-1,950

43,150

-4,900

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Proceeds from long-term debt

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Proceeds from long-term debt

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Payments on long term debt

2,874

2,876

2,875

2,875

2,875

2,875

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Payments on long term debt

2,874

2,876

2,875

2,875

2,875

2,875

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Payments of debt issuance costs

-

-

-

70

-

650

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Payments of debt issuance costs

-

-

-

70

-

650

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Proceeds from issuance of stock upon stock option exercises

-

-

-

99

648

1,442

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Proceeds from issuance of stock upon stock option exercises

-

-

-

99

648

1,442

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Contingent consideration payments

-

-

-

2,242

1,523

35

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Contingent consideration payments

-

-

-

2,242

1,523

35

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Proceeds from public offering, net of transaction costs

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Proceeds from public offering, net of transaction costs

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Payments made to repurchase stock options

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Payments made to repurchase stock options

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

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

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

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

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net cash used in financing activities

-27,140

-34,258

-22,675

-7,038

39,400

-7,018

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net cash used in financing activities

-27,140

-34,258

-22,675

-7,038

39,400

-7,018

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net decrease in cash and equivalents

-

-

-6,746

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net decrease in cash and equivalents

-

-

-6,746

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Proceeds from sale of preferred stock, net of transaction costs

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Proceeds from sale of preferred stock, net of transaction costs

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Payments made to repurchase common stock

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Payments made to repurchase common stock

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net increase (decrease) in cash and equivalents

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Net increase (decrease) in cash and equivalents

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Supplemental disclosures of cash flow information:
Cash paid for interest

9,748

9,210

9,254

10,144

9,118

8,429

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Cash paid for interest

9,748

9,210

9,254

10,144

9,118

8,429

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Cash paid for interest

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Cash paid for interest

-

-

-

-

-

-

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Cash paid for income taxes

-

-

-67

1,378

401

1,789

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

Cash paid for income taxes

-

-

-67

1,378

401

1,789

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx

xxxxx