Monte Carlo Simulation Using Excel: Case Study in Financial Forecasting

Seifedine Kadry

Chapter 16 in The Palgrave Handbook of Research Design in Business and Management, 2015, pp 263-289 from Palgrave Macmillan

Abstract: 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 Function (search for similar items in EconPapers)
Date: 2015
References: Add references at CitEc
Citations:

There are no downloads for this item, see the EconPapers FAQ for hints about obtaining it.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:pal:palchp:978-1-137-48495-6_16

Ordering information: This item can be ordered from
http://www.palgrave.com/9781137484956

DOI: 10.1057/9781137484956_16

Access Statistics for this chapter

More chapters in Palgrave Macmillan Books from Palgrave Macmillan
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().