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 6 of 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
FFord Motor Company5.53%$0.7463.45%
LCNBLCNB Corp.5.48%$0.8953.03%
PPBIPacific Premier Bancorp, Inc.5.48%$1.3492.42%
VGRVector Group Ltd.5.48%$0.8263.35%
DLXDeluxe Corporation5.43%$1.2166.43%
BAFNBayFirst Financial Corp.5.41%$0.4321.50%
IPGThe Interpublic Group of Companies, Inc.5.41%$1.3388.72%
PEBOPeoples Bancorp Inc.5.39%$1.6256.40%
OKEONEOK, Inc.5.38%$4.0075.29%
BUSEFirst Busey Corporation5.37%$1.2875.92%
OASOasis Petroleum Inc.5.37%$5.8765.40%
EIXEdison International5.36%$3.2639.45%
0R1X.LGeneral Mills, Inc.5.35%$2.4545.62%
FIBKFirst Interstate BancSystem, Inc.5.35%$1.8979.54%
FNCBFNCB Bancorp, Inc.5.33%$0.3651.41%
DHILDiamond Hill Investment Group, Inc.5.31%$9.0552.46%
SLRCSLR Investment Corp.5.31%$0.8249.67%
EPSNEpsilon Energy Ltd.5.30%$0.2491.92%
UVVUniversal Corporation5.28%$2.7862.64%
FLICThe First of Long Island Corporation5.27%$0.6386.64%
AUBAtlantic Union Bankshares Corporation5.22%$1.8576.04%
SAFESafehold Inc.5.20%$0.7145.17%
GAB-PGThe Gabelli Equity Trust Inc. PFD-G5.19%$1.0881.70%
HPQHP Inc.5.19%$1.1543.02%
SOISolaris Oilfield Infrastructure, Inc.5.18%$0.7025.64%
MBINOMerchants Bancorp5.17%$1.2924.09%
0JXQ.LMain Street Capital Corporation5.13%$3.1752.63%
EMNEastman Chemical Company5.12%$3.2954.36%
EMBCEmbecta Corp.5.10%$0.5936.96%
AMAntero Midstream Corporation5.09%$0.9193.18%
CZNCCitizens & Northern Corporation5.09%$1.0257.64%
FMNBFarmers National Banc Corp.5.09%$0.6846.83%
0J66.LHost Hotels & Resorts, Inc.5.08%$0.9084.69%
GLPIGaming and Leisure Properties, Inc.5.07%$2.2582.42%
PFISPeoples Financial Services Corp.5.07%$2.4446.22%
TBBAT&T Inc. 5.35% GLB NTS 665.07%$1.1436.88%
KFRCKforce Inc.5.02%$1.5768.10%
TTPTortoise Pipeline & Energy Fund, Inc.5.02%$2.3920.11%
STAR-PGiStar Inc.4.94%$1.2434.23%
PFSProvident Financial Services, Inc.4.93%$0.9761.13%
UBFOUnited Security Bancshares4.92%$0.4873.45%
DDTDillards Capital Trust I CAP SECS 7.5%4.90%$1.293.46%
SGUStar Group, L.P.4.89%$0.5836.90%
AGRAvangrid, Inc.4.88%$1.7660.70%
KMBKimberly-Clark Corporation4.88%$4.9583.80%
OCFCOceanFirst Financial Corp.4.86%$0.8761.98%
0I0J.LThe Clorox Company4.85%$4.8976.11%
FNLCThe First Bancorp, Inc.4.83%$1.2845.40%
RILYZB. Riley Financial, Inc. 5.25% Senior Notes due 20284.83%$0.5856.91%
BSETBassett Furniture Industries, Incorporated4.82%$0.8089.43%