Grufity logoGrufity logo

Microsoft Corp Stock Research

MSFT

267.56USD+10.79(+4.20%)Market Closed

Market Summary

USD267.56+10.79
Market Closed
4.20%

MSFT Stock Price

MSFT RSI Chart

MSFT Valuation

Market Cap

2.0T

Price/Earnings (Trailing)

29.54

Price/Sales (Trailing)

9.76

EV/EBITDA

23.94

Price/Free Cashflow

33.42

MSFT Price/Sales (Trailing)

MSFT Profitability

EBT Margin

40.47%

Return on Equity

36.83%

Return on Assets

18.5%

Free Cashflow Yield

2.99%

MSFT Fundamentals

MSFT Revenue

Revenue (TTM)

204.1B

Revenue Y/Y

1.97%

Revenue Q/Q

5.24%

MSFT Earnings

Earnings (TTM)

67.4B

Earnings Y/Y

-12.47%

Earnings Q/Q

-6.44%

Price Action

52 Week Range

212.83313.66
(Low)(High)

Last 7 days

8.0%

Last 30 days

19.0%

Last 90 days

19.5%

Trailing 12 Months

-10.3%

MSFT Financial Health

Current Ratio

1.93

Debt/Equity

0.27

Debt/Cashflow

1.74

MSFT Investor Care

Dividend Yield

0.97%

Dividend/Share (TTM)

2.6

Buy Backs (1Y)

0.77%

Diluted EPS (TTM)

9.01

Peers (Alternatives to Microsoft)

View All Peers In Detail
NameMkt Capsorted ascendingRevenuePrice %, 1MReturns, 1YP/EP/SRev 1-YrInc 1-Yr
LARGE-CAP
2.0T
204.1B
18.95% -10.26%
29.54
9.76
10.38% -5.25%
236.5B
46.1B
2.81% 10.15%
26.88
5.13
11.29% -14.28%
177.3B
17.6B
15.35% -24.31%
37.28
10.07
11.54% -1.37%
170.8B
-
21.90% -21.06%
614.27
5.56
24.56% -84.01%
25.0B
4.3B
21.80% -40.14%
35.82
5.76
11.14% -39.03%
12.1B
693.1M
-3.12% 59.08%
44.35
17.39
-2.84% -14.76%
MID-CAP
9.6B
631.5M
-1.97% 16.85%
-45.68
15.19
33.30% -26.60%
9.1B
767.1M
23.12% 16.51%
81.59
12.3
15.59% 16.73%
6.4B
842.0M
20.72% -20.92%
-32.02
7.55
13.87% -103.37%
3.1B
447.2M
37.23% -21.13%
-22.12
7.04
29.28% -105.78%
2.6B
506.4M
0.39% 55.58%
-71.14
5.11
10.10% -203.10%
2.4B
308.3M
1.17% 7.67%
-23.16
7.93
13.75% -237.98%
SMALL-CAP
1.2B
383.7M
35.49% -46.43%
-9.29
3.03
14.43% -50.89%
947.6M
399.9M
24.32% -4.57%
-11.66
2.37
4.73% 8.15%
284.4M
314.2M
13.01% -53.55%
-5.35
0.91
3.18% 5.68%

Financials for Microsoft

Income Statement (Last 12 Months)
(In Millions)
Description(%) Q/Q2022Q42022Q32022Q22022Q12021Q4
Revenue0.5%204,094203,075198,270192,557184,903
Gross Profit0.4%139,110138,619135,620132,345127,261
  S&GA Expenses1.3%22,70422,40421,82521,37820,865
  R&D Expenses4.3%26,62725,54124,51223,35022,248
EBITDA-2.5%84,61286,78898,37994,054-
EBITDA Margin-3.0%0.41*0.43*0.50*0.49*-
Earnings Before Taxes-2.6%82,58884,76483,71682,63479,680
EBT Margin-3.1%0.40*0.42*0.42*0.43*-
Interest Expenses-1.9%2,0242,0632,1202,250-
Net Income-3.4%67,44969,78972,73872,45671,185
Net Income Margin-3.8%0.33*0.34*0.37*0.38*-
Free Cahsflow-5.9%59,61863,33465,14963,649-
* denotes actual numbers (not divided by Millions)
Balance Sheet
(In Millions)
Description(%) Q/Q2022Q42022Q32022Q22022Q12021Q4
Assets1.3%364,552359,784364,840344,607340,389
  Current Assets-1.9%157,823160,812169,684153,922174,188
    Cash Equivalents-31.6%15,64622,88413,93112,49820,604
  Inventory-30.2%2,9804,2683,7423,2963,019
  Net PPE7.4%82,75577,03774,39870,29867,214
  Goodwill0.7%67,90567,45967,52467,37150,921
Liabilities-2.6%181,416186,218198,298181,683180,379
  Current Liabilities-6.5%81,71887,38995,08277,43977,510
  Long Term Debt-2.3%48,62249,78149,92653,258-
    LT Debt, Current23.1%3,9973,2482,7491,7494,998
    LT Debt, Non Current-2.8%44,11945,37447,03248,17748,260
Shareholder's Equity5.5%183,136173,566166,542162,924160,010
  Retained Earnings7.6%99,36892,37484,28179,63375,045
Accumulated Depreciation4.7%63,45960,63859,66058,05355,277
Shares Outstanding-0.1%7,4477,4577,4647,4837,505
Float-2,500,000----
* denotes actual numbers (not divided by Millions)
Cashflow (Last 12 Months)
(In Millions)
Description(%) Q/Q2022Q42022Q32022Q22022Q12021Q4
Cashflow From Operations-3.8%84,38687,69389,03587,11683,909
  Share Based Compensation8.0%8,6337,9927,5027,0766,695
Cashflow From Investing-19.8%-36,182.00-30,193.00-30,311.00-31,435.00-24,948.00
Cashflow From Financing1.2%-52,846.00-53,483.00-58,876.00-56,978.00-52,825.00
  Dividend Payments2.2%18,96418,55018,13517,71717,293
  Buy Backs-6.5%28,61130,58532,69631,11629,224

Risks for MSFT

What is the probability of a big loss on MSFT?

35%


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

28.0%


10-Year Cumulative Returns

29.3%


7-Year Cumulative Returns

27.3%


5-Year Cumulative Returns

14.4%


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-02-06
FLOSSBACH VON STORCH AG
added
1.86
60,095,900
1,288,850,000
4.92%
2023-02-06
DILLON & ASSOCIATES INC
added
0.63
118,000
3,322,000
0.72%
2023-02-06
CHECK CAPITAL MANAGEMENT INC/CA
reduced
-0.42
35,000
1,422,000
0.07%
2023-02-06
AMARILLO NATIONAL BANK
reduced
-6.62
-167,942
4,186,060
0.97%
2023-02-06
Main Street Research LLC
added
6.78
340,332
3,764,330
0.92%
2023-02-06
Ramsay, Stattman, Vela & Price, Inc.
added
0.98
1,129,500
29,494,500
6.64%
2023-02-06
MARTIN & CO INC /TN/
reduced
-2.58
25,674
8,002,670
2.11%
2023-02-06
WRAPMANAGER INC
added
4.98
416,000
5,551,000
1.78%
2023-02-06
Cumberland Partners Ltd
reduced
-12.22
-4,325,220
40,689,800
4.29%
2023-02-06
MERIDIAN INVESTMENT COUNSEL INC.
reduced
-0.16
196,000
7,193,000
2.87%

1–10 of 49

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

Investor's Business Daily

Dow Jones Futures: Market Rallies On Powell, Microsoft AI Arms ....

Investor's Business Daily,
80 minutes ago

The Motley Fool

Why Microsoft Stock Popped Today.

The Motley Fool,
3 hours ago

Investor's Business Daily

The Motley Fool

Why Alphabet Stock Was Gaining Today.

The Motley Fool,
6 hours ago

The Motley Fool

Schedule 13G FIlings of Microsoft

Date FiledName of FilerPercent of ClassNo. of SharesForm Type
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

196.21

-26.67%

358.75

34.08%

513.95

92.09%

610.28

128.09%

734.80

174.63%

Current Inflation

177.42

-33.69%

315.51

17.92%

442.29

65.30%

523.48

95.65%

625.82

133.90%

Very High Inflation

154.70

-42.18%

264.90

-0.99%

360.47

34.72%

424.63

58.70%

502.73

87.89%

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
Feb 01, 2023
4
Insider Trading
Feb 01, 2023
4
Insider Trading
Feb 01, 2023
4
Insider Trading
Feb 01, 2023
4
Insider Trading
Feb 01, 2023
4
Insider Trading
Feb 01, 2023
4
Insider Trading
Feb 01, 2023
4
Insider Trading
Feb 01, 2023
4
Insider Trading
Feb 01, 2023
4
Insider Trading
Feb 01, 2023
4
Insider Trading

Latest Insider Trading transactions for MSFT

Filter Transactions
Datesorted ascendingNameBuy/Sell$ ValueAvg. Price# SharesTitle
2023-01-31
STANTON JOHN W
acquired
-
-
237
-
2023-01-31
SCHARF CHARLES W
acquired
-
-
237
-
2023-01-31
Walmsley Emma N
acquired
-
-
237
-
2023-01-31
WARRIOR PADMASREE
acquired
-
-
237
-
2023-01-31
List Teri
acquired
-
-
237
-
2023-01-31
Johnston Hugh F
acquired
-
-
237
-
2023-01-31
Walmsley Emma N
sold (taxes)
-17,619.3
247.81
-71.1
-
2023-01-17
Jolla Alice L.
sold (taxes)
-48,067.5
239.23
-200.926
chief accounting officer
2022-12-15
Jolla Alice L.
sold (taxes)
-68,017.5
257.22
-264.433
chief accounting officer
2022-12-12
List Teri
acquired
-
-
233
-

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

2022-12-31
INCOME STATEMENTS - USD ($)
shares in Millions, $ in Millions
3 Months Ended6 Months Ended
Dec. 31, 2022
Dec. 31, 2021
Dec. 31, 2022
Dec. 31, 2021
Revenue$ 52,747$ 51,728$ 102,869$ 97,045
Cost of revenue17,48816,96032,94030,606
Gross margin35,25934,76869,92966,439
Research and development6,8445,75813,47211,357
Sales and marketing5,6795,37910,8059,926
General and administrative2,3371,3843,7352,671
Operating income20,39922,24741,91742,485
Other income (expense), net(60)268(6)554
Income before income taxes20,33922,51541,91143,039
Provision for income taxes3,9143,7507,9303,769
Net income$ 16,425$ 18,765$ 33,981$ 39,270
Earnings per share:    
Basic$ 2.20$ 2.50$ 4.56$ 5.23
Diluted$ 2.20$ 2.48$ 4.54$ 5.19
Weighted average shares outstanding:    
Basic7,4517,5057,4547,509
Diluted7,4737,5557,4797,561
Product    
Revenue$ 16,517$ 20,779$ 32,258$ 37,410
Cost of revenue5,6906,3319,99210,123
Service and Other    
Revenue36,23030,94970,61159,635
Cost of revenue$ 11,798$ 10,629$ 22,948$ 20,483

MSFT Balance Sheet

2022-12-31
BALANCE SHEETS - USD ($)
$ in Millions
Dec. 31, 2022
Jun. 30, 2022
Current assets:  
Cash and cash equivalents$ 15,646$ 13,931
Short-term investments83,86290,826
Total cash, cash equivalents, and short-term investments99,508104,757
Accounts receivable, net of allowance for doubtful accounts of $485 and $63335,83344,261
Inventories2,9803,742
Other current assets19,50216,924
Total current assets157,823169,684
Property and equipment, net of accumulated depreciation of $63,459 and $59,66082,75574,398
Operating lease right-of-use assets13,62413,148
Equity investments7,0976,891
Goodwill67,90567,524
Intangible assets, net10,35411,298
Other long-term assets24,99421,897
Total assets364,552364,840
Current liabilities:  
Accounts payable15,35419,000
Current portion of long-term debt3,9972,749
Accrued compensation9,03010,661
Short-term income taxes3,5534,067
Short-term unearned revenue36,98245,538
Other current liabilities12,80213,067
Total current liabilities81,71895,082
Long-term debt44,11947,032
Long-term income taxes24,16926,069
Long-term unearned revenue2,6442,870
Deferred income taxes289230
Operating lease liabilities11,99811,489
Other long-term liabilities16,47915,526
Total liabilities181,416198,298
Commitments and contingencies
Stockholders’ equity:  
Common stock and paid-in capital – shares authorized 24,000; outstanding 7,447 and 7,46490,22586,939
Retained earnings99,36884,281
Accumulated other comprehensive loss(6,457)(4,678)
Total stockholders’ equity183,136166,542
Total liabilities and stockholders’ equity$ 364,552$ 364,840