Ratios
Microsoft Corporation (MSFT.O) (Nasdaq)
Valuation Ratios
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| P/E Ratio (TTM) | 19.42 | 49.87 | 16.44 | 123.07 |
| P/E High - Last 5 Yrs. | 36.08 | 8.07 | 2.52 | 24.60 |
| P/E Low - Last 5 Yrs. | 8.65 | 1.96 | 0.46 | 5.65 |
| Beta | 0.95 | 0.77 | 1.13 | 1.38 |
| Price to Sales (TTM) | 4.72 | 1.38 | 1.05 | 2.02 |
| Price to Book (MRQ) | 6.47 | 3.93 | 1.89 | 2.50 |
| Price to Tangible Book (MRQ) | 9.85 | 18.03 | 2.93 | 6.24 |
| Price to Cash Flow (TTM) | 16.22 | 7.96 | 5.68 | 15.46 |
| Price to Free Cash Flow (TTM) | 18.50 | 58.15 | 26.40 | 21.45 |
| % Owned Institutions | -- | -- | -- | -- |
Dividends
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Dividend Yield | 1.74 | 0.23 | 0.04 | 1.51 |
| Dividend Yield - 5 Year Avg. | 3.96 | 2.04 | 1.24 | 2.76 |
| Dividend 5 Year Growth Rate | 26.58 | 12.76 | 12.69 | 9.49 |
| Payout Ratio(TTM) | 33.55 | 154.45 | 43.45 | 88.82 |
Growth Rates
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Sales (MRQ) vs Qtr. 1 Yr. Ago | -14.22 | -11.21 | -7.75 | -4.00 |
| Sales (TTM) vs TTM 1 Yr. Ago | -8.79 | -1.72 | -4.60 | -5.07 |
| Sales - 5 Yr. Growth Rate | 9.67 | 9.71 | 11.56 | 15.67 |
| EPS (MRQ) vs Qtr. 1 Yr. Ago | -16.45 | -25.71 | 132.42 | 75.46 |
| EPS (TTM) vs TTM 1 Yr. Ago | -18.66 | -- | -- | -- |
| EPS - 5 Yr. Growth Rate | 16.65 | 4.21 | 4.75 | 1.15 |
| Capital Spending - 5 Yr. Growth Rate | 22.98 | 31.38 | 17.75 | 19.60 |
Financial Strength
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Quick Ratio (MRQ) | 1.78 | 2.16 | 1.73 | 0.84 |
| Current Ratio (MRQ) | 1.82 | 2.35 | 2.04 | 0.99 |
| LT Debt to Equity (MRQ) | 9.09 | 13.75 | 18.07 | 130.42 |
| Total Debt to Equity (MRQ) | 14.55 | 18.88 | 28.94 | 201.14 |
| Interest Coverage (TTM) | -- | 4.03 | 0.38 | 26.27 |
Profitability Ratios
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Gross Margin (TTM) | 78.42 | 26.63 | 15.70 | 26.96 |
| Gross Margin - 5 Yr. Avg. | 81.06 | 55.98 | 35.61 | 26.64 |
| EBITD Margin (TTM) | 36.89 | -- | -- | -- |
| EBITD - 5 Yr. Avg | 38.98 | 25.50 | 23.50 | 15.38 |
| Operating Margin (TTM) | 32.23 | 6.85 | 1.56 | -- |
| Operating Margin - 5 Yr. Avg. | 36.03 | 21.39 | 13.14 | 20.09 |
| Pre-Tax Margin (TTM) | 33.03 | 6.55 | 1.39 | 7.74 |
| Pre-Tax Margin - 5 Yr. Avg. | 38.82 | 22.31 | 11.55 | 19.80 |
| Net Profit Margin (TTM) | 24.46 | 4.49 | -0.23 | 6.26 |
| Net Profit Margin - 5 Yr. Avg. | 28.01 | 14.07 | 8.42 | 14.04 |
| Effective Tax Rate (TTM) | 25.95 | 14.97 | 10.66 | -7.68 |
| Effecitve Tax Rate - 5 Yr. Avg. | 27.84 | 29.69 | 19.26 | 28.10 |
Management Effectiveness
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Return on Assets (TTM) | 18.77 | 3.45 | 1.77 | 3.65 |
| Return on Assets - 5 Yr. Avg. | 19.63 | 10.80 | 7.62 | 5.27 |
| Return on Investment (TTM) | 29.43 | 5.06 | 2.67 | 5.00 |
| Return on Investment - 5 Yr. Avg. | 28.63 | 15.85 | 10.97 | 6.77 |
| Return on Equity (TTM) | 36.82 | 6.42 | 2.86 | 8.73 |
| Return on Equity - 5 Yr. Avg. | 33.44 | 17.76 | 12.37 | 15.25 |
Efficiency
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Revenue/Employee (TTM) | 605,333 | 11,776,685 | 5,926,329 | 471,353 |
| Net Income/Employee (TTM) | 148,064 | 177,796 | -141,860 | 30,983 |
| Receivable Turnover (TTM) | 6.21 | 4.96 | 2.67 | 6.87 |
| Inventory Turnover (TTM) | 8.71 | 4.22 | 968.54 | 5.32 |
| Asset Turnover (TTM) | 0.77 | 0.40 | 0.42 | 0.45 |

