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$60.73 - $208.33$195.23
Multi-Stage$31.55 - $34.56$33.02
Blended Fair Value$114.13
Current Price$30.02
Upside280.17%
DecisionBuy

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 Rate6.32%6.32%6.32%
Growth Rate4.87%5.87%6.87%
Fair Value$60.73$195.23$208.33
Upside / Downside102.30%550.33%593.98%

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 Rate6.32%6.32%6.32%
Growth Rate4.87%5.87%6.87%
Year 1 PV (M)7.157.227.28
Year 2 PV (M)8.989.159.33
Year 3 PV (M)10.7611.0711.39
Year 4 PV (M)12.5012.9813.48
Year 5 PV (M)14.1814.8715.58
PV of Terminal Value (M)451.71473.66496.46
Equity Value (M)505.28528.95553.52
Shares Outstanding (M)16.0216.0216.02
Fair Value$31.55$33.02$34.56
Upside / Downside5.08%10.01%15.12%

High-Yield Dividend Screener

« Prev Page 3 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
1272.HKDatang Environment Industry Group Co., Ltd.13.53%$0.1542.28%
MID-UN.TOMINT Income Fund13.47%$1.0661.55%
1126.HKDream International Limited13.45%$1.1550.50%
HCO.PAHigh Co. S.A.13.45%$0.5362.33%
2348.HKDawnrays Pharmaceutical (Holdings) Limited13.44%$0.1633.06%
0384.HKChina Gas Holdings Limited13.43%$1.0494.76%
AEFAbrdn Emerging Markets Equity Income Fund Inc13.42%$0.9661.57%
9616.HKNeutech Group Limited13.40%$0.3455.10%
WN-PA.TOGeorge Weston Limited13.36%$3.4127.39%
CY4.FKelsian Group Limited13.31%$0.3278.26%
1100.HKMainland Headwear Holdings Limited13.28%$0.1742.95%
1755.HKS-Enjoy Service Group Co., Limited13.28%$0.3733.22%
DRR.AXDeterra Royalties Limited13.28%$0.5593.57%
2942.TWOJing-Jan Retail Business Co., Ltd.13.27%$4.1962.94%
1985.HKMicroware Group Limited13.26%$0.1768.95%
SSG.AXShaver Shop Group Limited13.25%$0.2086.08%
1553.HKMaike Tube Industry Holdings Limited13.22%$0.2027.92%
3306.HKJNBY Design Limited13.22%$2.5577.85%
0363.HKShanghai Industrial Holdings Limited13.17%$1.9035.00%
0579.HKBeijing Jingneng Clean Energy Co., Limited13.09%$0.3042.68%
RI.PAPernod Ricard S.A.13.06%$9.5377.43%
VULC3.SAVulcabras S.A.13.05%$2.6060.16%
600919.SSBank of Jiangsu Co., Ltd.13.01%$1.3572.63%
1551.HKGuangzhou Rural Commercial Bank Co., Ltd.13.00%$0.2058.85%
EIT-UN.TOCanoe EIT Income Fund13.00%$2.0542.34%
4334.SRAl Maather Reit Fund12.98%$1.1689.22%
BCE-PA.TOBCE Inc.12.97%$2.7139.91%
HLO.AXHelloworld Travel Limited12.97%$0.2567.50%
4347.SRBonyan REIT Fund12.96%$1.2193.24%
1526.HKRici Healthcare Holdings Limited12.94%$0.1438.91%
3709.HKEEKA Fashion Holdings Limited12.93%$0.9958.41%
ELSA.JKPT Elnusa Tbk12.90%$65.7979.08%
3348.HKChina PengFei Group Limited12.88%$0.1642.43%
BAYU.JKPT Bayu Buana Tbk12.87%$175.0059.18%
MJLF.BKMajor Cineplex Lifestyle Leasehold Property Fund.12.81%$0.6246.37%
037460.KQSamji Electronics Co., Ltd.12.80%$1,880.7647.73%
1785.HKChengdu Expressway Co., Ltd.12.79%$0.2688.07%
GWO-PN.TOGreat-West Lifeco Inc.12.76%$2.3953.09%
UNC.TOUnited Corporations Limited12.75%$1.8760.14%
FDJ.PAFDJ United12.74%$3.8390.91%
IRAO.MEPJSC Inter RAO UES12.74%$0.3919.11%
0OGG.LS.A. Catana Group12.72%$0.3722.37%
TAPG.JKPT Triputra Agro Persada Tbk12.65%$191.0090.66%
2407.HKGaush Meditech Ltd12.64%$1.0277.13%
MPCK.DEMPC Münchmeyer Petersen Capital AG12.63%$0.6260.64%
EDL.DEEdel SE & Co. KGaA12.60%$0.5754.20%
0086.HKSun Hung Kai & Co. Limited12.59%$0.5294.25%
4340.SRAl Rajhi REIT Fund12.56%$1.0083.50%
TRMDTORM plc12.54%$2.4890.35%
0819.HKTianneng Power International Limited12.50%$0.8935.06%