Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Mode

Ticker

Industry

Sector

Airtel Africa Plc (AAF.L)

Company Dividend Discount ModelIndustry: Telecommunications ServicesSector: Communication Services

Valuation Snapshot

Stable Growth$1.91 - $4.47$2.81
Multi-Stage$1.57 - $1.71$1.64
Blended Fair Value$2.22
Current Price$2.48
Upside-10.33%
DecisionDon't Buy

Dividend History & Growth Metrics (10Y)

Metric5Y CAGR10Y CAGR202520242023202220212020201920182017
DPS15.17%0.00%0.060.060.050.050.050.030.000.000.000.00
YoY Growth--8.02%8.72%15.38%0.00%49.56%0.00%0.00%0.00%0.00%0.00%
Dividend Yield--2.51%3.84%3.86%2.78%4.29%3.96%0.00%0.00%0.00%0.00%

Stable Growth Model (Adjusted)

(USD in Millions except Per Share Data)
Net Income To Common (M)339.00
(-) Cash Dividends Paid (M)229.00
(=) Cash Retained (M)110.00
MetricLOWBASEHIGH
Required Retention Ratio20.0%12.5%7.5%
(=) Cash Required (M)67.8042.3825.43
Cash Retained (M)110.00110.00110.00
(-) Cash Required (M)-67.80-42.38-25.43
(=) Excess Retained (M)42.2067.6384.58
(/) Shares Outstanding (M)3,684.283,684.283,684.28
(=) Excess Retained per Share0.010.020.02
LTM Dividend per Share0.060.060.06
(+) Excess Retained per Share0.010.020.02
(=) Adjusted Dividend0.070.080.09
WACC / Discount Rate8.86%8.86%8.86%
Growth Rate4.82%5.82%6.82%
Fair Value$1.91$2.81$4.47
Upside / Downside-22.89%13.19%80.15%

Multi-Stage Model: Projections

(USD in Millions)
MetricTTMDec-27Dec-28Dec-29Dec-30Dec-31Terminal
Net Income (M)339.00358.75379.64401.76425.16449.92463.42
Payout Ratio67.55%72.04%76.53%81.02%85.51%90.00%92.50%
Projected Dividends (M)229.00258.45290.54325.50363.55404.93428.66

Multi-Stage Valuation

MetricLOWBASEHIGH
WACC / Discount Rate8.86%8.86%8.86%
Growth Rate4.82%5.82%6.82%
Year 1 PV (M)235.17237.41239.65
Year 2 PV (M)240.56245.18249.83
Year 3 PV (M)245.24252.32259.54
Year 4 PV (M)249.23258.88268.80
Year 5 PV (M)252.59264.87277.63
PV of Terminal Value (M)4,563.264,785.125,015.52
Equity Value (M)5,786.066,043.786,310.98
Shares Outstanding (M)3,684.283,684.283,684.28
Fair Value$1.57$1.64$1.71
Upside / Downside-36.67%-33.85%-30.93%

High-Yield Dividend Screener

« Prev Page 24 of 30 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
EXPDExpeditors International of Washington, Inc.0.99%$1.5024.32%
LISOXLazard International Strategic Equity Ptf Open Shares0.99%$0.1336.87%
MXCMexco Energy Corporation0.99%$0.1012.25%
NICNicolet Bankshares, Inc.0.99%$1.1912.58%
PAYCPaycom Software, Inc.0.99%$1.5118.80%
RRCRange Resources Corporation0.99%$0.3514.60%
WLFCWillis Lease Finance Corporation0.99%$1.327.58%
WORWorthington Industries, Inc.0.99%$0.5223.95%
CNXNPC Connection, Inc.0.98%$0.5616.89%
CATCaterpillar Inc.0.97%$5.7829.40%
CNKCinemark Holdings, Inc.0.97%$0.2318.28%
ECLEcolab Inc.0.97%$2.5436.57%
EVREvercore Inc.0.97%$3.4127.02%
LSBKLake Shore Bancorp, Inc.0.96%$0.1424.34%
0ITL.LArthur J. Gallagher & Co.0.95%$2.4239.43%
0IZI.LW.W. Grainger, Inc.0.95%$9.5226.47%
0L5V.LThe Sherwin-Williams Company0.95%$3.1130.09%
0R2S.LStryker Corporation0.95%$3.2843.09%
RRXRegal Rexnord Corporation0.95%$1.3936.07%
WTWisdomTree, Inc.0.95%$0.1218.12%
JJacobs Solutions Inc.0.94%$1.2753.80%
ORCLOracle Corporation0.94%$1.8434.81%
TCBSTexas Community Bancshares, Inc.0.94%$0.1719.22%
IMKTAIngles Markets, Incorporated0.93%$0.6514.68%
ODCOil-Dri Corporation of America0.93%$0.4512.28%
PENGPenguin Solutions, Inc.0.93%$0.1940.17%
SSBKSouthern States Bancshares, Inc.0.93%$0.349.19%
DALDelta Air Lines, Inc.0.92%$0.638.94%
HIFSHingham Institution for Savings0.92%$2.4912.15%
RLRalph Lauren Corporation0.92%$3.3424.37%
OPYOppenheimer Holdings Inc.0.91%$0.668.90%
BGCBGC Group, Inc0.90%$0.0823.56%
CDRECadre Holdings, Inc.0.90%$0.3733.35%
MBNKPMedallion Bank0.90%$0.2312.50%
JBHTJ.B. Hunt Transport Services, Inc.0.89%$1.7530.14%
NYTThe New York Times Company0.89%$0.6230.32%
RMDResMed Inc.0.89%$2.1822.31%
VBFCVillage Bank and Trust Financial Corp.0.89%$0.7215.35%
0I14.LCognex Corporation0.88%$0.3249.16%
ARAntero Resources Corporation0.88%$0.3017.15%
LDOSLeidos Holdings, Inc.0.88%$1.6114.88%
LMATLeMaitre Vascular, Inc.0.88%$0.7032.20%
NNINelnet, Inc.0.88%$1.149.52%
PFSIPennyMac Financial Services, Inc.0.88%$1.1612.49%
SMBKSmartFinancial, Inc.0.88%$0.3211.76%
BYDBoyd Gaming Corporation0.87%$0.753.22%
ROSTRoss Stores, Inc.0.87%$1.5924.85%
BBSIBarrett Business Services, Inc.0.86%$0.3115.02%
BCOThe Brink's Company0.86%$1.0024.81%
HXLHexcel Corporation0.86%$0.6677.18%