Introduction to Discounted Cash Flow Analysis and Financial Functions in Excel

The financial and economic analysis of investment projects is typically carried out using the technique of discounted cash flow (DCF) analysis. This module introduces concepts of discounting and DCF analysis for the derivation of project performance criteria such as net present value (NPV), internal rate of return (IRR) and benefit to cost (B/C) ratios. These concepts and criteria are introduced with respect to a simple example, for which calculations using MicroSoft Excel are demonstrated.

Balancing the number and size of sites: An economic approach to the optimal design of cluster samples

The design of randomized controlled trials entails decisions that have economic as well as statistical implications. In particular, the choice of an individual or cluster randomization design may affect the cost of achieving the desired level of power, other things being equal. Furthermore, if cluster randomization is chosen, the researcher must decide how to balance the number of clusters, or sites, and the size of each site. This article investigates these interrelated statistical and economic issues. Its principal purpose is to elucidate the statistical and economic trade-offs to assist researchers to employ randomized controlled trials that have desired economic, as well as statistical, properties. (C) 2003 Elsevier Inc. All rights reserved.

Evolutionary economics: Foundation of liberal economic philosophy

This is a schools brief style of introduction to evolutionary economics. It addresses the nature of evolutionary theory in relation to economics, and examines why evolutionary economists argue that market-capitalism is an evolutionary system. Finally, it argues that liberal economic philosophy has much stronger and more direct relationship with evolutionary economic analysis than neoclassical economic analysis.

A cost-effectiveness analysis of buprenorphine-assisted heroin withdrawal

The purpose of this study was to conduct a cost - effectiveness analysis of detoxification from heroin using buprenorphine in a specialist clinic versus a shared care setting. A randomized controlled trial was conducted with a total of 115 heroin-dependent patients receiving a 5-day treatment regime of buprenorphine. The specialist clinic was a community-based treatment agency in inner-city Sydney. Shared care involved treatment by a general practitioner supplemented by weekend dispensing and some concurrent counselling at the specialist clinic. Quanti. cation of resource use was limited to inputs for treatment provision. The primary outcome measure used in the economic analysis was the proportion of each group that completed detoxification and achieved an initial 7-day period of abstinence. Buprenorphine detoxification in the shared care setting was estimated to be $24 more expensive per patient than treatment at the clinic, which had an average treatment cost of $332 per patient. Twenty-three per cent of the shared care patients and 22% of the clinic patients reported no opiate use during the withdrawal period. These results suggest that the provision of buprenorphine treatment for heroin dependence in shared care and clinic appear to be equally cost - effective.

Do open-cycle hatcheries relying on tourism conserve sea turtles? Sri Lankan developments and economic-ecological considerations

By combining economic analysis of markets with ecological parameters, this article considers the role that tourism-based sea turtle hatcheries (of an open-cycle type) can play in conserving populations of sea turtles. Background is provided on the nature and development of such hatcheries in Sri Lanka. The modeling facilitates the assessment of the impacts of turtle hatcheries on the conservation of sea turtles and enables the economic and ecological consequences of tourism, based on such hatcheries, to be better appreciated. The results demonstrate that sea turtle hatcheries serving tourists can make a positive contribution to sea turtle conservation, but that their conservation effectiveness depends on the way they are managed. Possible negative effects are also identified. Economic market models are combined with turtle population survival relationships to predict the conservation impact of turtle hatcheries and their consequence for the total economic value obtained from sea turtle populations.

Financial and economic performance of long-rotation hardwood plantation investments in Queensland, Australia

In Queensland, Australia, there is presently a high level of interest in long-rotation hardwood plantation investments for sawlog production, despite the consensus in Australian literature that such investments are not financially viable. Continuing genetics, silviculture and processing research, and increasing awareness about the ecosystem services generated by plantations, are anticipated to make future plantings profitable and socio-economically desirable in many parts of Queensland. Financial and economic models of hardwood plantations in Queensland are developed to test this hypothesis. The economic model accounts for carbon sequestration, salinity amelioration and other ecosystem service values of hardwood plantations. A carbon model estimates the value of carbon sequestered, while salinity and other ecosystem service values are estimated by the benefit transfer method. Where high growth rates (20-25 m(3) ha(-1) year(-1)) are achievable, long-rotation hardwood plantations are profitable in Queensland Hardwood Regions 1, 3 and 7 when rural land values are less than $2300/ha. Under optimistic assumptions, hardwood plantations growing at a rate of 15 in 3 ha-1 year 1 are financially viable in Hardwood Regions 2, 4 and 8, provided land values are less than $1600/ha. The major implication of the economic analysis is that long-rotation hardwood plantation forestry is socio-economically justified in most Hardwood Regions, even though financial returns from timber production may be negative. (c) 2003 Elsevier B.V. All rights reserved.

Some economic dimensions of the mental health jigsaw in Australia

The purpose of this paper is to demonstrate that, although there are some unique features associated with mental illness, such special features do not preclude economic analysis. As a mechanism for understanding how individual economic studies fit into the mental health sector, a conceptual framework of the components of mental health service provision is outlined. Emphasis is placed on, not simply institutional and market resources, but also on the services provided by relatives, self-help groups, etc. Australian data on parts of the mental health sector are employed to illustrate that some (and different) economic analyses can be undertaken in mental health. First, time-series data on public psychiatric hospitals are employed to demonstrate trends associated with deinstitutionalisation. Other data (for Queensland alone) indicate that there are state-based differences in the provision of such services. Second, attention is then directed to the analysis of time-series data on private fee-for-service psychiatric services. Various concepts and measures from industrial economics are applied to analyse the relative size of this service industry, the pricing behaviour of the profession, the service-mix of "the psychiatry firms" operating in Australia.

Extent and economic effect of heat loads on dairy cattle production in Australia

Objective To investigate the extent of heat load problems, caused by the combination of excessive temperature and humidity, in Holstein-Friesian cows in Australia. Also, to outline how milk production losses and consequent costs from this can be estimated and minimised. Procedures Long-term meteorological data for Australia were analysed to determine the distribution of hot conditions over space and time. Fifteen dairy production regions were identified for higher-resolution data analysis. Both the raw meteorological data and their integration into a temperature-humidity thermal index were compiled onto a computer program. This mapping software displays the distribution of climatic patterns, both Australia-wide and within the selected dairying regions. Graphical displays of the variation in historical records for 200 locations in the 15 dairying regions are also available. As a separate study, production data from research stations, on-farm trials and milk factory records were statistically analysed and correlated with the climatic indices, to estimate production losses due to hot conditions. Results Both milk yields and milk constituents declined with increases in the temperature-humidity index. The onset and rate of this decline are dependent on a number of factors, including location, level of production, adaptation, and management regime. These results have been integrated into a farm-level economic analysis for managers of dairy properties. Conclusion By considering the historical patterns of hot conditions over time and space, along with expected production losses, managers of dairy farms can now conduct an economic evaluation of investment strategies to alleviate heat loads. These strategies include the provision of sprinklers, shade structures, or combinations of these.

Returns to farm-level soil conservation on tropical steep slopes: The case of the Eritrean highlands

This study conducts an economic analysis of investment in simple soil conservation technologies in the highlands of Eritrea. The data used in the analysis were obtained from a farm survey and supplemented with data from secondary sources. Risk analysis techniques are used to take account of the uncertainties regarding the relationship between soil erosion and crop yield. The financial analysis reveals negative net present values (NPVs) and internal rates of return (IRRs) below 12 per cent for various slope categories. On the other hand, the economic analysis returns positive NPVs and IRRs of over 20 per cent. The results clearly indicate that in-vestment in soil conservation technology may not be a viable short-term proposition from the farmer's point of view and yet the net social benefits are positive. There is a strong case for government to provide incentives for soil conservation in view of the economic benefits.