Projected Income Statement: 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,115 5,001 5,730
Change - -29.23% 6.08% -17.36% 11.83% 9.94% 21.53% 14.58%
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,111 1,251
Change - - -5.35% 130.11% 45.8% 13.1% 12.61%
Free Cash Flow (FCF) 1 340.7 -81.31 24.07 -258 441 498 614
Change - - 129.6% -1,171.83% 270.95% 12.93% 23.29%
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.91% 73.04% 72.22%
EBIT Margin (%) 107.55% 77.05% 72.51% 75.26% 74.51% 74.04% 72.55% 73.12%
EBT Margin (%) 102.67% 10.64% -15.77% 59.15% 150.09% 118.28% 154.71% 118.78%
Net margin (%) 101.37% 58.1% -17.56% 56.71% 145.08% 126.41% 162.64% 144.15%
FCF margin (%) 67.42% - -17.1% 4.81% -47.61% 72.74% 71.73% 72.58%
FCF / Net Income (%) 66.51% - 97.38% 8.48% -32.81% 57.54% 44.1% 50.35%

Profitability

        
ROA 3.69% 2.16% 2.31% 2.31% 2.14% 2.25% 2.25% 2.47%
ROE 7.46% 4.09% 4.16% 4.2% 3.82% 3.77% 3.68% 3.98%

Financial Health

        
Leverage (Debt/EBITDA) 14.86x 11.41x 11.21x 9.04x 9.37x 9.18x 9.86x 9.38x
Debt / Free cash flow 15.84x - -49.81x 139.06x -14.51x 9.33x 10.04x 9.33x

Capital Intensity

        
CAPEX / Current Assets (%) 36.56% - 65.03% 58.5% 124.31% 161.99% 159.98% 147.86%
CAPEX / EBITDA (%) 50.87% - 85.58% 79.06% 168.65% 219.17% 219.05% 204.74%
CAPEX / FCF (%) 54.22% - -380.37% 1,216.2% -261.11% 222.69% 223.04% 203.72%

Items per share

        
Cash flow per share 1 0.4941 - 0.4853 0.5619 0.7386 0.5404 0.5492 0.6213
Change - - - 15.78% 31.45% -26.83% 1.63% 13.12%
Dividend per Share 1 0.1727 1.2 0.44 0.42 0.42 0.4269 0.4497 0.5145
Change - 594.97% -63.33% -4.55% 0% 1.64% 5.34% 14.42%
Book Value Per Share 1 15.05 14.58 13.92 13.31 14.35 15.71 17.16 19.5
Change - -3.13% -4.53% -4.41% 7.82% 9.51% 9.25% 13.59%
EPS 1 1.08 0.47 -0.18 0.5 1.4 1.685 2.154 2.377
Change - -56.48% -138.3% 377.78% 180% 20.34% 27.86% 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 7.92x 6.2x
PBR 0.85x 0.78x
EV / Sales 20.4x 19.1x
Yield 3.2% 3.37%

EPS & Dividend



Y-o-Y evolution of P/E

 

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
A
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
21
Last Close Price
13.35EUR
Average target price
17.40EUR
Spread / Average Target
+30.37%

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Stocks
  3. MRL Stock
  4. Financials Merlin Properties SOCIMI, S.A.