It has been a while since my last post and a long while since my last google spreadsheet template. Today, I would like to write about SREITs Geographical Breakdown by Country. This geographical breakdown information is available at SGX Chartbook: SREITs & Property Trust, however it is based on portfolio valuation. In my view, it would be more useful if it is based on gross rental income (GRI).
Therefore, I have created a Google Spreadsheet to for geographical breakdown based on gross rental income as below:
Besides Frasers Logistics & Commercial Trust which is based on property valuation, all information above are based on past 1 year gross rental income, I have indicated source of information at rightest column. I have also estimated the value of CapitaLand Integrated Commercial Trust which is expected to happen in this June end. In case you are not aware, CapitaLand Mall Trust and CapitaLand Commercial Trust are to be merge and become CapitaLand Integrated Commercial Trust.
Similar to my previous post on Sector Contribution Weightage of REITs, I have also created a separate sheet for you to track your SREITs portfolio weightage by country. What you have to do is to selected from drop down and key in cost in green columns, then the google sheets will do the calculation work. Refer below for example:
You could make a copy here. If you find the breakdown is overdetailed, you could customize it to smaller region like "Europe" or "UK" only to suit your own preference.
Although it is good to diversify your SREITs portfolio across different countries, but do note that this also come with forex risk. You should do your own analysis instead of buying any SREITs based on gut feel. That is all for today, hope this post helps.
Happy that it transpired into an article! So much work is actually required to diversify your investment well.
ReplyDeleteI still prefer Sg properties, as income not subjected to forex risk.
Delete