Fundamentals MSF (XETRA) - Microsoft Corporation
VR Fundamental Rating 6.65
| VR Piotroski Score | 8.00 |
| Altman-Z Score | 8.12 |
| Tobins Q Ratio | 2.72 |
| Tax Rate | 19.24% |
| Free-Cash-Flow Yield | 3.20% |
| Free-Cash-Flow Margin | 29.21% |
| Net Margin | 33.05% |
| Gross Margin | 68.16% |
| Debt / Equity | 0.26 |
| Debt / EBITDA | 0.49 |
| Debt / Free-Cash Flow | 1.24 |
| Interest Expense / Debt | 4.13% |
| RoE Return on Equity | 36.83% |
| RoCE Return on Cap. Employed | 29.73% |
| RoA Return on Assets | 18.50% |
| RoIC Return on Inv. Cap. | 40.67% |
| Analysts Rating | - |
| Analysts Target Price |
- |
VR Piotroski 8.00
1 - Yes: Net Income TTM (67449.0m) > 10m and > 3% of Revenue TTM (3% = 6122.82m)
2 - Yes: FCF TTM (59618.0m) > 1m and > FCF prev (98%) (59479.14m)
3 - Yes: RoA TTM 18.5% (Net Income TTM 67449.0m / Total Assets 364552.0m) >3% and > RoA prev (98%) 17.64% (61271.0m / 340389.0m)
4 - Yes: Total Cash from Operating Activities TTM 84386.0m > 1m and > Net Income TTM 67449.0m
5 - Yes: Net Debt (debt 48116.0m - cce 0m) to EBITDA TTM (98271.0m) ratio: 0.49 < 3.5
6 - No: Current Ratio 1.78 (Total Current Assets 169684.0m / Total Current Liabilities 95082.0m) >= 1 and > Current Ratio prev (98%) 2.08 (184406.0m / 88657.0m)
7 - Yes: Shares Outstanding last quarter 7473.0m < quarter 12m ago 7555.0m
8 - Yes: Gross Margin 68.2% (Total Revenue 204094.0m - Cost Of Revenue 64984.0m / Total Revenue) > 20% and > Gross Margin prev (98%) 67.4%
9 - Yes: Asset Turnover 0.56 (Total Revenue 204094.0m / Total Assets 364552.0m) > Asset Turnover prev (98%) 0.53 (184903.0m / 340389.0m)
2 - Yes: FCF TTM (59618.0m) > 1m and > FCF prev (98%) (59479.14m)
3 - Yes: RoA TTM 18.5% (Net Income TTM 67449.0m / Total Assets 364552.0m) >3% and > RoA prev (98%) 17.64% (61271.0m / 340389.0m)
4 - Yes: Total Cash from Operating Activities TTM 84386.0m > 1m and > Net Income TTM 67449.0m
5 - Yes: Net Debt (debt 48116.0m - cce 0m) to EBITDA TTM (98271.0m) ratio: 0.49 < 3.5
6 - No: Current Ratio 1.78 (Total Current Assets 169684.0m / Total Current Liabilities 95082.0m) >= 1 and > Current Ratio prev (98%) 2.08 (184406.0m / 88657.0m)
7 - Yes: Shares Outstanding last quarter 7473.0m < quarter 12m ago 7555.0m
8 - Yes: Gross Margin 68.2% (Total Revenue 204094.0m - Cost Of Revenue 64984.0m / Total Revenue) > 20% and > Gross Margin prev (98%) 67.4%
9 - Yes: Asset Turnover 0.56 (Total Revenue 204094.0m / Total Assets 364552.0m) > Asset Turnover prev (98%) 0.53 (184903.0m / 340389.0m)
Altman-Z 8.12
A = 0.209 = (Total Current Assets 157823.0m - Total Current Liabilities 81718.0m) / Total Assets 364552.0m
B = 0.273 = Retained Earnings 99368.0m / Total Assets 364552.0m
C = 0.231 = EBIT TTM 84081.0m / Total Assets 364552.0m
D = 10.271 = Market Cap 1863280.49m / Total Liabilities 181416.0m
E = 0.56 = Revenue TTM 204094.0m / Total Assets 364552.0m
8.116 = (1.2 * A) + (1.4 * B) + (3.3 * C) + (0.6 * D) + (1.0 * E)
B = 0.273 = Retained Earnings 99368.0m / Total Assets 364552.0m
C = 0.231 = EBIT TTM 84081.0m / Total Assets 364552.0m
D = 10.271 = Market Cap 1863280.49m / Total Liabilities 181416.0m
E = 0.56 = Revenue TTM 204094.0m / Total Assets 364552.0m
8.116 = (1.2 * A) + (1.4 * B) + (3.3 * C) + (0.6 * D) + (1.0 * E)
Current Fundamental Values
Market Cap = 1863280.49m EUR
Market Cap in USD = 1985424.12m (1863280.49m EUR * 1.0656 EURUSD)
Debt = 48116.0m (short 3997.0m + long 44119.0m) last quarter
CCE = unknown/error
Enterprise Value = 1911396.49m (Market Cap 1863280.49m + Debt 48116.0m - CCE 0m)
FCF Yield = 3.2% (FCF TTM 59618.0m / Market Cap 1863280.49m)
FCF Margin = 29.21% (FCF TTM 59618.0m / Revenue TTM 204094.0m)
Net Margin = 33.05% (Net Income TTM 67449.0m / Revenue TTM 204094.0m)
Gross Margin = 68.16% ((Revenue TTM 204094.0m - Cost of Revenue TTM 64984.0m) / Revenue TTM 204094.0m)
Tobins Q-Ratio = 2.715 (Market Cap 1863280.49m / Book Value Of Equity 686168.0m
Interest Expense / Debt = 4.13% (Interest Expense TTM 1989m / Debt 48116.0m)
taxrate = 19.24% last quarter (Income Tax Expense 3914.0m / Income Before Tax 20339.0m)
nopat = 66878.23m (Operating Income TTM 82815.0m * (1 - taxrate 0.19))
WACC = 7.46% ((Market Cap 1863280.49m / Enterprise Value 1911396.49m) * CAPM 0.08) + (Debt 48116.0m / Enterprise Value 1911396.49m) * x
Market Cap in USD = 1985424.12m (1863280.49m EUR * 1.0656 EURUSD)
Debt = 48116.0m (short 3997.0m + long 44119.0m) last quarter
CCE = unknown/error
Enterprise Value = 1911396.49m (Market Cap 1863280.49m + Debt 48116.0m - CCE 0m)
FCF Yield = 3.2% (FCF TTM 59618.0m / Market Cap 1863280.49m)
FCF Margin = 29.21% (FCF TTM 59618.0m / Revenue TTM 204094.0m)
Net Margin = 33.05% (Net Income TTM 67449.0m / Revenue TTM 204094.0m)
Gross Margin = 68.16% ((Revenue TTM 204094.0m - Cost of Revenue TTM 64984.0m) / Revenue TTM 204094.0m)
Tobins Q-Ratio = 2.715 (Market Cap 1863280.49m / Book Value Of Equity 686168.0m
Interest Expense / Debt = 4.13% (Interest Expense TTM 1989m / Debt 48116.0m)
taxrate = 19.24% last quarter (Income Tax Expense 3914.0m / Income Before Tax 20339.0m)
nopat = 66878.23m (Operating Income TTM 82815.0m * (1 - taxrate 0.19))
WACC = 7.46% ((Market Cap 1863280.49m / Enterprise Value 1911396.49m) * CAPM 0.08) + (Debt 48116.0m / Enterprise Value 1911396.49m) * x