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 15 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
1908.HKC&D International Investment Group Limited7.31%$1.1225.81%
2529.HKHollwin Urban Operation Service Group Co., Ltd7.31%$0.2224.64%
BMOB3.SABemobi Mobile Tech S.A.7.31%$1.6192.50%
CAMB3.SACambuci S.A.7.30%$0.7245.75%
CIP.AXCenturia Industrial REIT7.30%$0.2484.35%
NEO.BKNeo Corporate PCL7.30%$1.3550.11%
QTC.BKQTC Energy Public Company Limited7.30%$0.2597.23%
WHATS.BRWhat's Cooking Group NV/SA7.29%$8.2032.94%
C5H.IRCairn Homes plc7.28%$0.1544.15%
DOHI.QADoha Insurance Group Q.P.S.C.7.28%$0.1946.40%
STRN.SWSchlatter Industries AG7.28%$1.5052.09%
HDN.AXHomeCo Daily Needs REIT7.27%$0.1062.96%
IPCM.JKPT Jasa Armada Indonesia Tbk7.27%$26.1977.38%
O39.SIOversea-Chinese Banking Corporation Limited7.27%$1.4449.91%
THIP.BKThantawan Industry Public Company Limited7.27%$1.6450.43%
C6L.SISingapore Airlines Limited7.26%$0.4745.79%
SAPPE.BKSappe Public Company Limited7.26%$2.2382.18%
QIP.AXQANTM Intellectual Property Limited7.25%$0.1392.42%
KUOA.MXGrupo KUO, S.A.B. de C.V.7.24%$4.3464.64%
OYY.SIPropNex Limited7.24%$0.1493.41%
7035.KLCCK Consolidated Holdings Berhad7.23%$0.0976.61%
SOGN.OLSogn Sparebank7.22%$20.0011.36%
0QN6.LSF Urban Properties AG7.21%$7.2563.89%
WBC.AXWestpac Banking Corporation7.21%$2.8174.44%
120110.KSKolon Industries, Inc.7.20%$3,060.7698.52%
MILS3.SAMills Locação, Serviços e Logística S.A.7.20%$1.0181.51%
UZU.DEUzin Utz AG7.20%$5.1146.82%
3296.TNIPPON REIT Investment Corporation7.19%$7,108.4763.73%
600035.SSHubei Chutian Smart Communication Co.,Ltd.7.19%$0.2866.74%
036460.KSKorea Gas Corporation7.17%$2,752.5029.13%
HABITAT.SNAdministradora de Fondos de Pensiones Habitat S.A.7.17%$110.0070.97%
ITUB3.SAItaú Unibanco Holding S.A.7.17%$2.6064.54%
SAMF.JKPT Saraswanti Anugerah Makmur, Tbk7.17%$22.2285.61%
0HM0.LVGP N.V.7.16%$7.0036.73%
VLS.AXVita Life Sciences Limited7.16%$0.1855.52%
CRBN.ASCorbion N.V.7.15%$1.3455.86%
0586.HKChina Conch Venture Holdings Limited7.14%$0.6929.51%
600011.SSHuaneng Power International, Inc.7.14%$0.5357.39%
IFII.JKPT Indonesia Fibreboard Industry Tbk7.14%$16.0070.24%
UNTR.JKPT United Tractors Tbk7.14%$2,150.1250.66%
4987.TWOGodex International Co., Ltd7.12%$5.1885.38%
2328.HKPICC Property and Casualty Company Limited7.11%$1.1842.87%
CXSE3.SACaixa Seguridade Participações S.A.7.11%$1.1880.41%
PUB.PAPublicis Groupe S.A.7.11%$6.2349.76%
600057.SSXiamen Xiangyu Co., Ltd.7.10%$0.6177.47%
MYPK3.SAIochpe-Maxion S.A.7.09%$0.7051.81%
PRM-R.BKPrima Marine Public Company Limited7.09%$0.4949.90%
601187.SSXiamen Bank Co., Ltd.7.08%$0.5252.74%
014130.KSHanexpress.Co., Ltd7.07%$213.2520.61%
0NY3.LSTEF S.a.7.07%$9.1944.77%