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 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
VKQInvesco Municipal Trust8.62%$0.8469.07%
ARCCAres Capital Corporation8.61%$1.7691.56%
TPVGTriplePoint Venture Growth BDC Corp.8.52%$0.5767.26%
C-PJCitigroup Inc.8.49%$2.1326.99%
RVTRoyce Value Trust Inc.8.42%$1.3639.40%
OGNOrganon & Co.8.37%$0.6131.54%
MITTAG Mortgage Investment Trust, Inc.8.12%$0.7043.47%
CAGConagra Brands, Inc.8.06%$1.3978.70%
NOGNorthern Oil and Gas, Inc.8.02%$1.7794.64%
PAAPlains All American Pipeline, L.P.8.00%$1.4690.71%
TSLXSixth Street Specialty Lending, Inc.8.00%$1.7385.26%
ACCOACCO Brands Corporation7.90%$0.2967.00%
ETDEthan Allen Interiors Inc.7.90%$1.8197.75%
CQPCheniere Energy Partners, L.P.7.82%$4.2388.03%
UNMAUnum Group 6.250% JR NT587.69%$1.7933.52%
WRB-PHW.R. Berkley Corporation 4.125%7.68%$1.2726.69%
JHSJohn Hancock Income Securities Trust7.65%$0.8994.90%
NIDNuveen Intermediate Duration Municipal Term Fund7.59%$1.0284.59%
HWCPZHancock Whitney Corporation - 67.58%$1.7731.35%
WRB-PGW.R. Berkley Corporation 4.25%7.54%$1.2726.69%
NMTNuveen Massachusetts Quality Municipal Income Fund7.48%$0.8580.62%
LOANManhattan Bridge Capital, Inc.7.45%$0.3574.53%
OPALOPAL Fuels Inc.7.43%$0.1846.94%
ZIONLZions Bancorporation N.A. - 6.97.42%$1.8632.04%
GMTAGATX Corporation SR NT 20667.41%$1.8621.29%
IIMInvesco Value Municipal Income Trust7.41%$0.9264.33%
JMMNuveen Multi-Market Income Fund7.28%$0.4461.06%
BKEThe Buckle, Inc.7.26%$3.9196.21%
MHIPioneer Municipal High Income Fund, Inc.7.19%$0.6413.70%
ORIOld Republic International Corporation7.19%$3.1193.13%
PMFPIMCO Municipal Income Fund7.07%$0.5992.59%
RYNRayonier Inc.7.04%$1.5230.67%
DRQDril-Quip, Inc.7.02%$1.0850.37%
TRINITrinity Capital Inc. 7.875% Notes Due 20297.02%$1.7883.48%
C-PNCitigroup Capital XIII TR PFD SECS7.01%$2.1326.99%
VPVInvesco Pennsylvania Value Municipal Income Trust6.98%$0.7360.22%
VCVInvesco California Value Municipal Income Trust6.97%$0.7860.58%
EOTEaton Vance National Municipal Opportunities Trust6.96%$1.1869.84%
FLATXFidelity Latin America Fund6.92%$1.1539.63%
EGYVAALCO Energy, Inc.6.91%$0.2592.67%
NOMNuveen Missouri Quality Municipal Income Fund6.91%$0.8278.81%
UBCPUnited Bancorp, Inc.6.90%$0.9996.30%
TBCAT&T Inc. 5.625% Global Notes d6.89%$1.7255.65%
GTNGray Media, Inc.6.87%$0.3334.04%
HEPHolly Energy Partners, L.P.6.86%$1.4074.08%
AFGAmerican Financial Group, Inc.6.85%$9.2396.49%
BANFPBFC Capital Trust II PFD TR 7.20%6.85%$1.8025.72%
CFG-PDCitizens Financial Group, Inc.6.83%$1.7143.60%
RCIIRent-A-Center, Inc.6.81%$1.8279.98%
SPHSuburban Propane Partners, L.P.6.81%$1.2778.56%