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$2,356.05 - $12,726.91$4,614.09
Multi-Stage$1,338.60 - $1,463.80$1,400.06
Blended Fair Value$3,007.08
Current Price$1,878.40
Upside60.09%
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 Rate7.79%7.79%7.79%
Growth Rate5.50%6.50%7.50%
Fair Value$2,356.05$4,614.09$12,726.91
Upside / Downside25.43%145.64%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 Rate7.79%7.79%7.79%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)157,189.06158,679.00160,168.94
Year 2 PV (M)198,456.00202,236.03206,051.72
Year 3 PV (M)237,896.57244,725.73251,684.34
Year 4 PV (M)275,569.80286,167.44297,067.84
Year 5 PV (M)311,533.02326,580.18342,203.23
PV of Terminal Value (M)6,881,495.697,213,874.517,558,974.24
Equity Value (M)8,062,140.148,432,262.888,816,150.32
Shares Outstanding (M)6,022.806,022.806,022.80
Fair Value$1,338.60$1,400.06$1,463.80
Upside / Downside-28.74%-25.47%-22.07%

High-Yield Dividend Screener

« Prev Page 36 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
603317.SSSichuan Teway Food Group Co.,Ltd4.37%$0.5599.52%
ATRUST.ATAlpha Trust Mutual Fund and Alternative Investment Fund Management S.A.4.37%$0.5666.75%
BAM-R.BKBangkok Commercial Asset Management Public Company Limited4.37%$0.3550.66%
BPP-R.BKBanpu Power Public Company Limited4.37%$0.5585.50%
CRR-UN.TOCrombie Real Estate Investment Trust4.37%$0.6776.03%
U14.SIUOL Group Limited4.37%$0.3828.25%
016710.KSDaesung Holdings Co., Ltd.4.36%$368.1823.51%
093050.KSLF Corp.4.36%$772.5624.62%
600285.SSHenan Lingrui Pharmaceutical Co., Ltd.4.36%$0.9064.11%
EMAARDEV.AEEmaar Development PJSC4.36%$0.6827.01%
EN.PABouygues S.A.4.36%$1.9772.18%
HWX.TOHeadwater Exploration Inc.4.36%$0.4257.78%
PIRC.MIPirelli & C. S.p.A.4.36%$0.2651.67%
ZWACK.BDZwack Unicum Nyrt.4.36%$1,500.0088.31%
000531.SZGuangzhou Hengyun Enterprises Holding Ltd4.35%$0.2868.19%
000538.SZYunnan Baiyao Group Co.,Ltd4.35%$2.4784.67%
4792.TYAMADA Consulting Group Co.,Ltd.4.35%$76.8861.51%
603165.SSZhejiang Rongsheng Environmental Protection Paper Joint Stock Co., Ltd.4.35%$0.5573.83%
SBFG3.SAGrupo SBF S.A.4.35%$0.5537.97%
000240.KSHankook & Company Co., Ltd.4.34%$1,090.2033.39%
WCP.TOWhitecap Resources Inc.4.34%$0.5168.17%
8595.TJAFCO Group Co., Ltd.4.33%$104.3181.02%
ADW-A.TOAndrew Peller Limited4.33%$0.2364.87%
ITRNIturan Location and Control Ltd.4.33%$1.8464.72%
MRG-UN.TOMorguard North American Residential Real Estate Investment Trust4.33%$0.7528.03%
SYNEX-R.BKSynnex (Thailand) Public Company Limited4.33%$0.4353.70%
002275.SZGuilin Sanjin Pharmaceutical Co., Ltd.4.32%$0.6168.51%
091700.KQPartron Co., Ltd.4.32%$299.9351.71%
000333.SZMidea Group Co., Ltd.4.31%$3.3757.37%
002460.KSHS Hwasung Co., Ltd.4.31%$499.9314.25%
002833.SZGuangzhou KDT Machinery Co.,Ltd.4.31%$0.7074.51%
1050.HKKarrie International Holdings Limited4.31%$0.1159.43%
2763.TFTGroup Co., Ltd.4.31%$55.3330.88%
SB1NO.OLSpareBank 1 Sørøst-Norge4.31%$8.5049.18%
018250.KSAekyung Industrial Co., Ltd.4.30%$579.5745.50%
300441.SZNingbo BaoSi Energy Equipment Co., Ltd.4.30%$0.3272.05%
4042.TTosoh Corporation4.30%$101.0478.91%
4261.SRTheeb Rent A Car Company4.30%$1.6436.96%
AVIA.JKPT Avia Avian Tbk4.30%$22.3878.99%
PREVA.ASValue8 N.V.4.30%$0.2111.56%
SONYN.MXSony Group Corporation4.30%$20.0110.30%
SYMC.BKSymphony Communication Public Company Limited4.30%$0.1542.26%
TOA.BKTOA Paint (Thailand) Public Company Limited4.30%$0.5846.29%
2546.TWKedge Construction Co., Ltd.4.29%$3.6945.15%
267290.KSKyungdong City Gas Co., Ltd4.29%$875.0617.76%
601168.SSWestern Mining Co.,Ltd.4.29%$1.1989.92%
INH.DEINDUS Holding AG4.29%$1.2259.56%
OSP-R.BKOsotspa Public Company Limited4.29%$0.6959.37%
PE1.AXPengana Private Equity Trust4.29%$0.0632.51%
003540.KSDaishin Securities Co., Ltd.4.28%$1,158.7444.30%