Last Price$28.21.5%
Market Cap$454.6M
LTM Rule of 40 (EBIT margin)
20.9%
5Y avg
34.6%
Regulated Water industry
median
37.8%
Stock quality & Intrinsic value
7/10
0.7% undervalued
Consolidated Water Co. Ltd. Rule of 40 (EBIT margin)
Annual
Quarterly
LTM
Industry median
Company stand-alone
Crunching data... Almost there!
| Dec'04 | Dec'05 | Dec'06 | Dec'07 | Dec'08 | Dec'09 | Dec'10 | Dec'11 | Dec'12 | Dec'13 | Dec'14 | Dec'15 | Dec'16 | Dec'17 | Dec'18 | Dec'19 | Dec'20 | Dec'21 | Dec'22 | Dec'23 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Rule of 40 (EBIT margin) | 0.0% | 28.6% | 64.8% | 47.3% | 48.6% | 10.6% | (1.9%) | 18.5% | 29.3% | 9.5% | 12.6% | 1.9% | 4.5% | 13.0% | 17.6% | 8.3% | 8.4% | (9.4%) | 44.7% | 112.1% |
Overvalued or undervalued?
Check the intrinsic value for CWCO
and see if it's the right time to invest.
Consolidated Water Co. Ltd. (CWCO) Rule of 40 (EBIT margin) comparison analysis
General
LTM Rule of 40 (EBIT margin)
OTHER METRICS
Company name
Revenue growth
EPS growth
Net Income margin
Consolidated Water Co. Ltd.CWCO
20.9%
91.5%
208.2%
16.4%
Median Peer Set
40.4%
10.8%
13.4%
19.2%
Companhia de Saneamento Básico do Estado de São Paulo - SABESPSBS
91.5%
19.7%
16.6%
13.8%
California Water Service GroupCWT
54.5%
30.5%
258.2%
18.4%
American Water Works Company, Inc.AWK
47.3%
10.6%
10.2%
22.4%
Middlesex Water CompanyMSEX
43.1%
15.4%
40.7%
23.1%
The York Water CompanyYORW
42.9%
5.5%
(14.5%)
27.1%
Essential Utilities, Inc.WTRG
37.9%
1.6%
16.7%
28.5%
Artesian Resources CorporationARTNA
37.7%
(0.0%)
(12.1%)
16.9%
Aris Water Solutions, Inc.ARIS
35.9%
11.0%
233.9%
6.2%
SJW GroupSJW
34.4%
11.6%
6.7%
12.6%
American States Water CompanyAWR
30.9%
(0.0%)
(5.6%)
20.0%
CWCO key stats
USD
Millions
Billions
Annual
Quarterly
Trailing
Key stats
Income statement
Balance sheet
Cash Flow Statement
Valuation
Ratios
Per share
Per employee
Dividends & Yields
| Dec'04 | Dec'05 | Dec'06 | Dec'07 | Dec'08 | Dec'09 | Dec'10 | Dec'11 | Dec'12 | Dec'13 | Dec'14 | Dec'15 | Dec'16 | Dec'17 | Dec'18 | Dec'19 | Dec'20 | Dec'21 | Dec'22 | Dec'23 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
% growth | 23.3 0.0% | 26.2 12.5% | 38.2 46.0% | 49.1 28.6% | 65.7 33.6% | 58.0 (11.7%) | 50.7 (12.6%) | 55.2 8.8% | 65.5 18.7% | 63.8 (2.5%) | 65.6 2.7% | 57.1 (12.9%) | 57.9 1.3% | 62.3 7.7% | 65.7 5.5% | 68.8 4.7% | 72.6 5.6% | 66.9 (7.9%) | 94.1 40.7% | 180.2 91.5% |
| Cost of Goods Sold (COGS) | 13.7 | 15.8 | 22.6 | 30.5 | 47.0 | 35.0 | 34.1 | 36.1 | 43.5 | 40.3 | 42.4 | 34.2 | 33.6 | 36.9 | 39.0 | 40.5 | 45.9 | 43.4 | 63.7 | 118.3 |
% margin | 9.6 41.3% | 10.4 39.5% | 15.6 40.8% | 18.7 38.0% | 18.6 28.4% | 23.0 39.6% | 16.6 32.8% | 19.0 34.5% | 22.0 33.6% | 23.5 36.8% | 23.1 35.3% | 22.9 40.1% | 24.3 41.9% | 25.4 40.8% | 26.7 40.7% | 28.3 41.1% | 26.8 36.9% | 23.5 35.2% | 30.4 32.3% | 61.9 34.4% |
| Operating Expenses | 5.1 | 6.1 | 8.2 | 9.5 | 8.8 | 10.1 | 11.2 | 13.7 | 14.5 | 15.8 | 16.7 | 14.5 | 18.7 | 19.1 | 18.7 | 19.3 | 18.4 | 18.4 | 21.1 | 24.8 |
| Research & Development Expenses (R&D) | 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 | 0.0 | 0.0 | 0.0 | 0.4 | 0.0 |
| Selling, General & Administrative Expenses (SG&A) | 5.1 | 6.1 | 8.4 | 9.5 | 8.8 | 10.1 | 11.2 | 9.9 | 14.1 | 15.6 | 16.7 | 14.2 | 16.9 | 19.1 | 17.2 | 19.3 | 18.4 | 18.4 | 21.1 | 23.1 |
% margin | 5.1 21.7% | 4.2 16.1% | 7.2 18.8% | 9.2 18.7% | 9.8 15.0% | 12.9 22.2% | 5.4 10.7% | 5.4 9.7% | 6.9 10.6% | 7.7 12.0% | 6.5 9.9% | 8.5 14.8% | 1.8 3.2% | 3.3 5.3% | 8.0 12.1% | 2.5 3.6% | 2.0 2.8% | (0.9) (1.4%) | 3.7 4.0% | 37.2 20.6% |
| Interest Income | 0.1 | 0.2 | 0.3 | 1.9 | 1.4 | 0.9 | 1.4 | 1.2 | 0.8 | 0.8 | 1.4 | 1.0 | 0.6 | 0.4 | 0.7 | 0.6 | 0.5 | 0.7 | 0.4 | 0.7 |
| Interest Expense | 0.7 | 0.9 | 1.9 | 1.9 | 1.8 | 1.7 | 1.6 | 1.1 | 0.9 | 0.5 | 0.5 | 0.3 | 0.1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.1 |
| Pre-tax Income | 6.3 | 5.5 | 6,197.4 | 11,387.7 | 7,209.7 | 6,098.6 | 6,292,025.0 | 6,113,218.0 | 9.6 | 9.1 | 6.8 | 7.9 | 2.2 | 4.8 | 10.7 | 10.2 | 9.4 | 3.6 | 9.7 | 38.0 |
% effective tax rate | 0.0 0.5% | (0.0) (0.0%) | 1.3 0.0% | 5.8 0.1% | (6.3) (0.1%) | (0.6) (0.0%) | 0.2 0.0% | 0.1 0.0% | 3.9 40.8% | 2.4 26.0% | (4.3) (63.9%) | 0.4 5.7% | (0.5) (23.9%) | (0.9) (18.4%) | (0.2) (1.5%) | 0.1 0.7% | 0.1 0.9% | (0.4) (12.3%) | 0.4 4.1% | 6.8 17.8% |
% margin | 6.2 26.6% | 5.5 21.1% | 7.5 19.7% | 11.4 23.2% | 7.2 11.0% | 6.1 10.5% | 6.3 12.4% | 6.1 11.1% | 9.3 14.2% | 8.6 13.5% | 6.3 9.6% | 7.5 13.2% | 4.0 6.8% | 6.1 9.9% | 11.3 17.2% | 12.2 17.7% | 9.3 12.9% | 4.1 6.1% | 9.3 9.9% | 29.6 16.4% |
| EPS | 0.54 | 0.47 | 0.60 | 0.79 | 0.50 | 0.42 | 0.43 | 0.42 | 0.64 | 0.59 | 0.43 | 0.51 | 0.27 | 0.41 | 0.75 | 0.57 | 0.62 | 0.27 | 0.61 | 1.88 |
| Diluted EPS | 0.53 | 0.45 | 0.59 | 0.79 | 0.50 | 0.42 | 0.43 | 0.42 | 0.64 | 0.58 | 0.42 | 0.51 | 0.27 | 0.41 | 0.75 | 0.56 | 0.61 | 0.27 | 0.61 | 1.86 |
% margin | 7.1 30.7% | 9.6 36.5% | 14.2 37.1% | 15.1 30.8% | 16.4 25.0% | 19.3 33.3% | 14.3 28.2% | 12.9 23.3% | 16.1 24.6% | 14.1 22.1% | 12.7 19.3% | 13.7 24.1% | 9.1 15.8% | 10.9 17.5% | 15.3 23.3% | 19.6 28.6% | 16.3 22.5% | 10.6 15.8% | 16.0 17.0% | 44.7 24.8% |
Discover more Stock Ideas
Undervalued stocks right now
Discover the top 20 best undervalued stocks to buy for Mar 2025, listed on the Nasdaq or NYSE.
3M Return 32.1%
S&P Outperformance 19.1%
Next 3M Predicted Return 20.3%
Undervalued growth stocks
Discover the top 20 best undervalued large-cap growth stocks to buy for Mar 2025, listed on the Nasdaq or NYSE.
3M Return 35.3%
S&P Outperformance 22.3%
Next 3M Predicted Return 26.8%
Undervalued dividend stocks
Discover the top 20 best undervalued high-yield dividend stock that offers both growth potential and attractive dividend returns for Mar 2025.
3M Return 28.4%
S&P Outperformance 15.4%
Next 3M Predicted Return 16.9%
FAQ
1) What is Consolidated Water Co. Ltd.'s Rule of 40 (EBIT margin)?
As of today, Microsoft Corp's last 12-month Rule of 40 (EBIT margin) is 20.9%, based on the financial report for Sep 30, 2024 (Q3’2024). The average annual Rule of 40 (EBIT margin) for Consolidated Water Co. Ltd. have been 41.6% over the past three years, and 36.3% over the past five years.
2) Is Consolidated Water Co. Ltd.'s Rule of 40 (EBIT margin) Good?
As of today, Consolidated Water Co. Ltd.'s Rule of 40 (EBIT margin) is 20.9%, which is lower than industry median of 37.8%. It indicates that Consolidated Water Co. Ltd.'s Rule of 40 (EBIT margin) is Bad.