Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Consolidated Water Co. Ltd. logo

Consolidated Water Co. Ltd.

Sector: Utilities   

Industry: Utilities - Regulated Water

28.06
 
USD
  
-0.60
  
(-2.09%)
Optionable: Yes  Market Cap: 457 M  90-day average vol: 124,890

Previous close: 28.66  Open: 28.44  Bid: 26.37  Ask: 28.66
52 week range    
19.07   
   38.29
Last updated: Friday 19th July 2024

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

CWCO Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AccruedPreferredStockDividends-11485.0-12028.0-11563.0-11418.0-12356.0-11937.011740.010796.011532.015513.0
Basic EPS from continuing operations0.430.510.270.750.680.570.560.230.541.95
Basic EPS total0.430.510.270.820.750.810.240.060.381.88
Basic weighted shares outstanding15 M15 M15 M15 M15 M15 M15 M15 M15 M16 M
BasicDiscontinuousOperations0.070.070.24-0.32-0.17-0.16-0.07
Cost of sales-3 M-2 M-751139.0-469797.0-39 M-41 M46 M43 M64 M118 M
Depreciation-5 M-6 M-6 M-6 M-6 M-6 M6 M6 M5 M6 M
Depreciation unreconciled-6 M-6 M-7 M-7 M-7 M-7 M7 M7 M6 M6 M
Diluted EPS total0.420.510.270.820.750.80.240.060.381.86
Diluted normalized net income/share0.420.510.270.750.680.560.560.230.541.93
Diluted weighted shares outstanding15 M15 M15 M15 M15 M15 M15 M15 M15 M16 M
DilutedDiscontinuousOperations0.070.070.24-0.32-0.17-0.16-0.07
Dividends paid per share0.30.30.30.310.340.340.340.340.340.36
Earnings from equity interest303380.0294368.0337809.0127802.02 M44765.0371019.055984.075900.0123153.0
EarningsFromEquityInterestNetOfTax303380.0294368.0337809.0127802.02 M44765.0371019.055984.075900.0123153.0
GainOnSaleOfBusiness56000.0
GainOnSaleOfPPE-256000.0
GainOnSaleOfSecurity818000.0-128000.0
GainsLossOnDisposalOfDiscontinuedOperations1 M1 M4 M
GeneralAndAdministrativeExpense17 M15 M19 M19 M19 M17 M18 M18 M21 M25 M
Gross operating profit23 M23 M24 M24 M27 M28 M27 M24 M30 M62 M
ImpairmentOfCapitalAssets860000.01 M4 M3 M56774.0-445041.0-13997.03 M12704.07112.0
Income before tax7 M8 M2 M4 M11 M13 M9 M4 M10 M38 M
Income restructuring and M&A-8 M-4 M
Income taxes-536057.0-888977.0-157291.066621.086724.0-447982.0396739.07 M
Interest income-297000.0960000.0
InterestExpenseNonOperating488770.0269090.0104048.05722.08427.01332.09669.010248.046545.0145284.0
InterestIncomeOperating-26000.0
MinorityInterests411489.0-695787.0-2 M-730005.0-632915.0-1 M-573791.0
MiscOtherSpecialCharges-91760.0-521100.0482062.063715.0543014.098610.0207500.075050.0116269.0154036.0
Net income from total operations49 M41 M38 M41 M50 M53 M4 M875579.06 M30 M
NetIncomeCommonStockholders49 M41 M38 M41 M50 M53 M4 M864783.06 M30 M
NetIncomeContinuousOperations49 M41 M38 M41 M50 M53 M4 M875579.06 M30 M
NetIncomeDiscontinuousOperations1 M1 M1 M-5 M-3 M-2 M-1 M
NetIncomeExtraordinary-499182.0-406793.01 M411489.0
NetNonOperatingInterestIncomeExpense951861.0744162.0505702.0374841.0654770.0587177.0530427.0674561.0400641.0551124.0
NetOperatingInterestIncomeExpense-26000.0
NonRecurringOperationExpense-138000.0-203000.0
Normalized income6 M30 M
Operating income49 M42 M39 M41 M47 M52 M8 M2 M9 M37 M
Operating income before depreciation (EBITDA)13 M14 M10 M11 M18 M20 M17 M11 M16 M45 M
OperatingExpense17 M15 M19 M19 M19 M17 M18 M18 M21 M25 M
Other income net-211620.0226732.0-819871.0-191517.0-2 M-143375.0-578519.0-949034.0-64169.0-277189.0
OtherCostofRevenue3 M5 M5 M
OtherGainLossFromDispositionOfDiscontinuedOperations1 M-2 M-5 M
OtherGandA17 M15 M19 M19 M19 M17 M18 M18 M21 M25 M
OtherOperatingExpenses-42553.0-5 M-5 M5 M6 M6 M6 M
OtherunderPreferredStockDividend-11485.0-12028.0-11563.0-11418.0-12356.0-11937.011740.010796.011532.015513.0
PreferredStockDividends-11485.0-12028.0-11563.0-11418.0-12356.0-11937.011740.010796.011532.015513.0
RestructringAndMnAIncome-8 M-4 M
Revenue per share-168588.0-156089.0-1 M-1 M-1 M-841667.0891667.0746667.0582778.0574093.0
SalariesAndWages-202454.0-407668.0-521019.0-803577.0-850136.0-1 M1 M977232.01 M2 M
Selling Gen & administrative expense17 M15 M19 M19 M19 M17 M18 M18 M21 M25 M
Special income/charges860000.01 M4 M3 M56774.0-445041.0-13997.03 M12704.07112.0
Total Income available for interest expense (EBIT)7 M8 M2 M4 M11 M13 M9 M4 M10 M38 M
Total common shares outstanding15 M15 M15 M15 M15 M15 M15 M15 M16 M16 M
Total net income49 M41 M38 M41 M50 M53 M4 M875579.06 M30 M
Total ordinary shares16 M16 M16 M16 M16 M16 M16 M16 M16 M16 M
Total revenues66 M57 M58 M59 M66 M69 M73 M67 M94 M180 M
TotalExpenses14 M13 M18 M18 M-20 M-24 M64 M62 M85 M143 M
TotalRevenue66 M57 M58 M59 M66 M69 M73 M67 M94 M180 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University