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%
[Bottom of Page]

We have 4 report results for ticker: MSFT - Microsoft Corporation, also organized by 1 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


20

Total Checks Done


51

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
  • 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_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

Business Trends last 3 years beta

Score 8.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

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 3.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']

Business Performance beta

Score 5.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']
  • 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

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 CASHFLOW_COMPARE_DETAIL 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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_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_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 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 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
General notes:
Caution:: 0 value in revenue means we do not have data for the year for the ticker
0 value most likely means we had a data issue and could not find the field value in the particular year
StockMarketPrice is the price of the Stock in December first week for the year mentioned(typically)

2. CAGR report Showing CASHFLOW_COMPARE_DETAIL report for MSFT 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 CAGR_9Y_ENDING_2023 CAGR_5Y_ENDING_2023 CAGR_3Y_ENDING_2023
MSFT StockMarketPrice 28.15% 31.17% 20.03%
MSFT YearPriceHigh 25.42% 27.03% 18.17%
MSFT YearPriceLow 22.77% 21.21% 18.29%
MSFT revenue 10.42% 13.94% 14.01%
MSFT assets 10.16% 9.74% 10.99%
MSFT ppnenet 24.81% 26.56% 29.39%
MSFT cashflow::operating 11.64% 14.82% 13.01%
MSFT netincome 14.10% 34.29% 17.79%
MSFT operatingincome 13.75% 20.35% 18.68%
MSFT marketcap 26.42% 30.33% 19.35%
MSFT ev 25.90% 28.29% 18.34%
MSFT equity 9.68% 20.05% 20.35%
MSFT debt 8.25% -9.13% -9.31%
MSFT shares_calc -1.35% -0.65% -0.57%
MSFT income_tax 12.77% -3.16% 24.63%
MSFT sbc 16.42% 19.52% 22.03%
MSFT capex 19.91% 19.30% 22.10%
MSFT depreciation 11.48% 6.20% 2.70%
MSFT inventory -0.69% -1.25% 9.68%
MSFT payables 10.39% 16.00% 13.03%
MSFT receivables 10.67% 12.95% 15.00%
MSFT opLeverage 30.35% -38.14% -59.78%
MSFT opLeverageFlag 0.0 inf inf
MSFT evToEbitda 11.01% 8.99% 2.10%
MSFT evToOpIncome 10.67% 6.59% -0.28%
MSFT evToOcf 12.77% 11.73% 4.71%
MSFT pocf 13.24% 13.51% 5.61%
MSFT pe 10.80% -2.95% 1.33%
MSFT ps 14.48% 14.39% 4.70%
MSFT pb 15.26% 8.57% -0.83%
MSFT roa_cfo 0.57% 6.49% 4.29%
MSFT roe_cfo 2.76% 1.00% -3.92%
MSFT roce_cfo -0.48% 4.33% -1.82%
MSFT roic_cfo -4.83% -4.59% -6.43%
MSFT rotc_cfo -10.68% -8.63% -10.88%
MSFT margin_cfo 1.11% 0.78% -0.87%
MSFT margin_op 3.02% 5.63% 4.10%
MSFT margin_net 3.33% 17.85% 3.32%
MSFT yield_cfo -11.68% -11.88% -5.31%
MSFT yield_cfo_ev -11.32% -10.50% -4.56%
MSFT costs:rnd 10.16% 13.05% 12.17%
MSFT costs:sm 4.13% 5.43% 5.11%
MSFT goodwill 14.46% 13.73% 16.13%
General notes:
Caution:: 0 value in revenue means we do not have data for the year for the ticker
0 value most likely means we had a data issue and could not find the field value in the particular year
StockMarketPrice is the price of the Stock in December first week for the year mentioned(typically)

3. Rolling 5 yearly CAGR report Showing CASHFLOW_COMPARE_DETAIL report for MSFT 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 CAGR_5Y_2023 CAGR_5Y_2022 CAGR_5Y_2021 CAGR_5Y_2020 CAGR_5Y_2019 CAGR_5Y_2018 CAGR_5Y_2017 CAGR_5Y_2016 CAGR_5Y_2015 CAGR_5Y_2014 CAGR_5Y_2013
MSFT ppnenet 26.56% 25.67% 26.61% 24.55% 22.90% 24.14% inf inf inf inf inf
MSFT cashflow::operating 14.82% 17.65% 18.15% 15.38% 9.93% 8.76% 4.55% inf inf inf inf
MSFT netincome 34.29% 23.33% 24.43% 29.43% 12.19% -5.39% 8.47% inf inf inf inf
MSFT operatingincome 20.35% 23.50% 21.80% 23.87% 9.13% 5.55% 5.93% inf inf inf inf
MSFT marketcap 30.33% 23.58% 41.80% 32.98% 28.00% 22.65% 27.06% inf inf inf inf
MSFT ev 28.29% 22.11% 39.94% 32.16% 28.23% 23.63% 29.81% inf inf inf inf
MSFT equity 20.05% 13.68% 14.55% 8.12% 2.65% 0.94% inf inf inf inf inf
MSFT debt -9.13% 5.24% 5.36% 15.88% 25.54% 37.34% inf inf inf inf inf
MSFT shares_calc -0.65% -0.65% -0.30% -1.09% -1.91% -1.95% -1.97% inf inf inf inf
MSFT income_tax -3.16% 20.00% 14.03% 6.76% -4.99% 30.85% -3.56% inf inf inf inf
MSFT sbc 19.52% 18.10% 18.06% 15.49% 13.72% 10.37% 7.80% inf inf inf inf
MSFT capex 19.30% 24.06% 19.84% 21.04% 20.48% 22.27% 28.67% inf inf inf inf
MSFT depreciation 6.20% 10.50% 12.03% 16.52% 17.52% 22.27% 24.23% inf inf inf inf
MSFT inventory -1.25% 11.40% 3.21% -8.17% -4.96% 6.55% inf inf inf inf inf
MSFT payables 16.00% 20.79% 17.06% 13.71% 4.77% 12.28% inf inf inf inf inf
MSFT receivables 12.95% 14.56% 15.79% 12.32% 8.60% 8.65% inf inf inf inf inf
MSFT opLeverage -38.14% -24.67% -20.69% 17.37% 25.30% -17.83% inf inf inf inf inf
MSFT opLeverageFlag inf 0.0 0.0 inf inf 0.0 inf inf 0.0 0.0 inf
MSFT evToEbitda 8.99% 0.96% 16.56% 8.14% 15.92% 14.23% 19.24% inf inf inf inf
MSFT evToOpIncome 6.59% -1.13% 14.89% 6.70% 17.50% 17.14% 22.55% inf inf inf inf
MSFT evToOcf 11.73% 3.79% 18.43% 14.53% 16.64% 13.68% 24.16% inf inf inf inf
MSFT pocf 13.51% 5.04% 20.01% 15.26% 16.44% 12.77% 21.53% inf inf inf inf
MSFT pe -2.95% 0.20% 13.96% 2.74% 14.09% 29.65% 17.13% inf inf inf inf
MSFT ps 14.39% 7.01% 25.47% 22.15% 18.81% 14.36% 20.38% inf inf inf inf
MSFT pb 8.57% 8.70% 23.78% 22.98% 24.68% 21.50% -96.29% inf inf inf inf
MSFT roa_cfo 6.49% 5.51% 6.14% 4.23% -2.45% inf inf inf inf inf 0.0
MSFT roe_cfo 1.00% 2.71% 9.29% 12.41% 8.91% inf inf inf inf inf 0.0
MSFT roce_cfo 4.33% 5.63% 6.95% 5.77% -0.92% inf inf inf inf inf 0.0
MSFT roic_cfo -4.59% -3.29% 0.35% -0.64% -4.61% -1.79% -93.42% inf inf inf inf
MSFT rotc_cfo -8.63% -7.08% -5.13% -6.11% -11.45% inf inf inf inf inf 0.0
MSFT margin_cfo 0.78% 1.88% 4.54% 6.00% 2.07% 1.43% -0.95% inf inf inf inf
MSFT margin_op 5.63% 6.95% 7.77% 13.79% 1.32% -1.57% 0.36% inf inf inf inf
MSFT margin_net 17.85% 6.81% 10.10% 18.90% 4.17% -11.76% 2.76% inf inf inf inf
MSFT yield_cfo -11.88% -4.83% -16.69% -13.20% -14.12% -11.32% -17.70% inf inf inf inf
MSFT yield_cfo_ev -10.50% -3.65% -15.58% -12.68% -14.25% -12.04% -19.46% inf inf inf inf
MSFT costs:rnd 13.05% 13.46% 11.56% 9.85% 8.20% 7.18% 5.85% inf inf inf inf
MSFT costs:sm 5.43% 7.03% 6.48% 4.52% 2.87% 2.72% 2.32% inf inf inf inf
MSFT goodwill 13.73% 13.97% 22.70% 20.68% 15.86% 19.48% inf inf inf inf inf
General notes:
Caution:: 0 value in revenue means we do not have data for the year for the ticker
0 value most likely means we had a data issue and could not find the field value in the particular year
StockMarketPrice is the price of the Stock in December first week for the year mentioned(typically)

4. Rolling 9 yearly CAGR report Showing CASHFLOW_COMPARE_DETAIL report for MSFT 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 CAGR_9Y_2023 CAGR_9Y_2022 CAGR_9Y_2021 CAGR_9Y_2020 CAGR_9Y_2019 CAGR_9Y_2018 CAGR_9Y_2017
MSFT marketcap 26.42% 23.41% 33.67% inf inf inf inf
MSFT ev 25.90% 23.47% 33.92% inf inf inf inf
MSFT equity 9.68% 8.65% inf inf inf inf inf
MSFT debt 8.25% 22.87% inf inf inf inf inf
MSFT shares_calc -1.35% -1.41% -1.16% inf inf inf inf
MSFT income_tax 12.77% 8.68% 7.13% inf inf inf inf
MSFT sbc 16.42% 13.47% 11.79% inf inf inf inf
MSFT capex 19.91% 21.12% 27.57% inf inf inf inf
MSFT depreciation 11.48% 16.16% 16.45% inf inf inf inf
MSFT inventory -0.69% 7.58% inf inf inf inf inf
MSFT payables 10.39% 16.44% inf inf inf inf inf
MSFT receivables 10.67% 10.87% inf inf inf inf inf
MSFT opLeverage 30.35% -25.03% inf inf inf inf inf
MSFT opLeverageFlag 0.0 0.0 inf inf inf inf inf
MSFT evToEbitda 11.01% 8.48% 17.29% inf inf inf inf
MSFT evToOpIncome 10.67% 8.82% 17.64% inf inf inf inf
MSFT evToOcf 12.77% 8.93% 21.36% inf inf inf inf
MSFT pocf 13.24% 8.88% 21.13% inf inf inf inf
MSFT pe 10.80% 7.99% 15.90% inf inf inf inf
MSFT ps 14.48% 11.23% 21.97% inf inf inf inf
MSFT pb 15.26% 13.59% -82.21% inf inf inf inf
MSFT roa_cfo 0.57% inf inf inf inf inf inf
MSFT roe_cfo 2.76% inf inf inf inf inf inf
MSFT roce_cfo -0.48% inf inf inf inf inf inf
MSFT roic_cfo -4.83% -1.28% -78.07% inf inf inf inf
MSFT rotc_cfo -10.68% inf inf inf inf inf inf
MSFT margin_cfo 1.11% 2.16% 0.69% inf inf inf inf
MSFT margin_op 3.02% 2.27% 3.88% inf inf inf inf
MSFT margin_net 3.33% 3.02% 5.23% inf inf inf inf
MSFT yield_cfo -11.68% -8.17% -17.45% inf inf inf inf
MSFT yield_cfo_ev -11.32% -8.20% -17.61% inf inf inf inf
MSFT costs:rnd 10.16% 9.98% 8.66% inf inf inf inf
MSFT costs:sm 4.13% 4.04% 4.23% inf inf inf inf
MSFT goodwill 14.46% 18.50% inf inf inf inf inf
General notes:
Caution:: 0 value in revenue means we do not have data for the year for the ticker
0 value most likely means we had a data issue and could not find the field value in the particular year
StockMarketPrice is the price of the Stock in December first week for the year mentioned(typically)


Want to explore further, try these wonderful companies below or Use Search to find your favorite company or Check out our list of curated stocks here: Curated Stock List(new)

Join the 1,000+ Sleep Well Investors friends simplifying their investing decisions with SecDiver.com and SleepWellInvesting 🛌

*No account required, We promise to be respectful of your time and never spam you...