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 41 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
5271.KLPecca Group Berhad3.89%$0.0781.04%
8183.TWOInfo-Tek Corporation3.89%$1.3053.03%
BDMS-R.BKBangkok Dusit Medical Services Public Company Limited3.89%$0.7572.62%
DANHOS13.MXFibra Danhos3.89%$1.0936.98%
FPE.DEFuchs Petrolub SE3.89%$1.1751.86%
S63.SISingapore Technologies Engineering Ltd3.89%$0.3372.94%
SONIC.BKSonic Interfreight Public Company Limited3.89%$0.0633.00%
0QMW.LKuehne + Nagel International AG3.88%$9.9598.58%
600861.SSFESCO Group Co., Ltd.3.88%$0.7134.85%
CIV.PACaisse régionale de Crédit Agricole Mutuel d'Ille-et-Vilaine Société coopérative3.88%$4.0518.13%
DIR-UN.TODream Industrial Real Estate Investment Trust3.88%$0.4965.95%
GGBR3.SAGerdau S.A.3.88%$0.6845.15%
HMC.AXHMC Capital Limited3.88%$0.1611.87%
000728.SZGuoyuan Securities Company Limited3.87%$0.3252.50%
2145.HKShanghai Chicmax Cosmetic Co., Ltd.3.87%$2.6964.24%
600025.SSHuaneng Lancang River Hydropower Inc.3.87%$0.3575.95%
603970.SSSino-Agri Leading Biosciences Co.,Ltd3.87%$0.5074.51%
6509.TWOTaiwan Hopax Chems.Mfg.Co.,Ltd.3.87%$1.2549.65%
AKZA.ASAkzo Nobel N.V.3.87%$2.3195.66%
1763.HKChina Isotope & Radiation Corporation3.86%$0.8332.12%
600761.SSAnhui Heli Co.,Ltd.3.86%$0.8153.66%
605337.SSZhe Jiang Li Zi Yuan Food Co.,Ltd.3.86%$0.4692.31%
BOSS.DEHugo Boss AG3.86%$1.4043.29%
GOFORE.HEGofore Oyj3.86%$0.5283.77%
LOGO.ISLogo Yazilim Sanayi ve Ticaret A.S.3.86%$5.9443.46%
PKTM.VIPIERER Mobility AG3.86%$0.583.67%
SICT.BKSilicon Craft Technology Public Company Limited3.86%$0.0951.68%
000591.SZCECEP Solar Energy Co.,Ltd.3.85%$0.1763.11%
0QKI.LSwisscom AG3.85%$22.0191.35%
215200.KQMegaStudyEdu Co. Ltd3.85%$1,569.9734.80%
2163.TArtner Co.,Ltd.3.85%$81.5765.08%
3265.TWOWinstek Semiconductor Co., Ltd.3.85%$4.8095.49%
6301.TKomatsu Ltd.3.85%$192.6642.48%
9563.SRBena Steel Industries Co.3.85%$1.5884.07%
CPN-R.BKCentral Pattana Public Company Limited3.85%$2.1257.57%
000080.KSHITEJINRO Co., Ltd.3.84%$700.2055.98%
601921.SSZhejiang Publishing & Media Co., Ltd.3.84%$0.3051.98%
9945.TWRuentex Development Co.,Ltd.3.84%$1.1433.31%
AGUAS-A.SNAguas Andinas S.A.3.84%$14.2270.41%
TNKTeekay Tankers Ltd.3.84%$1.9821.29%
WALMEX.MXWal-Mart de México, S.A.B. de C.V.3.84%$2.1674.07%
000810.KSSamsung Fire & Marine Insurance Co., Ltd.3.83%$19,037.8640.33%
0QPW.LZug Estates Holding AG3.83%$85.0029.91%
9910.TWFeng Tay Enterprises Co., Ltd.3.83%$4.3186.98%
CTC-A.TOCanadian Tire Corporation, Limited3.83%$6.7249.69%
LOR.DEL'Oréal S.A.3.83%$13.9859.38%
SOBOSouth Bow Corporation3.83%$1.0769.36%
0799.HKIGG Inc3.82%$0.1512.76%
105630.KSHansae Co., Ltd.3.82%$500.3039.98%
SIX2.DESixt SE3.82%$2.7144.65%