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.

The future returns for property required by UK pension funds

In the 1970s Real Estate represented over 17% of the average pension funds total assets. Today such funds hold less than 4%, a figure not seen since the 1960s. This reduction in Real Estate holdings is mainly attributable to the relatively poor performance of Real Estate against other asset classes since the 1980s. Whether pension funds will increase their holding at any point in the future depends therefore on the expected return of Real Estate by comparison with that required to justify a particular asset holding. Using the technique of Modern Portfolio Theory (MPT), this paper assesses the required return that Real Estate would have to offer to justify a 15% holding in a mixed asset portfolio. This figure and the risk/return characteristics of the major asset classes is taken from survey data. Under a number of scenarios it is found that Real Estate can play a part in a mixed asset portfolio at the 15% level. In some cases however, the expected returns of Real Estate are not sufficient to justify a weight of 15% in this asset.

The future returns for property required by UK pension funds: the BHS data

Previous studies of the place of Property in the multi-asset portfolio have generally relied on historical data, and have been concerned with the supposed risk reduction effects that Property would have on such portfolios. In this paper a different approach has been taken. Not only are expectations data used, but we have also concentrated upon the required return that Property would have to offer to achieve a holding of 15% in typical UK pension fund portfolios. Using two benchmark portfolios for pension funds, we have shown that Property's required return is less than that expected, and therefore it could justify a 15% holding.

Required returns for real estate in UK pension fund portfolios

The position of Real Estate within a multi-asset portfolio has received considerable attention recently. Previous research has concentrated on the percentage holding property would achieve given its risk/return characteristics. Such studies have invariably used Modern Portfolio Theory and these approaches have been criticised for both the quality of the real estate data and problems with the methodology itself. The first problem is now well understood, and the second can be addressed by the use of realistic constraints on asset holdings. This paper takes a different approach. We determine the level of return that Real Estate needs to achieve to justify an allocation within the multi asset portfolio. In order to test the importance of the quality of the data we use historic appraisal based and desmoothed returns to examine the sensitivity of the results. Consideration is also given to the Holding period and the imposition of realistic constraints on the asset holdings in order to model portfolios held by pension fund investors. We conclude, using several benchmark levels of portfolio risk and return, that using appraisal based data the required level of return for Real Estate was less than that achieved over the period 1972-1993. The use of desmoothed series can reverse this result at the highest levels of desmoothing although within a restricted holding period Real Estate offered returns in excess of those required to enter the portfolio and might have a role to play in the multi-asset portfolio.

Changes in the relative importance of sector and regional Factors: 1987-2002

A stylised fact in the real estate portfolio diversification literature is that sector (property-type) effects are relatively more important than regional (geographical) factors in determining property returns. Thus, for those portfolio managers who follow a top-down approach to portfolio management, they should first choose in which sectors to invest and then select the best properties in each market. However, the question arises as to whether the dominance of the sector effects relative to regional effects is constant. If not property fund managers will need to take account of regional effects in developing their portfolio strategy. We find the results show that the sector-specific factors dominate the regional-specific factors for the vast majority of the time. Nonetheless, there are periods when the regional factors are of equal or greater importance than the sector effects. In particular, the sector effects tend to dominate during volatile periods of the real estate cycle; however, during calmer periods the sector and regional effects are of equal importance. These findings suggest that the sector effects are still the most important aspect in the development of an active portfolio strategy.

Testing the statistical significance of sector & regional diversification

The question as to whether it is better to diversify a real estate portfolio within a property type across the regions or within a region across the property types is one of continuing interest for academics and practitioners alike. The current study, however, is somewhat different from the usual sector/regional analysis taking account of the fact that holdings in the UK real estate market are heavily concentrated in a single region, London. As a result this study is designed to investigate whether a real estate fund manager can obtain a statistically significant improvement in risk/return performance from extending out of a London based portfolio into firstly the rest of the South East of England and then into the remainder of the UK, or whether the manger would be better off staying within London and diversifying across the various property types. The results indicating that staying within London and diversifying across the various property types may offer performance comparable with regional diversification, although this conclusion largely depends on the time period and the fund manager’s ability to diversify efficiently.

Multiple-project discount rates for cost-benefit analysis in construction projects: A formal risk model for microgeneration renewable energy technologies

The traditional economic approach for appraising the costs and benefits of construction project Net Present Values involves the calculation of net returns for each investment option under different discount rates. An alternative approach consists of multiple-project discount rates based on risk modelling. The example of a portfolio of microgeneration renewable energy technology (MRET) is presented to demonstrate that risks and future available budget for re-investment can be taken into account when setting discount rates for construction project specifications in presence of uncertainty. A formal demonstration is carried out through a reversed intertemporal approach of applied general equilibrium. It is demonstrated that risk and the estimated available budget for future re-investment can be included in the simultaneous assessment of the costs and benefits of multiple projects.

Characterization of safe nanostructured polymeric materials

The addition of small quantities of nanoparticles to conventional and sustainable thermoplastics leads to property enhancements with considerable potential in many areas of applications including food packaging 1, lightweight composites and high performance materials 2. In the case of sustainable polymers 3, the addition of nanoparticles may well sufficiently enhance properties such that the portfolio of possible applications is greatly increased. Most engineered nanoparticles are highly stable and these exist as nanoparticles prior to compounding with the polymer resin. They remain as nanoparticles during the active use of the packaging material as well as in the subsequent waste and recycling streams. It is also possible to construct the nanoparticles within the polymer films during processing from organic compounds selected to present minimal or no potential health hazards 4. In both cases the characterisation of the resultant nanostructured polymers presents a number of challenges. Foremost amongst these are the coupled challenges of the nanoscale of the particles and the low fraction present in the polymer matrix. Very low fractions of nanoparticles are only effective if the dispersion of the particles is good. This continues to be an issue in the process engineering but of course bad dispersion is much easier to see than good dispersion. In this presentation we show the merits of a combined scattering (neutron and x-ray) and microscopy (SEM, TEM, AFM) approach. We explore this methodology using rod like, plate like and spheroidal particles including metallic particles, plate-like and rod-like clay dispersions and nanoscale particles based on carbon such as nanotubes and graphene flakes. We will draw on a range of material systems, many explored in partnership with other members of Napolynet. The value of adding nanoscale particles is that the scale matches the scale of the structure in the polymer matrix. Although this can lead to difficulties in separating the effects in scattering experiments, the result in morphological studies means that both the nanoparticles and the polymer morphology are revealed.

The impact of price promotions on producer strategies in markets with large product heterogeneity

Although current research indicates that increasing the number of options has negative effects on the cognitive ability of consumers, little understanding has been given to the consequences on producers and their strategic behavior. This article tests whether a large portfolio of products is beneficial to producers by observing UK consumer response to price promotions. The article shows that discounts induce mainly segment switching (74% of the total impact), with a limited effect on stockpiling (26%) and no impact on purchase incidence. Consequently, consumers prefer to “follow the discount” rather than purchase multiple units of the same wine. This result seems to explain the current structure of the market, and suggests that discounts may conflict with segment loyalty, a situation that disfavors producers, particularly in very populated segments. Results also casts doubts on the economic sustainability of competition based on an intense product differentiation in the wine sector.

Performance drivers of UK unlisted property funds

An unlisted property fund is a private investment vehicle which aims to provide direct property total returns and may also employ financial leverage which will accentuate performance. They have become a far more prevalent institutional property investment conduit since the early 2000’s. Investors have been primarily attracted to them due to the ease of executing a property exposure, both domestically and internationally, and for their diversification benefits given the capital intensive nature of constructing a well diversified commercial property investment portfolio. However, despite their greater prominence there has been little academic research conducted on the performance and risks of unlisted property fund investments. This can be attributed to a paucity of available data and limited time series where it exists. In this study we have made use of a unique dataset of institutional UK unlisted non-listed property funds over the period 2003Q4 to 2011Q4, using a panel modelling framework in order to determine the key factors which impact on fund performance. The sample provided a rich set of unlisted property fund factors including market exposures, direct property characteristics and the level of financial leverage employed. The findings from the panel regression analysis show that a small number of variables are able to account for the performance of unlisted property funds. These variables should be considered by investors when assessing the risk and return of these vehicles. The impact of financial leverage upon the performance of these vehicles through the recent global financial crisis and subsequent UK commercial property market downturn was also studied. The findings indicate a significant asymmetric effect of employing debt finance within unlisted property funds.

Aligning asset allocation and real estate investment: some lessons from the last cycle

Asset allocation is concerned with the development of multi--‐asset portfolio strategies that are likely to meet an investor’s objectives based on the interaction of expected returns, risk, correlation and implementation from a range of distinct asset classes or beta sources. Challenges associated with the discipline are often particularly significant in private markets. Specifically, composition differences between the ‘index’ or ‘benchmark’ universe and the investible universe mean that there can often be substantial and meaningful deviations between the investment characteristics implied in asset allocation decisions and those delivered by investment teams. For example, while allocation decisions are often based on relatively low--‐risk diversified real estate ‘equity’ exposure, implementation decisions frequently include exposure to higher risk forms of the asset class as well as investments in debt based instruments. These differences can have a meaningful impact on the contribution of the asset class to the overall portfolio and, therefore, lead to a potential misalignment between asset allocation decisions and implementation. Despite this, the key conclusion from this paper is not that real estate investors should become slaves to a narrowly defined mandate based on IPD / NCREIF or other forms of benchmark replication. The discussion suggests that such an approach would likely lead to the underutilization of real estate in multi--‐asset portfolio strategies. Instead, it is that to achieve asset allocation alignment, real estate exposure should be divided into multiple pools representing distinct forms of the asset class. In addition, the paper suggests that associated investment guidelines and processes should be collaborative and reflect the portfolio wide asset allocation objectives of each pool. Further, where appropriate they should specifically target potential for ‘additional’ beta or, more marginally, ‘alpha’.

International office investment in global cities: the production of financial space and systemic risk

The paper explores the relationships between UK commercial real estate and regional economic development as a foundation for the analysis of the role of real estate investment in local economic development. Linkages between economic growth, development, real estate performance and investment allocations are documented. Long-run regional property performance is not the product of long-run economic growth, and weakly related to indicators of long-run supply and demand. Changes in regional portfolio weights seem driven by neither market performance nor underlying fundamentals. In the short run, regional investment shifts show no clear leads or lags with market performance.

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.

Private climate change reporting: an emerging discourse of risk and opportunity?

Purpose – This paper aims to explore the nature of the emerging discourse of private climate change reporting, which takes place in one-on-one meetings between institutional investors and their investee companies. Design/methodology/approach – Semi-structured interviews were conducted with representatives from 20 UK investment institutions to derive data which was then coded and analysed, in order to derive a picture of the emerging discourse of private climate change reporting, using an interpretive methodological approach, in addition to explorative analysis using NVivo software. Findings – The authors find that private climate change reporting is dominated by a discourse of risk and risk management. This emerging risk discourse derives from institutional investors' belief that climate change represents a material risk, that it is the most salient sustainability issue, and that their clients require them to manage climate change-related risk within their portfolio investment. It is found that institutional investors are using the private reporting process to compensate for the acknowledged inadequacies of public climate change reporting. Contrary to evidence indicating corporate capture of public sustainability reporting, these findings suggest that the emerging private climate change reporting discourse is being captured by the institutional investment community. There is also evidence of an emerging discourse of opportunity in private climate change reporting as the institutional investors are increasingly aware of a range of ways in which climate change presents material opportunities for their investee companies to exploit. Lastly, the authors find an absence of any ethical discourse, such that private climate change reporting reinforces rather than challenges the “business case” status quo. Originality/value – Although there is a wealth of sustainability reporting research, there is no academic research on private climate change reporting. This paper attempts to fill this gap by providing rich interview evidence regarding the nature of the emerging private climate change reporting discourse.

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.