Microsoft Corporation

Dividend Per Share TTM ($)	2.48
Forward Annual Dividend Yield	1.04%
Ex Dividend Date (MM/DD/YYYY)	11/16/2022
Dividend Pay Date (MM/DD/YYYY)	9/8/2022
Dividend Yield (TTM)	1.04%
Forward Annual Dividend Rate ($)	2.48
Dividend Payout Ratio	27.00
Dividend Per Share 5 Year CAGR	9.60%

Analyst Estimates

EPS Estimate Current Year ($)	10.14
EPS Estimate Next Year ($)	11.67
EPS Estimate Next Quarter ($)	2.55
EPS Estimate Current Quarter ($)	2.31
Current Target Price ($)	328.59
Next 5 Year Growth Rate (%)	11.7
1 week Ago Target Price ($)	330.20
2 week Ago Target Price ($)	330.20
3 week Ago Target Price ($)	330.20

Financial Health

Cash Flow Per Share TTM ($)	11.81
Current Ratio	1.80
Quick Ratio	1.60
Debt to Equity Ratio (Last Quarter)	0.37
Long term debt per share (Last Quarter)	6.3
F Score	7.0

Technicals

RSI (14 Day)	28.77
14 Day SMA ($)	250.01
14 Day EMA ($)	249.04
Money Flow Index	42.51
Average True Range	6.26
50 Day SMA ($)	267.28
200 Day SMA ($)	284.36
ADX	53.37
MACD	-8.71

Growth

Free Cash Flow QoQ Growth	-11.41%
Free Cash Flow YoY Growth	16.09%
Revenue YoY Growth	17.96%
EPS QoQ Growth	0.45%
Revenue QoQ Growth	5.07%
EPS YoY Growth	19.46%

Profitability

Return on Assets TTM (%)	20.82
Profit Margin TTM (%)	44.0
Return on Equity TTM (%)	47.15
Return on Capital TTM (%)	34.05
Interest Coverage Ratio	41.60
Gross Margin TTM (%)	68.4

Peers

Stock	Dividend	Market Cap (B)	PE	Price ($)
AAPL	0.0051	3,027 B	29	171.66
CSCO	0.0268	234 B	20.7	55.17
GOOGL		1,827 B	26.1	2784.02
HPQ	0.0267	41 B	6.9	37.49
IBM	0.0478	99 B	21	137.24
ORCL	0.0159	216 B	23.6	80.74
SAP

News

Financials

Income Statement

Balance Sheet

Cash Flow

MSFT Income Statement

Annual

	Jun-13	Jun-14	Jun-15	Jun-16	Jun-17	Jun-18	Jun-19	Jun-20	Jun-21	Jun-22
Total revenues	77,849 M	86,833 M	93,580 M	91,154 M	96,571 M	110,360 M	125,843 M	143,015 M	168,088 M	198,270 M
Cost of sales	16,630 M	21,866 M	27,081 M	26,158 M	25,483 M	28,092 M	31,228 M	33,282 M	40,546 M	48,190 M
Gross operating profit	57,464 M	59,755 M	60,542 M	58,374 M	62,310 M	72,007 M	82,933 M	96,937 M	115,856 M	135,620 M

Selling Gen & administrative expense	20,289 M	20,488 M	20,324 M	19,198 M	19,942 M	22,223 M	23,098 M	24,709 M	25,224 M	27,725 M
Research & development expense	10,411 M	11,381 M	12,046 M	11,988 M	13,037 M	14,726 M	16,876 M	19,269 M	20,716 M	24,512 M
Operating income	26,764 M	27,886 M	28,172 M	27,188 M	29,331 M	35,058 M	42,959 M	52,959 M	69,916 M	83,383 M

floaterest income	0	0	0	0	0	0	0	0	0	0
floaterest expense	0	0	0	0	0	0	0	0	0	0
Other income net	717 M	531 M	-8,884 M	-306 M	2,792 M	1,935 M	653 M	2,668 M	1,401 M	302 M
Pre-tax Income (EBT)	27,052 M	27,820 M	18,507 M	25,639 M	29,901 M	36,474 M	43,688 M	53,036 M	71,102 M	83,716 M

Income taxes	5,189 M	5,746 M	6,314 M	5,100 M	4,412 M	19,903 M	4,448 M	8,755 M	9,831 M	10,978 M
Net income from total operations	21,863 M	22,074 M	12,193 M	20,539 M	25,489 M	16,571 M	39,240 M	44,281 M	61,271 M	72,738 M
Minority floaterest	0	0	0	0	0	0	0	0	0	0
Total net income	21,863 M	22,074 M	12,193 M	20,539 M	25,489 M	16,571 M	39,240 M	44,281 M	61,271 M	72,738 M

Preferred dividends	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A
Net income available for common	21,863 M	22,074 M	12,193 M	20,539 M	25,489 M	16,571 M	39,240 M	44,281 M	61,271 M	72,738 M
Depreciation	3,755 M	5,212 M	5,957 M	6,622 M	8,778 M	10,261 M	11,682 M	12,796 M	11,686 M	14,460 M
Amortization	0	0	0	0	0	0	0	0	0	0
Operating income before depreciation (EBITDA)	31,236 M	33,629 M	25,245 M	33,504 M	40,901 M	49,468 M	58,056 M	68,423 M	85,134 M	100,239 M
Total Income available for floaterest expense (EBIT)	0	0	0	0	0	0	0	0	0	0
Basic EPS total	2.61	2.66	1.49	2.59	2.74	2.15	5.11	5.82	8.12	9.7
Diluted EPS total	2.58	2.63	1.48	2.56	2.71	2.13	5.06	5.76	8.05	9.65

<< PREVIOUS STOCK

NEXT STOCK>>

Call: 1-877-778-8358

I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONSGet started today

Microsoft Corporation

Sector: Technology

Industry: Software - Infrastructure

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Valuation

Price per Sales TTM ($)

Price per Book TTM ($)

PE Ratio (TTM)

Book Value per Share ($)

5 Year PE Range

Returns

7 Day Return

1 Month Return

3 Month Return

1 Year Return

3 Year Return

5 Year Return

YTD Return

Risk

Custom Beta One Year

Custom Beta Three Years

Beneish M Score

Altman Z Score

Ranks

MarketXLS Value Score

MarketXLS Quality Score

MarketXLS Technical Score

MarketXLS Rank

Dividends

Dividend Per Share TTM ($)

Forward Annual Dividend Yield

Ex Dividend Date (MM/DD/YYYY)

Dividend Pay Date (MM/DD/YYYY)

Dividend Yield (TTM)

Forward Annual Dividend Rate ($)

Dividend Payout Ratio

Dividend Per Share 5 Year CAGR

Analyst Estimates

EPS Estimate Current Year ($)

EPS Estimate Next Year ($)

EPS Estimate Next Quarter ($)

EPS Estimate Current Quarter ($)

Current Target Price ($)

Next 5 Year Growth Rate (%)

1 week Ago Target Price ($)

2 week Ago Target Price ($)

3 week Ago Target Price ($)

Financial Health

Cash Flow Per Share TTM ($)

Current Ratio

Quick Ratio

Debt to Equity Ratio (Last Quarter)

Long term debt per share (Last Quarter)

F Score

Technicals

RSI (14 Day)

14 Day SMA ($)

14 Day EMA ($)

Money Flow Index

Average True Range

50 Day SMA ($)

200 Day SMA ($)

ADX

MACD

Growth

Free Cash Flow QoQ Growth

Free Cash Flow YoY Growth

Revenue YoY Growth

EPS QoQ Growth

Revenue QoQ Growth

EPS YoY Growth

Profitability

Return on Assets TTM (%)

Profit Margin TTM (%)

Return on Equity TTM (%)

Return on Capital TTM (%)

Interest Coverage Ratio

Gross Margin TTM (%)

Peers

AAPL

Sector:
Technology

Industry:
Software - Infrastructure