GURUFOCUS.COM » STOCK LIST » Consumer Cyclical » Retail - Cyclical » HORNBACH Holding AG and Co KGaA (WBO:HBH) » Definitions » Beneish M-Score
中文

HORNBACH Holding AG and Co KGaA (WBO:HBH) Beneish M-Score

: -2.73 (As of Today)
View and export this data going back to 2017. Start your Free Trial

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.73 no higher than -1.78, which implies that the company is unlikely to be a manipulator.

The historical rank and industry rank for HORNBACH Holding AG and Co KGaA's Beneish M-Score or its related term are showing as below:

WBO:HBH' s Beneish M-Score Range Over the Past 10 Years
Min: -3.34   Med: -2.59   Max: -2.06
Current: -2.73

During the past 13 years, the highest Beneish M-Score of HORNBACH Holding AG and Co KGaA was -2.06. The lowest was -3.34. And the median was -2.59.


HORNBACH Holding AG and Co KGaA Beneish M-Score Historical Data

The historical data trend for HORNBACH Holding AG and Co KGaA'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.

HORNBACH Holding AG and Co KGaA Annual Data
Trend Feb14 Feb15 Feb16 Feb17 Feb18 Feb19 Feb20 Feb21 Feb22 Feb23
Beneish M-Score
Get a 7-Day Free Trial Premium Member Only Premium Member Only -2.45 -2.81 -2.49 -2.62 -2.58

HORNBACH Holding AG and Co KGaA Quarterly Data
Feb19 May19 Aug19 Nov19 Feb20 May20 Aug20 Nov20 Feb21 May21 Aug21 Nov21 Feb22 May22 Aug22 Nov22 Feb23 May23 Aug23 Nov23
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 -2.27 -2.58 -2.54 -2.70 -2.73

Competitive Comparison

For the Home Improvement Retail subindustry, HORNBACH Holding AG and Co KGaA'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.


HORNBACH Holding AG and Co KGaA Beneish M-Score Distribution

For the Retail - Cyclical industry and Consumer Cyclical sector, HORNBACH Holding AG and Co KGaA's Beneish M-Score distribution charts can be found below:

* The bar in red indicates where HORNBACH Holding AG and Co KGaA's Beneish M-Score falls into.



HORNBACH Holding AG and Co KGaA 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 HORNBACH Holding AG and Co KGaA 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.9813+0.528 * 1.0047+0.404 * 1.2112+0.892 * 0.9982+0.115 * 0.8247
-0.172 * SGAI+4.679 * TATA-0.327 * LVGI
-0.172 * 1.0484+4.679 * -0.064113-0.327 * 0.9591
=-2.73

* 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 (Nov23) TTM:Last Year (Nov22) TTM:
Total Receivables was €62 Mil.
Revenue was 1485.2 + 1667.9 + 1773.5 + 1253.433 = €6,180 Mil.
Gross Profit was 495.8 + 551.2 + 596 + 422.89 = €2,066 Mil.
Total Current Assets was €1,724 Mil.
Total Assets was €4,407 Mil.
Property, Plant and Equipment(Net PPE) was €2,582 Mil.
Depreciation, Depletion and Amortization(DDA) was €278 Mil.
Selling, General, & Admin. Expense(SGA) was €1,892 Mil.
Total Current Liabilities was €966 Mil.
Long-Term Debt & Capital Lease Obligation was €1,364 Mil.
Net Income was 28 + 58.9 + 66.3 + -52.026 = €101 Mil.
Non Operating Income was 0 + 0 + 0 + 0 = €0 Mil.
Cash Flow from Operations was 114.3 + 92 + 30.6 + 146.846 = €384 Mil.
Total Receivables was €63 Mil.
Revenue was 1546.3 + 1649.9 + 1813.4 + 1181.757 = €6,191 Mil.
Gross Profit was 500.5 + 547 + 620.1 + 411.899 = €2,079 Mil.
Total Current Assets was €1,851 Mil.
Total Assets was €4,533 Mil.
Property, Plant and Equipment(Net PPE) was €2,595 Mil.
Depreciation, Depletion and Amortization(DDA) was €226 Mil.
Selling, General, & Admin. Expense(SGA) was €1,808 Mil.
Total Current Liabilities was €1,023 Mil.
Long-Term Debt & Capital Lease Obligation was €1,476 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)
=(62.1 / 6180.033) / (63.4 / 6191.357)
=0.010048 / 0.01024
=0.9813

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)
=(2079.499 / 6191.357) / (2065.89 / 6180.033)
=0.335871 / 0.334285
=1.0047

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 - (1723.5 + 2581.8) / 4407.4) / (1 - (1851.2 + 2595.1) / 4533)
=0.023166 / 0.019126
=1.2112

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
=6180.033 / 6191.357
=0.9982

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))
=(226.155 / (226.155 + 2595.1)) / (277.986 / (277.986 + 2581.8))
=0.080161 / 0.097205
=0.8247

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)
=(1891.617 / 6180.033) / (1807.577 / 6191.357)
=0.306085 / 0.291952
=1.0484

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)
=((1364.3 + 965.5) / 4407.4) / ((1475.9 + 1022.5) / 4533)
=0.528611 / 0.551158
=0.9591

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
=(101.174 - 0 - 383.746) / 4407.4
=-0.064113

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.

HORNBACH Holding AG and Co KGaA has a M-score of -2.73 suggests that the company is unlikely to be a manipulator.


HORNBACH Holding AG and Co KGaA Beneish M-Score Related Terms

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


HORNBACH Holding AG and Co KGaA (WBO:HBH) Business Description

Traded in Other Exchanges
Address
Le Quartier Hornbach 19, Neustadt an der Weinstrasse, DEU, 67433
HORNBACH Holding AG and Co KGaA and its subsidiaries are involved in the business of Retail and Real estate segments. The company's operating segment include HORNBACH Baumarkt subgroup; HORNBACH Baustoff Union GmbH subgroup and HORNBACH Immobilien AG subgroup. It generates maximum revenue from the HORNBACH Baumarkt subgroup segment. Geographically, it derives a majority of revenue from Germany. Products are structured in the following divisions: Hardware/Electrical, Paint/Wallpaper/Flooring, Construction Materials/Timber/Prefabricated Components, Sanitary/Tiles, and Garden.

HORNBACH Holding AG and Co KGaA (WBO:HBH) Headlines

No Headlines