Wednesday, February 16, 2011

Microsoft offers value with a margin of safety

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:
YearFCF $Millions
200112319
200213739
200314906
200413517
200515793
200612826
200715532
200818430
200915918
201022096
TTM23156
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
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
YearFCF $ Millions
023156
125240
227512
329988
432687
535628
Terminal Value317470
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.

Sources
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