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,648.31 - $12,726.91$11,926.98
Multi-Stage$1,779.29 - $1,947.71$1,861.95
Blended Fair Value$6,894.47
Current Price$1,878.40
Upside267.04%
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,648.31$11,926.98$12,726.91
Upside / Downside147.46%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.08160,360.82161,866.55
Year 2 PV (M)202,685.11206,545.69210,442.69
Year 3 PV (M)245,541.32252,589.93259,772.16
Year 4 PV (M)287,439.75298,493.87309,863.81
Year 5 PV (M)328,396.17344,257.83360,726.55
PV of Terminal Value (M)9,493,391.039,951,925.3710,428,008.89
Equity Value (M)10,716,308.4711,214,173.5111,730,680.66
Shares Outstanding (M)6,022.806,022.806,022.80
Fair Value$1,779.29$1,861.95$1,947.71
Upside / Downside-5.28%-0.88%3.69%

High-Yield Dividend Screener

« Prev Page 4 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
EG7.IRFBD Holdings plc12.49%$1.9761.47%
WILCG. Willi-Food International Ltd.12.48%$3.5852.70%
9908.HKJiaXing Gas Group Co., Ltd.12.44%$1.0240.94%
MPMX.JKPT Mitra Pinasthika Mustika Tbk12.44%$120.0095.84%
0QL5.LCarlo Gavazzi Holding AG12.42%$20.0062.49%
GOZ.AXGrowthpoint Properties Australia12.40%$0.3016.37%
1999.HKMan Wah Holdings Limited12.39%$0.5757.62%
1285.HKJiashili Group Limited12.38%$0.1455.24%
600015.SSHua Xia Bank Co., Limited12.36%$0.8549.77%
BNP.DEBNP Paribas S.A.12.28%$10.0751.11%
0836.HKChina Resources Power Holdings Company Limited12.20%$2.1541.97%
BIS.AXBisalloy Steel Group Limited12.19%$0.5981.88%
KBS.BKKhonburi Sugar Public Company Limited12.17%$0.7056.34%
9300.SRAlwaha REIT Fund12.14%$1.1871.67%
2005.HKSSY Group Limited12.13%$0.3550.50%
BGI-UN.TOBrookfield Global Infrastructure Securities Income Fund12.09%$0.9646.13%
2003.HKVCREDIT Holdings Limited12.07%$0.3218.47%
1713.HKSichuan Energy Investment Development Co., Ltd.12.02%$0.2941.35%
NSI.ASNSI N.V.12.02%$2.3330.60%
RIO1.DERio Tinto Group12.02%$8.2864.54%
IGL.AXIVE Group Limited12.01%$0.3574.81%
0G5B.LSto SE & Co. KGaA12.00%$14.6483.41%
CDU.LSConduril - Engenharia, S.A.12.00%$1.8069.00%
2156.HKC&D Property Management Group Co. Limited11.98%$0.3354.74%
0057.HKChen Hsong Holdings Limited11.94%$0.1945.38%
BBSE3.SABB Seguridade Participações S.A.11.93%$4.2691.94%
SWUT.VISW Umwelttechnik Stoiser & Wolschner AG11.93%$3.7034.18%
0Q76.LCBo Territoria S.A.11.92%$0.4461.80%
ALCOF.PACofidur S.A.11.92%$34.8038.87%
0239.HKPak Fah Yeow International Limited11.87%$0.2852.60%
2356.HKDah Sing Banking Group Limited11.87%$1.2941.19%
3311.HKChina State Construction International Holdings Limited11.87%$1.1029.31%
ENGI.PAEngie S.A.11.87%$2.7376.93%
SENA.BKSena Development Public Company Limited11.86%$0.2074.93%
4348.SRAlkhabeer REIT Fund11.85%$0.6698.08%
AWZ.SIMulti-Chem Limited11.83%$0.4160.70%
0331.HKFSE Lifestyle Services Limited11.81%$0.6731.73%
SUL.AXSuper Retail Group Limited11.78%$1.8791.92%
2877.HKChina Shineway Pharmaceutical Group Limited11.77%$1.0139.47%
DSWLDeswell Industries, Inc.11.77%$0.4027.95%
0855.HKChina Water Affairs Group Limited11.75%$0.6256.78%
0659.HKCTF Services Limited11.70%$0.8876.18%
DRA.AXDRA Global Limited11.69%$0.2158.65%
GWA.AXGWA Group Limited11.68%$0.2995.40%
0968.HKXinyi Solar Holdings Limited11.67%$0.3670.18%
ENI-UN.TOEnergy Income Fund11.66%$0.2356.38%
TCF.AX360 Capital Mortgage REIT11.66%$0.6776.18%
3316.HKBinjiang Service Group Co. Ltd.11.65%$2.7669.09%
CC3.SIStarHub Ltd11.65%$0.1381.69%
TFG-R.BKThaifoods Group Public Company Limited11.65%$0.5242.58%