Herramienta ofimática (Excel) para la toma de decisiones financieras.

Abstract

My proposal is based on the creation of an office tool in which the management and some employees of the company can be supported when making decisions, taking as reference some financial indicators studied during the execution of the proposal, these are: EBIT, EBITDA, and FINANCIAL EBITDA. This tool was developed with financial information of the company during the periods from January 2018 to August of the same year, this information was used as a basis for the realization of the tool as a starting point we take the monthly movements of the organization, but for confidentiality issues the final information present in the tool has fictitious data. Throughout the execution of the tool, different dynamic tables were made that would allow me to catalog the different accounts according to the group to which they belong and the concept to which they refer, that is, income, costs, expenses, etc. Finally, a "dashboard" graphic model was created that reflects the company's financial information in a general way, seeking to optimize the time it takes senior management to make decisions and thus generate strategies in the shortest possible time. It should be noted that this proposal will positively benefit the company, as it will allow managers to quickly access financial information and make decisions in the shortest possible time.