Add to ORKGThe subject of the thesis is design of an application for calculation of financial situation in the firm INKAREA s.r.o, which I have chosen. The software will be programmed in the intuitive environment of MS Excel with the help of VBA. I will use the reports from the accountancy during the years 2013–2017, which are going to be more analysed in the practical part. The theoretical part will be dedicated to description of statistical methods and indicators as well as introducing the chosen firm. In the end I would like to evaluate the firm´s condition and some possible suggestions for improvement of the strategy on the market