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,051.15 - $12,726.91$11,926.98
Multi-Stage$1,695.74 - $1,855.96$1,774.38
Blended Fair Value$6,850.68
Current Price$1,878.40
Upside264.71%
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.83%6.83%6.83%
Growth Rate5.50%6.50%7.50%
Fair Value$4,051.15$11,926.98$12,726.91
Upside / Downside115.67%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.83%6.83%6.83%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)158,600.40160,103.72161,607.04
Year 2 PV (M)202,035.72205,883.93209,768.44
Year 3 PV (M)244,362.22251,376.98258,524.72
Year 4 PV (M)285,600.83296,584.23307,881.42
Year 5 PV (M)325,772.09341,507.01357,844.13
PV of Terminal Value (M)8,996,729.039,431,274.419,882,450.86
Equity Value (M)10,213,100.2910,686,730.2711,178,076.62
Shares Outstanding (M)6,022.806,022.806,022.80
Fair Value$1,695.74$1,774.38$1,855.96
Upside / Downside-9.72%-5.54%-1.19%

High-Yield Dividend Screener

« Prev Page 7 of 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
PLYMPlymouth Industrial REIT, Inc.4.80%$1.0549.94%
SAFTSafety Insurance Group, Inc.4.80%$3.6361.47%
CETCentral Securities Corp.4.79%$2.4313.87%
GBLIGlobal Indemnity Group, LLC4.79%$1.3870.11%
JANIXJanus Henderson Triton Fund Class D4.79%$1.2767.95%
MITNAG Mortgage Investment Trust, Inc. 9.500% Senior Notes due 20294.77%$1.2175.90%
PRUPrudential Financial, Inc.4.77%$5.4373.37%
IFAFXThe Income Fund of America, Class F-1 Shares4.76%$1.2433.91%
AMECXAmerican Funds The Income Fund of America Class A4.74%$1.2433.91%
UMPQUmpqua Holdings Corporation4.74%$0.8454.13%
NFBKNorthfield Bancorp, Inc.4.73%$0.5454.01%
SBSISouthside Bancshares, Inc.4.72%$1.4462.24%
TNLTravel + Leisure Co.4.72%$3.4054.99%
AIRCApartment Income REIT Corp.4.68%$1.8341.27%
SONSonoco Products Company4.68%$2.0832.95%
OFLXOmega Flex, Inc.4.67%$1.3685.30%
FTAIOFTAI Aviation Ltd.4.65%$1.1825.22%
WDWalker & Dunlop, Inc.4.65%$2.7379.29%
0J2Z.LHA Sustainable Infrastructure Capital, Inc.4.63%$1.4766.70%
FLMNFalcon Minerals Corporation4.63%$0.3681.83%
GSRMGSR II Meteora Acquisition Corp.4.62%$0.1532.94%
FBFWXAmerican Funds Retirement Income Portfolio - Moderate Class F-14.61%$0.6379.77%
GPSThe Gap, Inc.4.61%$0.9341.48%
QUADQuad/Graphics, Inc.4.61%$0.2764.56%
BMYBristol-Myers Squibb Company4.59%$2.4582.81%
WTBAWest Bancorporation, Inc.4.56%$0.9952.39%
SCPLSciPlay Corporation4.55%$1.0417.40%
OLPOne Liberty Properties, Inc.4.53%$0.9257.61%
RWAYLRunway Growth Finance Corp. - 74.53%$1.1475.51%
INSWInternational Seaways, Inc.4.52%$2.1248.43%
RWAYZRunway Growth Finance Corp. 8.00% Notes due 20274.52%$1.1475.51%
DDominion Energy, Inc.4.48%$2.6597.13%
TGTTarget Corporation4.48%$4.5054.48%
COLBColumbia Banking System, Inc.4.47%$1.2662.95%
DFPAXBNY Mellon Diversified International Fund Class A4.46%$0.4556.12%
KEYKeyCorp4.46%$0.9495.81%
RPTIXT. Rowe Price Mid-Cap Growth Fund4.46%$4.3859.54%
CGBDCarlyle Secured Lending, Inc.4.45%$0.5655.08%
NEWTPNewtekOne, Inc. Depositary Shares, Non-Cumulative Perpetual Preferred Stock, Series B4.44%$1.0244.14%
PFCPremier Financial Corp.4.43%$1.2468.07%
BFCBank First Corporation4.40%$5.3073.82%
DUKDuke Energy Corporation4.40%$5.1780.55%
0L77.LSkyworks Solutions, Inc.4.37%$2.7990.67%
ESCAEscalade, Incorporated4.35%$0.6065.28%
DINOHF Sinclair Corporation4.34%$2.0396.43%
LBAILakeland Bancorp, Inc.4.34%$0.5844.96%
CVXChevron Corporation4.32%$6.7495.36%
CVBFCVB Financial Corp.4.31%$0.8154.32%
HTBKHeritage Commerce Corp4.30%$0.5273.66%
EQREquity Residential4.28%$2.6689.76%