Ratios
Microsoft Corporation (MSFT.O) (Nasdaq)
Valuation Ratios
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| P/E Ratio (TTM) | 19.40 | 49.30 | 16.52 | 122.25 |
| P/E High - Last 5 Yrs. | 36.08 | 8.16 | 2.58 | 24.52 |
| P/E Low - Last 5 Yrs. | 8.65 | 1.98 | 0.47 | 5.65 |
| Beta | 0.95 | 0.77 | 1.13 | 1.37 |
| Price to Sales (TTM) | 4.72 | 1.40 | 1.07 | 2.04 |
| Price to Book (MRQ) | 6.46 | 3.92 | 1.91 | 2.53 |
| Price to Tangible Book (MRQ) | 9.84 | 17.88 | 2.95 | 6.45 |
| Price to Cash Flow (TTM) | 16.20 | 8.13 | 5.75 | 15.54 |
| Price to Free Cash Flow (TTM) | 18.48 | 56.59 | 26.48 | 21.77 |
| % Owned Institutions | -- | -- | -- | -- |
Dividends
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Dividend Yield | 1.74 | 0.23 | 0.04 | 1.50 |
| Dividend Yield - 5 Year Avg. | 3.96 | 2.04 | 1.25 | 2.75 |
| Dividend 5 Year Growth Rate | 26.58 | 12.81 | 12.74 | 9.49 |
| Payout Ratio(TTM) | 33.55 | 155.66 | 43.67 | 88.36 |
Growth Rates
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Sales (MRQ) vs Qtr. 1 Yr. Ago | -14.22 | -11.19 | -7.66 | -4.02 |
| Sales (TTM) vs TTM 1 Yr. Ago | -8.79 | -1.74 | -4.60 | -5.08 |
| Sales - 5 Yr. Growth Rate | 9.67 | 9.74 | 11.63 | 15.64 |
| EPS (MRQ) vs Qtr. 1 Yr. Ago | -16.45 | -26.24 | 134.26 | 73.70 |
| EPS (TTM) vs TTM 1 Yr. Ago | -18.66 | -- | -- | -- |
| EPS - 5 Yr. Growth Rate | 16.65 | 4.25 | 4.78 | 1.27 |
| Capital Spending - 5 Yr. Growth Rate | 22.98 | 31.18 | 17.73 | 19.55 |
Financial Strength
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Quick Ratio (MRQ) | 1.78 | 2.16 | 1.74 | 0.84 |
| Current Ratio (MRQ) | 1.82 | 2.35 | 2.05 | 0.99 |
| LT Debt to Equity (MRQ) | 9.09 | 13.84 | 18.11 | 130.01 |
| Total Debt to Equity (MRQ) | 14.55 | 19.01 | 29.01 | 200.27 |
| Interest Coverage (TTM) | -- | 4.03 | 0.38 | 26.43 |
Profitability Ratios
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Gross Margin (TTM) | 78.42 | 26.89 | 15.81 | 27.08 |
| Gross Margin - 5 Yr. Avg. | 81.06 | 56.14 | 35.61 | 26.75 |
| EBITD Margin (TTM) | 36.89 | -- | -- | -- |
| EBITD - 5 Yr. Avg | 38.98 | 25.52 | 23.42 | 15.46 |
| Operating Margin (TTM) | 32.23 | 6.90 | 1.60 | -- |
| Operating Margin - 5 Yr. Avg. | 36.03 | 21.42 | 13.15 | 20.04 |
| Pre-Tax Margin (TTM) | 33.03 | 6.59 | 1.44 | 7.66 |
| Pre-Tax Margin - 5 Yr. Avg. | 38.82 | 22.34 | 11.61 | 19.75 |
| Net Profit Margin (TTM) | 24.46 | 4.51 | -0.20 | 6.18 |
| Net Profit Margin - 5 Yr. Avg. | 28.01 | 14.11 | 8.46 | 14.00 |
| Effective Tax Rate (TTM) | 25.95 | 15.21 | 10.72 | -7.43 |
| Effecitve Tax Rate - 5 Yr. Avg. | 27.84 | 30.73 | 19.59 | 28.27 |
Management Effectiveness
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Return on Assets (TTM) | 18.77 | 3.48 | 1.79 | 3.65 |
| Return on Assets - 5 Yr. Avg. | 19.63 | 10.82 | 7.66 | 5.28 |
| Return on Investment (TTM) | 29.43 | 5.12 | 2.71 | 4.99 |
| Return on Investment - 5 Yr. Avg. | 28.63 | 15.87 | 11.03 | 6.79 |
| Return on Equity (TTM) | 36.82 | 6.49 | 2.91 | 8.72 |
| Return on Equity - 5 Yr. Avg. | 33.44 | 17.79 | 12.44 | 15.25 |
Efficiency
| Company | Industry | Sector | S&P 500 | |
|---|---|---|---|---|
| Revenue/Employee (TTM) | 605,333 | 11,877,391 | 5,951,891 | 473,836 |
| Net Income/Employee (TTM) | 148,064 | 177,853 | -142,088 | 30,890 |
| Receivable Turnover (TTM) | 6.21 | 5.01 | 2.70 | 6.89 |
| Inventory Turnover (TTM) | 8.71 | 4.42 | 949.65 | 5.36 |
| Asset Turnover (TTM) | 0.77 | 0.40 | 0.42 | 0.46 |

