10-Q Filing

CONSOLIDATED WATER CO. LTD. CIK: 928340 Q1 2018

Filing Information

Form Type	10-Q
Accession Number	`0001144204-18-027144`
Period End Date	20180331
Filing Date	20180510
Fiscal Year	2018
Fiscal Period	Q1
XBRL Instance	cwco-20180331.xml

Filing Contents

This filing contains the following financial statements:

Balance Sheet 78 Income Statement 62 Cash Flow Statement 42

Balance Sheet 78 line items

Line Item	Tag	Value	Unit	Period
Redeemable preferred stock, par value (in dollars per share)	`PreferredStockParOrStatedValuePerShare`	$0.60	USD	Point-in-time
Redeemable preferred stock, par value (in dollars per share)	`PreferredStockParOrStatedValuePerShare`	$0.60	USD	Point-in-time
Redeemable preferred stock, authorized	`PreferredStockSharesAuthorized`	200,000.00	shares	Point-in-time
Redeemable preferred stock, authorized	`PreferredStockSharesAuthorized`	200,000.00	shares	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$47.18M	USD	Point-in-time
Redeemable preferred stock, issued	`PreferredStockSharesIssued`	33,034.00	shares	Point-in-time
Redeemable preferred stock, issued	`PreferredStockSharesIssued`	33,488.00	shares	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$36.53M	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$43.68M	USD	Point-in-time
Cash and cash equivalents	`CashAndCashEquivalentsAtCarryingValue`	$39.25M	USD	Point-in-time
Accounts receivable, net	`AccountsReceivableNetCurrent`	$15.05M	USD	Point-in-time
Accounts receivable, net	`AccountsReceivableNetCurrent`	$17.84M	USD	Point-in-time
Redeemable preferred stock, outstanding	`PreferredStockSharesOutstanding`	33,034.00	shares	Point-in-time
Redeemable preferred stock, outstanding	`PreferredStockSharesOutstanding`	33,488.00	shares	Point-in-time
Inventory	`InventoryNet`	$1.74M	USD	Point-in-time
Inventory	`InventoryNet`	$1.75M	USD	Point-in-time
Prepaid expenses and other current assets	`PrepaidExpenseAndOtherAssetsCurrent`	$1.08M	USD	Point-in-time
Prepaid expenses and other current assets	`PrepaidExpenseAndOtherAssetsCurrent`	$950.23K	USD	Point-in-time
Current portion of loans receivable	`NotesAndLoansReceivableNetCurrent`	$1.40M	USD	Point-in-time
Current portion of loans receivable	`NotesAndLoansReceivableNetCurrent`	$1.42M	USD	Point-in-time
Costs and estimated earnings in excess of billings	`CostsInExcessOfBillingsOnUncompletedContractsOrProgramsExpectedToBeCollectedWithinOneYear`	$199.02K	USD	Point-in-time
Costs and estimated earnings in excess of billings	`CostsInExcessOfBillingsOnUncompletedContractsOrProgramsExpectedToBeCollectedWithinOneYear`	$238.44K	USD	Point-in-time
Total current assets	`AssetsCurrent`	$65.84M	USD	Point-in-time
Total current assets	`AssetsCurrent`	$66.69M	USD	Point-in-time
Property, plant and equipment, net	`PropertyPlantAndEquipmentNet`	$49.52M	USD	Point-in-time
Property, plant and equipment, net	`PropertyPlantAndEquipmentNet`	$50.53M	USD	Point-in-time
Construction in progress	`ConstructionInProgressGross`	$5.23M	USD	Point-in-time
Construction in progress	`ConstructionInProgressGross`	$1.82M	USD	Point-in-time
Inventory, non-current	`InventoryNoncurrent`	$4.80M	USD	Point-in-time
Inventory, non-current	`InventoryNoncurrent`	$4.76M	USD	Point-in-time
Loans receivable	`NotesAndLoansReceivableNetNoncurrent`	$734.98K	USD	Point-in-time
Loans receivable	`NotesAndLoansReceivableNetNoncurrent`	$370.46K	USD	Point-in-time
Investment in OC-BVI	`EquityMethodInvestments`	$2.78M	USD	Point-in-time
Investment in OC-BVI	`EquityMethodInvestments`	$2.89M	USD	Point-in-time
Goodwill	`Goodwill`	$8.38M	USD	Point-in-time
Goodwill	`Goodwill`	$8.38M	USD	Point-in-time
Land held for development	`LandAvailableForDevelopment`	$20.56M	USD	Point-in-time
Land held for development	`LandAvailableForDevelopment`	$20.56M	USD	Point-in-time
Intangible assets, net	`IntangibleAssetsNetExcludingGoodwill`	$3.41M	USD	Point-in-time
Intangible assets, net	`IntangibleAssetsNetExcludingGoodwill`	$3.77M	USD	Point-in-time
Other assets	`OtherAssetsNoncurrent`	$5.46M	USD	Point-in-time
Other assets	`OtherAssetsNoncurrent`	$4.91M	USD	Point-in-time
Total assets	`Assets`	$165.91M	USD	Point-in-time
Total assets	`Assets`	$165.48M	USD	Point-in-time
Accounts payable and other current liabilities	`AccountsPayableOtherCurrent`	$5.64M	USD	Point-in-time
Accounts payable and other current liabilities	`AccountsPayableOtherCurrent`	$5.66M	USD	Point-in-time
Dividends payable	`DividendsPayableCurrent`	$1.29M	USD	Point-in-time
Dividends payable	`DividendsPayableCurrent`	$1.28M	USD	Point-in-time
Note payable to related party	`NotesPayableRelatedPartiesClassifiedCurrent`	$686.00K	USD	Point-in-time
Note payable to related party	`NotesPayableRelatedPartiesClassifiedCurrent`	$294.00K	USD	Point-in-time
Billings in excess of costs and estimated earnings	`BillingsInExcessOfCostCurrent`	$1.26K	USD	Point-in-time
Billings in excess of costs and estimated earnings	`BillingsInExcessOfCostCurrent`	-	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$7.63M	USD	Point-in-time
Total current liabilities	`LiabilitiesCurrent`	$7.22M	USD	Point-in-time
Deferred tax liability	`DeferredTaxLiabilitiesGrossNoncurrent`	$928.88K	USD	Point-in-time
Deferred tax liability	`DeferredTaxLiabilitiesGrossNoncurrent`	$1.02M	USD	Point-in-time
Other liabilities	`OtherLiabilitiesNoncurrent`	$803.31K	USD	Point-in-time
Other liabilities	`OtherLiabilitiesNoncurrent`	$803.31K	USD	Point-in-time
Total liabilities	`Liabilities`	$8.95M	USD	Point-in-time
Total liabilities	`Liabilities`	$9.46M	USD	Point-in-time
Commitments and contingencies	`CommitmentsAndContingencies`	-	USD	Point-in-time
Commitments and contingencies	`CommitmentsAndContingencies`	-	USD	Point-in-time
Redeemable preferred stock, $0.60 par value. Authorized 200,000 shares; issued and outstanding 33,034 and 33,488 shares, respectively	`PreferredStockValue`	$19.82K	USD	Point-in-time
Redeemable preferred stock, $0.60 par value. Authorized 200,000 shares; issued and outstanding 33,034 and 33,488 shares, respectively	`PreferredStockValue`	$20.09K	USD	Point-in-time
Additional paid-in capital	`AdditionalPaidInCapital`	$86.54M	USD	Point-in-time
Additional paid-in capital	`AdditionalPaidInCapital`	$86.41M	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$53.92M	USD	Point-in-time
Retained earnings	`RetainedEarningsAccumulatedDeficit`	$53.11M	USD	Point-in-time
Cumulative translation adjustment	`AccumulatedOtherComprehensiveIncomeLossForeignCurrencyTranslationAdjustmentNetOfTax`	$-549.55K	USD	Point-in-time
Cumulative translation adjustment	`AccumulatedOtherComprehensiveIncomeLossForeignCurrencyTranslationAdjustmentNetOfTax`	$-549.55K	USD	Point-in-time
Total Consolidated Water Co. Ltd. stockholders' equity	`StockholdersEquity`	$148.91M	USD	Point-in-time
Total Consolidated Water Co. Ltd. stockholders' equity	`StockholdersEquity`	$147.93M	USD	Point-in-time
Non-controlling interests	`MinorityInterest`	$8.09M	USD	Point-in-time
Non-controlling interests	`MinorityInterest`	$8.05M	USD	Point-in-time
Total equity	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$156.02M	USD	Point-in-time
Total equity	`StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest`	$156.97M	USD	Point-in-time
Total liabilities and equity	`LiabilitiesAndStockholdersEquity`	$165.91M	USD	Point-in-time
Total liabilities and equity	`LiabilitiesAndStockholdersEquity`	$165.48M	USD	Point-in-time

Income Statement 62 line items

Line Item	Tag	Value	Unit	Period
Retail revenues	`RetailRevenues`	$6.43M	USD	1 Quarter
Retail revenues	`RetailRevenues`	$6.48M	USD	1 Quarter
Bulk revenues	`BulkRevenue`	$7.69M	USD	1 Quarter
Bulk revenues	`BulkRevenue`	$8.23M	USD	1 Quarter
Services revenues	`SalesRevenueServicesNet`	$130.25K	USD	1 Quarter
Services revenues	`SalesRevenueServicesNet`	$123.76K	USD	1 Quarter
Manufacturing revenues	`RevenueOtherManufacturedProducts`	$552.77K	USD	1 Quarter
Manufacturing revenues	`RevenueOtherManufacturedProducts`	$1.38M	USD	1 Quarter
Total revenues	`Revenues`	$15.34M	USD	1 Quarter
Total revenues	`Revenues`	$15.68M	USD	1 Quarter
Cost of retail revenues	`CostOfRetailRevenues`	$2.76M	USD	1 Quarter
Cost of retail revenues	`CostOfRetailRevenues`	$2.68M	USD	1 Quarter
Cost of bulk revenues	`CostOfBulkRevenues`	$5.02M	USD	1 Quarter
Cost of bulk revenues	`CostOfBulkRevenues`	$5.40M	USD	1 Quarter
Cost of services revenues	`CostOfServices`	$102.17K	USD	1 Quarter
Cost of services revenues	`CostOfServices`	$134.87K	USD	1 Quarter
Cost of manufacturing revenues	`ManufacturingCosts`	$1.04M	USD	1 Quarter
Cost of manufacturing revenues	`ManufacturingCosts`	$438.86K	USD	1 Quarter
Total cost of revenues	`CostOfRevenue`	$8.84M	USD	1 Quarter
Total cost of revenues	`CostOfRevenue`	$8.73M	USD	1 Quarter
Gross profit	`GrossProfit`	$6.83M	USD	1 Quarter
Gross profit	`GrossProfit`	$6.60M	USD	1 Quarter
General and administrative expenses	`GeneralAndAdministrativeExpense`	$4.77M	USD	1 Quarter
General and administrative expenses	`GeneralAndAdministrativeExpense`	$4.80M	USD	1 Quarter
Loss (gain) on asset dispositions and impairments, net	`GainLossOnSalesOfAssetsAndAssetImpairmentCharges`	$-1.34K	USD	1 Quarter
Loss (gain) on asset dispositions and impairments, net	`GainLossOnSalesOfAssetsAndAssetImpairmentCharges`	$9.63K	USD	1 Quarter
Income from operations	`OperatingIncomeLoss`	$1.84M	USD	1 Quarter
Income from operations	`OperatingIncomeLoss`	$2.05M	USD	1 Quarter
Interest income	`InterestIncomeOther`	$122.19K	USD	1 Quarter
Interest income	`InterestIncomeOther`	$161.12K	USD	1 Quarter
Interest expense	`InterestExpense`	$1.75K	USD	1 Quarter
Interest expense	`InterestExpense`	$2.22K	USD	1 Quarter
Profit sharing income from OC-BVI	`ProfitLossFromSubsidiaries`	$10.12K	USD	1 Quarter
Profit sharing income from OC-BVI	`ProfitLossFromSubsidiaries`	$28.35K	USD	1 Quarter
Equity in the earnings of OC-BVI	`IncomeLossFromEquityMethodInvestments`	$80.59K	USD	1 Quarter
Equity in the earnings of OC-BVI	`IncomeLossFromEquityMethodInvestments`	$26.87K	USD	1 Quarter
Net unrealized gain (loss) on put/call options	`UnrealizedGainLossOnDerivatives`	$165.00K	USD	1 Quarter
Net unrealized gain (loss) on put/call options	`UnrealizedGainLossOnDerivatives`	$-206.00K	USD	1 Quarter
Other	`OtherNonoperatingIncomeExpense`	$82.60K	USD	1 Quarter
Other	`OtherNonoperatingIncomeExpense`	$71.79K	USD	1 Quarter
Other income, net	`NonoperatingIncomeExpense`	$393.75K	USD	1 Quarter
Other income, net	`NonoperatingIncomeExpense`	$144.91K	USD	1 Quarter
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest`	$1.98M	USD	1 Quarter
Income before income taxes	`IncomeLossFromContinuingOperationsBeforeIncomeTaxesExtraordinaryItemsNoncontrollingInterest`	$2.44M	USD	1 Quarter
Provision for (benefit from) income taxes	`IncomeTaxExpenseBenefit`	$-139.70K	USD	1 Quarter
Provision for (benefit from) income taxes	`IncomeTaxExpenseBenefit`	$-77.39K	USD	1 Quarter
Net income	`ProfitLoss`	$2.06M	USD	1 Quarter
Net income	`ProfitLoss`	$2.58M	USD	1 Quarter
Income (loss) attributable to non-controlling interests	`NetIncomeLossAttributableToNoncontrollingInterest`	$-51.78K	USD	1 Quarter
Income (loss) attributable to non-controlling interests	`NetIncomeLossAttributableToNoncontrollingInterest`	$-34.49K	USD	1 Quarter
Net income attributable to Consolidated Water Co. Ltd. stockholders	`NetIncomeLoss`	$2.09M	USD	1 Quarter
Net income attributable to Consolidated Water Co. Ltd. stockholders	`NetIncomeLoss`	$2.63M	USD	1 Quarter
Basic earnings per common share attributable to Consolidated Water Co. Ltd. common stockholders	`EarningsPerShareBasic`	$0.18	USD	1 Quarter
Basic earnings per common share attributable to Consolidated Water Co. Ltd. common stockholders	`EarningsPerShareBasic`	$0.14	USD	1 Quarter
Diluted earnings per common share attributable to Consolidated Water Co. Ltd. common stockholders	`EarningsPerShareDiluted`	$0.14	USD	1 Quarter
Diluted earnings per common share attributable to Consolidated Water Co. Ltd. common stockholders	`EarningsPerShareDiluted`	$0.18	USD	1 Quarter
Dividends declared per common share	`CommonStockDividendsPerShareDeclared`	$0.09	USD	1 Quarter
Dividends declared per common share	`CommonStockDividendsPerShareDeclared`	$0.07	USD	1 Quarter
Basic earnings per share	`WeightedAverageNumberOfSharesOutstandingBasic`	14.87M	shares	1 Quarter
Basic earnings per share	`WeightedAverageNumberOfSharesOutstandingBasic`	14.96M	shares	1 Quarter
Diluted earnings per share	`WeightedAverageNumberOfDilutedSharesOutstanding`	15.11M	shares	1 Quarter
Diluted earnings per share	`WeightedAverageNumberOfDilutedSharesOutstanding`	15.04M	shares	1 Quarter

Cash Flow Statement 42 line items

Line Item	Tag	Value	Unit	Period
Net cash provided by (used in) operating activities	`NetCashProvidedByUsedInOperatingActivities`	$-719.49K	USD	1 Quarter
Net cash provided by (used in) operating activities	`NetCashProvidedByUsedInOperatingActivities`	$679.08K	USD	1 Quarter
Additions to property, plant and equipment and construction in progress	`PaymentsToAcquirePropertyPlantAndEquipment`	$2.87M	USD	1 Quarter
Additions to property, plant and equipment and construction in progress	`PaymentsToAcquirePropertyPlantAndEquipment`	$1.77M	USD	1 Quarter
Proceeds from sale of equipment	`ProceedsFromSaleOfPropertyPlantAndEquipment`	$9.63K	USD	1 Quarter
Proceeds from sale of equipment	`ProceedsFromSaleOfPropertyPlantAndEquipment`	$11.19K	USD	1 Quarter
Collections on loans receivable	`ProceedsFromCollectionOfLoansReceivable`	$479.41K	USD	1 Quarter
Collections on loans receivable	`ProceedsFromCollectionOfLoansReceivable`	$341.65K	USD	1 Quarter
Net cash used in investing activities	`NetCashProvidedByUsedInInvestingActivities`	$-2.52M	USD	1 Quarter
Net cash used in investing activities	`NetCashProvidedByUsedInInvestingActivities`	$-1.28M	USD	1 Quarter
Dividends paid to common shareholders	`PaymentsOfDividendsCommonStock`	$1.11M	USD	1 Quarter
Dividends paid to common shareholders	`PaymentsOfDividendsCommonStock`	$1.27M	USD	1 Quarter
Dividends paid to preferred shareholders	`PaymentsOfDividendsPreferredStockAndPreferenceStock`	$2.85K	USD	1 Quarter
Dividends paid to preferred shareholders	`PaymentsOfDividendsPreferredStockAndPreferenceStock`	$2.64K	USD	1 Quarter
Issuance (repayment) of note payable to related party	`ProceedsFromRepaymentsOfRelatedPartyDebt`	$-392.00K	USD	1 Quarter
Issuance (repayment) of note payable to related party	`ProceedsFromRepaymentsOfRelatedPartyDebt`	$392.00K	USD	1 Quarter
Net cash used in financing activities	`NetCashProvidedByUsedInFinancingActivities`	$-725.11K	USD	1 Quarter
Net cash used in financing activities	`NetCashProvidedByUsedInFinancingActivities`	$-1.66M	USD	1 Quarter
Net increase (decrease) in cash and cash equivalents	`CashAndCashEquivalentsPeriodIncreaseDecrease`	$-3.50M	USD	1 Quarter
Net increase (decrease) in cash and cash equivalents	`CashAndCashEquivalentsPeriodIncreaseDecrease`	$-2.72M	USD	1 Quarter
Cash and cash equivalents at beginning of period	`CashAndCashEquivalentsAtCarryingValue`	$47.18M	USD	Point-in-time
Cash and cash equivalents at beginning of period	`CashAndCashEquivalentsAtCarryingValue`	$36.53M	USD	Point-in-time
Cash and cash equivalents at beginning of period	`CashAndCashEquivalentsAtCarryingValue`	$43.68M	USD	Point-in-time
Cash and cash equivalents at beginning of period	`CashAndCashEquivalentsAtCarryingValue`	$39.25M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashAndCashEquivalentsAtCarryingValue`	$47.18M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashAndCashEquivalentsAtCarryingValue`	$36.53M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashAndCashEquivalentsAtCarryingValue`	$43.68M	USD	Point-in-time
Cash and cash equivalents at end of period	`CashAndCashEquivalentsAtCarryingValue`	$39.25M	USD	Point-in-time
Interest paid in cash	`InterestPaid`	$4.43K	USD	1 Quarter
Interest paid in cash	`InterestPaid`	-	USD	1 Quarter
Issuance of 39,986 and 17,833, respectively, shares of common stock for services rendered	`StockIssuedDuringPeriodValueIssuedForServices`	$203.55K	USD	1 Quarter
Issuance of 39,986 and 17,833, respectively, shares of common stock for services rendered	`StockIssuedDuringPeriodValueIssuedForServices`	$441.16K	USD	1 Quarter
Conversion (on a one-to-one basis) of 454 and 0, respectively, shares of redeemable preferred stock to common stock	`ConversionOfStockAmountConverted1`	$272.00	USD	1 Quarter
Conversion (on a one-to-one basis) of 454 and 0, respectively, shares of redeemable preferred stock to common stock	`ConversionOfStockAmountConverted1`	-	USD	1 Quarter
Dividends declared but not paid	`Dividends`	$1.12M	USD	1 Quarter
Dividends declared but not paid	`Dividends`	$1.27M	USD	1 Quarter
Transfers from inventory to property, plant and equipment and construction in progress	`TransfersFromInventoryToPropertyPlantAndEquipmentAndConstructionInProgress`	$70.55K	USD	1 Quarter
Transfers from inventory to property, plant and equipment and construction in progress	`TransfersFromInventoryToPropertyPlantAndEquipmentAndConstructionInProgress`	$89.72K	USD	1 Quarter
Transfers from construction in progress to property, plant and equipment	`TransfersFromConstructionInProgressToPropertyPlantAndEquipment`	$140.50K	USD	1 Quarter
Transfers from construction in progress to property, plant and equipment	`TransfersFromConstructionInProgressToPropertyPlantAndEquipment`	$243.69K	USD	1 Quarter
Transfers from other assets to construction in progress	`TransfersFromOtherAssetsToConstructionInProgress`	$765.66K	USD	1 Quarter
Transfers from other assets to construction in progress	`TransfersFromOtherAssetsToConstructionInProgress`	-	USD	1 Quarter

Data is extracted from SEC EDGAR XBRL filings. Values shown are as reported in the filing.