REITs Screener 2018

2

Members of the Financial Horse Facebook Group will know that earlier this week, a fellow reader by the name of “Terry Ng” shared a photo of an absolutely amazing REIT Screener that he came up with to keep track of blue chip REITs. I was so impressed with the table that I reached out to him to ask if he would be keen to share it with other readers of Financial Horse. I knew it took a massive amount of effort on his part to compile this table, so the fact that he said yes without hesitation, just goes to show how selfless he is in sharing this work with all investors out there.

So let’s not take anything from him. Everything else in this post is pure Terry. Way to go sir! The Singapore investing community needs more men like you.


Downloadable link to the Excel spreadsheet: REITS Screener Spreadsheet 

Please also note the important disclaimers at the bottom of the table.

REIT/Trust NameWALEOccupancy RateProperty YieldGearing RatioCost of DebtInterest Coverage RatioDebt to MaturityP/BDiv YieldNAVIndustryMarket Cap(Mil)
CapitaLand Mall Trust1.999%5.4%34%3.2%4.84.91.105.14%$1.95Retail7380
Frasers CentrePoint Trust1.892%4.9%29%2.3%6.92.31.115.29%$2.02Retail2027
SPH REIT2.4100%5.1%25%2.8%6.12.11.055.33%$0.95Retail2554
Mapletree Commercial Trust2.798%4.6%36%2.7%4.94.01.195.51%$1.38Retail/Office4521
Suntec REIT3.199%3.5%35%2.7%3.82.90.885.40%$2.11Retail/Office5029
Starhill Global REIT3.296%5.3%35%3.2%4.22.60.786.88%$0.92Retail/Office1592
CapitaLand Commercial Trust5.997%3.60%37%2.6%4.92.41.014.92%$1.74Office6362
Frasers Commercial Trust2.689%5.50%35%3.0%4.42.50.896.96%$1.58Office1217
Keppel REIT5.599.7%3.48%38%2.62%4.33.40.844.83%$1.41Office4101
Mapletree Industrial Trust3.889.6%7.20%33.7%2.90%7.13.31.366.00%$1.47Industrial3827
Mapletree Logistics Trust3.596.6%5.12%37.6%2.30%5.64.51.156.05%$1.10Industrial3761
AIMS AMP REIT2.391%6.31%33%3.60%4.73.31.047.25%$1.37Industrial946
Ascendas REIT4.292%6.22%34%2.90%5.93.21.236.15%$2.12Industrial8000
Fraser L & I Trust6.7599%8.80%29%2.80%8.32.91.156.59%$0.94Industrial2500
Ascott REIT4.60%36%2.40%4.14.10.866.56%$1.25Hospitality2313
Ascendas Hospitality Trust5.76%31%2.60%5.12.70.887.28%$0.92Hospitality906
Frasers Hospitality Trust5.53%32%2.65%5.12.740.847.37%$0.82Hospitality1317
Far East Hospitality Trust3.91%34%2.50%4.13.30.746.09%$0.87Hospitality1290
CDL Hospitality Trust6.51%33%2.10%7.32.61.025.91%$1.53Hospitality2027
First REIT9.5100%8.11%33%3.38%5.53.71.236.91%$1.01Medical976
Parkway Life REIT7.998%5.93%36%1.00%11.33.11.554.91%$1.76Medical1657
Keppel DC REIT9.193%7.97%33%2.20%9.73.81.385.31%$0.97Data Center1623
Trust NameP/EP/BEV/EBITDANet Debt AssetNet Debt EquityDebt Servicing RatioInterest Coverage RatioCost of DebtDiv YieldNAVIndustryMarket Cap(Mil)
Netlink Trust450.961510%13.3%15.75%6.43.47%4.13%$0.82Telecommunications3020
Keppel Infrastructure Trust701.691749%83.0%54.00%1.85.14%7.37%$0.30Utilities1948
Credits: Terry Ng

 

Note:

  1. The REITs shortlisted in the screener are based on criteria such as (1) strong sponsor, (2) market cap of at least S$1b and no China REITS. As for Business Trust, only businesses that are defensive in nature such as utilties/Telecoms are shortlisted.
  2. The screener is updated when the respective REIT’s annual report are published.
  3. The Dividend Yield and PB Ratio are based on historical NAV and DPU based on their latest annual report (FY2017). It is not based on Trailing Twelve Months (TTM) yield. The PB and Dividend Yield is updated based on repsective REITS stock price as of 17 Sep 2018.
  4. Hospitality REITS’s WALE and Occupancy rate:
    1. WALE for hospitality REITs are only applicable for retail and office component of the hospitality REIT. The retail and office component is only a small component of the respective hospitality REIT. So I don’t feel a need to include such numbers. Anyway most of the hospitality REIT have long management contract or Master Lease of at least 5 years to 20 years.
    2. Most hospitality REITs listed in SGX have overseas properties except Far East Trust which is a pure Singapore Play. It is also difficult to compare the REITS in terms of RevPAR / ADR / Occupancy Rate as the hotels are operating in different countries with different economic conditions. As for Ascott REIT, it is a pure REIT with serviced residence and no hotels in their portfolio. Those who want to invest in hospitality REITS must be aware that this sector is very cyclical and should only form a small percentage of your REIT portfolio.
  5. The screener is good for level 1 analysis. But in order to understand the REIT and convince yourself to press the buy button, individuals need to apply qualitative analysis for level 2 and foresight for level 3. Past performance is not an indicator of future performance.

Level 1- Quantitative Analysis

Level 2 – Qualitative Analysis

Level 3 – Foresight

Disclaimer: Please do not buy REITS purely based on financial data and ratios. It’s the underlying fundamentals that will affect the stock price of the REITS.


Financial Horse has a set of 7 Commandments for Successful Investing, that I ask myself before making every investment, and that I will never break regardless of the situation. Enter your email below to receive a copy in your inbox!

Enjoyed this article? Like our Facebook Page for more great articles, or join the Facebook Group to continue the discussion!

2 COMMENTS

Leave a Reply