CWCO - Intrinsic Value and Financial Analysis - Consolidated Water Co. Ltd.

Consolidated Water Co. Ltd. CWCO

Utilities - Regulated Water - NASDAQ - KY

Watchlist

$ 25.77

4.67 %

$ 408 M

Market Cap

13.56

P/E

BALANCE SHEET

220 M ASSETS

Growth Rates

1Year 13.76%

3Years 6.94%

5Years 4.94%

7Years 4.29%

10Years 2.88%

27.7 M LIABILITIES

Growth Rates

1Year 9.90%

3Years 38.05%

5Years 25.93%

7Years 16.54%

10Years 1.52%

187 M EQUITY

Growth Rates

1Year 17.01%

3Years 5.10%

5Years 3.81%

7Years 3.63%

10Years 3.01%

BALANCE SHEET DECOMPOSITION

Balance Sheet Decomposition Consolidated Water Co. Ltd.

220 M ASSETS
27.7 M LIABILITIES

Current Assets	113 M
Cash & Short-Term Investments	42.6 M
Receivables	59.8 M
Other Current Assets	10.3 M
Non-Current Assets	106 M
Long-Term Investments	1.41 M
PP&E	58.5 M
Other Non-Current Assets	45.8 M

Current Liabilities	23.9 M
Accounts Payable	11.6 M
Short-Term Debt	649 K
Other Current Liabilities	11.7 M
Non-Current Liabilities	3.84 M
Long-Term Debt	2.02 M
Other Non-Current Liabilities	1.82 M

Balance Sheet

Millions

	Dec-2023	Dec-2022	Dec-2021	Dec-2020	Dec-2019	Dec-2018	Dec-2017	Dec-2016	Dec-2015	Dec-2014	Dec-2013	Dec-2012	Dec-2011	Dec-2010	Dec-2009	Dec-2008	Dec-2007	Dec-2006	Dec-2005	Dec-2004	Dec-2003	Dec-2002	Dec-2001	Dec-2000	Dec-1999	Dec-1998	Dec-1997	Dec-1996	Dec-1995	Dec-1994	Dec-1993
ASSETS
Cash & Cash Equivalents	42.6	50.7	40.4	43.8	42.9	31.3	47.2	39.3	44.8	35.7	33.6	33.9	37.6	46.1	44.4	36.3	38.5	37.3	12.0	9.2	8.2	0.6	0.5	0.3	22.1 K	0.4	1.1	1.1	(0.3)	(0.2)	(0.4)
Short Term Investments	0	0	2.5	0	0	0	0	0	5.6	5.0	8.6	8.6	8.5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Receivables	59.8	30.0	27.8	22.0	24.6	25.8	16.3	18.2	11.4	14.6	20.6	14.3	10.4	13.9	11.2	14.7	10.8	7.0	6.3	7.7	5.0	1.4	1.3	1.5	1.2	0.8	0.8	0.6	0.7	0.5	0.7
Inventory	6.0	5.7	2.5	3.2	3.3	2.2	1.7	2.3	1.9	1.7	1.4	1.8	1.5	1.4	1.8	1.6	3.6	2.8	2.0	1.6	1.5	0.4	48.4 K	34.2 K	0.1	100 K	0	0	0	0	0
Other Current Assets	4.3	6.2	3.9	3.9	3.2	4.8	3.3	1.1	1.7	2.1	2.4	2.7	9.4	2.3	1.7	1.4	1.4	1.1	0.9	0.6	0.6	1.3	0.3	0.4	0.3	0.2	0.2	0.3	0.5	0.9	0.9
Total Current Assets	112.7	92.6	76.9	72.9	73.4	62.4	66.7	60.9	65.4	59.5	67.6	61.3	67.3	63.7	59.1	54.0	54.4	48.2	21.2	19.2	15.3	3.6	2.5	2.2	1.7	1.6	2.1	2.0	0.9	1.2	1.2
PP&E	58.5	58.3	56.3	59.5	67.0	64.9	52.3	54.0	55.7	58.3	60.1	61.6	64.3	56.2	61.2	65.1	65.0	60.2	32.7	28.9	29.7	20.3	18.4	17.6	15.2	14.4	13.0	12.6	12.2	10.1	8.8
Intangible Assets	3.4	2.8	3.4	4.1	5.0	1.9	3.8	5.2	0.8	0.9	1.1	1.5	1.5	1.7	1.9	2.1	2.9	3.7	4.5	5.4	6.4	1.6	1.8	2.0	0	0	0	0	0	0	0
Goodwill	12.9	10.4	10.4	13.3	13.3	8.0	8.4	9.8	3.5	3.5	3.5	3.5	3.6	3.6	3.6	3.6	3.6	3.6	3.6	3.6	3.4	0	0	0	0	0	0	0	0	0	0
Long Term Investments	1.4	1.5	1.7	2.1	1.9	2.6	2.8	4.1	4.5	5.2	6.6	6.9	6.6	7.8	9.2	14.4	0	0	11.3	11.1	10.0	12.4 K	12.4 K	0	0	0	0	0	0	0	0
Other Long Term Assets	29.6	26.4	28.1	27.4	7.4	8.6	10.2	7.0	7.4	6.9	7.0	6.7	6.7	6.6	8.5	29.8	23.5	23.3	15.1	0.4	0.5	12.4	12.4 K	0	16.4 K	0	0	100 K	0.2	0	100 K
Other Assets	1.1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Total Assets	219.6	193.0	177.0	179.6	192.3	172.5	165.5	163.6	161.6	160.5	165.4	150.4	160.9	152.2	154.5	154.7	149.3	139.0	88.4	70.8	68.6	25.5	22.7	21.8	16.9	16.0	15.1	14.7	13.3	11.3	10.1
LIABILITIES
Accounts Payable	11.6	8.4	2.8	2.7	3.5	4.6	2.1	4.9	4.8	6.0	7.2	4.7	4.6	4.3	6.2	7.3	5.0	5.5	3.9	3.9	2.1	1.1	1.1	1.4	0.3	0.6	0.5	0.6	0.6	1.0	1.0
Short Term Debt	0.6	0.7	0.7	0.5	0.7	0	0.7	0.5	7.0	9.0	5.2	1.6	17.5	1.4	1.3	1.2	1.1	1.2	3.5	3.7	3.8	0.5	0.4	0.9	1.6	0.7	0.7	0.6	0.6	0.5	0.4
Other Current Liabilities	5.1	4.4	3.1	3.2	3.3	3.2	4.7	1.2	1.2	1.2	11.2	2.3	1.2	1.2	1.2	1.0	60.7 K	1.0	0.8	0.8	0.7	0.4	0.7	0.4	0.4	0.2	0.3	0.2	1.0	0.3	0.4
Total Current Liabilities	23.9	22.7	7.7	6.9	8.2	7.9	7.6	6.7	13.2	16.2	23.6	8.7	23.3	6.9	8.7	9.5	6.2	7.6	8.2	8.4	6.5	2.6	2.2	2.8	2.3	1.5	1.5	1.4	2.2	1.8	1.8
Long Term Debt	2.0	1.8	2.3	1.1	1.2	0	0	0	0	0	0	5.2	6.9	16.9	19.8	21.1	22.4	23.5	19.4	12.9	16.6	2.1	1.2	1.1	3.9	5.3	3.1	3.7	4.3	4.0	3.9
Deferred Tax Income	0	0.6	1.2	1.4	1.5	0.7	1.0	1.9	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Other Liabilities	1.8	0.2	1.4	2.5	4.9	0.2	0.8	0.9	0.2	0.2	0.3	0.4	0.4	0.4	0.5	(21.1)	0.5	0.5	0.3	0.4	0.4	0.1	90.3 K	93.9 K	(1.8)	(2.5)	0	100 K	0.3	100 K	0.3
Total Liabilities	27.7	25.2	11.4	10.5	14.3	8.8	9.5	9.5	13.4	16.4	23.9	14.3	30.6	24.2	28.9	31.1	29.0	31.6	28.0	21.6	23.5	4.8	3.5	4.0	4.3	4.3	4.6	5.2	6.8	5.9	6.0
EQUITY
Common Stock	9.5	9.2	9.1	9.1	9.0	9.0	9.0	8.9	8.9	8.8	8.8	8.8	8.7	8.7	8.7	8.7	8.7	8.5	7.3	6.9	6.8	4.8	4.7	4.6	3.8	0	0	0	0	0	0
Retained Earnings	85.1	61.2	60.6	64.9	66.4	59.3	53.1	51.6	52.1	49.0	47.2	43.0	38.0	36.3	34.4	32.3	29.9	21.3	16.9	14.1	10.6	8.5	7.6	6.4	7.1	5.7	4.5	3.7	2.9	2.3	2.0
Other Accumulative Comprehensive Income/Loss	0	0	0	0	0	(0.5)	(0.5)	(0.5)	(0.5)	(0.5)	(0.5)	0	0	0	0	0.7	0	(15.0)	19.4 K	0	(16.3)	(23.7)	(8.4)	(7.2)	(6.4)	(5.6)	(4.9)	(4.3)	(5.1)	(5.1)	(5.3)
Total Equity	191.8	167.8	165.7	169.0	178.0	163.8	156.0	154.1	148.2	144.1	141.5	136.1	130.3	128.0	125.5	123.6	120.3	107.3	60.4	49.2	45.1	20.7	19.3	17.8	12.5	11.7	10.5	9.5	6.5	5.4	4.1
Total Liabilities and Equity	219.6	193.0	177.0	179.6	192.3	172.5	165.5	163.6	161.6	160.5	165.4	150.4	160.9	152.2	154.5	154.7	149.3	139.0	88.4	70.8	68.6	25.5	22.7	21.8	16.9	16.0	15.1	14.7	13.3	11.3	10.1
SHARES OUTSTANDING
Common Shares Outstanding	15.7	15.3	15.3	15.1	15.0	15.0	14.9	14.8	14.7	14.7	14.6	14.6	14.6	14.5	14.5	14.5	14.4	12.4	11.8	11.5	9.8	7.9	7.8	7.1	6.1	6.1	5.7	5.5	4.7	4.0	3.3	4.3

Balance Sheet

Premium Plan

Unlimited Plan