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$2,356.05 - $12,726.91$4,614.09
Multi-Stage$1,338.60 - $1,463.80$1,400.06
Blended Fair Value$3,007.08
Current Price$1,878.40
Upside60.09%
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 Rate7.79%7.79%7.79%
Growth Rate5.50%6.50%7.50%
Fair Value$2,356.05$4,614.09$12,726.91
Upside / Downside25.43%145.64%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 Rate7.79%7.79%7.79%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)157,189.06158,679.00160,168.94
Year 2 PV (M)198,456.00202,236.03206,051.72
Year 3 PV (M)237,896.57244,725.73251,684.34
Year 4 PV (M)275,569.80286,167.44297,067.84
Year 5 PV (M)311,533.02326,580.18342,203.23
PV of Terminal Value (M)6,881,495.697,213,874.517,558,974.24
Equity Value (M)8,062,140.148,432,262.888,816,150.32
Shares Outstanding (M)6,022.806,022.806,022.80
Fair Value$1,338.60$1,400.06$1,463.80
Upside / Downside-28.74%-25.47%-22.07%

High-Yield Dividend Screener

« Prev Page 25 of 30 Next »
Ticker ⇵ Company ⇵ Dividend Yield % ▼ Dividend Per Share ⇵ Payout Ratio % ⇵
MDCM.D.C. Holdings, Inc.0.86%$0.5455.94%
AXPAmerican Express Company0.85%$3.1720.85%
FOXAFox Corporation0.85%$0.6213.96%
LMSTLimestone Bancorp, Inc.0.85%$0.208.06%
RCLRoyal Caribbean Cruises Ltd.0.85%$2.4116.19%
AZZAZZ Inc.0.84%$0.928.89%
HIBBHibbett, Inc.0.84%$0.749.00%
MARMarriott International, Inc.0.84%$2.6227.38%
MORNMorningstar, Inc.0.84%$1.7720.03%
SGHSMART Global Holdings, Inc.0.84%$0.1430.96%
URIUnited Rentals, Inc.0.84%$7.1318.10%
0HYJ.LCintas Corporation0.83%$1.5434.15%
EFXEquifax Inc.0.83%$1.7833.46%
GMGeneral Motors Company0.82%$0.6621.22%
KVSAKhosla Ventures Acquisition Co.0.81%$0.099.61%
WMTWalmart Inc.0.81%$0.9131.92%
BMIBadger Meter, Inc.0.80%$1.4130.10%
FRDFriedman Industries, Incorporated0.80%$0.169.82%
ITTITT Inc.0.80%$1.4022.66%
MLIMueller Industries, Inc.0.80%$0.9413.89%
SSSSLSuRo Capital Corp. 6.00% Notes due 20260.80%$0.208.46%
RGLDRoyal Gold, Inc.0.79%$1.7524.00%
VRSKVerisk Analytics, Inc.0.79%$1.7426.41%
COFCapital One Financial Corporation0.78%$1.9487.57%
EEExcelerate Energy, Inc.0.78%$0.229.21%
0K36.LMoody's Corporation0.77%$3.8230.70%
HCIHCI Group, Inc.0.77%$1.429.00%
PHParker-Hannifin Corporation0.77%$6.8524.15%
SEISolaris Energy Infrastructure, Inc.0.77%$0.3944.96%
0HQN.LCboe Global Markets, Inc.0.76%$1.9020.31%
ASICAtegrity Specialty Holdings LLC0.76%$0.1512.77%
GLGlobe Life Inc.0.75%$1.037.35%
0KYY.LS&P Global Inc.0.74%$3.8128.09%
PHMPulteGroup, Inc.0.74%$0.896.67%
ROPRoper Technologies, Inc.0.74%$3.2022.09%
ZWSZurn Elkay Water Solutions Corporation0.74%$0.3530.63%
JOEThe St. Joe Company0.73%$0.4324.05%
TOLToll Brothers, Inc.0.73%$0.997.16%
TTEKTetra Tech, Inc.0.73%$0.2526.25%
0HCB.LAlcoa Corporation0.72%$0.409.08%
AAgilent Technologies, Inc.0.72%$0.9921.64%
FCFSFirstCash Holdings, Inc0.72%$1.1316.40%
TRAKReposiTrak, Inc.0.72%$0.0922.94%
BKNGBooking Holdings Inc.0.71%$37.7824.39%
PGCPeapack-Gladstone Financial Corporation0.71%$0.2010.22%
ASOAcademy Sports and Outdoors, Inc.0.70%$0.376.63%
BROBrown & Brown, Inc.0.70%$0.5418.02%
INTUIntuit Inc.0.70%$4.3929.97%
MSFTMicrosoft Corporation0.70%$3.3123.52%
NCRNCR Corporation0.70%$0.111.70%