Projected Income Statement: Merlin Properties SOCIMI, S.A.

Forecast Balance Sheet: Merlin Properties SOCIMI, S.A.

Forecast Balance Sheet - Merlin Properties SOCIMI, S.A.
Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 5,395 3,818 4,050 3,347 3,743 4,148 5,017 5,826
Change - -29.23% 6.08% -17.36% 11.83% 10.82% 20.95% 16.13%
Announcement Date 2/24/22 2/27/23 2/28/24 2/27/25 2/25/26 - - -
1EUR in Million
Estimates

Cash Flow Forecast: Merlin Properties SOCIMI, S.A.

Fiscal Period: December 2021 2023 2024 2025 2026 2027 2028
CAPEX 1 184.7 309.3 292.7 673.6 982.1 1,186 1,409
Change - - -5.35% 130.11% 45.8% 20.82% 18.79%
Free Cash Flow (FCF) 1 340.7 -81.31 24.07 -258 -477 123 301
Change - - 129.6% -1,171.83% -84.91% 125.79% 144.72%
Announcement Date 2/24/22 2/28/24 2/27/25 2/25/26 - - -
1EUR in Million
Estimates

Forecast Financial Ratios: Merlin Properties SOCIMI, S.A.

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028

Profitability

        
EBITDA Margin (%) 71.86% 73.92% 75.99% 74% 73.71% 73.76% 73.26% 72.17%
EBIT Margin (%) 107.55% 77.05% 72.51% 75.26% 74.51% 72.89% 72.03% 71.06%
EBT Margin (%) 102.67% 10.64% -15.77% 59.15% 150.09% 148.97% 163.97% 129.49%
Net margin (%) 101.37% 58.1% -17.56% 56.71% 145.08% 148.58% 169.17% 150.62%
FCF margin (%) 67.42% - -17.1% 4.81% -47.61% -78.44% 17.69% 35.71%
FCF / Net Income (%) 66.51% - 97.38% 8.48% -32.81% -52.79% 10.46% 23.71%

Profitability

        
ROA 3.69% 2.16% 2.31% 2.31% 2.14% 2.25% 2.25% 2.49%
ROE 7.46% 4.09% 4.16% 4.2% 3.82% 3.66% 3.49% 3.64%

Financial Health

        
Leverage (Debt/EBITDA) 14.86x 11.41x 11.21x 9.04x 9.37x 9.25x 9.85x 9.58x
Debt / Free cash flow 15.84x - -49.81x 139.06x -14.51x -8.7x 40.79x 19.35x

Capital Intensity

        
CAPEX / Current Assets (%) 36.56% - 65.03% 58.5% 124.31% 161.49% 170.65% 167.2%
CAPEX / EBITDA (%) 50.87% - 85.58% 79.06% 168.65% 218.94% 232.92% 231.66%
CAPEX / FCF (%) 54.22% - -380.37% 1,216.2% -261.11% -205.88% 964.63% 468.24%

Items per share

        
Cash flow per share 1 0.4941 - 0.4853 0.5619 0.7386 0.4617 0.5514 0.6229
Change - - - 15.78% 31.45% -37.5% 19.45% 12.96%
Dividend per Share 1 0.1727 1.2 0.44 0.42 0.42 0.4215 0.4491 0.5079
Change - 594.97% -63.33% -4.55% 0% 0.35% 6.55% 13.1%
Book Value Per Share 1 15.05 14.58 13.92 13.31 14.35 15.2 17 19.01
Change - -3.13% -4.53% -4.41% 7.82% 5.97% 11.83% 11.84%
EPS 1 1.08 0.47 -0.18 0.5 1.4 1.706 2.154 2.377
Change - -56.48% -138.3% 377.78% 180% 21.85% 26.29% 10.35%
Nbr of stocks (in thousands) 466,885 468,225 468,346 562,415 562,814 619,183 619,183 619,183
Announcement Date 2/24/22 2/27/23 2/28/24 2/27/25 2/25/26 - - -
1EUR
Estimates
2026 *2027 *
P/E 6.84x 5.41x
PBR 0.77x 0.69x
EV / Sales 18.7x 17.6x
Yield 3.61% 3.85%

EPS & Dividend

EPS & Dividend - Merlin Properties SOCIMI, S.A.


Y-o-Y evolution of P/E

Valuation ratios - P/E - Merlin Properties SOCIMI, S.A.
 

Year-on-year evolution of the Yield

Valuation ratios - Yield - Merlin Properties SOCIMI, S.A.
Trader
Investor
Global
Quality
ESG MSCI
A
MarketScreener Ratings - Merlin Properties SOCIMI, S.A.
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
21
Last Close Price
11.66EUR
Average target price
17.24EUR
Spread / Average Target
+47.83%

Quarterly revenue - Rate of surprise

Rate of surprise - Net sales - Quarterly - Merlin Properties SOCIMI, S.A.
  1. Stock Market
  2. Stocks
  3. MRL Stock
  4. Financials Merlin Properties SOCIMI, S.A.