{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["List1","aktiva1","pasiva1","vzz1","Analyza","Likvidita","Rentabilita","Aktivita","Zadlzenost","hori_aktiva","hori_pasiva","List5","List6"],"not_rendered":{"charts":18,"images":2,"macros":1,"external_links":1,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"List1","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,0,4,9]]}
[]
[]
[]
[]
["Softwarová aplikácia pre finančnú analýzu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Autor: Zuzana Mičáková"]

{"sheet":"aktiva1","index":1,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,9,3,9],[2,10,3,10],[0,0,1,10],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["AKTÍVA"]
[]
["Označenie","Názov","Číslo riadka",2014,2015,2016,2017,2018,2019]
[]
["","SPOLU MAJETOK r. 02 + r. 14","1",455454,273860,227102,170585,304092,260096]
["A.","Neobežný majetok r. 03 + r. 04 + r. 09","2",23502,25560,16921,32334,39511,28245]
["A.I.","Dlhodobý nehmotný majetok (012, 013, 014, 015, 019, 01X, 041, 051) - /072, 073, 074, 075, 079, 07X, 091, 093, 095A/","3"]
["A.II.","Dlhodobý hmotný majetok súčet (r. 05 až r. 08)","4",23502,25560,16921,32334,39511,28245]
["A.II.1.","Pozemky a stavby (021, 031, 042A, 052A) - /081, 092A, 094A, 095A/","5"]
["2.","Samostatné hnuteľné veci a súbory hnuteľných vecí (022, 02X, 042A, 052A) - /082, 08XA, 092A, 094A, 095A/","6",null,null,null,32334,39511,28245]
["3.","Ostatný dlhodobý hmotný majetok (025, 026, 029, 02X, 032, 042A, 052A) - /085, 086, 089, 08XA, 092A, 094A, 095A/","7"]
["4.","Opravná položka k nadobudnutému majetku (+/- 097 ) - /+/- 098/","8"]
["A.III.","Dlhodobý finančný majetok súčet (r. 10 až r. 13)","9"]
["A.III.1.","Podielové cenné papiere (061, 062, 063, 043A, 053A) - /095A, 096A/","10"]
["2.","Ostatný dlhodobý finančný majetok (065A, 066A, 067A, 069, 06XA, 043A, 053A) - /095A, 096A/","11"]
["3.","Účty v bankách s dobou viazanosti dlhšou ako jeden rok (22XA)","12"]
["4.","Ostatný dlhodobý finančný majetok so zostatkovou dobou splatnosti najviac jeden rok (065A, 066A, 067A, 06XA) - /096A/","13"]
["B.","Obežný majetok r. 15 + r. 16 + r. 17 + r. 21","14",431952,248300,210181,138251,264581,231851]
["B.I.","Zásoby (112, 119, 11X, 121, 122, 123, 124, 12X, 132, 133, 13X, 139, 314A) - /191, 192, 193, 194, 195, 196, 19X, 391A/","15",18209,20961,29996,13807,63318,78979]
["B.II.","Dlhodobé pohľadávky (311A, 312A, 313A, 314A, 315A, 316A, 31XA, 335A, 336A, 33XA, 354A, 355A, 358A, 35XA, 371A, 374A, 375A, 378A, 381A, 382A, 385A) - 391A","16",null,82,0,1450,-1186,273]
["B.III.","Krátkodobé pohľadávky súčet (r. 18 až r. 20)","17",270942,120747,92621,83420,189614,137079]
["B.III.1.","Pohľadávky z obchodného styku (311A, 312A, 313A, 314A, 315A, 316A, 31XA) - /391A/","18",267119,119412,84900,81897,189614,137059]
["2.","Sociálne poistenie, daňové pohľadávky a dotácie (336A, 341A, 342A, 343A, 345A, 346A, 347A, 34XA) - /391A/","19",3823,1335,7582,1523]
["3.","Ostatné pohľadávky (335A, 336A, 33XA, 354A, 355A, 358A, 35XA, 371A, 374A, 375A, 378A, 381A, 382A, 385A, 398A) - /391A/","20",null,null,null,null,null,20]
["B.IV.","Finančný majetok r. 22 + r. 23","21",142801,106510,87564,39574,12835,15520]
["B.IV.1.","Peniaze a účty v bankách (211, 213, 21X, 221A, 22XA, +/- 261)","22",142801,106510,87564,39574,12835,15520]
["2.","Ostatné finančné účty (251, 252, 253, 256, 257, 25X, 259, 314A) - /291, 29X/","23"]

{"sheet":"pasiva1","index":2,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,9,3,9],[2,10,3,10],[0,0,1,10],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["PASÍVA"]
[]
["Označenie","Názov","Číslo riadka",2014,2015,2016,2017,2018,2019]
[]
["","SPOLU VLASTNÉ IMANIE A ZÁVÄZKY r. 25 + r. 34","24",455454,273860,227102,170585,304092,260096]
["A.","Vlastné imanie r. 26 + r. 29 + r. 30 + r. 31 + r. 32 + r. 33","25",46010,53480,58043,47944,94354,101263]
["A.I.","Základné imanie r. 27 + r. 28","26",6639,6639,6639,6639,6639,6639]
["A.I.1.","Základné imanie a zmeny základného imania (411, +/- 419) alebo (+/- 491)","27",null,null,null,6639,6639,6639]
["2.","Pohľadávky za upísané vlastné imanie (/-/353)","28"]
["A.II.","Kapitálové fondy (412, 413, 417, 418)","29",0,0,0,null,49214,49214]
["A.III.","Fondy zo zisku (421, 422, 423, 427, 42X)","30",889,1392,1393,1393,1393,1393]
["A.IV.","Oceňovacie rozdiely (+/- 415, 416)","31"]
["A.V.","Nerozdelený zisk alebo neuhradená strata minulých rokov (428, /-/429)","32",28411,37979,45448,50010,39912,37107]
["A.VI.","Výsledok hospodárenia za účtovné obdobie po zdanení (+/-) r. 01 - (r. 26 + r. 29 + r. 30 + r. 31 + r. 32 + r. 34)","33",10071,7470,4563,-10098,-2804,6910]
["B.","Záväzky r. 35 + r. 36 + r. 37 + r. 38 + r. 43 + r. 44 + r. 45","34",409444,220380,169059,122641,209738,158833]
["B.I.","Dlhodobé záväzky okrem rezerv a úverov (316A, 321A, 32XA, 372A, 471A, 472A, 473A, 474A, 475A, 476A, 478A, 479A, 47XA, /-/255A, 383A, 384A)","35",15520,13475,8080,2887,330,342]
["B.II.","Dlhodobé rezervy (451A, 459A, 45XA)","36"]
["B.III.","Dlhodobé bankové úvery (461A, 46XA)","37",null,null,null,22355,36421,27654]
["B.IV.","Krátkodobé záväzky okrem rezerv, úverov a výpomoci súčet (r. 39 až r. 42)","38",393924,219822,160725,66643,172987,130837]
["B.IV.1.","Krátkodobé záväzky z obchodného styku (316A, 321A, 32XA, 322, 324, 325, 326, 32X, 475A, 476A, 478A, 479A, 47XA)","39",null,null,null,59812,128293,110993]
["2.","Záväzky voči zamestnancom a zo sociálneho poistenia (331, 333, 336A, 33X, 479A)","40",null,null,null,3922,2918,4234]
["3.","Daňové záväzky a dotácie (341A, 342A, 343A, 345A, 346A, 347A, 34XA)","41",null,null,null,2059,4270,5017]
["4.","Ostatné krátkodobé záväzky (364, 365, 366, 367, 368A, 36X, 372A, 379, 383A, 384A, 398A, 471A, 472A, 474A, 478A, 479A, 47XA)","42",null,null,null,850,37506,10593]
["B.V.","Krátkodobé rezervy (323, 32XA, 451A, 459A, 45XA)","43",null,-12917,254,756]
["B.VI.","Bežné bankové úvery (221A, 231, 232, 23X, 461A, 46XA)","44"]
["B.VII.","Krátkodobé finančné výpomoci (241, 249, 24X, 473A, /-/255A)","45",null,null,null,30000]

{"sheet":"vzz1","index":3,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[2,9,3,9],[2,10,3,10],[0,0,1,10],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8]]}
["VZZ"]
[]
["Označenie","Názov","Číslo riadka",2014,2015,2016,2017,2018,2019]
[]
["*","Výnosy z hospodárskej činnosti spolu súčet (r. 02 až r. 07)","1",923977,696952,578268,347907,527556,718787]
["I.","Tržby z predaja tovaru (604, 607)","2",919776,689874,577313,318842,502479,694770]
["II.","Tržby z predaja vlastných výrobkov a služieb (601, 602, 606)","3",null,null,null,2071,4446,6471]
["III.","Zmena stavu vnútroorganizačných zásob (+/-) (účtová skupina 61)","4"]
["IV.","Aktivácia (účtová skupina 62)","5"]
["V.","Tržby z predaja dlhodobého nehmotného majetku, dlhodobého hmotného majetku a materiálu (641, 642)","6",1083,520,null,null,10667]
["VI.","Ostatné výnosy z hospodárskej činnosti (644, 645, 646, 648, 655, 657)","7",2098,5675,955,26994,9964,17546]
["*","Náklady na hospodársku činnosť spolu súčet (r. 09 až r. 17)","8",910237,685508,574377,352470,526659,707188]
["A.","Náklady vynaložené na obstaranie predaného tovaru (504, (+/- ) 505A, 507)","9",814632,555314,431707,253051,370429,515031]
["B.","Spotreba materiálu, energie a ostatných neskladovateľných dodávok (501, 502, 503, (+/-) 505A)","10",6798,7966,5622,8711,10618,12606]
["C.","Služby (účtová skupina 51)","11",80895,108997,100712,33034,75972,101995]
["D.","Osobné náklady (účtová skupina 52)","12",null,null,20315,29622,46940,54981]
["E.","Dane a poplatky (účtová skupina 53)","13",699,784,1529,1526,2368,1728]
["F.","Odpisy a opravné položky k dlhodobému nehmotnému majetku a dlhodobému hmotnému majetku (551, (+/-) 553)","14",6087,5987,8638,12745,14929,16255]
["G.","Zostatková cena predaného dlhodobého majetku a predaného materiálu (541, 542)","15",null,3528,null,null,825]
["H.","Opravné položky k pohľadávkam (+/- 547)","16"]
["I.","Ostatné náklady na hospodársku činnosť (543, 544, 545, 546, 548, 549, 555, 557)","17",1126,2932,5854,13781,4578,4592]
["**","Výsledok hospodárenia z hospodárskej činnosti (+/-) (r. 01 - r. 08)","18",13740,11444,3891,-4563,897,11599]
["*","Pridaná hodnota (r. 02 - r. 09) + (r. 03 + r. 04 + r. 05) - (r. 10 + r. 11)","19",18471,18480,39272,26117,49906,71609]
["*","Výnosy z finančnej činnosti spolu súčet (r. 21 až r. 26)","20",4,4,4496,91,66]
["VII.","Tržby z predaja cenných papierov a podielov (661)","21"]
["VIII.","Výnosy z dlhodobého finančného majetku (665)","22"]
["IX.","Výnosy z krátkodobého finančného majetku (666)","23"]
["X.","Výnosové úroky (662)","24",4,4,1]
["XI.","Kurzové zisky (663)","25",null,null,null,91,66]
["XII.","Ostatné výnosy z finančnej činnosti (668)","26",null,null,4495]
["*","Náklady na finančnú činnosť spolu súčet (r. 28 až r. 33)","27",509,1098,842,4303,3205,2042]
["J.","Predané cenné papiere a podiely (561)","28"]
["K.","Náklady na krátkodobý finančný majetok (566)","29"]
["L.","Opravné položky k finančnému majetku (+/-) (565)","30"]
["M.","Nákladové úroky (562)","31",65,null,null,614,1355,1684]
["N.","Kurzové straty (563)","32",null,null,null,1455,515,17]
["O.","Ostatné náklady na finančnú činnosť (568, 569)","33",444,1098,842,2234,1335,341]
["**","Výsledok hospodárenia z finančnej činnosti (+/-) (r. 20 - r. 27)","34",-505,-1094,3654,-4212,-3139,-2042]
["**","Výsledok hospodárenia za účtovné obdobie pred zdanením (+/-) (r. 18 + r. 34)","35",13235,10350,7545,-8775,-2242,9557]
["P.","Daň z príjmov (591, 595)","36",3164,2880,2982,1323,562,2647]
["Q.","Prevod podielov na výsledku hospodárenia spoločníkom (+/-) (596)","37"]
["***","Výsledok hospodárenia za účtovné obdobie po zdanení (+/-) (r. 35 - r. 36 - r. 37)","38",10071,7470,4563,-10098,-2804,6910]

{"sheet":"Analyza","index":4,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":true,"merged":[[22,1,22,3],[23,1,23,3],[16,1,16,4],[2,1,2,4],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3]]}
[]
[]
[null,"Bežná likvidita"]
[]
[]
[null,"i","Rok","Bežná likvidita","Regresná priamka"]
[null,1,2014,1.0965363877296128,1.1040000000000001,null,null,null,null,null,null,null,1,{"$f":"POWER(M7,2)","v":1},null,{"$f":"B7*D7","v":1.0965363877296128}]
[null,2,2015,1.1295502724931989,1.2569999999999999,null,null,null,null,null,null,null,2,{"$f":"POWER(M8,2)","v":4},null,{"$f":"B8*D8","v":2.2591005449863979}]
[null,3,2016,1.3077057085083217,1.41,null,null,null,null,null,null,null,3,9,null,{"$f":"B9*D9","v":3.9231171255249651}]
[null,4,2017,2.0745014480140451,1.5629999999999999,null,null,null,null,null,null,null,4,16,null,8.2980057920561805]
[null,5,2018,1.5294848745859515,1.716,null,null,null,null,null,null,null,5,25,null,7.6474243729297573]
[null,6,2019,1.772059891315148,1.869,null,null,null,null,null,null,null,6,36,null,10.632359347890887]
[null,7,2020,null,2.0219999999999998,null,null,null,null,null,null,null,null,{"$f":"SUM(N7:N12)","v":91}]
[null,8,2021,null,2.1749999999999998,null,null,null,null,null,null,null,{"$f":"SUM(M7:M12)/6","v":3.5},{"$f":"SUM(N7:N12)/6","v":15.166666666666666},null,{"$f":"SUM(P7:P12)","v":33.856543571117797}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"POWER(M14,2)","v":12.25}]
[]
[null,"Charakteristiky trendu"]
[null,"     b1:",null,null,0.95099999999999996]
[null,"     b2:",null,null,0.153]
[null,"     b3:"]
[null,"     Rovnica:",null,null,"y(x) = 0,951 + 0,153*x"]
[null,"     Priemer č. radu:",null,null,{"$f":"ROUND((SUM(D7:D12)/6),3)","v":1.4850000000000001}]
[null,"     Priemer 1. dif:",null,null,{"$f":"ROUND((D12-D7)/5,3)","v":0.13500000000000001}]
[null,"     Priemer koef. rastu:",null,null,{"$f":"ROUND((POWER(D12/D7,1/5)),3)","v":1.101}]

{"sheet":"Likvidita","index":5,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Ukazovateľ","2014","2015","2016","2017","2018","2019"]
["Bežná likvidita",1.0965363877296128,1.1295502724931989,1.3077057085083217,2.0745014480140451,1.5294848745859515,1.772059891315148]
["Pohotová likvidta",1.0503117352585778,1.0341958493690349,1.1210763726862654,1.8673228996293685,1.1634573696289316,1.1684156622362176]
["Okamžitá likvidita",0.36250901189061852,0.48452839115284185,0.54480634624358371,0.59382080638626711,7.4196326891616135E-2,0.11862087941484442]

{"sheet":"Rentabilita","index":6,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Ukazovateľ","2014","2015","2016","2017","2018","2019"]
["ROA [%]",2.2112002529344346,2.7276710728109252,2.0092293330750062,-5.9196295102148486,-0.92208936769135663,2.6567113681102361]
["ROE [%]",21.888719843512281,13.967838444278236,7.8614130902951258,-21.06207241782079,-2.9717870996460141,6.8238152138490857]
["ROI [%]",2.9201631778401334,3.7793032936536917,3.3222957085362528,-4.7841252161678929,-0.29168804177683072,4.3218657726377954]
["ROCE [%]",16.473265073947669,11.15674706892689,6.9007758268681094,-12.958762604869783,-1.1052210060638419,6.6486666305634419]
["ROS [%]",1.4460042445117072,1.5002739630715174,1.3069166985673282,-2.5430568409506629,-0.17497657444395129,1.6030152258638612]

{"sheet":"Aktivita","index":7,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Ukazovateľ","2014","2015","2016","2017","2018","2019"]
["Obrat celkových aktív",2.0194706820008168,2.5190754400058424,2.5420868156158907,1.8812498168068705,1.6670119569077779,2.6960852915846458]
["Obrat stálych aktív",39.136073525657388,26.990375586854459,34.118137225932273,9.9249396919651147,12.829971400369518,24.827084439723844]
["Obrat zásob",50.512164314350045,32.91226563618148,19.24633284437925,23.242775403780691,8.0060172462806793,8.8788285493612218]
["Doba obratu zásob [deň]",7.2259821956650319,11.090090364327398,18.964651757365587,15.703804457906038,45.590708684716674,41.109026711216259]
["Doba obratu pohľadávok [deň]",107.51947213234527,63.928463748452621,58.558641499498535,96.529433210870238,135.67336390984858,71.492511133832735]
["Doba obratu záväzkov [deň]",162.4820173607487,123.43327187283474,106.72516468536134,79.082025346433468,124.7930265818415,68.279428898196201]

{"sheet":"Zadlzenost","index":8,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Ukazovateľ","2014","2015","2016","2017","2018","2019"]
["Celková zadlženosť",0.89897991893802665,0.80471773899072518,0.74441880740812494,0.71894363513790782,0.6897189008589506,0.61067067544291342]
["Koeficient samofinancovania",0.10102008106197333,0.19528226100927482,0.25558119259187501,0.28105636486209223,0.3102810991410494,0.38932932455708663]
["Úrokové krytie",204.61538461538461,null,null,-13.291530944625407,-0.65461254612546127,6.6751781472684089]

{"sheet":"hori_aktiva","index":9,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":true,"merged":[[0,0,1,7],[29,0,30,7],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[31,7,32,7],[31,8,32,8],[31,9,32,9],[31,10,32,10],[31,0,32,0],[31,1,32,1],[31,2,32,2],[31,3,32,3],[31,4,32,4],[31,5,32,5],[31,6,32,6]]}
["AKTÍVA"]
[]
["Označenie","Názov","Číslo riadka",2014,2015,2016,2017,2018]
[]
["","SPOLU MAJETOK","1",-181594,-46758,-56517,133507,-43996]
["A.","Neobežný majetok ","2",2058,-8639,15413,7177,-11266]
["A.I.","Dlhodobý nehmotný majetok ","3"]
["A.II.","Dlhodobý hmotný majetok súčet ","4",2058,-8639,15413,7177,-11266]
["A.II.1.","Pozemky a stavby","5"]
["2.","Samostatné hnuteľné veci a súbory hnuteľných vecí ","6",null,null,32334,7177,-11266]
["3.","Ostatný dlhodobý hmotný majetok ","7"]
["4.","Opravná položka k nadobudnutému majetku","8"]
["A.III.","Dlhodobý finančný majetok súčet ","9"]
["A.III.1.","Podielové cenné papiere ","10"]
["2.","Ostatný dlhodobý finančný majetok ","11"]
["3.","Účty v bankách s dobou viazanosti dlhšou ako jeden rok ","12"]
["4.","Ostatný dlhodobý finančný majetok","13"]
["B.","Obežný majetok","14",-183652,-38119,-71930,126330,-32730]
["B.I.","Zásoby ","15",2752,9035,-16189,49511,15661]
["B.II.","Dlhodobé pohľadávky ","16",82,null,1450,-2636,1459]
["B.III.","Krátkodobé pohľadávky súčet ","17",-150195,-28126,-9201,106194,-52535]
["B.III.1.","Pohľadávky z obchodného styku ","18",-147707,-34512,-3003,107717,-52555]
["2.","Sociálne poistenie, daňové pohľadávky a dotácie ","19",-2488,6247,-6059]
["3.","Ostatné pohľadávky","20",null,null,null,null,20]
["B.IV.","Finančný majetok","21",-36291,-18946,-47990,-26739,2685]
["B.IV.1.","Peniaze a účty v bankách ","22",-36291,-18946,-47990,-26739,2685]
["2.","Ostatné finančné účty ","23"]
[]
[]
["AKTÍVA"]
[]
["Označenie","Názov","Číslo riadka",{"$f":" D3","v":2014},{"$f":" E3","v":2015},2016,2017,2018]
[]
["","SPOLU MAJETOK","1",-0.39870985873436177,-0.17073687285474329,-0.24886174494280103,0.7826420845912595,-0.14467989950409743]
["A.","Neobežný majetok ","2",8.7567015573142712E-2,-0.33798904538341157,0.91087997163288226,0.22196449557741077,-0.28513578497127384]
["A.I.","Dlhodobý nehmotný majetok ","3"]
["A.II.","Dlhodobý hmotný majetok súčet ","4",8.7567015573142712E-2,-0.33798904538341157,0.91087997163288226,0.22196449557741077,-0.28513578497127384]
["A.II.1.","Pozemky a stavby","5"]
["2.","Samostatné hnuteľné veci a súbory hnuteľných vecí ","6",null,null,32334,0.22196449557741077,-0.28513578497127384]
["3.","Ostatný dlhodobý hmotný majetok ","7"]
["4.","Opravná položka k nadobudnutému majetku","8"]
["A.III.","Dlhodobý finančný majetok súčet ","9"]
["A.III.1.","Podielové cenné papiere ","10"]
["2.","Ostatný dlhodobý finančný majetok ","11"]
["3.","Účty v bankách s dobou viazanosti dlhšou ako jeden rok ","12"]
["4.","Ostatný dlhodobý finančný majetok ","13"]
["B.","Obežný majetok","14",-0.42516761121606106,-0.15351993556182039,-0.34222884085621441,0.91377277560379311,-0.12370502794985279]
["B.I.","Zásoby ","15",0.15113405458839035,0.43103859548685652,-0.5397052940392052,3.5859346708191495,0.24733882940080229]
["B.II.","Dlhodobé pohľadávky ","16",82,null,1450,-1.8179310344827586,-1.2301854974704891]
["B.III.","Krátkodobé pohľadávky súčet ","17",-0.55434373408330939,-0.23293332339519823,-9.9340322389091032E-2,1.2730040757612084,-0.277062875104159]
["B.III.1.","Pohľadávky z obchodného styku ","18",-0.55296328602607825,-0.28901617927846446,-3.5371024734982333E-2,1.3152740637630194,-0.27716835254780764]
["2.","Sociálne poistenie, daňové pohľadávky a dotácie ","19",-0.65079780277269161,4.67940074906367,-0.79912951727776316]
["3.","Ostatné pohľadávky","20"]
["B.IV.","Finančný majetok","21",-0.25413687579218636,-0.17788001126654773,-0.54805627883605135,-0.67567089503209177,0.20919361121932217]
["B.IV.1.","Peniaze a účty v bankách ","22",-0.25413687579218636,-0.17788001126654773,-0.54805627883605135,-0.67567089503209177,0.20919361121932217]
["2.","Ostatné finančné účty ","23"]

{"sheet":"hori_pasiva","index":10,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":true,"merged":[[0,0,1,7],[30,5,31,5],[30,6,31,6],[28,0,29,7],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[30,0,31,0],[30,1,31,1],[30,2,31,2],[30,3,31,3],[2,9,3,9],[2,10,3,10],[2,8,3,8],[30,4,31,4],[30,7,31,7],[30,8,31,8],[30,9,31,9],[30,10,31,10]]}
["PASÍVA"]
[]
["Označenie","Názov","Číslo riadka",2014,2015,2016,2017,2018]
[]
["","SPOLU VLASTNÉ IMANIE A ZÁVÄZKY ","24",-181594,-46758,-56517,133507,-43996]
["A.","Vlastné imanie ","25",7470,4563,-10099,46410,6909]
["A.I.","Základné imanie","26",0,0,0,0,0]
["A.I.1.","Základné imanie a zmeny základného imania ","27",null,null,6639,0,0]
["2.","Pohľadávky za upísané vlastné imanie ","28"]
["A.II.","Kapitálové fondy ","29",null,null,null,49214,0]
["A.III.","Fondy zo zisku ","30",503,1,0,0,0]
["A.IV.","Oceňovacie rozdiely ","31"]
["A.V.","Nerozdelený zisk alebo neuhradená strata minulých rokov ","32",9568,7469,4562,-10098,-2805]
["A.VI.","Výsledok hospodárenia za účtovné obdobie po zdanení ","33",-2601,-2907,-14661,7294,9714]
["B.","Záväzky ","34",-189064,-51321,-46418,87097,-50905]
["B.I.","Dlhodobé záväzky okrem rezerv a úverov","35",-2045,-5395,-5193,-2557,12]
["B.II.","Dlhodobé rezervy ","36"]
["B.III.","Dlhodobé bankové úvery ","37",null,null,22355,14066,-8767]
["B.IV.","Krátkodobé záväzky okrem rezerv, úverov a výpomoci súčet ","38",-174102,-59097,-94082,106344,-42150]
["B.IV.1.","Krátkodobé záväzky z obchodného styku ","39",null,null,59812,68481,-17300]
["2.","Záväzky voči zamestnancom a zo sociálneho poistenia ","40",null,null,3922,-1004,1316]
["3.","Daňové záväzky a dotácie ","41",null,null,2059,2211,747]
["4.","Ostatné krátkodobé záväzky ","42",null,null,850,36656,-26913]
["B.V.","Krátkodobé rezervy","43",-12917,13171,502]
["B.VI.","Bežné bankové úvery ","44"]
["B.VII.","Krátkodobé finančné výpomoci ","45",null,null,30000]
[]
[]
["PASÍVA"]
[]
["Označenie","Názov","Číslo riadka",2014,2015,2016,2017,2018]
[]
["","SPOLU VLASTNÉ IMANIE A ZÁVÄZKY ","24",-0.39870985873436177,-0.17073687285474329,-0.24886174494280103,0.7826420845912595,-0.14467989950409743]
["A.","Vlastné imanie ","25",0.16235600956313845,8.532161555721765E-2,-0.1739916958117258,0.96800433839479394,7.3224240625728645E-2]
["A.I.","Základné imanie","26",1.5062509414068384E-4,1.5062509414068384E-4,1.5062509414068384E-4,1.5062509414068384E-4]
["A.I.1.","Základné imanie a zmeny základného imania ","27",null,null,0,1.5062509414068384E-4]
["2.","Pohľadávky za upísané vlastné imanie ","28"]
["A.II.","Kapitálové fondy ","29",null,null,null,0]
["A.III.","Fondy zo zisku ","30",0.56580427446569181,7.1839080459770114E-4,7.1787508973438624E-4,7.1787508973438624E-4]
["A.IV.","Oceňovacie rozdiely ","31"]
["A.V.","Nerozdelený zisk alebo neuhradená strata minulých rokov ","32",0.33677096899088382,0.1966613128307749,0.10037845449744763,-0.20191961607678463,-7.0279615153337346E-2]
["A.VI.","Výsledok hospodárenia za účtovné obdobie po zdanení ","33",-0.25826630920464699,-0.38915662650602412,-3.2130177514792901,-0.72232125173301642,-3.4643366619115548]
["B.","Záväzky ","34",-0.46175789607369994,-0.23287503403212634,-0.27456686718837803,0.71017848843372122,-0.24270756849021161]
["B.I.","Dlhodobé záväzky okrem rezerv a úverov","35",-0.13176546391752578,-0.40037105751391466,-0.64269801980198016,-0.88569449255282295,3.6363636363636362E-2]
["B.II.","Dlhodobé rezervy ","36"]
["B.III.","Dlhodobé bankové úvery ","37",null,null,0,0.62921046745694476,-0.24071277559649654]
["B.IV.","Krátkodobé záväzky okrem rezerv, úverov a výpomoci súčet ","38",-0.44196850153836781,-0.26884024346971641,-0.58536008710530407,1.5957264829014299,-0.2436599282026973]
["B.IV.1.","Krátkodobé záväzky z obchodného styku ","39",null,null,0,1.1449374707416571,-0.13484757547177165]
["2.","Záväzky voči zamestnancom a zo sociálneho poistenia ","40",null,null,0,-0.25599184089750127,0.45099383139136395]
["3.","Daňové záväzky a dotácie ","41",null,null,0,1.0738222438076737,0.17494145199063232]
["4.","Ostatné krátkodobé záväzky ","42",null,null,0,43.124705882352941,-0.71756518956966886]
["B.V.","Krátkodobé rezervy","43",0,-1.019664008670744,1.9763779527559056]
["B.VI.","Bežné bankové úvery ","44"]
["B.VII.","Krátkodobé finančné výpomoci ","45",null,null,0]

{"sheet":"List5","index":11,"n_rows":33,"n_cols":29,"rows_kept":33,"cut":false,"hidden":true,"merged":[[6,26,6,27],[30,15,30,16]]}
[]
[]
[null,"Rok t","Poradie x=1","yi","1.diferencia","koeficient rastu","koeficient rastu v %"]
[null,2014,1,38028,null,null,null,null,null,null,null,null,null,null,null,null,"i","xi","yi","xi^2","xi*yi","y so strieškou","ei","ei^2","(y1-y priemer)^2","vyrovnané údaje"]
[null,2015,2,46478,{"$f":"D5-D4","v":8450},{"$f":"D5/D4","v":1.2222046912801094},{"$f":"(D5-D4)/D4","v":0.22220469128010939},null,null,null,null,null,"x priemer","na druhu",null,null,1,1,919776,{"$f":"ROUND(POWER(R5,2),2)","v":1},{"$f":"ROUND((R5*S5),2)","v":919776},{"$f":"ROUND(($R$28+$R$29*R5),0)","v":-1457003},{"$f":"S5-V5","v":2376779},{"$f":"ROUND((POWER(W5,2)),2)","v":5649078414841},{"$f":"ROUND((POWER((S5-$R$31),2)),2)","v":90261589805.440002},{"$f":"$R$28+($R$29*Q5)","v":-1457003.142857143}]
[null,2016,3,49456,{"$f":"D6-D5","v":2978},{"$f":"D6/D5","v":1.0640733250139851},{"$f":"(D6-D5)/D5","v":6.4073325013985105E-2},null,null,null,null,null,{"$f":"R25/Q33","v":3.5},{"$f":"POWER(M6,2)","v":12.25},null,null,2,2,689874,{"$f":"ROUND(POWER(R6,2),2)","v":4},{"$f":"ROUND((R6*S6),2)","v":1379748},{"$f":"ROUND(($R$28+$R$29*R6),0)","v":-847657},{"$f":"S6-V6","v":1537531},{"$f":"ROUND((POWER(W6,2)),2)","v":2364001575961},{"$f":"ROUND((POWER((S6-$R$31),2)),2)","v":4974998133.4399996},{"$f":"$R$28+($R$29*Q6)","v":-847656.68571428582}]
[null,2017,4,71608,{"$f":"D7-D6","v":22152},1.447913296667745,{"$f":"(D7-D6)/D6","v":0.44791329666774504},null,null,null,null,null,null,null,null,null,3,3,577313,9,1731939,-238310,815623,665240878129,1766296747.1099999,-238310.22857142868,"Index determinácie",null,{"$f":"1-(X25/Y25)","v":-46.196159264917867}]
[null,2018,5,91594,19986,1.279102893531449,0.27910289353144901,null,null,null,null,null,null,null,null,null,4,4,320913,16,1283652,371036,-50123,2512315129,89058873280.440002,371036.22857142845]
[null,2019,6,101014,9420,1.1028451645304278,0.10284516453042776,null,null,null,null,null,null,null,null,null,5,5,506925,25,2534625,980383,-473458,224162477764,12637207168.440001,980382.68571428536]
[null,null,null,{"$f":"SUM(D4:D9)","v":398178},null,null,null,null,null,null,null,null,null,null,null,null,6,6,701241,36,4207446,1589729,-888488,789410926144,6707719200.4399996,1589729.1428571427]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,0,0,null,0,0,null,{"$f":"$R$28+($R$29*Q11)","v":2199075.6}]
[null,null,null,"priemerna hodnota y","priemer 1.d","priemer k",null,null,null,null,null,null,null,null,null,null,8,null,null,0,0,null,0,0,null,2808422.057142857]
[null,null,null,{"$f":"D10/6","v":66363},{"$f":"(D9-D4)/5","v":12597.2},{"$f":"(D9/D4)^(1/5)","v":1.2157817409943328},null,null,null,null,null,null,null,null,null,null,9,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUMA",null,{"$f":"SUM(R5:R24)","v":21},{"$f":"SUM(S5:S24)","v":3716042},{"$f":"SUM(T5:T24)","v":91},{"$f":"SUM(U5:U24)","v":12057186},{"$f":"SUM(V5:V24)","v":398178},null,{"$f":"SUM(X5:X24)","v":9694406587968},{"$f":"SUM(Y5:Y24)","v":205406684335.31}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b1=",58.4,{"$f":"D13-(R29*M6)","v":-2066349.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b2=",408.5,{"$f":"(U25-(Q33*D13*M6))/(T25-(6*N6))","v":609346.45714285714}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y priemer =",null,{"$f":"S25/Q33","v":619340.33333333337}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n= ",6]

{"sheet":"List6","index":12,"n_rows":128,"n_cols":26,"rows_kept":128,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Ukazovateľ","2014","2015","2016","2017","2018","2019",null,null,"Rok","Celková zadlženosť",null,null,null,null,null,"Rok t","Rentabilita tržieb","1.diferencia [€]","Koeficient rastu","Koeficient rastu [%]",null,"Priemer časového radu","Priemer prvých diferencií","Priemer koeficientu rastu"]
[null,"Vlastné imanie [€]",46010,53480,58043,47944,94354,101263,null,null,2014,0.9,null,160.05000000000001,38028,0.9,null,2014,38028,null,null,null,null,{"$f":"List5!D13","v":66363},{"$f":"List5!E13","v":12597.2},{"$f":"List5!F13","v":1.2157817409943328}]
[null,null,null,null,null,null,null,null,null,null,2015,0.8,null,63.05,46478,0.8,null,2015,46478,{"$f":"S4-S3","v":8450},{"$f":"S4/S3","v":1.2222046912801094},{"$f":"(S4-S3)/S3","v":0.22220469128010939}]
[null,null,null,null,null,null,null,null,null,null,2016,0.74,null,57.76,49456,0.74,null,2016,49456,{"$f":"S5-S4","v":2978},{"$f":"S5/S4","v":1.0640733250139851},{"$f":"(S5-S4)/S4","v":6.4073325013985105E-2}]
[null,null,null,null,null,null,null,null,null,null,2017,0.72,null,95.21,71608,0.72,null,2017,71608,{"$f":"S6-S5","v":22152},1.447913296667745,{"$f":"(S6-S5)/S5","v":0.44791329666774504}]
[null,null,0.89897991893802665,0.80471773899072518,0.74441880740812494,0.71894363513790782,0.6897189008589506,0.61067067544291342,null,null,2018,0.69,null,133.81,91594,0.69,null,2018,91594,{"$f":"S7-S6","v":19986},{"$f":"S7/S6","v":1.279102893531449},{"$f":"(S7-S6)/S6","v":0.27910289353144901}]
[null,null,106.04660265108026,63.052731368336829,57.756468328272526,95.207112207981609,133.81482467820683,70.513161666245992,null,null,2019,0.61,null,70.510000000000005,101014,0.61,null,2019,101014,{"$f":"S8-S7","v":9420},1.1028451645304278,0.10284516453042776]
[null,null,154.18171380857947,114.71068629923725,100.22466149211954,77.998709930728893,123.08353306702175,67.344094255755152]
[null,null," 455 454"," 273 860"," 227 102"," 170 585"," 304 092"," 260 096"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1299999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0699999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.77]
[]
[]
[]
[]
[]
[]
[]
[null,"Ukazovateľ","2014","2015","2016","2017","2018","2019"]
[null,"Pracovný kapitál [€]",431952,248300,210181,138251,264581,231851]
[null,"Čistý pracovný kapitál [€]",{"$f":"C31-393924","v":38028},{"$f":"D31-201822","v":46478},{"$f":"E31-160725","v":49456},{"$f":"F31-66643","v":71608},{"$f":"G31-172987","v":91594},{"$f":"H31-130837","v":101014}]
[]
[]
[]
[]
[null,"Ukazovateľ","2014","2015","2016","2017","2018","2019"]
[null,"Bežná likvidita",1.0965363877296128,1.1295502724931989,1.3077057085083217,2.0745014480140451,1.5294848745859515,1.772059891315148]
[null,"Pohotová likvidta",1.0503117352585778,1.0341958493690349,1.1210763726862654,1.8673228996293685,1.1634573696289316,1.1684156622362176]
[null,"Okamžitá likvidita",0.36250901189061852,0.48452839115284185,0.54480634624358371,0.59382080638626711,7.4196326891616135E-2,0.11862087941484442]
[]
[]
[]
[]
[]
[null,"Pracovný kapitál [€]",431952,248300,210181,138251,264581,231851]
[null,"Čistý pracovný kapitál [€]",413743,227339,180185,124444,201263,152872]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ukazovateľ","2014","2015","2016","2017","2018","2019"]
[null,"ROA [%]",2.2112002529344346,2.7276710728109252,2.0092293330750062,-5.9196295102148486,-0.92208936769135663,2.6567113681102361]
[null,"ROE [%]",21.888719843512281,13.967838444278236,7.8614130902951258,-21.06207241782079,-2.9717870996460141,6.8238152138490857]
[null,"ROI [%]",2.9201631778401334,3.7793032936536917,3.3222957085362528,-4.7841252161678929,-0.29168804177683072,4.3218657726377954]
[null,"ROCE [%]",16.473265073947669,11.15674706892689,6.9007758268681094,-12.958762604869783,-1.1052210060638419,6.6486666305634419]
[null,"ROS [%]",1.4460042445117072,1.5002739630715174,1.3069166985673282,-2.5430568409506629,-0.17497657444395129,1.6030152258638612]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ukazovateľ","2014","2015","2016","2017","2018","2019"]
[null,"Obrat celkových aktív",2.0194706820008168,2.5190754400058424,2.5420868156158907,1.8812498168068705,1.6670119569077779,2.6960852915846458]
[null,"Obrat stálych aktív",39.136073525657388,26.990375586854459,34.118137225932273,9.9249396919651147,12.829971400369518,24.827084439723844]
[null,"Obrat zásob",50.512164314350045,32.91226563618148,19.24633284437925,23.242775403780691,8.0060172462806793,8.8788285493612218]
[null,"Doba obratu zásob [deň]",7.1269961381901688,10.938171318240721,18.704862007264691,15.488683848893626,44.966178428761651,40.545889359007816]
[null,"Doba obratu pohľadávok [deň]",106.04660265108026,63.052731368336829,57.756468328272526,95.207112207981609,133.81482467820683,70.513161666245992]
[null,"Doba obratu záväzkov [deň]",154.18171380857947,114.71068629923725,100.22466149211954,77.998709930728893,123.08353306702175,67.344094255755152]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,","]
[]
[]
[]
[]
[]
[null,"Ukazovateľ","2014","2015","2016","2017","2018","2019"]
[null,"Celková zadlženosť",0.89897991893802665,0.80471773899072518,0.74441880740812494,0.71894363513790782,0.6897189008589506,0.61067067544291342]
[null,"Koeficient samofinancovania",0.10102008106197333,0.19528226100927482,0.25558119259187501,0.28105636486209223,0.3102810991410494,0.38932932455708663]
[null,"Úrokové krytie",204.61538461538461,null,null,-13.291530944625407,-0.65461254612546127,6.6751781472684089]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ukazovateľ","2014","2015","2016","2017","2018","2019"]
[null,"Tržby z predaja tovaru [€]",919776,689874,577313,318842,502479,694770]
[null,"Tržby z predaja vlastných výrobkov a služieb [€]",0,0,0,2071,4446,6471]
[null,"Tržby celkom [€]",919776,689874,577313,320913,506925,701241]
[]
[]
[]
[]
[]
[]
[null,"Požiadavky na aplikáciu"]
[null,"Analýza finančných ukazovateľov"]
[null,"Plne automatizované načítanie údajov"]
[null,"Možnosť výberu analyzovaného obdobia"]
[null,"Prehľadné výsledky formou tlačových zostáv pripravených na tisk"]
[null,"Dostupnosť použitého softwaru bez nutnosti nákupu"]
[]
[]
[]
[null,"Náklady spojené so softwarovou aplikáciou","Cena"]
[null,"Softwarová aplikácia","85 eur"]
[null,"Zaškolenie užívateľa","15 eur/hod"]
[null,"Konzultácie v prípade problémov","10 eur/hod"]