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 18 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
CU-X.TOCanadian Utilities Limited6.70%$2.3196.15%
NACNuveen California Quality Municipal Income Fund6.70%$0.7958.10%
SMIT.BKSahamit Machinery Public Company Limited6.70%$0.2480.77%
FNTN.DEfreenet AG6.69%$1.9986.99%
2319.HKChina Mengniu Dairy Company Limited6.68%$1.0099.41%
8963.TInvincible Investment Corporation6.68%$4,300.6161.53%
PLAKR.ATPlastika Kritis S.A.6.67%$0.9734.18%
000540.KSHeungkuk Fire&Marine Insurance Co., Ltd.6.66%$237.3827.99%
2314.HKLee & Man Paper Manufacturing Limited6.66%$0.1928.93%
298020.KSHyosung TNC Corporation6.66%$14,250.7888.73%
CPTGF.BKC.P. Tower Growth Leasehold Property Fund6.66%$0.3463.33%
0QQG.LRomande Energie Holding S.A.6.65%$2.8854.24%
9924.TWTaiwan Fu Hsing Industrial Co.,Ltd.6.65%$3.4897.31%
AYUD.BKAllianz Ayudhya Capital Public Company Limited6.65%$2.3438.16%
BEES3.SABanestes S.A. - Banco do Estado do Espírito Santo6.65%$0.5447.77%
DHTDHT Holdings, Inc.6.65%$0.7862.76%
DVLA.JKPT Darya-Varia Laboratoria Tbk6.65%$110.0071.18%
BTB-UN.TOBTB Real Estate Investment Trust6.64%$0.2763.41%
0297.HKSinofert Holdings Limited6.63%$0.1040.38%
0QQ0.LBKW AG6.63%$11.1661.27%
TTW-R.BKTTW Public Company Limited6.63%$0.6076.46%
000001.SZPing An Bank Co., Ltd.6.62%$0.7533.97%
5519.TWLongDa Construction & Development Corporation6.62%$2.1773.27%
AKHI.QAAl Khaleej Takaful Insurance Company Q.P.S.C.6.62%$0.1562.13%
DEXP3.SADexxos Participações S.A.6.61%$0.5235.77%
PLZ-UN.TOPlaza Retail REIT6.60%$0.2887.93%
0900.HKAEON Credit Service (Asia) Company Limited6.59%$0.4847.12%
4001.SRAbdullah Al-Othaim Markets Company6.59%$0.4169.57%
9942.TWNAK Sealing Technologies Corporation6.59%$6.9983.55%
QFLS.QAQatar Fuel Company Q.P.S.C.("WOQOD")6.59%$1.0096.27%
AD-UN.TOAlaris Equity Partners Income Trust6.58%$1.3646.26%
ARF.AXArena REIT6.58%$0.2367.19%
BVI.PABureau Veritas S.A.6.58%$1.7768.58%
9677.HKWeihai Bank Co., Ltd. Class H6.57%$0.1837.27%
LI.PAKlépierre6.57%$2.1940.55%
SIME.KLSime Darby Berhad6.57%$0.1445.15%
KER.PAKering S.A.6.56%$19.9987.42%
MING.OLSpareBank 1 SMN6.56%$13.2942.26%
024090.KSDCM Corp.6.55%$791.6575.82%
EMSN.SWEms-Chemie Holding AG6.55%$36.0191.24%
HVN.AXHarvey Norman Holdings Limited6.55%$0.4665.85%
LALIN.BKLalin Property Public Company Limited6.54%$0.3261.45%
0636.HKKLN Logistics Group Limited6.53%$0.4728.09%
0JSU.LSipef N.V.6.53%$5.3834.04%
0QF8.LAktia Pankki Oyj6.53%$0.8292.48%
INTRInter & Co, Inc.6.53%$0.5520.40%
0028.HKTian An China Investments Company Limited6.52%$0.3015.83%
4190.SRJarir Marketing Company6.52%$0.8499.34%
ONEE.BKThe ONE Enterprise Public Company Limited6.52%$0.1489.05%
0119.HKPoly Property Group Co., Limited6.51%$0.1338.03%