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 10 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
BNGA.JKPT Bank CIMB Niaga Tbk8.91%$157.7256.96%
QIGD.QAQatari Investors Group Q.S.C.8.91%$0.1397.17%
MCS-R.BKM.C.S. Steel Public Company Limited8.90%$0.7434.29%
0QR1.LSchweiter Technologies AG8.89%$22.4090.72%
0816.HKJinmao Property Services Co., Limited8.88%$0.2355.27%
3492.TMIRARTH Real Estate Investment Corporation8.88%$8,301.0988.12%
3998.HKBosideng International Holdings Limited8.86%$0.4070.17%
PJP.WAPJP Makrum S.A.8.86%$1.4265.03%
603565.SSShanghai Zhonggu Logistics Co., Ltd.8.84%$0.8987.23%
ALVAP.PAKumulus Vape S.A.8.83%$0.3724.09%
IPS.PAIpsos S.A.8.83%$2.9938.93%
RFF.AXRural Funds Group8.83%$0.1715.19%
KOV.AXKorvest Ltd8.81%$1.2460.47%
0QUS.LG5 Entertainment AB (publ)8.80%$8.0594.74%
9620.SRBalsm Alofoq Medical Co.8.80%$2.4063.98%
PPM.AXPepper Money Limited8.80%$0.2044.77%
VK.PAVallourec S.A.8.80%$1.4183.22%
BBNI.JKPT Bank Negara Indonesia (Persero) Tbk8.79%$374.4666.86%
KJL.BKKijcharoen Engineering Electric Public Company Limited8.79%$0.5473.06%
0856.HKVSTECS Holdings Limited8.78%$0.7147.24%
BA-R.BKBangkok Airways Public Company Limited8.78%$1.3083.23%
PFRM3.SAProfarma Distribuidora de Produtos Farmacêuticos S.A.8.78%$0.7478.88%
0001.HKCK Hutchison Holdings Limited8.77%$4.7359.96%
NOBLE-R.BKNoble Development Public Company Limited8.75%$0.1927.34%
RANA.OLRana Gruber ASA8.75%$6.7583.80%
PDG.BKProdigy Public Company Limited8.74%$0.2690.35%
WHC.AXWhitehaven Coal Limited8.74%$0.6856.57%
DLTA.JKPT Delta Djakarta Tbk8.73%$175.4299.09%
8371.HKTaste Gourmet Group Limited8.70%$0.1853.44%
TRAN.BACompañía de Transporte de Energía Eléctrica en Alta Tensión Transener S.A.8.70%$301.7991.83%
0257.HKChina Everbright Environment Group Limited8.69%$0.4235.73%
EMB.AXEmbelton Limited8.69%$0.7069.10%
HP3A.DERingmetall SE8.69%$0.2438.33%
RDTX.JKPT Roda Vivatex Tbk8.69%$1,103.9395.63%
S56.SISamudera Shipping Line Ltd8.69%$0.1060.61%
1307.TWSan Fang Chemical Industry Co., Ltd.8.68%$2.7091.10%
ASIZ.LAberforth Split Level Income ZDP 20248.68%$11.0447.29%
PIC.AXPerpetual Equity Investment Company Limited8.68%$0.1197.90%
CPHN.SWCPH Chemie + Papier Holding AG8.66%$5.9989.84%
JIN.AXJumbo Interactive Limited8.66%$0.9974.11%
PM-R.BKPremier Marketing Public Company Limited8.66%$1.0390.60%
0546.HKFufeng Group Limited8.65%$0.7030.72%
ITB.DEImperial Brands PLC8.65%$3.0955.77%
LOGG3.SALOG Commercial Properties e Participações S.A.8.64%$2.1949.79%
5547.TWOJioushun Construction Co., Ltd.8.63%$2.2658.13%
TWD.AXTamawood Limited8.62%$0.2480.43%
UNITED.HEUnited Bankers Oyj8.60%$1.6153.91%
DDR.AXDicker Data Limited8.58%$0.8796.73%
PATO.BKPato Chemical Industry Public Company Limited8.58%$0.6098.05%
0371.HKBeijing Enterprises Water Group Limited8.56%$0.2164.00%