Definitive Analysis
Definitive Analysis

Financial Statements

Analysis Mode

Ticker

Industry

Sector

Microsoft Corporation (MSFT)

Company Dividend Discount ModelIndustry: Software - InfrastructureSector: Technology

Valuation Snapshot

Stable Growth$288.40 - $661.40$420.71
Multi-Stage$206.39 - $225.41$215.72
Blended Fair Value$318.22
Current Price$517.95
Upside-38.56%
DecisionDon't Buy

Dividend History & Growth Metrics (10Y)

Metric5Y CAGR10Y CAGR2025202420232022202120202019201820172016
DPS9.73%9.32%3.232.922.652.432.212.031.851.701.591.47
YoY Growth--10.62%9.95%9.18%9.77%9.14%9.60%8.76%7.21%7.62%11.37%
Dividend Yield--0.62%0.68%0.84%1.04%0.79%0.96%1.33%1.47%2.13%2.56%

Stable Growth Model (Adjusted)

(USD in Millions except Per Share Data)
Net Income To Common (M)104,912.00
(-) Cash Dividends Paid (M)24,677.00
(=) Cash Retained (M)80,235.00
MetricLOWBASEHIGH
Required Retention Ratio20.0%12.5%7.5%
(=) Cash Required (M)20,982.4013,114.007,868.40
Cash Retained (M)80,235.0080,235.0080,235.00
(-) Cash Required (M)-20,982.40-13,114.00-7,868.40
(=) Excess Retained (M)59,252.6067,121.0072,366.60
(/) Shares Outstanding (M)7,465.007,465.007,465.00
(=) Excess Retained per Share7.948.999.69
LTM Dividend per Share3.313.313.31
(+) Excess Retained per Share7.948.999.69
(=) Adjusted Dividend11.2412.3013.00
WACC / Discount Rate9.61%9.61%9.61%
Growth Rate5.50%6.50%7.50%
Fair Value$288.40$420.71$661.40
Upside / Downside-44.32%-18.77%27.70%

Multi-Stage Model: Projections

(USD in Millions)
MetricTTMDec-27Dec-28Dec-29Dec-30Dec-31Terminal
Net Income (M)104,912.00111,731.28118,993.81126,728.41134,965.76143,738.53148,050.69
Payout Ratio23.52%36.82%50.11%63.41%76.70%90.00%92.50%
Projected Dividends (M)24,677.0041,136.4359,631.3380,356.77103,524.57129,364.68136,946.89

Multi-Stage Valuation

MetricLOWBASEHIGH
WACC / Discount Rate9.61%9.61%9.61%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)37,176.4437,528.8337,881.21
Year 2 PV (M)48,703.1349,630.7950,567.20
Year 3 PV (M)59,312.4761,015.1262,750.04
Year 4 PV (M)69,057.0771,712.8174,444.42
Year 5 PV (M)77,986.8981,753.6985,664.65
PV of Terminal Value (M)1,248,435.111,308,734.991,371,342.69
Equity Value (M)1,540,671.111,610,376.221,682,650.21
Shares Outstanding (M)7,465.007,465.007,465.00
Fair Value$206.39$215.72$225.41
Upside / Downside-60.15%-58.35%-56.48%

High-Yield Dividend Screener

« Prev Page 24 of 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
EXPDExpeditors International of Washington, Inc.0.99%$1.5024.32%
LISOXLazard International Strategic Equity Ptf Open Shares0.99%$0.1336.87%
MXCMexco Energy Corporation0.99%$0.1012.25%
NICNicolet Bankshares, Inc.0.99%$1.1912.58%
PAYCPaycom Software, Inc.0.99%$1.5118.80%
RRCRange Resources Corporation0.99%$0.3514.60%
WLFCWillis Lease Finance Corporation0.99%$1.327.58%
WORWorthington Industries, Inc.0.99%$0.5223.95%
CNXNPC Connection, Inc.0.98%$0.5616.89%
CATCaterpillar Inc.0.97%$5.7829.40%
CNKCinemark Holdings, Inc.0.97%$0.2318.28%
ECLEcolab Inc.0.97%$2.5436.57%
EVREvercore Inc.0.97%$3.4127.02%
LSBKLake Shore Bancorp, Inc.0.96%$0.1424.34%
0ITL.LArthur J. Gallagher & Co.0.95%$2.4239.43%
0IZI.LW.W. Grainger, Inc.0.95%$9.5226.47%
0L5V.LThe Sherwin-Williams Company0.95%$3.1130.09%
0R2S.LStryker Corporation0.95%$3.2843.09%
RRXRegal Rexnord Corporation0.95%$1.3936.07%
WTWisdomTree, Inc.0.95%$0.1218.12%
JJacobs Solutions Inc.0.94%$1.2753.80%
ORCLOracle Corporation0.94%$1.8434.81%
TCBSTexas Community Bancshares, Inc.0.94%$0.1719.22%
IMKTAIngles Markets, Incorporated0.93%$0.6514.68%
ODCOil-Dri Corporation of America0.93%$0.4512.28%
PENGPenguin Solutions, Inc.0.93%$0.1940.17%
SSBKSouthern States Bancshares, Inc.0.93%$0.349.19%
DALDelta Air Lines, Inc.0.92%$0.638.94%
HIFSHingham Institution for Savings0.92%$2.4912.15%
RLRalph Lauren Corporation0.92%$3.3424.37%
OPYOppenheimer Holdings Inc.0.91%$0.668.90%
BGCBGC Group, Inc0.90%$0.0823.56%
CDRECadre Holdings, Inc.0.90%$0.3733.35%
MBNKPMedallion Bank0.90%$0.2312.50%
JBHTJ.B. Hunt Transport Services, Inc.0.89%$1.7530.14%
NYTThe New York Times Company0.89%$0.6230.32%
RMDResMed Inc.0.89%$2.1822.31%
VBFCVillage Bank and Trust Financial Corp.0.89%$0.7215.35%
0I14.LCognex Corporation0.88%$0.3249.16%
ARAntero Resources Corporation0.88%$0.3017.15%
LDOSLeidos Holdings, Inc.0.88%$1.6114.88%
LMATLeMaitre Vascular, Inc.0.88%$0.7032.20%
NNINelnet, Inc.0.88%$1.149.52%
PFSIPennyMac Financial Services, Inc.0.88%$1.1612.49%
SMBKSmartFinancial, Inc.0.88%$0.3211.76%
BYDBoyd Gaming Corporation0.87%$0.753.22%
ROSTRoss Stores, Inc.0.87%$1.5924.85%
BBSIBarrett Business Services, Inc.0.86%$0.3115.02%
BCOThe Brink's Company0.86%$1.0024.81%
HXLHexcel Corporation0.86%$0.6677.18%