Projected Income Statement: CapitaLand Ascott Trust

Forecast Balance Sheet: CapitaLand Ascott Trust

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 2,383 2,511 2,616 2,529 2,576 2,782 2,818 2,800
Change - 5.37% 4.18% -3.33% 1.86% 8% 1.29% -0.64%
Announcement Date 1/27/22 1/30/23 1/28/24 1/26/25 1/29/26 - - -
1SGD in Million
Estimates

Cash Flow Forecast: CapitaLand Ascott Trust

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 106.9 48.53 89.9 74.79 59.68 23.35 47.68 22.08
Change - -54.59% 85.25% -16.8% -20.2% -60.87% 104.2% -53.7%
Free Cash Flow (FCF) 1 38.75 233.8 -99.57 242.4 295.9 404.5 374 400.5
Change - 503.28% -142.59% 343.41% 22.08% 36.71% -7.54% 7.09%
Announcement Date 1/27/22 1/30/23 1/28/24 1/26/25 1/29/26 - - -
1SGD in Million
Estimates

Forecast Financial Ratios: CapitaLand Ascott Trust

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

Profitability

        
EBITDA Margin (%) 37.95% 39.26% 46.04% 41.98% 41.31% 43.03% 43.03% 43.4%
EBIT Margin (%) 33.13% 35.96% 42.74% 32.18% 36.83% 39.32% 39.45% 39.66%
EBT Margin (%) 95.06% 41.82% 40.59% 35.73% 53.05% 26.25% 26.86% 28.19%
Net margin (%) 78.42% 35.95% 31.06% 29.79% 39.11% 20.6% 20.94% 22.02%
FCF margin (%) 9.83% 37.64% -13.37% 29.94% 35.32% 50.4% 44.83% 46.13%
FCF / Net Income (%) 12.53% 104.7% -43.06% 100.49% 90.31% 244.66% 214.07% 209.48%

Profitability

        
ROA 4.15% 2.83% 2.76% 1.72% 2.03% 1.88% 1.97% 2.15%
ROE 7.5% 5.16% 5.07% 3.16% 3.73% 3.76% 3.97% 4.34%

Financial Health

        
Leverage (Debt/EBITDA) 15.92x 10.3x 7.63x 7.44x 7.45x 8.06x 7.85x 7.43x
Debt / Free cash flow 61.48x 10.74x -26.27x 10.44x 8.71x 6.88x 7.53x 6.99x

Capital Intensity

        
CAPEX / Current Assets (%) 27.1% 7.81% 12.07% 9.24% 7.13% 2.91% 5.71% 2.54%
CAPEX / EBITDA (%) 71.4% 19.9% 26.22% 22.01% 17.25% 6.76% 13.28% 5.86%
CAPEX / FCF (%) 275.77% 20.76% -90.28% 30.86% 20.17% 5.77% 12.75% 5.51%

Items per share

        
Cash flow per share 1 0.0459 0.0841 0.0838 0.0833 0.0925 0.0542 0.0562 0.0601
Change - 83.16% -0.32% -0.6% 11.04% -41.38% 3.74% 6.77%
Dividend per Share 1 0.0432 0.0567 0.0657 0.061 0.061 0.061 0.0614 0.0618
Change - 31.25% 15.87% -7.15% 0% 0% 0.62% 0.64%
Book Value Per Share 1 1.19 1.15 1.16 1.15 1.17 1.152 1.152 1.114
Change - -3.36% 0.87% -0.86% 1.74% -1.53% -0.01% -3.33%
EPS 1 0.0932 0.0625 0.0607 0.0595 0.0807 0.0489 0.0501 0.0494
Change - -32.94% -2.88% -1.98% 35.63% -39.45% 2.5% -1.36%
Nbr of stocks (in thousands) 3,276,547 3,441,974 3,763,304 3,791,190 3,829,951 3,851,435 3,851,435 3,851,435
Announcement Date 1/27/22 1/30/23 1/28/24 1/26/25 1/29/26 - - -
1SGD
Estimates
2026 *2027 *
P/E 17.5x 17.1x
PBR 0.74x 0.74x
EV / Sales 7.57x 7.32x
Yield 7.13% 7.18%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
AA
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
9
Last Close Price
0.8550SGD
Average target price
1.056SGD
Spread / Average Target
+23.46%

Annual profits - Rate of surprise

  1. Stock Market
  2. Stocks
  3. HMN Stock
  4. ATTRF Stock
  5. Financials CapitaLand Ascott Trust