Diseñar un aplicativo en Excel, para distribuir el impacto de las variables más representativas en la creación de empresas usando simulación de Montecarlo

Abstract

The objective of this research was to design an Excel sheet for Financial Simulation to define the concepts, variables and possible scenarios to apply the Monte Carlo Model to investment projects. The methodology used was a descriptive type quantitative approach with an experimental, explanatory, descriptive design; the information was collected through the generation of a physical and private database; the information was obtained through physical documents and web pages. Instruments were designed to collect, classify and analyze the existing common information. Subsequently, the specialized literature consulted was analyzed to identify the criteria for selecting software for the analysis and simulation of investment projects. And finally, the Excel sheet method was designed to identify and project the selection criteria of a project in three possible scenarios. The results showed that the elaboration of an Excel sheet to project the application of the Monte Carlo Model in three possible scenarios is possible, feasible and very practical, yielding results within a context of the marketing, operational, administrative, legal, accounting and financial areas. Resulting in a very particular and practical tool when evaluating investment projects.