Week 369 - High-quality Producers & Transporters of Industrial Commodities in the 2017 Barron's 500 List
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAE
1
Companies Ranked by Finance Value (Column E)TickerReward = Total Return/Yr since market peak on 7/19/2007Risk Aversion = Total Return/Yr during Commodities Bear Market (4/14-4/16)Finance Value = Col C + Col D5-Yr Total Return/YrDiv Yield5-Yr Div Growth5-Yr BetaP/EBMW Method 16-Yr CAGR (Px only)Recent Px TrendBMW Method Est. Loss @ -2SD2017 Barron's 500 Rank2016 Barron's 500 RankLT Debt: Total AssetsOperating Cash Flow RatioTBV:PxDiv:FCFS&P Bond RatingS&P Stock Rating (Stars)Px (50d avg)Shares BOTAmountNet Present Value at 10-Yr Holding Period with 9% Discount RateMarket Cap ($B)Div Achiever25-Yr Total Return/YrGraham Number Over/Under ValueDurable Competitive AdvantageYears TBV down
2
Canadian National RailwayCNI11.9%6.9%18.8%12.4%1.6%1.5%0.911717.3%on trendline35%29919224%25%21%63%AA+/M (4)$83.2060$4,992.00$5,537.95$6718.2%NA7.8%3
3
Berkshire HathawayBRK-B8.9%6.6%15.5%10.6%0.0%0.0%0.83129.7%up 1SD24%27418711%127%50%no dividendAAB+/L (3)$192.5126$5,005.26$69.47$49112.1%NA12.6%2
4
Union PacificUNP15.6%-6.1%9.5%13.1%2.0%0.5%0.851120.9%on trendline29%44036727%184%22%53%A-A/M (3)$143.1835$5,011.30$9,249.64$10812.8%35.4%8.3%0
5
DeereDE8.1%-5.6%2.5%11.2%1.9%5.1%0.972513.5%on trendline36%46342938%10%12%74%AB+/M (4)$146.6934$4,987.46$2,845.88$4613.1%125.6%8.3%4
6
Archer Daniels MidlandADM3.2%-6.3%-3.1%5.3%2.9%12.4%0.81168.4%on trendline38%44635216%18%57%no FCFAB+/M (4)$45.89109$5,002.01$852.56$26yes6.2%-4.8%2.8%3
7
CaterpillarCAT5.4%-9.4%-4.0%11.1%2.5%8.2%1.533811.5%on trendline43%47745230%21%8%43%AB+/M (5)$146.0934$4,967.06$1,919.29$84yes14.1%470.1%5.6%4
8
Exxon MobilXOM-0.2%-4.5%-4.7%-2.3%4.0%6.0%0.81185.5%down 1SD31%4844816%52%56%92%AA+B+/L (3)$81.7461$4,986.14-$125.47$354yes9.7%8.5%7.7%2
9
Imperial OilIMO-3.1%-14.8%-17.9%-5.0%1.7%4.3%0.69551.4%down 1SD59%48548612%67%69%25%AA+A+/M (5)$32.81152$4,987.12-$2,151.28$2811.4%NANANA
10
Averagen = 86.2%-4.2%2.1%7.1%2.1%4.8%0.932411.0%on trendline37%42136821%63%37%58%A+A-/L (4)$109.01$4,992.29$2,274.76$15112.2%127.0%7.6%3
11
12
BENCHMARKS
13
SPDR S&P 500 ETFSPY7.5%6.6%14.1%13.2%1.8%8.1%1176.7%up 1SD30%NA$275.7218$4,962.96-$458.07$2599.5%NANA
14
SPDR Dow Jones Ind Avg ETFDIA7.6%4.7%12.3%12.2%2.1%8.0%1.03166.4%up 1SD26%NA$248.1420$4,962.80-$478.80$21NANANA
15
SPDR S&P MidCap 400 ETFMDY8.4%2.8%11.2%12.1%1.3%13.4%0.98179.1%on trendline27%NA$359.8614$5,038.04$428.28$21NANANA
16
ChevronCVX3.5%-6.7%-3.2%-0.2%3.6%3.5%1.13239.8%on trendline32%49248212%74%62%96%AA-B/M (4)$125.0540$5,002.00$1,330.33$23911.1%23.9%7.0%2
17
Occidental PetroleumOXY3.7%-10.1%-6.4%-1.1%3.6%5.5%0.58348.7%on trendline53%49449924%68%33%148%AB-/M (3)$84.0559$4,958.95$937.25$65yes12.7%104.7%negative
18
Suncor EnergySU-0.9%-8.1%-9.0%5.2%2.6%15.2%0.93235.5%up 1SD56%48748415%94%49%88%A-B-/H (5)$40.45124$5,015.80-$223.29$6716.5%NA5.6%2
19
Schlumberger LimitedSLB-3.3%-11.3%-14.6%-4.2%3.0%6.6%1.02neg earnings5.4%down 1SD47%48143219%37%3%82%AA-NR/M (3)$68.2573$4,982.25-$532.87$917.7%negative earningsnegative
20
HalliburtonHAL0.9%-21.4%-20.5%-2.5%1.6%10.9%1.26neg earnings7.3%on trendline48%50046041%51%14%23%A-B-/H (4)$47.06106$4,988.36-$284.25$358.3%negative earningsnegative
21
ConocoPhillipsCOP-1.1%-21.1%-22.2%1.6%1.6%-16.0%1.32neg earnings8.1%on trendline47%48948524%75%40%52%A-B-/M (4)$69.0072$4,968.00-$338.69$8411.1%negative earningsnegative
22
BHP Billiton LimitedBHP-2.1%-35.9%-38.0%-4.2%4.4%-0.7%1.15295.4%down 1SD64%23%148%41%30%ANR/H (3)$49.78100$4,978.00-$350.13$14011.5%NA4.4%2
23
Averagen = 102.4%-10.1%-7.6%3.2%2.6%5.5%1.04237.2%on trendline43%49147423%78%35%74%AB-/M (4)$136.74$4,985.72$2.98$10211.1%64.3%5.7%2
24
25
Consumer Price Indexcpi1.9%1.8%2.7%
26
27
Updated 6/30/2018
Loading...
 
 
 
Sheet1
 
 
Main menu