| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | BAO HUAT REIT Valuation | ||||||||||||||||
2 | Brought to you by: REIT-TIREMENT | ||||||||||||||||
3 | Fundamental Valuation Information | Relative Valuation Information | |||||||||||||||
4 | Sector | Type | % | Range | Price/NAV | Dividend Yield | |||||||||||
5 | Top 3 Sectors | 1 | Retail | 50 | Up to 1y | Up to 3y | Up to 5y | Up to 1y | Up to 3y | Up to 5y | |||||||
6 | 2 | Industrial | 50 | +2SD | 1.21 | 1.18 | 1.09 | 5.25% | 5.60% | 5.45% | |||||||
7 | 3 | +1SD | 1.18 | 1.14 | 1.07 | 5.00% | 5.30% | 5.35% | |||||||||
8 | Items | Value | Average | 1.15 | 1.1 | 1.05 | 4.75% | 5.00% | 5.25% | ||||||||
9 | Current Price | $2.00 | -1SD | 1.12 | 1.06 | 1.03 | 4.50% | 4.70% | 5.15% | ||||||||
10 | Market Cap, SGD | 4 | Billion | -2SD | 1.09 | 1.02 | 1.01 | 4.25% | 4.40% | 5.05% | |||||||
11 | Income Support | 5 | % | ||||||||||||||
12 | Distribution from Disposal | 5 | % | User to Key In | Result | ||||||||||||
13 | NAV per Unit | $1.82 | |||||||||||||||
14 | Forecast FY DPU | 10 | cents | * Everything can get from SREITs Dashboard besides forecast DPU and Yield Factor | |||||||||||||
15 | Yield Factor | 0.8 | <-- | *Refer Here | |||||||||||||
16 | |||||||||||||||||
17 | Fundamental Valuation Calculation | Valuation Table | |||||||||||||||
18 | Benchmark Yield | 6.25 | % | Type | Fundamental | Relative-P/NAV | Relative-Div. Yield | ||||||||||
19 | Min. Yield | 5.375 | % | Overvalued | $2.020 | $2.080 | $2.130 | ||||||||||
20 | Market Cap Discount | 0.5 | % | Slightly Overvalued | $1.930 | $2.050 | $2.080 | ||||||||||
21 | Target Dividend Yield | 5.417 | % | Fair Value | $1.75 to $1.92 | $2.01 to $2.04 | $1.99 to $2.07 | ||||||||||
22 | Intrinsic Value | $1.840 | Slightly Undervalued | $1.740 | $2.000 | $1.980 | |||||||||||
23 | Relative Valuation Calculation | Undervalued | $1.650 | $1.970 | $1.930 | ||||||||||||
24 | Weighted Avg P/NAV | 1.115 | |||||||||||||||
25 | Weighted Avg Dividend Yield | 4.925 | % | Price Range | |||||||||||||
26 | Weighted Avg 1 SD-P/NAV | 0.031 | Max. Buy Price | $1.930 | Strong Buy | Buy | Hold | Sell | Strong Sell | ||||||||
27 | Weighted Avg 1 SD-Div. Yield | 0.235 | % | Min. Sell Price | $2.060 | ||||||||||||
28 | Mean Reversion Price-P/NAV | $2.020 | Strong Buy Price | $1.830 | Current | ||||||||||||
29 | Mean Reversion Price-Div. Yield | $2.030 | Strong Sell Price | $2.170 | $1.83 | $1.93 | $2.06 | $2.17 | |||||||||
30 | |||||||||||||||||