Dynamic Dashboard

>>>Dashboard Link<<<

For this section we look at the trends for new condo launches in 2008, 2013 and 2018. The main objective is to observe if leasehold properties' prices would start to decay. Users can play around with the dashboard to derive the trends according to the filters selected.

Tool: Tableau Public

Avoid buying leasehold properties as their lease will decay... but how old is too old? Is a 15 year-old leasehold property still profitable?

To address this belief, we have extracted newly launched properties in years 2008, 2015 and 2018 and developed a dashboard to enable users to interact with the data to obtain their own insights.

Data

From the main dataset, we filtered out the new launches in 2008. 2013 and 2018. The new launches are identified as properties that are indicated as "New Sale" under Field: Type of Sale on that particular Year and no data has occurred before the identified Year.

We selected launches in 2008, 2013 and 2018 as we will be able to derive the trends from the past 15, 10 and 5 years and observe their performances.

Median Profit/Loss (%) field was used as it would capture a more accurate change in Profit/Loss as compared to actual ($) figures.

Dashboard

The filtered data is then uploaded onto Tableau Public where the various filters are inserted for users to interact. Users can select the tenure, launch year, relevant individual condos and relevant districts to make comparisons. This link to access the dashboard.

Inferences

Generally, the median P/L(%) trendline for both freehold and leasehold properties moves in similar directions, peaking in 2012 and 2022. If we want to assess if leasehold decay is in effect, the best reference would be to observe the median P/L (%) trend of new launches in 2008 as they would be 15 years old. From the consolidated view, leasehold properties still outperforms freehold properties in terms of profitability although these properties are already 15 years old. P/L($) are strongly influenced by other market forces instead of decay. Thus, we can conclude that leasehold properties do not experience decay at the 15-year-old mark.

* Caveat: Analysis does not consider factors such as holding period, sales frequency, unit layout, development size etc.