This is a continuity post from my previous post - How do I Conduct Fundamental Analysis for REITs? in which I have brought up the idea of using yield factor as a discount factor for the dividend yield to get the fundamental intrinsic value. I have shared this idea previously in 2019 - REITs Valuation post. Besides fundamental valuation, I would also employ the reversion to mean method to gauge the favorable price, which is similar to the post of 9 Attractive SREITs Based on Mean Reversion. I would use a fiction REIT - BAO HUAT REIT as an example to better illustrate my thought process.
Image by Gerd Altmann from Pixabay
I have created a simple spreadsheet with the example that I am going to use as below. You could first make a copy through this link and go through it together with this post.
There are two tabs, the "benchmarks" tab is for you to specific your...