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 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
GHYPGIM Global High Yield Fund, Inc15.29%$1.8962.38%
BGRBlackRock Energy and Resources Trust15.26%$2.1298.26%
BOEBlackRock Enhanced Global Dividend Trust15.09%$1.7867.28%
FENFirst Trust Energy Income and Growth Fund15.00%$2.4049.79%
SOJESouthern Company (The) Series 214.95%$2.6967.01%
PSFCohen & Steers Select Preferred and Income Fund, Inc.14.84%$3.0256.28%
EVGEaton Vance Short Duration Diversified Income Fund14.82%$1.6271.62%
LDPCohen & Steers Limited Duration Preferred and Income Fund, Inc.14.73%$3.1554.69%
DNPDNP Select Income Fund Inc.14.64%$1.4553.01%
JRSNuveen Real Estate Income Fund14.56%$1.1189.79%
DPGDuff & Phelps Utility and Infrastructure Fund Inc.14.47%$1.8654.60%
BSTBlackRock Science and Technology Trust14.42%$5.8646.91%
MPAIXMorgan Stanley Insti Fd Advantage Portfolio Cl I14.33%$4.0043.20%
JCAPJefferson Capital, Inc. Common Stock14.11%$3.1245.65%
PHTPioneer High Income Fund, Inc.13.99%$1.1961.96%
RZC7.125% Fixed-Rate Reset Subordinated Debentures due 205213.93%$3.5527.34%
RNPCohen & Steers REIT and Preferred Income Fund, Inc.13.88%$2.7761.92%
DOMHDominari Holdings Inc.13.87%$0.7010.86%
STT-PDState Street Corporation13.86%$3.4633.48%
FCTFirst Trust Senior Floating Rate Income Fund II13.80%$1.3867.42%
VIRTVirtu Financial, Inc.13.57%$4.4389.50%
DHFBNY Mellon High Yield Strategies Fund13.55%$0.3461.16%
JHIJohn Hancock Investors Trust13.15%$1.7974.97%
AIOVirtus Artificial Intelligence & Technology Opportunities Fund12.91%$2.8238.01%
UTFCohen & Steers Infrastructure Fund, Inc12.84%$3.1453.56%
DFPFlaherty & Crumrine Dynamic Preferred and Income Fund Inc.12.81%$2.6848.05%
WEAWestern Asset Premier Bond Fund12.81%$1.4380.16%
TPZTortoise Essential Energy Fund12.76%$2.6467.76%
FTFranklin Universal Trust12.72%$1.0256.42%
CSQCalamos Strategic Total Return Fund12.70%$2.4351.10%
HYBThe New America High Income Fund Inc.12.68%$1.0463.42%
NBBNuveen Taxable Municipal Income Fund12.66%$2.0085.04%
RWAYRunway Growth Finance Corp.12.66%$1.1475.51%
ELVTElevate Credit, Inc.12.61%$0.2475.91%
NDPTortoise Energy Independence Fund, Inc.12.60%$5.0986.32%
BCEICivitas Resources, Inc.12.58%$7.0698.41%
GENVRGen Digital Inc. Contingent Value Rights12.54%$0.5054.91%
SOJCThe Southern Company JR 2017B NT 7712.31%$2.6967.01%
BTOJohn Hancock Financial Opportunities Fund12.25%$4.3229.72%
FEIFirst Trust MLP and Energy Income Fund12.21%$1.2058.56%
PCNPIMCO Corporate & Income Strategy Fund12.19%$1.5568.95%
HTDJohn Hancock Tax-Advantaged Dividend Income Fund12.17%$2.9051.08%
NIEVirtus Equity & Convertible Income Fund12.17%$3.0445.26%
PFDFlaherty & Crumrine Preferred Income Fund Inc.11.99%$1.4348.51%
TYGTortoise Energy Infrastructure Corporation11.98%$4.9643.95%
FPLFirst Trust New Opportunities MLP & Energy Fund11.82%$0.9254.20%
BTZBlackRock Credit Allocation Income Trust11.69%$1.2692.75%
BHBFXMadison Dividend Income Fd Cl Y11.61%$2.8540.22%
CGABLThe Carlyle Group Inc. 4.625% Subordinated Notes due 206111.57%$2.0197.92%
DBLDoubleLine Opportunistic Credit Fund11.57%$1.7652.03%