| Company Name: | Microsoft Corporation | | Ticker Symbol: | MSFT | | | WWW Address: | www.microsoft.com | | CEO: | Steven A. Ballmer | | No. of Employees: | 93,000 | | Common Issue Type: | CS | | Business Description: | The Company provides software, services and solutions that help people and businesses realize their full potential.
|
| | | Industry Information: | COMPUTER SOFWARE & SERVICES - Application Software [more like this] |
| | Price | Day Change | Bid | Ask | Open | High | Low | Volume | | 29.62 |  -0.16 | 24.0 | 29.85 | 29.66 | 29.77 | 29.43 | 42648018 |
| Market Cap (mil) | Shares Outstanding (mil) | Beta | EPS | DPS | P/E | Yield | 52-Wks-Range |
| 262,998.9 | 8,879.1 | 0.92 | 1.62 | 0.50 | 19.2 | 1.8 | 30.14 - 14.87 |
| | KEY FIGURES (Latest Twelve Months - LTM) | | Yesterday's Close | 29.62 | $ | | PE Ratio - LTM | 19.2 | |
| Market Capitalisation | 262,999.6 | mil |
| Latest Shares Outstanding | 8,879.1 | mil |
| Earnings pS (EPS) | 1.62 | $ |
| Dividend pS (DPS) | 0.50 | ¢ |
| Dividend Yield | 1.8 | % |
| Dividend Payout Ratio | 31 | % |
| Revenue per Employee | 628,355 | $ |
| Effective Tax Rate | 26.5 | % |
| Float | 7,749.4 | mil |
| Float as % of Shares Outstanding | 87.3 | % |
| Foreign Sales | 25,385 | mil |
| Domestic Sales | 33,052 | mil |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 29.30 | % |
| Research & Devlopment (R&D) as % of Revenue | 15.60 | % |
| Gross Profit Margin | 83.1 | % |
| EBITDA Margin | 38.1 | % |
| Pre-Tax Profit Margin | 33.0 | % |
| Assets Turnover | 0.8 | % |
| Return on Assets (ROA) | 16.9 | % |
| Return on Equity (ROE) | 33.4 | % |
| Return on Capital Invested (ROCI) | 30.6 | % |
| Current Ratio | 1.8 | |
| Leverage Ratio (Assets/Equity) | 2.0 | |
| Interest Cover | 0.0 | |
| Total Debt/Equity (Gearing Ratio) | 0.15 | |
| LT Debt/Total Capital | 8.0 | % |
| Working Capital pS | 2.64 | $ |
| Cash pS | 0.99 | $ |
| Book-Value pS | 4.64 | $ |
| Tangible Book-Value pS | 3.04 | $ |
| Cash Flow pS | 1.85 | $ |
| Free Cash Flow pS | 1.56 | $ |
 |
| KEY FIGURES (LTM): Price info |
| Price/Book Ratio | 6.38 | |
| Price/Tangible Book Ratio | 9.75 | |
| Price/Cash Flow | 16.0 | |
| Price/Free Cash Flow | 19.0 | |
| P/E as % of Industry Group | 66.0 | % |
| P/E as % of Sector Segment | 90.0 | % |
| | | Balance Sheet (at a glance) in Millions |
| | | | | | DIVIDEND INFO | | Dividend Declared Date | 09/20/2009 |
| Dividend Ex-Date | 11/16/2009 |
| Dividend Record Date | 11/18/2009 |
| Dividend Pay Date | 12/09/2009 |
| Dividend Amount | 130 |
| Type of Payment | Cash Payment |
| Dividend Rate | 0.52 |
| Current Dividend Yield | 1.8 |
| 5-Y Average Dividend Yield | 1.6 |
| Payout Ratio | 31.0 |
| 5-Y Average Payout Ratio | 83.0 |
|  | | Share price performance previous 3 years |
|
 | | | Share price performance intraday |
|
 | | | | | PRICE/VOLUME | High | Low | Close | % Price Chg | % Price Chg vs. Mkt. | Avg. Daily Vol | Total Vol |
| 1 Week | - | - | - | 0.0 | 100 | 533,776 | 2,602,072 |
| 4 Weeks | 30.14 | 27.41 | 28.02 | 5.7 | 105 | 594,671 | 11,893,429 |
| 13 Weeks | 30.14 | 23.76 | 24.41 | 21.3 | 114 | 561,978 | 35,966,596 |
| 26 Weeks | 30.14 | 19.45 | 19.75 | 50.0 | 122 | 577,492 | 73,341,538 |
| 52 Weeks | 30.14 | 14.87 | 19.68 | 50.5 | 110 | 643,942 | 161,629,475 |
| YTD | 30.14 | 14.87 | - | 52.4 | 126 | 637,448 | 143,425,716 |
| Moving Average | 5-Days | 10-Days | 10-Weeks | 30-Weeks | 200-Days | Beta (60-Mnth) | Beta (36-Mnth) |
| 29.81 | 29.52 | 26.98 | 24.17 | 22.52 | 0.92 | 0.96 |
| | | | GROWTH RATES | 5-Year
Growh | R² of 5-Year Growth | 3-Year
Growth |
| Revenue | 9.89 | 89.4 | 7.58 |
| Income | 14.93 | 78.2 | 8.10 |
| Dividend | -9.07 | 4.0 | 11.75 |
| Capital Spending | 49.22 | NA | 34.16 |
| R&D | 5.49 | NA | 10.03 |
| Normalized Inc. | 15.03 | NA | 7.88 |
| | | CHANGES | YTD vs.
Last YTD | Curr Qtr vs.
Qtr 1-Yr ago | Annual vs.
Last Annual |
| Revenue % | -14.2 | -14.2 | -3.3 |
| Earnings % | -18.3 | -18.3 | -17.6 |
| EPS % | -16.7 | -16.7 | -13.4 |
| EPS $ | -0.08 | -0.08 | -0.25 |
| | | | SOLVENCY RATIOS | | SHORT-TERM SOLVENCY RATIOS (LIQUIDITY) |
| Net Working Capital Ratio | 28.56 |
| Current Ratio | 1.8 |
| Quick Ratio (Acid Test) | 1.6 |
| Liquidity Ratio (Cash) | 1.16 |
| Receivables Turnover | 4.7 |
| Average Collection Period | 77 |
| Working Capital/Equity | 56.2 |
| Working Capital pS | 2.50 |
| Cash-Flow pS | 1.92 |
| Free Cash-Flow pS | 1.19 |
| FINANCIAL STRUCTURE RATIOS |
| Altman's Z-Score Ratio | 6.44 |
| Financial Leverage Ratio (Assets/Equity) | 2.0 |
| Debt Ratio | 49.2 |
| Total Debt/Equity (Gearing Ratio) | 0.15 |
| LT Debt/Equity | 0.09 |
| LT Debt/Capital Invested | 26.1 |
| LT Debt/Total Liabilities | 9.8 |
| Interest Cover | 0.0 |
| Interest/Capital Invested | 0.00 |
| | | | VALUATION RATIOS | | MULTIPLES |
| PQ Ratio | 16.02 |
| Tobin's Q Ratio | 3.38 |
| Current P/E Ratio - LTM | 19.20 |
| Enterprise Value (EV)/EBITDA | 11.77 |
| Enterprise Value (EV)/Free Cash Flow | 27.40 |
| Dividend Yield | 1.8 |
| Price/Tangible Book Ratio - LTM | 9.75 |
| Price/Book Ratio - LTM | 6.38 |
| Price/Cash Flow Ratio | 16.0 |
| Price/Free Cash Flow Ratio - LTM | 19.0 |
| Price/Sales Ratio | 4.67 |
| P/E Ratio (1 month ago) - LTM | 17.1 |
| P/E Ratio (26 weeks ago) - LTM | 11.4 |
| P/E Ratio (52 weeks ago) - LTM | 10.3 |
| 5-Y High P/E Ratio | 27.0 |
| 5-Y Low P/E Ratio | 9.2 |
| 5-Y Average P/E Ratio | 18.3 |
| Current P/E Ratio as % of 5-Y Average P/E | 105 |
| P/E as % of Industry Group | 66.0 |
| P/E as % of Sector Segment | 90.0 |
| Current 12 Month Normalized P/E Ratio - LTM | 19.2 |
| PER SHARE FIGURES |
| LT Debt pS | 0.42 |
| Current Liabilities pS | 3.03 |
| Tangible Book Value pS - LTM | 3.04 |
| Book Value pS - LTM | 4.64 |
| Capital Invested pS | 4.88 |
| Cash pS - LTM | 0.99 |
| Cash Flow pS - LTM | 1.85 |
| Free Cash Flow pS - LTM | 1.56 |
| Earnings pS (EPS) | 1.62 |
| | | | OPERATING RATIOS | | PROFITABILITY RATIOS |
| Free Cash Flow Margin | 18.11 |
| Free Cash Flow Margin 5YEAR AVG | 3.45 |
| Net Profit Margin | 24.9 |
| Net Profit Margin - 5YEAR AVRG. | 28.0 |
| Equity Productivity | 1.48 |
| Return on Equity (ROE) | 36.8 |
| Return on Equity (ROE) - 5YEAR AVRG. | 36.5 |
| Capital Invested Productivity | 1.35 |
| Return on Capital Invested (ROCI) | 33.6 |
| Return on Capital Invested (ROCI) - 5YEAR AVRG. | 35.8 |
| Assets Productivity | 0.80 |
| Return on Assets (ROA) | 18.7 |
| Return on Assets (ROA) - 5YEAR AVRG. | 20.1 |
| Gross Profit Margin | 83.1 |
| Gross Profit Margin - 5YEAR AVRG. | 84.1 |
| EBITDA Margin - LTM | 38.1 |
| EBIT Margin - LTM | 33.0 |
| Pre-Tax Profit Margin | 33.9 |
| Pre-Tax Profit Margin - 5YEAR AVRG. | 38.8 |
| Effective Tax Rate | 26.5 |
| Effective Tax Rate - 5YEAR AVRG. | 27.9 |
| EFFICIENCY RATIOS |
| Cash Conversion Cycle | 101 |
| Revenue per Employee | 628,355 |
| Net Income per Employee | 156,656 |
| Average Collection Period | 69 |
| Receivables Turnover | 4.7 |
| Day's Inventory Turnover Ratio | 32 |
| Inventory Turnover | 11.3 |
| Inventory/Sales | 1.2 |
| Accounts Payble/Sales | 8.57 |
| Assets/Revenue | 1.25 |
| Net Working Capital Turnover | 2.63 |
| Fixed Assets Turnover | 2.04 |
| Total Assets Turnover | 0.8 |
| Revenue per $ Cash | 9.62 |
| Revenue per $ Plant | 7.76 |
| Revenue per $ Common Equity | 1.48 |
| Revenue per $ Capital Invested | 1.35 |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 28.9 |
| SG&A Expense as % of Revenue - 5YEAR AVRG. | 30.0 |
| Research & Devlopment (R&D) as % of Revenue | 15.4 |
| R&D Expense as % of Revenue - 5YEAR AVRG. | 15.4 |
|
|  
| | |  |  | |
| |