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 30 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
DIB.AEDubai Islamic Bank P.J.S.C.4.96%$0.4741.66%
002701.SZORG Technology Co.,Ltd.4.95%$0.2968.18%
3702.TWWPG Holdings Limited4.95%$2.9381.01%
5353.TWOTailyn Technologies, Inc.4.95%$1.2992.09%
8966.THeiwa Real Estate REIT, Inc.4.95%$7,784.9462.25%
BOBA.JKPT Formosa Ingredient Factory Tbk4.95%$9.0050.69%
EPG-R.BKEastern Polymer Group Public Company Limited4.95%$0.1439.44%
MMP-UN.TOPrecious Metals and Mining Trust4.95%$0.1937.80%
VFQS.QAVodafone Qatar P.Q.S.C.4.95%$0.1280.20%
WJX.TOWajax Corporation4.95%$1.3765.74%
0RI3.LPareto Bank ASA4.94%$4.4950.07%
3226.TMitsui Fudosan Accommodations Fund Inc.4.94%$6,633.1172.65%
600987.SSZhejiang Hangmin Co.,Ltd4.94%$0.3447.75%
6596.TWOKuang Hong Arts Management Incorporation4.94%$6.9937.90%
ALLUX.PAInstallux S.A.4.94%$15.3129.71%
5110.SRSaudi Electricity Company4.93%$0.7051.64%
HYPE3.SAHypera S.A.4.93%$1.1588.85%
0966.HKChina Taiping Insurance Holdings Company Limited4.92%$0.9521.78%
5213.TWOYeaShin International Development Co., Ltd.4.92%$1.1837.56%
600295.SSInner Mongolia Erdos Resources Co.,ltd.4.92%$0.6192.93%
6192.TWLumax International Corp., Ltd.4.92%$5.4852.55%
E3G1.SGEvolution AB (publ)4.92%$2.8450.73%
XO.BKExotic Food Public Company Limited4.92%$0.7257.45%
059090.KQMiCo Ltd.4.91%$674.3669.83%
0662.HKAsia Financial Holdings Limited4.91%$0.2419.50%
4928.TNoevir Holdings Co., Ltd.4.91%$224.9495.68%
600970.SSSinoma International Engineering Co.Ltd4.91%$0.5144.22%
601319.SSThe People's Insurance Company (Group) of China Limited4.91%$0.4442.28%
EVLI.HEEvli Oyj4.91%$1.1492.58%
MRXMarex Group plc Ordinary Shares4.91%$1.8638.69%
SPMA.JKPT Suparma Tbk4.91%$11.9734.68%
TABREED.AENational Central Cooling Company PJSC4.91%$0.1677.99%
081660.KSMisto Holdings Corp.4.90%$2,010.6262.73%
300770.SZGuangdong South New Media Co.,Ltd.4.90%$2.0863.80%
7944.TRoland Corporation4.90%$174.9564.69%
IGTInternational Game Technology PLC4.90%$0.8083.51%
SYDB.COSydbank A/S4.90%$27.5761.30%
7246.KLSignature International Berhad4.89%$0.0748.72%
9917.TWTaiwan Secom Co., Ltd.4.89%$5.2880.23%
QBE.AXQBE Insurance Group Limited4.89%$0.9739.27%
TRIS3.SATrisul S.A.4.89%$0.3025.32%
000877.SZTianshan Material Co., Ltd.4.88%$0.2693.74%
0236.HKSan Miguel Brewery Hong Kong Limited4.88%$0.0633.49%
4007.SRAl Hammadi Holding Company4.88%$1.3884.27%
600901.SSJiangsu Financial Leasing Co., Ltd.4.88%$0.3054.72%
601098.SSChina South Publishing & Media Group Co., Ltd4.88%$0.5562.37%
SPIE.PASPIE S.a.4.88%$2.4095.87%
TOTO.JKPT Surya Toto Indonesia Tbk4.88%$13.1736.11%
002035.SZVatti Corporation Limited4.87%$0.3057.45%
002807.SZJiangsu Jiangyin Rural Commercial Bank Co.,LTD.4.87%$0.2225.03%