Computing Markowitz efficient frontiers using a spreadsheet optimiser

Markowitz showed that assets can be combined to produce an 'Efficient' portfolio that will give the highest level of portfolio return for any level of portfolio risk, as measured by the variance or standard deviation. These portfolios can then be connected to generate what is termed an 'Efficient Frontier' (EF). In this paper we discuss the calculation of the Efficient Frontier for combinations of assets, again using the spreadsheet Optimiser. To illustrate the derivation of the Efficient Frontier, we use the data from the Investment Property Databank Long Term Index of Investment Returns for the period 1971 to 1993. Many investors might require a certain specific level of holding or a restriction on holdings in at least some of the assets. Such additional constraints may be readily incorporated into the model to generate a constrained EF with upper and/or lower bounds. This can then be compared with the unconstrained EF to see whether the reduction in return is acceptable. To see the effect that these additional constraints may have, we adopt a fairly typical pension fund profile, with no more than 20% of the total held in Property. The paper shows that it is now relatively easy to use the Optimiser available in at least one spreadsheet (EXCEL) to calculate efficient portfolios for various levels of risk and return, both constrained and unconstrained, so as to be able to generate any number of Efficient Frontiers.

Occupational futures? Divesting real estate and corporate PFI

Property ownership can tie up large amounts of capital and management energy that business could employ more productively elsewhere. Competitive pressures, accounting changes and increasingly sophisticated occupier requirements are building demand for new and innovative ways to satisfy corporate occupation needs. The investment climate is also changing. Falling interest rates and falling inflation can be expected to undermine returns from the traditional FRI lease. In future, investment returns will be more dependent on active and innovative management geared to the needs of occupiers on whom income depends. Occupier and investor interests, therefore, look set to coincide, but unlocking the potential for both parties will depend on developing new finance and investment vehicles that align their respective needs. In the UK, examples include PFI in the public sector and off-balance sheet financing in the private sector. In the USA, “synthetic lease” structures have also become popular. Growing investment market experience in assessing risks and returns suggests scope for further innovative arrangements in the corporate sector. But how can such arrangements be structured? What are the risks, drivers and barriers?

Holding periods and investment performance: analysing UK office returns 1983-2003

Drawing on a unique database of office properties constructed for Gerald Eve by IPD, this paper examines the holding periods of individual office properties sold between 1983 and 2003. It quantifies the holding periods of sold properties and examines the relationship between the holding period and investment performance. Across the range of holding periods, excess returns (performance relative to the market) are evenly distributed. There are as many winners as there are losers. The distribution of excess returns over different holding periods is widely spread with the risk of under-performance greater over short holding periods. Over the longer term, excess performance is confined to a narrow range and individual returns are more likely to perform in line with the market as a whole.

Direct investment in real estate

Momentum strategies have the potential to generate extra profits in private real estate markets. Tests of a variety of frequencies of portfolio reweighting identify periods of winner and loser performance. There are strong potential gains from momentum strategies that are based on prior returns over a 6- to 12-month period. Whether these gains are attainable for real-world investors depends on transaction costs, but some momentum strategies do produce net excess returns. The findings hold even if returns are unsmoothed to reflect underlying market prices.

An analysis of commercial real estate returns: is there a smoothing puzzle?

In this paper we investigate the commonly used autoregressive filter method of adjusting appraisal-based real estate returns to correct for the perceived biases induced in the appraisal process. Since the early work by Geltner (1989), many papers have been written on this topic but remarkably few have considered the relationship between smoothing at the individual property level and the amount of persistence in the aggregate appraised-based index. To investigate this issue in more detail we analyse a sample of individual property level appraisal data from the Investment Property Database (IPD). We find that commonly used unsmoothing estimates overstate the extent of smoothing that takes place at the individual property level. There is also strong support for an ARFIMA representation of appraisal returns.

The impact of country risk on international real estate returns

Commercial real estate investors have well-established methods to assess the risks of a property investment in their home country. However, when the investment decision is overseas another dimension of uncertainty overlays the analysis. This additional dimension, typically called country risk, encompasses the uncertainty of achieving expected financial results solely due to factors relating to the investment’s location in another country. However, very little has been done to examine the effects of country risk on international real estate returns, even though in international investment decisions considerations of country risk dominate asset investment decisions. This study extends the literature on international real estate diversification by empirically estimating the impact of country risk, as measured by Euromoney, on the direct real estate returns of 15 countries over the period 1998-2004, using a pooled regression analysis approach. The results suggest that country risk data may help investor’s in their international real estate decisions since the country risk data shows a significant and consistent impact on real estate return performance.

Serial persistence in individual real estate returns in the UK

Persistence of property returns is a topic of perennial interest to fund managers as it suggests that choosing those properties that will perform well in the future is as simple as looking at those that performed well in the past. Consequently, much effort has been expended to determine if such a rule exists in the real estate market. This paper extends earlier studies in US, Australian, and UK markets in two ways. First, this study applies the same methodology originally used in Young and Graff (1996) making the results directly comparable with those in the US and Australian property markets. Second, this study uses a much longer and larger database covering all commercial property data available from the Investment Property Databank (IPD), for the years 1981 to 2002 for as many as 216,758 individual property returns. While the performance results of this study mimic the US and Australian results of greater persistence in the extreme first and fourth quartiles, they also evidence persistence in the moderate second and third quartiles, a notable departure from previous studies. Likewise patterns across property type, location, time, and holding period are remarkably similar leading to the conjecture that behaviors in the practice of commercial real estate investment management are themselves deeply rooted and persistent and perhaps influenced for good or ill by agency effects

Country, sector and regional factors in European property returns

For those portfolio managers who follow a top-down approach to fund management when they are trying to develop a pan-European investment strategy they need to know which are the most important factors affecting property returns, so as to concentrate their management and research efforts accordingly. In order to examine this issue this paper examines the relative importance of country, sector and regional effects in determining property returns across Europe using the largest database of individual property returns currently available. Using annual data over the period 1996 to 2002 for a sample of over 25,000 properties the results show that the country-specific effects dominate sector-specific factors, which in turn dominate the regional-specific factors. This is true even for different sub-sets of countries and sectors. In other words, real estate returns are mainly determined by local (country specific) conditions and are only mildly affected by general European factors. Thus, for those institutional investors contemplating investment into Europe the first level of analysis must be an examination of the individual countries, followed by the prospects of the property sectors within the country and then an assessment of the differences in expected performance between the main city and the rest of the country.

An analysis of commercial real estate returns: an anatomy of smoothing in asset and index returns

In this article, we investigate the commonly used autoregressive filter method of adjusting appraisal-based real estate returns to correct for the perceived biases induced in the appraisal process. Many articles have been written on appraisal smoothing but remarkably few have considered the relationship between smoothing at the individual property level and the amount of persistence in the aggregate appraisal-based index. To investigate this issue we analyze a large sample of appraisal data at the individual property level from the Investment Property Databank. We find that commonly used unsmoothing estimates at the index level overstate the extent of smoothing that takes place at the individual property level. There is also strong support for an ARFIMA representation of appraisal returns at the index level and an ARMA model at the individual property level.

Hedging effectiveness of total returns swaps: application to the Japanese market

The development of the real estate swap market offers many opportunities for investors to adjust the exposure of their portfolios to real estate. A number of OTC transactions have been observed in markets around the world. In this paper we examine the Japanese commercial real estate market from the point of view of an investor holding a portfolio of properties seeking to reduce the portfolio exposure to the real estate market by swapping an index of real estate for LIBOR. This paper explores the practicalities of hedging portfolios comprising small numbers of individual properties against an appropriate index. We use the returns from 74 properties owned by Japanese Real Estate Investment Trusts over the period up to September 2007. The paper also discusses and applies the appropriate stochastic processes required to model real estate returns in this application and presents alternative ways of reporting hedging effectiveness. We find that the development of the derivative does provide the capacity for hedging market risk but that the effectiveness of the hedge varies considerably over time. We explore the factors that cause this variability.

Persistence of UK Real Estate returns: a Markov chain analysis

The persistence of investment performance is a topic of perennial interest to investors. Efficient Markets theory tells us that past performance can not be used to predict future performance yet investors appear to be influenced by the historical performance in making their investment allocation decisions. The problem has been of particular interest to investors in real estate; not least because reported returns from investment in real estate are serially correlated thus implying some persistence in investment performance. This paper applies the established approach of Markov Chain analysis to investigate the relationship between past and present performance of UK real estate over the period 1981 to 1996. The data are analysed by sector, region and size. Furthermore some variations in investment performance classification are reported and the results are shown to be robust.

Fixing the currency: analysing the implications for property investment performance

This paper analyses the historic effects of exchange rate movements on returns, risk and diversification of office markets within the Euro zone in order to gain insights into the investment consequences of conversion to a fixed rate currency regime. The data used in the study represents annual office rental growth rates for 22 European cities from nine European Union countries between 1985 and 1996. Relative performance is reported in terms of domestic currency and in terms of deutsche marks. The evidence presented suggests that Euro zone property investors in ‘southern’ countries are now protected from short term jump risk associated with flexible peg currency arrangements and medium/long-term currency volatility. Historically exchange rate movements have produced decreases in returns and increases in volatility. For northern ‘bloc’ cities, the effects of fixing the exchange rate are minimal. For these cities, national exchange rate fluctuations against the deutsche mark have been minor and the resultant implications for property risk and return to non-domestic SCA investors have been negligible. Moreover, although previous research would suggest that the effect of currency volatility is to decrease market correlation, this cannot be observed within the Euro zone.

International investment, ownership and risk in the City of London office market: an analysis of trends 1972-1997

Office returns in the City of London are more volatile than in other UK markets. This volatility may reflect fluctuations in capital flows associated with changing patterns of ownership and the growing linkage between real estate and financial markets in the City. Using current and historical data, patterns of ownership in the City are investigated. They reveal that overseas ownership has grown markedly since 1985, that owners are predominantly FIRE sector firms and that there are strong links between ownership and occupation. This raises concerns about future volatility and systemic risk.