Content area
Full Text
EXECUTIVE SUMMARY
An Excel-based capital budgeting simulation model that contains a degree of randomness and uncertainty can be used to expand classroom discussions of risk in the context of capital investment analysis. This adds a level of detail that is often over-looked by most managerial accounting textbooks.
Many leading managerial accounting textbooks provide only limited coverage of risk in the context of capital budgeting, often referred to as capital investment analysis. Capital budgeting chapters usually focus on widely used decision models, such as net present value (NPV), inter- nal rate of return (IRR), accounting rate of return (ARR), profitability index (PI), and the payback period (PB), and are often enhanced with analyzing tax implications in capital bud- geting decisions.1 But only the deterministic versions of these models, in which no randomness is involved, are covered. Cash flows are forecasted as single figures, and their uncer- tainty is ignored. The risk associated with an investment proj- ect is expressed in the selected discount rate (required rate of return). The lesson being told, therefore, is that the greater the risk that is associated with an investment, the greater the return that is required.
In practice, however, several different techniques are used to deal with the uncertainty of investment projects. Firms might combine NPV with PB when analyzing the total risk of a project. They also might use sensitivity analysis, scenario analysis, risk-adjusted discount-rate approach, or simulation. These techniques are applied following the assumption that it is relevant to consider a project's total risk when evaluating the project and when the returns from the project are positively correlated with the returns from the firm as a whole.2
Although the leading textbooks do not delve into these methods for dealing with uncertainty in invest- ments, the techniques can be explained easily in the classroom, especially when supplemented with spread- sheet applications. An educational model developed in Excel can provide a simple simulation of the NPV of an investment project whose outcome is uncertain. The model is easy to use, requiring only a basic Excel pack- age and not the @Risk add-in.
Basic Simulation Model
A simulation model is a computer model that imitates a real-life situation. When applicable in capital budgeting, the simulation approach generally is more...