Financials Fideicomiso Irrevocable No. F/1523

Equities

FIBRAHD 15

MXCFFI1H0008

Commercial REITs

End-of-day quote Mexican S.E. 06:00:00 2024-04-28 pm EDT 5-day change 1st Jan Change
2.18 MXN 0.00% Intraday chart for Fideicomiso Irrevocable No. F/1523 0.00% +9.00%

Valuation

Fiscal Period: December 2017 2018 2019 2020 2021 2022
Capitalization 1 3,055 3,454 3,520 2,142 1,399 1,097
Enterprise Value (EV) 1 3,512 5,079 5,491 4,210 3,708 3,459
P/E ratio 39.3 x 55.2 x 16.7 x -4.66 x 9.94 x 74.3 x
Yield 8% 9.5% 8.86% 4.09% 6.85% -
Capitalization / Revenue 11.4 x 6.83 x 6 x 4.13 x 2.67 x 1.93 x
EV / Revenue 13.1 x 10 x 9.36 x 8.12 x 7.06 x 6.1 x
EV / EBITDA 20.2 x 14.7 x 15.1 x 16.3 x 21.9 x 11.3 x
EV / FCF 107 x 35.7 x 40.8 x -393 x 44.5 x -84.4 x
FCF Yield 0.93% 2.8% 2.45% -0.25% 2.25% -1.19%
Price to Book 0.97 x 0.9 x 0.96 x 0.67 x 0.43 x 0.34 x
Nbr of stocks (in thousands) 328,003 428,468 431,864 439,435 437,180 437,180
Reference price 2 9.314 8.062 8.151 4.873 3.200 2.510
Announcement Date 5/14/18 4/29/19 4/28/20 4/5/21 5/7/22 4/28/23
1MXN in Million2MXN
Estimates

Income Statement Evolution (Annual data)

Fiscal Period: December 2017 2018 2019 2020 2021 2022
Net sales 1 268.4 505.8 586.9 518.1 524.9 567.5
EBITDA 1 173.8 344.4 363.9 259 169.1 304.8
EBIT 1 173.7 344.2 363.8 258.4 168.8 304.1
Operating Margin 64.74% 68.05% 61.98% 49.87% 32.15% 53.59%
Earnings before Tax (EBT) 1 143.9 88.62 212 -448.6 149.2 15.03
Net income 1 140.7 88.2 211.1 -454.5 143.3 15.03
Net margin 52.45% 17.44% 35.97% -87.73% 27.3% 2.65%
EPS 2 0.2372 0.1461 0.4880 -1.047 0.3221 0.0338
Free Cash Flow 1 32.68 142.4 134.6 -10.72 83.37 -41.01
FCF margin 12.18% 28.15% 22.94% -2.07% 15.88% -7.23%
FCF Conversion (EBITDA) 18.81% 41.33% 36.99% - 49.31% -
FCF Conversion (Net income) 23.22% 161.39% 63.78% - 58.17% -
Dividend per Share 2 0.7454 0.7661 0.7223 0.1993 0.2192 -
Announcement Date 5/14/18 4/29/19 4/28/20 4/5/21 5/7/22 4/28/23
1MXN in Million2MXN
Estimates

Balance Sheet Analysis

Fiscal Period: December 2017 2018 2019 2020 2021 2022
Net Debt 1 457 1,625 1,971 2,068 2,309 2,362
Net Cash position 1 - - - - - -
Leverage (Debt/EBITDA) 2.631 x 4.718 x 5.417 x 7.984 x 13.66 x 7.749 x
Free Cash Flow 1 32.7 142 135 -10.7 83.4 -41
ROE (net income / shareholders' equity) 4.88% 2.52% 5.6% -13.2% 4.48% 0.46%
ROA (Net income/ Total Assets) 3.06% 4.16% 3.58% 2.58% 1.76% 3.01%
Assets 1 4,604 2,123 5,899 -17,629 8,139 499.1
Book Value Per Share 2 9.570 8.980 8.520 7.220 7.390 7.420
Cash Flow per Share 2 2.270 0.7600 2.320 0.9700 1.340 1.520
Capex - 24.8 - - 4.02 4.7
Capex / Sales - 4.91% - - 0.77% 0.83%
Announcement Date 5/14/18 4/29/19 4/28/20 4/5/21 5/7/22 4/28/23
1MXN in Million2MXN
Estimates

EPS & Dividend

Year-on-year evolution of the PER

Change in Enterprise Value/EBITDA

  1. Stock Market
  2. Equities
  3. FIBRAHD 15 Stock
  4. Financials Fideicomiso Irrevocable No. F/1523