Grufity logoGrufity logo
StocksFundsSearch Filings

Microsoft Corp Stock Research

MSFT

332.89USD+6.97(+2.14%)Market Closed

Market Summary

USD332.89+6.97
Market Closed
2.14%

MSFT Alerts

MSFT Stock Price

MSFT RSI Chart

MSFT Valuation

Market Cap

2.5T

Price/Earnings (Trailing)

35.87

Price/Sales (Trailing)

11.93

EV/EBITDA

28.79

Price/Free Cashflow

43.13

MSFT Price/Sales (Trailing)

MSFT Profitability

EBT Margin

40.47%

Return on Equity

36.83%

Return on Assets

18.5%

Free Cashflow Yield

2.32%

MSFT Fundamentals

MSFT Revenue

Revenue (TTM)

207.6B

Revenue Y/Y

7.08%

Revenue Q/Q

0.21%

MSFT Earnings

Earnings (TTM)

69.0B

Earnings Y/Y

9.39%

Earnings Q/Q

11.41%

Price Action

52 Week Range

212.83333.40
(Low)(High)

Last 7 days

4.6%

Last 30 days

12.7%

Last 90 days

33.6%

Trailing 12 Months

25.8%

MSFT Financial Health

Current Ratio

1.93

Debt/Equity

0.27

Debt/Cashflow

1.74

MSFT Investor Care

Dividend Yield

0.8%

Dividend/Share (TTM)

2.66

Buy Backs (1Y)

0.75%

Diluted EPS (TTM)

9.24

Peers (Alternatives to Microsoft)

View All Peers In Detail
NameMkt Capsorted ascendingRevenuePrice %, 1MReturns, 1YP/EP/SRev 1-YrInc 1-Yr
LARGE-CAP
2.5T
207.6B
12.70% 25.81%
35.87
11.93
7.81% -4.74%
190.7B
18.0B
14.41% 1.66%
40.25
10.59
11.50% -1.86%
-
-
-29.25% -13.98%
-
-
- -
281.0B
48.0B
11.07% 46.64%
33.56
5.86
14.66% 10.75%
217.4B
31.4B
12.49% 32.61%
1.0K
6.93
19.41% -85.60%
20.5B
4.4B
7.88% -38.07%
198.13
4.68
7.15% -92.46%
MID-CAP
2.9B
489.0M
13.36% -11.92%
-19.47
6.28
23.89% -67.60%
11.1B
809.1M
8.18% 50.50%
81.07
13.74
17.99% 15.82%
6.7B
869.9M
8.60% 1.58%
-39.92
7.66
13.87% -28.82%
2.4B
-
1.17% 7.67%
-23.16
7.93
- -
SMALL-CAP
1.1B
396.1M
29.79% 5.39%
-5.73
2.87
14.23% -99.11%
1.1B
400.9M
1.28% 74.75%
-16.18
2.66
2.63% 29.30%
92.8M
315.6M
-17.82% -77.71%
-0.5
0.29
2.89% -207.54%

Financials for Microsoft

Income Statement (Last 12 Months)
(In Millions)
* denotes actual numbers (not divided by Millions)
Description(%) Q/Q2023Q12022Q42022Q32022Q22022Q1
Revenue1.7%207,591204,094203,075198,270192,557
Gross Profit2.1%142,094139,110138,619135,620132,345
  S&GA Expenses0.7%22,85922,70422,40421,82521,378
  R&D Expenses2.5%27,30526,62725,54124,51223,350
EBITDA-2.5%84,61286,78898,37994,054-
EBITDA Margin-3.0%0.41*0.43*0.50*0.49*-
Earnings Before Taxes3.0%85,07182,58884,76483,71682,634
EBT Margin-3.1%0.40*0.42*0.42*0.43*-
Interest Expenses-1.9%2,0242,0632,120--
Net Income2.3%69,02067,44969,78972,73872,456
Net Income Margin-3.8%0.33*0.34*0.37*0.38*-
Free Cahsflow-5.9%59,61863,33465,14963,649-
Balance Sheet
(In Millions)
* denotes actual numbers (not divided by Millions)
Description(%) Q/Q2023Q12022Q42022Q32022Q22022Q1
Assets4.3%380,088364,552359,784364,840344,607
  Current Assets3.8%163,889157,823160,812169,684153,922
    Cash Equivalents69.8%26,56215,64622,88413,93112,498
  Inventory-3.5%2,8772,9804,2683,7423,296
  Net PPE6.5%88,13282,75577,03774,39870,298
  Goodwill0.1%67,94067,90567,45967,52467,371
Liabilities2.2%185,405181,416186,218198,298181,683
  Current Liabilities4.9%85,69181,71887,38995,08277,439
  Long Term Debt-2.3%48,62249,78149,926--
    LT Debt, Current56.2%6,2453,9973,2482,7491,749
    LT Debt, Non Current-4.9%41,96544,11945,37447,03248,177
Shareholder's Equity6.3%194,683183,136173,566166,542162,924
  Retained Earnings8.9%108,23499,36892,37484,28179,633
Accumulated Depreciation4.0%65,99863,45960,63859,66058,053
Shares Outstanding-0.1%7,4377,4477,4577,4647,493
Cashflow (Last 12 Months)
(In Millions)
Description(%) Q/Q2023Q12022Q42022Q32022Q22022Q1
Cashflow From Operations-1.1%83,44184,38687,69389,03587,116
  Share Based Compensation6.5%9,1928,6337,9927,5027,076
Cashflow From Investing35.7%-23,275-36,182-30,193-30,311-31,435
Cashflow From Financing13.4%-45,791-52,846-53,483-58,876-56,978
  Dividend Payments2.2%19,37818,96418,55018,13517,717
  Buy Backs-11.6%25,29828,61130,58532,69631,116

Risks for MSFT

What is the probability of a big loss on MSFT?

40.8%


Probability that Microsoft stock will be more than 20% underwater in next one year

5.4%


Probability that Microsoft stock will be more than 30% underwater in next one year.

0%


Probability that Microsoft stock will be more than 40% underwater in next one year.
*Calculated based on probability distribution of losses observed in actual data in the last 5 years.

How does MSFT drawdown profile look like?

Y-axis is the maximum loss one would have experienced if Microsoft was unfortunately bought at previous high price.

Drawdowns

Returns for MSFT

Cumulative Returns on MSFT

27.5%


10-Year Cumulative Returns

32.0%


7-Year Cumulative Returns

28.9%


5-Year Cumulative Returns

23.3%


3-Year Cumulative Returns

What are the long-term rolling returns for MSFT?

FIve years rolling returns for Microsoft.

Annualized Returns

Which funds bought or sold MSFT recently?

View All Details
Datesorted ascendingFund NameType% Chg$ Change$ Held% Portfolio
2023-05-24
Verity Asset Management, Inc.
added
94.16
2,717,900
4,755,090
2.84%
2023-05-24
Old North State Trust, LLC
added
1.9
771,000
4,196,000
2.90%
2023-05-23
Capital Impact Advisors, LLC
sold off
-100
-1,012,520
-
-%
2023-05-23
Brookfield Corp /ON/
added
277
24,257,200
31,123,700
0.12%
2023-05-23
MOUNTAIN PACIFIC INVESTMENT ADVISERS INC/ID
added
1.22
679,668
3,812,830
0.27%
2023-05-23
Toroso Investments, LLC
added
117
90,187,000
146,192,000
2.50%
2023-05-23
Seaport Global Advisors, LLC
added
139
813,012
1,245,170
3.93%
2023-05-23
TPB WEALTH ADVISORS
reduced
-40.53
-385,000
966,000
0.53%
2023-05-23
3Chopt Investment Partners, LLC
new
-
2,507,140
2,507,140
1.34%
2023-05-23
Front Row Advisors LLC
reduced
-1.3
1,441,000
9,166,000
4.40%

1–10 of 44

Latest Funds Activity

Are funds buying MSFT calls or puts?
Calls
Puts
Are funds bullish or bearish(Calls - Puts)?
Net Call Options
No. of funds that own MSFT
No. of Funds

Microsoft News

Barron's
Nvidia’s New AI Supercomputer Is a Game Changer.
Barron's,
3 hours ago
The Motley Fool
If AI Thrives, Microsoft Will, Too.
The Motley Fool,
13 hours ago
Yahoo Finance
InvestorPlace
The Motley Fool
InvestorPlace
The Motley Fool
Microsoft: Buy, Sell, or Hold?.
The Motley Fool,
2 days ago
The Coin Republic

Schedule 13G FIlings of Microsoft

Date FiledName of FilerPercent of ClassNo. of SharesForm Type
Feb 09, 2023
vanguard group inc
8.62%
642,664,898
SC 13G/A
Jan 31, 2023
blackrock inc.
7.1%
532,084,843
SC 13G/A
Feb 10, 2022
vanguard group inc
8.20%
615,950,062
SC 13G/A
Feb 08, 2022
blackrock inc.
6.9%
519,712,655
SC 13G/A
Feb 10, 2021
vanguard group inc
8.12%
614,100,233
SC 13G/A
Feb 05, 2021
blackrock inc.
6.8%
515,872,379
SC 13G/A
Feb 12, 2020
vanguard group inc
8.17%
623,667,281
SC 13G/A
Feb 05, 2020
blackrock inc.
6.8%
515,197,221
SC 13G/A

MSFT Fair Value

Microsoft fair value in different scenarios

The table shows the Fair Value estimates for Microsoft for various scenarios. Disclaimer: These are just estimations from a model. None of the models are good at predicting the future. Please dont buy or sell stocks based on these outputs.
Fair ValueVery PessimisticPessimisticBase CaseOptimisticVery Optimistic
Very Low Inflation

188.50

-43.37%

239.92

-27.93%

322.20

-3.21%

416.67

25.17%

514.74

54.63%
Current Inflation

171.50

-48.48%

214.83

-35.47%

282.78

-15.05%

360.76

8.37%

441.90

32.75%
Very High Inflation

150.72

-54.72%

184.82

-44.48%

236.80

-28.87%

296.59

-10.90%

359.06

7.86%

Historical Microsoft Fair Value Estimates


Very Pessimistic Case
Pessimistic Case
Fair Value
Optimistic Case
Very Optimistic Case
Closing Stock Price

Recent SEC filings of Microsoft

View All Filings
Date Filed Form Type Document
May 19, 2023
4
Insider Trading
May 17, 2023
4
Insider Trading
May 10, 2023
4
Insider Trading
May 08, 2023
4
Insider Trading
May 05, 2023
144
Notice of Insider Sale Intent
May 02, 2023
4
Insider Trading
May 01, 2023
144
Notice of Insider Sale Intent
Apr 25, 2023
10-Q
Quarterly Report
Apr 25, 2023
8-K
Current Report
Apr 18, 2023
4
Insider Trading

Latest Insider Trading transactions for MSFT

Filter Transactions
Datesorted ascendingNameBuy/Sell$ ValueAvg. Price# SharesTitle
2023-05-18
Capossela Christopher C
sold
-1,584,350
316
-5,000
evp, chief marketing officer
2023-05-16
Capossela Christopher C
sold
-1,588,020
312
-5,081
evp, chief marketing officer
2023-05-16
Capossela Christopher C
gifted
-
-
-1,620
evp, chief marketing officer
2023-05-10
Capossela Christopher C
sold
-1,307,000
312
-4,177
evp, chief marketing officer
2023-05-09
Capossela Christopher C
sold
-1,543,520
308
-5,000
evp, chief marketing officer
2023-05-05
Capossela Christopher C
sold
-1,550,250
310
-5,000
evp, chief marketing officer
2023-05-01
Althoff Judson
sold
-9,182,700
306
-30,000
evp, chief commercial officer
2023-04-17
Jolla Alice L.
sold (taxes)
-50,781
286
-177
chief accounting officer
2023-02-28
Jolla Alice L.
sold (taxes)
-103,806
250
-414
chief accounting officer
2023-02-28
Hood Amy
sold (taxes)
-1,252,970
250
-5,008
evp, chief financial officer

1–10 of 50

Satya Nadella
65535
Microsoft Corporation develops, licenses, and supports software, services, devices, and solutions worldwide. Its Productivity and Business Processes segment offers Office, Exchange, SharePoint, Microsoft Teams, Office 365 Security and Compliance, and Skype for Business, as well as related Client Access Licenses (CAL); Skype, Outlook.com, OneDrive, and LinkedIn; and Dynamics 365, a set of cloud-based and on-premises business solutions for organizations and enterprise divisions. Its Intelligent Cloud segment licenses SQL, Windows Servers, Visual Studio, System Center, and related CALs; GitHub that provides a collaboration platform and code hosting service for developers; and Azure, a cloud platform. It also offers support services and Microsoft consulting services to assist customers in developing, deploying, and managing Microsoft server and desktop solutions; and training and certification on Microsoft products. Its More Personal Computing segment provides Windows original equipment manufacturer (OEM) licensing and other non-volume licensing of the Windows operating system; Windows Commercial, such as volume licensing of the Windows operating system, Windows cloud services, and other Windows commercial offerings; patent licensing; Windows Internet of Things; and MSN advertising. It also offers Surface, PC accessories, PCs, tablets, gaming and entertainment consoles, and other devices; Gaming, including Xbox hardware, and Xbox content and services; video games and third-party video game royalties; and Search, including Bing and Microsoft advertising. It sells its products through OEMs, distributors, and resellers; and directly through digital marketplaces, online stores, and retail stores. It has collaborations with Dynatrace, Inc., Morgan Stanley, Micro Focus, WPP plc, ACI Worldwide, Inc., and iCIMS, Inc., as well as strategic relationships with Avaya Holdings Corp. and wejo Limited. Microsoft Corporation was founded in 1975 and is based in Redmond, Washington.

MSFT Income Statement

2023-03-31
INCOME STATEMENTS - USD ($)
shares in Millions, $ in Millions
3 Months Ended9 Months Ended
Mar. 31, 2023
Mar. 31, 2022
Mar. 31, 2023
Mar. 31, 2022
Revenue$ 52,857$ 49,360$ 155,726$ 146,405
Cost of revenue16,12815,61549,06846,221
Gross margin36,72933,745106,658100,184
Research and development6,9846,30620,45617,663
Sales and marketing5,7505,59516,55515,521
General and administrative1,6431,4805,3784,151
Operating income22,35220,36464,26962,849
Other income (expense), net321(174)315380
Income before income taxes22,67320,19064,58463,229
Provision for income taxes4,3743,46212,3047,231
Net income$ 18,299$ 16,728$ 52,280$ 55,998
Earnings per share:    
Basic$ 2.46$ 2.23$ 7.02$ 7.46
Diluted$ 2.45$ 2.22$ 6.99$ 7.41
Weighted average shares outstanding:    
Basic7,4417,4937,4507,504
Diluted7,4647,5347,4747,552
Product    
Revenue$ 15,588$ 17,366$ 47,846$ 54,776
Cost of revenue3,9414,58413,93314,707
Service and Other    
Revenue37,26931,994107,88091,629
Cost of revenue$ 12,187$ 11,031$ 35,135$ 31,514

MSFT Balance Sheet

2023-03-31
BALANCE SHEETS - USD ($)
$ in Millions
Mar. 31, 2023
Jun. 30, 2022
Current assets:  
Cash and cash equivalents$ 26,562$ 13,931
Short-term investments77,86590,826
Total cash, cash equivalents, and short-term investments104,427104,757
Accounts receivable, net of allowance for doubtful accounts of $495 and $63337,42044,261
Inventories2,8773,742
Other current assets19,16516,924
Total current assets163,889169,684
Property and equipment, net of accumulated depreciation of $65,998 and $59,66088,13274,398
Operating lease right-of-use assets13,87913,148
Equity investments9,4156,891
Goodwill67,94067,524
Intangible assets, net9,87911,298
Other long-term assets26,95421,897
Total assets380,088364,840
Current liabilities:  
Accounts payable15,30519,000
Current portion of long-term debt6,2452,749
Accrued compensation10,41110,661
Short-term income taxes4,1634,067
Short-term unearned revenue36,90345,538
Other current liabilities12,66413,067
Total current liabilities85,69195,082
Long-term debt41,96547,032
Long-term income taxes25,00026,069
Long-term unearned revenue2,6982,870
Deferred income taxes302230
Operating lease liabilities12,31211,489
Other long-term liabilities17,43715,526
Total liabilities185,405198,298
Commitments and contingencies
Stockholders’ equity:  
Common stock and paid-in capital - shares authorized 24,000: outstanding 7,437 and 7,46492,09386,939
Retained earnings108,23484,281
Accumulated other comprehensive loss(5,644)(4,678)
Total stockholders’ equity194,683166,542
Total liabilities and stockholders’ equity$ 380,088$ 364,840