morningstar search engine
morningstar search engine

First, I use MorningStar program to filter my criteria; which are price/fair value <= 0.8, forward dividend yield >= 3, earning yield >= 5, price/book <= 5, price/sales >= 5, morning star rate overall >= 3, P/cash flow<= 15, cash return > 0, and cash flow >0). The reason I use these criteria is to evaluate the value stocks (underperformed). According to the Journal of Portfolio Management of Denis B Chaves and Robert D Arnott and the new finance book of Robert A Haugen, growth stocks sell at above-average prices relative to current cash flows, earning, dividends, and book values; and value stocks sell at below average prices relative to these numbers. Generally, the value stocks have greater returns than growth stocks in the long term investment. As a result, I have a list of 21 stocks (PPoint, slide 3).

valueline
Valueline.com
BHP Billiton Limited NYSE -BHP
Weighted Average Cost of Capital
Value Line Beta 1.40 Long Term Debt 18.713
Yahoo Beta 1.78 Long Term Interest 900
Average Beta 1.59 Cost of Debt 4.81%
Adjusted Beta 1.39 Income Tax Rate(2017) 34.00%
20-Year Treasury Bond Yield 3.38% After-Tax Cost of Debt 3.17%
Expected Market Return 9.00% Proportion of Equity 90.69%
Cost of Equity 11.21% Proportion of Debt 9.31%
Share Outstanding 2.660 Weighted Average Cost of Capital 10.46%
Stock Price $68.49 Infinite FCFTF Growth 4.19%
Market Value of Equity 182.183 Average Annual P/E Ratio(2017) 12.00
Current and Projected Amounts 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17
Working Capital $7.500 $9.000 $11.775 $14.550 $17.325 $20.100
Capital Spending per Share $5.20 $5 $6 $6 $6
Common Shares Outstanding 2.600 2.575 2.550 2.525 2.500
Long-Term Debt 19.000 20.000 20.500 21.000 21.500 22.000
Interst Payment 962 986 1.010 1.034 1.058
Free Cash Flows (Millions of Dollars)
12/31/13 12/31/14 12/31/15 12/31/16 12/31/17
Net Profit 23.000 24.450 25.900 27.350 28.800
-Depreciation 6.600 7.000 7.400 7.800 8.200
Net Profit 23.000 24.450 25.900 27.350 28.800
-Increase in Woring Capital (1.500) (2.775) (2.775) (2.775) (2.775)
Capital Spending (13.520) (13.905) (14.280) (14.645) (15.000)
-New Borrowing 1000 500 500 500 500
-After-tax interest Payment 635 651 667 682 698
Stock Valuation 9/11/2012 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17
Fractional Years from Current Date 1.31 2.31 3.31 4.31 5.31
Free Cash Flows to Equity(FCFTE) 15.580 15.270 16.745 18.230 19.725
Terminal Value of FCFTE 345.600
Total FCFTE 15.580 15.270 16.745 18.230 365.325
Present Values of Total FCFTE 13.562 11.952 11.785 11.536 206.746
Market Value of Equity (FCFTE Method) 256.713
Stock Value(FCFTE) $96.51
Free Cash Flows to Firm(FCFTF) 15.215 15.421 16.912 18.412 19.923
Terminal Value of FCFTF 330.621
Total FCFTF 15.215 15.421 16.912 18.412 350.544
Present Values of Total FCFTF 13.361 12.259 12.171 11.996 206.746
Enterprise Value 256.533
Total Cash 5.060
Market Value of Firm 261.593
Total Debt 28.330
Market Value of Equity(FCFTF Method) 233.263 Thompson/Firt Call Price Target
Stock Value (FCFTF Method) $87.69 High $96.00
Mean $59.11
Estimated Stock Value $92.10 Median $51.61
12-Month Target Price $102.43 Low $42.04
Projected Return 49.55% No of Brokers 6

Next, I use the Valueline.com (PP, slides 5) to check the fundamental analysis and to support the excel analysis. Cash flow per ADR from 2009 to 2012 rises sharply after the financial collapse of 2008; and the stock is priced at 11x of cash flow. The dividend yield of 3.7% is also a favor factor for investors who look for income. Sales, EPS, Net Profits, average annual dividend, and working capital have a stable uptrend. The decrease in equivalent share outstanding is a good side of increasing the stock price. Moreover, the technical and safety valuation from Valueline are 2 and 3 [over the scale of 1 (best) � 5 (worst)], meaning that BPH is not a risky stock. Valueline shows that BHP�s financial strength is A; stock�s price stability is 50 (scale of 0-100), and growth persistence is 95 (scale of 0-100). So far, 2015-2017 BHP stock projection show that the predicted high price is 165 (gain 150% with 28% of annual total return and the predicted low price is 110 (gain 70% with 17% of annual total return).

Option Chains
Option Chains

Third, I use the options chain to predict the stock price by identifying the resistance and support of option traders. Generally, in January 2013, option chains support at the price of $70 and resist at $77.5 (some resist at $85). In short, option traders favor the stock at the high price comparing to the current price. BHP chart

BHP Billiton Limited (BHP)
Copper chart
Copper Chart
Finally, I use technical analysis to define the stock cycle, weekly pattern, risk, rate of change, volume, and stock trend. There is five years cycle in which the current year (4th) is consolidation pattern (PP, slide 9). There is limited risk because BHP BILLITON is strong uptrend till 2004. Rate of change of 10.2 years is 603% comparing to ROC of current 4 years is 52%. Also, the volume of trading BHP is very high. It means that investors still pay attention to this stock. Although average true range is high but the Bollinger band width is low (less risky). As a result, BHP is a good stock in the next 5 years. Further, BHP is diversified natural resources, especially in copper and iron; therefore, copper price is very much affecting the BHP stock price. Copper price is increasing sharply with very high ROC of 10 years; and the housing market will recovery in the future (according to the Barron�s newspaper, the housing market is up 7% since 2010).

Barron News
Barron News

In conclusion, BHP BILLION LIMITED is a great company to invest in the long term because the value of company which is less risk and high return. My prediction is if the stock price breaks at $75(current price quoted at $72.88 in September 14th, 2012); then, the stock will be bullish in the next 5 years.