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]

Information flow analysis for fail-secure devices

Information security devices must preserve security properties even in the presence of faults. This in turn requires a rigorous evaluation of the system behaviours resulting from component failures, especially how such failures affect information flow. We introduce a compositional method of static analysis for fail-secure behaviour. Our method uses reachability matrices to identify potentially undesirable information flows based on the fault modes of the system's components.

Characteristics of undular hydraulic jumps: Experiments and analysis

The writers measured velocity, pressure and energy distributions, wavelengths, and wave amplitudes along undular jumps in a smooth rectangular channel 0.25 m wide. In each case the upstream flow was a fully developed shear flow. Analysis of the data shows that the jump has strong three-dimensional features and that the aspect ratio of the channel is an important parameter. Energy dissipation on the centerline is far from negligible and is largely constrained to the reach between the start of the lateral shock waves and the first wave crest of the jump, in which the boundary layer develops under a strong adverse pressure gradient. A Boussinesq-type solution of the free-surface profile, velocity, and energy and pressure distributions is developed and compared with the data. Limitations of the two-dimensional analysis are discussed.

Agency problems and capital expenditure announcements

This article examines the market valuation of announcements of new capital expenditure. Prior research suggests that the firm's growth opportunities and cash flow position condition the market response. This study jointly examines the role of growth and cash flow, and the interaction between them. Using a new data set of Australian firms that avoids problems associated with expectations models, the results are remarkably strong and support a positive association between growth opportunities and the market valuation, in addition to supporting the role of free cash flow. The findings have implications for the relationship between general investment information and stock prices.

The NASCAR phenomenon: Auto racing sponsorships and shareholder wealth

This study presents the first analysis of the impact of NASCAR sponsorship announcements on the stock prices of sponsoring firms. The primary finding of the study-that NASCAR sponsorship announcements were accompanied by the largest increases in shareholder wealth ever recorded in the marketing literature in response to a voluntary marketing program-represents a striking and unambiguous stock market endorsement of the sponsorships. Indeed, the 24 sponsors analyzed in this study experienced mean increases in shareholder wealth of over $300 million dollars, net of all of the costs associated with the sponsorships. A multiple regression analysis of firm-specific stock price changes and select corporate and sponsorship attributes indicates that NASCAR sponsorships with more successful racing teams, corporate (as opposed to product or divisional) sponsorships, and sponsorships with direct ties to the consumer automotive industry are all positively correlated with perceived sponsorship success, while corporate cash flow per share (a well-known proxy for agency conflicts within the firm) is negatively related with shareholder approval.

Computation of bifurcation boundaries for power systems: A new Delta-plane method

This paper is devoted to the problems of finding the load flow feasibility, saddle node, and Hopf bifurcation boundaries in the space of power system parameters. The first part contains a review of the existing relevant approaches including not-so-well-known contributions from Russia. The second part presents a new robust method for finding the power system load flow feasibility boundary on the plane defined by any three vectors of dependent variables (nodal voltages), called the Delta plane. The method exploits some quadratic and linear properties of the load now equations and state matrices written in rectangular coordinates. An advantage of the method is that it does not require an iterative solution of nonlinear equations (except the eigenvalue problem). In addition to benefits for visualization, the method is a useful tool for topological studies of power system multiple solution structures and stability domains. Although the power system application is developed, the method can be equally efficient for any quadratic algebraic problem.