Abstract
With the rapidly increasing house prices in the Netherlands, there is a growing need for more localised value predictions for mortgage collaterals within the financial sector. Many existing studies focus on modelling house prices for an individual city; however, these models are often not interesting for mortgage lenders with assets spread out all over the country. That is why, with the current abundance of national geospatial datasets, this paper implements and compares three hedonic pricing models (linear regression, geographically weighted regression, and extreme gradient boosting—XGBoost) to model real estate appraisals values for five large municipalities in different parts of the Netherlands. The appraisal values used to train the model are provided by Stater N.V., which is the largest mortgage service provider in the Netherlands. Out of the three implemented models, the XGBoost model has the highest accuracy. XGBoost can explain 83% of the variance with an RMSE of €65,312, an MAE of €43,625, and an MAPE of 6.35% across the five municipalities. The two most important variables in the model are the total living area and taxation value, which were taken from publicly available datasets. Furthermore, a comparison is made between indexation and XGBoost, which shows that the XGBoost model is able to more accurately predict the appraisal values of different types of houses. The remaining unexplained variance is most probably caused by the lack of good indicators for the condition of the house. Overall, this paper highlights the benefits of open geospatial datasets to build a national real estate appraisal model.
Subject
Earth and Planetary Sciences (miscellaneous),Computers in Earth Sciences,Geography, Planning and Development
Reference42 articles.
1. Hypotheek in Relatie tot Waarde Huis (LTV)https://afm.nl/nl-nl/consumenten/themas/producten/hypotheek/hoeveel-lenen/maximale-hypotheek
2. The macroeconomic effects of the LTV and LTI ratios in Ireland
3. The Quality and Integrity of Residential Real Estate Appraisals,2019
4. The value of urban open space: Meta-analyses of contingent valuation and hedonic pricing results
Cited by
8 articles.
订阅此论文施引文献
订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献