Definitive Analysis
Loading...
Definitive Analysis

Financial Statements

Mode

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 49 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
064960.KSSNT Motiv Co., Ltd.3.32%$1,136.7332.23%
0RNT.LBrødrene A & O Johansen A/S3.32%$3.0743.48%
603676.SSTibet Weixinkang Medicine Co., Ltd.3.32%$0.3567.92%
6791.TWOTaiwan Auto-Design Co.3.32%$3.4985.79%
9432.TNTT, Inc.3.32%$5.2441.63%
AJBU.SIKeppel DC REIT3.32%$0.0751.19%
MFF.AXMFF Capital Investments Limited3.32%$0.166.10%
VZN.SWVZ Holding AG3.32%$4.9645.59%
6438.TWSymtek Automation Asia Co., Ltd.3.31%$4.6960.82%
8272.TWOChanging Information Technology Inc.3.31%$2.5960.59%
ALDEL.PADelfingen Industry S.A.3.31%$1.1538.10%
GJF.OLGjensidige Forsikring ASA3.31%$10.0077.33%
001560.KSCheil Grinding Wheel Ind. Co., Ltd.3.30%$321.6715.39%
002895.SZGuizhou Chanhen Chemical Corporation3.30%$1.2157.70%
0GWB.ILL E Lundbergföretagen AB (publ)3.30%$16.7254.63%
2441.TWGreatek Electronics Inc.3.30%$2.9871.42%
MAVI.ISMavi Giyim Sanayi ve Ticaret A.S.3.30%$1.4153.21%
MTSA3.SAMETISA Metalúrgica Timboense S.A.3.30%$2.5153.64%
3475.TGood Com Asset Co., Ltd.3.29%$41.3153.09%
ARCOArcos Dorados Holdings Inc.3.29%$0.2420.61%
GLINT.LSGlintt - Global Intelligent Technologies, S.A.3.29%$0.0463.67%
LABB.MXGenomma Lab Internacional, S.A.B. de C.V.3.29%$0.5928.90%
009770.KSSam Jung Pulp Co.,Ltd.3.28%$1,000.1513.81%
3050.SRSouthern Province Cement Company3.28%$0.7453.26%
603075.SSHangzhou Heatwell Electric Heating Technology Co., Ltd.3.28%$0.7290.17%
6741.TNippon Signal Co., Ltd.3.28%$42.9832.43%
000088.SZShenzhen Yan Tian Port Holdings Co.,Ltd.3.27%$0.1553.36%
002648.SZSatellite Chemical Co.,Ltd.3.27%$0.5831.65%
005750.KSDaelim B&Co Co.,Ltd.3.27%$152.6038.32%
011760.KSHyundai Corporation3.27%$700.0011.11%
2248.TWOShining Victory Motor Electronic Co., Ltd.3.27%$1.6118.34%
4021.TNissan Chemical Corporation3.27%$175.2852.54%
603439.SSGuiZhou SanLi Pharmaceutical Co.,Ltd3.27%$0.3895.76%
7942.TJSP Corporation3.27%$79.9839.18%
BRIT3.SABrisanet Participações S.A.3.27%$0.0982.21%
IAF-PI.TOiA Financial Corporation Inc.3.27%$0.8225.22%
ORS.MIOrsero S.p.A.3.27%$0.6133.02%
PEHN.SWPrivate Equity Holding AG3.27%$2.0817.62%
4471.TSanyo Chemical Industries Ltd.3.26%$169.9727.59%
5315.TWOUnited Radiant Technology Corporation3.26%$0.8049.66%
603558.SSZhejiang Jasan Holding Group Co., Ltd.3.26%$0.3734.35%
7744.TNoritsu Koki Co., Ltd.3.26%$60.5454.32%
MYTIL.ATMetlen Energy & Metals S.A.3.26%$1.7219.73%
TCW.TOTrican Well Service Ltd.3.26%$0.2035.68%
001040.KSCJ Corporation3.25%$5,626.0348.88%
002507.SZChongqing Fuling Zhacai Group Co., Ltd.3.25%$0.4260.46%
016740.KSDUAL Co., Ltd.3.25%$123.0716.96%
131090.KQSecuve Co., Ltd.3.25%$125.0032.25%
300729.SZLoctek Ergonomic Technology Corp.3.25%$0.4463.17%
300881.SZShengtak New Material Co., Ltd3.25%$1.1065.22%