IS428 2016-17 Term1 Assign1 Nguyen Duy Loc
Contents
Abstract
The market of private properties in 2015 continued to show decline further in term of supply and prices. Would this trend go further into 2016?
The prices on the market is usually determined by supply and demand. From this analysis, we will see how the supply react to the decreasing demand and how responsive is this industry to the market forces.
Problem and Motivation
What are the three patterns of the share of the private properties supply in 2015?
What are the three patterns of the distribution of the private properties prices in 2015?
With reference to the findings, what policy should we implement for 2016.
Approaches
Data Preparation
The data is collected from REALIS by quarter:
- The residential projects data quarter by quarter of 2015
- The residential transactions data monthly of 2015.
Tools Utilized
Tablue 10
QGIS 2.12
Results
Supply
As seen below, the majority of the of the units supply come from condominium category, followed secondly by apartments.
However, this dominant category is dropping in term of supply. Clearly, the supply is following the decreasing demand trend for condominiums.
Among the residentials units supplied in 2015, some are planned, some are under-construction and some are complete.
To clearly see the trend in demand, we look at how many units are launched during 2015 but unsold. Even though the trend in the number of units is downward, the number of units unsold is upward.
Demand & Prices
The below picture show us the sales throughout all the months of 2015 by planning regions. For North East Region, there is a huge surge during the summer period.
Overall, sales tends to decreases toward the end of the year from November and starts to pick up around March. During the period between March and November, sales fluctuate wildly.
Its not always the case where the pricing dictates demand. Still, it is true for North East Region sales during summer when the price plummeted and the sales rocketed up.
One common question always comes to our minds is when to buy and where to buy a house? For instance, I want to buy a condo.
However, is it good enough if a person takes the median pricing and gauge the future price of the house? It depends on the distribution of the pricing in that area as well as the property type.
Based on the transactions data, we observe the following distribution of selling/buying activities.