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.

Reconciling value estimates from the discounted cash flow model and the residual income model

This paper examines why practitioners and researchers get different estimates of equity value when they use a discounted cash flow (CF) model versus a residual income (RI) model. Both models are derived from the same underlying assumption -- that price is the present value of expected future net dividends discounted at the cost of equity capital -- but in practice and in research they frequently yield different estimates. We argue that the research literature devoted to comparing the accuracy of these two models is misguided; properly implemented, both models yield identical valuations for all firms in all years. We identify how prior research has applied inconsistent assumptions to the two models and show how these seemingly small errors cause surprisingly large differences in the value estimates. [ABSTRACT FROM AUTHOR]

Power generation investment opportunities evaluation: A comparison between net present value and real options approach

To evaluate an investment project in the competitive electricity market, there are several key factors that affects the project's value: the present value that the project could bring to investor, the possible future course of actions that investor has and the project's management flexibility. The traditional net present value (NPV) criteria has the ability to capture the present value of the project's future cash flow, but it fails to assess the value brought by market uncertainty and management flexibility. By contrast with NPV, the real options approach (ROA) method has the advantage to combining the uncertainty and flexibility in evaluation process. In this paper, a framework for using ROA to evaluate the generation investment opportunity has been proposed. By given a detailed case study, the proposed framework is compared with NPV and showing a different results

Net uptake of dissolved free amino acids by the giant clam, Tridacna maxima: alternative sources of energy and nitrogen?

The role of dissolved free amino acids (DFAA) in nitrogen and energy budgets was investigated for the giant clam, Tridacna maxima, growing under field conditions at One Tree Island, at the southern end of the Great Barrier Reef, Australia. Giant clams (121.5-143.7 mm in shell length) took up neutral, acidic and basic amino acids. The rates of net uptake of DFAA did not differ between light and dark, nor for clams growing under normal or slightly enriched ammonium concentrations. Calculations based on the net uptake concentrations typical of the maximum concentrations of DFAA found in coral reef waters (similar to 0.1 mu M)revealed that DFAA could only contribute 0.1% and 1% of the energy and nitrogen demands of giant clams, respectively. These results suggest that DFAA does not supply significant amounts of energy or nitrogen for giant clams or their symbionts.

Gender, marital status, farm size and other factors influencing the extent of cash cropping in Kenya: A case study

This article examines the effects of commercialisation of agriculture on land use and work patterns by means of a case study in the Nyeri district in Kenya. The study uses cross sectional data collected from small-scale farmers in this district. We find that good quality land is allocated to non-food cash crops, which may lead to a reduction in non-cash food crops and expose some households to greater risks of possible famine. Also the proportion of land allocated to food crops declines as the farm size increases while the proportion of land allocated to non-food cash crops rises as the size of farm increases. Cash crops are also not bringing in as much revenue commensurate with the amount of land allocated to them. With growing commercialisation, women still work more hours than men. They not only work on non-cash food crops but also on cash crops including non-food cash crops. Evidence indicates that women living with husbands work longer hours than those married but living alone, and also longer than the unmarried women. Married women seem to lose their decision-making ability with growth of commercialisation, as husbands make most decisions to do with cash crops. Furthermore husbands appropriate family cash income. Husbands are less likely to use such income for the welfare of the family compared to wives due to different expenditure patterns. Married women in Kenya also have little or no power to change the way land is allocated between food and non-food cash crops. Due to deteriorating terms of trade for non-food cash crops, men have started cultivation of food cash crops with the potential of crowding out women. It is found that both the area of non-cash crops tends to rise with farm size but also the proportion of the farm area cash cropped rises in Central Kenya.

The net benefit of saving the Asian Elephant: A policy and contingent valuation Study

Reports results from a contingent valuation survey of willingness to pay for the conservation of the Asian elephant of a sample of urban residents living in three selected housing schemes in Colombo, the capital of Sri Lanka. Face–to–face surveys were conducted using an interview schedule. A non-linear logit regression model is used to analyse the respondents’ responses for the payment principle questions and to identify the factors that influence their responses. We investigate whether urban residents’ willingness to pay for the conservation of elephants is sufficient to compensate farmers for the damage caused by elephants. We find that the beneficiaries (the urban residents) could compensate losers (the farmers in the areas affected by human–elephant conflict) and be better off than in the absence of elephants in Sri Lanka. Therefore, there is a strong economic case for the conservation of the wild elephant population in Sri Lanka. However, we have insufficient data to determine the optimal level of this elephant population in the Kaldor-Hicks sense. Nevertheless, the current population of elephant in Sri Lanka is Kaldor-Hicks preferable to having none.

Marital status, farm size and other influences on the extent of cash cropping in Kenya: A household case study

This article examines the effects of marital status, farm size and other factors on the extent of cash cropping (and allocation of land use) by means of a case study in the Nyeri district in Kenya. It was found that married women are involved in the production of a relatively greater amount of output of cash crops than unmarried women since husbands prefer to have more land under cash crops than food crops. Farmers with better quality land allocate a high proportion of it to non-food cash crops, which may expose some households to greater risks of possible famine. The proportion of land allocated to food crops declines as the farm size increases while the proportion of land allocated to non-food cash crops rises as the size of farm increases. Age is also inversely associated with subsistence. Education, though inversely associated with subsistence farming does not appear to be statistically very significant as an influence on the composition of land use and composition of farm output. With growing commercialisation, married women work more hours than unmarried ones, working not only on non-cash food crops but also on non-food cash crops. Married women seem to lose their decision-making ability with growth of agricultural commercialisation, as husbands make most decisions to do with cash crops. Married women in Kenya also have little or no power to change the way land is allocated between food and non-food cash crops.

Cash, customers, and care: The experience and meaning of differential payment for high care places in aged care facilities

The introduction of new asset/income tested charges for high care residents was the 1997-98 Commonwealth government policy response to concerns about financing residential aged care. This in-depth study of residents, families, staff and managers in three aged care facilities explores issues of equity, access and empowerment arising when some residents pay more for the same level of care and amenity. The study reports little evidence of financial contributions affecting access to high care places and the delivery of care, the potential for differential access to amenities such as single rooms linked to the extra payments, and no evidence of a sense of empowerment linked to payment of the new charges. The complexity of current financial arrangements, access to appropriate financial advice at the time of entry, and the potential for an informal two tier system in relation to the allocation Of amenities are identified as developing policy issues.