University of agribusiness and rural development, UARD Jubilee International Scientific Conference

Font Size: 
Simulation modeling in international capital budgeting with Excel
Georgi Georgiev

Last modified: 2018-02-12


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.


simulation modeling, international capital budgeting, Monte Carlo simulation, Data table


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

Full Text: PDF  |  PRES