Ngl energy partners lp (NGL)
Balance Sheet / 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'11
ASSETS
CURRENT ASSETS:
Cash and Cash Equivalents, at Carrying Value

12

21

27

18

23

36

13

22

28

18

19

12

28

23

10

28

25

30

43

41

30

11

39

10

8

5

4

11

23

26

21

7

10

8

8

16

Accounts receivable-trade, net of allowance for doubtful accounts of $4,055 and $4,016, respectively

947

987

911

998

1,006

1,366

1,096

1,026

1,063

841

652

800

765

592

607

521

581

712

905

1,025

1,664

1,433

903

877

1,099

602

545

562

595

385

347

84

115

55

48

44

Accounts receivable-affiliates

12

14

11

12

12

17

8

4

3

2

1

6

20

3

3

15

3

6

18

17

42

41

1

7

6

3

14

22

1

3

4

2

2

0

0

-

Inventories

183

308

519

136

572

679

600

551

645

570

563

561

613

520

522

367

414

408

489

442

535

941

373

310

443

355

208

126

234

264

192

94

184

107

53

12

Product exchanges

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3

0

0

0

Derivative financial instruments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4

-

-

-

Prepaid expenses and other current assets

90

199

178

65

210

159

135

128

97

112

96

103

134

110

123

95

117

120

130

121

184

156

58

80

96

47

39

37

58

57

62

10

7

2

2

3

Assets held for sale

95

0

-

580

124

0

515

517

131

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3

-

-

-

Total current assets

1,341

1,531

1,649

1,812

1,949

2,259

2,369

2,251

1,969

1,546

1,333

1,484

1,562

1,250

1,269

1,028

1,229

1,276

1,587

1,647

2,457

2,585

1,376

1,286

1,654

1,013

812

761

912

736

628

198

332

174

113

77

PROPERTY, PLANT AND EQUIPMENT, net of accumulated depreciation of $504,731 and $417,457, respectively

2,704

2,485

2,015

1,828

1,726

1,706

1,604

1,518

1,708

1,768

1,769

1,790

1,746

1,755

1,733

1,649

1,972

1,845

1,743

1,624

1,472

1,433

863

835

806

631

536

526

520

425

435

231

227

66

65

66

Goodwill

1,307

1,176

1,153

1,110

1,182

1,271

1,262

1,204

1,313

1,339

1,451

1,451

1,462

1,467

1,448

1,315

1,700

1,658

1,600

1,558

1,361

1,254

1,158

1,085

1,037

840

563

555

510

515

476

167

92

9

8

8

INTANGIBLE ASSETS, net of accumulated amortization of $603,573 and $503,117, respectively

1,600

1,194

931

800

922

966

907

913

1,064

1,112

1,130

1,163

1,164

1,190

1,173

1,148

1,225

1,215

1,234

1,232

1,153

838

699

736

713

534

434

441

487

345

355

149

99

12

11

11

INVESTMENTS IN UNCONSOLIDATED ENTITIES

22

1

1

1

4

4

1

17

16

198

190

187

187

190

192

219

467

473

474

472

478

482

211

194

248

-

-

-

-

-

-

-

-

-

-

-

OPERATING LEASE RIGHT-OF-USE ASSETS

183

203

518

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

LOAN RECEIVABLE-AFFILIATE

-

-

-

-

0

0

2

1

0

4

3

3

2

1

1

22

23

23

23

8

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

Other Assets, Noncurrent

83

71

125

113

170

176

175

245

242

240

238

239

251

217

184

176

106

108

110

112

94

42

13

9

15

5

6

6

7

5

3

2

2

-

-

-

ASSETS HELD FOR SALE

0

0

-

234

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Total assets

7,242

6,664

6,394

5,902

5,955

6,385

6,323

6,151

6,316

6,209

6,118

6,320

6,378

6,073

6,002

5,560

6,724

6,601

6,774

6,655

7,017

6,635

4,322

4,147

4,476

3,026

2,353

2,291

2,437

2,029

1,900

749

755

262

198

163

LIABILITIES AND EQUITY
CURRENT LIABILITIES:
Accounts payable-trade

846

842

814

879

905

1,045

836

852

866

635

522

658

650

512

528

420

511

568

755

833

1,534

1,345

810

719

1,152

604

571

536

579

419

360

81

107

62

49

37

Accounts payable-affiliates

29

24

23

28

23

42

24

1

0

4

1

7

22

6

8

7

11

18

25

25

12

85

37

76

18

18

10

6

6

11

14

9

9

-

-

-

Accrued expenses and other payables

352

336

214

107

263

267

225

223

230

227

192

207

196

184

256

214

197

169

243

202

282

223

128

141

141

101

96

85

74

68

51

14

9

4

5

3

Product exchanges

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

15

-

19

10

7

1

Advance payments received from customers

29

27

28

8

21

29

21

8

46

80

57

35

63

87

68

56

73

96

66

54

72

106

56

29

62

67

35

22

59

74

47

20

29

33

15

7

Current maturities of long-term debt

4

0

0

0

339

716

0

0

3

42

42

29

33

8

7

7

7

4

3

4

4

5

6

7

7

8

8

8

8

78

92

19

92

40

1

0

Operating lease obligations

57

68

77

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Liabilities held for sale

40

0

-

226

10

0

55

42

16

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Total current liabilities

1,361

1,298

1,157

1,251

1,564

2,101

1,165

1,129

1,164

989

816

938

966

798

869

706

801

857

1,094

1,119

1,906

1,764

1,038

974

1,382

800

722

659

727

653

581

144

269

151

79

50

LONG-TERM DEBT, net of debt issuance costs of $20,263 and $12,008, respectively, and current maturities

3,068

2,773

2,586

2,160

1,877

1,815

3,032

2,679

2,921

2,993

2,834

2,963

3,216

3,063

2,866

2,912

3,306

3,077

2,951

2,727

2,753

2,437

1,441

1,629

1,517

906

781

740

827

569

510

199

117

10

10

65

OPERATING LEASE OBLIGATIONS

122

132

439

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

OTHER NONCURRENT LIABILITIES

104

64

61

63

74

86

63

173

168

175

176

184

186

198

199

247

112

127

126

115

111

114

58

11

39

2

3

2

1

2

2

0

0

0

0

0

NONCURRENT LIABILITIES HELD FOR SALE

0

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

COMMITMENTS AND CONTINGENCIES (NOTE 9)

-

-

-

-

-

0

0

-

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

REDEEMABLE NONCONTROLLING INTEREST

-

-

-

-

-

-

-

-

4

3

3

3

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

EQUITY:
General partner, representing a 0.1% interest, 128,477 and 124,633 notional units, respectively

-51

-51

-50

-50

-50

-50

-50

-50

-50

-50

-50

-50

-50

-50

-50

-50

-

-

-

-37

-

-

-

-45

-46

-48

-49

-50

-50

-51

-51

0

0

0

0

0

Limited partners, representing a 99.9% interest, 128,348,906 and 124,508,497 common units issued and outstanding, respectively

1,682

1,697

1,897

2,067

2,085

2,046

1,740

1,852

1,823

1,819

2,063

2,192

1,969

1,977

2,023

1,707

-

-

-

2,183

-

-

-

-

-

-

-

-

912

839

840

-

349

81

86

47

Accumulated other comprehensive loss

-0

-0

-0

-0

-0

-0

-0

-1

-1

-2

-2

-1

-0

-0

-0

-0

-0

-0

-0

-0

-0

-0

-0

-0

-0

-

-

0

-

-

-

-

-

-

-

-

Subordinated units - 5,919,346 units outstanding at December 31, 2012 and March 31, 2012

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

13

11

13

-

18

18

21

-

Foreign currency translation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-0

-0

-

0

0

0

0

0

-

0

0

Noncontrolling interests

74

57

58

58

77

78

79

83

7

7

7

26

29

29

37

37

546

544

547

546

569

568

5

5

7

7

6

5

5

3

2

0

-

-

-

-

Total equity

2,053

2,051

2,150

2,277

2,315

2,277

1,971

2,086

1,981

1,976

2,220

2,166

1,947

1,955

2,010

1,694

2,504

2,538

2,602

2,693

2,245

2,318

1,782

1,531

1,537

1,317

845

889

880

803

805

405

368

100

108

47

Total liabilities and equity

7,242

6,664

6,394

5,902

5,955

6,385

6,323

6,151

6,316

6,209

6,118

6,320

6,378

6,073

6,002

5,560

6,724

6,601

6,774

6,655

7,017

6,635

4,322

4,147

4,476

3,026

2,353

2,291

2,437

2,029

1,900

749

755

262

198

163

Class A Convertible Preferred Units
Temporary Equity, Carrying Amount, Including Portion Attributable to Noncontrolling Interests

0

0

0

149

122

104

91

82

76

71

67

63

61

58

56

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Class D Preferred Units
Temporary Equity, Carrying Amount, Including Portion Attributable to Noncontrolling Interests

531

343

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Class B Perpetual Preferred Units
Preferred limited partners

305

305

202

202

202

202

202

202

202

202

202

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Class C Perpetual Preferred Units
Preferred limited partners

42

42

42

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-