A note on the use of spreadsheet optimisers in real estate analysis

Modern Portfolio Theory (MPT) has been advocated as a more rational approach to the construction of real estate portfolios. The application of MPT can now be achieved with relative ease using the powerful facilities of modern spreadsheet, and does not necessarily need specialist software. This capability is to be found in the use of an add-in Tool now found in several spreadsheets, called an Optimiser or Solver. The value in using this kind of more sophisticated analysis feature of spreadsheets is increasingly difficult to ignore. This paper examines the use of the spreadsheet Optimiser in handling asset allocation problems. Using the Markowitz Mean-Variance approach, the paper introduces the necessary calculations, and shows, by means of an elementary example implemented in Microsoft's Excel, how the Optimiser may be used. Emphasis is placed on understanding the inputs and outputs from the portfolio optimisation process, and the danger of treating the Optimiser as a Black Box is discussed.

Predicting the annual performance of UK real estate: timeliness versus coverage

The IPD Annual Index is the largest and most comprehensive Real Estate market index available in the UK Such coverage however inevitably leads to delays in publication. In contrast there are a number of quarterly and monthly indices which are published within days of the year end but which lack the coverage in terms of size and numbers of properties. This paper analyses these smaller but more timely indices to see whether such indices can be used to predict the performance of the IPD Annual Index. Using a number of measures of forecasting accuracy it is shown that the smaller indices provide unbiased and efficient predictions of the IPD Annual Index. Such indices also significantly outperform a naive no-change model. Although no one index performs significantly better than the others. The more timely indices however do not perfectly track the IPD Annual Index. As a result any short run predictions of performance will be subject to a degree of error. Nevertheless the more timely indices, although lacking authoritative coverage, provide a valuable service to investors giving good estimates of Real Estates performance well before the publication of the IPD Annual Index.

Real Estate & the New Economy: The Impact of Information and Communications Technology

Private sector commercial property represents some #400 bn, or 34% of total UK business assets and is a vital fabric for housing commercial enterprise. Yet social and economic forces for change, linked with new technology, are making owners and occupiers question the very nature and purpose of property and real estate.

The effects of information presentation on real estate market perceptions

The study seeks to identify systematic differences in perception of the real estate market caused by the frames through which people obtain market information. We operationalise the frames through manipulation of data presentation in a commercial real estate market report, selectively controlling time scale, proportionality distortion and negative value presentation. Our findings suggest that such differences are real and their effects should be taken into account in the design and interpretation of market reports.

An analysis of the determinants of cross-border real estate development flows

This paper investigates the scale and drivers of cross-border real estate development in western and central and eastern Europe (CEE). Drawing upon existing literature on the integration of international real estate markets, we make some inferences on expected patterns of cross-border real estate development from this literature review. The paper draws upon a transactions database in order to assess the penetration of national markets by international real estate developers. The determinants of cross-border transaction flows are modeled as a function the range of economic and real estate variables. Whilst western European markets tend to be dominated by local developers, much higher levels of market penetration by international real estate developers are found in the less mature markets of central and eastern Europe. Empirical modelling based on gravity model specifications reveal the importance of size of the economies, distance between countries, extent of globalization and EU membership as significant determinants of cross-border real estate development flow.

The impact of E-commerce on retail real estate in the UK

This article summarizes the main research findings from the first of a series of annual surveys conducted for the British Council of Shopping Centres. The study examines the changing pattern of retailing in the United Kingdom and provides an overview of key research from previous studies in both the U.K. and the United States. The main findings are then presented, including an examination of the impact of e-commerce on sales and rental values and on the future space and ownership / leasing requirements of U.K. retailers for 2000-2005. The impact on a shopping center in a case study town in the U.K. is also considered. The difficulties of isolating the impact of e-commerce from other forces for change in retailing are highlighted. In contrast to other viewpoints, the results show that e-commerce will not mean the death of conventional store-based U.K. retailing, although further benchmark research is needed.

Bias or rationality? The case of UK commercial real estate investment

Purpose – The purpose of this paper is to test the hypothesis that investment decision making in the UK direct property market does not conform to the assumption of economic rationality underpinning portfolio theory. Design/methodology/approach – The developing behavioural real estate paradigm is used to challenge the idea that investor “man” is able to perform with economic rationality, specifically with reference to the analysis of the spatial dispersion of the entire UK “investible stock” and “investible locations” against observed spatial patterns of institutional investment. Location quotients are derived, combining different data sets. Findings – Considerably greater variation in institutional property holdings is found across the UK than would be expected given the economic and stock characteristics of local areas. This appears to provide evidence of irrationality (in the strict traditional economic sense) in the behaviour of institutional investors, with possible herding underpinning levels of investment that cannot be explained otherwise. Research limitations/implications – Over time a lack of distinction has developed between the cause and effect of comparatively low levels of development and institutional property investment across the regions. A critical examination of decision making and behaviour in practice could break this cycle, and could in turn promote regional economic growth. Originality/value – The entire “population” of observations is used to demonstrate the relationships between economic theory and investor performance exploring, for the first time, stock and local area characteristics.

The performance effects of composition changes on sector specific stock indices: The case of European listed real estate

This paper examines the impact of changes in the composition of real estate stock indices, considering companies both joining and leaving the indices. Stocks that are newly included not only see a short-term increase in their share price, but trading volumes increase in a permanent fashion following the event. This highlights the importance of indices in not only a benchmarking context but also in enhancing investor awareness and aiding liquidity. By contrast, as anticipated, the share prices of firms removed from indices fall around the time of the index change. The fact that the changes in share prices, either upwards for index inclusions or downwards for deletions, are generally not reversed, would indicate that the movements are not purely due to price pressure, but rather are more consistent with the information content hypothesis. There is no evidence, however, that index changes significantly affect the volatility of price changes or their operating performances as measured by their earnings per share.

Broker use and the cost of liquidity in commercial real estate investment

Purpose – Commercial real estate is a highly specific asset: heterogeneous, indivisible and with less information transparency than most other commonly held investment assets. These attributes encourage the use of intermediaries during asset acquisition and disposal. However, there are few attempts to explain the use of different brokerage models (with differing costs) in different markets. This study aims to address this gap. Design/methodology/approach – The study analyses 9,338 real estate transactions in London and New York City from 2001 to 2011. Data are provided by Real Capital Analytics and cover over $450 billion of investments in this period. Brokerage trends in the two cities are compared and probit regressions are used to test whether the decision to transact with broker representation varies with investor or asset characteristics. Findings – Results indicate greater use of brokerage in London, especially by purchasers. This persists when data are disaggregated by sector, time or investor type, pointing to the role of local market culture and institutions in shaping brokerage models and transaction costs. Within each city, the nature of the investors involved seems to be a more significant influence on broker use than the characteristics of the assets being traded. Originality/value – Brokerage costs are the single largest non-tax charge to an investor when trading commercial real estate, yet there is little research in this area. This study examines the role of brokers and provides empirical evidence on factors that influence the use and mode of brokerage in two major investment destinations.

The influence of a decision support tool on real estate valuations

An appraisal task involves the rendering of market value, an unobservable and hypothetical construct. Direct feedback against this objective is typically not possible, so alternative feedback such as confirmation of previous appraised values may be employed. This may alter the appraiser’s perception of the valuation objective leading to divergence from the appraisal normative model. The real estate literature suggests appraisers have been susceptible to the influence of previous appraised values, often resulting in biased valuations. This research focuses on the efficacy of a decision support tool in eliminating or subduing this bias in the appraisal process.

Does connectivity add value to commercial real estate? The case of managed and conventional offices

This research is a preliminary study which examines the impact of connectivity on value in the managed office and conventional office sectors. The research is based on an extensive literature review, online survey and case studies carried out during 2005. The research shows, for the first time in the UK, how connectivity can increase value in office buildings, and how technology is priced in the market place.

A comparative analysis of the accuracy and uncertainty in real estate and macroeconomic forecasts

We compare and contrast the accuracy and uncertainty in forecasts of rents with those for a variety of macroeconomic series. The results show that in general forecasters tend to be marginally more accurate in the case of macro-economic series than with rents. In common across all of the series, forecasts tend to be smoothed with forecasters under-estimating performance during economic booms, and vice-versa in recessions We find that property forecasts are affected by economic uncertainty, as measured by disagreement across the macro-forecasters. Increased uncertainty leads to increased dispersion in the rental forecasts and a reduction in forecast accuracy.

On the predictive content of leading indicators: the case of U.S. real estate markets

This paper employs a probit and a Markov switching model using information from the Conference Board Leading Indicator and other predictor variables to forecast the signs of future rental growth in four key U.S. commercial rent series. We find that both approaches have considerable power to predict changes in the direction of commercial rents up to two years ahead, exhibiting strong improvements over a naïve model, especially for the warehouse and apartment sectors. We find that while the Markov switching model appears to be more successful, it lags behind actual turnarounds in market outcomes whereas the probit is able to detect whether rental growth will be positive or negative several quarters ahead.