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: 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.

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.

The child and imperial return: the mystery of Edwin Drood

The Mystery of Edwin Drood has often been read as an Imperial text, just as Dickens's work has repeatedly been considered in relation to its construction of childhood. Despite this, 'the child' has either been avoided in criticism of Dickens's last novel, or has actively been read as absent. In this essay, I return the ‘repressed’ child to a reading of Drood, and through this disrupt appeals to a hard-impacted Imperial structure I understand to be made within criticism of it.

Domestic and foreign bias in global real estate mutual fund investment allocations

The purpose of the study is to seek a better understanding of the investment allocation behaviour of the real estate mutual funds by focusing on asset allocation at the country level. Analysing the country allocation of 553 real estate mutual funds domiciled in 20 countries, we attempt to trace how investment bias exists across countries and affects their country allocations. Our results evidence the existence of disproportionate country allocation to their domestic markets (domestic bias) and to each foreign market (foreign bias). We also find each bias is influenced by different sets of variables: real estate market influences for domestic bias and familiarity influences for foreign bias. This difference in factors influential for each bias in part explains the conflated relationship between the two biases.

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.

Can company-fund manager meetings convey informational benefits? Exploring the rationalisation of equity investment decision making by UK fund managers

Conventional economic theory, applied to information released by listed companies, equates ‘useful’ with ‘price-sensitive’. Stock exchange rules accordingly prohibit the selec- tive, private communication of price-sensitive information. Yet, even in the absence of such communication, UK equity fund managers routinely meet privately with the senior execu- tives of the companies in which they invest. Moreover, they consider these brief, formal and formulaic meetings to be their most important sources of investment information. In this paper we ask how that can be. Drawing on interview and observation data with fund managers and CFOs, we find evidence for three, non-mutually exclusive explanations: that the characterisation of information in conventional economic theory is too restricted, that fund managers fail to act with the rationality that conventional economic theory assumes, and/or that the primary value of the meetings for fund managers is not related to their investment decision making but to the claims of superior knowledge made to clients in marketing their active fund management expertise. Our findings suggest a disconnect between economic theory and economic policy based on that theory, as well as a corre- sponding limitation in research studies that test information-usefulness by assuming it to be synonymous with price-sensitivity. We draw implications for further research into the role of tacit knowledge in equity investment decision-making, and also into the effects of the principal–agent relationship between fund managers and their clients.

Inflammatory modulation of exercise salience: using hormesis to return to a healthy lifestyle

Most of the human population in the western world has access to unlimited calories and leads an increasingly sedentary lifestyle. The propensity to undertake voluntary exercise or indulge in spontaneous physical exercise, which might be termed "exercise salience", is drawing increased scientific attention. Despite its genetic aspects, this complex behaviour is clearly modulated by the environment and influenced by physiological states. Inflammation is often overlooked as one of these conditions even though it is known to induce a state of reduced mobility. Chronic subclinical inflammation is associated with the metabolic syndrome; a largely lifestyle-induced disease which can lead to decreased exercise salience. The result is a vicious cycle that increases oxidative stress and reduces metabolic flexibility and perpetuates the disease state. In contrast, hormetic stimuli can induce an anti-inflammatory phenotype, thereby enhancing exercise salience, leading to greater biological fitness and improved functional longevity. One general consequence of hormesis is upregulation of mitochondrial function and resistance to oxidative stress. Examples of hormetic factors include calorie restriction, extreme environmental temperatures, physical activity and polyphenols. The hormetic modulation of inflammation, and thus, exercise salience, may help to explain the highly heterogeneous expression of voluntary exercise behaviour and therefore body composition phenotypes of humans living in similar obesogenic environments.

Linear and non-linear transmission of equity return volatility: evidence from the US, Japan and Australia

This paper models the transmission of shocks between the US, Japanese and Australian equity markets. Tests for the existence of linear and non-linear transmission of volatility across the markets are performed using parametric and non-parametric techniques. In particular the size and sign of return innovations are important factors in determining the degree of spillovers in volatility. It is found that a multivariate asymmetric GARCH formulation can explain almost all of the non-linear causality between markets. These results have important implications for the construction of models and forecasts of international equity returns.

Individual assets, market structure and the drivers of return

Much UK research and market practice on portfolio strategy and performance benchmarking relies on a sector‐geography subdivision of properties. Prior tests of the appropriateness of such divisions have generally relied on aggregated or hypothetical return data. However, the results found in aggregate may not hold when individual buildings are considered. This paper makes use of a dataset of individual UK property returns. A series of multivariate exploratory statistical techniques are utilised to test whether the return behaviour of individual properties conforms to their a priori grouping. The results suggest strongly that neither standard sector nor regional classifications provide a clear demarcation of individual building performance. This has important implications for both portfolio strategy and performance measurement and benchmarking. However, there do appear to be size and yield effects that help explain return behaviour at the property level.