Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Ticker

Industry

Sector

Microsoft Corporation (MSFT)

Company Dividend Discount ModelIndustry: Software - InfrastructureSector: Technology

Valuation Snapshot

Stable Growth$288.85 - $663.45$421.60
Multi-Stage$206.61 - $225.65$215.96
Blended Fair Value$318.78
Current Price$517.95
Upside-38.45%
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.85$421.60$663.45
Upside / Downside-44.23%-18.60%28.09%

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,178.6537,531.0637,883.46
Year 2 PV (M)48,708.9249,636.6950,573.21
Year 3 PV (M)59,323.0561,026.0062,761.24
Year 4 PV (M)69,073.5071,729.8774,462.13
Year 5 PV (M)78,010.0881,777.9985,690.12
PV of Terminal Value (M)1,250,038.191,310,415.511,373,103.60
Equity Value (M)1,542,332.391,612,117.111,684,473.75
Shares Outstanding (M)7,465.007,465.007,465.00
Fair Value$206.61$215.96$225.65
Upside / Downside-60.11%-58.31%-56.43%

High-Yield Dividend Screener

« Prev Page 68 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
0316.HKOrient Overseas (International) Limited2.19%$2.7948.77%
3109.TShikibo Ltd.2.19%$22.8930.55%
3679.TZIGExN Co., Ltd.2.19%$10.5526.56%
4516.TNippon Shinyaku Co., Ltd.2.19%$123.8726.14%
4617.TChugoku Marine Paints, Ltd.2.19%$96.7242.42%
600051.SSNingbo United Group Co.,Ltd.2.19%$0.1755.08%
603799.SSZhejiang Huayou Cobalt Co., Ltd2.19%$1.4948.01%
7233.KLDufu Technology Corp. Berhad2.19%$0.0495.65%
9064.TYamato Holdings Co., Ltd.2.19%$48.3336.15%
9948.TARCS Company Limited2.19%$74.0133.92%
000049.SZShenzhen Desay Battery Technology Co., Ltd.2.18%$0.5954.00%
000153.SZAnhui Fengyuan Pharmaceutical Co., Ltd.2.18%$0.1455.80%
002237.SZShandong Humon Smelting Co., Ltd.2.18%$0.2961.47%
002626.SZXiamen Kingdomway Group Company2.18%$0.4354.26%
2468.TWFortune Information Systems Corp2.18%$0.9078.36%
300815.SZEIT Environmental Development Group Co.,Ltd2.18%$0.5038.67%
300910.SZXinxiang Richful Lube Additive Co., Ltd2.18%$1.2345.00%
4908.TWOAPAC Opto Electronics Inc.2.18%$1.7472.09%
601369.SSXi'an Shaangu Power Co., Ltd.2.18%$0.2237.55%
067160.KQSoop Co., Ltd.2.17%$1,492.2515.52%
3898.HKZhuzhou CRRC Times Electric Co., Ltd.2.17%$0.8329.19%
4507.TShionogi & Co., Ltd.2.17%$61.6530.72%
603383.SSFujian Apex Software Co.,LTD2.17%$0.7883.82%
603568.SSZhejiang Weiming Environment Protection Co., Ltd.2.17%$0.5534.14%
7181.TJapan Post Insurance Co., Ltd.2.17%$102.1324.56%
053800.KQAhnLab, Inc.2.16%$1,304.4028.50%
0QI9.LCreades AB2.16%$1.5916.64%
601233.SSTongkun Group Co., Ltd.2.16%$0.3750.52%
605056.SSXianheng International Science&Technology Co., Ltd.2.16%$0.3657.45%
MGICMagic Software Enterprises Ltd.2.16%$0.5669.02%
002311.SZGuangdong Haid Group Co., Limited2.15%$1.1939.51%
3727.TAplix Corporation2.15%$3.4454.78%
603586.SSShandong Gold Phoenix Co.,Ltd2.15%$0.4151.17%
6268.TNabtesco Corporation2.15%$80.7460.45%
ATRLJ-B.STAtrium Ljungberg AB (publ)2.15%$0.7141.67%
BPAN4.SABanco Pan S.A.2.15%$0.2441.77%
NCM.AXNewcrest Mining Limited2.15%$0.5038.39%
PARAUCO.SNParque Arauco S.A.2.15%$62.7342.33%
SHANG.BKShangri-La Hotel Public Company Limited2.15%$1.0056.93%
VZUG.SWV-ZUG Holding AG2.15%$0.9119.03%
WTIF.SGWisdomTree Japan Equity UCITS ETF2.15%$0.9891.42%
002258.SZLier Chemical Co.,LTD.2.14%$0.2848.19%
002605.SZShanghai Yaoji Technology Co., Ltd.2.14%$0.5042.55%
0GZV.ILGetinge AB (publ)2.14%$4.6761.88%
0PMJ.LSiemens Healthineers AG2.14%$0.9549.72%
300482.SZGuangzhou Wondfo Biotech Co.,Ltd2.14%$0.4274.45%
5288.KLSime Darby Property Berhad2.14%$0.0342.63%
603218.SSRiyue Heavy Industry Co., Ltd.2.14%$0.2852.42%
BXB.AXBrambles Limited2.14%$0.4940.03%
POBS.BOPlatinumOne Business Services2.14%$3.0015.69%