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.

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.

Livestock and learning: evaluation of a prototype 3D virtual learning environment for livestock practitioners in India and Bolivia

Livestock are a key asset for the global poor. However, access to relevant information is a critical issue for both the poor and the practitioners who serve them. Therefore, the authors describe a web-based Virtual Learning Environment to disseminate educational materials on priority animal health constraints in Bolivia and India. The aim was to explore demand for 3D among development practitioners in the South. Two wider arguments from the ICT4D literature framed the analysis: the concept of 3D as a ‘lead technology’ and the relevance of Internet skills to the adoption of a 3D format. The results illustrated that neither construct influenced demand. Rather, study participants were ready adopters but desired greater levels of interaction and thereby, a more collaborative learning environment. Therefore, 3D has a number of potential benefits to enhance knowledge sharing among community practitioners in the Global South.

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.

Towards a semiotic approach to practice-oriented knowledge transfer

With the rapid growth of information and technology, knowledge is a valuable asset in organisation which has become significant as a strategic resource. Many studies have focused on managing knowledge in organisations. In particular, knowledge transfer has become a significant issue concerned with the movement of knowledge across organisational boundaries. It enables the exploitation and application of existing knowledge for other organisations, reducing the time of creating knowledge, and minimising the cost of organisational learning. One way to capture knowledge in a transferrable form is through practice. In this paper, we discuss how organisations can transfer knowledge through practice effectively and propose a model for a semiotic approach to practice-oriented knowledge transfer. In this model, practice is treated as a sign that represents knowledge, and its localisation is analysed as a semiotic process.

Measuring significant variability characteristics: An assessment of three UK renewables

The variability of renewable energy is widely recognised as a challenge for integrating high levels of renewable generation into electricity systems. However, to explore its implications effectively, variability itself should first be clearly understood. This is particularly true for national electricity systems with high planned penetration of renewables and limited interconnection such as the UK. Variability cannot be considered as a distinct resource property with a single measurable parameter, but is a multi-faceted concept best described by a range of distinct characteristics. This paper identifies relevant characteristics of variability, and considers their implications for energy research. This is done through analysis of wind, solar and tidal current resources, with a primary focus on the Bristol Channel region in the UK. The relationship with electricity demand is considered, alongside the potential benefits of resource diversity. Analysis is presented in terms of persistence, distribution, frequency and correlation between supply and demand. Marked differences are seen between the behaviours of the individual resources, and these give rise to a range of different implications for system integration. Wind shows strong persistence and a useful seasonal pattern, but also a high spread in energy levels at timescales beyond one or two days. The solar resource is most closely correlated with electricity demand, but is undermined by night-time zero values and an even greater spread of monthly energy delivered than wind. In contrast, the tidal resource exhibits very low persistence, but also much greater consistency in energy values assessed across monthly time scales. Whilst this paper focuses primarily on the behaviour of resources, it is noted that discrete variability characteristics can be related to different system impacts. Persistence and predictability are relevant for system balancing, whereas statistical distribution is more relevant when exploring issues of asset utilisation and energy curtailment. Areas of further research are also identified, including the need to assess the value of predictability in relation to other characteristics.

Risk premia in covered bond markets

The authors empirically explore risk premia in mortgage covered bond markets. Using a large panel dataset of covered bond asset swap spreads, they study the impact of different legal and economic environments. Conducting an in-depth analysis of this market, the authors find significant but small differences between countries during normal market periods. However, these differences are much stronger during times of economic crisis. Moreover, they find that developments in the real estate market are of relatively little importance during stable market periods. During economic distress, however, they are of high importance for explaining risk premia in covered bond markets

The dynamics of commodity prices

In this paper we study the stochastic behavior of the prices and volatilities of a sample of six of the most important commodity markets and we compare these properties with those of the equity market. we observe a substantial degree of heterogeneity in the behavior of the series. Our findings show that it is inappropriate to treat different kinds of commodities as a single asset class as is frequently the case in the academic literature and in the industry. We demonstrate that commodities can be a useful diversifier of equity volatility as well as equity returns. Options pricing and hedging applications exemplify the economic impacts of the differences across commodities and between model specifications.

Semiotic approach to a practice-oriented knowledge transfer

Knowledge is a valuable asset in organisations that has become significant as a strategic resource in the information age. Many studies have focused on managing knowledge in organisations. In particular, knowledge transfer has become a significant issue concerned with the movement of knowledge across organisational boundaries. One way to capture knowledge in a transferrable form is through practice. In this paper, we discuss how organisations can transfer knowledge through practice effectively and propose a model for a semiotic approach to practice-oriented knowledge transfer. In this model, practice is treated as a sign that represents knowledge, and its localisation is analysed as a semiotic process.

Becoming poverty focused: implications for health actors

The article explores the relationship between health sector interventions and poverty analysis. It is suggested that a dynamic asset approach to poverty and health provides a framework for intervention that recognizes the complex strategies adopted by poor individuals, households and communities. The linked nature of the asset approach leads to an inter-sectoral focus and provides extra stimulation to engage with diverse partners who may be slow to own poverty reduction and health policies.

Microstructure of the Euro-area government bond market

This chapter highlights similarities and differences of equity and fixed- income markets and provides an overview of the characteristics of European government bond market trading and liquidity. Most existing studies focus on the U.S. market. This chapter presents the institutional details of the MTS market, which is the largest European electronic platform for trading government, quasi-government, asset- backed, and corporate fixed- income securities. It reviews the main features of high- frequency fixed- income data and the methods for measuring market liquidity. Finally, the chapter shows how liquidity differs across European countries, how liquidity varies with the structure of the market, and how liquidity has changed during the recent liquidity and sovereign crises.

Cross-country effects of regulatory capital arbitrage

One reason for the recent asset price bubbles in many developed countries could be regulatory capital arbitrage. Regulatory and legal changes can help traditional banks to move their assets off their balance sheets into the lightly regulated shadows and thus enable regulatory arbitrage through the securitized sector. This paper adopts a global vector autoregression (GVAR) methodology to assess the effects of regulatory capital arbitrage on equity prices, house prices and economic activity across 11 OECD countries/ regions. A counterfactual experiment disentangles the effects of regulatory arbitrage following a change in the net capital rule for investment banks in April 2004 and the adoption of the Basel II Accord in June 2004. The results provide evidence for the existence of an international finance multiplier, with about half of the countries overshooting U.S. impulse responses. The counterfactual shows that regulatory arbitrage via the U.S. securitized sector may enhance the cross-country reallocation of capital from housing markets towards equity markets.

Rural-urban disparities in child nutrition in Bangladesh and Nepal

Background The persistence of rural-urban disparities in child nutrition outcomes in developing countries alongside rapid urbanisation and increasing incidence of child malnutrition in urban areas raises an important health policy question - whether fundamentally different nutrition policies and interventions are required in rural and urban areas. Addressing this question requires an enhanced understanding of the main drivers of rural-urban disparities in child nutrition outcomes especially for the vulnerable segments of the population. This study applies recently developed statistical methods to quantify the contribution of different socio-economic determinants to rural-urban differences in child nutrition outcomes in two South Asian countries – Bangladesh and Nepal. Methods Using DHS data sets for Bangladesh and Nepal, we apply quantile regression-based counterfactual decomposition methods to quantify the contribution of (1) the differences in levels of socio-economic determinants (covariate effects) and (2) the differences in the strength of association between socio-economic determinants and child nutrition outcomes (co-efficient effects) to the observed rural-urban disparities in child HAZ scores. The methodology employed in the study allows the covariate and coefficient effects to vary across entire distribution of child nutrition outcomes. This is particularly useful in providing specific insights into factors influencing rural-urban disparities at the lower tails of child HAZ score distributions. It also helps assess the importance of individual determinants and how they vary across the distribution of HAZ scores. Results There are no fundamental differences in the characteristics that determine child nutrition outcomes in urban and rural areas. Differences in the levels of a limited number of socio-economic characteristics – maternal education, spouse’s education and the wealth index (incorporating household asset ownership and access to drinking water and sanitation) contribute a major share of rural-urban disparities in the lowest quantiles of child nutrition outcomes. Differences in the strength of association between socio-economic characteristics and child nutrition outcomes account for less than a quarter of rural-urban disparities at the lower end of the HAZ score distribution. Conclusions Public health interventions aimed at overcoming rural-urban disparities in child nutrition outcomes need to focus principally on bridging gaps in socio-economic endowments of rural and urban households and improving the quality of rural infrastructure. Improving child nutrition outcomes in developing countries does not call for fundamentally different approaches to public health interventions in rural and urban areas.