Reducing property valuation bias through Random Forests: Predicting prices for public asset optimization

Authors

  • Edy Riyanto Politeknik Keuangan Negara (PKN) STAN
  • Imanishi Dwi Alfianyah Directorate General of State Assets Management (DJKN), Ministry of Finance of the Republic of Indonesia

DOI:

https://doi.org/10.12928/optimum.v16i1.13186

Keywords:

Random Forest Regression, Machine Learning, Cross-Validation, State Asset Optimization, Valuation

Abstract

This study applies supervised machine learning, specifically the Random Forest regression algorithm, to predict office rental prices in DKI Jakarta. A dataset was compiled via web scraping of online property listings, incorporating features such as location, office area, number of floors, lifts, parking capacity, and building grade. Data preprocessing involved handling missing values, removing outliers, applying one-hot encoding, and normalizing the data to ensure consistency. The model was developed using the CRISP-DM framework and evaluated through an 80:20 train-test split and 10-fold cross-validation. Performance metrics included Root Mean Squared Error (RMSE) and R². The Random Forest model achieved high accuracy, with cross-validation yielding an R² of 0.934 and an RMSE of Rp16.288 per m²/month. SHAP analysis revealed that lifts, floors, parking, office area, and building grade significantly influenced predictions. Bias analysis indicated a tendency to underestimate rents for grade B and C buildings. The model was also simulated to estimate rental values of underutilized government-owned offices, supporting asset optimization amid the planned capital relocation. These results demonstrate the potential of machine learning to improve valuation practices, reduce bias, and enhance decision-making in public asset management.

References

Adams, D., & Tolson, S. (2019). Valuation in the dark: Constructing perception of normality in failing markets. Town Planning Review, 90(4), 383-406. https://doi.org/10.3828/tpr.2019.23

Antipov, E. A., & Pokryshevskaya, E. B. (2012). Mass appraisal of residential apartments: An application of random forest for valuation and a CART-based approach for model interpretation. Expert Systems with Applications, 39(2), 1772-1778. https://doi.org/10.1016/j.eswa.2011.08.077

Bowles, G., McAllister, P., & Tarbert, H. (2001). An assessment of the impact of valuation error on property investment performance measurement. Journal of Property Investment & Finance, 19(2), 139-155. https://doi.org/10.1108/14635780110383695

Čeh, M., Kilibarda, M., Lisec, A., & Bajat, B. (2018). Estimating the performance of Random Forest versus multiple regression for predicting prices of apartments. ISPRS International Journal of Geo-Information, 7(5), 168-180. https://doi.org/10.3390/ijgi7050168

Colliers International. (2024). Jakarta office market report Q1 2024. Colliers International.

Crosby, N., Hughes, C., & Murdoch, S. (2006). Exit strategies for business tenants. Journal of Property Research, 23(3), 215-236. https://doi.org/10.1080/09599910600933848

DJKN. (2020). Guidelines for the valuation of state property. Ministry of Finance of the Republic of Indonesia.

Fitri, E. (2023). Comparative analysis of linear regression methods, random forest regression, and gradient boosted trees regression for predicting home prices. Journal of Applied Computer Science and Technology, 4(1), 58-64. https://doi.org/10.52158/jacost.v4i1.491

French, N., & Gabrielli, L. (2004). The uncertainty of valuation. Journal of Property Investment & Finance, 22(4), 329-346. https://doi.org/10.1108/14635780410569470

Geltner, D. (1997). The use of appraisal in portfolio valuation and index construction. Journal of Property Investment & Finance, 15(5), 423-447. https://doi.org/10.1108/14635789710189191

Ja'afar, N. S., Mohamad, J., & Ismail, S. (2021). Machine learning for property price prediction and price valuation: A systematic literature review. Planning Malaysia, 19(4), 56-70. https://doi.org/10.21837/pm.v19i17.1018

James, G., Witten, D., Hastie, T., & Tibshirani, R. (2013). An introduction to statistical learning: With applications in R. Springer. https://doi.org/10.1007/978-1-4614-7138-7

Knight Frank. (2024). Greater Jakarta property market outlook. Knight Frank.

Le, V. T., Nguyen, H. Q., & Nguyen, V. T. (2018). Analysis of factors affecting Ho Chi Minh city's office rental prices using a hedonic model. MATEC Web of Conferences, 193, 05041. https://doi.org/10.1051/matecconf/201819305041

Levantesi, S., & Piscopo, G. (2020). The importance of economic variables on the London real estate market: A Random Forest approach. Risks, 8(4), 112-124. https://doi.org/10.3390/risks8040112

Lorenz, D., & Lützkendorf, T. (2008). Sustainability in property valuation: Theory and practice. Journal of Property Investment & Finance, 26(6), 482-521. https://doi.org/10.1108/14635780810908361

MAPPI. (2018). Kode Etik Penilai Indonesia dan Standar Penilaian Indonesia (KEPI & SPI) Edisi VII-2018. Masyarakat Profesi Penilai Indonesia.

Mohd, T., Harussani, M., & Masrom, S. (2022). Rapid modelling of machine learning in predicting office rental price. International Journal of Advanced Computer Science and Applications, 13(12), 567-573. https://doi.org/10.14569/IJACSA.2022.0131271

Mulyadi, E., Miyasto, H., & Sugiyanto, F. X. (2015). Model nilai sewa ruang perkantoran pada kawasan pusat bisnis di Jakarta. Jurnal Ekonomi dan Bisnis Indonesia, 30(3), 245-258. https://doi.org/10.22146/jieb.6680

Nwosu, A. E. (2019). Valuation inaccuracy: Implications on commercial property investment performance in Akure. Nigeria. Journal of African Real Estate Research, 4(1), 92-107. https://doi.org/10.15641/jarer.v0i0.712

Restiatun. (2021). Determinants of the office space rent rate in Jakarta, Indonesia. Indian Journal of Economics and Business, 20(3), 765-776.

RICS. (2015). Our changing world: Let us be ready. Royal Institution of Chartered Surveyors. Washington DC.

Riyanto, E. (2021). Identification of factors that affect residential property value based on the perception of government appraisers. Info Artha, 5(1), 55-65. https://doi.org/10.31092/jia.v5i1.1176

Shimizu, C., & Nishimura, K. G. (2006). Biases in Appraisal Land Price Information: The Case of Japan. Journal of Property Investment & Finance, 24(2), 150-175. https://doi.org/10.1108/14635780610655085

Downloads

Published

2026-03-09

Issue

Section

Articles