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 43 of 151 Next »
Ticker Company Dividend Yield % Dividend Per Share Payout Ratio %
9541.SRAcademy Of Learning Company3.74%$0.4378.32%
BBCA.JKPT Bank Central Asia Tbk3.74%$300.0564.91%
BKGI.BKBangkok Genomics Innovation Public Company Limited3.74%$0.0588.71%
DACDanaos Corporation3.74%$3.5614.02%
JKON.JKPT Jaya Konstruksi Manggala Pratama Tbk3.74%$3.2545.42%
MDKI.JKPT Emdeki Utama Tbk3.74%$8.0062.54%
NORCO.OLNorconsult ASA3.74%$1.6672.73%
SLCE3.SASLC Agrícola S.A.3.74%$0.5541.84%
3948.HKInner Mongolia Yitai Coal Co., Ltd.3.73%$0.6524.32%
IDPR.JKPT Indonesia Pondasi Raya Tbk3.73%$10.0075.77%
KIMBERA.MXKimberly-Clark de México, S. A. B. de C. V.3.73%$1.4357.51%
PGMN3.SAEmpreendimentos Pague Menos S.A.3.73%$0.2374.59%
QIBK.QAQatar Islamic Bank (Q.P.S.C.)3.73%$0.8944.73%
002367.SZCanny Elevator Co., Ltd.3.72%$0.3060.41%
600300.SSV V Food & Beverage Co.,Ltd3.72%$0.1351.92%
603899.SSShanghai M&G Stationery Inc.3.72%$1.0169.72%
RHC.AXRamsay Health Care Limited3.72%$1.2932.49%
000999.SZChina Resources Sanjiu Medical & Pharmaceutical Co., Ltd.3.71%$1.0663.26%
214180.KQHecto Innovation Co., Ltd.3.71%$602.8723.75%
603948.SSZhejiang Jianye Chemical Co., Ltd.3.71%$1.0175.31%
6089.TWill Group, Inc.3.71%$44.4274.52%
QNNS.QAQatar Navigation Q.P.S.C.3.71%$0.4038.98%
016610.KSDB Securities Co., Ltd.3.70%$404.3430.24%
2471.TS-Pool, Inc.3.70%$10.1043.62%
3430.TWOChitec Technology Co., Ltd.3.70%$2.5075.20%
4560.TWStrong H Machinery Technology (Cayman) Incorporation3.70%$1.2042.07%
5347.KLTenaga Nasional Berhad3.70%$0.5162.35%
LOOMIS.STLoomis AB (publ)3.70%$14.1053.46%
MIDW-A.STMidway Holding AB (publ)3.70%$0.9165.00%
PNDORA.COPandora A/S3.70%$25.7237.06%
SPVI.BKS P V I Public Company Limited3.70%$0.0837.67%
3401.TTeijin Limited3.69%$49.9735.81%
BZU.MIBuzzi Unicem S.p.A.3.69%$1.9018.48%
CWP.AXCedar Woods Properties Limited3.69%$0.3115.67%
CX.STCombinedX AB (publ)3.69%$1.3755.29%
REH.AXReece Limited3.69%$0.4943.22%
000783.SZChangjiang Securities Company Limited3.68%$0.3043.98%
014820.KSDongwon Systems Corporation3.68%$916.7745.73%
2245.HKLygend Resources & Technology Co., Ltd.3.68%$0.9136.29%
5DD.SIMicro-Mechanics (Holdings) Ltd.3.68%$0.0666.85%
600598.SSHeilongjiang Agriculture Company Limited3.68%$0.5589.21%
601156.SSEastern Air Logistics Co., Ltd.3.68%$0.6841.00%
NICL.JKPT PAM Mineral Tbk3.68%$51.0099.38%
PNBN.JKP.T. Bank Pan Indonesia Tbk3.68%$42.0037.86%
3617.TWCyber Power Systems, Inc.3.67%$7.6445.54%
5296.KLMr D.I.Y. Group (M) Berhad3.67%$0.0687.61%
600535.SSTasly Pharmaceutical Group Co., Ltd3.67%$0.5575.36%
8424.TFuyo General Lease Co., Ltd.3.67%$157.5152.44%
9937.TWNational Petroleum Co., Ltd.3.67%$2.1088.32%
KEMIRA.HEKemira Oyj3.67%$0.7249.87%