Seven Editora
##common.pageHeaderLogo.altText##
##common.pageHeaderLogo.altText##


Contact

  • Seven Publicações Ltda CNPJ: 43.789.355/0001-14 Rua: Travessa Aristides Moleta, 290- São José dos Pinhais/PR CEP: 83045-090
  • Principal Contact
  • Nathan Albano Valente
  • (41) 9 8836-2677
  • editora@sevenevents.com.br
  • Support Contact
  • contato@sevenevents.com.br

Solver as a financial asset allocation tool

Rodrigues Matsumoto A;
Bruno Lopes de Souza Brito G;
Luz da Conceição M;
Ferreira de Oliveira Junior W;
Aragão Ferreira Silva P;
Yani Figueira de Holanda G;
Cavalcante Saldanha D;
Filipe Lima Raposo C

André Rodrigues Matsumoto

Giovanni Bruno Lopes de Souza Brito

Marcio Luz da Conceição

Waldecy Ferreira de Oliveira Junior

Paola Aragão Ferreira Silva

Genifer Yani Figueira de Holanda

Dayanne Cavalcante Saldanha

Cláudio Filipe Lima Raposo


Keywords

Investment portfolio
Diversifiable risk
Solver.

Abstract

The definition of an investment portfolio usually depends on the elaboration of a strategy, which may or may not be successful in its results. Obviously, in this context, there will be an arrangement with the allocated assets, according to the idealized strategy. That said, naturally arises the need to have good instruments to assist in the configuration of this investment portfolio. To fulfill this purpose, Microsoft Excel's Solver tool emerges as an interesting candidate to meet this demand, being able to facilitate the search for the best combination of financial assets, given a certain level of risk, or Beta. The objective of the study was to verify the feasibility of using the solver tool in the construction of an investment portfolio, seeking to reduce or even eliminate the diversifiable risk. This study is characterized as an experiment, of an exploratory nature, of a quantitative nature, and the results were obtained through simulation in Microsoft's software. The information that guided the research was obtained from an electronic site, scientific article and newspaper. It was found that Solver was able to meet the objective, according to the adoption of the desired parameters, however, to strengthen the understanding, it is still necessary to increase the set of financial assets, which have negative correlations with each other as a characteristic.

 

DOI: 10.56238/pacfdnsv1-116


Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

Copyright (c) 2023 André Rodrigues Matsumoto, Giovanni Bruno Lopes de Souza Brito, Marcio Luz da Conceição, Waldecy Ferreira de Oliveira Junior, Paola Aragão Ferreira Silva , Genifer Yani Figueira de Holanda, Dayanne Cavalcante Saldanha, Cláudio Filipe Lima Raposo

Author(s)

  • André Rodrigues Matsumoto
  • Giovanni Bruno Lopes de Souza Brito
  • Marcio Luz da Conceição
  • Waldecy Ferreira de Oliveira Junior
  • Paola Aragão Ferreira Silva
  • Genifer Yani Figueira de Holanda
  • Dayanne Cavalcante Saldanha
  • Cláudio Filipe Lima Raposo