Ratios
Microsoft Corporation (MSFT.O) (Nasdaq)
Valuation Ratios
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| P/E Ratio (TTM) | 18.96 | 47.50 | 15.83 | 116.00 |
| P/E High - Last 5 Yrs. | 36.08 | 8.18 | 2.62 | 24.43 |
| P/E Low - Last 5 Yrs. | 8.65 | 1.99 | 0.47 | 5.62 |
| Beta | 0.95 | 0.77 | 1.14 | 1.36 |
| Price to Sales (TTM) | 4.61 | 1.39 | 1.02 | 2.01 |
| Price to Book (MRQ) | 6.31 | 3.83 | 1.86 | 2.51 |
| Price to Tangible Book (MRQ) | 9.62 | 17.80 | 3.02 | 6.74 |
| Price to Cash Flow (TTM) | 15.83 | 7.93 | 5.55 | 15.14 |
| Price to Free Cash Flow (TTM) | 18.05 | 55.03 | 25.48 | 21.67 |
| % Owned Institutions | -- | -- | -- | -- |
Dividends
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Dividend Yield | 1.78 | 0.24 | 0.04 | 1.53 |
| Dividend Yield - 5 Year Avg. | 3.96 | 2.03 | 1.24 | 2.74 |
| Dividend 5 Year Growth Rate | 26.58 | 12.83 | 12.61 | 9.52 |
| Payout Ratio(TTM) | 33.55 | 154.56 | 43.10 | 87.51 |
Growth Rates
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Sales (MRQ) vs Qtr. 1 Yr. Ago | -14.22 | -11.14 | -7.53 | -4.11 |
| Sales (TTM) vs TTM 1 Yr. Ago | -8.79 | -1.69 | -4.50 | -5.14 |
| Sales - 5 Yr. Growth Rate | 9.67 | 9.75 | 11.75 | 15.60 |
| EPS (MRQ) vs Qtr. 1 Yr. Ago | -16.45 | -26.08 | 134.88 | 74.27 |
| EPS (TTM) vs TTM 1 Yr. Ago | -18.66 | -- | -- | -- |
| EPS - 5 Yr. Growth Rate | 16.65 | 4.31 | 4.81 | 1.39 |
| Capital Spending - 5 Yr. Growth Rate | 22.98 | 31.13 | 17.82 | 19.44 |
Financial Strength
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Quick Ratio (MRQ) | 1.78 | 2.16 | 1.73 | 0.86 |
| Current Ratio (MRQ) | 1.82 | 2.35 | 2.04 | 1.02 |
| LT Debt to Equity (MRQ) | 9.09 | 13.89 | 18.07 | 129.00 |
| Total Debt to Equity (MRQ) | 14.55 | 19.08 | 28.92 | 198.51 |
| Interest Coverage (TTM) | -- | 4.10 | 0.39 | 26.84 |
Profitability Ratios
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Gross Margin (TTM) | 78.42 | 26.99 | 15.64 | 27.37 |
| Gross Margin - 5 Yr. Avg. | 81.06 | 56.17 | 35.55 | 27.04 |
| EBITD Margin (TTM) | 36.89 | -- | -- | -- |
| EBITD - 5 Yr. Avg | 38.98 | 25.55 | 23.48 | 15.66 |
| Operating Margin (TTM) | 32.23 | 6.98 | 1.65 | -- |
| Operating Margin - 5 Yr. Avg. | 36.03 | 21.45 | 13.15 | 20.01 |
| Pre-Tax Margin (TTM) | 33.03 | 6.66 | 1.49 | 7.75 |
| Pre-Tax Margin - 5 Yr. Avg. | 38.82 | 22.36 | 11.57 | 19.71 |
| Net Profit Margin (TTM) | 24.46 | 4.57 | -0.11 | 6.24 |
| Net Profit Margin - 5 Yr. Avg. | 28.01 | 14.13 | 8.44 | 13.97 |
| Effective Tax Rate (TTM) | 25.95 | 15.28 | 10.61 | -6.80 |
| Effecitve Tax Rate - 5 Yr. Avg. | 27.84 | 30.80 | 19.43 | 28.35 |
Management Effectiveness
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Return on Assets (TTM) | 18.77 | 3.50 | 1.79 | 3.70 |
| Return on Assets - 5 Yr. Avg. | 19.63 | 10.82 | 7.64 | 5.34 |
| Return on Investment (TTM) | 29.43 | 5.15 | 2.71 | 5.06 |
| Return on Investment - 5 Yr. Avg. | 28.63 | 15.87 | 11.00 | 6.88 |
| Return on Equity (TTM) | 36.82 | 6.54 | 2.93 | 8.86 |
| Return on Equity - 5 Yr. Avg. | 33.44 | 17.80 | 12.41 | 15.35 |
Efficiency
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Revenue/Employee (TTM) | 605,333 | 11,788,867 | 5,869,906 | 476,499 |
| Net Income/Employee (TTM) | 148,064 | 176,709 | -129,447 | 31,219 |
| Receivable Turnover (TTM) | 6.21 | 5.00 | 2.68 | 6.98 |
| Inventory Turnover (TTM) | 8.71 | 4.43 | 869.71 | 5.41 |
| Asset Turnover (TTM) | 0.77 | 0.40 | 0.42 | 0.46 |

