Financials Lippo Malls Indonesia Retail Trust

Equities

D5IU

SG1W27938677

Commercial REITs

Market Closed - Singapore S.E. 04:31:39 2024-04-26 am EDT 5-day change 1st Jan Change
0.012 SGD 0.00% Intraday chart for Lippo Malls Indonesia Retail Trust 0.00% -29.41%

Valuation

Fiscal Period: December 2018 2019 2020 2021 2022 2023
Capitalization 1 520.5 651.4 181.5 414.4 230.9 130.8
Enterprise Value (EV) 1 1,145 1,266 769.8 1,151 976.6 833.1
P/E ratio 12 x -154 x -0.73 x -7.99 x -18.1 x -1.04 x
Yield 11.3% 9.91% 5.48% 6.48% 10.3% -
Capitalization / Revenue 2.26 x 2.39 x 1.22 x 2.37 x 1.13 x 0.66 x
EV / Revenue 4.97 x 4.64 x 5.18 x 6.58 x 4.77 x 4.22 x
EV / EBITDA 7.43 x 7.89 x 11.1 x 12.4 x 8.27 x 7.75 x
EV / FCF 11 x -29.7 x 5.7 x 215 x 11.1 x 17.9 x
FCF Yield 9.13% -3.37% 17.6% 0.47% 8.99% 5.58%
Price to Book 0.64 x 0.8 x 0.36 x 0.57 x 0.44 x 0.3 x
Nbr of stocks (in thousands) 2,859,934 2,894,903 2,926,795 7,673,336 7,696,810 7,696,810
Reference price 2 0.1820 0.2250 0.0620 0.0540 0.0300 0.0170
Announcement Date 3/24/19 3/19/20 3/31/21 4/6/22 4/2/23 4/2/24
1SGD in Million2SGD
Estimates

Income Statement Evolution (Annual data)

Fiscal Period: December 2018 2019 2020 2021 2022 2023
Net sales 1 230.3 273 148.5 175.1 204.7 197.3
EBITDA 1 154.1 160.5 69.11 92.98 118.1 107.4
EBIT 1 148.5 153.7 63.68 82.66 108.9 99.31
Operating Margin 64.48% 56.31% 42.87% 47.21% 53.19% 50.34%
Earnings before Tax (EBT) 1 99.6 39.45 -208.3 -7.608 48.22 -106.4
Net income 1 60.93 13.5 -230.2 -32.51 1.583 -126
Net margin 26.46% 4.95% -154.98% -18.57% 0.77% -63.87%
EPS 2 0.0152 -0.001461 -0.0849 -0.006760 -0.001655 -0.0164
Free Cash Flow 1 104.5 -42.64 135.2 5.355 87.83 46.46
FCF margin 45.37% -15.62% 91% 3.06% 42.9% 23.55%
FCF Conversion (EBITDA) 67.79% - 195.57% 5.76% 74.34% 43.24%
FCF Conversion (Net income) 171.47% - - - 5,548.3% -
Dividend per Share 2 0.0205 0.0223 0.003400 0.003500 0.003100 -
Announcement Date 3/24/19 3/19/20 3/31/21 4/6/22 4/2/23 4/2/24
1SGD in Million2SGD
Estimates

Balance Sheet Analysis

Fiscal Period: December 2018 2019 2020 2021 2022 2023
Net Debt 1 624 614 588 737 746 702
Net Cash position 1 - - - - - -
Leverage (Debt/EBITDA) 4.052 x 3.828 x 8.513 x 7.927 x 6.312 x 6.536 x
Free Cash Flow 1 104 -42.6 135 5.36 87.8 46.5
ROE (net income / shareholders' equity) 5.42% 1.25% -24.9% -3.69% 0.18% -17.1%
ROA (Net income/ Total Assets) 4.61% 4.83% 2.18% 2.82% 3.52% 3.49%
Assets 1 1,323 279.6 -10,555 -1,153 44.94 -3,612
Book Value Per Share 2 0.2900 0.2800 0.1700 0.0900 0.0700 0.0600
Cash Flow per Share 2 0.0200 0.0400 0.0400 0.0200 0.0100 0.0200
Capex 1 4.11 2.79 1.9 1.87 1.66 3
Capex / Sales 1.79% 1.02% 1.28% 1.07% 0.81% 1.52%
Announcement Date 3/24/19 3/19/20 3/31/21 4/6/22 4/2/23 4/2/24
1SGD in Million2SGD
Estimates

EPS & Dividend

Year-on-year evolution of the PER

Change in Enterprise Value/EBITDA

  1. Stock Market
  2. Equities
  3. D5IU Stock
  4. Financials Lippo Malls Indonesia Retail Trust