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$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 16 of 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
HWBKHawthorn Bancshares, Inc.2.27%$0.7724.18%
UTMDUtah Medical Products, Inc.2.27%$1.2835.35%
DKSDICK'S Sporting Goods, Inc.2.26%$4.5238.61%
EMLThe Eastern Company2.26%$0.4437.05%
SBCFSeacoast Banking Corporation of Florida2.26%$0.7143.09%
WMKWeis Markets, Inc.2.26%$1.4535.88%
0JYA.LMarathon Petroleum Corporation2.25%$3.7274.60%
FSBCFive Star Bancorp2.25%$0.8029.79%
IBMInternational Business Machines Corporation2.25%$6.5678.75%
0KYZ.LSBA Communications Corporation2.24%$4.3254.40%
BPOPPopular, Inc.2.24%$2.8224.06%
MFINMedallion Financial Corp.2.24%$0.2312.50%
MSMorgan Stanley2.24%$4.0740.12%
FXNCFirst National Corporation2.23%$0.5586.28%
BACBank of America Corporation2.22%$1.2431.97%
SSBSouthState Corporation2.22%$2.0930.58%
VLGEAVillage Super Market, Inc.2.22%$0.7720.42%
WWWWolverine World Wide, Inc.2.22%$0.4137.79%
CCBGCapital City Bank Group, Inc.2.21%$0.9326.22%
CGThe Carlyle Group Inc.2.20%$1.3476.25%
NHINational Health Investors, Inc.2.20%$1.6954.58%
VNOVornado Realty Trust2.20%$0.7315.58%
BANCBanc of California, Inc.2.19%$0.4332.44%
EBTCEnterprise Bancorp, Inc.2.19%$0.8726.66%
RHPRyman Hospitality Properties, Inc.2.19%$2.0957.31%
CDPCOPT Defense Properties2.18%$0.6045.15%
FDSFactSet Research Systems Inc.2.18%$6.2039.64%
ISBAIsabella Bank Corporation2.18%$1.1044.52%
WHWyndham Hotels & Resorts, Inc.2.18%$1.6437.28%
EFSCEnterprise Financial Services Corp2.17%$1.1722.34%
ETHGrayscale Ethereum Mini Trust2.17%$0.6434.57%
SEMSelect Medical Holdings Corporation2.17%$0.3236.19%
BFSTBusiness First Bancshares, Inc.2.16%$0.5620.21%
CWBCCommunity West Bancshares2.16%$0.4826.89%
EHTHeHealth, Inc.2.16%$0.095.60%
TPLTexas Pacific Land Corporation2.16%$6.4231.02%
CBSHCommerce Bancshares, Inc.2.15%$1.1226.40%
COLMColumbia Sportswear Company2.15%$1.2035.55%
HTHHilltop Holdings Inc.2.15%$0.7328.46%
NATHNathan's Famous, Inc.2.15%$1.9835.76%
RCKYRocky Brands, Inc.2.15%$0.6222.50%
BDXBecton, Dickinson and Company2.14%$4.1771.28%
CICigna Corporation2.14%$5.9626.01%
FBIZFirst Business Financial Services, Inc.2.14%$1.1518.19%
JBSSJohn B. Sanfilippo & Son, Inc.2.14%$1.4926.50%
JNPRJuniper Networks, Inc.2.14%$0.8682.37%
POOLPool Corporation2.14%$4.9244.68%
CSCOCisco Systems, Inc.2.13%$1.6262.56%
CSTRCapStar Financial Holdings, Inc.2.13%$0.4330.48%
HTLFHeartland Financial USA, Inc.2.13%$1.3869.73%