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,650.45 - $12,726.91$11,926.98
Multi-Stage$1,779.56 - $1,948.01$1,862.24
Blended Fair Value$6,894.61
Current Price$1,878.40
Upside267.05%
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.66%6.66%6.66%
Growth Rate5.50%6.50%7.50%
Fair Value$4,650.45$11,926.98$12,726.91
Upside / Downside147.57%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.66%6.66%6.66%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)158,855.87160,361.62161,867.36
Year 2 PV (M)202,687.13206,547.75210,444.79
Year 3 PV (M)245,545.00252,593.72259,776.05
Year 4 PV (M)287,445.50298,499.84309,870.00
Year 5 PV (M)328,404.38344,266.43360,735.56
PV of Terminal Value (M)9,495,009.399,953,621.9010,429,786.58
Equity Value (M)10,717,947.2711,215,891.2511,732,480.34
Shares Outstanding (M)6,022.806,022.806,022.80
Fair Value$1,779.56$1,862.24$1,948.01
Upside / Downside-5.26%-0.86%3.71%

High-Yield Dividend Screener

« Prev Page 2 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
0081.HKChina Overseas Grand Oceans Group Limited15.97%$0.3160.87%
QRF.BRQrf Comm. VA15.92%$1.6488.42%
INC-UN.TOIncome Financial Trust15.90%$1.4843.23%
QRI.AXQualitas Real Estate Income Fund15.90%$0.2594.00%
9172.KLFormosa Prosonic Industries Berhad15.89%$0.1872.55%
1099.HKSinopharm Group Co. Ltd.15.88%$3.1363.13%
XBBDC.MCBanco Bradesco S.A.15.82%$0.4623.31%
LPIN.JKPT Multi Prima Sejahtera Tbk15.59%$69.5396.86%
LFG.AXLiberty Financial Group Limited15.46%$0.6679.98%
ALPDX.PAPiscines Desjoyaux S.A.15.43%$2.0088.06%
2660.HKZengame Technology Holding Limited15.29%$0.3942.93%
CD3.AXCD Private Equity Fund III15.14%$0.1791.41%
PAGSPagSeguro Digital Ltd.15.12%$1.4619.46%
0912.HKSuga International Holdings Limited15.10%$0.1669.91%
RUI.PARubis15.03%$4.8772.73%
WAM.AXWAM Capital Limited15.01%$0.2767.95%
0113.HKDickson Concepts (International) Limited15.00%$0.8467.46%
0830.HKChina State Construction Development Holdings Limited14.96%$0.1834.59%
FFARM.ASForFarmers N.V.14.96%$0.6785.82%
BM.BKBangkok Sheet Metal Public Company Limited14.94%$0.1777.02%
DGS.TODividend Growth Split Corp.14.90%$1.1529.30%
6110.HKTopsports International Holdings Limited14.83%$0.4376.21%
GLB.AXGlobe International Limited14.83%$0.3872.14%
MOT.AXMetrics Income Opportunities Trust14.82%$0.2879.33%
CIQ-UN.TOCanadian High Income Equity Fund14.80%$1.0424.28%
BBVA.DEBanco Bilbao Vizcaya Argentaria, S.A.14.69%$0.6438.92%
601169.SSBank of Beijing Co., Ltd.14.63%$0.8064.51%
0184.HKKeck Seng Investments (Hong Kong) Limited14.62%$0.3123.90%
0881.HKZhongsheng Group Holdings Limited14.56%$1.7065.93%
6626.HKYuexiu Services Group Limited14.51%$0.3664.32%
ALNU.MEPJSC ALROSA-Nyurba14.51%$9,491.6654.89%
NONG.OLSpareBank 1 Nord-Norge14.36%$21.7372.60%
0640.HKInfinity Development Holdings Company Limited14.32%$0.3651.92%
2558.HKJinshang Bank Co., Ltd.14.28%$0.2031.14%
0270.HKGuangdong Investment Limited14.27%$0.9899.44%
0517.HKCOSCO SHIPPING International (Hong Kong) Co., Ltd.14.01%$0.8888.71%
2560.HKAnhui Conch Material Technology Co Ltd14.01%$0.2449.79%
WTCM.MEJoint Stock Company "World Trade Center Moscow"13.98%$1.9924.33%
6186.HKChina Feihe Limited13.94%$0.5681.20%
601186.SSChina Railway Construction Corporation Limited13.92%$1.0764.40%
CFEB.BRCompagnie d'Entreprises CFE S.A.13.92%$1.2171.32%
PMV.AXPremier Investments Limited13.92%$1.9251.67%
601229.SSBank of Shanghai Co., Ltd.13.82%$1.4093.74%
2120.HKWenzhou Kangning Hospital Co., Ltd.13.78%$1.3769.01%
DLNGDynagas LNG Partners LP13.72%$0.5131.08%
MXT.AXMetrics Master Income Trust13.71%$0.2785.17%
0085.HKChina Electronics Huada Technology Company Limited13.70%$0.1947.52%
0046.HKComputer And Technologies Holdings Limited13.69%$0.2285.50%
601328.SSBank of Communications Co., Ltd.13.66%$0.9992.22%
AKER.OLAker ASA13.66%$106.4372.10%