SANTOS, F. G.; http://lattes.cnpq.br/7001006658868274; SANTOS, Felipe Galdino dos.
Resumo:
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.