MSFT is OVERVALUED SecDiverAI
Median Fair Price 240.5
Confidence: MEDIUM

Fair Price Range 108.24 - 353.98
3 Year Price target: $ 267.03 - $ 436.71

Current Market Price: 414.2 as of 2024-09-10
Investment Value of 100 $ invested in MSFT as compared to Market Index: SPY across historical periods[*does not include dividends]
Investment Period $ Value Today(MSFT) $ Value Today(SPY) CAGR vs Market
9 years before $ 1030.73 $ 208.39 29.59% vs SPY:8.5%
5 years before $ 429.47 $ 150.37 33.84% vs SPY:8.5%
3 years before $ 191.22 $ 127.73 24.12% vs SPY:8.5%

Welcome to Summary reports!   



We have 9 report results for ticker: MSFT - Microsoft Corporation, also organized by 6 group tags below ... Bargain Finder: Related Companies Portfolio Health: Related Companies

Business Checklist for MSFT from SecDiver AI beta Free for Limited Time

Want to see more such checks or Customize your checks, check out our plans

Red Flags Identified


24

Total Checks Done


69

Wall Street Drivers beta

πŸ“Š Professional Investors(wallstreet) pay a lot of heed at these numbers, long term history matters - specially 9+ year trends
Score 9.0 / 10.0

  • revenue cagr for last 9 years
  • insight: ['10.32 is greater than equal to 5']
  • mental_model: We prefer growing Business which grow >= 5% YoY, better than GDP growth of >= 2-3%
  • cashflows cagr for last 9 years
  • insight: ['11.78 is greater than equal to 5']
  • mental_model: We prefer growing Business which generate cashflows >= 5% YoY, for some industries like finance specially Banks this might be lower/red and its OK for them
  • operating profits cagr for last 9 years
  • insight: ['13.69 is greater than equal to 5']
  • mental_model: We prefer growing Business which generate operating profits >= 5% YoY
  • shares outstanding cagr for last 9 years
  • insight: ['-1.31 is less than equal to 2']
  • mental_model: As a business owner equity is important, We want less dilution over years OR it should reduce so our share of business increases with time, less than 2% is ideal, >=10% is potentially bad be careful
  • net profits cagr for last 9 years
  • insight: ['14.57 is greater than equal to 5']
  • mental_model: We prefer growing Business which generate net profits >= 5% YoY
  • debt cagr for last 9 years
  • insight: ['15.56 is less than equal to 2']
  • mental_model: We prefer Business with lower debt growth
  • equity cagr for last 9 years
  • insight: ['9.16 is greater than equal to 5']
  • mental_model: We prefer growing Business having shareholder equity growth >= 5% YoY
  • roe average for last 3 years
  • insight: ['56.99 is greater than equal to 10']
  • mental_model: Good Business have return on equity >= 10%, ROE matters for businesses like Insurance, Banks, Financials
  • roce average for last 3 years
  • insight: ['37.81 is greater than equal to 15']
  • mental_model: Good Business have return on capital >= 15%, for some industries like finance specially Banks this might be lower/red and its OK for them
  • roic average for last 3 years
  • insight: ['96.71 is greater than equal to 15']
  • mental_model: Good Business have return on invested capital >= 15%, for some industries like finance specially Banks this might be lower/red and its OK for them
  • leverage average for last 3 years
  • insight: ['0.81 is less than equal to 5', '0.81 is greater than equal to 0']
  • mental_model: We prefer Business which can pay their debts in less than 5 years, for some industries like finance specially Banks this might be lower/red and its OK for them
  • roe_cashflow::operating average for last 3 years
  • insight: ['60.06 is greater than equal to 10']
  • mental_model: Good Business have return on equity >= 10%
  • roce_cashflow::operating average for last 3 years
  • insight: ['39.88 is greater than equal to 15']
  • mental_model: Good Business have return on capital >= 15%
  • roic_cashflow::operating average for last 3 years
  • insight: ['102.09 is greater than equal to 15']
  • mental_model: Good Business have return on invested capital >= 15%

Business Durability beta

🏰 Quality companies with moats show higher or stable trends, long term trends matters, Consistency is the Key
Score 8.0 / 10.0

  • margin cashflow running_sum for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 0.44 wrt mean ratio: 0.397']
  • margin operating running_sum for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 0.42 wrt mean ratio: 0.33']
  • margin net running_sum for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 0.36 wrt mean ratio: 0.264']
  • roa average for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 24.15 wrt mean ratio: 17.542']
  • mental_model: We want stability on increasing return on assets
  • roe average for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 56.99 wrt mean ratio: 44.711']
  • mental_model: We want stability on increasing return on equity
  • roce average for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 37.81 wrt mean ratio: 28.124']
  • mental_model: We want stability on increasing return on capital employed
  • roic average for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 96.71 wrt mean ratio: 91.11']
  • mental_model: We want stability on increasing return on invested capital
  • rotc average for last 3 years
  • insight: ['trend is lower, last 3 year ratio: 138.99 wrt mean ratio: 156.329']
  • mental_model: We want stability on increasing return on tangible capital
  • cash average for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 20953000000.0 wrt mean ratio: 10974740740.741']
  • mental_model: We want stability on cash growth
  • roa_cashflow::operating average for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 25.38 wrt mean ratio: 21.064']
  • mental_model: We want stability on increasing return on assets
  • roe_cashflow::operating average for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 60.06 wrt mean ratio: 53.608']
  • mental_model: We want stability on increasing return on equity
  • roce_cashflow::operating average for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 39.88 wrt mean ratio: 33.761']
  • mental_model: We want stability on increasing return on capital employed
  • roic_cashflow::operating average for last 3 years
  • insight: ['trend is lower, last 3 year ratio: 102.09 wrt mean ratio: 111.394']
  • mental_model: We want stability on increasing return on invested capital
  • rotc_cashflow::operating average for last 3 years
  • insight: ['trend is lower, last 3 year ratio: 146.88 wrt mean ratio: 192.841']
  • mental_model: We want stability on increasing return on tangible capital

Valuation is the Key beta

πŸ’Ž Buying Quality companies at cheap provides the right Margin of Safety in the longer term
Score 0.0 / 10.0

  • pe average for last 3 years
  • insight: ['34.7 is less than equal to 15', '34.7 is greater than 0']
  • mental_model: It depends which side of the equation you are, Buy, Hold or Sell but typically We want lower number here when we are BUY mode, PE <=15 preferred
  • pocf average for last 3 years
  • insight: ['28.22 is less than equal to 15', '28.22 is greater than 0']
  • mental_model: It depends which side of the equation you are, Buy, Hold or Sell but typically We want lower number here when we are BUY mode, POCF <=15 preferred
  • pb average for last 3 years
  • insight: ['13.98 is less than equal to 2', '13.98 is greater than 0']
  • mental_model: It depends which side of the equation you are, Buy, Hold or Sell but typically We want lower number here when we are BUY mode, PB <=2 preferred
  • ps average for last 3 years
  • insight: ['12.38 is less than equal to 5', '12.38 is greater than 0']
  • mental_model: It depends which side of the equation you are, Buy, Hold or Sell but typically We want lower number here when we are BUY mode, PS <=5 preferred
  • evToEbitda average for last 3 years
  • insight: ['25.95 is less than equal to 15', '25.95 is greater than 0']
  • mental_model: It depends which side of the equation you are, Buy, Hold or Sell but typically We want lower number here when we are BUY mode, evToEbitda <=15 preferred
  • evToOcf average for last 3 years
  • insight: ['28.77 is less than equal to 15', '28.77 is greater than 0']
  • mental_model: It depends which side of the equation you are, Buy, Hold or Sell but typically We want lower number here when we are BUY mode, POCF <=15 preferred
  • evToRevenue average for last 3 years
  • insight: ['12.63 is less than equal to 2', '12.63 is greater than 0']
  • mental_model: It depends which side of the equation you are, Buy, Hold or Sell but typically We want lower number here when we are BUY mode, evToRevenue <=2 preferred

Business Trends last 3 years beta

Score 9.0 / 10.0

  • receivables running_sum for last 3 years
  • insight: ['trend is stable, last 3 year ratio: 0.23 wrt mean ratio: 0.223']
  • mental_model: receivables should always grow less with revenues otherwise there might be some payment/collection issues, Watch out
  • inventory running_sum for last 3 years
  • insight: ['trend is lower, last 3 year ratio: 0.02 wrt mean ratio: 0.023']
  • mental_model: inventory should always grow in relation with revenues, Inventory build can be positive depending on the industry cycle, but mostly it could be a CON as working capital is tied up, Be Careful
  • payables running_sum for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 0.09 wrt mean ratio: 0.08']
  • mental_model: the more this is the better, nothing bad about it.
  • capex running_sum for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 0.13 wrt mean ratio: 0.092']
  • sales and marketing running_sum for last 3 years
  • insight: ['trend is lower, last 3 year ratio: 0.11 wrt mean ratio: 0.152']
  • mental_model: Sales are marketing increases specially if its a Sales led growth Be Careful, With time you want Organic Growth and Customer Retention
  • research & development running_sum for last 3 years
  • insight: ['trend is stable, last 3 year ratio: 0.13 wrt mean ratio: 0.13']
  • mental_model: Rnd is good specially when company is increasing moat but be careful with the spend, typically RND spend shows up 2-3 years, Read Annual statements to understand why this RND is increasing
  • cash running_sum for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 0.11 wrt mean ratio: 0.087']
  • mental_model: cash trend should be similar or greater to revenue, if company is heavily reinvesting it might be OK, but do check

Profits Matter beta

πŸ’° Companies needs to have positive profits to reward its shareholders in the long term
Score 10.0 / 10.0

  • positive cashflows profits average for last 3 years
  • insight: ['84452333333.33 is greater than equal to 0']
  • mental_model: We want to see positive cashflows profits for last 3 years, Profits determine Stock prices in the long term
  • positive operating profits average for last 3 years
  • insight: ['80607333333.33 is greater than equal to 0']
  • mental_model: We want to see positive operating profits for last 3 years, Profits determine Stock prices in the long term
  • positive net profits average for last 3 years
  • insight: ['68790000000.0 is greater than equal to 0']
  • mental_model: We want to see positive net profits for last 3 years, GAAP net Profits determine Stock prices in the long term

Capital Allocation beta

🧠 Remember: Shareholders only gets rewarded if management does prudent capital allocation decisions
Score 6.0 / 10.0

  • capex to Cashflow running_sum for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 0.29 wrt mean ratio: 0.229']
  • depreciation to capex running_sum for last 3 years
  • insight: ['trend is lower, last 3 year ratio: 0.55 wrt mean ratio: 0.838']
  • mental_model: Helps understand where the company is investing for the future, OR it has to replenish its assets to maintain business
  • stock based compensation to Cashflow running_sum for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 0.09 wrt mean ratio: 0.083']
  • dividend distribution to Cashflow running_sum for last 3 years
  • insight: ['trend is lower, last 3 year ratio: -0.21 wrt mean ratio: -0.268']
  • shares_buyback distribution of Cashflow running_sum for last 3 years
  • insight: ['trend is stable, last 3 year ratio: -0.32 wrt mean ratio: -0.334']
  • cashToRevenue running_sum for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 0.11 wrt mean ratio: 0.087']
  • cashToEquity running_sum for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 0.12 wrt mean ratio: 0.101']
  • cashToCapex running_sum for last 3 years
  • insight: ['trend is stable, last 3 year ratio: 0.87 wrt mean ratio: 0.909']

Business Performance beta

Score 6.0 / 10.0

  • Operating Leverage Cashflow cagr for last 9 years
  • insight: ['Ratio is [1.14] for last 9 year ratio, threshold 0.9, value_1: 11.78, value_2: 10.32']
  • Operating Leverage cagr for last 9 years
  • insight: ['Ratio is [1.33] for last 9 year ratio, threshold 0.9, value_1: 13.69, value_2: 10.32']
  • debt cagr for last 9 years
  • insight: ['Ratio is [1.51] for last 9 year ratio, threshold 1, value_1: 15.56, value_2: 10.32']
  • cash cagr for last 9 years
  • insight: ['Ratio is [1.76] for last 9 year ratio, threshold 0.9, value_1: 16.09, value_2: 9.16']
  • debt-equity-cagr cagr for last 9 years
  • insight: ['Ratio is [1.7] for last 9 year ratio, threshold 1, value_1: 15.56, value_2: 9.16']
  • mental_model: We want debt to grow less than equity

Balance Sheet Quality beta

πŸ“ˆ Quality companies can withstand darkest hours, strong balance sheet is the key
Score 10.0 / 10.0

  • debtToCashflow running_sum for last 3 years
  • insight: ['trend is lower, last 3 year ratio: 0.81 wrt mean ratio: 1.199']
  • debtToEquity running_sum for last 3 years
  • insight: ['trend is lower, last 3 year ratio: 0.4 wrt mean ratio: 0.569']
  • leverage average for last 3 years
  • insight: ['0.81 is less than equal to 5']
  • mental_model: We prefer Business which can pay their debts in less than 5 years

Taxes, Interest and Unearned beta

πŸ“ˆNote: this is a new one, so do not use this for now, we are looking at data
Score 10.0 / 10.0

  • income_tax running_sum for last 3 years
  • insight: ['trend is stable, last 3 year ratio: 0.07 wrt mean ratio: 0.072']

Valuation Insights Relative to History beta

Score 0.0 / 10.0

  • pe average for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 34.7 wrt mean ratio: 28.654']
  • mental_model: It depends which side of the equation you are, Buy, Hold or Sell but typically We want stability on decreasing trend here
  • pocf average for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 28.22 wrt mean ratio: 18.349']
  • mental_model: It depends which side of the equation you are, Buy, Hold or Sell but typically We want stability on decreasing trend here
  • pb average for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 13.98 wrt mean ratio: 9.469']
  • mental_model: It depends which side of the equation you are, Buy, Hold or Sell but typically We want stability on decreasing trend here
  • ps average for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 12.38 wrt mean ratio: 7.518']
  • mental_model: It depends which side of the equation you are, Buy, Hold or Sell but typically We want stability on decreasing trend here
  • evToEbitda average for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 25.95 wrt mean ratio: 18.843']
  • mental_model: It depends which side of the equation you are, Buy, Hold or Sell but typically We want stability on decreasing trend here
  • evToOcf average for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 28.77 wrt mean ratio: 19.265']
  • mental_model: It depends which side of the equation you are, Buy, Hold or Sell but typically We want stability on decreasing trend here
  • evToRevenue average for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 12.63 wrt mean ratio: 7.885']
  • mental_model: It depends which side of the equation you are, Buy, Hold or Sell but typically We want stability on decreasing trend here

Want to see What Wall Street looks at for Quality companies? We are building a special AI based SecDiver scoring system
Sign up for FREE

We do NOT feel in CONTROL in the markets. Do we know why?

1. Showing SUMMARY report for MSFT [show/hide charts] Current Market Price: 414.2 as of 2024-09-10

T means Trillions, B means Billions, M means Millions, all values are in USD(or company filed currency) if not specified as percent/number in the Entry column
Disclaimer: Data is provided as is, please do your due diligence before making any investments, Markets can be very volatile!
Ticker Entry 2023 2022 2021 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008
MSFT StockMarketPrice 374.58 237.71 330.27 216.60 151.97 96.45 79.85 56.74 49.30 40.18 31.50 21.83 20.63 21.61 23.12 14.41
MSFT YearPriceHigh 384.30 338.00 349.67 232.86 159.55 116.18 87.50 64.10 56.85 50.05 38.98 32.95 29.46 31.58 31.50 35.96
MSFT YearPriceLow 219.35 213.43 211.94 132.52 97.20 83.83 61.95 48.04 39.72 34.63 26.28 26.26 23.65 22.73 14.87 17.50
MSFT revenue 211.91B 198.27B 168.09B 143.01B 125.84B 110.36B 96.57B 91.15B 93.58B 86.83B 77.85B 73.72B 0.0 0.0 0.0 0.0
MSFT revenue::cost 65.86B 62.65B 52.23B 46.08B 42.91B 38.35B 34.26B 32.78B 33.04B 27.08B 20.39B 17.53B 0.0 0.0 0.0 0.0
MSFT operating_expense inf inf inf inf inf inf inf inf inf inf inf inf 0.0 0.0 0.0 0.0
MSFT assets 411.98B 364.84B 333.78B 301.31B 286.56B 258.85B 250.31B 193.69B 176.22B 172.38B 142.43B 0.0 0.0 0.0 0.0 0.0
MSFT cash 34.70B 13.93B 14.22B 13.58B 11.36B 11.95B 7.66B 6.51B 5.59B 8.67B 3.80B 0.0 0.0 0.0 0.0 0.0
MSFT ppnenet 95.64B 74.40B 59.72B 44.15B 36.48B 29.46B 23.73B 18.36B 14.73B 13.01B 9.99B 0.0 0.0 0.0 0.0 0.0
MSFT workingCapital 29.00B 25.52B 21.38B 22.20B 20.53B 17.22B 13.63B 14.22B 14.77B 14.60B 14.60B 0.0 0.0 0.0 0.0 0.0
MSFT workingCapitalWithCash 29.28B 25.80B 21.65B 22.43B 20.76B 17.38B 13.76B 14.33B 14.95B 14.67B 14.67B 0.0 0.0 0.0 0.0 0.0
MSFT owner_earnings 64.11B 67.07B 58.94B 42.59B 35.85B 29.68B 28.11B 24.04B 21.15B 24.84B 22.67B 27.08B 0.0 0.0 0.0 0.0
MSFT netincome_cfo 72.36B 72.74B 61.27B 44.28B 39.24B 16.57B 25.49B 20.54B 12.19B 22.07B 21.86B 16.98B 0.0 0.0 0.0 0.0
MSFT cashflow::operating 87.58B 89.03B 76.74B 60.67B 52.19B 43.88B 39.51B 33.33B 29.67B 32.50B 28.83B 31.63B 0.0 0.0 0.0 0.0
MSFT cashflow::fcf 59.48B 65.15B 56.12B 45.23B 38.26B 32.25B 31.38B 24.98B 23.72B 27.02B 24.58B 29.32B 0.0 0.0 0.0 0.0
MSFT cashflow::realfcf 49.86B 57.65B 50.00B 39.95B 33.61B 28.31B 28.11B 22.31B 21.15B 24.57B 22.17B 27.08B 0.0 0.0 0.0 0.0
MSFT netincome 72.36B 72.74B 61.27B 44.28B 39.24B 16.57B 25.49B 20.54B 12.19B 22.07B 21.86B 16.98B 0.0 0.0 0.0 0.0
MSFT operatingincome 88.52B 83.38B 69.92B 52.96B 42.96B 35.06B 29.02B 26.08B 18.16B 27.76B 26.76B 21.76B 0.0 0.0 0.0 0.0
MSFT grossincome 146.05B 135.62B 115.86B 96.94B 82.93B 72.01B 62.31B 58.37B 60.54B 59.90B 57.60B 56.19B 0.0 0.0 0.0 0.0
MSFT marketcap 2783.98B 1772.00B 2529.41B 1637.60B 1159.35B 740.50B 614.83B 441.17B 393.80B 337.47B 266.81B 185.69B 0.0 0.0 0.0 0.0
MSFT ev 2796.51B 1857.63B 2573.33B 1687.36B 1220.17B 804.79B 684.29B 479.44B 418.52B 351.95B 278.60B 185.69B 0.0 0.0 0.0 0.0
MSFT ebitda 102.38B 97.84B 81.60B 65.75B 54.64B 45.32B 37.80B 32.70B 24.12B 32.97B 30.52B 24.73B 0.0 0.0 0.0 0.0
MSFT equity 206.22B 166.54B 141.99B 118.30B 102.33B 82.72B 87.71B 72.00B 80.08B 89.78B 78.94B 0.0 0.0 0.0 0.0 0.0
MSFT debt 47.24B 99.56B 58.15B 63.33B 72.18B 76.24B 77.12B 44.78B 30.31B 23.14B 15.60B 0.0 0.0 0.0 0.0 0.0
MSFT debtToEquity 0.23 0.60 0.41 0.54 0.71 0.92 0.88 0.62 0.38 0.26 0.20 inf 0.0 0.0 0.0 0.0
MSFT owner_earningsToInterest inf inf inf inf inf inf inf inf inf inf inf inf 0.0 0.0 0.0 0.0
MSFT cashflow::operatingToInterest inf inf inf inf inf inf inf inf inf inf inf inf 0.0 0.0 0.0 0.0
MSFT eps 9.72 9.70 8.12 5.82 5.11 2.15 3.29 2.59 1.49 2.66 2.61 2.02 0.0 0.0 0.0 0.0
MSFT dps_share 2.65 2.41 2.17 1.99 1.80 1.65 1.53 1.39 1.21 1.06 0.88 0.75 0.0 0.0 0.0 0.0
MSFT dividendPayoutToCashflow::operating 0.23 0.20 0.22 0.25 0.26 0.29 0.30 0.33 0.33 0.27 0.26 0.20 0.0 0.0 0.0 0.0
MSFT dividendPayoutToOwner_earnings 0.31 0.27 0.28 0.36 0.39 0.43 0.42 0.46 0.47 0.36 0.33 0.24 0.0 0.0 0.0 0.0
MSFT shares 7.47B 7.54B 7.61B 7.61B 7.67B 7.70B 7.75B 7.92B 8.18B 8.40B 8.47B 8.51B 0.0 0.0 0.0 0.0
MSFT shares_calc 7.43B 7.45B 7.66B 7.56B 7.63B 7.68B 7.70B 7.78B 7.99B 8.40B 8.47B 8.51B 0.0 0.0 0.0 0.0
MSFT income_tax 16.95B 10.98B 9.83B 8.76B 4.45B 19.90B 4.41B 5.10B 6.31B 5.75B 5.19B 5.29B 0.0 0.0 0.0 0.0
MSFT sbc 9.61B 7.50B 6.12B 5.29B 4.65B 3.94B 3.27B 2.67B 2.57B 2.45B 2.41B 2.24B 0.0 0.0 0.0 0.0
MSFT capex 28.11B 23.89B 20.62B 15.44B 13.93B 11.63B 8.13B 8.34B 5.94B 5.49B 4.26B 2.31B 0.0 0.0 0.0 0.0
MSFT maintainence_capex 13.86B 14.46B 11.69B 12.80B 11.68B 10.26B 8.13B 6.62B 5.94B 5.21B 3.75B 2.31B 0.0 0.0 0.0 0.0
MSFT depreciation 13.86B 14.46B 11.69B 12.80B 11.68B 10.26B 8.78B 6.62B 5.96B 5.21B 3.75B 2.97B 0.0 0.0 0.0 0.0
MSFT capexToRevenue 13.26 12.05 12.27 10.80 11.07 10.54 8.42 9.15 6.35 6.32 5.47 3.13 0.0 0.0 0.0 0.0
MSFT depreciationToRevenue 6.54 7.29 6.95 8.95 9.28 9.30 9.09 7.26 6.37 6.00 4.82 4.02 0.0 0.0 0.0 0.0
MSFT sbcToRevenue 4.54 3.78 3.64 3.70 3.70 3.57 3.38 2.93 2.75 2.82 3.09 3.04 0.0 0.0 0.0 0.0
MSFT sbcToOperatingCashflow 10.97 8.43 7.97 8.72 8.91 8.98 8.27 8.01 8.68 7.53 8.34 7.10 0.0 0.0 0.0 0.0
MSFT inventory 2.50B 3.74B 2.64B 1.90B 2.06B 2.66B 2.18B 2.25B 2.90B 2.66B 1.94B 0.0 0.0 0.0 0.0 0.0
MSFT payables 18.09B 19.00B 15.16B 12.53B 9.38B 8.62B 7.39B 6.90B 6.59B 7.43B 4.83B 0.0 0.0 0.0 0.0 0.0
MSFT receivables 48.69B 44.26B 38.04B 32.01B 29.52B 26.48B 22.43B 18.28B 17.91B 19.54B 17.49B 0.0 0.0 0.0 0.0 0.0
MSFT inventoryTurnover 17.60 23.77 27.56 22.34 16.12 17.59 15.22 11.30 12.42 13.97 10.52 inf 0.0 0.0 0.0 0.0
MSFT inventoryToRevenue 0.02 0.01 0.01 0.01 0.02 0.02 0.02 0.03 0.03 0.02 0.02 0.0 0.0 0.0 0.0 0.0
MSFT payablesToRevenue 0.09 0.08 0.07 0.07 0.07 0.07 0.07 0.07 0.08 0.06 0.06 0.0 0.0 0.0 0.0 0.0
MSFT receivablesToRevenue 0.21 0.19 0.19 0.21 0.21 0.20 0.19 0.20 0.21 0.20 0.22 0.0 0.0 0.0 0.0 0.0
MSFT opLeverage -0.72 1.30 14.49 9.63 8.51 6.51 5.36 46.18 -42.35 -7.82 17.38 0.0 0.0 0.0 0.0 0.0
MSFT opLeverageFlag 0.0 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.0 0.0 1.00 0.0 0.0 0.0 0.0 0.0
MSFT evToEbitda 27.31 18.99 31.54 25.66 22.33 17.76 18.10 14.66 17.35 10.67 9.13 7.51 0.0 0.0 0.0 0.0
MSFT evToOpIncome 31.59 22.28 36.81 31.86 28.40 22.96 23.58 18.39 23.04 12.68 10.41 8.53 0.0 0.0 0.0 0.0
MSFT evToRevenue 13.20 9.37 15.31 11.80 9.70 7.29 7.09 5.26 4.47 4.05 3.58 2.52 0.0 0.0 0.0 0.0
MSFT evToOcf 31.93 20.86 33.53 27.81 23.38 18.34 17.32 14.39 14.11 10.83 9.66 5.87 0.0 0.0 0.0 0.0
MSFT pocf 31.79 19.90 32.96 26.99 22.22 16.87 15.56 13.24 13.27 10.38 9.25 5.87 0.0 0.0 0.0 0.0
MSFT peg 183.19 1.25 1.04 2.66 0.21 0.0 0.89 0.29 0.0 7.96 0.42 0.0 0.0 0.0 0.0 0.0
MSFT pe 38.47 24.36 41.28 36.98 29.55 44.69 24.12 21.48 32.30 15.29 12.20 10.94 0.0 0.0 0.0 0.0
MSFT pfcf 46.81 27.20 45.07 36.20 30.30 22.96 19.59 17.66 16.60 12.49 10.86 6.33 0.0 0.0 0.0 0.0
MSFT ps 13.14 8.94 15.05 11.45 9.21 6.71 6.37 4.84 4.21 3.89 3.43 2.52 0.0 0.0 0.0 0.0
MSFT pb 13.50 10.64 17.81 13.84 11.33 8.95 7.01 6.13 4.92 3.76 3.38 inf 0.0 0.0 0.0 0.0
MSFT priceToRealfcf 55.83 30.74 50.59 41.00 34.50 26.15 21.87 19.77 18.62 13.73 12.03 6.86 0.0 0.0 0.0 0.0
MSFT roa 24.26% 24.98% 23.20% 18.48% 16.60% 14.01% 14.98% 14.80% 10.54% 19.49% 0.0 0.0 0.0 0.0 0.0 0.0
MSFT roa_goodwill 29.77% 29.35% 27.10% 21.66% 19.25% 16.29% 16.51% 16.37% 11.93% 21.72% 0.0 0.0 0.0 0.0 0.0 0.0
MSFT roe 53.15% 58.73% 59.10% 51.75% 51.93% 39.97% 40.31% 32.56% 20.23% 35.16% 0.0 0.0 0.0 0.0 0.0 0.0
MSFT roce 33.27% 41.66% 38.49% 30.35% 27.03% 21.27% 24.85% 23.62% 16.08% 29.36% 0.0 0.0 0.0 0.0 0.0 0.0
MSFT roic 85.61% 97.83% 106.70% 90.25% 85.94% 85.60% 90.74% 90.08% 65.37% 112.90% 108.85% inf 0.0 0.0 0.0 0.0
MSFT rotc 118.99% 139.63% 158.36% 145.18% 145.82% 147.71% 158.12% 177.03% 139.58% 277.84% 0.0 0.0 0.0 0.0 0.0 0.0
MSFT roic_cash 85.38% 97.51% 106.26% 89.90% 85.53% 85.28% 90.37% 89.73% 64.96% 112.55% 108.52% inf 0.0 0.0 0.0 0.0
MSFT roa_cfo 24.01% 26.67% 25.47% 21.17% 20.16% 17.53% 20.40% 18.91% 17.21% 22.82% 0.0 0.0 0.0 0.0 0.0 0.0
MSFT roe_cfo 52.59% 62.71% 64.87% 59.29% 63.09% 50.03% 54.87% 41.61% 33.04% 41.17% 0.0 0.0 0.0 0.0 0.0 0.0
MSFT roce_cfo 32.91% 44.49% 42.25% 34.77% 32.83% 26.62% 33.83% 30.19% 26.27% 34.38% 0.0 0.0 0.0 0.0 0.0 0.0
MSFT roic_cfo 84.70% 104.46% 117.11% 103.40% 104.40% 107.15% 123.51% 115.11% 106.78% 132.19% 117.27% inf 0.0 0.0 0.0 0.0
MSFT roic_cashflow::operating_cash 84.47% 104.12% 116.63% 103.00% 103.90% 106.75% 123.01% 114.67% 106.12% 131.78% 116.91% inf 0.0 0.0 0.0 0.0
MSFT roic_cashflow::fcf 57.52% 76.44% 85.64% 77.08% 76.54% 78.75% 98.10% 86.29% 85.39% 109.88% 99.96% inf 0.0 0.0 0.0 0.0
MSFT roic_cashflow::fcf_cash 57.36% 76.18% 85.29% 76.79% 76.18% 78.45% 97.70% 85.96% 84.86% 109.54% 99.65% inf 0.0 0.0 0.0 0.0
MSFT roic_cashflow::realfcf 48.22% 67.64% 76.30% 68.07% 67.23% 69.13% 87.89% 77.08% 76.13% 99.93% 90.17% inf 0.0 0.0 0.0 0.0
MSFT roic_cashflow::realfcf_cash 48.09% 67.41% 75.99% 67.81% 66.91% 68.87% 87.53% 76.78% 75.65% 99.63% 89.89% inf 0.0 0.0 0.0 0.0
MSFT roic_income::net 69.98% 85.34% 93.50% 75.46% 78.50% 40.46% 79.69% 70.95% 43.89% 89.78% 88.92% inf 0.0 0.0 0.0 0.0
MSFT roic_income::net_cash 69.79% 85.06% 93.12% 75.17% 78.13% 40.31% 79.36% 70.67% 43.61% 89.50% 88.65% inf 0.0 0.0 0.0 0.0
MSFT rotc_cfo 117.72% 149.10% 173.81% 166.34% 177.14% 184.90% 215.23% 226.22% 228.02% 325.31% 0.0 0.0 0.0 0.0 0.0 0.0
MSFT roic_owner_earnings 62.00% 78.70% 89.94% 72.58% 71.72% 72.48% 87.89% 83.02% 76.13% 101.05% 92.21% inf 0.0 0.0 0.0 0.0
MSFT roic_owner_earnings_cash 61.83% 78.43% 89.57% 72.30% 71.38% 72.21% 87.53% 82.70% 75.65% 100.73% 91.93% inf 0.0 0.0 0.0 0.0
MSFT margin_owner_earnings 30.25% 33.83% 35.06% 29.78% 28.49% 26.90% 29.11% 26.37% 22.60% 28.61% 29.12% 36.73% 0.0 0.0 0.0 0.0
MSFT margin_cfo 41.33% 44.91% 45.65% 42.43% 41.47% 39.76% 40.91% 36.56% 31.70% 37.43% 37.04% 42.90% 0.0 0.0 0.0 0.0
MSFT margin_op 41.77% 42.06% 41.59% 37.03% 34.14% 31.77% 30.06% 28.61% 19.41% 31.97% 34.38% 29.52% 0.0 0.0 0.0 0.0
MSFT margin_fcf 28.07% 32.86% 33.39% 31.63% 30.40% 29.22% 32.49% 27.41% 25.35% 31.11% 31.57% 39.77% 0.0 0.0 0.0 0.0
MSFT margin_fcf_real 23.53% 29.07% 29.75% 27.93% 26.71% 25.65% 29.11% 24.48% 22.60% 28.30% 28.48% 36.73% 0.0 0.0 0.0 0.0
MSFT margin_net 34.15% 36.69% 36.45% 30.96% 31.18% 15.02% 26.39% 22.53% 13.03% 25.42% 28.08% 23.03% 0.0 0.0 0.0 0.0
MSFT yield_owner_earnings 2.30% 3.79% 2.33% 2.60% 3.09% 4.01% 4.57% 5.45% 5.37% 7.36% 8.50% 14.58% 0.0 0.0 0.0 0.0
MSFT yield_owner_earnings_enterprise inf inf inf inf inf inf inf inf inf inf inf inf 0.0 0.0 0.0 0.0
MSFT yield_cfo 3.15% 5.02% 3.03% 3.71% 4.50% 5.93% 6.43% 7.55% 7.53% 9.63% 10.81% 17.03% 0.0 0.0 0.0 0.0
MSFT yield_cfo_ev 3.13% 4.79% 2.98% 3.60% 4.28% 5.45% 5.77% 6.95% 7.09% 9.23% 10.35% 17.03% 0.0 0.0 0.0 0.0
MSFT yield_income::operating 3.18% 4.71% 2.76% 3.23% 3.71% 4.73% 4.72% 5.91% 4.61% 8.23% 10.03% 11.72% 0.0 0.0 0.0 0.0
MSFT yield_income::operating_enterprise 3.17% 4.49% 2.72% 3.14% 3.52% 4.36% 4.24% 5.44% 4.34% 7.89% 9.61% 11.72% 0.0 0.0 0.0 0.0
MSFT yield_cashflow::fcf 2.14% 3.68% 2.22% 2.76% 3.30% 4.36% 5.10% 5.66% 6.02% 8.01% 9.21% 15.79% 0.0 0.0 0.0 0.0
MSFT yield_cashflow::fcf_enterprise 2.13% 3.51% 2.18% 2.68% 3.14% 4.01% 4.59% 5.21% 5.67% 7.68% 8.82% 15.79% 0.0 0.0 0.0 0.0
MSFT yield_cashflow::realfcf 1.79% 3.25% 1.98% 2.44% 2.90% 3.82% 4.57% 5.06% 5.37% 7.28% 8.31% 14.58% 0.0 0.0 0.0 0.0
MSFT yield_cashflow::realfcf_enterprise 1.78% 3.10% 1.94% 2.37% 2.75% 3.52% 4.11% 4.65% 5.05% 6.98% 7.96% 14.58% 0.0 0.0 0.0 0.0
MSFT yield_income::net 2.60% 4.10% 2.42% 2.70% 3.38% 2.24% 4.15% 4.66% 3.10% 6.54% 8.19% 9.14% 0.0 0.0 0.0 0.0
MSFT yield_income::net_enterprise 2.59% 3.92% 2.38% 2.62% 3.22% 2.06% 3.72% 4.28% 2.91% 6.27% 7.85% 9.14% 0.0 0.0 0.0 0.0
MSFT costs:ga 7.58B 5.90B 5.11B 5.11B 4.88B 4.75B 4.48B 4.56B 4.61B 4.82B 5.15B 4.57B 0.0 0.0 0.0 0.0
MSFT costs:rnd 27.20B 24.51B 20.72B 19.27B 16.88B 14.73B 13.04B 11.99B 12.05B 11.38B 10.41B 9.81B 0.0 0.0 0.0 0.0
MSFT costs:sm 22.76B 21.82B 20.12B 19.60B 18.21B 17.47B 15.54B 14.70B 15.71B 15.81B 15.28B 13.86B 0.0 0.0 0.0 0.0
MSFT shares_buyback -22.25B -32.70B -27.39B -22.97B -19.54B -10.72B -11.79B -15.97B -14.44B -7.32B -5.36B -5.03B 0.0 0.0 0.0 0.0
MSFT dividends -19.80B -18.14B -16.52B -15.14B -13.81B -12.70B -11.85B -11.01B -9.88B -8.88B -7.46B -6.38B 0.0 0.0 0.0 0.0
MSFT goodwill 67.89B 67.52B 49.71B 43.35B 42.03B 35.68B 35.12B 17.87B 16.94B 20.13B 14.65B 0.0 0.0 0.0 0.0 0.0
MSFT costs:sgna 7.58B 5.90B 5.11B 5.11B 4.88B 4.75B 4.48B 4.56B 4.61B 4.82B 5.15B 4.57B 0.0 0.0 0.0 0.0
MSFT investedCapital 103.40B 85.23B 65.53B 58.68B 49.99B 40.96B 31.99B 28.95B 27.78B 24.59B 24.59B 0.0 0.0 0.0 0.0 0.0
MSFT investedCapitalWith2PercentCash 103.68B 85.52B 65.80B 58.91B 50.22B 41.11B 32.12B 29.06B 27.96B 24.66B 24.66B 0.0 0.0 0.0 0.0 0.0
MSFT priceToTangibleEquity 20.12 17.90 27.41 21.85 19.23 15.74 11.69 8.15 6.24 4.84 4.15 inf 0.0 0.0 0.0 0.0
MSFT revenue_01_YoY 6.88% 17.96% 17.53% 13.65% 14.03% 14.28% 5.94% -2.59% 7.77% 11.54% 5.60% 0.0 0.0 0.0 0.0 0.0
MSFT revenue_03_YoY 14.01% 16.36% 15.06% 13.98% 11.35% 5.65% 3.61% 5.40% 8.27% 0.0 0.0 0.0 0.0 0.0 0.0 0.0
MSFT revenue_05_YoY 13.94% 15.47% 13.02% 8.85% 7.70% 7.23% 5.55% 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
MSFT share_cnt 7.43B 7.45B 7.66B 7.56B 7.63B 7.68B 7.70B 7.78B 7.99B 0.0 0.0 0.0 0.0 0.0 0.0 0.0
MSFT share_multiplier 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.0 0.0 0.0 0.0
MSFT tangible_equity 138.34B 99.02B 92.28B 74.95B 60.30B 47.03B 52.59B 54.12B 63.14B 69.66B 64.29B 0.0 0.0 0.0 0.0 0.0
MSFT cashflow::fcf_01_YoY -8.71% 16.09% 24.06% 18.23% 18.63% 2.79% 25.60% 5.30% -12.19% 9.93% -16.18% 0.0 0.0 0.0 0.0 0.0
MSFT cashflow::fcf_03_YoY 9.55% 19.41% 20.28% 12.97% 15.27% 10.78% 5.11% 0.55% inf 0.0 0.0 0.0 0.0 0.0 0.0 0.0
MSFT cashflow::fcf_05_YoY 13.02% 15.73% 17.57% 13.78% 7.21% 5.59% 1.37% 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
MSFT cashflow::financing -43.94B -58.88B -48.49B -46.03B -36.89B -33.59B 8.41B -8.39B -9.08B -8.39B -8.15B -9.41B 0.0 0.0 0.0 0.0
MSFT cashflow::investing -22.68B -30.31B -27.58B -12.22B -15.77B -6.06B -46.78B -23.95B -23.00B -18.83B -23.81B -24.79B 0.0 0.0 0.0 0.0
MSFT cashflow::realfcf_01_YoY -13.50% 15.29% 25.17% 18.86% 18.71% 0.71% 25.98% 5.50% -13.92% 10.83% -18.12% 0.0 0.0 0.0 0.0 0.0
MSFT cashflow::realfcf_03_YoY 7.67% 19.70% 20.87% 12.42% 14.63% 10.21% 4.59% 0.22% inf 0.0 0.0 0.0 0.0 0.0 0.0 0.0
MSFT cashflow::realfcf_05_YoY 11.99% 15.45% 17.51% 13.56% 6.46% 5.01% 0.75% 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
MSFT income::net_01_YoY -0.52% 18.72% 38.37% 12.85% 136.80% -34.99% 24.10% 68.45% -44.76% 0.97% 28.77% 0.0 0.0 0.0 0.0 0.0
MSFT income::net_03_YoY 17.79% 22.84% 54.63% 20.21% 24.08% 10.77% 4.91% inf inf 0.0 0.0 0.0 0.0 0.0 0.0 0.0
MSFT income::net_05_YoY 34.29% 23.33% 24.43% 29.43% 12.19% inf 8.47% 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
MSFT income::operating_01_YoY 6.16% 19.26% 32.02% 23.28% 22.54% 20.79% 11.30% 43.59% -34.58% 3.72%