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

Replacement Spreadsheet For Current Article

I submitted the 2012 year end spreadshet in my most recent article on MLPs - and not the 2013 year end spreadsheet. Until the editors make the correction - here is the data I should have placed in that article.

MLP Midstream 12-31-13
Yields are based on the Q4-13 distribution. Under the 'year to date' header, the change in the distribution is actually the change since Q4-12 - or the change over the last twelve months. The change in the target, EPS, DCF and CAGR is the percentage change in the consensus 2013 projection that has happened since the beginning of the year.


    Current Distrib/ Q4 Dist Dist/dcf Dist/dcf Year-to-Date Percent Change
    Price Quarter Yield 2013 2014 Price Pr+Dist EPS Target DCF Dist cagr

Access (NYSE:ACMP) 56.58 0.5350 3.78 75.09 66.46 68.69 75.07 -24.85 45.96 19.75 22.99 6.67
American (NYSE:AMID) 27.08 0.4525 6.68 124.83 87.44 98.53 111.80 -84.85 13.64 -30.29 4.62 50.00
Atlas Pipelines (NYSE:APL) 35.05 0.6200 7.08 99.60 84.07 11.02 18.88 -97.19 3.75 -19.16 8.77 -1.09
BlueKnight (NASDAQ:BKEP) 8.51 0.1225 5.76 61.25 47.57 29.33 36.78 32.26 14.29 -5.88 8.89 -5.56
Buckeye (NYSE:BPL) 71.01 1.0750 6.06 99.54 91.49 56.38 65.84 -2.73 28.07 -0.23 3.61 122.22
Boardwalk (NYSE:BWP) 25.52 0.5325 8.35 105.45 107.58 2.49 11.04 -19.05 1.58 -10.62 0.00 -28.57
Crestwood (NYSE:CMLP) 24.89 0.4050 6.51 97.01 87.57 15.61 23.13 -84.76 -4.24 -24.09 6.58 11.11
DCP Partners (NYSE:DPM) 50.35 0.7200 5.72 102.86 87.54 20.60 27.50 -16.36 12.45 -13.04 5.88 6.35
El Paso (NYSE:EPB) 36.00 0.6500 7.22 105.69 100.78 -2.62 4.41 -12.09 -1.47 -10.87 12.07 -71.43
Enbridge (NYSE:EEP) 29.87 0.5435 7.28 121.45 102.55 7.06 14.85 -41.54 -2.65 -19.37 0.00 -10.00
Enterprise (NYSE:EPD) 66.30 0.6900 4.16 71.32 66.51 32.39 37.90 4.46 18.58 3.48 6.15 11.67
Energy Trans (NYSE:ETP) 57.25 0.9050 6.32 90.73 77.19 33.36 41.79 19.39 21.06 1.79 1.26 33.33
EQT Mdstrm (NYSE:EQM) 58.79 0.4300 2.93 69.92 55.48 88.73 94.25 5.00 19.64 -1.60 22.86 na
Exterran (EXLP) 30.23 0.5275 6.98 78.73 80.84 49.14 59.55 62.82 18.60 3.88 3.94 -25.00
Genesis (NYSE:GEL) 52.57 0.5225 3.98 88.56 71.09 47.17 53.02 -21.05 48.90 -3.28 10.58 24.29
Holly (NYSE:HEP) 32.33 0.4925 6.09 94.26 89.95 -1.70 4.29 -35.33 -2.03 -5.00 6.49 15.38
Kinder Morgan (NYSE:KMP) 80.66 1.3500 6.69 100.37 94.24 1.09 7.86 -3.19 0.36 -4.78 7.14 4.44
Magellan (NYSE:MMP) 63.27 0.5575 3.52 80.51 72.64 46.49 51.66 13.57 35.41 12.15 14.95 3.53
Mark West (NYSE:MWE) 66.13 0.8500 5.14 94.71 78.34 29.64 36.31 -63.43 29.29 -16.51 4.94 -2.25
Targa (NYSE:NGLS) 52.30 0.7325 5.60 101.38 83.48 39.91 47.75 -32.33 18.86 -15.50 10.57 -13.75
NuStar (NYSE:NS) 50.99 1.0950 8.59 131.53 114.96 20.03 30.34 -49.77 -1.98 -18.78 0.00 -25.00
OneOK (NYSE:OKS) 52.65 0.7250 5.51 98.64 86.83 -2.48 2.89 -15.02 -9.44 -8.98 5.84 -18.29
Oil Tanking (NYSE:OILT) 62.07 0.4450 2.87 66.92 63.12 63.95 68.65 27.32 26.00 23.15 18.67 na
Plains All-Am (NYSE:PAA) 51.77 0.6000 4.64 73.62 76.68 14.43 19.74 13.33 21.08 9.03 10.60 41.67
Regency (NYSE:RGP) 26.26 0.4700 7.16 100.53 90.82 21.13 29.80 -31.82 11.57 -7.43 2.17 -16.67
Spectra (NYSE:SEP) 45.35 0.5163 4.55 99.29 80.05 45.21 51.83 1.20 37.68 -2.35 5.37 61.90
Sunco (NYSE:SXL) 75.48 0.6300 3.34 56.76 54.66 51.78 56.85 -0.88 33.40 30.97 21.74 30.88
TCPipelines (NYSE:TCP) 48.43 0.8100 6.69 92.84 87.57 20.00 28.02 -15.04 7.88 -3.59 3.85 -11.76
Tesoro (NYSE:TLLP) 52.34 0.5450 4.17 88.62 71.01 19.50 24.47 -26.05 23.27 -12.14 19.78 0.00
Transmontaigne (NYSE:TLP) 42.50 0.6500 6.12 83.87 74.29 11.93 18.78 -30.15 20.37 -12.68 1.56 3.45
Western (NYSE:WES) 61.69 0.5800 3.76 92.43 76.07 29.52 34.39 -6.08 28.96 -13.45 16.00 3.33
Williams (NYSE:WPZ) 50.86 0.8775 6.90 108.00 98.32 4.52 11.73 -32.66 -7.38 -14.92 8.67 -16.92
Cross-Tex (XTEX) 27.60 0.3300 4.78 95.65 84.08 89.69 98.76 0.00 68.24 -36.41 0.00 41.67

Pipeline Average     5.60 92.48 81.55 32.20 39.39 -17.18 17.57 12.58 8.38  
Shipping
Navios (NYSE:NMM) 19.12 0.4425 9.26 98.88 101.14 55.70 70.11 -10.53 17.63 8.48 0.00 0.00
Martin (NASDAQ:MMLP) 42.80 0.7825 7.31 98.12 89.94 37.80 47.88 -25.00 33.51 -6.73 1.62 6.45
TeeKay (NYSE:TGP) 42.71 0.6750 6.32 94.41 91.53 13.05 20.20 -1.35 6.70 -7.14 0.00 -60.00

Shipping Average     7.63 93.52   35.52 46.06 -12.29 19.28    

MidStream Average   5.77 92.87 82.61 32.47 39.95 -16.77 17.71    

Click to enlarge