Real estate risk: heavy tail modelling using Excel

Roger Brown and Beate Klingenberg

Journal of Property Investment & Finance, 2015, vol. 33, issue 4, 393-407

Abstract: Purpose - – The purpose of this paper is to present a practice briefing in the form of a user’s manual for Excel-based simulation of real estate risk. Based on a generic discounted cash flow model, the simulation incorporates the often ignored heavy tail behaviour of real estate investments, and consolidates Jensen’s inequality. The briefing attempts to explain a model that permits the user to decide whether to include extreme events in real estate risk modelling and how extreme these events may be. Practitioners can generate a variety of modelling outcomes and then choose risk comfort zones in which to contemplate a range of returns. Design/methodology/approach - – The paper provides an overview of the underlying mathematical concepts and challenges, as well as on the perspectives on their application from the current academic literature. It offers a step-by-step walk-through of the Excel model (the model being downloadable at:www.mathestate.com). Findings - – Existing models for real estate risk modelling fall short with respect to realistic simulation of the probability of extreme events due to challenges in the implementation of stable laws. These former barriers to the implementation of stable laws have been overcome by providing a unique combination of Excel-resident functionalities with a stable pseudo random number generator. Research limitations/implications - – Investment advisers no longer need expensive add-ins to estimate risk. The presented Excel model is more robust than common approaches as it considers distribution shapes that are not otherwise easily available. The only apparent limitation is that users need to be familiar with the most basic functionality of Excel. Practical implications - – Practitioners are provided with an easy-to-use Excel model that does not require further software add-ins. The model simulates real estate investment returns, based on a more realistic inclusion of risk behaviour. It allows specifying how much extreme value behaviour characterizes the volatility in future projections modelled to guide investment decisions. Social implications - – Risk is a cost to society. Many recent news events demonstrate the importance of including extreme values in modelling. The paper attempts to contribute to more realistic risk estimation in real estate investment. Originality/value - – This briefing introduces a real estate risk simulation model that includes using stable laws, using Excel, a familiar and widely used platform. Such a model has not previously been reported in the academic or practitioners’ literature.

Keywords: Heavy tails; Modelling risk; Spreadsheet models; Stable distributions; Cash flow model; Real estate investments; Stable laws (search for similar items in EconPapers)
Date: 2015
References: Add references at CitEc
Citations:

Downloads: (external link)
https://www.emerald.com/insight/content/doi/10.110 ... d&utm_campaign=repec (text/html)
https://www.emerald.com/insight/content/doi/10.110 ... d&utm_campaign=repec (application/pdf)
Access to full text is restricted to subscribers

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:eme:jpifpp:v:33:y:2015:i:4:p:393-407

DOI: 10.1108/JPIF-05-2014-0033

Access Statistics for this article

Journal of Property Investment & Finance is currently edited by Nick French

More articles in Journal of Property Investment & Finance from Emerald Group Publishing Limited
Bibliographic data for series maintained by Emerald Support ().