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.

Economic and political influences on urban planning: a comparison of London, Paris and Berlin

This paper addressed the degree of autonomy experienced by the planning regimes of London, Paris and Berlin. What variation exists in the governance of these cities and how do national, local, political, business and community interests effect planning decisions? The discussion is placed in the context of the literature on world cities and growth coalitions and the debate over whether economic forces compel cities to follow similar strategies. The paper concludes that in the case of the three cities examined there is considerable variation of planning approach due to different historical, cultural and political factors.

The UK Department of National Heritage: a model for the development and integration of leisure policy in the new Europe?

Leisure is in the vanguard of a social and cultural revolution which is replacing the former East/West political bipolarity with a globalised economic system in which the new Europe has a central rôle. Within this revolution, leisure, including recreation, culture and tourism, is constructed as the epitome of successful capitalist development; the very legitimisation of the global transmogrification from a production to a consumption orientation. While acting as a direct encouragement to the political transformation in many eastern European states, it is uncertain how the issue of leisure policy is being handled, given its centrality to the new economic order. This paper therefore examines the experience of western Europe, considering in particular the degree to which the newly-created Department of National Heritage in the UK provides a potential model for leisure development and policy integration in the new Europe. Despite an official rhetoric of support and promotion of leisure activities, reflecting the growing economic significance of tourism and the positive relationship between leisure provision and regional economic development, the paper establishes that in the place of the traditional rôle of the state in promoting leisure interests, the introduction of the Department has signified a shift to the use of leisure to promote the Government's interests, particularly in regenerating citizen rights claims towards the market. While an institution such as the Department of National Heritage may have relevance to emerging states as a element in the maintenance of political hegemony, therefore, it is questionable how far it can be viewed as a promoter or protector of leisure as a signifier of a newly-won political, economic and cultural freedom throughout Europe.

Access to the countryside of England and Wales: public/private partnership or the privatisation of public rights?

This paper examines the evolution of public rights of access to private land in England and Wales. Since the Eighteenth Century the administration and protection of these rights has been though a form of public/private partnership in which the judiciary, while maintaining the dominance of private property, have safeguarded de facto public access by refusing consistently to punish simple trespass. While this situation has been modified, principally by post-World War II legislation, to allow for some formalisation of access arrangements and consequent compensation to landowners in areas of high recreational pressure and low legal accessibility, recent policy initiatives suggest that the balance of the partnership has now shifted in favour of landowners. In particular, the new access payment schemes, developed by the UK Government in response to the European Commission's Agri-Environment Regulations, locate the landowner as the beneficiary of the partnership, financed by tax revenue and justified on the spurious basis of improved 'access provision'. As such the state, as the former upholder of citizen rights, now assumes the duplicitous position of underwriting private property ownership through the commodification of access, while proclaiming a significant improvement in citizens' access rights.

Partnership in the provision of recreational access: the reconstruction of the public interest in private land in England and Wales

This paper examines the evolution of public rights of access to private land in England and Wales. Since the Eighteenth Century the administration and protection of these rights has been though a form of public/private partnership in which the judiciary, while maintaining the dominance of private property, have safeguarded de facto public access by refusing consistently to punish simple trespass. While this situation has been modified, principally by post-World War II legislation, to allow for some formalisation of access arrangements and consequent compensation to landowners in areas of high recreational pressure and low legal accessibility, recent policy initiatives suggest that the balance of the partnership has now shifted in favour of landowners. In particular, the new access payment schemes, developed by the UK Government in response to the European Commission's Agri-Environment Regulations, identify the landowner as the beneficiary of the partnership, financed by tax revenue and justified on the spurious basis of improved 'access provision'. As such the State, as the former upholder of citizen rights, now assumes the duplicitous position of underwriting private property ownership through the commodification of access, while proclaiming a significant improvement in citizens' access rights.

Regional implications of macro-economic, sectoral and company changes in the development of technopoles in Britain and France

This paper reports the proceedings of a conference held at Reading University in 1993 which addressed the issues of new technological developments at the regional and sub-regional levels in Britain and France. These new technological clusters - the `Technopoles' - are investigated in a series of papers in both English and French which examines their spatial, sectoral and economic aspects to determine what lessons can be learned from their development and what their future economic significance is likely to be. Two recurring themes are of particular significance in the papers - the link between R& D and regional development, and the different forms which innovation assumes within the various technopoles under scrutiny.

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.

Commentary on an example of a tenancy agreement for an agricultural holding

This paper sets out an example of a standard agricultural tenancy, being one creating a tenancy from year to year and consequently covered by the agricultural holdings legislation. A facing-page commentary gives a clause-by-clause analysis of the agreement, the implications of each provision being discussed in the light of the law of contract, agricultural holdings legislation and, where appropriate, subsequent caselaw.

The story of Temple Bar: creating Dublin's cultural quarter

The paper conceptualises and explores the links between cities, commerce, urbanism and cultural planning by drawing on Temple Bar in Dublin as an example of how, by linking these concepts to practice in real concrete situations urban life or urban culture can be created and/or revitalised. Temple Bar is Dublin's emerging cultural quarter, an experiment in urban revitalisation which is deliberately focused on culture and urbanism as ways of rediscovering the good city. It has attracted considerable interest from across Europe, and has secured EC funding to kick-start the process of renewal. The author was appointed by the Irish Government to prepare the area management and development strategy for Temple Bar in 1990. Wary of the dangers of property led regeneration, of the destructive impacts of sudden or cataclysmic change, the agencies in Temple Bar have deliberately adopted a strategic management approach to the area. This is referred to as 'urban stewardship', a process of looking after and respecting a place, and helping it to help itself. The paper explores whether there is a 'culture of cities' and whether it is possible to recreate an urban culture. Following Raymond Williams, an anthropological definition of culture is employed, "... a particular way of life, which expresses certain meaning and values not only in art and learning but also in institutional and ordinary behaviour". Rather than being simply an add-on to the serious concerns of economic development and the built environment, culture has both helped shape, and continues to develop in, the streets, spaces and buildings of the city.

Expectation versus provision in the management and use of urban open space

This paper discusses the implications of the shifting cultural significance of public open space in urban areas. In particular, it focuses on the increasing dysfunction between people's expectations of that space and its actual provision and management. In doing so, the paper applies Lefebvre's ideas of spatiality to the evident paradigm shift from 'public' to 'private' culture, with its associated commodification of previously public space. While developing the construct of paradigm shift, the paper recognises that the former political notions inherent in the provision of public space remain in evidence. So whereas public parks were formerly seen as spaces of confrontation between the 'rationality' of public order as the 'irrationality' of individual leisure pursuits, they are now increasingly seen, particularly 'out of hours', as the domain of the dispossessed, to be defined and policed as 'dangerous'. Where once people were welcomed into public open spaces as a means of 'educating' them in good, acceptable, leisure practices, therefore, they are now increasingly excluded, but for the same ostensible reasons. Building on survey work undertaken in Reading, Berkshire, the paper illustrates how communities can become separated from 'their' space, leaving them with the overriding impression that they have been 'short-changed' in terms of both the provision and the management of urban open space. Rather than the intimacy of local space for local people, therefore, the paper argues that parks have become externalised places, increasingly responding to commercial definitions of culture and what is 'public'. Central urban open spaces are therefore increasingly becoming sites of stratification, signification of a consumer-constructed citizenship and valorisation of public life as a legitimate element of the market surface of town and city centres.

Producing leisure spaces out of thin air: the case of the Countryside Stewardship Scheme

This paper examines the growing dysfunction between the apparently increasing significance of diverse leisure practices in the countryside and the largely unchanging official response towards them. Although there is recognition in the recent rural White Paper (DOE and MAFF, 1995) that access is essential to enjoying the countryside, the construction of this term is dubious, since paid access agreements, based on producer requirements, are favoured over any form of demand-driven freedom to roam. Using the Countryside Stewardship Scheme (CSS) as an example of the incentive structure developed to promote this policy, the paper applies Plato's simulacrum as a reading of how this process is being utilised to underpin the dominant rights associated with rural property interests. In particular, the paper makes the point that rather than representing the corollary of a market situation, as its supporters claim, the CSS involves government grant for the eclectic provision of short term licences over ground which remains unmapped as anything other than its continued agricultural use. In concluding, the paper asserts that rather than representing an increase in the availability of leisure sites in the countryside, the CSS and other schemes represent a diversion from the wider and deeper socio-cultural process of continued wealth and power redistribution.

Marriage value and scarcity in agricultural rents: a discussion of the findings in Childers v Ankers

Formal statutory guidance to arbitrators involved in settling disputes over rents for agricultural holdings is contained in the Agricultural Holdings Act 1986. The particular features of the agricultural letting market raise valuation problems which the Act itself has failed to satisfactorily address, most notably the degree to which marriage value and scarcity should be taken into account. The 1995 Court of Appeal case of Childers v Anker addresses several of the key issues. This paper seeks to explore the findings and practical implications of the case for rental valuers and arbitrators. It argues that sitting tenants may be seriously disadvantaged by the court's judgements, not least by having to pay rents on review which reflect elements of marriage value and possibly scarcity value.

Local space for local people? Trends in the provision and management of urban outdoor recreation in the UK

This paper examines the growing trend in the UK towards the effective privatisation of formerly public open space and the relationship of this trend to the recent shifts in public sector management. A case study of Reading, England, illustrates the growing cultural and spatial dysfunction, particularly in terms of the declining knowledge and use of the town's urban gardens by the local population. Where once the gardens were a focus of social activity, therefore, they are now a largely irrelevant site of urban decline. In contrast to central urban space, it is clear that other types of open space in other areas can still assume a significance in peoples' lives. In many cases the use of these areas illustrates a counter cultural position in which the consumerism of the city management is actively being resisted. The paper concludes that while there appear to be ways in which local space could be reclaimed for local people, the power to achieve this lies predominantly in the same hands as those responsible for appropriating central space to the imperative of the market in the first instance

Recent trends in UK Government policy on the provision and management of leisure facilities

Since the first election victory of the Thatcher administration in 1979, Britain has witnessed a cultural transformation from the municipal socialism of the post-World War 2 Welfare State to a form of post-industrial entrepreneurialism. This has had a profound effect on all aspects of civil society, not least the redefinition of the role of active leisure from the 1950s evocation of 'Sport For All' to the market rationality of the 1980s. The transformation has signalled a shift from government support for active leisure as an element of citizen rights to the use of leisure to promote the government's interest in legitimating a new social order based not on rights but on means. Thus access to active living is no longer a societal goal for all, but a discretionary consumer good, the consumption of which signifies 'active' citizenship. It furthermore signifies differentiation from the growing mass of 'deviants' who are unwilling or unable to embrace this new construction of citizenship and are, therefore, increasingly denied access to active living and, hence, active citizenship.

Sustainable land management and development: the role of the chartered surveyor

Despite the growing intensity of the debate about environmental management, it is only recently that rural practice surveyors have become aware of its significance and potential. Consequently, few surveyors are yet in a position to offer professional advice, despite evidence from the RICS's client needs survey that nearly half of all existing clients require more advice on environmental matters. As a prerequisite to becoming involved in environmental management, it is clear that chartered surveyors have to develop new skills alongside new perceptions of their work. Rather than being conterminous, however, the alignment of these attributes reflects a fundamental tension. This is focused on the dichotomy between the strategic construction of the environment as a basis for realigning corporate policy and the more limited evocation of environmentalism as potential new business. This paper seeks to explore the nature and policy context of sustainable development, in the process examining its significance for rural chartered surveyors. In doing so, the paper will seek to contrast the essentially anthropocentric utilitarianism of surveyors' current attitudes with the radical agenda inferred by a more ecocentric, sustainable development approach to professional management and advice. The paper will conclude with a discussion about how far the principles of sustainable development can be incorporated into the management of surveying businesses, and what this implies for the future of the rural practice chartered surveyor as land manager.