Diploma thesis is focused on the analysis of the financial health of microenterprise using statistical methods, specifically time series. The selected size of the enterprise is related to important asset, since this type of analysis is not usually automated. In theoretical part, thesis will discuss each monitored indicator that forms the basis for statistical analysis, which is also described in the theoretical level. The practical part will focus on specific statements obtained, their financial and statistical analysis, and then creating a program in the language of Excel VBA to automate these activities