Horizon therapeutics public limited company (HZNP)
CashFlow / TTM
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'11Mar'11
CASH FLOWS FROM OPERATING ACTIVITIES:
Net loss

592,292

573,020

106,005

97,044

77,413

-38,380

-150,181

-223,426

-408,211

-350,125

-493,349

-435,247

-210,727

-165,563

-12,298

-3,151

13,679

39,532

-16,109

-17,323

-76,906

-263,603

-334,857

-342,412

-333,084

-149,005

-70,437

-81,898

-86,239

-87,794

-140,188

-140,464

-129,320

-113,265

0

0

0

Adjustments to reconcile net loss to net cash (used in) provided by operating activities:
Depreciation and amortization expense

244,007

237,157

220,399

243,309

246,215

249,759

249,628

237,540

247,039

256,087

280,355

262,154

242,506

221,665

198,783

190,125

170,650

138,343

110,372

73,916

46,941

34,009

21,134

16,291

12,791

9,310

7,728

7,253

6,384

5,538

4,776

4,296

4,259

4,199

0

0

0

Equity-settled share-based compensation

120,088

91,215

94,945

105,221

114,575

114,860

120,609

125,613

124,015

125,019

120,399

115,561

114,111

113,019

111,311

107,632

104,624

83,553

59,340

38,450

17,945

13,198

11,919

9,001

5,862

5,014

4,205

4,271

3,981

4,661

4,365

3,795

3,692

2,530

0

0

0

Amortization of debt discount and deferred financing costs

22,320

22,602

22,941

23,188

23,106

22,751

22,635

22,175

21,692

21,619

20,940

20,243

19,544

18,546

18,951

19,914

21,029

18,810

15,514

12,435

9,146

9,273

8,408

7,201

5,787

4,364

0

0

0

-

-

-

-

-

-

-

-

Non-cash interest expense and amortization of deferred charges

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

Paid-in-kind interest expense

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,225

0

0

0

-

-

-

-

-

-

-

-

Loss on induced conversions of debt and debt extinguishment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-21,581

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loss on debt extinguishment

-

-58,835

0

0

0

-

-

-

-

-978

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Foreign exchange loss

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-2,537

1,335

2,073

1,206

1,468

938

-917

489

-1,109

-2,455

-944

-1,023

0

0

0

Other

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loss (gain) on sale of assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-76

0

0

0

-

-

-

-

Loss on derivative revaluation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

214,995

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Deferred income taxes

569,121

565,537

57,834

63,995

64,669

64,491

67,597

54,498

82,856

132,231

93,392

139,685

110,599

65,561

81,693

27,038

184,562

180,549

138,252

166,157

5,706

7,516

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Royalty accretion

-

-

-

-

-

-

-

-

-

-

50,269

47,282

44,216

40,616

35,279

32,095

26,403

20,088

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Impairment of long-lived assets

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Royalty liability remeasurement

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Foreign exchange and other adjustments

20

-574

-661

-366

-856

-332

-298

1,620

2,373

1,466

1,369

-874

-1,034

-420

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable

21,472

-56,166

5,595

-8,348

-8

59,697

-31,228

-14,565

-10,997

84,444

27,435

81,606

92,810

68,271

131,844

111,531

141,161

124,766

129,520

107,515

75,484

46,183

51,313

44,446

32,333

12,491

10,698

6,718

6,982

1,087

5,759

661

-1,700

1,817

0

0

0

Inventories

16,865

3,268

5,626

1,773

4,857

-10,280

-32,791

-52,184

-85,611

-108,371

-127,273

-121,592

-97,366

-67,633

-23,239

-15,438

-16,445

-12,216

-19,863

-18,238

-10,990

-7,173

1,671

3,377

5,021

3,426

3,173

2,580

1,913

4,022

2,560

2,730

2,331

923

0

0

0

Prepaid expenses and other current assets

97,827

72,763

61,842

21,271

15,397

25,313

25,981

19,062

2,250

-5,110

11,836

9,179

30,442

28,239

20,241

20,209

-35,079

-1,014

6,700

2,400

39,297

9,208

3,830

3,393

5,837

1,240

-1,533

-1,030

-1,418

543

2,768

4,183

3,497

1,897

0

0

0

Accounts payable

13,412

-8,723

-38,050

10,553

-4,705

-4,593

32,012

-49,936

-46,071

-16,521

-36,044

19,610

15,287

32,065

3,120

32,312

44,512

-8,362

37,041

5,007

9,013

9,383

15,414

10,236

5,286

3,908

-1,846

-2,302

-3,795

-2,209

3,149

2,932

4,909

5,643

0

0

0

Accrued trade discounts and rebates

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Accrued expenses

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

1,821

1,339

6,221

980

-3,190

-2,121

-1,935

-208

5,496

5,339

4,286

3,215

0

0

0

Deferred revenues

-

-4,901

-6,758

1,682

1,022

-395

2,160

4,417

3,602

4,468

5,327

1,916

994

1,114

-893

-1,503

1,221

1,693

1,905

1,854

-700

-562

-600

-9

-1,382

-1,145

-1,751

-1,131

2,219

2,616

4,826

5,221

2,576

3,237

0

0

0

Deferred tax liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-20,077

-15,749

-15,770

-15,778

0

0

0

Other non-current assets and liabilities

-18,787

-2,613

10,513

7,579

14,706

10,440

-18,878

11,023

-4,827

-5,720

8,451

-15,036

-1,496

-4,455

-4,345

-12,104

-11,393

-8,120

-2,620

-691

-449

-636

-274

-392

-526

-468

0

0

0

-

-

-

-

-

-

-

-

Net cash (used in) provided by operating activities

307,571

426,332

343,660

341,005

311,522

194,543

229,095

212,583

198,723

284,340

280,265

340,703

340,081

369,456

365,209

324,805

319,086

194,166

69,307

-17,610

-42,433

27,549

6,292

-4,615

-32,275

-54,287

-60,277

-73,662

-78,620

-76,641

-74,074

-67,541

-55,832

-41,540

0

0

0

Payment related to license agreement

-

-

-

-

-

12,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments for acquisitions, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

1,354,921

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments for acquisition

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of property and equipment

135,012

17,857

15,215

10,867

5,955

4,771

1,189

2,471

3,578

4,336

5,137

5,576

9,623

15,725

17,258

17,651

13,104

7,156

6,177

4,744

4,583

3,500

2,392

1,890

1,467

1,198

967

638

1,428

1,336

2,167

2,611

1,696

1,604

0

0

0

Change in escrow deposit for property purchase

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-234,212

-17,857

25,785

39,557

38,469

27,653

-1,868

-13,542

-113,427

-102,185

-935,988

-937,561

-848,812

-1,370,646

-499,293

-569,657

-1,516,866

-995,048

-1,080,850

-1,186,564

-228,665

-227,720

-216,549

-36,827

-36,404

-36,135

-967

-688

-1,478

-1,386

-2,517

-3,161

-2,246

-2,154

0

0

0

CASH FLOWS FROM FINANCING ACTIVITIES:
Proceeds (refunds) related to the ESPP plan

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from the issuance of ordinary shares in connection with warrant exercises

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

18,124

23,323

21,982

24,841

38,461

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from the issuance of ordinary shares in conjunction with ESPP program

-

-

-

-

-

8,610

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred financing expenses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Proceeds from the issuance of ordinary shares in connection with stock option exercises

21,890

24,882

23,455

25,329

26,069

16,972

10,158

4,542

2,568

2,167

2,253

3,514

3,500

3,875

3,999

2,987

4,347

5,217

5,591

4,984

3,870

2,693

0

0

0

-

-

-

-

-

-

-

-

-

0

0

0

Payment of employee withholding taxes relating to share-based awards

61,062

31,569

31,033

29,644

28,109

14,455

13,775

10,516

5,773

6,533

5,870

6,007

5,631

5,539

5,999

5,802

5,994

3,024

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from private equity offerings, net of issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

Repayment of notes payable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

19,788

20,100

20,516

31,623

13,067

0

0

0

Net proceeds from the issuance of ordinary shares

-

326,793

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Change in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,411

2,569

2,178

1,122

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net proceeds from term loans

-

-

-

-

-

-

-

-

-

1,693,512

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayment of term loans

-

1,336,207

1,736,207

1,636,053

1,143,624

845,749

875,597

875,596

852,124

1,622,749

0

0

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from issuance of bridge notes payable to related parties

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

6,766

0

0

0

Proceeds from the issuance of notes payable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

Net cash (used in) provided by financing activities

-350,681

-290,446

-293,287

-227,112

8,708

-16,596

-45,533

-46,088

-21,519

54,276

732,432

730,778

732,452

657,074

204

2,607

1,039,717

1,442,481

1,446,906

1,742,900

712,627

338,285

0

0

0

-

-

-

-

164,308

164,225

127,681

134,818

55,152

0

0

0

Effect of foreign exchange rate changes on cash, cash equivalents and restricted cash

-955

-107

-1,894

-319

-2,880

-1,380

262

2,117

6,596

5,316

3,618

1,230

-1,087

-1,210

-1,103

-287

-295

-790

142

-520

-692

213

-39

84

105

99

191

43

-140

-160

695

709

1,055

1,124

0

0

0

Net (decrease) increase in cash, cash equivalents and restricted cash

-278,277

117,922

74,264

153,131

355,819

204,220

181,956

155,070

70,373

241,747

80,327

135,150

222,634

-345,326

-134,983

-242,532

-158,358

640,809

435,505

538,206

440,837

138,327

190,131

59,511

22,298

-23,607

-62,676

5,880

725

86,121

88,329

57,688

77,795

12,582

0

0

0

SUPPLEMENTAL CASH FLOW INFORMATION:
Cash paid for interest

88,838

78,044

117,217

106,468

112,934

112,468

106,530

110,910

108,484

113,790

95,653

89,422

71,965

60,817

60,146

60,057

44,244

42,021

0

0

0

-

-

-

-

8,573

7,309

7,356

6,298

7,554

6,487

5,399

5,192

2,757

0

0

0

Cash paid for income taxes, net of refunds received

9,335

9,925

21,683

33,380

54,828

53,058

40,903

28,351

1,698

2,548

5,855

5,799

19,907

22,339

18,515

18,329

3,009

1,880

1,911

1,627

1,266

37

38

38

37

44

48

55

63

57

0

0

0

-

0

0

0

Cash paid for amounts included in the measurement of lease liabilities, net of lease incentive payments

6,685

6,484

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for debt extinguishment

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Fees paid for debt commitments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

8,222

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for induced conversions and debt extinguishment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

SUPPLEMENTAL NON-CASH FLOW INFORMATION:
Purchases of property and equipment included in accounts payable and accrued expenses

-2,103

117

1,593

2,935

3,852

1,101

0

0

0

-

-356

-550

-911

700

4,911

6,947

6,758

4,940

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Transaction costs related to issuance of ordinary shares included in accrued expenses

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Conversion of Convertible Senior Notes to ordinary shares

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

60,985

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Commitment fee paid on notes payable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

0

0

Accrued Trade Discounts and Rebates [Member]
Accrued liabilities

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accrued Expenses [Member]
Accrued liabilities

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-