Font Size:
Simulation modeling in international capital budgeting with Excel
Last modified: 2018-02-12
Abstract
The aim of the article is to present in detail the process of simulation modeling in international capital budgeting, using the embedded functions of Excel. Monte Carlo simulations are used to generate 10 000 probabilistic predictions for limited key economic variables with certain probability distribution parameters. As a final result, an estimation of the net present value for the investment project is made.
Keywords
simulation modeling, international capital budgeting, Monte Carlo simulation, Data table
References
1. Holtan M., Using simulation to calculate the NPV of a project, Onward Inc. 2002
2. Dowd Kevin, “Introduction to market risk measurement”, John Wiley & Sons Ltd, England 2002
3. Winston, Wayne L., Microsoft® Excel® 2010: Data Analysis and Business Modeling, Microsoft Press, 2011
4. Allman, Keith A., Modeling Structured Finance Cash Flows with Microsoft Excel, John Wiley & Sons, Inc., 2007
5. Ngai Hang Chan and Hoi Ying Wong, Simulation techniques in financial risk management, John Wiley & Sons, Inc., 2006