Implementación de modelos financieros en hojas de cálculo para la toma de decisiones de inversión

Abstract

The objective of this research was to implement financial models in spreadsheets for investment decision making. The research design was non-experimental, descriptive, bibliographic and documentary; therefore, there is no population, nor sample. The implementation proposal was oriented towards financial evaluation and the automation of four indicators was worked on, such as the Net Present Value (NPV), the Internal Rate of Return (IRR), the Cost Benefit Coefficient (CBC) and the Recovery Period (PR). Regarding the conclusions, it can be indicated in the first place that the implementation of automated financial models to evaluate an investment must start from the calculation of the four standardized indicators. Secondly, for the automation of the Net Present Value and the Internal Rate of Return, the most efficient is the use of the NAV and IRR functions respectively. It was also possible to conclude that for the optimization of the calculation of the Cost Benefit Coefficient and the Recovery Period, the most convenient is the implementation of formulas by the user.