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$10,802.27 - $12,726.91$11,926.98
Multi-Stage$3,056.54 - $3,350.49$3,200.79
Blended Fair Value$7,563.88
Current Price$1,878.40
Upside302.68%
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 Rate5.18%5.18%5.18%
Growth Rate5.50%6.50%7.50%
Fair Value$10,802.27$11,926.98$12,726.91
Upside / Downside475.08%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 Rate5.18%5.18%5.18%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)161,097.64162,624.63164,151.62
Year 2 PV (M)208,448.10212,418.45216,426.26
Year 3 PV (M)256,087.72263,439.08270,929.80
Year 4 PV (M)304,017.83315,709.49327,735.19
Year 5 PV (M)352,239.75369,253.06386,917.51
PV of Terminal Value (M)17,127,028.4817,954,270.3618,813,172.73
Equity Value (M)18,408,919.5219,277,715.0820,179,333.11
Shares Outstanding (M)6,022.806,022.806,022.80
Fair Value$3,056.54$3,200.79$3,350.49
Upside / Downside62.72%70.40%78.37%

High-Yield Dividend Screener

« Prev Page 34 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
BILI-A.STBilia AB (publ)4.58%$6.0877.85%
SHA.AXSHAPE Australia Corporation Limited4.58%$0.2863.86%
SUTHA.BKGolden Lime Public Company Limited4.58%$0.1279.88%
YUASA.BKYuasa Battery (Thailand) Public Company Limited4.58%$0.6126.69%
001323.SZDe Rucci Healthy Sleep Co., Ltd.4.57%$1.1972.11%
FNAC.PAFnac Darty S.A.4.57%$1.3429.18%
CRSU.PACaisse Régionale de Crédit Agricole Mutuel Sud Rhône Alpes4.56%$8.7019.97%
ELIN.ATElinoil Hellenic Petroleum Company S.A.4.56%$0.1127.16%
000596.SZAnhui Gujing Distillery Co., Ltd.4.55%$6.0467.48%
002483.SZJiangsu Rainbow Heavy Industries Co., Ltd.4.55%$0.3263.40%
002746.SZShandong Xiantan Co., Ltd.4.55%$0.2882.68%
NSL-R.BKNSL Foods Public Company Limited4.55%$1.0551.73%
600350.SSShandong Hi-speed Company Limited4.54%$0.4464.80%
7463.TAdvan Group Co., Ltd.4.54%$41.5719.08%
SEGMN.ISSegmen Kardesler Gid Urt Ve Amblj Sny AS4.54%$0.8469.37%
005180.KSBinggrae Co., Ltd.4.53%$3,299.7936.30%
6873.TWHD Renewable Energy Co., Ltd.4.53%$4.5378.62%
300193.SZShenzhen Jasic Technology Co.,Ltd.4.52%$0.4081.71%
5904.TWOPOYA International Co., Ltd.4.52%$20.1875.14%
600282.SSNanjing Iron & Steel Co., Ltd.4.52%$0.2454.66%
603689.SSAnhui Province Natural Gas DevelopmentCo.,Ltd.4.52%$0.3769.94%
688036.SSShenzhen Transsion Holdings Co., Ltd.4.52%$2.9990.95%
ALCLA.PAClasquin S.A.4.52%$6.4148.30%
023000.KSSAMWONSTEEL Co.,Ltd.4.51%$108.3244.46%
0QNM.LAdecco Group AG4.51%$1.0462.86%
9539.SRAqaseem Factory for Chemicals and Plastics Co.4.51%$0.2165.70%
DUI.AXDiversified United Investment Limited4.51%$0.2470.80%
SLIGR.ASSligro Food Group N.V.4.51%$0.47100.00%
032640.KSLG Uplus Corp.4.50%$650.0160.09%
4165.SRAl Majed Oud Co.4.50%$6.0082.11%
000411.SZZhejiang Int'l Group Co.,Ltd.4.49%$0.5761.70%
002543.SZGuangdong Vanward New Electric Co., Ltd.4.49%$0.4649.41%
003070.KSKolon Global Corporation4.49%$401.8773.73%
601665.SSQilu Bank Co., Ltd.4.49%$0.2628.78%
BSANTANDER.SNBanco Santander-Chile4.49%$3.1956.12%
GPW.WAGielda Papierów Wartosciowych w Warszawie S.A.4.49%$2.9966.28%
SHUR.BRShurgard Self Storage S.A.4.49%$1.3113.81%
044450.KSKSS Line Ltd.4.48%$397.8627.45%
0OR2.LLNA Santé S.A.4.48%$1.1025.22%
2731.TWLion Travel Service Co., Ltd.4.48%$7.4848.12%
4104.TWExcelsior Medical Co., Ltd.4.48%$3.6277.21%
7167.KLAble Global Berhad4.48%$0.0731.97%
7593.TVt Holdings Co.,Ltd.4.48%$24.0056.43%
0IPY.LAubay S.A.4.47%$2.5247.60%
3020.SRYamama Saudi Cement Company4.47%$1.0650.72%
3114.TWOHowteh Technology Co., Ltd.4.47%$1.1951.28%
CCEPCoca-Cola Europacific Partners PLC4.47%$3.9457.53%
CMCanadian Imperial Bank of Commerce4.47%$4.1147.39%
QIIK.QAQatar International Islamic Bank (Q.P.S.C)4.47%$0.5158.75%
1515.HKChina Resources Medical Holdings Company Limited4.46%$0.1423.71%