A construção de uma ferramenta em VBA para resolução de problemas básicos da Matemática Financeira.

Abstract

Bearing in mind the daily applicability of Financial Mathematics and its potential contextualization with subjects dealt with in the media with frequent use of tables, graphs and interest rates, and given the importance of such knowledge for the formation of a more critical citizen and aware of their choices economics, the objective of this work is to build an educational tool for solving basic problems of Financial Mathematics, using the Visual Basic for Applications (VBA) programming language. A bibliographic survey on Financial Mathematics, electronic spreadsheets and VBA is then carried out in order to have a theoretical knowledge for the construction of the tool. The developed tool has four variables: capital, rate, time and amount. By supplying three of the four variables, the fourth variable is obtained. In view of this, it appears that the built tool allows the calculation of basic variables of Financial Mathematics, and can be used for professional purposes or facilitate the teaching and learning process of this area of Mathematics, providing more dynamic and interactive classes capable of arousing interest. and students’ attention to understanding the concepts behind the content, not limiting it to the application of formulas and the performance of exhaustive and repetitive calculations.