Welcome to the SREITs dashboard page! For the best viewing experience, desktop and tablet users are ideal, while mobile users can also enjoy it in landscape mode for optimal viewing. The dashboard is thoughtfully segmented and organized, ensuring you effortlessly find what you're looking for.
Finding value in the dashboard? Consider spreading the word to others who could benefit. Ready to dive deeper? Your support on REIT-TIREMENT Patreon would be greatly appreciated. By becoming a patron, you'll access exclusive valuation analyses, downloadable SREITs dashboard PDFs and detailed SREITs Data Excel files. Moreover, SREITs Dashboard PDFs available on Patreon feature extended trend periods of up to 10 years and encompass additional metrics trends, offering more profound insights and value.
Your support is crucial and invaluable in continuing to enhance and expand this resource. Thank you for considering supporting this journey!
Part - 2 of 2 - 21 Counters
Wow these are really very valuable data! Thank you!
ReplyDeleteGlad that you like it, please feel it to share it.
DeleteWould like to ask where did you get the land lease expiry data from?
ReplyDeleteEspecially for CMT, can't seem to find it anywhere
Manually calculated from Annual report, then minus 0.25 every quarter. Then when new annual report is out, re-count again.
DeleteHappy to see the data in such user interface ��
ReplyDeleteVisual data easier to digest
DeleteLove this dashboard! Just a little feedback, maybe showing all the counters or a drop down field instead of side scrolling will be easier to find and select?
ReplyDeleteGlad that you like it. My source Google sheet got such function, but when embedded in Google sheet, drop down can't work. Is the limitations on blogger site.
DeleteHi Vince,
ReplyDeleteThank you for this very useful dashboard. May i know for your calculation on dividend yield & Price/NAV High & Low, is it calculated daily or based on quarterly?
I am happy that you find it useful. I think you are referring to the Price Relative Chart Average Dividend Yield and Average Price/NAV section. Since it is average value of each quarter, the high low will only be updated quarterly. So you may come across "current" value is not within the high and low range.
DeleteGreat site Vince, keep it up
ReplyDeleteThanks for your compliment
Deleteany plans to include other business trusts into the dashboard? but i would imagine its a lot of extra work
DeleteSo far I only find 2 BizTrusts operate similar to REITs, which are AIT and DRT. As for other business trust, since their business model are different, those figures in dashboard may not be suitable.
DeleteVery informative site for someone like me who is getting exposed to investments only recently. Thanks for the great work Vince.
ReplyDeletehaha, glad that helps. Good to read the post "suggestions to new reits investors" as well
Deletenice work!!
ReplyDeleteThanks
DeleteWhat does the red portion of the barchart mean? For example gearing ratio, its written 41%, and blue bar is up to 41%. And there's a red bar that extends up to 50%.
ReplyDeleteHaha. Someone asked before. The red bar is to show the limits of it. E.g. gearing limit max at 50%, fixed rate debt max is 100%. I have tried but couldn't but different text on red portion.
DeleteIt will be even better if there is a ranking table so that we can see at a glance which is the best SREITS in terms of undervalued price, yield, gearing ratio, price/NAV
ReplyDeleteUndervalue or not is quite subjective. You could refer to my SREITs Data page for all SREITs price, yield, gearing ratio, price/NAV and etc. Click SREITs Info -> SREITs Data. I sort according to alphabet. So far blogspot not allow user to interact with google sheet table, not like wordpress with table plugin
DeleteThank you Vince. For the invaluable dashboard. What is the formula for distribution on capital and distribution margin please? I can't confirm it anywhere!!
ReplyDelete1) Distribution on Capital = Distribution to Unitholders / (Equity + Debt)
Delete* Exclude non-controlling interest
2) Distribution Margin = Distribution to Unitholders / (Gross Revenue from Properties + Distributions from Associate/Joint Venture)
You could refer to my previous post of Uncommon Financial Metrics of REITs for more detail. I have trimmed the distribution margin to exclude interest income & any recurring income as most SREITs which adopted half-yearly reporting do not declare this info quarterly anymore.
Wow, this is very good data!
ReplyDeleteGlad it helps. Do verify data before make any decision. I might be wrong.
DeleteGreat Work!
ReplyDeleteMay I know how you import price data from InvestingNote? Thanks.
In Google Sheet, input the following formula:
Delete=IMPORTXML("https://www.investingnote.com/stocks/SGX:O5RU","//*[@id='stock-panel']/div[1]/div[2]/div[1]/h1/strong")
Replace the SGX:O5RU to your desired stock quote, then you are good to go.
Thanks a lot! I just update my worksheet.
DeleteBtw, better to also look at other markets, eg. US and China, many great companies
DeleteGlad the formula helps. There are indeed many good oversea counters. But just focus on SREITs already taken up most of my free time.
DeleteThai is amazing work. Thank you so much for sharing.
ReplyDeleteThanks for compliment, though I noticed that now people only look at "data" tab instead of individual SREITs tab.
Deletewow this is amazing, if only i found out about this earlier! thanks for the effort!
ReplyDeleteThanks for compliment. Please share to your friends so they can know this blog "earlier" too.
DeleteThis is amazing work! How often do you keep it updated? I guess it keeps you busy during the quarterly reporting period.
ReplyDeleteThanks for compliment. I normally update within next day of announce release. Unless there is cases where many REITs released in same day, like the 23th July-8 REITS, and this coming 28th July - 5 REITs
Deletethis is a very good dashboard... thanks so much for doing this.
ReplyDeleteGlad that helps, please share to your friends if you find this useful
Deletemust give you thumb up for sharing, could you show how to calculate the ICR? thanks in advance
ReplyDeleteThanks for compliment. MAS recently issued a standardize formula for ICR on 16 Apr 2020, as quoted below:
Delete"Interest coverage ratio (or ICR) means a ratio that is calculated by dividing the trailing 12 months earnings before interest, tax, depreciation and amortisation (excluding effects of any fair value changes of derivatives and investment properties, and foreign exchange translation), by the trailing 12 months interest expense and borrowing-related fees."
SREITs have adopted this calculation in their latest result, so manual calculation is no longer required at our end.
Hi Vince, may I know:
ReplyDelete1) What is GRI ? Group......? What does it means?
2) How to do you calculate Distribution margin%? What is the formula?
Thank you
GRI = Gross Rental Income
DeleteDistribution Margin = Distribution margin is calculated based on past 4 quarters distributions and gross revenue+distributon from joint venture/associate, excluding income support and distribution from asset disposal.
For more detail, you can refer to the note tab which I explain on how I get those data. Let me know if you find any missing definition.
Hi Vince,
ReplyDeleteUnder Related Parties Shareholding,
1)the Directors of REIT Manager %, can you explain this part?
If I see 20%, does it means that Directors of REIT Manager hold 20% of entire REIT?
2) REIT Manager shows another %. A bit confuse.
Please help to explain. Thank you.
REIT manager is refer to the "company" which manage the REIT, for example, ARA LOGOS Logistics Trust Management Limited is the REIT manager for ARALOGOS Logistics Trust. As for Directors of REIT manager is refer to "person" who are director level at the "company" which manage REIT.
DeleteIs my explanation clear?
Very clear. Thank you very much.
DeleteWould it be possible to include the 3 SG REITS ETFs in this Dashboard?
ReplyDeleteIt will certainly be wonderful if it is.
The informatio for the 3 REIT ETF would be different from dashboard items, so would need to review and design a new layout. Let me think about it.
Deletehello Vince, looking at the one year +1 SD P/NAV for KDC REIT and think there may be a typo. it has the same value as the three year +1 SD P/NAV.
ReplyDeleteI just check, the data is correct, both are similar. 1y = 2.333 while 3y = 2.326. The table is auto generate instead of manual key in.
Deletehello Vince, are you going to include digital core reit in your s-reits dashboard?
ReplyDeleteHi Mikhail, added
Deletethanks, Vince.
DeleteI am new to your site. Looks like a full time job here. Fantastic amount of work. Great work.
ReplyDeleteThanks for the compliment. My full time job is not related to financial line though. Anyway, pls help to share to ur like-minded friends.
DeleteThe key indicators provide optimal focal point🌟🌟🌟🌟🌟 and the key statistics provides a good🌟🌟🌟🌟🌟 overall evaluation of the individual reit👍👍, aids in decision making. Appreciate the hard effort.
ReplyDeleteThanks for your compliment. Please help to share it to your like-minded frens.
DeleteHi Vince, been searching for high & low for quality S-REIT info since investing in them a year ago until I discovered your blog via Dividend Uncle. Very generous of you willing to share these info. Keep up with the good work.
ReplyDeleteHi, thanks for your compliment. I also appreciate Dividend Uncle's help to feature my website in his videos. Do help to share my site to your like-minded friends. Thanks
Delete