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,231.74 - $3,542.92$3,384.44
Blended Fair Value$7,655.71
Current Price$1,878.40
Upside307.57%
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.06%5.06%5.06%
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.06%5.06%5.06%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)161,273.36162,802.02164,330.68
Year 2 PV (M)208,903.11212,882.13216,898.68
Year 3 PV (M)256,926.68264,302.12271,817.37
Year 4 PV (M)305,346.52317,089.28329,167.53
Year 5 PV (M)354,165.10371,271.41389,032.41
PV of Terminal Value (M)18,177,495.0119,055,474.8119,967,056.97
Equity Value (M)19,464,109.7820,383,821.7721,338,303.65
Shares Outstanding (M)6,022.806,022.806,022.80
Fair Value$3,231.74$3,384.44$3,542.92
Upside / Downside72.05%80.18%88.61%

High-Yield Dividend Screener

« Prev Page 16 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
0ELV.LGuerbet S.A.7.06%$1.0131.15%
215000.KQGOLFZON Co., Ltd.7.05%$3,999.3763.09%
HLAG.DEHapag-Lloyd AG7.05%$8.2861.62%
XVALO.MCVale S.A.7.05%$0.8162.96%
0GN6.LArgan S.A.7.04%$4.6130.62%
RIGD.ILReliance Industries Limited7.04%$5.008.14%
600098.SSGuangzhou Development Group Incorporated7.03%$0.4669.93%
SORKON.BKS. Khonkaen Foods Public Company Limited7.03%$0.2571.33%
Z74.SISingapore Telecommunications Limited7.03%$0.3287.72%
603995.SSYongjin Technology Group Co., Ltd.7.02%$1.2769.10%
6671.TWSan Neng Group Holdings Co., Ltd.7.02%$2.5194.63%
KPN.ASKoninklijke KPN N.V.7.02%$0.2869.30%
NNCL.BKNava Nakorn Public Company Limited7.02%$0.1182.26%
TEGH.BKThai Eastern Group Holdings Public Company Limited7.02%$0.2137.13%
ASTAK.ATAlpha Real Estate S.a.7.01%$0.5252.38%
INETREIT.BKINET Freehold and Leasehold Real Estate Investment Trust7.01%$0.8045.08%
ABTG.MIAlfio Bardolla Training Group S.p.A.7.00%$0.1235.81%
MMB.PALagardere S.A.7.00%$1.3164.26%
0010.HKHang Lung Group Limited6.99%$1.0742.37%
0RP0.LTikehau Capital6.99%$1.1166.15%
1066.HKShandong Weigao Group Medical Polymer Company Limited6.99%$0.3541.33%
CAT31.PACaisse Regionale de Credit Agricole Mutuel Toulouse 316.99%$7.4918.27%
037710.KSGwangju Shinsegae. Co. ,Ltd.6.98%$2,199.7640.80%
AP-R.BKAP (Thailand) Public Company Limited6.98%$0.6040.92%
EASON.BKEason & Co Public Company Limited6.97%$0.0860.98%
KENKenon Holdings Ltd.6.97%$4.7154.85%
015860.KSILJIN Holdings Co., Ltd.6.96%$474.0952.60%
3808.HKSinotruk (Hong Kong) Limited6.96%$1.9343.31%
603801.SSZbom Home Collection Co.,Ltd6.96%$0.6494.30%
WOMF.JKPT Wahana Ottomitra Multiartha Tbk6.96%$22.5631.36%
601225.SSShaanxi Coal Industry Company Limited6.95%$1.4875.05%
LOG.MCLogista Integral, S.A.6.95%$2.0980.25%
VCX.AXVicinity Centres6.95%$0.1852.81%
0QME.LOrell Füssli AG6.94%$8.3058.10%
3470.TMarimo Regional Revitalization REIT, Inc.6.94%$7,579.0662.91%
ARROW.BKArrow Syndicate Public Company Limited6.93%$0.3569.42%
003690.KSKorean Reinsurance Company6.92%$797.5138.80%
3279.TActivia Properties Inc.6.92%$9,742.1289.07%
IL0A.IRPermanent TSB Group Holdings plc6.92%$0.1639.09%
S41.SIHong Leong Finance Limited6.92%$0.1875.53%
SECURITY.SNGrupo Security S.A.6.92%$23.1197.85%
2377.HKChina Boqi Environmental (Holding) Co., Ltd.6.91%$0.0712.31%
601991.SSDatang International Power Generation Co., Ltd.6.91%$0.2465.75%
ALPJT.PAPoujoulat S.A.6.91%$0.5236.16%
AZM.MIAzimut Holding S.p.A.6.91%$2.4771.18%
PPF.BKPinthong Industrial Park Property Fund6.91%$0.7581.09%
BOLSAA.MXBolsa Mexicana de Valores, S.A.B. de C.V.6.90%$2.5984.50%
HYDRA.ASHydratec Industries N.V.6.90%$12.0839.09%
0O6D.LMiquel y Costas & Miquel, S.A.6.89%$1.0041.40%
0QO6.LJulius Bär Gruppe AG6.89%$3.9199.57%