Real estate risk: heavy tail modelling using Excel

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.

Citation

Brown, R. and Klingenberg, B. (2015), "Real estate risk: heavy tail modelling using Excel", Journal of Property Investment & Finance, Vol. 33 No. 4, pp. 393-407. https://doi.org/10.1108/JPIF-05-2014-0033