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...