• Home
  • Search
  • Real estate risk: heavy tail modelling using Excel
  • Cite Icon4
  • https://doi.org/10.1108/jpif-05-2014-0033Copy DOI Icon

Real estate risk: heavy tail modelling using Excel

Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
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.

Similar Papers
  • Research Article
  • Citations3

Building for a better hospital. Value-adding management & design of healthcare real estate

  • Jan 01, 2014
  • Architecture and the Built Environment
  • Johan Van Der Zwart
  • Book Chapter
  • Citations1

Real Estate Risk: Appraisal Capture

  • Jan 01, 2019
  • Volker Liermann +1
  • Research Article

Market Risk of Real Estate

  • Nov 09, 2012
  • SSRN Electronic Journal
  • Felix Schlumpf +2
  • Research Article

Comparing Commercial and Residential Real Estate Investment Opportunities and Risks in Modern Economic Times

  • Jan 01, 2025
  • Journal of Financial Risk Management
  • Denis Burke
  • Conference Article

Determining Risk Management Dynamics: An Analysis of Risk Perceptions of Real Estate Development Firms in Turkey

  • Jan 01, 2017
  • Akin Ozturk +3
  • Research Article
  • Citations6

Real Estate Exposure and Asset Intensity

  • Jan 01, 2000
  • Journal of Real Estate Portfolio Management
  • Seow-Eng Ong +1
  • Research Article
  • Citations27

Spatial decision support systems for effective ex-ante risk evaluation: An innovative model for improving the real estate redevelopment processes

  • Feb 24, 2023
  • Land Use Policy
  • Debora Anelli +1
  • Research Article
  • Citations9

Bank Risk Factors and Changing Risk Exposures of Banks: Capital Market Evidence Before and During the Financial Crisis

  • Aug 31, 2012
  • SSRN Electronic Journal
  • Wolfgang Bessler +1
  • Research Article

Real Estate as Part of an Investment Portfolio in Australia

  • Jun 20, 2010
  • SSRN Electronic Journal
  • Richard A Heaney +2
  • Research Article
  • Citations39

Risk and Return in Real Estate: Evidence from a Real Estate Stock Index

  • Sep 01, 1993
  • Financial Analysts Journal
  • Joseph Gyourko +1
  • Research Article
  • Citations13

Real Estate Economics, Management and Investments: New Perspectives and Frontiers

  • Mar 12, 2018
  • Buildings
  • Vincenzo Del Giudice +1
  • Research Article
  • Citations1

Climate Risk Assessment Framework in Real Estate: A Focus on Flooding

  • Nov 03, 2024
  • Sustainability
  • Shu-Han Wu +5
  • Conference Article

Performance Effects of Corporate Real Estate Ownership for the Retail Industry

  • Jan 01, 2019
  • Abraham Park +1
  • Research Article
  • Citations1

Impact of Institutional Investors on Real Estate Risk

  • Jan 01, 2021
  • SSRN Electronic Journal
  • Dragana Cvijanovic +2
  • Book Chapter

Chapter 6 - Uncertainty: Risk in real estate

  • Jan 01, 2005
  • Private Real Estate Investment
  • Roger J Brown
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.