After previous post about data collection, now I would like to share out how to use those data to generate a Basic REITs Analysis Summary through Google Spreadsheets. I will use 3 REITs examples, which are SPH REIT from previous post, First REIT and Ascott Residence Trust.
This summary would require consolidation of a few google spreadsheets that I have shared previously. Below are the post of spreadsheets used, I would suggest you to go through first before you continue this post:
i) How to Create Your Own Basic REITs Screener
ii) Relative Valuation for REITs.
iii) How to DIY a REITs Data Collection Spreadsheet
We have data now, time to make it into information This summary require more formula work, therefore I have added SREITs Basic Screener as overview page for formula link up. I have added a few more columns as compared to previous version, which are:
i) Shortname - For formula to link up with...