Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Ticker

Industry

Sector

Bharti Airtel Limited (BHARTIARTL.BO)

Company Dividend Discount ModelIndustry: Telecommunications ServicesSector: Communication Services

Valuation Snapshot

Stable Growth$4,051.15 - $12,726.91$11,926.98
Multi-Stage$1,695.74 - $1,855.96$1,774.38
Blended Fair Value$6,850.68
Current Price$1,878.40
Upside264.71%
DecisionBuy

Dividend History & Growth Metrics (10Y)

Metric5Y CAGR10Y CAGR2025202420232022202120202019201820172016
DPS30.59%15.77%11.516.955.962.404.473.037.745.421.521.77
YoY Growth--65.73%16.57%148.64%-46.34%47.33%-60.82%42.77%256.15%-14.15%-33.40%
Dividend Yield--0.57%0.48%0.68%0.35%0.87%0.55%2.26%1.58%0.44%0.54%

Stable Growth Model (Adjusted)

(USD in Millions except Per Share Data)
Net Income To Common (M)385,426.00
(-) Cash Dividends Paid (M)114,035.00
(=) Cash Retained (M)271,391.00
MetricLOWBASEHIGH
Required Retention Ratio20.0%12.5%7.5%
(=) Cash Required (M)77,085.2048,178.2528,906.95
Cash Retained (M)271,391.00271,391.00271,391.00
(-) Cash Required (M)-77,085.20-48,178.25-28,906.95
(=) Excess Retained (M)194,305.80223,212.75242,484.05
(/) Shares Outstanding (M)6,022.806,022.806,022.80
(=) Excess Retained per Share32.2637.0640.26
LTM Dividend per Share18.9318.9318.93
(+) Excess Retained per Share32.2637.0640.26
(=) Adjusted Dividend51.2056.0059.19
WACC / Discount Rate6.83%6.83%6.83%
Growth Rate5.50%6.50%7.50%
Fair Value$4,051.15$11,926.98$12,726.91
Upside / Downside115.67%534.95%577.54%

Multi-Stage Model: Projections

(USD in Millions)
MetricTTMDec-27Dec-28Dec-29Dec-30Dec-31Terminal
Net Income (M)385,426.00410,478.69437,159.80465,575.19495,837.58528,067.02543,909.03
Payout Ratio29.59%41.67%53.75%65.83%77.92%90.00%92.50%
Projected Dividends (M)114,035.00171,043.98234,982.34306,510.02386,343.50475,260.32503,115.86

Multi-Stage Valuation

MetricLOWBASEHIGH
WACC / Discount Rate6.83%6.83%6.83%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)158,600.40160,103.72161,607.04
Year 2 PV (M)202,035.72205,883.93209,768.44
Year 3 PV (M)244,362.22251,376.98258,524.72
Year 4 PV (M)285,600.83296,584.23307,881.42
Year 5 PV (M)325,772.09341,507.01357,844.13
PV of Terminal Value (M)8,996,729.039,431,274.419,882,450.86
Equity Value (M)10,213,100.2910,686,730.2711,178,076.62
Shares Outstanding (M)6,022.806,022.806,022.80
Fair Value$1,695.74$1,774.38$1,855.96
Upside / Downside-9.72%-5.54%-1.19%

High-Yield Dividend Screener

« Prev Page 5 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
U11.SIUnited Overseas Bank Limited11.62%$4.1058.46%
9543.SRSaudi Networkers Services Company11.60%$8.7072.96%
0688.HKChina Overseas Land & Investment Limited11.57%$1.4538.43%
0QKP.LPhoenix Mecano AG11.55%$51.5065.02%
601668.SSChina State Construction Engineering Corporation Limited11.55%$0.5954.79%
5983.KLMBM Resources Bhd11.49%$0.6069.77%
601800.SSChina Communications Construction Company Limited11.48%$0.9576.83%
0440.HKDah Sing Financial Holdings Limited11.45%$4.0834.85%
H02.SIHaw Par Corporation Limited11.39%$1.8082.18%
EDV.AXEndeavour Group Limited11.35%$0.4279.74%
102260.KSDongsung Chemical Co., Ltd.11.33%$470.0161.08%
092230.KSKPX Holdings Co.,Ltd.11.32%$8,125.9434.75%
9909.HKPowerlong Commercial Management Holdings Limited11.28%$0.2829.74%
SVR.AXSolvar Limited11.25%$0.2083.01%
HOLCO.ASHolland Colours N.V.11.23%$9.8877.82%
RBN-UN.TOBlue Ribbon Income Fund11.23%$0.9343.10%
0066.HKMTR Corporation Limited11.22%$3.3977.76%
3360.HKFar East Horizon Limited11.17%$0.8944.98%
0934.HKSinopec Kantons Holdings Limited11.16%$0.4758.03%
317400.KSXi S&D Inc.11.16%$481.1664.89%
0146.HKTai Ping Carpets International Limited11.12%$0.2151.92%
096760.KSJW Holdings Corporation11.12%$390.8363.07%
3868.HKXinyi Energy Holdings Limited11.12%$0.1360.32%
BMW3.DEBayerische Motoren Werke AG11.11%$10.5291.60%
1109.HKChina Resources Land Limited11.09%$3.0736.44%
2380.HKChina Power International Development Limited11.08%$0.3656.67%
3900.HKGreentown China Holdings Limited11.07%$0.9398.98%
600016.SSChina Minsheng Banking Corp., Ltd.11.06%$0.4261.11%
BFG.AXBell Financial Group Limited11.06%$0.1590.20%
1571.HKXin Point Holdings Limited11.03%$0.4241.05%
601577.SSBank of Changsha Co., Ltd.11.03%$1.0752.50%
IMMOU.BRImmo Moury SCA11.02%$3.5993.20%
2555.HKSichuan Baicha Baidao Industrial Co., Ltd.11.00%$0.7076.19%
POMO3.SAMarcopolo S.A.10.98%$0.6158.30%
IEL.AXIDP Education Limited10.96%$0.6398.92%
1579.HKYihai International Holding Ltd.10.95%$1.4288.97%
SPTO.JKPT Surya Pertiwi Tbk10.93%$70.5268.08%
TOTG.OLTotens Sparebank10.91%$31.6287.19%
1052.HKYuexiu Transport Infrastructure Limited10.89%$0.5162.60%
601919.SSCOSCO SHIPPING Holdings Co., Ltd.10.89%$1.6567.32%
DETEC.HEDetection Technology Oyj10.89%$1.2399.18%
018500.KSDongwon Metal Co., Ltd.10.86%$150.3024.83%
3799.HKDali Foods Group Company Limited10.86%$0.4172.83%
EBRO.MCEbro Foods, S.A.10.86%$2.0177.79%
023590.KSDaou Technology Inc.10.85%$4,297.7041.75%
0392.HKBeijing Enterprises Holdings Limited10.84%$3.4643.30%
NOVC.DENovo Nordisk A/S10.83%$9.9046.60%
0408.HKYip's Chemical Holdings Limited10.81%$0.2048.65%
4342.SRJadwa Investment - Jadwa Reit Saudi Fund10.80%$1.2085.91%
RIAS-B.CORIAS A/S10.79%$73.9373.44%