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 8 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
035810.KQEASY HOLDINGS Co., Ltd.9.64%$435.2887.39%
0623.HKSinoMedia Holding Limited9.64%$0.1944.98%
ITSA3.SAItaúsa S.A.9.64%$1.1780.68%
MFG.AXMagellan Financial Group Limited9.64%$0.9634.94%
PMTA.BKPM Thoresen Asia Holdings Public Company Limited9.64%$0.9860.98%
2989.TTokaido REIT, Inc.9.63%$11,143.4889.54%
SBMO.ASSBM Offshore N.V.9.63%$2.3853.44%
0576.HKZhejiang Expressway Co., Ltd.9.62%$0.6974.90%
INVEST.HEInvestors House Oyj9.62%$0.3663.41%
MFEC.BKMFEC Public Company Limited9.62%$0.5094.79%
PIKK.MEPJSC PIK-specialized homebuilder9.61%$45.9431.14%
6868.HKTenfu (Cayman) Holdings Company Limited9.60%$0.2693.07%
601077.SSChongqing Rural Commercial Bank Co., Ltd.9.58%$0.6286.18%
SIQ.AXSmartgroup Corporation Ltd9.58%$0.8777.09%
5012.KLTa Ann Holdings Berhad9.57%$0.4093.61%
PAC.AXPacific Current Group Limited9.57%$0.9623.44%
MTO.AXMotorCycle Holdings Limited9.56%$0.3068.86%
HME.VHemisphere Energy Corporation9.55%$0.1957.92%
0382.HKEdvantage Group Holdings Limited9.54%$0.1412.43%
0OQQ.LInfotel S.A.9.54%$4.0386.81%
VIE.PAVeolia Environnement S.A.9.53%$2.8797.23%
0QJX.LEFG International AG9.52%$1.8196.44%
601998.SSChina CITIC Bank Corporation Limited9.51%$0.7368.88%
0752.HKPico Far East Holdings Limited9.50%$0.2545.55%
MRN.PAMersen S.A.9.50%$2.3045.40%
MTS.AXMetcash Limited9.50%$0.3164.02%
SYNE3.SASYN prop e tech S.A.9.50%$0.4659.20%
TEXF.BRTexaf S.A.9.50%$3.4063.35%
601997.SSBank of Guiyang Co.,Ltd.9.49%$0.5639.86%
WMA.AXWam Alternative Assets Limited9.49%$0.109.12%
0135.HKKunlun Energy Company Limited9.48%$0.7052.47%
SC-R.BKSC Asset Corporation Public Company Limited9.47%$0.1648.63%
0DLI.LAcomo N.V.9.45%$2.4067.74%
AFYAAfya Limited9.45%$1.4117.69%
BBRI.JKPT Bank Rakyat Indonesia (Persero) Tbk9.44%$343.6092.61%
TEKA.BKTeka Construction Public Company Limited9.44%$0.1696.55%
8964.TFrontier Real Estate Investment Corporation9.39%$8,736.6196.39%
ALLA.BKAlla Public Company Limited9.39%$0.1177.39%
4333.SRTaleem REIT Fund9.38%$0.9670.19%
SHL.AXSonic Healthcare Limited9.38%$2.1198.90%
TQM-R.BKTQM Alpha Public Company Limited9.37%$1.0882.74%
0882.HKTianjin Development Holdings Limited9.36%$0.2321.27%
0O84.LDNB Bank ASA9.36%$17.5255.97%
4339.SRDerayah Financial - Derayah Reit Fund9.36%$0.4982.63%
601390.SSChina Railway Group Limited9.35%$0.5150.32%
CPACopa Holdings, S.A.9.35%$11.3970.44%
BRSR3.SABanco do Estado do Rio Grande do Sul S.A.9.34%$1.5649.87%
RET.BRRetail Estates N.V.9.34%$5.9746.68%
0265.HKGangyu Smart Urban Services Holdings Limited9.33%$0.1868.15%
KGKC.MEPJSC Kurgan Generation Company9.33%$4.0370.77%