GURUFOCUS.COM » STOCK LIST » Utilities » Utilities - Regulated » Consolidated Water Co Ltd (NAS:CWCO) » Definitions » Beneish M-Score

CWCO (Consolidated Water Co) Beneish M-Score : -2.84 (As of Dec. 14, 2024)


View and export this data going back to 1995. Start your Free Trial

What is Consolidated Water Co Beneish M-Score?

The zones of discrimination for M-Score is as such:

An M-Score of equal or less than -1.78 suggests that the company is unlikely to be a manipulator.
An M-Score of greater than -1.78 signals that the company is likely to be a manipulator.

Good Sign:

Beneish M-Score -2.84 no higher than -1.78, which implies that the company is unlikely to be a manipulator.

The historical rank and industry rank for Consolidated Water Co's Beneish M-Score or its related term are showing as below:

CWCO' s Beneish M-Score Range Over the Past 10 Years
Min: -3.12   Med: -2.63   Max: -1.12
Current: -2.84

During the past 13 years, the highest Beneish M-Score of Consolidated Water Co was -1.12. The lowest was -3.12. And the median was -2.63.


Consolidated Water Co Beneish M-Score Historical Data

The historical data trend for Consolidated Water Co's Beneish M-Score can be seen below:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* Premium members only.

Consolidated Water Co Beneish M-Score Chart

Consolidated Water Co Annual Data
Trend Dec14 Dec15 Dec16 Dec17 Dec18 Dec19 Dec20 Dec21 Dec22 Dec23
Beneish M-Score
Get a 7-Day Free Trial Premium Member Only Premium Member Only -2.53 -2.88 -2.41 -3.07 -1.12

Consolidated Water Co Quarterly Data
Dec19 Mar20 Jun20 Sep20 Dec20 Mar21 Jun21 Sep21 Dec21 Mar22 Jun22 Sep22 Dec22 Mar23 Jun23 Sep23 Dec23 Mar24 Jun24 Sep24
Beneish M-Score Get a 7-Day Free Trial Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only -1.69 -1.12 -1.26 -2.24 -2.84

Competitive Comparison of Consolidated Water Co's Beneish M-Score

For the Utilities - Regulated Water subindustry, Consolidated Water Co's Beneish M-Score, along with its competitors' market caps and Beneish M-Score data, can be viewed below:

* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap. Note that "N/A" values will not show up in the chart.


Consolidated Water Co's Beneish M-Score Distribution in the Utilities - Regulated Industry

For the Utilities - Regulated industry and Utilities sector, Consolidated Water Co's Beneish M-Score distribution charts can be found below:

* The bar in red indicates where Consolidated Water Co's Beneish M-Score falls into.



Consolidated Water Co Beneish M-Score Calculation

The M-score was created by Professor Messod Beneish. Instead of measuring the bankruptcy risk (Altman Z-Score) or business trend (Piotroski F-Score), M-score can be used to detect the risk of earnings manipulation. This is the original research paper on M-score.

The M-Score Variables:

The M-score of Consolidated Water Co for today is based on a combination of the following eight different indices:

M=-4.84+0.92 * DSRI+0.528 * GMI+0.404 * AQI+0.892 * SGI+0.115 * DEPI
=-4.84+0.92 * 0.8137+0.528 * 0.9333+0.404 * 0.5086+0.892 * 1.022+0.115 * 0.7561
-0.172 * SGAI+4.679 * TATA-0.327 * LVGI
-0.172 * 1.1107+4.679 * -0.003184-0.327 * 0.7258
=-2.84

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

This Year (Sep24) TTM:Last Year (Sep23) TTM:
Total Receivables was $39.2 Mil.
Revenue was 33.391 + 32.479 + 39.689 + 53.251 = $158.8 Mil.
Gross Profit was 11.635 + 11.62 + 13.878 + 19.29 = $56.4 Mil.
Total Current Assets was $153.9 Mil.
Total Assets was $238.4 Mil.
Property, Plant and Equipment(Net PPE) was $59.3 Mil.
Depreciation, Depletion and Amortization(DDA) was $6.7 Mil.
Selling, General, & Admin. Expense(SGA) was $24.9 Mil.
Total Current Liabilities was $20.1 Mil.
Long-Term Debt & Capital Lease Obligation was $2.9 Mil.
Net Income was 4.454 + 15.85 + 6.474 + 9.843 = $36.6 Mil.
Non Operating Income was 0.332 + 0.068 + 0.118 + 0.029 = $0.5 Mil.
Cash Flow from Operations was 10.352 + 20.956 + 5.95 + -0.425 = $36.8 Mil.
Total Receivables was $47.1 Mil.
Revenue was 49.854 + 44.237 + 32.869 + 28.428 = $155.4 Mil.
Gross Profit was 16.614 + 15.464 + 10.559 + 8.89 = $51.5 Mil.
Total Current Assets was $109.6 Mil.
Total Assets was $211.6 Mil.
Property, Plant and Equipment(Net PPE) was $58.2 Mil.
Depreciation, Depletion and Amortization(DDA) was $4.9 Mil.
Selling, General, & Admin. Expense(SGA) was $21.9 Mil.
Total Current Liabilities was $26.5 Mil.
Long-Term Debt & Capital Lease Obligation was $1.6 Mil.




1. DSRI = Days Sales in Receivables Index

Measured as the ratio of Revenue in Total Receivables in year t to year t-1.

A large increase in DSR could be indicative of revenue inflation.

DSRI=(Receivables_t / Revenue_t) / (Receivables_t-1 / Revenue_t-1)
=(39.158 / 158.81) / (47.088 / 155.388)
=0.246571 / 0.303035
=0.8137

2. GMI = Gross Margin Index

Measured as the ratio of gross margin in year t-1 to gross margin in year t.

Gross margin has deteriorated when this index is above 1. A firm with poorer prospects is more likely to manipulate earnings.

GMI=GrossMargin_t-1 / GrossMargin_t
=(GrossProfit_t-1 / Revenue_t-1) / (GrossProfit_t / Revenue_t)
=(51.527 / 155.388) / (56.423 / 158.81)
=0.331602 / 0.355286
=0.9333

3. AQI = Asset Quality Index

AQI is the ratio of asset quality in year t to year t-1.

Asset quality is measured as the ratio of non-current assets other than Property, Plant and Equipment to Total Assets.

AQI=(1 - (CurrentAssets_t + PPE_t) / TotalAssets_t) / (1 - (CurrentAssets_t-1 + PPE_t-1) / TotalAssets_t-1)
=(1 - (153.947 + 59.331) / 238.368) / (1 - (109.577 + 58.23) / 211.597)
=0.105257 / 0.20695
=0.5086

4. SGI = Sales Growth Index

Ratio of Revenue in year t to sales in year t-1.

Sales growth is not itself a measure of manipulation. However, growth companies are likely to find themselves under pressure to manipulate in order to keep up appearances.

SGI=Sales_t / Sales_t-1
=Revenue_t / Revenue_t-1
=158.81 / 155.388
=1.022

5. DEPI = Depreciation Index

Measured as the ratio of the rate of Depreciation, Depletion and Amortization in year t-1 to the corresponding rate in year t.

DEPI greater than 1 indicates that assets are being depreciated at a slower rate. This suggests that the firm might be revising useful asset life assumptions upwards, or adopting a new method that is income friendly.

DEPI=(Depreciation_t-1 / (Depreciaton_t-1 + PPE_t-1)) / (Depreciation_t / (Depreciaton_t + PPE_t))
=(4.863 / (4.863 + 58.23)) / (6.735 / (6.735 + 59.331))
=0.077077 / 0.101944
=0.7561

Note: If the Depreciation, Depletion and Amortization data is not available, we assume that the depreciation rate is constant and set the Depreciation Index to 1.

6. SGAI = Sales, General and Administrative expenses Index

The ratio of Selling, General, & Admin. Expense(SGA) to Sales in year t relative to year t-1.

SGA expenses index > 1 means that the company is becoming less efficient in generate sales.

SGAI=(SGA_t / Sales_t) / (SGA_t-1 /Sales_t-1)
=(24.892 / 158.81) / (21.928 / 155.388)
=0.156741 / 0.141118
=1.1107

7. LVGI = Leverage Index

The ratio of total debt to Total Assets in year t relative to yeat t-1.

An LVGI > 1 indicates an increase in leverage

LVGI=((LTD_t + CurrentLiabilities_t) / TotalAssets_t) / ((LTD_t-1 + CurrentLiabilities_t-1) / TotalAssets_t-1)
=((2.876 + 20.087) / 238.368) / ((1.615 + 26.47) / 211.597)
=0.096334 / 0.132729
=0.7258

8. TATA = Total Accruals to Total Assets

Total accruals calculated as the change in working capital accounts other than cash less depreciation.

TATA=(IncomefromContinuingOperations_t - CashFlowsfromOperations_t) / TotalAssets_t
=(NetIncome_t - NonOperatingIncome_t - CashFlowsfromOperations_t) / TotalAssets_t
=(36.621 - 0.547 - 36.833) / 238.368
=-0.003184

An M-Score of equal or less than -1.78 suggests that the company is unlikely to be a manipulator. An M-Score of greater than -1.78 signals that the company is likely to be a manipulator.

Consolidated Water Co has a M-score of -2.84 suggests that the company is unlikely to be a manipulator.


Consolidated Water Co Beneish M-Score Related Terms

Thank you for viewing the detailed overview of Consolidated Water Co's Beneish M-Score provided by GuruFocus.com. Please click on the following links to see related term pages.


Consolidated Water Co Business Description

Traded in Other Exchanges
Address
West Bay Road, 4th Floor, Windward Three, P.O. Box 1114, Regatta Office Park, Grand Cayman, CYM, KY1-1102
Consolidated Water Co Ltd is a water utility company. It develops and operates seawater desalination plants and water distribution systems. The company's business segments are; The retail segment operates the water utility for the Seven Mile Beach and West Bay areas of Grand Cayman Island, The bulk segment supplies potable water to government utilities in Grand Cayman and The Bahamas under long-term contracts, The services segment designs, constructs and sells water infrastructure and provides management and operating services to third parties, and The manufacturing segment manufactures and services a wide range of custom and specialized water-related products applicable to commercial, municipal and industrial water production, supply and treatment.
Executives
Raymond Whittaker director REGATTA OFFICE PARK, WINDWARD THREE, 4TH FLOOR, WEST BAY ROAD, P.O. BOX 1114, GRAND CAYMAN E9 E9 KY11102
Clarence B. Flowers director REGATTA OFFICE PARK, WINDWARD THREE, 4TH FLOOR, WEST BAY ROAD, P.O. BOX 1114, GRAND CAYMAN E9 E9 KY11102
Wilmer F. Pergande director REGATTA OFFICE PARK, WINDWARD THREE, 4TH FLOOR, WEST BAY ROAD, P.O. BOX 1114, GRAND CAYMAN E9 E9 KY11102
Richard Finlay director REGATTA OFFICE PARK, WINDWARD THREE, 4TH FLOOR, WEST BAY ROAD, P.O. BOX 1114, GRAND CAYMAN E9 E9 KY11102
Todd Redding officer: VP OF PURCHASING & LOGISTICS REGATTA OFFICE PARK, WINDWARD THREE, 4TH FLOOR, WEST BAY ROAD, P.O. BOX 1114, GRAND CAYMAN E9 E9 KY11102
Robert B. Morrison officer: VP of Procurement & Logistics PO BOX 31017, GRAND CAYMAN E9 KY1-1205
Douglas R. Vizzini officer: VP of Finance REGATTA OFFICE PARK, WINDWARD THREE, 4TH FLOOR, WEST BAY ROAD, P.O. BOX 1114, GRAND CAYMAN E9 E9 KY11102
Armando Averhoff officer: VP of Information Technology REGATTA OFFICE PARK, WINDWARD THREE, 4TH FLOOR, WEST BAY ROAD, P.O. BOX 1114, GRAND CAYMAN E9 E9 KY11102
Brent Brodie officer: VP of Sales and Marketing REGATTA OFFICE PARK, WINDWARD THREE, 4TH FLOOR, WEST BAY ROAD, P.O. BOX 1114, GRAND CAYMAN E9 E9 KY11102
Ramjeet Jerrybandan officer: EXECUTIVE VP OF OPERATIONS REGATTA OFFICE PARK, WINDWARD THREE, 4TH FLOOR, WEST BAY ROAD, P.O. BOX 1114, GRAND CAYMAN E9 E9 KY11102
Frederick W. Mctaggart director, officer: President and CEO REGATTA OFFICE PARK, WINDWARD THREE, 4TH FLOOR, WEST BAY ROAD, P.O. BOX 1114, GRAND CAYMAN E9 E9 KY11102
John Tonner officer: Chief Commercial Officer 7256 NW 108TH WAY, PARKLAND FL 33706
David Sasnett officer: EVP & CFO REGATTA OFFICE PARK, WINDWARD THREE, 4TH FLOOR, WEST BAY ROAD, P.O. BOX 1114, GRAND CAYMAN E9 E9 KY11102
Leonard J Sokolow director REGATTA OFFICE PARK, WINDWARD THREE, 4TH FLOOR, WEST BAY ROAD, P.O. BOX 1114, GRAND CAYMAN E9 E9 KY11102
Carson K. Ebanks director REGATTA OFFICE PARK, WINDWARD THREE, 4TH FLOOR, WEST BAY ROAD, P.O. BOX 1114, GRAND CAYMAN E9 E9 KY11102