I'm not writing this article to argue whether the PC is dead or not. I'm writing this article to argue why you should consider investing in Microsoft (MSFT). Microsoft has consistently been able to adapt to consumers' needs, as well as revolutionize products. No matter how they decide to move forward, I am confident that the company will continue to produce healthy returns and margins. Since the beginning of the year, the company has been trading in the $28-$32 range. I think that the stock is due for a breakout, and that there is a great opportunity here.
The table below shows how profitable Microsoft has been during the past ten years.
When you shift focus to EPS growth, Microsoft has seen healthy growth. Earnings per share have increased on average of 12.4% over the past five years. When looking forward to the next five years, analysts have a projected growth rate of 10.3%. This shows a promising future for the company. Even though the growth rate is predicted to decline by a small margin, which is to be expected as a company progresses, it shows that analysts are still confident in the ability of Microsoft to generate revenue moving forward.
When valuing Microsoft, I used a discounted free-cash-flow model. The table below has the FCF in millions from the past ten years.
The following two tables show the average growth rate that Microsoft has seen over the past ten years. Since just taking the average from 2002 to 2011 could be a bit misleading, I used five and ten year multi-year growth performances. I've found that this gives a more accurate growth rate.
5 Year Multi-Year Growth:
10 Year Multi-Year Growth:
The average of the two tables gives an average growth rate of 10.85%, a pretty solid number from a cash cow like Microsoft. For a conservative valuation, I cut the average growth rate in half, making it 5.43%.
For the discount rate, I used the CAPM. With an expected rate of 10.5%, risk free rate of 1.68%, and a beta of 1.17, the discount rate came out to be 12.0%. I use an expected rate of 10.5% in order to get a fairly conservative discount rate.
The intrinsic value for Microsoft based off the calculations above is $43.97. With Microsoft closing at 29.07 at the writing of this article, it is obvious that there is significant upside. When including a margin of safety of 25%-50%, we have a target buy window between $21.98 and $32.98. Since the current price falls within this window, I'll turn to price multiple valuations to either confirm or deny the buy.
|Current||10 Yr Avg|
When the current multiples of Microsoft are compared to the ten year averages of the company, it confirms that the company could be perceived as undervalued.
Many investors have been hesitant to invest in Microsoft just because they have always viewed the company as overvalued. However, I believe that based on the above research, Microsoft is now undervalued. It seems that Microsoft is selling at a significant discount when compared to its intrinsic value of $43.97. With ten years of healthy growth and profitable numbers and a promising future, I recommend a buy for Microsoft.