Please Note: Blog posts are not selected, edited or screened by Seeking Alpha editors.

MLP UBTI Data

I had noted in prior articles that I would eventually post UBTI data in an upcoming article. For several reasons, that article is being delayed. For those wanting it, I am posting a small set of that data from tax year 2011 below. Those MLPs with 100% negative UBTIs would be relatively safe to own in an IRA. You are not taxed for negative UBTIs. It has never shown up in the UBTI data that a sale changes the UBTI number.

 

 

MLP

# observations

Min of UBTI/100

Max of UBTI/100

Average of UBTI/100

# negative UBTI/100

% negative UBTI/100

AB

2

-$54.75

$4.00

-$25.38

1

50%

AGU

1

$63.00

$63.00

$63.00

0

0%

AHGP

3

-$120.57

-$91.75

-$103.07

3

100%

APL

16

-$300.70

$96.82

-$79.87

14

88%

APU

7

-$271.52

$70.20

-$74.15

5

71%

ARLP

4

-$27.65

$257.00

$114.80

1

25%

ATLS

2

-$24.84

$5.16

-$9.84

1

50%

BBEP

15

-$10.75

$258.00

$119.01

4

27%

BIP

6

$0.00

$0.00

$0.00

6

100%

BPL

15

-$176.00

$323.82

$68.53

5

33%

BWK

1

$0.00

$0.00

$0.00

1

100%

BWP

25

-$198.00

-$0.25

-$91.30

25

100%

CEP

1

$169.20

$169.20

$169.20

0

0%

CHKM

11

-$297.97

-$27.25

-$117.03

11

100%

CLMT

6

-$47.52

-$0.39

-$22.80

6

100%

CMLP

12

-$440.72

-$32.60

-$224.67

12

100%

CPNO

21

-$529.48

$0.00

-$226.68

21

100%

CQP

5

-$69.96

$5.00

-$27.11

3

60%

CVR

1

$5.62

$5.62

$5.62

0

0%

DEP

6

$2.00

$45.86

$19.13

0

0%

DMLP

4

$0.00

$30.11

$7.53

3

75%

DPM

9

-$193.00

$301.00

-$9.64

5

56%

ECT

1

$3.92

$3.92

$3.92

0

0%

EEP

12

-$144.00

-$37.25

-$80.86

12

100%

ENP

8

-$28.38

$121.00

$48.89

1

13%

EP

3

-$201.00

-$109.40

-$167.80

3

100%

EPB

38

-$303.37

-$9.81

-$126.32

38

100%

EPD

80

-$747.00

$0.00

-$305.18

80

100%

EROC

9

-$50.00

$8.00

-$20.69

7

78%

ETE

41

-$600.00

$0.00

-$284.27

41

100%

ETP

49

-$775.12

$0.00

-$417.96

49

100%

EVEP

29

-$106.00

$80.00

-$21.70

21

72%

EXLP

2

-$765.00

-$35.23

-$400.12

2

100%

FGP

8

-$335.00

$0.00

-$79.31

8

100%

FUN

1

-$42.30

-$42.30

-$42.30

1

100%

GEL

22

-$281.55

$288.97

-$60.91

19

86%

GLE

1

-$73.91

-$73.91

-$73.91

1

100%

GLP

1

-$132.39

-$132.39

-$132.39

1

100%

GSJK

1

$0.00

$0.00

$0.00

1

100%

HEP

3

-$266.50

-$28.33

-$147.94

3

100%

KMP

17

-$1,432.00

-$7.71

-$589.55

17

100%

LGCY

27

-$14.00

$153.87

$28.67

6

22%

LINE

54

-$828.60

$28.24

-$322.41

52

96%

LRE

1

$0.00

$0.00

$0.00

1

100%

MCEP

1

-$6.09

-$6.09

-$6.09

1

100%

MMLP

6

-$378.64

-$1.89

-$144.34

6

100%

MMP

36

-$115.33

$177.00

$44.45

8

22%

MWE

61

-$503.00

$76.61

-$71.47

59

97%

NGLS

24

-$1,787.50

$0.00

-$300.77

24

100%

NHS

1

-$22.38

-$22.38

-$22.38

1

100%

NKA

2

-$52.40

$0.00

-$26.20

2

100%

NRGY

19

-$357.00

$0.00

-$139.04

19

100%

NRP

10

-$26.00

-$11.00

-$17.89

10

100%

NS

11

-$187.17

$193.70

-$25.53

8

73%

NSH

6

-$82.42

$28.93

-$24.67

5

83%

OKS

28

-$437.32

$0.00

-$210.94

28

100%

OXF

3

-$293.77

-$170.66

-$235.43

3

100%

PAA

31

-$124.00

$436.00

$84.03

11

35%

PER

2

$0.00

$0.00

$0.00

2

100%

PNG

7

-$220.00

$14.00

-$94.20

5

71%

PSE

7

$0.00

$512.00

$240.75

1

14%

PVG

4

$0.00

$112.11

$36.89

1

25%

PVR

7

$10.45

$162.38

$112.08

0

0%

QRE

4

-$93.00

-$16.00

-$62.53

4

100%

RGNC

4

-$437.82

-$3.75

-$215.05

4

100%

RGP

22

-$467.26

$0.00

-$269.89

22

100%

RNF

1

-$40.50

-$40.50

-$40.50

1

100%

RNO

2

-$0.35

$0.00

-$0.18

2

100%

SEP

7

-$249.33

-$9.80

-$109.89

7

100%

SDT

1

$0.00

$0.00

$0.00

1

100%

SPH

4

-$268.17

$242.50

$8.08

2

50%

STON

7

$33.20

$59.30

$41.91

0

0%

SXL

14

-$87.33

$11.33

-$25.80

11

79%

TCP

9

-$322.00

$0.00

-$145.34

9

100%

TGP

5

-$148.00

-$1.64

-$81.11

5

100%

THN

1

$764.47

$764.47

$764.47

0

0%

TLP

5

-$332.00

$7.00

-$89.46

4

80%

TNH

1

-$11.00

-$11.00

-$11.00

1

100%

UAN

8

-$3.00

$50.00

$14.98

1

13%

VNR

29

$0.00

$168.00

$48.16

1

3%

WES

23

-$285.30

-$1.78

-$71.72

23

100%

WPZ

24

-$993.68

$0.00

-$214.32

24

100%

XTEX

4

-$183.33

-$71.00

-$127.77

4

100%

Click to enlarge

 
Click to enlarge

e-mail to a friend printer-friendly add t
Click to enlarge