Tuesday, June 23, 2020

Tableau Visualisation of HDB prices

Came across this interesting use of data visualisation applied to HDB prices.
Kudos to the team that came up with this great application of Tableau to derive insights from data!

While I am figuring out how to embed the interactive version in this blog (comments welcome if you could guide me on how to do this!), you can navigate to the public dashboard here

This also reminds all of us the importance of continuous re-skilling and up-skilling as described in my earlier post here.

Hope this inspires you to think of how you can leverage data as part of your quest to uncover value!



Credit to the authors of the original Tableau Dashboard

Tuesday, June 16, 2020

What determines Residential Property prices?



"Price is What You Pay; Value is What You Get" - Warren Buffet

Ever wondered about the price discrepancies among properties in different part of Singapore, or even within different parts of the same estate? What explains the huge observed variance in psf from $6xx to $2xxx?

What exactly is fair value?

FRS 13 defines fair value as the price that would be received to sell an asset or paid to transfer a liability in an orderly transaction between market participants at the measurement date. 

What valuation techniques are available?

The market approach uses prices and other relevant information generated by market
transactions involving identical or comparable (ie similar) assets, liabilities or a group of
assets and liabilities, such as a business. For example, some people might refer to recent transacted prices at the HDB resource here to determine what an appropriate price could be.

The cost approach reflects the amount that would be required currently to replace the service
capacity of an asset (often referred to as current replacement cost). In the Singapore context, this could be more relevant to landed property where in addition to the land price, the parties could also consider how much Additions and Alterations costs have been, or would be incurred.

The income approach converts future amounts (eg cash flows or income and expenses) to a single current (ie discounted) amount. When the income approach is used, the fair value measurement reflects current market expectations about those future amounts. This can be easily understood in the scenario of holding an investment property: typical inflows could be receipts of tenants' rental, and outflows would be the mortgage repayments and/or the future sale proceeds.

Application to the Residential property market

At the heart of the model is the observation that market forces should adjust to make households indifferent between buying and renting

There is a ”user cost relationship” linking house prices, rents and interest rates. According to this relationship, market forces should equate the cost of renting – the rent/price ratio – to the cost of home ownership – the interest income forgone upon purchasing a property net of expected house price appreciation

A second relationship represents demand for housing, and states that rents are higher when the stock of housing is lower, but also that rents increase when households have more income to spend on accommodation services and when population increases. 

The third leg of the model is relationship capturing housing supply, which assumes that new
housing is built when house prices increase relative to the marginal cost of building new dwellings. 

The framework implies that house prices increase when interest rates fall; when disposable income and/or the size of population increase; and when building costs rise.

Since housing purchases are typically financed through mortgage loans, and many potential
homeowners are constrained in the amount of credit they can obtain, credit supply ought to impact house prices. An increase in credit availability and a loosening of borrowing constraints, for example, is likely to reduce the interest rates faced by households and push prices up

Pressures on the housing market may also arise from abroad – for example, because foreign investors with abundant liquidity and a high willingness to pay acquire property in local residential markets

While this blog is primarily concerned about Singapore real estate, it is interesting to note that the sensitivity of house prices to drivers varies across jurisdictions depending on the structural characteristics of each economy. For example, the interest rate sensitivity of prices ought to be greater in countries where mortgages are predominantly adjustable rate rather than fixed rate. More broadly, changes in housing demand drivers should have a larger impact on house prices in countries
where the price elasticity of supply is low. Price sensitivities to demand drivers could also be expected to be greater in jurisdictions with tax incentives for home ownership such as tax deductibility of mortgage interest payments.

For more details, including empirical observations (i.e. with real data), please refer to the paper here

What can I do with this model?

In summary, the framework returns the following predictions regarding the sensitivity of house prices to different drivers: prices should be higher when
  • households’ disposable income are higher;
  • population growth are higher; 
  • interest rates are lower; 
  • credit conditions loosen; and 
  • footprint of international investors is higher.
Anecdotally, in the current Jun 2020 environment:
  • Household income should be lower due to lower consumer confidence
  • Population growth should be lower due to possible reduction in foreign workforce
  • Interest rates are lower directly/indirectly due to monetary policy
  • Credit should be simpler to obtain for example the MAS SGD facility for esg loans
  • There could be more international investors particularly from Hong Kong
Depending on your views on each of those drivers, and the relative weightage accorded to each driver, how do you think residential property prices will behave? How can you benefit from the price trends? Let me know in the comments below.

Tuesday, June 9, 2020

Covid-19 aka "Crisis of a Generation": Should I buy or sell now?

How is the Market Situation?

The Straits Times reported on 9 June 2020 that resale transactions for non-landed private homes saw a plunge in sales volumes with 171 transactions in May 2020. This is 80% lower than May 2019 and a 43% decrease compared to the 300 transactions in April 2020.

Prices increased 0.1 per cent compared to April.

The Straits Times reported on 4 June 2020 that Housing Board resale flat volumes dropped in May 2020 to levels not seen in the last thirty years. 364 flats changed hands. This compares to 2019 total resale volume of 23,714 (monthly average 1,976).


Similar to the non-landed private home sector, prices increased 0.1 per cent compared to April.

The reduction in transactions could possibly be due to Circuit Breaker measures preventing physical viewings, or general reduction in consumer confidence resulting in deferral of big-ticket spend.


Recap of 2008 Property Boom

Singapore experienced a property boom in the middle of the recession triggered by the financial crisis. This was widely attributed to a change in investors' perception: an increasing number of people viewed real estate as a safe haven after reports of failures in financial products.

Transact or wait?

Given the possibility for borrowers to defer payments for both home and personal loans, it is unlikely that we will witness a significant fire sale in the near future. Barring exceptional changes in personal circumstances, sellers will likely have the holding power to wait out any temporary price weaknesses.

For buyers, in the short term, the pre-pandemic factors continue to apply: reassess your available budget depending on how your earning power will be affected - affordability is key.

In the long term, I would recommend all participants in the real estate market to scrutinize PM Lee Hsien Loong's 7 June National Broadcast  here. As we face the "crisis of a generation", should real estate continue to be the asset class of choice for wealth preservation/growth? This question would require examination of the drivers of property prices which I will share in a subsequent post here.

Thank you for reading.