Seeking Alpha

Factoids'  Instablog

Factoids
Send Message
I seek to liberate investors from the chains of borrowed opinions by teaching metric awareness that leads to the formation of your own opinions. I lack the usual attributes that qualifies me to write on investing. I am a retail investor. But I do gather, process and analyze significantly more... More
My blog:
Factoids' Instablog
  • Replacement Spreadsheet For Current Article 0 comments
    Jan 27, 2014 5:47 PM

    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.


      CurrentDistrib/Q4 DistDist/dcfDist/dcfYear-to-Date Percent Change
      PriceQuarterYield20132014PricePr+DistEPSTargetDCFDistcagr

    Access(ACMP)56.580.53503.7875.0966.4668.6975.07-24.8545.9619.7522.996.67
    American(AMID)27.080.45256.68124.8387.4498.53111.80-84.8513.64-30.294.6250.00
    Atlas Pipelines(APL)35.050.62007.0899.6084.0711.0218.88-97.193.75-19.168.77-1.09
    BlueKnight(BKEP)8.510.12255.7661.2547.5729.3336.7832.2614.29-5.888.89-5.56
    Buckeye(BPL)71.011.07506.0699.5491.4956.3865.84-2.7328.07-0.233.61122.22
    Boardwalk(BWP)25.520.53258.35105.45107.582.4911.04-19.051.58-10.620.00-28.57
    Crestwood(CMLP)24.890.40506.5197.0187.5715.6123.13-84.76-4.24-24.096.5811.11
    DCP Partners(DPM)50.350.72005.72102.8687.5420.6027.50-16.3612.45-13.045.886.35
    El Paso(EPB)36.000.65007.22105.69100.78-2.624.41-12.09-1.47-10.8712.07-71.43
    Enbridge(EEP)29.870.54357.28121.45102.557.0614.85-41.54-2.65-19.370.00-10.00
    Enterprise(EPD)66.300.69004.1671.3266.5132.3937.904.4618.583.486.1511.67
    Energy Trans(ETP)57.250.90506.3290.7377.1933.3641.7919.3921.061.791.2633.33
    EQT Mdstrm(EQM)58.790.43002.9369.9255.4888.7394.255.0019.64-1.6022.86na
    Exterran(EXLP)30.230.52756.9878.7380.8449.1459.5562.8218.603.883.94-25.00
    Genesis(GEL)52.570.52253.9888.5671.0947.1753.02-21.0548.90-3.2810.5824.29
    Holly(HEP)32.330.49256.0994.2689.95-1.704.29-35.33-2.03-5.006.4915.38
    Kinder Morgan(KMP)80.661.35006.69100.3794.241.097.86-3.190.36-4.787.144.44
    Magellan(MMP)63.270.55753.5280.5172.6446.4951.6613.5735.4112.1514.953.53
    Mark West(MWE)66.130.85005.1494.7178.3429.6436.31-63.4329.29-16.514.94-2.25
    Targa(NGLS)52.300.73255.60101.3883.4839.9147.75-32.3318.86-15.5010.57-13.75
    NuStar(NS)50.991.09508.59131.53114.9620.0330.34-49.77-1.98-18.780.00-25.00
    OneOK(OKS)52.650.72505.5198.6486.83-2.482.89-15.02-9.44-8.985.84-18.29
    Oil Tanking(OILT)62.070.44502.8766.9263.1263.9568.6527.3226.0023.1518.67na
    Plains All-Am(PAA)51.770.60004.6473.6276.6814.4319.7413.3321.089.0310.6041.67
    Regency(RGP)26.260.47007.16100.5390.8221.1329.80-31.8211.57-7.432.17-16.67
    Spectra(SEP)45.350.51634.5599.2980.0545.2151.831.2037.68-2.355.3761.90
    Sunco(SXL)75.480.63003.3456.7654.6651.7856.85-0.8833.4030.9721.7430.88
    TCPipelines(TCP)48.430.81006.6992.8487.5720.0028.02-15.047.88-3.593.85-11.76
    Tesoro(TLLP)52.340.54504.1788.6271.0119.5024.47-26.0523.27-12.1419.780.00
    Transmontaigne(TLP)42.500.65006.1283.8774.2911.9318.78-30.1520.37-12.681.563.45
    Western(WES)61.690.58003.7692.4376.0729.5234.39-6.0828.96-13.4516.003.33
    Williams(WPZ)50.860.87756.90108.0098.324.5211.73-32.66-7.38-14.928.67-16.92
    Cross-Tex(XTEX)27.600.33004.7895.6584.0889.6998.760.0068.24-36.410.0041.67

    Pipeline Average  5.6092.4881.5532.2039.39-17.1817.5712.588.38 
    Shipping
    Navios(NMM)19.120.44259.2698.88101.1455.7070.11-10.5317.638.480.000.00
    Martin(MMLP)42.800.78257.3198.1289.9437.8047.88-25.0033.51-6.731.626.45
    TeeKay(TGP)42.710.67506.3294.4191.5313.0520.20-1.356.70-7.140.00-60.00

    Shipping Average  7.6393.52 35.5246.06-12.2919.28  

    MidStream Average 5.7792.8782.6132.4739.95-16.7717.71  

Back To Factoids' Instablog HomePage »

Instablogs are blogs which are instantly set up and networked within the Seeking Alpha community. Instablog posts are not selected, edited or screened by Seeking Alpha editors, in contrast to contributors' articles.

Comments (0)
Track new comments
Be the first to comment
Full index of posts »
Latest Followers

StockTalks

More »

Latest Comments


Posts by Themes
Instablogs are Seeking Alpha's free blogging platform customized for finance, with instant set up and exposure to millions of readers interested in the financial markets. Publish your own instablog in minutes.