Monte Carlo Simulation Using Excel: Case Study in Financial Forecasting
Abstract
Modeling is the process of producing a model; a model is a representation of the construction and working of some system of interest. A model is similar to but simpler than the system it represents. One purpose of a model is to enable the analyst to predict the effect of changes to the system. On the one hand, a model should be a close approximation to the real system and incorporate most of its salient features. On the other hand, it should not be so complex that it is impossible to understand and experiment with it. A good model is a judicious tradeoff between realism and simplicity. Simulation practitioners recommend increasing the complexity of a model iteratively. An important issue in modeling is model validity. Model validation techniques include simulating the model under known input conditions and comparing model output with system output. Generally, a model intended for a simulation study is a mathematical model developed with the help of simulation software. Mathematical model classifications include deterministic (input and output variables are fixed values) or stochastic (at least one of the input or output variables is probabilistic) and static (time is not taken into account) or dynamic (time-varying interactions among variables are taken into account). Typically, simulation models are stochastic and dynamic.
Keywords
Monte Carlo Simulation Uncertain Variable Geometric Brownian Motion Financial Forecast Excel FunctionPreview
Unable to display preview. Download preview PDF.
References
- Banks, J., Ed. (1998). Handbook of simulation: Principles, methodology, advances, applications, and practice. New York: John Wiley & Sons.Google Scholar
- Banks, J., Carson, J.S., Nelson, B.L. & Nicol, D.M. (2005). Discreteevent system simulation. (4th.ed.). Upper Saddle River, NJ: Prentice-Hall.Google Scholar
- Bianchi, M., Boyle, M., & Hollingsworth, D. (1999). A comparison of methods for trend estimation. Applied Economics Letters, 6, 103–109.CrossRefGoogle Scholar
- Cellier, F.E. & Kofman, E. (2006). Continuous system simulation. New York: Springer-Verlag.Google Scholar
- Drakos, Nikos (1995). Computer based learning unit. University of Leeds. Introduction to Monte Carlo Methods. csep1.phy.ornl.gov/mc/node1.html.Google Scholar
- Landau, D. P. & Binder, K. (2005). A guide to Monte Carlo simulations in statistical physics. (2nd ed.). Cambridge: Cambridge University Press.CrossRefGoogle Scholar
- Law, A. M. & Kelton, W.D. (2000). Simulation modeling and analysis. (3rd ed). New York: McGraw-Hill.Google Scholar
- Paskov, S. (1994). Computing high dimensional integrals with applications to finance. (Preprint Columbia University).Google Scholar
- Stanislaw, Ulam. (1991). Adventures of a mathematician. Originally published in 1976, University of California Press, p. 199.Google Scholar