CWCO DCF Model
| Dec'19 Actual | Dec'20 Actual | Dec'21 Actual | Dec'22 Actual | Dec'23 Actual | Dec'24 Estimate | Dec'25 Estimate | Dec'26 Estimate | Dec'27 Estimate | Dec'28 Estimate | Dec'29 Estimate | Dec'30 Estimate | Dec'31 Estimate | Dec'32 Estimate | Dec'33 Estimate | Dec'34 Terminal | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
% growth | 68.8 4.7% | 72.6 5.6% | 66.9 (7.9%) | 94.1 40.7% | 180.2 91.5% | 138.9 (22.9%) | 151.0 8.7% | 230.0 52.4% | 335.8 46.0% | 469.0 39.7% | 625.1 33.3% | 793.5 26.9% | 956.8 20.6% | 1,092.8 14.2% | 1,178.6 7.9% | 1,196.3 1.5% |
% margin | 2.5 3.6% | 2.0 2.8% | (0.9) (1.4%) | 3.7 4.0% | 37.2 20.6% | 18.7 13.5% | 20.3 13.5% | 31.0 13.5% | 45.3 13.5% | 63.2 13.5% | 84.3 13.5% | 107.0 13.5% | 129.0 13.5% | 147.3 13.5% | 158.9 13.5% | 161.3 13.5% |
NOPAT % effective tax rate | 2.4 3.6% | 2.0 2.8% | (1.1) (1.6%) | 3.6 3.8% | 30.6 17.0% | 15.4 11.1% | 16.7 11.1% | 25.5 11.1% | 37.2 11.1% | 52.0 11.1% | 69.3 11.1% | 88.0 11.1% | 106.1 11.1% | 121.1 11.1% | 130.7 11.1% | 132.6 11.1% |
% of revenue | 7.2 10.5% | 7.4 10.2% | 6.9 10.4% | 6.2 6.6% | 6.6 3.6% | 9.5 6.9% | 10.4 6.9% | 15.8 6.9% | 23.0 6.9% | 32.2 6.9% | 42.9 6.9% | 54.4 6.9% | 65.6 6.9% | 74.9 6.9% | 80.8 6.9% | 82.1 6.9% |
% of revenue | (3.5) (5.1%) | (1.7) (2.4%) | (1.5) (2.2%) | (7.5) (8.0%) | (5.0) (2.8%) | (6.0) (4.3%) | (6.6) (4.3%) | (10.0) (4.3%) | (14.6) (4.3%) | (20.4) (4.3%) | (27.2) (4.3%) | (34.5) (4.3%) | (41.6) (4.3%) | (47.5) (4.3%) | (51.3) (4.3%) | (52.0) (4.3%) |
% of revenue | (3.1) (4.6%) | 1.3 1.8% | (5.9) (8.8%) | 5.9 6.3% | (30.7) (17.0%) | (9.1) (6.5%) | (9.8) (6.5%) | (15.0) (6.5%) | (21.9) (6.5%) | (30.6) (6.5%) | (40.8) (6.5%) | (51.7) (6.5%) | (62.4) (6.5%) | (71.3) (6.5%) | (76.9) (6.5%) | (78.0) (6.5%) |
Free Cash Flow to Firm (FCFF) % of revenue | 3.0 4.3% | 9.0 12.4% | (1.5) (2.3%) | 8.1 8.6% | 1.4 0.8% | 9.8 7.1% | 10.7 7.1% | 16.3 7.1% | 23.8 7.1% | 33.2 7.1% | 44.2 7.1% | 56.1 7.1% | 67.7 7.1% | 77.3 7.1% | 83.4 7.1% | 84.6 7.1% |
% of FCFF used in calculation | 100.0% | 80.8% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | ||||||
Discount period | 0.50 | 1.50 | 2.50 | 3.50 | 4.50 | 5.50 | 6.50 | 7.50 | 8.50 | |||||||
Discount factor | 0.96 | 0.89 | 0.82 | 0.76 | 0.70 | 0.64 | 0.59 | 0.55 | 0.51 | |||||||
Discounted FCFF (DFCFF) | 8.3 | 14.4 | 19.5 | 25.1 | 30.9 | 36.2 | 40.3 | 42.5 | 42.3 |
Best stock ideas on the market right now
With Value Sense, you can find undervalued stocks list with intrinsic value. Discover more stock market investment ideas.
Undervalued stocks right now
Discover the top 20 best undervalued stocks to buy for Mar 2025, listed on the Nasdaq or NYSE.
Low P/E stocks
Explore the best low P/E stocks to buy in 2025, featuring top companies trading at low P/E ratios.
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.
CWCO DCF Value
DCF Value Calculation
Equity Value Bridge
CWCO DCF Financials
CWCO DCF sensitivity
Explore more intrinsic value tools hub for CWCO
FAQ
What is Consolidated Water Co. Ltd. DCF (discounted cash flow) valuation?
As of Mar 11, 2025, Consolidated Water Co. Ltd.'s Discounted Cash Flow (DCF) valuation estimates its share price at $56.1. This suggests it may be undervalued by 99.0% compared to its current price of around $28.2, using a WACC of 8.3% and growth rates of 1.5%.
What is Consolidated Water Co. Ltd. WACC?
As of Mar 11, 2025, Consolidated Water Co. Ltd.'s Weighted Average Cost of Capital (WACC) is approximately 8.3%.
What is Consolidated Water Co. Ltd. Enterprise Value?
As of Mar 11, 2025, Consolidated Water Co. Ltd.'s Enterprise Value (EV) is approximately $864.5M. This value reflects the company's total market capitalization plus debt, minus cash and cash equivalents, providing a comprehensive measure of its overall value in the market.