Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Ticker

Industry

Sector

Consolidated Water Co. Ltd. (CWCO)

Company Dividend Discount ModelIndustry: Regulated WaterSector: Utilities

Valuation Snapshot

Stable Growth$17.35 - $33.64$23.83
Multi-Stage$14.37 - $15.68$15.01
Blended Fair Value$19.42
Current Price$30.02
Upside-35.31%
DecisionDon't Buy

Dividend History & Growth Metrics (10Y)

Metric5Y CAGR10Y CAGR2024202320222021202020192018201720162015
DPS4.28%3.61%0.390.340.320.320.320.320.320.280.280.28
YoY Growth--14.83%6.36%-0.12%0.35%0.71%0.09%14.07%0.70%0.36%0.23%
Dividend Yield--1.60%1.28%1.96%2.91%2.38%1.94%2.46%1.92%2.38%2.27%

Stable Growth Model (Adjusted)

(USD in Millions except Per Share Data)
Net Income To Common (M)16.88
(-) Cash Dividends Paid (M)5.26
(=) Cash Retained (M)11.62
MetricLOWBASEHIGH
Required Retention Ratio20.0%12.5%7.5%
(=) Cash Required (M)3.382.111.27
Cash Retained (M)11.6211.6211.62
(-) Cash Required (M)-3.38-2.11-1.27
(=) Excess Retained (M)8.249.5110.35
(/) Shares Outstanding (M)16.0216.0216.02
(=) Excess Retained per Share0.510.590.65
LTM Dividend per Share0.330.330.33
(+) Excess Retained per Share0.510.590.65
(=) Adjusted Dividend0.840.920.97
WACC / Discount Rate9.96%9.96%9.96%
Growth Rate4.87%5.87%6.87%
Fair Value$17.35$23.83$33.64
Upside / Downside-42.22%-20.62%12.06%

Multi-Stage Model: Projections

(USD in Millions)
MetricTTMDec-27Dec-28Dec-29Dec-30Dec-31Terminal
Net Income (M)16.8817.8718.9220.0321.2022.4523.12
Payout Ratio31.17%42.93%54.70%66.47%78.23%90.00%92.50%
Projected Dividends (M)5.267.6710.3513.3116.5920.2021.38

Multi-Stage Valuation

MetricLOWBASEHIGH
WACC / Discount Rate9.96%9.96%9.96%
Growth Rate4.87%5.87%6.87%
Year 1 PV (M)6.916.987.04
Year 2 PV (M)8.408.568.72
Year 3 PV (M)9.7310.0110.30
Year 4 PV (M)10.9211.3411.78
Year 5 PV (M)11.9812.5613.17
PV of Terminal Value (M)182.15191.00200.19
Equity Value (M)230.09240.45251.20
Shares Outstanding (M)16.0216.0216.02
Fair Value$14.37$15.01$15.68
Upside / Downside-52.15%-49.99%-47.76%

High-Yield Dividend Screener

« Prev Page 34 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
BILI-A.STBilia AB (publ)4.58%$6.0877.85%
SHA.AXSHAPE Australia Corporation Limited4.58%$0.2863.86%
SUTHA.BKGolden Lime Public Company Limited4.58%$0.1279.88%
YUASA.BKYuasa Battery (Thailand) Public Company Limited4.58%$0.6126.69%
001323.SZDe Rucci Healthy Sleep Co., Ltd.4.57%$1.1972.11%
FNAC.PAFnac Darty S.A.4.57%$1.3429.18%
CRSU.PACaisse Régionale de Crédit Agricole Mutuel Sud Rhône Alpes4.56%$8.7019.97%
ELIN.ATElinoil Hellenic Petroleum Company S.A.4.56%$0.1127.16%
000596.SZAnhui Gujing Distillery Co., Ltd.4.55%$6.0467.48%
002483.SZJiangsu Rainbow Heavy Industries Co., Ltd.4.55%$0.3263.40%
002746.SZShandong Xiantan Co., Ltd.4.55%$0.2882.68%
NSL-R.BKNSL Foods Public Company Limited4.55%$1.0551.73%
600350.SSShandong Hi-speed Company Limited4.54%$0.4464.80%
7463.TAdvan Group Co., Ltd.4.54%$41.5719.08%
SEGMN.ISSegmen Kardesler Gid Urt Ve Amblj Sny AS4.54%$0.8469.37%
005180.KSBinggrae Co., Ltd.4.53%$3,299.7936.30%
6873.TWHD Renewable Energy Co., Ltd.4.53%$4.5378.62%
300193.SZShenzhen Jasic Technology Co.,Ltd.4.52%$0.4081.71%
5904.TWOPOYA International Co., Ltd.4.52%$20.1875.14%
600282.SSNanjing Iron & Steel Co., Ltd.4.52%$0.2454.66%
603689.SSAnhui Province Natural Gas DevelopmentCo.,Ltd.4.52%$0.3769.94%
688036.SSShenzhen Transsion Holdings Co., Ltd.4.52%$2.9990.95%
ALCLA.PAClasquin S.A.4.52%$6.4148.30%
023000.KSSAMWONSTEEL Co.,Ltd.4.51%$108.3244.46%
0QNM.LAdecco Group AG4.51%$1.0462.86%
9539.SRAqaseem Factory for Chemicals and Plastics Co.4.51%$0.2165.70%
DUI.AXDiversified United Investment Limited4.51%$0.2470.80%
SLIGR.ASSligro Food Group N.V.4.51%$0.47100.00%
032640.KSLG Uplus Corp.4.50%$650.0160.09%
4165.SRAl Majed Oud Co.4.50%$6.0082.11%
000411.SZZhejiang Int'l Group Co.,Ltd.4.49%$0.5761.70%
002543.SZGuangdong Vanward New Electric Co., Ltd.4.49%$0.4649.41%
003070.KSKolon Global Corporation4.49%$401.8773.73%
601665.SSQilu Bank Co., Ltd.4.49%$0.2628.78%
BSANTANDER.SNBanco Santander-Chile4.49%$3.1956.12%
GPW.WAGielda Papierów Wartosciowych w Warszawie S.A.4.49%$2.9966.28%
SHUR.BRShurgard Self Storage S.A.4.49%$1.3113.81%
044450.KSKSS Line Ltd.4.48%$397.8627.45%
0OR2.LLNA Santé S.A.4.48%$1.1025.22%
2731.TWLion Travel Service Co., Ltd.4.48%$7.4848.12%
4104.TWExcelsior Medical Co., Ltd.4.48%$3.6277.21%
7167.KLAble Global Berhad4.48%$0.0731.97%
7593.TVt Holdings Co.,Ltd.4.48%$24.0056.43%
0IPY.LAubay S.A.4.47%$2.5247.60%
3020.SRYamama Saudi Cement Company4.47%$1.0650.72%
3114.TWOHowteh Technology Co., Ltd.4.47%$1.1951.28%
CCEPCoca-Cola Europacific Partners PLC4.47%$3.9457.53%
CMCanadian Imperial Bank of Commerce4.47%$4.1147.39%
QIIK.QAQatar International Islamic Bank (Q.P.S.C)4.47%$0.5158.75%
1515.HKChina Resources Medical Holdings Company Limited4.46%$0.1423.71%