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


5

Total Checks Done


23

Wall Street Drivers beta

📊 Professional Investors(wallstreet) pay a lot of heed at these numbers, long term history matters - specially 9+ year trends
Score 8.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
  • 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
  • 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

Business Durability beta

🏰 Quality companies with moats show higher or stable trends, long term trends matters, Consistency is the Key
Score 10.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']
  • 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

Business Trends last 3 years beta

Score 5.0 / 10.0

  • capex running_sum for last 3 years
  • insight: ['trend is higher, last 3 year ratio: 0.13 wrt mean ratio: 0.092']
  • 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

Capital Allocation beta

🧠 Remember: Shareholders only gets rewarded if management does prudent capital allocation decisions
Score 8.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
  • 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 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']
  • 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

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 SPECIAL_REPORT 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
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
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
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
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
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
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
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
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
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
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
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
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
MSFT owner_earningsToInterest inf inf inf inf inf inf inf inf inf inf inf inf
MSFT cashflow::operatingToInterest inf inf inf inf inf inf inf inf inf inf inf inf
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
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
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
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
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
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. Vertical Data, ratio wrt to shares_calc 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
MSFT StockMarketPrice
MSFT revenue 28.51 26.60 21.95 18.92 16.50 14.37 12.54 11.72 11.72 10.34 9.19 8.67
MSFT cash 4.67 1.87 1.86 1.80 1.49 1.56 1.00 0.84 0.70 1.03 0.45 0.0
MSFT ppnenet 12.87 9.98 7.80 5.84 4.78 3.84 3.08 2.36 1.84 1.55 1.18 0.0
MSFT owner_earnings 8.63 9.00 7.70 5.63 4.70 3.87 3.65 3.09 2.65 2.96 2.68 3.18
MSFT cashflow::operating 11.78 11.94 10.02 8.03 6.84 5.72 5.13 4.29 3.71 3.87 3.40 3.72
MSFT grossincome 19.65 18.19 15.13 12.82 10.87 9.38 8.09 7.51 7.58 7.13 6.80 6.61
MSFT marketcap 374.58 237.71 330.27 216.60 151.97 96.45 79.85 56.74 49.30 40.18 31.50 21.83
MSFT ev 376.27 249.20 336.00 223.18 159.94 104.82 88.87 61.66 52.39 41.90 32.89 21.83
MSFT ebitda 13.78 13.13 10.65 8.70 7.16 5.90 4.91 4.21 3.02 3.93 3.60 2.91
MSFT equity 27.75 22.34 18.54 15.65 13.41 10.77 11.39 9.26 10.03 10.69 9.32 0.0
MSFT debt 6.36 13.36 7.59 8.38 9.46 9.93 10.02 5.76 3.79 2.76 1.84 0.0
MSFT owner_earningsToInterest 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01
MSFT cashflow::operatingToInterest 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01
MSFT shares 1.01 1.01 0.99 1.01 1.01 1.00 1.01 1.02 1.02 1.00 1.00 1.00
MSFT shares_calc 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00
MSFT capex 3.78 3.20 2.69 2.04 1.83 1.52 1.06 1.07 0.74 0.65 0.50 0.27
MSFT depreciation 1.86 1.94 1.53 1.69 1.53 1.34 1.14 0.85 0.75 0.62 0.44 0.35
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. Vertical Data, ratio wrt to revenue 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
MSFT StockMarketPrice
MSFT revenue 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
MSFT cash 16.38% 7.03% 8.46% 9.49% 9.02% 10.82% 7.94% 7.14% 5.98% 9.98% 4.89% 0.0
MSFT ppnenet 45.13% 37.52% 35.53% 30.87% 28.99% 26.69% 24.58% 20.14% 15.74% 14.98% 12.83% 0.0
MSFT 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%
MSFT cashflow::operating 41.33% 44.91% 45.65% 42.43% 41.47% 39.76% 40.91% 36.56% 31.70% 37.43% 37.04% 42.90%
MSFT grossincome 68.92% 68.40% 68.93% 67.78% 65.90% 65.25% 64.52% 64.04% 64.70% 68.98% 73.99% 76.22%
MSFT marketcap 1313.72% 893.73% 1504.81% 1145.06% 921.27% 670.98% 636.66% 483.99% 420.82% 388.64% 342.72% 251.87%
MSFT ev 1319.64% 936.92% 1530.94% 1179.85% 969.60% 729.24% 708.58% 525.97% 447.23% 405.31% 357.87% 251.87%
MSFT ebitda 48.31% 49.35% 48.55% 45.98% 43.42% 41.06% 39.15% 35.87% 25.77% 37.97% 39.20% 33.54%
MSFT equity 97.31% 84.00% 84.47% 82.72% 81.32% 74.95% 90.83% 78.98% 85.58% 103.40% 101.41% 0.0
MSFT debt 22.29% 50.22% 34.59% 44.28% 57.36% 69.08% 79.86% 49.13% 32.39% 26.65% 20.04% 0.0
MSFT owner_earningsToInterest 0.05% 0.05% 0.06% 0.07% 0.08% 0.09% 0.10% 0.11% 0.11% 0.12% 0.13% 0.14%
MSFT cashflow::operatingToInterest 0.05% 0.05% 0.06% 0.07% 0.08% 0.09% 0.10% 0.11% 0.11% 0.12% 0.13% 0.14%
MSFT shares 3.53% 3.80% 4.53% 5.32% 6.10% 6.98% 8.02% 8.69% 8.74% 9.67% 10.88% 11.54%
MSFT shares_calc 3.51% 3.76% 4.56% 5.29% 6.06% 6.96% 7.97% 8.53% 8.54% 9.67% 10.88% 11.54%
MSFT capex 13.26% 12.05% 12.27% 10.80% 11.07% 10.54% 8.42% 9.15% 6.35% 6.32% 5.47% 3.13%
MSFT depreciation 6.54% 7.29% 6.95% 8.95% 9.28% 9.30% 9.09% 7.26% 6.37% 6.00% 4.82% 4.02%
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. Vertical Data, ratio wrt to ppnenet 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
MSFT StockMarketPrice
MSFT revenue 221.57% 266.50% 281.48% 323.92% 344.99% 374.61% 406.89% 496.59% 635.26% 667.38% 779.19%
MSFT cash 36.29% 18.72% 23.82% 30.75% 31.13% 40.55% 32.29% 35.47% 37.98% 66.63% 38.07%
MSFT ppnenet 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
MSFT owner_earnings 67.03% 90.15% 98.70% 96.46% 98.28% 100.76% 118.45% 130.94% 143.57% 190.95% 226.92%
MSFT cashflow::operating 91.57% 119.67% 128.51% 137.43% 143.06% 148.96% 166.46% 181.55% 201.40% 249.80% 288.59%
MSFT grossincome 152.71% 182.29% 194.01% 219.56% 227.36% 244.42% 262.53% 318.01% 410.98% 460.37% 576.52%
MSFT marketcap 2910.86% 2381.79% 4235.80% 3709.10% 3178.30% 2513.56% 2590.50% 2403.43% 2673.30% 2593.74% 2670.45%
MSFT ev 2923.96% 2496.89% 4309.35% 3821.78% 3345.05% 2731.81% 2883.15% 2611.92% 2841.06% 2704.99% 2788.52%
MSFT ebitda 107.05% 131.51% 136.65% 148.93% 149.80% 153.83% 159.28% 178.14% 163.72% 253.41% 305.46%
MSFT equity 215.62% 223.85% 237.78% 267.95% 280.53% 280.78% 369.56% 392.23% 543.64% 690.06% 790.15%
MSFT debt 49.39% 133.82% 97.37% 143.43% 197.87% 258.79% 324.94% 243.96% 205.74% 177.88% 156.14%
MSFT owner_earningsToInterest 0.10% 0.13% 0.17% 0.23% 0.27% 0.34% 0.42% 0.54% 0.68% 0.77% 1.00%
MSFT cashflow::operatingToInterest 0.10% 0.13% 0.17% 0.23% 0.27% 0.34% 0.42% 0.54% 0.68% 0.77% 1.00%
MSFT shares 7.81% 10.13% 12.74% 17.24% 21.04% 26.14% 32.64% 43.17% 55.51% 64.55% 84.78%
MSFT shares_calc 7.77% 10.02% 12.83% 17.12% 20.91% 26.06% 32.44% 42.36% 54.23% 64.55% 84.78%
MSFT capex 29.39% 32.11% 34.53% 34.97% 38.17% 39.48% 34.25% 45.45% 40.35% 42.16% 42.61%
MSFT depreciation 14.49% 19.44% 19.57% 28.98% 32.03% 34.83% 36.98% 36.08% 40.44% 40.06% 37.58%
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...