Mathematical and Statistical Methods as Support of the Development of Software Applications

This diploma thesis disserts mainly on the software application development created through language Visual Basic for Application, which serves to creation of macros and automation of work in Microsoft Excel. The Application is made specially for company PENTACO, spol. s.r.o. The software allows to calculate complete financial analysis of company for last 8 years. Statistical methods are used for prediction of future indicators. The financial analysis will reveal the weaknesses and strengths of the company and on their basis will be suggested solutions for fixing of problems and company situation