Goal:
The aim of the course is to familiarise students with financial techniques supported by IT solutions. Financial areas such as controlling, business analysis and financial
management will be highlighted. Students will be introduced to computer tools for financial analysis through practical exercises. They will enable them to analyse and understand their operation and their potential uses. The course will cover how to analyse and visualise source data with differences in magnitude and how to quickly produce charts and statements. An additional important unit of study is the solution of linear programming (or other optimization) problems with large numbers of variables and constraints. There is a wide range of software developed to solve optimisation problems efficiently. Their applications and capabilities are reviewed. General optimisation problems are also solved, where the constraints and the objective function are not necessarily linear. Thus, in addition to linear programming problems, solutions to nonlinear optimization problems are also covered.
Course description:
The course includes: Introduction to financial technologies, rules of charting, charting options, functions to be used in financial analysis, approximation, target value search (APR, calculation of break-even points) and optimisation (bottlenecks, production losses, collateral losses) procedures (SOLVER), handling large data tables, company analyses, report tables (PIVOT), financial calculations, annuity and non-annuity credit constructions, complex calculations, solutions to problems.