25 XP   0   0   10

Etablissementen Franz Colruyt NV
Buy, Hold or Sell?

Let's analyze Etablissementen Franz Colruyt NV together

I guess you are interested in Etablissementen Franz Colruyt NV. Buy, hold or sell? I don't know! However, I do recommend doing research before doing anything. I will help you with that.

I'm going to help you getting a better view of Etablissementen Franz Colruyt NV. At the end you don't have to ask anyone for trading advice. You can make your own decision, with more confidence, the odds in your favor, backed by data.

Get notifications about Etablissementen Franz Colruyt NV

I send you an email if I find something interesting about Etablissementen Franz Colruyt NV.

Quick analysis of Etablissementen Franz Colruyt NV (30 sec.)










What can you expect buying and holding a share of Etablissementen Franz Colruyt NV? (30 sec.)

How much money do you get?

How much money do you get?
‚ā¨7.83
When do you have the money?
1 year
How often do you get paid?
100.0%

What is your share worth?

Current worth
‚ā¨25.15
Expected worth in 1 year
‚ā¨47.30
How sure are you?
100.0%

+ What do you gain per year?

Total Gains per Share
‚ā¨29.33
Return On Investment
64.6%

For what price can you sell your share?

Current Price per Share
‚ā¨45.40
Expected price per share
‚ā¨39.38 - ‚ā¨47.56
How sure are you?
50%
3rd party ad coffee SUPPORTERis ad-free.

1. Valuation of Etablissementen Franz Colruyt NV (5 min.)




Live pricePrice per Share (EOD)

‚ā¨45.40

Intrinsic Value Per Share

‚ā¨41.06 - ‚ā¨130.26

Total Value Per Share

‚ā¨66.22 - ‚ā¨155.41

2. Growth of Etablissementen Franz Colruyt NV (5 min.)




Is Etablissementen Franz Colruyt NV growing?

Current yearPrevious yearGrowGrow %
How rich?$3.4b$2.7b$723.5m20.9%

How much money is Etablissementen Franz Colruyt NV making?

Current yearPrevious yearGrowGrow %
Making money$1.1b$218.8m$927.6m80.9%
Net Profit Margin9.7%2.0%--

How much money comes from the company's main activities?

3. Financial Health of Etablissementen Franz Colruyt NV (5 min.)




4. Comparing to competitors in the Grocery Stores industry (5 min.)




  Industry Rankings (Grocery Stores)  


Richest
#13 / 68

Most Revenue
#11 / 68
3rd party ad coffee SUPPORTERis ad-free.

What can you expect buying and holding a share of Etablissementen Franz Colruyt NV? (5 min.)

Welcome investor! Etablissementen Franz Colruyt NV's management wants to use your money to grow the business. In return you get a share of Etablissementen Franz Colruyt NV.

What can you expect buying and holding a share of Etablissementen Franz Colruyt NV?

First you should know what it really means to hold a share of Etablissementen Franz Colruyt NV. And how you can make/lose money.

Speculation

The Price per Share of Etablissementen Franz Colruyt NV is ‚ā¨45.40. The market price reflects what other people think it is worth; not what it's really worth. Your job is to find out if the market price is fair, overpriced, or underpriced. I will help you with that.

If you buy blind, there is a 50% chance of making or losing money by selling the stock in the future. However, we can look at a few things to determine the odds in our favor:

  • The fundamentals: the financial health trends of Etablissementen Franz Colruyt NV.
  • The technials: based on market psychology, we can make a calculated estimate of what the price will do in the future. We can do this through technical analysis. We can calculate the probabilities and the expected value (millionaire math). That's called speculation.
  • The book value: what is the market price compared to it's book value.

Investing

If you really want to invest in Etablissementen Franz Colruyt NV, you will have to let go of the thought of selling in the future. If you have to sell the share for less than you bought it, it can still be a good investment. Focus on what it means to hold the stock forever:

  • You own a part of the company. The equity of this part can grow or shrink. The current Book Value per Share is ‚ā¨25.15. Based on the TTM, the Book Value Change Per Share is ‚ā¨5.54 per quarter. Based on the YOY, the Book Value Change Per Share is ‚ā¨1.06 per quarter.
  • You may receive quarterly/yearly dividend in the form of additional shares.
  • You may receive quarterly/yearly dividend in the form of cash. Based on the TTM the Dividend per Share is ‚ā¨1.80 per quarter.
Based on historical numbers we can estimate the returns while holding a share of Etablissementen Franz Colruyt NV.

How much money are you going to get?

 MRQTTMYOY5Y10Y
 ‚ā¨% of Price per Share‚ā¨% of Price per Share‚ā¨% of Price per Share‚ā¨% of Price per Share‚ā¨% of Price per Share
Usd Eps9.0920.0%9.0920.0%1.713.8%3.998.8%3.387.4%
Usd Book Value Change Per Share6.0413.3%6.0413.3%1.162.5%1.994.4%1.373.0%
Usd Dividend Per Share1.964.3%1.964.3%1.192.6%1.543.4%1.383.0%
Usd Total Gains Per Share8.0017.6%8.0017.6%2.355.2%3.537.8%2.756.1%
Usd Price Per Share46.72-46.72-29.37-45.25-49.74-
Price to Earnings Ratio5.14-5.14-17.17-14.38-16.95-
Price-to-Total Gains Ratio5.84-5.84-12.50-16.66-28.39-
Price to Book Ratio1.70-1.70-1.37-2.14-2.82-
Price-to-Total Gains Ratio5.84-5.84-12.50-16.66-28.39-

When do you get the money?

Usd Investment
$.00
Usd Price Per Share49.5314
Number of shares20
Gains per QuarterTrailing 12 Months5 Year
Usd Dividend Per Share1.961.54
Usd Book Value Change Per Share6.041.99
Usd Total Gains Per Share8.003.53
Gains per Quarter (20 shares)159.9970.58
Gains per Year (20 shares)639.97282.33
YearsReturn on Investment (TTM)Return on Investment (5Y)
 DividendBook Value gainTotal gainsDividendBook Value gainTotal gains
Broker costs---10---10
1157483630123159272
23139671270246319554
347014501910369478836
4627193325504926371118
5783241631906157971400
6940290038307389561682
710973383447086111151964
812543866511098412752246
9141043505750110714342528
10156748336390123015942810

How sure are you?

Based on the past periods, how sure are you to get value out of your investment.

Linear %
 Trailing 12 Months3Y5 Year10 YearALLTIME
  % % % % %
Earnings Per Share1.00.00.0100.0%3.00.00.0100.0%5.00.00.0100.0%10.00.00.0100.0%23.00.00.0100.0%
Book Value Change Per Share1.00.00.0100.0%2.01.00.066.7%4.01.00.080.0%7.03.00.070.0%20.03.00.087.0%
Dividend per Share1.00.00.0100.0%3.00.00.0100.0%5.00.00.0100.0%10.00.00.0100.0%23.00.00.0100.0%
Total Gains per Share1.00.00.0100.0%3.00.00.0100.0%5.00.00.0100.0%10.00.00.0100.0%23.00.00.0100.0%
3rd party ad coffee SUPPORTERis ad-free.

Fundamentals of Etablissementen Franz Colruyt NV

About Etablissementen Franz Colruyt NV

Colruyt Group N.V., together with its subsidiaries, engages in the retail, wholesale, food service, and other activities in Belgium, France, Luxembourg, and internationally. It operates through three segments: Retail, Wholesale and Foodservice, and Other Activities. The company provides groceries, fresh products, dry products, and frozen and non-food products; and operates CNG, hydrogen filling, and charging stations. It also provides printing and document management solutions; and develops, constructs, operates, maintains, and finances wind energy projects. The company offers its products and services under the Bike Republic, Bio-Planet, Boni Selection, Collect&Go, Colruyt Group Academy, Colruyt Lowest Prices, Colruyt Prix Qualité, Cru, DATS 24, Dreambaby, Dreamland, Everyday, Graindor, Kangourou, Okay, Spar Colruyt Group, Xtra, Jims, Newpharma, The Fashion Society, Codifrance, Colex, Solucious, Spar For You, and Symeta Hybrid brands. It provides its products and services to wholesalers, commercial customers, and affiliated independent merchants, as well as schools, care homes, the hospitality sector, etc. The company was formerly known as Etn. Fr. Colruyt NV and changed its name to Colruyt Group N.V. in October 2023. The company was founded in 1928 and is headquartered in Halle, Belgium.

Fundamental data was last updated by Penke on 2024-07-07 23:24:06.

Financial Health

Profitability Details
 Compared to previous yearCompared to industry
The company is making a profit.
Using its assets, the company is efficient in making profit.
Using its investors money, the company is very efficient in making profit.
Operating Efficiency Details
 Compared to previous yearCompared to industry
The company is operating less efficient.
The company is less efficient in keeping operating costs low.
Liquidity Details
 Compared to previous yearCompared to industry
The company is just able to pay all its short-term debts.
The company is just not able to pay all its short-term debts with the most liquid assets.
Solvency Details
 Compared to previous yearCompared to industry
The company is able to pay all its debts by selling its assets.
The company is able to pay all its debts with equity.

Valuation

Valuation Details
 Compared to previous yearCompared to industry
Based on the equity, the company is underpriced.
Based on the earnings, the company is cheap.
Based on how much money comes from the company's main activities, the company is cheap.
3rd party ad coffee SUPPORTERis ad-free.

1.1. Profitability of Etablissementen Franz Colruyt NV.

1.1. Profitability
1.1.1. Net Profit Margin

Measures how much net profit¬†Etablissementen Franz Colruyt NV earns for each €1 of revenue.

  • Above 10% is considered healthy but always compare¬†Etablissementen Franz Colruyt NV to the¬†Grocery Stores industry mean.
  • A Net Profit Margin of 9.7%¬†means that¬†€0.10 for each €1¬†in revenue is generated as profit.

Let's take a look of the Net Profit Margin trends of Etablissementen Franz Colruyt NV:

  • The MRQ is 9.7%. The company is making a profit. +1
  • The TTM is 9.7%. The company is making a profit. +1
Trends
Current periodCompared to+/- 
MRQ9.7%TTM9.7%0.0%
TTM9.7%YOY2.0%+7.7%
TTM9.7%5Y4.7%+5.0%
5Y4.7%10Y4.3%+0.4%
Compared to industry (Grocery Stores)
PeriodCompanyIndustry (mean)+/- 
MRQ9.7%2.3%+7.4%
TTM9.7%2.3%+7.4%
YOY2.0%2.4%-0.4%
5Y4.7%2.5%+2.2%
10Y4.3%2.3%+2.0%
1.1.2. Return on Assets

Shows how efficient Etablissementen Franz Colruyt NV is using its assets to generate profit.

  • Above 5% is considered healthy¬†but always compare¬†Etablissementen Franz Colruyt NV to the¬†Grocery Stores industry mean.
  • 16.0% Return on Assets means that¬†Etablissementen Franz Colruyt NV generated¬†€0.16 profit for each $1 in assets.

Let's take a look of the Return on Assets trends of Etablissementen Franz Colruyt NV:

  • The MRQ is 16.0%. Using its assets, the company is efficient in making profit. +1
  • The TTM is 16.0%. Using its assets, the company is efficient in making profit. +1
Trends
Current periodCompared to+/- 
MRQ16.0%TTM16.0%0.0%
TTM16.0%YOY3.2%+12.8%
TTM16.0%5Y8.3%+7.7%
5Y8.3%10Y8.7%-0.4%
Compared to industry (Grocery Stores)
PeriodCompanyIndustry (mean)+/- 
MRQ16.0%1.1%+14.9%
TTM16.0%1.4%+14.6%
YOY3.2%1.3%+1.9%
5Y8.3%1.2%+7.1%
10Y8.7%1.2%+7.5%
1.1.3. Return on Equity

Shows how efficient Etablissementen Franz Colruyt NV is using its investors money to generate profit.

  • Above 15%-20% is considered healthy but always compare¬†Etablissementen Franz Colruyt NV to the¬†Grocery Stores industry mean.
  • 33.1% Return on Equity means Etablissementen Franz Colruyt NV generated €0.33¬†for each¬†€1 the owners (shareholders) invested.

Let's take a look of the Return on Equity trends of Etablissementen Franz Colruyt NV:

  • The MRQ is 33.1%. Using its investors money, the company is very efficient in making profit. +2
  • The TTM is 33.1%. Using its investors money, the company is very efficient in making profit. +2
Trends
Current periodCompared to+/- 
MRQ33.1%TTM33.1%0.0%
TTM33.1%YOY8.0%+25.1%
TTM33.1%5Y17.5%+15.6%
5Y17.5%10Y17.7%-0.2%
Compared to industry (Grocery Stores)
PeriodCompanyIndustry (mean)+/- 
MRQ33.1%3.6%+29.5%
TTM33.1%4.6%+28.5%
YOY8.0%4.2%+3.8%
5Y17.5%4.0%+13.5%
10Y17.7%3.4%+14.3%
3rd party ad coffee SUPPORTERis ad-free.

1.2. Operating Efficiency of Etablissementen Franz Colruyt NV.

1.2. Operating Efficiency
1.2.1. Operating Margin

Measures how efficient Etablissementen Franz Colruyt NV is operating .

  • Measures how much profit Etablissementen Franz Colruyt NV makes for each €1 of sales after paying variable costs (production costs, wages, etc) but before taxes.
  • Above 15% is considered healthy but always compare¬†Etablissementen Franz Colruyt NV to the¬†Grocery Stores industry mean.
  • An Operating Margin of 3.1%¬†means the company generated €0.03 ¬†for each €1 in revenue (before taxes).

Let's take a look of the Operating Margin trends of Etablissementen Franz Colruyt NV:

  • The MRQ is 3.1%. The company is operating less efficient.
  • The TTM is 3.1%. The company is operating less efficient.
Trends
Current periodCompared to+/- 
MRQ3.1%TTM3.1%0.0%
TTM3.1%YOY1.1%+2.0%
TTM3.1%5Y2.8%+0.3%
5Y2.8%10Y4.1%-1.3%
Compared to industry (Grocery Stores)
PeriodCompanyIndustry (mean)+/- 
MRQ3.1%2.9%+0.2%
TTM3.1%2.4%+0.7%
YOY1.1%3.4%-2.3%
5Y2.8%3.8%-1.0%
10Y4.1%3.4%+0.7%
1.2.2. Operating Ratio

Measures how efficient Etablissementen Franz Colruyt NV is keeping operating costs low.

  • Below 1 is considered healthy (always compare to¬†Grocery Stores industry mean).
  • An Operation Ratio of 0.97 means that the operating costs are €0.97 for each €1 in net sales.

Let's take a look of the Operating Ratio trends of Etablissementen Franz Colruyt NV:

  • The MRQ is 0.969. The company is less efficient in keeping operating costs low.
  • The TTM is 0.969. The company is less efficient in keeping operating costs low.
Trends
Current periodCompared to+/- 
MRQ0.969TTM0.9690.000
TTM0.969YOY0.989-0.020
TTM0.9695Y0.972-0.003
5Y0.97210Y0.959+0.014
Compared to industry (Grocery Stores)
PeriodCompanyIndustry (mean)+/- 
MRQ0.9691.395-0.426
TTM0.9691.221-0.252
YOY0.9890.988+0.001
5Y0.9721.109-0.137
10Y0.9591.033-0.074
3rd party ad coffee SUPPORTERis ad-free.

1.3. Liquidity of Etablissementen Franz Colruyt NV.

1.3. Liquidity
1.3.1. Current Ratio

Measures if Etablissementen Franz Colruyt NV is able to pay off Short-term Debt.

  • Above 1.5 is considered healthy (always compare to¬†Grocery Stores industry mean).
  • A Current Ratio of 1.03¬†means the company has €1.03 in assets for each €1 in short-term debts.

Let's take a look of the Current Ratio trends of Etablissementen Franz Colruyt NV:

  • The MRQ is 1.032. The company is just able to pay all its short-term debts.
  • The TTM is 1.032. The company is just able to pay all its short-term debts.
Trends
Current periodCompared to+/- 
MRQ1.032TTM1.0320.000
TTM1.032YOY0.778+0.254
TTM1.0325Y0.847+0.185
5Y0.84710Y0.860-0.013
Compared to industry (Grocery Stores)
PeriodCompanyIndustry (mean)+/- 
MRQ1.0320.883+0.149
TTM1.0320.920+0.112
YOY0.7780.890-0.112
5Y0.8470.896-0.049
10Y0.8600.859+0.001
1.3.2. Quick Ratio

Measures if Etablissementen Franz Colruyt NV is able to pay off Short-term Debt but only using the most liquid assets.

  • Above 1 is considered healthy but¬†always compare¬†Etablissementen Franz Colruyt NV to the¬†Grocery Stores industry mean.
  • A Quick Ratio of 0.80¬†means the company can pay off €0.80 for each €1 in debt (using most liquid assets).

Let's take a look of the Quick Ratio trends of Etablissementen Franz Colruyt NV:

  • The MRQ is 0.804. The company is just not able to pay all its short-term debts with the most liquid assets. -1
  • The TTM is 0.804. The company is just not able to pay all its short-term debts with the most liquid assets. -1
Trends
Current periodCompared to+/- 
MRQ0.804TTM0.8040.000
TTM0.804YOY0.403+0.401
TTM0.8045Y0.527+0.276
5Y0.52710Y0.511+0.016
Compared to industry (Grocery Stores)
PeriodCompanyIndustry (mean)+/- 
MRQ0.8040.276+0.528
TTM0.8040.329+0.475
YOY0.4030.381+0.022
5Y0.5270.397+0.130
10Y0.5110.392+0.119
3rd party ad coffee SUPPORTERis ad-free.

1.4. Solvency of Etablissementen Franz Colruyt NV.

1.3. Liquidity
1.4.1. Debt to Asset Ratio

Measures how much % of Etablissementen Franz Colruyt NV assets are financed with debt.

  • Below 1 (100%) is considered healthy but always compare¬†Etablissementen Franz Colruyt NV to Grocery Stores industry mean.
  • A Debt to Asset Ratio of 0.52¬†means that Etablissementen Franz Colruyt NV assets are¬†financed with 51.7% credit (debt) and the remaining percentage (100% - 51.7%)¬†is financed by its owners/shareholders.¬†

Let's take a look of the Debt to Asset Ratio trends of Etablissementen Franz Colruyt NV:

  • The MRQ is 0.517. The company is able to pay all its debts by selling its assets. +1
  • The TTM is 0.517. The company is able to pay all its debts by selling its assets. +1
Trends
Current periodCompared to+/- 
MRQ0.517TTM0.5170.000
TTM0.517YOY0.596-0.079
TTM0.5175Y0.538-0.021
5Y0.53810Y0.513+0.025
Compared to industry (Grocery Stores)
PeriodCompanyIndustry (mean)+/- 
MRQ0.5170.702-0.185
TTM0.5170.680-0.163
YOY0.5960.686-0.090
5Y0.5380.690-0.152
10Y0.5130.659-0.146
1.4.2. Debt to Equity Ratio

Measures if Etablissementen Franz Colruyt NV is able to pay off its debts by using shareholders equity.

  • Below 2 is considered healthy but¬†always compare¬†Etablissementen Franz Colruyt NV to the¬†Grocery Stores industry mean.
  • A Debt to Equity ratio of 107.1% means that company has €1.07 debt for each €1 in shareholders equity.

Let's take a look of the Debt to Equity Ratio trends of Etablissementen Franz Colruyt NV:

  • The MRQ is 1.071. The company is able to pay all its debts with equity. +1
  • The TTM is 1.071. The company is able to pay all its debts with equity. +1
Trends
Current periodCompared to+/- 
MRQ1.071TTM1.0710.000
TTM1.071YOY1.478-0.407
TTM1.0715Y1.183-0.112
5Y1.18310Y1.069+0.113
Compared to industry (Grocery Stores)
PeriodCompanyIndustry (mean)+/- 
MRQ1.0712.353-1.282
TTM1.0712.098-1.027
YOY1.4782.188-0.710
5Y1.1832.253-1.070
10Y1.0692.066-0.997
3rd party ad coffee SUPPORTERis ad-free.

2. Market Valuation of Etablissementen Franz Colruyt NV

2.1. Earnings Per Share
2.1. Price to Earnings Ratio

Measures¬†how much money you pay¬†for each share for¬†every €1 in earnings Etablissementen Franz Colruyt NV generates.

  • Above 15 is considered overpriced but¬†always compare¬†Etablissementen Franz Colruyt NV to the¬†Grocery Stores industry mean.
  • A PE ratio of 5.14 means the investor is paying €5.14¬†for every €1 in earnings.

Let's take a look of the Price to Earnings Ratio trends of Etablissementen Franz Colruyt NV:

  • The EOD is 5.450. Based on the earnings, the company is cheap. +2
  • The MRQ is 5.141. Based on the earnings, the company is cheap. +2
  • The TTM is 5.141. Based on the earnings, the company is cheap. +2
Trends
Current periodCompared to+/- 
EOD5.450MRQ5.141+0.310
MRQ5.141TTM5.1410.000
TTM5.141YOY17.173-12.032
TTM5.1415Y14.384-9.243
5Y14.38410Y16.952-2.568
Compared to industry (Grocery Stores)
PeriodCompanyIndustry (mean)+/- 
EOD5.45016.186-10.736
MRQ5.14114.835-9.694
TTM5.14114.951-9.810
YOY17.17313.495+3.678
5Y14.38414.825-0.441
10Y16.95221.089-4.137
2.2. Price To Free Cash Flow Ratio

Let's take a look of the Price To Free Cash Flow Ratio trends of Etablissementen Franz Colruyt NV:

  • The EOD is 5.339. Based on how much money comes from the company's main activities, the company is cheap. +2
  • The MRQ is 5.035. Based on how much money comes from the company's main activities, the company is cheap. +2
  • The TTM is 5.035. Based on how much money comes from the company's main activities, the company is cheap. +2
Trends
Current periodCompared to+/- 
EOD5.339MRQ5.035+0.303
MRQ5.035TTM5.0350.000
TTM5.035YOY14.253-9.217
TTM5.0355Y82.361-77.326
5Y82.36110Y62.108+20.253
Compared to industry (Grocery Stores)
PeriodCompanyIndustry (mean)+/- 
EOD5.3396.519-1.180
MRQ5.0356.836-1.801
TTM5.0355.411-0.376
YOY14.2535.437+8.816
5Y82.3614.625+77.736
10Y62.1083.888+58.220
3rd party ad coffee SUPPORTERis ad-free.
2. Book Value per Share
2.3. Price to Book Ratio

Measures if the stock price of Etablissementen Franz Colruyt NV is to cheap or to expensive compared to its book value.

  • At or below 1 is considered healthy¬†(always compare to Grocery Stores industry mean).
  • A PB ratio of 1.70 means the investor is paying €1.70¬†for each €1 in book value.

Let's take a look of the Price to Book Ratio trends of Etablissementen Franz Colruyt NV:

  • The EOD is 1.805. Based on the equity, the company is underpriced. +1
  • The MRQ is 1.702. Based on the equity, the company is underpriced. +1
  • The TTM is 1.702. Based on the equity, the company is underpriced. +1
Trends
Current periodCompared to+/- 
EOD1.805MRQ1.702+0.103
MRQ1.702TTM1.7020.000
TTM1.702YOY1.372+0.330
TTM1.7025Y2.138-0.436
5Y2.13810Y2.815-0.677
Compared to industry (Grocery Stores)
PeriodCompanyIndustry (mean)+/- 
EOD1.8052.165-0.360
MRQ1.7022.372-0.670
TTM1.7022.516-0.814
YOY1.3723.066-1.694
5Y2.1383.216-1.078
10Y2.8153.379-0.564
2. Total Gains per Share
3rd party ad coffee SUPPORTERis ad-free.

3. Summary

3.1. Key Performance Indicators

The key performance indicators of Etablissementen Franz Colruyt NV compared to the Most Recent Quarter (MRQ).

 End of day+/-Most Recent QuarterTrailing 12 Months+/-Year-Over-Year+/-5 Year+/-10 Year+/-
Book Value Change Per Share--5.5375.5370%1.060+422%1.826+203%1.258+340%
Book Value Per Share--25.15525.1550%19.617+28%19.833+27%17.000+48%
Current Ratio--1.0321.0320%0.778+33%0.847+22%0.860+20%
Debt To Asset Ratio--0.5170.5170%0.596-13%0.538-4%0.513+1%
Debt To Equity Ratio--1.0711.0710%1.478-28%1.183-9%1.069+0%
Dividend Per Share--1.7951.7950%1.093+64%1.409+27%1.265+42%
Eps--8.3308.3300%1.568+431%3.653+128%3.095+169%
Free Cash Flow Per Share--8.5048.5040%1.889+350%3.069+177%2.171+292%
Free Cash Flow To Equity Per Share--2.6482.6480%2.036+30%1.238+114%0.163+1529%
Gross Profit Margin--1.0001.0000%-2.049+305%-0.432+143%-1.154+215%
Intrinsic Value_10Y_max--130.257--------
Intrinsic Value_10Y_min--41.063--------
Intrinsic Value_1Y_max--5.572--------
Intrinsic Value_1Y_min--2.689--------
Intrinsic Value_3Y_max--22.443--------
Intrinsic Value_3Y_min--9.361--------
Intrinsic Value_5Y_max--46.187--------
Intrinsic Value_5Y_min--17.389--------
Market Cap5665420600.000+5%5402338711.8405402338711.8400%3444888895.720+57%5495611862.334-2%6333272413.329-15%
Net Profit Margin--0.0970.0970%0.020+380%0.047+106%0.043+123%
Operating Margin--0.0310.0310%0.011+190%0.028+11%0.041-24%
Operating Ratio--0.9690.9690%0.989-2%0.9720%0.959+1%
Pb Ratio1.805+6%1.7021.7020%1.372+24%2.138-20%2.815-40%
Pe Ratio5.450+6%5.1415.1410%17.173-70%14.384-64%16.952-70%
Price Per Share45.400+6%42.82042.8200%26.920+59%41.474+3%45.595-6%
Price To Free Cash Flow Ratio5.339+6%5.0355.0350%14.253-65%82.361-94%62.108-92%
Price To Total Gains Ratio6.192+6%5.8405.8400%12.500-53%16.657-65%28.391-79%
Quick Ratio--0.8040.8040%0.403+100%0.527+52%0.511+57%
Return On Assets--0.1600.1600%0.032+396%0.083+93%0.087+83%
Return On Equity--0.3310.3310%0.080+314%0.175+89%0.177+87%
Total Gains Per Share--7.3327.3320%2.154+240%3.235+127%2.523+191%
Usd Book Value--3462397600.0003462397600.0000%2738846400.000+26%2843735140.000+22%2538811549.891+36%
Usd Book Value Change Per Share--6.0416.0410%1.157+422%1.992+203%1.373+340%
Usd Book Value Per Share--27.44427.4440%21.403+28%21.638+27%18.547+48%
Usd Dividend Per Share--1.9591.9590%1.193+64%1.537+27%1.380+42%
Usd Eps--9.0889.0880%1.710+431%3.986+128%3.376+169%
Usd Free Cash Flow--1170533900.0001170533900.0000%263694700.000+344%434327100.000+170%317993770.000+268%
Usd Free Cash Flow Per Share--9.2789.2780%2.061+350%3.348+177%2.369+292%
Usd Free Cash Flow To Equity Per Share--2.8892.8890%2.222+30%1.350+114%0.177+1529%
Usd Market Cap6180973874.600+5%5893951534.6175893951534.6170%3758373785.231+57%5995712541.806-2%6909600202.942-15%
Usd Price Per Share49.531+6%46.71746.7170%29.370+59%45.248+3%49.744-6%
Usd Profit--1146531900.0001146531900.0000%218854600.000+424%520428820.000+120%460238350.000+149%
Usd Revenue--11831676800.00011831676800.0000%10837557600.000+9%10809889840.000+9%10429250850.000+13%
Usd Total Gains Per Share--8.0008.0000%2.350+240%3.529+127%2.753+191%
 EOD+4 -4MRQTTM+0 -0YOY+33 -35Y+32 -410Y+28 -8

3.2. Fundamental Score

Let's check the fundamental score of Etablissementen Franz Colruyt NV based on Penke's default stock scanner.

Penke's Stock Scanner

  
  
IndicatorConditionValue
Price to Earnings Ratio (EOD)Between0-155.450
Price to Book Ratio (EOD)Between0-11.805
Net Profit Margin (MRQ)Greater than00.097
Operating Margin (MRQ)Greater than00.031
Quick Ratio (MRQ)Greater than10.804
Current Ratio (MRQ)Greater than11.032
Debt to Asset Ratio (MRQ)Less than10.517
Debt to Equity Ratio (MRQ)Less than11.071
Return on Equity (MRQ)Greater than0.150.331
Return on Assets (MRQ)Greater than0.050.160
Total7/10 (70.0%)

3.3. Technical Score

Let's check the technical score of Etablissementen Franz Colruyt NV based on Penke's default Symbol scanner.

Penke's Symbol Scanner

  
  
IndicatorConditionValue
RsiGreater than5056.191
Ma 20Greater thanMa 5044.549
Ma 50Greater thanMa 10044.724
Ma 100Greater thanMa 20043.410
OpenGreater thanClose45.260
Total3/5 (60.0%)



Reversals in quarterly reports

I have detected a reversal (positive to negative, negative to positive) in the following values of the quarterly reports.

 2020-03-312021-03-312022-03-312023-03-312024-03-31
Long-term Assets Other  -60,700-64,200-124,900-32,700-157,600-216,900-374,500770,700396,200



Latest Balance Sheet

Balance Sheet of 2024-03-31. All numbers in thousands.

Summary
Total Assets6,571,200
Total Liabilities3,397,600
Total Stockholder Equity3,173,600
 As reported
Total Liabilities 3,397,600
Total Stockholder Equity+ 3,173,600
Total Assets = 6,571,200

Assets

Total Assets6,571,200
Total Current Assets2,457,100
Long-term Assets4,114,100
Total Current Assets
Cash And Cash Equivalents 774,600
Short-term Investments 226,200
Net Receivables 686,000
Inventory 757,800
Other Current Assets 12,500
Total Current Assets  (as reported)2,457,100
Total Current Assets  (calculated)2,457,100
+/-0
Long-term Assets
Property Plant Equipment 2,951,200
Goodwill 415,300
Long-term Assets Other 396,200
Long-term Assets  (as reported)4,114,100
Long-term Assets  (calculated)3,762,700
+/- 351,400

Liabilities & Shareholders' Equity

Total Current Liabilities2,380,100
Long-term Liabilities1,017,500
Total Stockholder Equity3,173,600
Total Current Liabilities
Short-term Debt 211,900
Accounts payable 1,406,100
Other Current Liabilities 728,400
Total Current Liabilities  (as reported)2,380,100
Total Current Liabilities  (calculated)2,346,400
+/- 33,700
Long-term Liabilities
Long-term Liabilities  (as reported)1,017,500
Long-term Liabilities  (calculated)0
+/- 1,017,500
Total Stockholder Equity
Common Stock379,000
Retained Earnings 2,888,400
Accumulated Other Comprehensive Income -10,800
Other Stockholders Equity -83,000
Total Stockholder Equity (as reported)3,173,600
Total Stockholder Equity (calculated)3,173,600
+/-0
Other
Cash and Short Term Investments 1,000,800
Common Stock Shares Outstanding 126,164
Current Deferred Revenue33,700
Liabilities and Stockholders Equity 6,571,200
Net Debt 249,900
Short Long Term Debt Total 1,024,500



Balance Sheet

All numbers in thousands.

 Trend2024-03-312023-03-312022-03-312021-03-312020-03-312019-03-312018-03-312017-03-312016-03-312015-03-312014-03-312013-03-312012-03-312011-03-312010-03-312009-03-312008-03-312007-03-312006-03-312005-03-312004-03-312003-03-312002-03-312001-03-312000-03-31
> Total Assets 
42,496,718
48,844,832
1,246,794
1,376,860
1,530,565
1,641,400
1,716,400
1,961,000
2,184,700
2,362,100
2,632,400
3,017,300
3,167,000
3,443,300
3,721,800
3,661,200
4,019,200
4,094,800
4,054,100
4,146,900
4,645,400
5,258,800
5,690,500
6,220,300
6,571,200
6,571,2006,220,3005,690,5005,258,8004,645,4004,146,9004,054,1004,094,8004,019,2003,661,2003,721,8003,443,3003,167,0003,017,3002,632,4002,362,1002,184,7001,961,0001,716,4001,641,4001,530,5651,376,8601,246,79448,844,83242,496,718
   > Total Current Assets 
0
0
826,875
921,153
977,153
925,500
931,200
1,076,500
1,111,500
1,169,100
1,172,500
1,332,500
1,378,000
1,581,400
1,741,900
1,481,000
1,634,200
1,640,400
1,372,500
1,413,600
1,543,200
1,730,000
1,839,100
2,002,400
2,457,100
2,457,1002,002,4001,839,1001,730,0001,543,2001,413,6001,372,5001,640,4001,634,2001,481,0001,741,9001,581,4001,378,0001,332,5001,172,5001,169,1001,111,5001,076,500931,200925,500977,153921,153826,87500
       Cash And Cash Equivalents 
1,034,574
2,554,330
74,979
52,554
92,145
366,000
331,300
414,900
296,600
292,900
247,900
287,900
308,300
503,900
602,600
309,200
432,600
523,700
212,100
163,200
263,800
284,500
176,200
358,600
774,600
774,600358,600176,200284,500263,800163,200212,100523,700432,600309,200602,600503,900308,300287,900247,900292,900296,600414,900331,300366,00092,14552,55474,9792,554,3301,034,574
       Short-term Investments 
9,107,009
8,924,485
232,679
334,258
262,744
27,200
32,200
36,600
55,900
55,300
38,300
25,100
25,400
25,000
25,400
23,600
25,500
1,600
3,600
4,500
27,800
36,400
128,300
31,300
226,200
226,20031,300128,30036,40027,8004,5003,6001,60025,50023,60025,40025,00025,40025,10038,30055,30055,90036,60032,20027,200262,744334,258232,6798,924,4859,107,009
       Net Receivables 
3,618,177
4,238,454
156,234
126,813
199,528
188,000
206,500
232,500
320,900
339,700
379,700
465,500
493,000
470,300
491,700
479,500
491,000
442,700
497,300
535,500
589,000
633,300
682,100
615,600
686,000
686,000615,600682,100633,300589,000535,500497,300442,700491,000479,500491,700470,300493,000465,500379,700339,700320,900232,500206,500188,000199,528126,813156,2344,238,4543,618,177
       Other Current Assets 
4,579,658
6,846,756
328,263
462,336
319,255
215,200
238,700
240,400
100
348,600
390,900
481,300
-100
514,200
72,900
89,600
69,900
72,100
67,000
79,700
33,200
37,900
36,900
170,400
12,500
12,500170,40036,90037,90033,20079,70067,00072,10069,90089,60072,900514,200-100481,300390,900348,600100240,400238,700215,200319,255462,336328,2636,846,7564,579,658
   > Long-term Assets 
0
0
419,919
455,707
553,412
715,900
785,200
884,500
1,073,200
1,193,000
1,459,900
1,684,800
1,789,000
1,861,900
1,950,000
2,135,100
2,333,200
2,397,000
2,615,900
2,668,700
3,102,200
3,528,800
3,851,400
4,217,900
4,114,100
4,114,1004,217,9003,851,4003,528,8003,102,2002,668,7002,615,9002,397,0002,333,2002,135,1001,950,0001,861,9001,789,0001,684,8001,459,9001,193,0001,073,200884,500785,200715,900553,412455,707419,91900
       Property Plant Equipment 
14,112,712
14,902,588
773,719
832,439
962,768
635,300
702,000
802,000
936,900
1,043,700
1,243,900
1,395,600
1,501,800
1,535,100
1,647,700
1,802,700
1,965,100
2,037,000
2,131,800
2,199,100
2,391,600
2,576,600
2,745,000
2,820,800
2,951,200
2,951,2002,820,8002,745,0002,576,6002,391,6002,199,1002,131,8002,037,0001,965,1001,802,7001,647,7001,535,1001,501,8001,395,6001,243,9001,043,700936,900802,000702,000635,300962,768832,439773,71914,902,58814,112,712
       Goodwill 
326,151
557,822
12,696
13,361
22,893
44,300
48,800
46,700
64,300
72,600
83,800
95,200
95,000
89,600
89,300
89,300
89,300
57,400
58,100
55,400
60,700
124,900
157,600
374,500
415,300
415,300374,500157,600124,90060,70055,40058,10057,40089,30089,30089,30089,60095,00095,20083,80072,60064,30046,70048,80044,30022,89313,36112,696557,822326,151
       Long Term Investments 
0
0
0
0
0
0
0
0
0
0
0
0
0
0
160,100
183,600
213,500
222,800
302,400
263,100
0
0
0
0
0
00000263,100302,400222,800213,500183,600160,10000000000000000
       Intangible Assets 
378,705
607,149
2,671
3,948
9,191
3,000
3,700
6,500
7,000
9,500
22,500
81,600
88,300
51,600
52,900
59,500
65,300
79,800
123,600
151,100
264,000
402,000
487,000
714,500
0
0714,500487,000402,000264,000151,100123,60079,80065,30059,50052,90051,60088,30081,60022,5009,5007,0006,5003,7003,0009,1913,9482,671607,149378,705
       Long-term Assets Other 
0
0
-602,817
-394,040
-441,440
27,200
35,900
40,900
55,800
65,500
55,900
46,100
45,200
45,300
-3,300
-3,200
-32,300
-59,800
-72,300
-62,200
-60,700
-124,900
-157,600
-374,500
396,200
396,200-374,500-157,600-124,900-60,700-62,200-72,300-59,800-32,300-3,200-3,30045,30045,20046,10055,90065,50055,80040,90035,90027,200-441,440-394,040-602,81700
> Total Liabilities 
25,002,450
28,497,636
766,002
810,423
983,908
878,200
945,100
1,041,700
1,213,600
1,263,300
1,380,100
1,528,500
1,549,700
1,650,400
1,754,900
1,860,500
1,971,500
1,954,600
2,012,600
1,939,200
2,286,000
2,731,600
3,228,400
3,709,900
3,397,600
3,397,6003,709,9003,228,4002,731,6002,286,0001,939,2002,012,6001,954,6001,971,5001,860,5001,754,9001,650,4001,549,7001,528,5001,380,1001,263,3001,213,6001,041,700945,100878,200983,908810,423766,00228,497,63625,002,450
   > Total Current Liabilities 
21,133,389
24,162,349
665,635
710,981
908,697
791,300
853,600
937,700
1,090,600
1,136,400
1,240,600
1,376,400
1,392,100
1,496,700
1,597,600
1,674,500
1,780,600
1,700,600
1,779,600
1,712,100
1,853,300
2,191,900
2,286,600
2,573,600
2,380,100
2,380,1002,573,6002,286,6002,191,9001,853,3001,712,1001,779,6001,700,6001,780,6001,674,5001,597,6001,496,7001,392,1001,376,4001,240,6001,136,4001,090,600937,700853,600791,300908,697710,981665,63524,162,34921,133,389
       Short-term Debt 
0
0
0
0
3,733
4,000
3,300
2,400
0
0
0
3,600
5,000
3,100
3,700
5,100
4,700
11,600
128,600
41,000
28,500
231,700
350,000
479,500
211,900
211,900479,500350,000231,70028,50041,000128,60011,6004,7005,1003,7003,1005,0003,6000002,4003,3004,0003,7330000
       Short Long Term Debt 
0
0
0
0
0
0
0
0
0
0
0
0
0
0
32,100
1,500
1,300
8,900
125,900
33,500
2,000
190,500
299,100
419,000
0
0419,000299,100190,5002,00033,500125,9008,9001,3001,50032,10000000000000000
       Accounts payable 
11,826,369
14,646,451
395,675
409,954
498,072
503,700
565,800
638,100
754,900
768,500
834,200
918,000
868,200
952,000
1,046,700
1,062,300
1,123,500
1,059,500
1,074,600
1,101,500
1,237,300
1,319,300
1,283,600
1,295,800
1,406,100
1,406,1001,295,8001,283,6001,319,3001,237,3001,101,5001,074,6001,059,5001,123,5001,062,3001,046,700952,000868,200918,000834,200768,500754,900638,100565,800503,700498,072409,954395,67514,646,45111,826,369
       Other Current Liabilities 
8,674,071
8,892,394
665,635
710,981
904,964
188,100
212,000
233,800
335,700
367,900
406,400
-100
3,900
10,700
547,200
607,100
652,400
629,500
705,000
610,600
560,800
614,100
627,600
777,300
728,400
728,400777,300627,600614,100560,800610,600705,000629,500652,400607,100547,20010,7003,900-100406,400367,900335,700233,800212,000188,100904,964710,981665,6358,892,3948,674,071
   > Long-term Liabilities 
0
0
100,367
99,441
75,211
86,900
91,500
104,000
123,000
126,900
139,500
152,100
157,600
153,700
11,300
11,400
10,200
1,800
2,000
2,000
432,700
539,700
941,800
1,136,300
1,017,500
1,017,5001,136,300941,800539,700432,7002,0002,0001,80010,20011,40011,300153,700157,600152,100139,500126,900123,000104,00091,50086,90075,21199,441100,36700
       Long term Debt Total 
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
28,500
15,500
13,700
6,500
139,600
0
0
0
0
0000139,6006,50013,70015,50028,5000000000000000000
       Capital Lease Obligations Min Short Term Debt
0
0
0
0
-3,733
-4,000
-3,300
-2,400
0
0
0
-3,600
-5,000
-3,100
-3,700
-5,100
-4,700
4,800
-114,900
-30,000
132,400
11,100
-66,000
-151,100
-211,900
-211,900-151,100-66,00011,100132,400-30,000-114,9004,800-4,700-5,100-3,700-3,100-5,000-3,600000-2,400-3,300-4,000-3,7330000
       Long-term Liabilities Other 
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
156,100
700
1,000
-400
16,300
100
5,300
0
05,30010016,300-4001,000700156,10000000000000000000
> Total Stockholder Equity
16,991,957
19,675,066
440,786
523,185
494,865
758,300
770,600
918,500
971,100
1,098,000
1,251,700
1,475,200
1,584,800
1,791,200
1,965,100
1,798,300
2,044,300
2,136,000
2,036,000
2,204,400
2,355,800
2,523,000
2,462,100
2,510,300
3,173,600
3,173,6002,510,3002,462,1002,523,0002,355,8002,204,4002,036,0002,136,0002,044,3001,798,3001,965,1001,791,2001,584,8001,475,2001,251,7001,098,000971,100918,500770,600758,300494,865523,185440,78619,675,06616,991,957
   Common Stock
4,364,187
4,749,974
128,131
132,321
138,873
148,800
159,100
173,900
185,400
195,300
209,100
233,000
239,100
249,200
260,600
274,600
291,700
305,800
315,900
331,200
347,100
357,400
364,700
370,200
379,000
379,000370,200364,700357,400347,100331,200315,900305,800291,700274,600260,600249,200239,100233,000209,100195,300185,400173,900159,100148,800138,873132,321128,1314,749,9744,364,187
   Retained Earnings Total Equity0000000000000000000000000
   Accumulated Other Comprehensive Income 
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
-6,400
-60,500
-42,900
-56,400
-47,200
-65,500
-22,900
72,100
-10,800
-10,80072,100-22,900-65,500-47,200-56,400-42,900-60,500-6,4000000000000000000
   Capital Surplus 0000000000000000000000000
   Treasury Stock0000-128,800-252,400-506,400-180,000-81,500-361,900-296,700-262,700-384,600-305,100-306,400-240,500-171,600-30,100-253,100000000
   Other Stockholders Equity 
0
0
312,655
390,864
355,992
-81,100
-253,200
-30,200
785,700
902,700
1,042,600
1,242,200
100
0
-300,400
-377,000
-81,500
-180,000
-549,300
-308,800
-128,800
-65,300
-143,800
-238,600
-83,000
-83,000-238,600-143,800-65,300-128,800-308,800-549,300-180,000-81,500-377,000-300,40001001,242,2001,042,600902,700785,700-30,200-253,200-81,100355,992390,864312,65500



Balance Sheet

All numbers in thousands.




Cash Flow

All numbers in thousands.