Microsoft Corp.

November 21, 2010

Stock of the week: Microsoft Corp. (MSFT)

Fundamental Analysis

Analysts expect Microsoft’s earnings to grow by about 9% or 10% on average over the next five years. The discount rate, calculated using Microsoft’s beta of 1.07, a risk free rate of 4% and a market return of 9%, comes down to 9.4%. For my DCF analysis I let the growth rate converge to 2.5% annually over about 15 years, whereafter it stays constant. This gives Microsoft's stock a value $48 per share. At the time of writing MSFT has closed at $25.69 per share.

MSFT’s dividend, currently at 64 cents per share, gives a yield of 2.49%. Historically, MSFT’s dividends grew 12% annually on average. Using a long-term dividend growth rate of 5%, and the 9.4% discount rate as above, Gordon’s model gives MSFT a per share value of about $15. This is solely due to the fact that MSFT pays a very low dividend.

Microsoft’s P/E ratio is 11.03, which seems low, and it is. The Industry and S&P 500 P/Es are 23.71 and 15.72 respectively. MSFT's PEG ratio is 1.06, which is also low. This points to undervaluation.

Technical Analysis

MSFT’s price has just dipped below the 50-day exponential moving average, announcing bearish sentiment. MACD also generated a sell signal several days earlier. Yet the price is still above the lower Bollinger band. If price drops below $25 (going under the lower Bollinger band) a further drop is likely. 


Conclusion: The stock seems to be undervalued yet it appears it will continue to drop. 

This chart was obtained from Sharpcharts.com.
 
 

Coca Cola Company

October 31, 2010

Stock of the week: Coca Cola Company (KO)

Fundamental Analysis

Coca Cola’s Free Cash Flow per share is currently $1.82. Analysts expect growth of 9.7% in the coming year, and an average growth rate of 8.7% over the next 5 years. Using the CAPM I estimate KO’s discount rate to be 7%. (9% market return, 4% risk-free rate, beta of 0.6). My Discount Cash Flow analysis gives KO an intrinsic value of $69.50. At the time of writing KO’s stock is trading at $61.32.

KO’s dividend, current...


Continue reading...
 

Apple Inc.

October 20, 2010

Stock of the Week: Apple Inc.

Apple (AAPL) once again surprised investors Monday releasing its Q4 earnings of $4.64 per share, 14% higher than expected. That same day the stock price reached an all time high of $319, 65% higher than a year previously. Is Apple going to slow down soon? When is all this incredible growth going to end?


Fundamental Analysis

After this quarter Apple’s annual Free Cash Flow came out at $16.5 billion. Using the Capital Asset Pricing Model I estimate the dis...


Continue reading...
 



You are responsible for your own investment decisions. The Intelligent Investor strives for accuracy, but will not be responsible for any errors or omissions in articles or postings. Nor will The Intelligent Investor be liable for any loss or damage caused by a reader's reliance on information obtained on this site, or in a hyperlinked area. If you don't accept this responsibility for yourself, then you should not use The Intelligent Investor.

This free website was made using Yola.

No HTML skills required. Build your website in minutes.

Go to www.yola.com and sign up today!

Make a free website with Yola