Title: Methodological proposal of financial modelling using dynamic scenarios from multivariable data tables

Authors: J.D. González-Ruiz; Eduardo Duque; Alejandro Peña; Jovani Jiménez; Héctor Alejandro Patiño

Addresses: EAFIT University, Medellín, Colombia ' Faculty of Business and Marketing Studies, Institución Universitaria Esumer, Medellín, Colombia; Faculty of Engineering, Institución Universitaria Pascual Bravo, Medellín, Colombia ' EIA University, Antioquia, Colombia ' Faculty of Mines, National University of Colombia, Bogotá, Colombia ' EIA University, Antioquia, Colombia

Abstract: This paper aims at proposing a methodological strategy for teaching the modelling of dynamic scenarios from Multivariable Data Tables using Microsoft Excel as a technological tool. It provides a step-by-step guide for improving the teaching-learning method on the development of financial models, which could also be used in other areas. The methodology allows identifying the most important aspects of developing financial models so students-professors could be guided towards a more pedagogical approach promoting the incorporation of technological tools in the classroom. This work plays a pivotal role in financial modelling teaching since it provides relevant elements leading to the development of systematic thinking among university students based on cognitive activities. Also, various contributions to research on the teaching-learning process in modelling are discussed. For validating the proposal, an airport's financial valuation was used as a case study. As a result, this paper contributes to increasing the role of computational tools and students-professors involvement in the development of systemic thinking and cognitive skills.

Keywords: financial modelling; learning-teaching; Excel; cognitive skills; project finance; dynamic scenarios.

DOI: 10.1504/IJTEL.2018.092700

International Journal of Technology Enhanced Learning, 2018 Vol.10 No.3, pp.161 - 183

Received: 23 Feb 2017
Accepted: 14 Jul 2017
Published online: 28 Jun 2018 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article