Consolidated Water Co. Ltd. (CWCO) · DCF calculator
What is one share of Consolidated Water worth today if its operating cash flow keeps growing and the market keeps paying the multiple it has paid? Every starting value below comes from Consolidated Water's own filings and price history. Change any of them; nothing here is a forecast or advice.
Operating cash flow, as filed and projected
| Year | Growth | Operating cash flow |
|---|---|---|
| 1 | 20.1% | 47.75M |
| 2 | 18.1% | 56.38M |
| 3 | 16.3% | 65.56M |
| 4 | 14.6% | 75.16M |
| 5 | 13.2% | 85.07M |
How it is worked out
The figure is grown for each year of the horizon at a rate that fades, the multiple puts a market value on the last year's figure, and that value is divided over the share count as it will be by then. What that future price is worth today is it discounted at the return you want.
growth in year n = g × (1 − fade)n−1
figure in year n = figure in year n−1 × (1 + growth in year n)
future price = figure in year N × multiple ÷ (shares today × (1 + share change)N)
fair value = future price ÷ (1 + return wanted)N
The starting values are Consolidated Water's own: the latest twelve months of the figure as filed, what it actually grew at over four years, the company's own five-year median multiple of it or today's if that is lower, and what its share count actually did. A model this simple is only as good as the assumptions put into it, and the most important one -- that the business keeps growing -- is the one no filing can tell you.