| Company Name: | Microsoft Corporation | | Ticker Symbol: | MSFT | | | WWW Address: | www.microsoft.com |
| CEO: | Steven A. Ballmer | | No. of Employees: | 94,000 |
| Common Issue Type: | CS | | Business Description: | Microsoft Corporation is engaged in developing, manufacturing, licensing and supporting a range of software products and services for different types of computing devices.
|
| | | Industry Information: | COMPUTER SOFWARE & SERVICES - Application Software [more like this] |
| | Price | Day Change | Bid | Ask | Open | High | Low | Volume | | 34.269 |  0.119 | 34.02 | 34.22 | 33.92 | 34.28 | 33.90 | 33175804 |
| Market Cap (mil) | Shares Outstanding (mil) | Beta | EPS | DPS | P/E | Yield | 52-Wks-Range |
| 286,184.1 | 8,351.1 | 0.96 | 2.00 | 0.76 | 17.5 | 2.7 | 35.27 - 26.26 |
| | KEY FIGURES (Latest Twelve Months - LTM) | | Yesterday's Close | 34.27 | $ | | PE Ratio - LTM | 17.5 | |
| Market Capitalisation | 286,184.1 | mil |
| Latest Shares Outstanding | 8,351.1 | mil |
| Earnings pS (EPS) | 2.00 | $ |
| Dividend pS (DPS) | 0.76 | ¢ |
| Dividend Yield | 2.7 | % |
| Dividend Payout Ratio | 38 | % |
| Revenue per Employee | 784,287 | $ |
| Effective Tax Rate | 23.8 | % |
| Float | 7,632.6 | mil |
| Float as % of Shares Outstanding | 90.5 | % |
| Foreign Sales | 34,877 | mil |
| Domestic Sales | 38,846 | mil |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 26.20 | % |
| Research & Devlopment (R&D) as % of Revenue | 13.40 | % |
| Gross Profit Margin | 79.9 | % |
| EBITDA Margin | 40.3 | % |
| Pre-Tax Profit Margin | 28.0 | % |
| Assets Turnover | 0.6 | % |
| Return on Assets (ROA) | 12.2 | % |
| Return on Equity (ROE) | 21.4 | % |
| Return on Capital Invested (ROCI) | 18.5 | % |
| Current Ratio | 2.9 | |
| Leverage Ratio (Assets/Equity) | 1.7 | |
| Interest Cover | 31.9 | |
| Total Debt/Equity (Gearing Ratio) | 0.19 | |
| LT Debt/Total Capital | 13.0 | % |
| Working Capital pS | 7.38 | $ |
| Cash pS | 0.63 | $ |
| Book-Value pS | 9.18 | $ |
| Tangible Book-Value pS | 7.04 | $ |
| Cash Flow pS | 2.39 | $ |
| Free Cash Flow pS | 2.18 | $ |
 |
| KEY FIGURES (LTM): Price info |
| Price/Book Ratio | 3.73 | |
| Price/Tangible Book Ratio | 4.87 | |
| Price/Cash Flow | 14.3 | |
| Price/Free Cash Flow | 15.7 | |
| P/E as % of Industry Group | 60.0 | % |
| P/E as % of Sector Segment | 79.0 | % |
| | | Balance Sheet (at a glance) in Millions |
| | | | | | DIVIDEND INFO | | Dividend Declared Date | 03/10/2013 |
| Dividend Ex-Date | 05/13/2013 |
| Dividend Record Date | 05/15/2013 |
| Dividend Pay Date | 06/12/2013 |
| Dividend Amount | 230 |
| Type of Payment | Cash Payment |
| Dividend Rate | 0.92 |
| Current Dividend Yield | 2.7 |
| 5-Y Average Dividend Yield | 2.2 |
| Payout Ratio | 38.0 |
| 5-Y Average Payout Ratio | 28.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 | - | - | - | -1.7 | 99 | 512,141 | 2,528,621 |
| 4 Weeks | 35.27 | 31.77 | 31.79 | 7.8 | 103 | 506,047 | 10,120,936 |
| 13 Weeks | 35.27 | 27.33 | 27.76 | 23.4 | 113 | 524,817 | 33,588,306 |
| 26 Weeks | 35.27 | 26.26 | 27.70 | 23.7 | 106 | 511,866 | 63,983,215 |
| 52 Weeks | 35.27 | 26.26 | 29.06 | 17.9 | 94 | 481,160 | 119,808,953 |
| YTD | 35.27 | 26.28 | - | 28.3 | 111 | 511,442 | 51,144,182 |
| Moving Average | 5-Days | 10-Days | 10-Weeks | 30-Weeks | 200-Days | Beta (60-Mnth) | Beta (36-Mnth) |
| 34.59 | 34.23 | 30.99 | 28.71 | 29.12 | 0.96 | 1.18 |
| | | | GROWTH RATES | 5-Year
Growh | R² of 5-Year Growth | 3-Year
Growth |
| Revenue | 5.51 | 88.8 | 6.84 |
| Income | 3.83 | 18.2 | -2.43 |
| Dividend | 14.19 | 96.1 | 17.05 |
| Capital Spending | 3.70 | NA | 41.85 |
| R&D | 4.58 | NA | 4.81 |
| Normalized Inc. | 10.54 | NA | 8.81 |
| | | CHANGES | YTD vs.
Last YTD | Curr Qtr vs.
Qtr 1-Yr ago | Annual vs.
Last Annual |
| Revenue % | 4.1 | 17.7 | 5.4 |
| Earnings % | -3.3 | 18.5 | -26.7 |
| EPS % | -2.9 | 20.0 | -25.7 |
| EPS $ | -0.06 | 0.12 | -0.69 |
| | | | SOLVENCY RATIOS | | SHORT-TERM SOLVENCY RATIOS (LIQUIDITY) |
| Net Working Capital Ratio | 43.21 |
| Current Ratio | 2.6 |
| Quick Ratio (Acid Test) | 2.4 |
| Liquidity Ratio (Cash) | 1.93 |
| Receivables Turnover | 4.8 |
| Average Collection Period | 75 |
| Working Capital/Equity | 79.0 |
| Working Capital pS | 6.25 |
| Cash-Flow pS | 2.38 |
| Free Cash-Flow pS | 1.53 |
| FINANCIAL STRUCTURE RATIOS |
| Altman's Z-Score Ratio | 5.13 |
| Financial Leverage Ratio (Assets/Equity) | 1.8 |
| Debt Ratio | 45.3 |
| Total Debt/Equity (Gearing Ratio) | 0.18 |
| LT Debt/Equity | 0.16 |
| LT Debt/Capital Invested | 28.8 |
| LT Debt/Total Liabilities | 19.5 |
| Interest Cover | 59.6 |
| Interest/Capital Invested | 0.43 |
| | | | VALUATION RATIOS | | MULTIPLES |
| PQ Ratio | 27.61 |
| Tobin's Q Ratio | 2.36 |
| Current P/E Ratio - LTM | 17.50 |
| Enterprise Value (EV)/EBITDA | 8.99 |
| Enterprise Value (EV)/Free Cash Flow | 23.15 |
| Dividend Yield | 2.7 |
| Price/Tangible Book Ratio - LTM | 4.87 |
| Price/Book Ratio - LTM | 3.73 |
| Price/Cash Flow Ratio | 14.3 |
| Price/Free Cash Flow Ratio - LTM | 15.7 |
| Price/Sales Ratio | 3.76 |
| P/E Ratio (1 month ago) - LTM | 16.2 |
| P/E Ratio (26 weeks ago) - LTM | 14.9 |
| P/E Ratio (52 weeks ago) - LTM | 10.6 |
| 5-Y High P/E Ratio | 20.1 |
| 5-Y Low P/E Ratio | 8.4 |
| 5-Y Average P/E Ratio | 13.1 |
| Current P/E Ratio as % of 5-Y Average P/E | 134 |
| P/E as % of Industry Group | 60.0 |
| P/E as % of Sector Segment | 79.0 |
| Current 12 Month Normalized P/E Ratio - LTM | 12.7 |
| PER SHARE FIGURES |
| LT Debt pS | 1.28 |
| Current Liabilities pS | 3.90 |
| Tangible Book Value pS - LTM | 7.04 |
| Book Value pS - LTM | 9.18 |
| Capital Invested pS | 9.23 |
| Cash pS - LTM | 0.63 |
| Cash Flow pS - LTM | 2.39 |
| Free Cash Flow pS - LTM | 2.18 |
| Earnings pS (EPS) | 2.00 |
| | | | OPERATING RATIOS | | PROFITABILITY RATIOS |
| Free Cash Flow Margin | 17.39 |
| Free Cash Flow Margin 5YEAR AVG | 20.28 |
| Net Profit Margin | 23.0 |
| Net Profit Margin - 5YEAR AVRG. | 28.0 |
| Equity Productivity | 1.11 |
| Return on Equity (ROE) | 25.6 |
| Return on Equity (ROE) - 5YEAR AVRG. | 37.1 |
| Capital Invested Productivity | 0.96 |
| Return on Capital Invested (ROCI) | 22.0 |
| Return on Capital Invested (ROCI) - 5YEAR AVRG. | 32.9 |
| Assets Productivity | 0.60 |
| Return on Assets (ROA) | 14.0 |
| Return on Assets (ROA) - 5YEAR AVRG. | 19.5 |
| Gross Profit Margin | 79.9 |
| Gross Profit Margin - 5YEAR AVRG. | 82.7 |
| EBITDA Margin - LTM | 40.3 |
| EBIT Margin - LTM | 28.9 |
| Pre-Tax Profit Margin | 30.2 |
| Pre-Tax Profit Margin - 5YEAR AVRG. | 36.6 |
| Effective Tax Rate | 23.8 |
| Effective Tax Rate - 5YEAR AVRG. | 23.7 |
| EFFICIENCY RATIOS |
| Cash Conversion Cycle | 108 |
| Revenue per Employee | 784,287 |
| Net Income per Employee | 180,617 |
| Average Collection Period | 77 |
| Receivables Turnover | 4.8 |
| Day's Inventory Turnover Ratio | 31 |
| Inventory Turnover | 11.6 |
| Inventory/Sales | 1.5 |
| Accounts Payble/Sales | 6.77 |
| Assets/Revenue | 1.67 |
| Net Working Capital Turnover | 1.41 |
| Fixed Assets Turnover | 2.04 |
| Total Assets Turnover | 0.6 |
| Revenue per $ Cash | 10.63 |
| Revenue per $ Plant | 8.92 |
| Revenue per $ Common Equity | 1.11 |
| Revenue per $ Capital Invested | 0.96 |
| Selling, General & Adm/tive (SG&A) as % of Revenue | 25.0 |
| SG&A Expense as % of Revenue - 5YEAR AVRG. | 27.4 |
| Research & Devlopment (R&D) as % of Revenue | 13.3 |
| R&D Expense as % of Revenue - 5YEAR AVRG. | 13.3 |
|
|  
| | |  |  | |
| |
