Fundamental Analysis of Microsoft Corporation - Growth / Value Index
MSFT - Valuation Highlights
Valuation Analysis
Undervalued - Price to Intrinsic Value of 0.195
Tremendous increasing in Book Value last 3 year
Tsr Value Index - Poor Score of 28.12
Price to Book Ratio of 13.97 suggesting that it is very expensive
Valuation Key Ratios
Ratio | TTM | Latest FY | Yoy Change | MRQ |
---|---|---|---|---|
Price to Earning | 36.41 | 43.39 | -0.386 % | |
Price to Book | 14.10 | 15.23 | -19.97 % | 12.40 |
Price to Sales | 13.26 | 14.82 | -7.28 % | |
Enterprise Value to EBITDA Multiple | 28.60 | 30.79 | -3.68 % |
MSFT - Profitability Highlights
Profitability Analysis
Piotroski F Score - Good Value of 7.0
Excellent Net Margin for last 3 years
Over the last 3 years, the company has achieved Incredible Return on Equity
Strong Return On Capital Employed of 28.55
Company Earning excess return
During the past twelve months, the company has given a strong Return On Equity of 38.71%
During the past twelve months, the company has given a strong Net Margin of 36.43%
All key Trailing Twelve Months Margin growing by 15 %
Company's Profit Before Tax is increasing for last 5 Quarters
EBITDA is continuously increasing for last 3 Years
Very Low Dividend Yield of 0.720 %
Low Earning Yield of 2.77 %
Profitability Key Ratios
Ratio | TTM | Latest FY | Yoy Change | MRQ |
---|---|---|---|---|
Return On Equity | 38.71 | 35.09 | -19.66 % | 8.67 |
Return On Asset | 19.65 | 17.56 | -11.90 % | 4.53 |
Net Profit Margin | 36.43 | 34.15 | -6.92 % | 35.47 |
Operating Profit Margin | 44.70 | 41.77 | -0.671 % | 44.59 |
EBITDA Margin | 46.34 | 48.31 | -4.44 % | 44.59 |
Highlights
Market Cap | 3123.13 B |
Enterprise Value | 3135.66 B |
Price/Book TTM | 14.10 |
Outstanding Share | 7432.31 M |
Float/ Outstanding Share | 99.85% |
Dividend Yield | 0.710 % |
Share Holding
Guru Numbers
Price/Graham No | 4.96 |
Peter Lynch Ratio | 0.0108 |
Piotroski F Score | 7.00 |
Altman Z Score | 10.97 |
Sloan Ratio | 0.0181 |
Peter Lynch Fair Value | 180.73 |
MSFT - Growth Highlights
Growth Analysis
Annual sales of the company is increased for three years in a row
Steady increase in Total Assets for last 3 Years
Growth Key Fields
Field | TTM | YoY Growth | QoQ Growth |
---|---|---|---|
Revenue | 236584 M | 6.88 % | 0.261 % |
Gross Profit | 165359 M | 7.69 % | 2.25 % |
EBITDA | 109636 M | 2.14 % | 2.03 % |
Net Profit | 86181.00 M | 0.518 % | 0.316 % |
EPS | 11.54 | 0.387 % | NA |
MSFT - Stability Highlights
Stability Analysis
Tsr Stability Index - Good Score of 76.56
Altman Z Score of 10.89 suggests good Stability
Debt to equity ratio has decreased and is lowest in last five years
Decreasing debt with Increasing revenue
Stability Key Ratios
Ratio | Latest FY | Yoy Change | MRQ |
---|---|---|---|
Debt to Equity Ratio | 0.229 | -23.37 % | 0.259 |
Cash Ratio | 1.07 | -3.03 % | |
Quick Ratio | 1.75 | -0.0051 % | 1.23 |
Shareholders Equity | 50.06 | 9.66 % | |
Debt to EBITDA | 0.461 | -7.10 % |
Historical Valuation Ratios of Microsoft Corporation
Historical Valuation Ratios
Loading ...
Historical Profitability Ratios of Microsoft Corporation
Historical Profitability Ratios
Loading ...
Historical Efficiency Ratios of Microsoft Corporation
Historical Efficiency Ratios
Loading ...
Historical Solvency Ratios of Microsoft Corporation
Historical Solvency Ratios
Loading ...
Note : All Data Generated at the End of Trading Hours (EOD Data)