Utilização de planilhas eletrônicas como ferramenta de auxílio na gestão financeira de micro e pequenas empresas

Abstract

With so many changes happening in the Brazilian economy, technological advances and globalization, to keep an industry in the market there must be a financial balance. The current financial sector managers constantly seek to maintain the liquidity of companies in general. But this is still a great challenge because it is impossible to predict the future, to identify when there is no need to raise funds or apply. To assist managers in these industries and reduce the time needed to cash flow problems and provide more time to reflect on the decision-making, we sought to develop a model for projecting cash flow, through spreadsheets. The result of this study was able to create spreadsheets to project procurement, sales and the result of the industry. Besides being able to see the projected cash flow and compare it with the director.