Content area
Full Text
ALTHOUGH MANY TYPES OF ANALYSES ARE USEFUL IN DETERMINING THE SCOPE AND POSSIBLE SUCCESS OF A PROJECT, MONTE CARLO SIMULATION ACTUALLY HELPS MANAGERS UNDERSTAND AND VISUALIZE RISK AND UNCERTAINTY BY MAPPING ALL POSSIBLE OUTCOMES OF A PROJECT.
Monte Carlo simulation is a powerful spreadsheet-based tool that allows managers to better understand and visualize risk and uncertainty in discounted cash flow (DCF) analysis. The primary output, a histogram of net present values (NPV), maps the entire distribution of possible outcomes as a bell-shaped curve and therefore estimates the probability of success for the project (e.g., NPV > zero). Although we use fictional names, we illustrate a real capital budgeting problem using Monte Carlo simulation to demonstrate how employing this tool can result in more-informed decision making.
Finance theory states that expected (mean) cash flows should be discounted at the opportunity cost of capital using a decision rule to accept or reject all positive or negative NPV projects. A central issue for managers, however, is how to deal with uncertainty-i.e., the fact that expected cash flows are only a point estimate of a large number of possible realizations. Traditional finance textbooks suggest two tools for this-sensitivity analysis and scenario analysis. Sensitivity analysis tweaks one variable at a time and evaluates the effect on the project's net present value, and scenario analysis examines a limited number of combinations of variables: worst-case (WC), most-likely-case (MLC), and best-case (BC) estimates of financial variables that determine future cash flows (e.g., sales, costs, growth rates, investment in working capital, etc.). The output is three project NPVs where all variables simultaneously take on one of the three hypothetical realizations. Neither tool produces probabilities of success or failure for the project.
Monte Carlo simulation, however, overcomes the limitations of sensitivity and scenario analyses by examining the effects of all possible combinations of variables and their realizations. Although the inputs are no different from scenario analysis, Monte Carlo simulation treats the estimates as a triangular distribution with the probability of WC and BC realizations being close to zero and increasing linearly up to the MLC. The simulation package then draws randomly from this distribution (100,000 times in our examples) for all variables that are specified in the DCF model and calculates an NPV...