Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Company Industry Sector

Fundamentals

Margins Returns Growth Rates Metrics/Ratios

Valuations

Projections DCF DDM EPV Multiples Valuations

Miscellaneous

Indicators Charts WACC Beta Predictability

Mode

Company Industry Sector

Ticker

Industry

Sector

Bharti Airtel Limited (BHARTIARTL.BO)

Company Dividend Discount ModelIndustry: Telecommunications ServicesSector: Communication Services

Valuation Snapshot

Stable Growth$1,767.11 - $6,023.25$2,899.85
Multi-Stage$1,142.76 - $1,248.77$1,194.80
Blended Fair Value$2,047.33
Current Price$1,878.40
Upside8.99%
DecisionDon't Buy

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 Rate8.56%8.56%8.56%
Growth Rate5.50%6.50%7.50%
Fair Value$1,767.11$2,899.85$6,023.25
Upside / Downside-5.92%54.38%220.66%

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 Rate8.56%8.56%8.56%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)156,082.74157,562.20159,041.66
Year 2 PV (M)195,672.32199,399.33203,161.50
Year 3 PV (M)232,908.82239,594.80246,407.52
Year 4 PV (M)267,893.37278,195.79288,792.55
Year 5 PV (M)300,723.25315,248.29330,329.25
PV of Terminal Value (M)5,729,325.596,006,054.166,293,373.78
Equity Value (M)6,882,606.097,196,054.577,521,106.25
Shares Outstanding (M)6,022.806,022.806,022.80
Fair Value$1,142.76$1,194.80$1,248.77
Upside / Downside-39.16%-36.39%-33.52%

High-Yield Dividend Screener

« Prev Page 46 of 151 Next »
Ticker ⇵ Company ⇵ Dividend Yield % ▼ Dividend Per Share ⇵ Payout Ratio % ⇵
ATCOLAtlas Corp.3.53%$0.8930.47%
AWC-R.BKAsset World Corp Public Company Limited3.53%$0.0737.62%
CCRO3.SACCR S.A.3.53%$0.4866.57%
HMU.DEHMS Bergbau AG3.53%$1.6929.89%
RAUTE.HERaute Oyj3.53%$0.5226.97%
RWE.DERWE AG3.53%$1.6646.76%
SNL.AXSupply Network Limited3.53%$1.1367.28%
0NHS.LNutrien Ltd.3.52%$2.1858.76%
CELL.MICellularline S.p.A.3.52%$0.0934.70%
INFREA.STInfrea AB3.52%$0.5067.57%
ISSP.JKPT Steel Pipe Industry of Indonesia Tbk3.52%$15.0019.85%
MGAMagna International Inc.3.52%$1.9252.47%
PARP.PAGroupe Partouche S.A.3.52%$0.6438.61%
PKI.TOParkland Corporation3.52%$1.4073.81%
SMU.SNSMU S.A.3.52%$5.4946.99%
161390.KSHankook Tire & Technology Co., Ltd.3.51%$2,000.0025.86%
300360.SZHangzhou Sunrise Technology Co., Ltd.3.51%$0.6152.03%
5106.KLAxis Real Estate Investment Trust3.51%$0.0756.99%
601128.SSJiangsu Changshu Rural Commercial Bank Co., Ltd.3.51%$0.2519.56%
INTP.JKPT Indocement Tunggal Prakarsa Tbk3.51%$259.8143.04%
RATO-A.STRatos AB (publ)3.51%$1.3512.15%
002887.SZTianjin LVYIN Landscape and Ecology Construction Co., Ltd3.50%$0.3384.50%
603062.SSMEGA P&C Advanced Materials (Shanghai) Company Limited3.50%$1.6674.27%
CMCLCaledonia Mining Corporation Plc3.50%$0.9235.87%
DLODLocal Limited3.50%$0.4987.74%
LAZLazard Ltd3.50%$1.7467.48%
TWL.MITraWell Co S.p.A.3.50%$0.2128.69%
WJP.SIVICOM Ltd3.50%$0.0666.95%
005610.KSSPC Samlip Co., Ltd.3.49%$1,803.3945.19%
0RFL.LVAT Group AG3.49%$12.5088.50%
2030.HKCabbeen Fashion Limited3.49%$0.0563.92%
5206.TWOKunyue Development Co., Ltd.3.49%$1.1821.91%
5246.KLWestports Holdings Berhad3.49%$0.2071.36%
5989.TH-One Co.,Ltd.3.49%$49.4414.49%
ACO-X.TOATCO Ltd.3.49%$1.9850.80%
CNICanadian National Railway Company3.49%$3.5050.64%
PEAB3.SACompanhia de Participações Aliança da Bahia3.49%$1.3678.68%
026960.KSDong Suh Companies Inc.3.48%$905.3362.72%
055550.KSShinhan Financial Group Co., Ltd.3.48%$2,668.7426.55%
0QK5.LINFICON Holding AG3.48%$3.4443.54%
6722.TWOWhetron Electronics Co.,Ltd.3.48%$1.9924.71%
HOLM-A.STHolmen AB (publ)3.48%$12.2366.11%
002206.SZZhejiang Hailide New Material Co.,Ltd3.47%$0.2043.30%
3004.SRNorthern Region Cement Company3.47%$0.2579.89%
4129.TWOUnited Orthopedic Corporation3.47%$3.8069.70%
600133.SSWuhan East Lake High Technology Group Co., Ltd.3.47%$0.3287.27%
601995.SSChina International Capital Corporation Limited3.47%$1.2162.35%
6471.TNSK Ltd.3.47%$33.8292.34%
CSED3.SACruzeiro do Sul Educacional S.A.3.47%$0.2130.49%
GPRA.JKPT Perdana Gapuraprima Tbk3.47%$5.0018.12%