Valoración financiera de los proyectos “Fábrica de bioinsumos”, “Escalamiento de una planta de producción de soluciones habitacionales flotantes” y “Modelo renting de bicicletas eléctricas”, con base en una herramienta automatizada en Excel ®

Abstract

This graduation project will create an Excel® tool for project valuation, including a stochastic model in the framework of the SOLA Project built in 2017 developed with resources from the European Union -- It includes, within its variable processing model, stochastic elements that allows it to carry out probabilistic financial evaluations -- This is how, the tool expands its capacities for the evaluation of innovation projects -- The graduation project begins with the presentation of a conceptual framework that allows understanding the two fundamental conceptual elements of the tool: mathematical modeling and financial valuation -- The first element is understood as a representation of reality that enables one to answer questions about that reality with a specific purpose -- The second element is defined as the estimation of the wealth generation capacity of a productive asset, being a business, a project or a technology, from the point of view of the contributors of capital -- With these fundamental elements defined, a detailed explanation of the functioning of the tool is presented and additionally, a comparative exercise is carried out, so is evident the relationship of the tool with the main concepts of project management -- Finally, three technologies are evaluated through a systematic process that includes the contextualization of the projects; the construction of evaluation assumptions; the processing of the variables and the presentation of the respective results and recommendations -- It is worth mentioning that the projects evaluated are part of the portfolio of the Innovation Department of the EAFIT University, and they are known as: - Bio factory -- Scaling of a production plant for floating housing solutions -- Renting model of electric bicycles