Grufity logoGrufity logo

MSFT

248.32USD-6.70(-2.63%)Delayedas of 05 Dec 2022, 02:36 pm

Microsoft Corp

Market Summary

USD248.32-6.70Delayedas of 05 Dec 2022, 02:36 pm
-2.63%

MSFT Alerts

MSFT Stock Price

RSI Chart

Valuation

Market Cap

1.8T

Price/Earnings

25.2

Price/Sales

8.66

Price/Cashflow

20.06

MarketCap/EBT

20.75

Price/Sales

Profitability

EBT Margin

41.74%

Return on Equity

40.21%

Return on Assets

19.4%

Fundamentals

Revenue

Revenue (TTM)

203.1B

Revenue Y/Y

10.6%

Revenue Q/Q

-3.36%

Earnings

Earnings (TTM)

69.8B

Earnings Y/Y

-14.38%

Earnings Q/Q

4.87%

Price Action

52 Week Range

212.83341.10
(Low)(High)

Last 7 days

3.0%

Last 30 days

16.2%

Last 90 days

-0.1%

Trailing 12 Months

-21.9%

Financial Health

Current Ratio

1.84

Debt/Equity

0.28

Debt/Cashflow

1.8

Investor Care

Dividend Yield

1.08%

Dividend/Share (TTM)

2.54

Buy Backs (1Y)

0.71%

Diluted EPS (TTM)

9.29

Peers (Alternatives to Microsoft)

View All Peers In Detail
NameMkt Capsorted ascendingRevenuePrice %, 1MReturns, 1YP/EP/SRev 1-YrInc 1-Yr
LARGE-CAP
1.8T
203.1B
16.19% -21.88%
25.2
8.66
15.22% 2.81%
208.6B
44.2B
10.96% -5.77%
35.9
4.72
8.12% -58.36%
163.0B
30.3B
-3.63% -44.66%
304.14
5.56
21.26% -84.01%
151.4B
17.2B
13.38% -49.17%
31.46
8.81
13.86% -17.57%
25.1B
4.3B
-5.46% -61.25%
25.38
5.85
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%
7.5B
740.5M
12.08% -18.13%
67.22
10.14
15.84% 1.13%
5.0B
812.6M
8.04% -48.17%
-33.17
6.14
9.33% -463.42%
3.6B
421.7M
-19.92% -44.81%
-29.08
8.53
27.49% -161.02%
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.19
7.94
13.75% -232.84%
SMALL-CAP
991.7M
371.9M
6.18% -58.89%
-8.92
2.67
15.01% -44.50%
653.0M
399.9M
20.08% -33.40%
-6.96
1.63
4.73% 8.15%
246.7M
310.7M
-1.33% -63.18%
-4.28
0.79
2.66% -1.77%

Financials for Microsoft

Income Statement (Last 12 Months)
(In Millions)
Description(%) Q/Q2022Q32022Q22022Q12021Q42021Q3
Revenue2.4%203,075198,270192,557184,903176,251
Gross Profit2.2%138,619135,620132,345127,261121,375
  S&GA Expenses2.7%22,40421,82521,37820,86520,433
  R&D Expenses4.2%25,54124,51223,35022,24821,389
Earnings Before Taxes1.3%84,76483,71682,63479,68075,502
Net Income-4.1%69,78972,73872,45671,18567,883
Balance Sheet
(In Millions)
Description(%) Q/Q2022Q32022Q22022Q12021Q42021Q3
Assets-1.4%359,784364,840344,607340,389335,418
  Current Assets-5.2%160,812169,684153,922174,188174,326
    Cash Equivalents64.3%22,88413,93112,49820,60419,165
  Inventory14.1%4,2683,7423,2963,0193,411
  Net PPE3.5%77,03774,39870,29867,21463,772
  Goodwill-0.1%67,45967,52467,37150,92150,455
Liabilities-6.1%186,218198,298181,683180,379183,440
  Current Liabilities-8.1%87,38995,08277,43977,51080,528
  Long Term Debt-2.3%48,62249,78149,92653,25853,288
    LT Debt, Current18.2%3,2482,7491,7494,9983,249
    LT Debt, Non Current-3.5%45,37447,03248,17748,26050,039
Shareholder's Equity4.2%173,566166,542162,924160,010151,978
  Retained Earnings9.6%92,37484,28179,63375,04566,944
Accumulated Depreciation1.6%60,63859,66058,05355,27752,469
Shares Outstanding-0.1%7,4577,4647,4837,5007,510
Float-2,500,000----
* denotes actual numbers (not divided by Millions)
Cashflow (Last 12 Months)
(In Millions)
Description(%) Q/Q2022Q32022Q22022Q12021Q42021Q3
Cashflow From Operations-1.5%87,69389,03587,11683,90981,945
  Share Based Compensation6.5%7,9927,5027,0766,6956,364
Cashflow From Investing0.4%-30,193.00-30,311.00-31,435.00-24,948.00-25,456.00
Cashflow From Financing9.2%-53,483.00-58,876.00-56,978.00-52,825.00-54,473.00
  Dividend Payments2.4%18,13517,71717,29316,871
  Buy Backs-6.5%30,58532,69631,11629,22428,326

Risks

What is the probability of a big loss on MSFT?

31.1%


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

4.2%


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.

Returns

Cumulative Returns on MSFT

27.9%


10-Year Cumulative Returns

26.2%


7-Year Cumulative Returns

26.3%


5-Year Cumulative Returns

20.7%


3-Year Cumulative Returns

What are the long-term rolling returns for MSFT?

FIve years rolling returns for Microsoft.

Which funds bought or sold MSFT recently?

View All Details
Datesorted ascendingFund NameType% Chg$ Change$ Held% Portfolio
2022-11-29
AWM CAPITAL, LLC
ADDED
96.99
343,000
745,000
0.25%
2022-11-29
SALEM CAPITAL MANAGEMENT INC
REDUCED
-0.89
-999,000
8,864,000
7.02%
2022-11-29
Bridgefront Capital, LLC
ADDED
168.67
614,000
1,041,000
1.07%
2022-11-29
London & Capital Asset Management Ltd
REDUCED
-4.12
-11,195,000
74,550,000
6.96%
2022-11-23
Toroso Investments, LLC
REDUCED
-3.13
-7,076,000
51,145,000
2.12%
2022-11-23
Eagle Bay Advisors LLC
REDUCED
-7.71
-574,155
2,976,000
1.84%
2022-11-23
CLIENT 1ST ADVISORY GROUP, LLC
UNCHANGED
-
-66,000
642,000
0.40%
2022-11-23
Invst, LLC
ADDED
3.56
-802,000
3,679,000
0.63%
2022-11-23
FSB PREMIER WEALTH MANAGEMENT, INC.
ADDED
5.44
-51,000
1,114,000
0.65%
2022-11-23
Gould Capital, LLC
REDUCED
-4.77
-125,000
791,000
0.68%

1–10 of 46

Latest Funds Activity

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

Microsoft News

Yahoo Finance

Notorious Hacking Group Lapsus$ Behind Microsoft, Nvidia And Other Breaches Draws Regulatory Review.5 hours ago

The Motley Fool

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

-20.99%

358.75

44.47%

513.95

106.97%

610.28

145.76%

734.80

195.91%

Current Inflation

177.42

-28.55%

315.51

27.06%

442.29

78.11%

523.48

110.81%

625.82

152.02%

Very High Inflation

154.70

-37.70%

264.90

6.68%

360.47

45.16%

424.63

71.00%

502.73

102.45%

Historical Microsoft Fair Value Estimates


Recent SEC filings of Microsoft

View All Filings
Date Filed Form Type Document
Nov 21, 2022
PX14A6G
PX14A6G
Nov 14, 2022
4
Insider Trading
Nov 04, 2022
PX14A6G
PX14A6G
Oct 27, 2022
DEF 14A
DEF 14A
Oct 27, 2022
DEFA14A
DEFA14A
Oct 25, 2022
8-K
Current Report
Oct 25, 2022
10-Q
Quarterly Report
Oct 18, 2022
4
Insider Trading
Sep 20, 2022
4/A
Insider Trading
Sep 20, 2022
4
Insider Trading

Latest Insider Trading transactions for MSFT

Filter Transactions
Datesorted ascendingNameBuy/Sell$ ValueAvg. Price# SharesTitle
2022-12-01
Althoff Judson
SOLD
-6,139,120
254.271
-24,144
EVP, Chief Commercial Officer
2022-11-30
Jolla Alice L.
SOLD FOR TAXES
-99,652.1
240.33
-414.647
Chief Accounting Officer
2022-11-11
Young Christopher David
SOLD FOR TAXES
-2,503,470
242.98
-10,303.2
EVP, Business Development
2022-10-17
Jolla Alice L.
SOLD FOR TAXES
-40,562.3
228.56
-177.469
Chief Accounting Officer
2022-09-19
Althoff Judson
ACQUIRED
-
-
27,996
EVP, Chief Commercial Officer
2022-09-19
Capossela Christopher C
ACQUIRED
-
-
11,302
EVP, Chief Marketing Officer
2022-09-19
Young Christopher David
ACQUIRED
-
-
14,342
EVP, Business Development
2022-09-19
Hogan Kathleen T
ACQUIRED
-
-
12,621
EVP, Human Resources
2022-09-19
Hood Amy
ACQUIRED
-
-
33,465
EVP & Chief Financial Officer
2022-09-19
SMITH BRADFORD L
ACQUIRED
-
-
29,641
President/Chief Legal 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

2022-09-30
INCOME STATEMENTS - USD ($)
shares in Millions, $ in Millions
3 Months Ended
Sep. 30, 2022
Sep. 30, 2021
Revenue$ 50,122$ 45,317
Cost of revenue15,45213,646
Gross margin34,67031,671
Research and development6,6285,599
Sales and marketing5,1264,547
General and administrative1,3981,287
Operating income21,51820,238
Other income, net54286
Income before income taxes21,57220,524
Provision for income taxes4,01619
Net income$ 17,556$ 20,505
Earnings per share:  
Basic$ 2.35$ 2.73
Diluted$ 2.35$ 2.71
Weighted average shares outstanding:  
Basic7,4577,513
Diluted7,4857,567
Product  
Revenue$ 15,741$ 16,631
Cost of revenue4,3023,792
Service and Other  
Revenue34,38128,686
Cost of revenue$ 11,150$ 9,854

MSFT Balance Sheet

2022-09-30
BALANCE SHEETS - USD ($)
$ in Millions
Sep. 30, 2022
Jun. 30, 2022
Current assets:  
Cash and cash equivalents$ 22,884$ 13,931
Short-term investments84,37890,826
Total cash, cash equivalents, and short-term investments107,262104,757
Accounts receivable, net of allowance for doubtful accounts of $438 and $63331,27944,261
Inventories4,2683,742
Other current assets18,00316,924
Total current assets160,812169,684
Property and equipment, net of accumulated depreciation of $60,638 and $59,66077,03774,398
Operating lease right-of-use assets13,34713,148
Equity investments6,8396,891
Goodwill67,45967,524
Intangible assets, net10,80811,298
Other long-term assets23,48221,897
Total assets359,784364,840
Current liabilities:  
Accounts payable16,60919,000
Current portion of long-term debt3,2482,749
Accrued compensation7,40510,661
Short-term income taxes6,7294,067
Short-term unearned revenue41,34045,538
Other current liabilities12,05813,067
Total current liabilities87,38995,082
Long-term debt45,37447,032
Long-term income taxes23,71226,069
Long-term unearned revenue2,5492,870
Deferred income taxes223230
Operating lease liabilities11,66011,489
Other long-term liabilities15,31115,526
Total liabilities186,218198,298
Commitments and contingencies
Stockholders’ equity:  
Common stock and paid-in capital – shares authorized 24,000; outstanding 7,457 and 7,46488,53586,939
Retained earnings92,37484,281
Accumulated other comprehensive loss(7,343)(4,678)
Total stockholders’ equity173,566166,542
Total liabilities and stockholders’ equity$ 359,784$ 364,840