Etablissementen Franz Colruyt NV

BATS-CHIXE:COLRB

比利時 / 必需消費品 / Consumer Staples Distribution & Retail

綜觀

股息

5 年 DCF 增長退出價

股價

38.00 EUR

公允價值

56.62 EUR

Metrics	Range	Conclusion
Discount Rate	8.5% - 7.5%	8.0%
Perpetuity Growth Rate	0.0% - 0.5%	0.0%
Fair Value	€53.43 - €63.59	€56.62
Upside	40.5% - 67.2%	48.9%

3.0%

Revenue 5y CAGR

8.4%

5y Avg EBITDA Margin

12.1%

Unlevered FCF 5y CAGR

5-Year DCF Model: Gordon Growth Exit

股價

38.00 EUR

公允價值

56.62 EUR

看漲

48.9%

Revenue and EBITDA

CapEx

Working Capital

D&A

Tax Rate

Discount Rate

Terminal Value


Select Revenue and EBITDA Forecast

(EUR in millions)		Input Projections
Fiscal Years Ending	Mar-24	Mar-25	Mar-26	Mar-27	Mar-28	Mar-29

Revenue	10,845	11,068	11,585	11,936	12,242	12,553
% Growth	11.9%	2.1%	4.7%	3.0%	2.6%	2.5%

EBITDA	786	879	920	961	1,105	1,133
% of Revenue	7.2%	7.9%	7.9%	8.1%	9.0%	9.0%

支援算式

Calculation of Free Cash Flow

Discounting Periods

Discounting Factors

Calculation of Enterprise Value

Equity Waterfall

Historical Financials

Current Trading Multiples


Calculation of Free Cash Flow

Projected Unlevered Cash Flow
(EUR in millions)		Mar-25	Mar-26	Mar-27	Mar-28	Mar-29	Terminal

EBITDA		879	920	961	1,105	1,133	1,133
Other Income / (Exp)		0	0	0	0	0	0
D&A		(409)	(415)	(431)	(556)	(563)	(424)

EBIT		470	505	530	549	570	709
Pro forma Taxes		(94)	(101)	(106)	(110)	(114)	(142)
NOPAT	400	376	404	424	439	456	567

Capital Expenditures	(434)	(490)	(500)	(500)	(441)	(446)	(446)
NWC Investment	85	17	38	26	23	23	0
(+) D&A	285	409	415	431	556	563	424

Free Cash Flow	337	311	357	381	577	596	545
% Growth		-8%	15%	7%	51%	3%	-9%

載入錯誤

Etablissementen Franz Colruyt NV

BATS-CHIXE:COLRB

比利時 / 必需消費品 / Consumer Staples Distribution & Retail

5 年 DCF 增長退出價