Ngl energy partners lp (NGL)
CashFlow / TTM
Dec'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'11Dec'10
OPERATING ACTIVITIES:
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest

-107,119

-39,582

516,723

339,395

407,090

353,331

-175,187

-69,605

-154,031

-209,507

-102,586

143,874

-89,597

-39,895

20,663

-187,097

131,139

74,875

65,096

50,193

-17,912

11,409

26,356

48,758

27,953

44,378

55,392

48,190

39,792

5,404

-10,074

7,864

544

511

0

0

0

Adjustments to reconcile net (loss) income to net cash provided by operating activities:
Income (Loss) from Discontinued Operations, Net of Tax, Attributable to Parent

-223,182

-258,946

407,275

403,119

580,344

642,187

158,282

156,780

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Depreciation and amortization, including amortization of debt issuance costs

261,041

239,730

229,610

227,694

220,017

220,787

224,938

225,738

192,250

201,308

198,478

194,829

231,696

232,793

238,487

249,211

249,328

237,402

230,865

210,475

195,030

178,456

151,331

132,653

120,453

103,858

92,331

77,513

54,073

38,531

25,186

17,188

12,312

8,539

0

0

0

Loss on early extinguishment or revaluation of liabilities, net

-5,947

-6,030

-6,030

-6,967

-26,858

-37,916

-41,573

-43,917

-40,959

-19,818

-15,223

18,010

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Gain on early extinguishment of liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loss on early extinguishment of debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

Non-cash equity-based compensation expense

36,001

41,633

39,557

41,367

40,702

45,085

31,931

35,241

40,357

34,994

39,586

53,102

41,344

33,077

37,608

51,565

69,463

72,491

61,292

32,767

16,598

19,050

14,748

14,054

14,188

12,475

15,090

8,670

0

0

0

-

-

-

-

-

-

Gain (Loss) on Disposition of Assets

47,263

70,883

68,006

-34,296

-67,219

8,923

-96,048

17,104

18,703

-93,719

16,388

208,890

-114,293

-115,587

-116,026

-320,766

-9,585

-38,330

-41,173

-41,184

-35,733

-6,000

-3,656

-3,597

-2,724

-2,373

-553

-187

0

0

0

-

-

-

-

-

-

Revaluation of liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Provision for doubtful accounts

665

973

453

369

343

48

481

590

-802

-173

-707

-1,000

2,329

2,460

4,580

5,628

5,477

5,804

4,914

4,105

2,731

3,011

2,332

2,445

2,518

1,740

1,386

1,315

1,553

1,296

1,296

1,049

657

378

0

0

0

Derivative Instruments Not Designated as Hedging Instruments, Gain (Loss), Net

4,431

144,531

112,831

33,631

12,896

-138,675

-205,831

-116,604

-52,840

-45,641

40,249

-55,978

-96,484

13,723

84,766

103,223

75,498

225,459

195,663

219,421

224,048

12,722

-53,931

-43,655

-43,111

-27,276

-15,813

-4,376

15,819

10,528

10,231

5,974

3,119

1,933

0

0

0

Income (Loss) from Equity Method Investments

435

1,678

2,322

2,533

3,237

4,048

5,942

7,539

8,781

7,472

5,252

3,830

3,839

5,418

7,797

16,121

18,607

16,991

18,256

12,103

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Distributions of earnings from unconsolidated entities

-

-

-

-

-

-

-

4,632

6,361

6,299

4,813

3,564

3,756

5,853

11,418

17,404

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Lower of cost or market value adjustment

38,753

51,835

53,177

50,987

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Revaluation of Investments

-

-

-

-

-

-

-

-

-

-

-

14,365

14,365

14,365

14,365

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other

-1,370

664

1,340

485

507

8,599

4,104

41

4,299

-4,311

2,574

7,809

4,728

8,784

7,224

5,854

10,247

-252

777

577

-5,905

533

-317

-312

-70

-311

-500

-375

-347

-396

-472

-403

0

0

0

-

-

Changes in operating assets and liabilities, exclusive of acquisitions:
Accounts receivable-trade and affiliates

26,597

-249,409

-182,466

144,209

65,841

599,031

476,978

272,990

275,363

259,796

49,663

254,124

194,211

-129,241

-310,462

-505,540

-1,070,739

-722,122

-163,945

-41,395

393,374

309,369

-739

-21,115

128,320

127,190

119,395

-2,562

-16,993

-92,381

-123,062

20,179

31,266

11,634

0

0

0

Accounts receivable-affiliates

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

35,646

35,543

-15,933

-18,002

2,477

-167

9,880

12,877

0

0

0

-

-

-

-

-

-

Inventories

-97,584

-98,388

-40,275

-52,870

19,249

100,398

52,949

8,048

28,541

51,093

38,649

189,311

199,491

111,154

32,922

-74,686

-117,921

-481,590

-259,811

-243,292

-246,402

50,559

55,733

73,321

58,052

86,313

13,172

-18,433

-6,095

-2,875

-21,173

-30,268

20,898

34,175

0

0

0

Other current and noncurrent assets

-25,725

-14,494

-21,299

-44,261

-12,878

13,619

34,681

22,472

-5,394

24,371

-31,684

54,184

74,565

15,531

21,688

-10,572

-35,811

-2,909

44,944

34,505

24,391

24,971

-5,097

-20,308

-9,960

-7,962

-23,732

-22,585

-15,671

-17,928

-13,007

-14,344

0

0

0

-

0

Product exchanges, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-8,834

7,473

0

0

0

Accounts payable-trade and affiliates

69,090

-121,588

-24,637

101,699

-1,062

402,960

304,143

195,339

188,275

120,166

-11,343

236,633

143,131

-76,891

-252,750

-439,709

-1,070,365

-789,175

-201,314

-53,086

308,951

235,982

-132,178

-167,060

160,584

121,777

158,735

-16,913

-6,399

-67,710

-116,741

35,747

38,072

28,327

0

0

0

Other current and noncurrent liabilities

3,630

-56,956

-24,806

-10,620

-16,028

15,990

-10,378

-14,252

8,895

7,133

1,584

3,573

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accounts payable-affiliates

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-5,380

64,224

24,617

67,361

13,730

11,414

-485

-6,813

0

0

0

-

-

-

-

-

-

Accrued expenses and other liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-15,311

-34,114

-48,228

-41,671

747

24,137

5,535

-9,689

-12,630

-16,299

-8,424

366

-439

-208

0

0

0

Advance payments received from customers

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

7,344

25,004

10,454

-3,074

-7,856

-7,669

-13,059

-11,049

11,469

21,407

11,641

4,582

2,433

-5,073

0

0

0

Net Cash Provided by (Used in) Operating Activities, Continuing Operations

577,907

527,735

450,594

307,514

89,741

-159,630

-9,872

53,629

-15,145

-70,578

-36,945

-97,800

-57,211

122,523

199,126

351,495

473,685

498,121

335,014

262,391

102,303

72,345

68,909

85,236

199,333

136,696

213,076

132,634

102,067

90,315

57,763

90,329

20,202

-18,783

0

0

0

Net cash provided by operating activities-discontinued operations

-22,837

-107,092

-2,305

29,736

159,597

198,007

105,703

84,338

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by operating activities

555,070

420,643

448,289

337,250

249,338

38,377

95,831

137,967

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

INVESTING ACTIVITIES:
Capital expenditures

578,877

521,169

538,294

455,613

355,444

280,641

178,826

133,761

162,662

189,942

232,402

344,936

429,318

641,242

679,954

661,885

589,690

367,403

301,221

227,978

192,638

180,600

183,823

165,148

143,051

125,279

99,983

72,475

40,782

20,045

9,388

7,544

4,900

3,534

0

0

0

Purchases of pipeline capacity allocations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisitions, net of cash acquired

1,381,818

766,013

254,892

316,936

197,971

197,971

116,592

19,897

-65,688

-51,472

47,367

41,928

174,809

197,403

185,212

234,652

34,233

452,704

1,008,951

960,922

1,142,680

1,534,969

1,279,720

1,268,810

1,237,684

576,328

200,423

490,805

598,109

602,293

592,672

297,401

192,860

19,590

0

0

0

Net settlements of commodity derivatives

-16,074

-126,817

-85,713

-18,405

9,764

137,735

184,615

100,405

39,846

33,860

-7,798

37,086

69,369

-37,615

-105,820

-105,662

-100,926

-237,870

-187,439

-199,165

-185,158

12,555

34,869

35,956

4,602

-3,197

-16,039

-11,579

18,845

15,829

19,761

6,464

1,649

1,438

0

0

0

Proceeds from sales of assets

24,898

9,955

12,444

16,177

10,840

19,473

20,757

33,844

45,376

50,411

46,287

28,232

17,669

5,284

6,962

8,455

16,007

21,088

27,204

26,262

32,594

31,177

24,561

24,660

11,682

6,723

5,807

5,080

1,629

1,637

1,560

1,238

0

0

0

-

-

Proceeds from sale of TLP common units

-

-

-

-

-

-

-

-

-

-

-

-

0

0

112,370

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from divestitures of businesses and investments, net

232,215

317,215

317,215

335,809

141,257

348,374

348,374

329,780

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Investments in unconsolidated entities

21,569

1,312

1,272

389

96

7,407

16,221

21,465

23,566

16,255

7,355

2,105

3,058

4,505

9,282

11,431

8,373

14,064

31,583

33,528

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Distributions of capital from unconsolidated entities

1,880

1,879

1,879

1,440

259

7,591

9,854

11,969

13,794

8,837

8,866

9,692

9,357

12,818

15,577

15,792

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loan for natural gas liquids facility

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,913

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayments on loan for natural gas liquids facility

4,987

8,800

10,651

10,336

10,998

9,735

10,358

10,052

9,756

9,467

9,187

8,916

8,651

8,396

8,148

7,618

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loan to affiliate

0

0

465

1,515

2,565

3,065

3,060

2,510

1,960

2,460

2,700

3,200

2,700

1,700

1,000

15,621

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayments on loan to affiliate

-

-

-

-

-

-

-

-

-

-

-

655

1,651

2,168

2,168

1,513

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payment to Terminate Contract

-

-

-

-

-

-

-

-

-

-

-

16,875

16,875

16,875

16,875

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments for (Proceeds from) Other Investing Activities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-853

-865

-762

-346

0

0

0

-

-

Net Cash Provided by (Used in) Investing Activities, Continuing Operations

-1,702,210

-873,703

-367,021

-392,286

-428,910

-243,910

-112,235

105,343

222,857

-100,330

-195,686

-264,265

-181,296

-339,939

-298,143

-445,327

-846,820

-956,863

-1,511,110

-1,366,221

-1,197,887

-1,728,807

-1,488,064

-1,455,373

-1,403,767

-713,498

-309,800

-546,621

-617,564

-604,007

-579,977

-296,897

-195,373

-21,305

0

0

0

Net cash provided by investing activities-discontinued operations

190,976

304,803

868,767

845,759

1,152,930

1,011,863

144,497

165,239

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Formation transaction contributions

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Net cash (used in) provided by investing activities

-1,511,234

-568,900

501,746

453,473

724,020

767,953

32,262

270,582

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

FINANCING ACTIVITIES:
Proceeds from borrowings under Revolving Credit Facility

4,603,000

4,288,500

4,275,500

4,098,500

3,716,500

3,628,000

3,097,000

2,434,500

2,198,500

1,744,500

1,566,000

1,700,000

1,736,400

2,017,800

2,314,800

2,602,500

2,709,900

3,139,700

3,991,200

3,764,500

3,601,700

3,463,500

2,785,000

2,545,500

2,290,500

1,694,800

1,020,800

1,227,975

1,106,375

975,575

918,575

478,900

412,646

247,500

0

0

0

Payments on Revolving Credit Facility

4,100,000

4,019,500

4,446,500

3,897,000

3,967,000

3,775,500

2,540,500

2,279,500

2,572,500

2,795,500

2,623,500

2,733,500

2,129,400

1,721,900

2,089,300

2,133,000

2,189,400

2,482,600

3,097,200

3,280,000

2,996,200

3,012,000

2,570,000

2,101,000

2,045,000

1,434,800

842,800

964,475

753,375

639,575

587,075

329,900

283,392

225,381

0

0

0

Issuance of senior unsecured notes

-

-

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

250,000

0

0

0

-

-

-

-

-

-

Repayment and repurchase of senior unsecured notes

341,587

731,989

731,989

737,058

466,602

376,361

417,377

486,699

421,632

121,471

80,455

21,193

58,550

58,550

58,550

43,421

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from borrowings under other long-term debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

880

0

0

0

-

-

-

-

-

-

-

-

-

-

Payments on other long-term debt

654

653

653

653

649

651

881

877

40,320

42,282

44,210

46,153

7,987

7,166

5,560

5,087

4,861

4,857

5,970

6,688

7,582

8,487

8,282

8,819

10,204

9,093

7,421

4,837

1,466

550

1,389

1,278

6,445

6,881

0

0

0

Debt issuance costs

13,666

11,049

8,485

1,383

1,118

1,006

1,375

2,700

23,447

35,712

35,609

33,558

13,161

9,177

10,276

10,237

9,934

3,258

8,888

11,076

11,360

31,575

24,578

24,595

25,637

4,568

3,950

20,189

18,949

18,287

20,579

2,380

2,670

6,860

0

0

0

Contributions from general partner

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

482

823

0

0

0

-

2,370

2,203

930

510

0

0

0

-

-

-

-

-

-

Contributions from noncontrolling interest owners, net

0

0

0

169

169

169

169

23

56

230

366

672

2,149

5,399

7,929

11,547

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Distributions to general and common unit partners and preferred unitholders

239,651

236,533

245,016

236,633

235,481

235,164

225,573

225,067

216,035

205,263

194,284

181,581

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Distributions to partners

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

419,798

316,721

221,740

145,090

19,387

33,868

53,624

71,608

-54,181

-35,623

-24,389

-19,060

0

0

0

-

-

Distributions to noncontrolling interest owners

-

-

-

-

-

-

-

-

-

-

-

3,292

12,374

20,690

28,018

35,720

36,288

36,273

36,192

27,147

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sale of preferred units, net of offering costs

622,965

428,338

42,638

0

0

-24

-246

202,731

202,717

202,712

202,772

234,975

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments for redemption of preferred units

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repurchase of warrants

0

0

0

14,988

14,988

14,988

14,988

10,549

10,549

10,549

10,549

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sale of common units, net of offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

541,128

0

0

0

-

-

-

-

-642

-688

-1,348

-1,203

74,759

0

0

0

-

0

Payments for settlement and early extinguishment of liabilities

2,996

3,211

3,925

4,577

4,534

4,397

3,858

3,408

2,899

2,712

2,839

28,468

27,977

27,406

26,374

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Subsidiary Investment in Stock of Parent

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sale of convertible preferred units and warrants, net of offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Common stock dividends

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Other

-

-

-

-

-

-

-

-

-

-

0

-

-

20

-27

-72

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Exercise of stock options of NGL Supply

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Repurchase of common units

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,418

0

0

0

-

-

Net Cash Provided by (Used in) Financing Activities, Continuing Operations

945,147

133,037

-936,216

-793,920

-974,074

-784,130

-135,359

-390,445

-161,569

196,429

271,824

375,087

242,255

210,790

66,389

80,705

367,758

476,972

1,179,923

1,134,693

1,117,239

1,662,757

1,454,231

1,369,016

1,189,432

556,321

79,860

417,716

529,032

531,298

534,960

198,063

179,815

44,555

0

0

0

Net cash used in financing activities-discontinued operations

0

0

0

-325

-516

-1,550

5,838

-3,836

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) financing activities

945,147

133,037

-936,216

-794,245

-974,590

-785,680

-129,521

-394,281

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Less cash flows from discontinued operations

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net (decrease) increase in cash and cash equivalents

-11,017

-15,220

13,819

-3,522

-1,232

20,650

-3,017

14,268

-1,030

-4,063

9,461

-16,710

3,748

-6,626

-32,628

-13,127

-5,377

18,230

3,827

30,863

21,655

6,295

35,076

-1,121

-15,002

-20,481

-16,864

3,729

13,535

17,606

12,746

-8,505

4,597

4,420

0

0

0

Supplemental cash flow information:
Cash interest paid

161,876

153,557

156,064

170,632

171,468

179,411

189,709

192,938

182,598

155,260

143,060

117,912

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Income taxes paid (net of income tax refunds)

4,802

4,292

4,052

2,423

2,122

1,738

1,504

1,843

1,651

1,740

1,585

2,022

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Supplemental non-cash investing and financing activities:
Distributions declared but not paid to Class B, Class C and Class D preferred unitholders

12,612

8,162

5,796

4,725

4,725

3,780

9,450

4,725

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accrued capital expenditures

25,221

46,006

39,390

19,121

39,413

30,724

23,391

12,123

6,448

2,592

-3,653

1,758

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-