Fundamental Analysis of Microsoft Corporation - Growth / Value Index


MSFT - Valuation Highlights

Valuation Analysis

   Undervalued - Price to Intrinsic Value of 0.219
   Tremendous increasing in Book Value last 3 year
   Tsr Value Index - Poor Score of 28.12
   Price to Earning Ratio is 40.51 and EV to EBITDA is 31.81 suggesting that it is very expensive
   Price to Book Ratio of 15.68 suggesting that it is very expensive
Valuation Key Ratios
Ratio TTM Latest FY Yoy Change MRQ
Price to Earning 39.30 46.83 -0.386 %
Price to Book 15.21 16.43 -19.97 % 13.39
Price to Sales 14.32 15.99 -7.28 %
Enterprise Value to EBITDA Multiple 30.86 33.22 -3.63 %


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.650 %
   Low Earning Yield of 2.47 %
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 Cap3370.92 B
Enterprise Value3383.46 B
Price/Book TTM15.21
Outstanding Share7432.31 M
Float/ Outstanding Share99.86%
Dividend Yield0.640 %
Share Holding
Guru Numbers
Price/Graham No5.36
Peter Lynch Ratio0.0100
Piotroski F Score7.00
Altman Z Score11.69
Sloan Ratio0.0181
Peter Lynch Fair Value180.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 11.99 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)