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$10,802.27 - $12,726.91$11,926.98
Multi-Stage$3,231.74 - $3,542.92$3,384.44
Blended Fair Value$7,655.71
Current Price$1,878.40
Upside307.57%
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 Rate5.06%5.06%5.06%
Growth Rate5.50%6.50%7.50%
Fair Value$10,802.27$11,926.98$12,726.91
Upside / Downside475.08%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 Rate5.06%5.06%5.06%
Growth Rate5.50%6.50%7.50%
Year 1 PV (M)161,273.36162,802.02164,330.68
Year 2 PV (M)208,903.11212,882.13216,898.68
Year 3 PV (M)256,926.68264,302.12271,817.37
Year 4 PV (M)305,346.52317,089.28329,167.53
Year 5 PV (M)354,165.10371,271.41389,032.41
PV of Terminal Value (M)18,177,495.0119,055,474.8119,967,056.97
Equity Value (M)19,464,109.7820,383,821.7721,338,303.65
Shares Outstanding (M)6,022.806,022.806,022.80
Fair Value$3,231.74$3,384.44$3,542.92
Upside / Downside72.05%80.18%88.61%

High-Yield Dividend Screener

« Prev Page 13 of 30 Next »
Ticker ⇵ Company ⇵ Dividend Yield % ▼ Dividend Per Share ⇵ Payout Ratio % ⇵
CLColgate-Palmolive Company2.88%$2.2462.40%
TCBKTriCo Bancshares2.87%$1.3537.83%
0U6R.LBunge Limited2.86%$3.0531.37%
FBMSThe First Bancshares, Inc.2.86%$0.9739.72%
RILYGB. Riley Financial, Inc. 5.00% Senior Notes due 20262.86%$0.5856.91%
CNSCohen & Steers, Inc.2.85%$1.8156.91%
MRBKMeridian Corporation2.85%$0.4927.85%
AMGNAmgen Inc.2.84%$9.3172.03%
BKHBlack Hills Corporation2.84%$1.9850.60%
GABCGerman American Bancorp, Inc.2.84%$1.1140.35%
HOMBHome Bancshares, Inc.2.84%$0.7934.17%
KOThe Coca-Cola Company2.84%$1.9665.04%
SBFGSB Financial Group, Inc.2.84%$0.6128.02%
TSBKTimberland Bancorp, Inc.2.84%$1.0027.24%
CATYCathay General Bancorp2.83%$1.3831.20%
CWTCalifornia Water Service Group2.83%$1.2253.25%
EBIXEbix, Inc.2.83%$0.0846.85%
CMS-PBConsumers Energy Company2.82%$2.1762.27%
EPRTEssential Properties Realty Trust, Inc.2.82%$0.8570.58%
GPKGraphic Packaging Holding Company2.82%$0.4324.85%
VALSXValue Line Select Growth Fund2.82%$0.8756.29%
CCNECNB Financial Corporation2.81%$0.7235.05%
ORRFOrrstown Financial Services, Inc.2.81%$0.9826.05%
TXNMTXNM Energy, Inc.2.80%$1.6586.75%
STCStewart Information Services Corporation2.79%$1.9554.56%
CVLYCodorus Valley Bancorp, Inc.2.77%$0.6728.98%
KKRSKKR Group Finance Co. IX LLC 4.2.77%$0.497.61%
SHBIShore Bancshares, Inc.2.77%$0.4828.28%
HNNAHennessy Advisors, Inc.2.76%$0.2721.11%
HONEHarborOne Bancorp, Inc.2.76%$0.3351.05%
KMTKennametal Inc.2.76%$0.8065.12%
PNMPNM Resources, Inc.2.76%$1.1257.65%
HWCHancock Whitney Corporation2.75%$1.7731.35%
YOUClear Secure, Inc.2.75%$0.9550.89%
0HE2.LAmeren Corporation2.74%$2.7853.51%
MTDRMatador Resources Company2.74%$1.1918.96%
OFGOFG Bancorp2.74%$1.1225.13%
VLOValero Energy Corporation2.74%$4.5393.65%
YORWThe York Water Company2.73%$0.8762.37%
CCZComcast Holdings Corp.2.72%$1.6326.92%
KKellanova2.72%$2.2762.18%
ADTADT Inc.2.71%$0.2229.95%
AVTAvnet, Inc.2.71%$1.3448.46%
BKUBankUnited, Inc.2.71%$1.2134.19%
CNOBConnectOne Bancorp, Inc.2.71%$0.7148.64%
GBXThe Greenbrier Companies, Inc.2.71%$1.2819.40%
PBHCPathfinder Bancorp, Inc.2.71%$0.3826.39%
TRINTrinity Capital Inc.2.71%$0.4120.50%
RILYNB. Riley Financial, Inc. - 6.502.70%$0.5856.91%
0L5A.LSempra2.69%$2.4172.79%