20 Pages Posted: 14 Oct 2011
Date Written: September 11, 2011
This teaching note provides step-by-step instruction for simulating the net present value and the internal rate of return of a five-year project. The uncertainty lie in the initial level of sales, sales growth rates, gross profit margins, operating expenses before depreciation, and the terminal value multiples for net working capital and plant, property and equipment. The problem is based on the opening example in the chapter on Project Risk Analysis of Titman and Martin’s (2011) valuation text, with a multi-period version of uncertain variables added, and separate random variables representing the terminal value multiples for net working capital and plant, property and equipment.
Keywords: Capital Budgeting, Financial Modeling, Risk Simulation
JEL Classification: A20, C00, G31
Suggested Citation: Suggested Citation
Joaquin, Domingo C., Note on the Mechanics of Spreadsheet-Based Simulation with Application to Project Risk Analysis (September 11, 2011). Available at SSRN: https://ssrn.com/abstract=1936655 or http://dx.doi.org/10.2139/ssrn.1936655