Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Company Industry Sector

Fundamentals

Margins Returns Growth Rates Metrics/Ratios

Valuations

Projections DCF DDM EPV Multiples Valuations

Miscellaneous

Indicators Charts WACC Beta Predictability

Mode

Company Industry Sector

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 69 of 151 Next »
Ticker ⇵ Company ⇵ Dividend Yield % ▼ Dividend Per Share ⇵ Payout Ratio % ⇵
SIE.DESiemens AG2.14%$5.1641.34%
TBIG.JKPT Tower Bersama Infrastructure Tbk2.14%$55.6585.41%
VNX.DENXP Semiconductors N.V.2.14%$4.0549.93%
010100.KSKorea Movenex Co., Ltd.2.13%$99.689.18%
300154.SZShenzhen Riland Industry Group Co., Ltd2.13%$0.2190.73%
600848.SSShanghai Lingang Holdings Co.,Ltd.2.13%$0.2539.80%
7259.TAisin Corporation2.13%$62.3927.27%
ALBRK.ISAlbaraka Türk Katilim Bankasi A.S.2.13%$0.173.51%
BURBurford Capital Limited2.13%$0.1947.60%
ECSC.LECSC Group plc2.13%$1.1222.10%
PR9.BKPraram 9 Hospital Public Company Limited2.13%$0.4038.51%
000630.SZTongling Nonferrous Metals Group Co.,Ltd.2.12%$0.1392.15%
000878.SZYunnan Copper Co., Ltd.2.12%$0.4467.43%
002223.SZJiangsu Yuyue Medical Equipment & Supply Co., Ltd.2.12%$0.8146.42%
002731.SZShenyang Cuihua Gold and Silver Jewelry Co., Ltd.2.12%$0.2724.86%
0RKK.LVolati AB2.12%$2.2057.57%
0RVK.LBefesa S.A.2.12%$0.7464.88%
163560.KSDRB Industrial Co., Ltd.2.12%$146.7836.08%
2641.TWOFranbo Lines Corp.2.12%$0.4325.10%
443060.KSHdhms2.12%$4,099.9369.50%
605500.SSForest Packaging Group Co.,Ltd.2.12%$0.1989.23%
6455.TMorita Holdings Corporation2.12%$58.4524.57%
CCOLA.ISCoca-Cola Içecek Anonim Sirketi2.12%$1.2625.02%
MTWI.JKPT Malacca Trust Wuwungan Insurance Tbk2.12%$7.8425.68%
PNDX-B.STPandox AB (publ)2.12%$4.2540.78%
000860.KSKangnam Jevisco Co., Ltd2.11%$292.3959.03%
002440.SZZhejiang Runtu Co., Ltd.2.11%$0.1660.72%
002973.SZQiaoyin City Management Co.,Ltd.2.11%$0.2959.79%
0400.HKIngdan, Inc.2.11%$0.0622.33%
0Z4I.LSunny Optical Technology (Group) Company Limited2.11%$0.7115.45%
200771.SZHangzhou Steam Turbine Co., Ltd.2.11%$0.2859.18%
285130.KSSK Chemicals Co.,Ltd2.11%$1,396.2531.71%
688558.SSNantong Guosheng Intelligence Technology Group Co., Ltd.2.11%$0.6153.65%
NRDF.CONordfyns Bank A/S2.11%$13.0894.24%
001880.KSDL Construction Co., Ltd.2.10%$300.9316.73%
002967.SZGRG Metrology & Test Group Co. Ltd. Class A2.10%$0.4662.67%
023350.KSKorea Engineering Consultants Corp.2.10%$100.0016.54%
1423.TWReward Wool Industry Corporation2.10%$0.7918.73%
2811.TKagome Co., Ltd.2.10%$56.5639.32%
601456.SSGuolian Minsheng Securities Co., Ltd.2.10%$0.2168.71%
U10.SIUOB-Kay Hian Holdings Limited2.10%$0.0524.07%
UNBL.PAUnibel S.A.2.10%$24.7334.10%
3979.TUluru.Co.,Ltd.2.09%$8.7136.14%
600309.SSWanhua Chemical Group Co., Ltd.2.09%$1.6045.09%
7714.TWOUniforce Technology Corp.2.09%$3.8369.36%
ALIG.STAlimak Group AB (publ)2.09%$2.9845.61%
002226.SZAnhui Jiangnan Chemical Industry Co., Ltd.2.08%$0.1239.66%
002706.SZShanghai Liangxin Electrical Co.,LTD.2.08%$0.2279.51%
002763.SZShenzhen Huijie Group Co., Ltd.2.08%$0.1578.60%
4016.SRMiddle East Pharmaceutical Industries Company2.08%$2.3548.29%