I believe Microsoft ($MSFT), at approximately $27/share offers value with a margin of safety on a cash flow valuation basis. Assuming all else at $MSFT meets my standard for good business, I'd buy it today for the long term at $26.
Microsoft develops the Windows operating system and the Office suite of productivity software. Windows and Office account for roughly 56% of Microsoft's revenue, with another 24% coming from software for enterprise servers. The firm's other businesses include the Xbox 360 video game console, Bing Internet search, business software, and software for mobile devices.
I estimated the firm's WACC at 12.23% using the Capital Asset Pricing Model and the company's recent SEC filings.
Recent free cash flows and noted growth rates:
| Year | FCF $Millions |
| 2001 | 12319 |
| 2002 | 13739 |
| 2003 | 14906 |
| 2004 | 13517 |
| 2005 | 15793 |
| 2006 | 12826 |
| 2007 | 15532 |
| 2008 | 18430 |
| 2009 | 15918 |
| 2010 | 22096 |
| TTM | 23156 |
Average Annual Growth: approx. 8%
CAGR: approx. 7%
Consensus Forecast Industry 5-Year Growth: approx. 18% per year
Consensus Forecast Company 5-Year Growth: approx. 10% per year
CAGR: approx. 7%
Consensus Forecast Industry 5-Year Growth: approx. 18% per year
Consensus Forecast Company 5-Year Growth: approx. 10% per year
Assuming the company achieves a 5-year growth rate in FCF of 9% per year, and assuming that after the next five years, the company achieves no growth in FCF or 0% growth per year forever:
Discounted Cash Flow Valuation
| Year | FCF $ Millions |
| 0 | 23156 |
| 1 | 25240 |
| 2 | 27512 |
| 3 | 29988 |
| 4 | 32687 |
| 5 | 35628 |
| Terminal Value | 317470 |
The firm's future cash flows, discounted at a WACC of 12.23%, give a present value for the entire firm (Debt + Equity) of $284,434 million. If the firm's fair value of debt is estimated at $12,000 million, then the fair value of the firm's equity could be $272,434 million. $272,434 million / 8400 million outstanding shares is approximately $32 per share and a 20% margin of safety is $26. Assuming all else at $MSFT meets my standard for good business, I'd buy it today for the long term at $26.
Morningstar.com
Disclosure: I have no positions in any stocks mentioned, and no plans to initiate any positions within the next 72 hours.
No comments:
Post a Comment