{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Aktiva","Pasiva","Výkaz zisků a ztrát","Spuštění programu","Rozdílové ukazatele","Absolutní ukazatele","Ukazatele likvidity","Ukazatele zadluženosti","Ukazatele rentability","Ukazatele aktivity","Souhrnné indexy"],"not_rendered":{"charts":8,"images":32,"macros":1,"external_links":0,"defined_names":0,"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":"Aktiva","index":0,"n_rows":71,"n_cols":16,"rows_kept":71,"cut":false,"hidden":false,"merged":[[70,3,70,6],[65,3,65,6],[66,3,66,6],[67,3,67,6],[68,3,68,6],[69,3,69,6],[60,3,60,6],[61,3,61,6],[62,3,62,6],[63,3,63,6],[64,3,64,6],[55,3,55,6],[56,3,56,6],[57,3,57,6],[58,3,58,6],[59,3,59,6],[50,3,50,6],[51,3,51,6],[52,3,52,6],[53,3,53,6],[54,3,54,6],[69,0,70,1],[35,3,35,6],[36,3,36,6],[37,3,37,6],[38,3,38,6],[39,3,39,6],[40,3,40,6],[41,3,41,6],[42,3,42,6],[43,3,43,6],[44,3,44,6],[45,3,45,6],[46,3,46,6],[47,3,47,6],[48,3,48,6],[49,3,49,6],[35,1,35,2],[38,0,42,1],[45,0,51,1],[54,0,61,1],[64,0,66,1],[26,3,26,6],[27,3,27,6],[28,0,33,1],[28,3,28,6],[29,3,29,6],[30,3,30,6],[31,3,31,6],[32,3,32,6],[33,3,33,6],[16,3,16,6],[17,3,17,6],[18,0,25,1],[18,3,18,6],[19,3,19,6],[20,3,20,6],[21,3,21,6],[22,3,22,6],[23,3,23,6],[24,3,24,6],[25,3,25,6],[7,3,7,6],[8,3,8,6],[9,0,15,1],[9,3,9,6],[10,3,10,6],[11,3,11,6],[12,3,12,6],[13,3,13,6],[14,3,14,6],[15,3,15,6],[4,0,4,2],[4,3,4,6],[5,1,5,2],[5,3,5,6],[6,1,6,2],[6,3,6,6],[0,0,0,2],[0,3,0,6],[1,0,3,2],[1,3,3,6],[1,7,3,7],[0,8,1,15],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,8,3,8],[2,9,3,9],[2,10,3,10]]}
["označ",null,null,"AKTIVA",null,null,null,"řád","Běžné účetní období"]
["a",null,null,"b",null,null,null,"c"]
[null,null,null,null,null,null,null,null,2007,2008,2009,2010,2011,2012,2013,2014]
[]
[null,null,null,"AKTIVA CELKEM",null,null,null,"001",{"$f":"SUM(I6+I7,I36,I68)","v":167801},{"$f":"SUM(J6+J7,J36,J68)","v":200071},204444,217019,212998,195075,211982,250306]
["A.",null,null,"Pohledávky za upsaný základní kapitál",null,null,null,"002",0,0,0,0,0,0,0,0]
["B.",null,null,"Dlouhodobý majetek",null,null,null,"003",{"$f":"I8+I17+I27","v":52667},53686,52018,50695,48194,60964,53462,68006]
["B.","I.",null,"Dlouhodobý nehmotný majetek",null,null,null,"004",{"$f":"SUM(I9:I16)","v":795},583,240,224,407,778,888,700]
["B.","I.",1,"Zřizovací výdaje",null,null,null,"005",0,0,0,0,0,0,0,0]
[null,null,2,"Nehmotné výsledky výzkumu a vývoje ",null,null,null,"006",0,0,0,0,0,0,0,0]
[null,null,3,"Software",null,null,null,"007",795,583,240,224,407,778,888,700]
[null,null,4,"Ocenitelná práva",null,null,null,"008",0,0,0,0,0,0,0,0]
[null,null,5,"Goodwill",null,null,null,"009",0,0,0,0,0,0,0,0]
[null,null,6,"Jiný dlouhodobý nehmotný majetek",null,null,null,"010",0,0,0,0,0,0,0,0]
[null,null,7,"Nedokončený dlouhodobý nehmotný majetek",null,null,null,"011",0,0,0,0,0,0,0,0]
[null,null,8,"Poskytnuté zálohy na dlouhodobý nehmotný majetek",null,null,null,"012",0,0,0,0,0,0,0,0]
["B.","II.",null,"Dlouhodobý hmotný majetek ",null,null,null,"013",{"$f":"SUM(I18:I26)","v":50226},51457,50132,48825,47476,60186,52574,67306]
["B.","II.",1,"Pozemky",null,null,null,"014",1808,1746,1653,2631,2562,1613,1247,1262]
[null,null,2,"Stavby",null,null,null,"015",43638,42012,39916,40478,39441,52729,45533,58302]
[null,null,3,"Samostatné hmotné movité věci a soubory hmotných movitých věcí",null,null,null,"016",3185,7294,6710,5409,5173,5368,5311,4517]
[null,null,4,"Pěstitelské celky trvalých porostů",null,null,null,"017",0,0,0,0,0,0,0,0]
[null,null,5,"Dospělá zvířata a jejich skupiny",null,null,null,"018",0,0,0,0,0,0,0,0]
[null,null,6,"Jiný dlouhodobý hmotný majetek",null,null,null,"019",31,24,15,7,0,0,0,0]
[null,null,7,"Nedokončený dlouhodobý hmotný majetek",null,null,null,"020",1564,381,1838,300,300,476,483,1345]
[null,null,8,"Poskytnuté zálohy na dlouhodobý hmotný majetek",null,null,null,"021",0,0,0,0,0,0,0,1880]
[null,null,9,"Oceňovací rozdíl k nabytému majetku",null,null,null,"022",0,0,0,0,0,0,0,0]
["B.","III.",null,"Dlouhodobý finanční majetek",null,null,null,"023",{"$f":"SUM(I28:I34)","v":1646},1646,1646,1646,311,0,0,0]
["B.","III.",1,"Podíly - ovládaná osoba",null,null,null,"024",1646,1646,1646,1646,311,0,0,0]
[null,null,2,"Podíly v účetních jednotkách pod podstatným vlivem",null,null,null,"025",0,0,0,0,0,0,0,0]
[null,null,3,"Ostatní dlouhodobé cenné papíry a podíly",null,null,null,"026",0,0,0,0,0,0,0,0]
[null,null,4,"Zápůjčky a úvěry - ovládaná nebo ovládající osoba, podstatný vliv",null,null,null,"027",0,0,0,0,0,0,0,0]
[null,null,5,"Jiný dlouhodobý finanční majetek",null,null,null,"028",0,0,0,0,0,0,0,0]
[null,null,6,"Pořizovaný dlouhodobý finanční majetek",null,null,null,"029",0,0,0,0,0,0,0,0]
[null,null,7,"Poskytnuté zálohy na dlouhodobý finanční majetek",null,null,null,"030",0,0,0,0,0,0,0,0]
[]
["C.",null,null,"Oběžná aktiva",null,null,null,"031",{"$f":"I37+I44+I53+I63","v":114331},145362,151411,165530,164340,133686,158232,181533]
["C.","I.",null,"Zásoby",null,null,null,"032",{"$f":"SUM(I38:I43)","v":17415},22616,25721,27946,45070,23813,22937,47001]
["C.","I.",1,"Materiál",null,null,null,"033",0,4375,4589,4238,4474,6408,6175,5726]
[null,null,2,"Nedokončená výroba a polotovary",null,null,null,"034",758,2698,2560,7018,25071,2993,3794,27926]
[null,null,3,"Výrobky",null,null,null,"035",0,0,0,0,0,0,0,0]
[null,null,4,"Mladá a ostatní zvířata a jejich skupiny",null,null,null,"036",0,0,0,0,0,0,0,0]
[null,null,5,"Zboží",null,null,null,"037",16657,15543,18572,16690,15525,14412,12968,13349]
[null,null,6,"Poskytnuté zálohy na zásoby",null,null,null,"038",0,0,0,0,0,0,0,0]
["C.","II.",null,"Dlouhodobé pohledávky",null,null,null,"039",{"$f":"SUM(I45:I52)","v":3944},4110,5596,6631,7291,6786,6270,4811]
["C.","II.",1,"Pohledávky z obchodních vztahů",null,null,null,"040",3944,4110,5596,6131,6791,6226,5770,4311]
[null,null,2,"Pohledávky - ovládaná nebo ovládající osoba",null,null,null,"041",0,0,0,0,0,0,0,0]
[null,null,3,"Pohledávky - podstatný vliv",null,null,null,"042",0,0,0,0,0,0,0,0]
[null,null,4,"Pohledávky za společníky",null,null,null,"043",0,0,0,0,0,0,0,0]
[null,null,5,"Dlouhodobé poskytnuté zálohy",null,null,null,"044",0,0,0,0,0,0,0,0]
[null,null,6,"Dohadné účty aktivní",null,null,null,"045",0,0,0,0,0,0,0,0]
[null,null,7,"Jiné pohledávky",null,null,null,"046",0,0,0,500,500,560,500,500]
[null,null,8,"Odložená daňová pohledávka",null,null,null,"047",0,0,0,0,0,0,0,0]
["C.","III.",null,"Krátkodobé pohledávky",null,null,null,"048",{"$f":"SUM(I54:I62)","v":92148},114773,119355,129287,109438,100045,113029,119452]
["C.","III.",1,"Pohledávky z obchodních vztahů",null,null,null,"049",49147,67095,44579,51700,34394,22617,33297,23574]
[null,null,2,"Pohledávky - ovládaná nebo ovládající osoba",null,null,null,"050",0,0,0,0,0,0,0,0]
[null,null,3,"Pohledávky - podstatný vliv",null,null,null,"051",0,0,0,0,0,0,0,0]
[null,null,4,"Pohledávky za společníky",null,null,null,"052",0,0,0,0,0,0,0,0]
[null,null,5,"Sociální zabezpečení a zdravotní pojištění",null,null,null,"053",0,0,0,0,0,0,0,0]
[null,null,6,"Stát - daňové pohledávky",null,null,null,"054",1371,1192,5,14,247,2559,3506,0]
[null,null,7,"Krátkodobé poskytnuté zálohy",null,null,null,"055",9452,10608,7717,6925,7116,2583,1679,5169]
[null,null,8,"Dohadné účty aktivní",null,null,null,"056",31563,35843,64765,69358,66561,70787,71817,85661]
[null,null,9,"Jiné pohledávky",null,null,null,"057",615,35,2289,1290,1120,1499,2730,5048]
["C.","IV.",null,"Krátkodobý finanční majetek",null,null,null,"058",{"$f":"I64+I65+I67+I66","v":824},3863,739,1666,2541,3042,15996,10269]
["C.","IV.",1,"Peníze",null,null,null,"059",211,63,174,74,185,42,165,164]
[null,null,2,"Účty v bankách",null,null,null,"060",613,3800,565,1592,2356,3000,15831,10105]
[null,null,3,"Krátkodobé cenné papíry a podíly",null,null,null,"061",0,0,{"$f":"I66+J66","v":0},0,0,0,0,0]
[null,null,4,"Pořizovaný krátkodobý finanční majetek",null,null,null,"062",0,0,{"$f":"I67+J67","v":0},0,0,0,0,0]
["D.","I.",null,"Časové rozlišení",null,null,null,"063",{"$f":"I69+I71+I70","v":803},1023,1015,{"$f":"L69+L71+L70","v":794},464,425,288,767]
["D.","I.",1,"Náklady příštích období ",null,null,null,"064",803,1023,953,587,422,260,199,384]
[null,null,2,"Komplexní náklady příštích období",null,null,null,"065",0,0,0,0,0,0,0,0]
[null,null,3,"Příjmy příštích období",null,null,null,"066",0,0,62,207,42,165,89,383]

{"sheet":"Pasiva","index":1,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[4,1,4,2],[0,0,0,2],[1,0,2,2],[1,3,2,3],[1,4,2,4],[3,0,3,2],[25,0,25,1],[26,1,26,2],[29,0,31,1],[34,0,42,1],[6,0,8,1],[11,0,15,1],[18,0,18,1],[21,0,22,1],[24,0,24,2],[23,11,24,11],[23,12,24,12],[0,5,1,12],[23,7,24,7],[23,8,24,8],[23,9,24,9],[23,10,24,10],[23,5,24,5],[23,6,24,6]]}
["označ",null,null,"PASIVA","řád","Běžné účetní období"]
["a",null,null,"b","c"]
[null,null,null,null,null,2007,2008,2009,2010,2011,2012,2013,2014]
[null,null,null,"PASIVA CELKEM","067",{"$f":"SUM(F5+F27+F61)","v":167801},{"$f":"SUM(G5+G27+G61)","v":200071},204444,217019,212998,195075,211982,250306]
["A.",null,null,"Vlastní kapitál ","068",{"$f":"F6+F10+F17+F20+F24-F26","v":43148},44585,46302,49819,{"$f":"J6+J10+J17+J20+J24-J26","v":63375},64353,65216,69094]
["A.","I.",null,"Základní kapitál ","069",{"$f":"F7+F9+F8","v":46300},46300,46300,46300,46300,46300,46300,46300]
[null,null,1,"Základní kapitál","070",46300,46300,46300,46300,46300,46300,46300,46300]
[null,null,2,"Vlastní akcie a vlastní obchodní podíly (-)","071",0,0,0,0,0,0,0,0]
[null,null,3,"Změny základního kapitálu","072",0,0,0,0,0,0,0,0]
["A.","II.",null,"Kapitálové fondy","073",{"$f":"SUM(F11:F16)","v":0},0,0,0,8115,6179,3908,3770]
["A.","II.",1,"Ážio","074",0,0,0,0,0,0,0,0]
[null,null,2,"Ostatní kapitálové fondy","075",0,0,0,0,9450,7825,5554,5554]
[null,null,3,"Oceňovací rozdíly z přecenění majetku a závazků","076",0,0,0,0,-1335,-1646,-1646,-1784]
[null,null,4,"Oceňovací rozdíly z přecenění při přeměnách obchodních korporací","077",0,0,0,0,0,0,0,0]
[null,null,5,"Rozdíly z přeměn obchodních korporací","078",0,0,0,0,0,0,0,0]
[null,null,6,"Rozdíly z ocenění při přeměnách obchodních korporací","079",0,0,0,0,0,0,0,0]
["A.","III.",null,"Fondy ze zisku","080",{"$f":"F18+F19","v":322},{"$f":"G18+G19","v":398},469,555,731,1003,1149,1149]
["A.","III.",1,"Rezervní fond","081",322,398,469,555,731,1003,1149,1149]
[null,null,2,"Statutární a ostatní fondy","082",0,0,0,0,0,0,0,0]
["A.","IV.",null,"Výsledek hospodáření minulých let ","083",{"$f":"F21+F22+F23","v":-4982},-3549,-2185,-554,2788,7957,10726,13859]
["A.","IV.",1,"Nerozdělený zisk minulých let ","084",0,0,0,0,2788,7957,10726,13859]
[null,null,2,"Neuhrazená ztráta minulých let","085",-4982,-3549,-2185,-554,0,0,0,0]
[null,null,3,"Jiný výsledek hospodaření minulých let","086",0,0,0,0,0,0,0,0]
["A.","V.",1,"Výsledek hospodaření běžného účetního období (+/-) ","087",{"$f":"Aktiva!I5-F6-F10-F17-F20-F27-F61","v":1508},{"$f":"Aktiva!J5-G6-G10-G17-G20-G27-G61","v":1436},{"$f":"Aktiva!K5-H6-H10-H17-H20-H27-H61","v":1718},{"$f":"Aktiva!L5-I6-I10-I17-I20-I27-I61","v":3518},{"$f":"Aktiva!M5-J6-J10-J17-J20-J27-J61","v":5441},{"$f":"Aktiva!N5-K6-K10-K17-K20-K27-K61","v":2914},{"$f":"Aktiva!O5-L6-L10-L17-L20-L27-L61","v":3133},{"$f":"Aktiva!P5-M6-M10-M17-M20-M27-M61","v":4016}]
[]
[null,null,2,"Rozhodnuto o zálohách na výplatu podílu na zisku (-)","088",0,0,0,0,0,0,0,0]
["B.",null,null,"Cizí zdroje","089",{"$f":"SUM(F28+F33+F45+F57)","v":114874},{"$f":"SUM(G28+G33+G45+G57)","v":142817},146049,159781,143735,128752,146404,181151]
["B.","I.",null,"Rezervy","090",{"$f":"SUM(F29:F32)","v":0},0,0,0,0,0,0,0]
["B.","I.",1,"Rezervy podle zvláštních právních předpisů","091",0,0,0,0,0,0,0,0]
[null,null,2,"Rezerva na důchody a podobné závazky","092",0,0,0,0,0,0,0,0]
[null,null,3,"Rezerva na daň z příjmů","093",0,0,0,0,0,0,0,0]
[null,null,4,"Ostatní rezervy","094",0,0,0,0,0,0,0,0]
["B.","II.",null,"Dlouhodobé závazky","095",{"$f":"SUM(F34:F43)","v":1608},3431,2763,2894,4126,4760,2747,2527]
["B.","II.",1,"Závazky z obchodních vztahů","096",1387,2913,2228,2154,3086,3683,1712,1385]
[null,null,2,"Závazky - ovládaná nebo ovládající osoba","097",0,0,0,0,0,0,0,0]
[null,null,3,"Závazky - podstatný vliv","098",0,0,0,0,0,0,0,0]
[null,null,4,"Závazky ke společníkům","099",0,0,0,0,0,0,0,0]
[null,null,5,"Dlouhodobé přijaté zálohy","100",0,0,0,0,0,0,0,0]
[null,null,6,"Vydané dluhopisy","101",0,0,0,0,0,0,0,0]
[null,null,7,"Dlouhodobé směnky k úhradě","102",0,0,0,0,0,0,0,0]
[null,null,8,"Dohadné účty pasívní","103",0,0,0,0,0,0,0,0]
[null,null,9,"Jiné závazky","104",0,0,0,0,0,0,0,0]
[null,null,10,"Odložený daňový závazek","105",221,518,535,740,1040,1077,1035,1142]
[]
["B.","III.",null,"Krátkodobé závazky",106,{"$f":"SUM(F46:F56)","v":92364},119492,127723,134441,119324,95123,120119,147692]
["B.","III.",1,"Závazky z obchodních vztahů","107",45051,67449,49063,55411,24454,19856,36479,43106]
[null,null,2,"Závazky - ovládaná nebo ovládající osoba","108",0,0,0,0,0,0,0,0]
[null,null,3,"Závazky - podstatný vliv",109,0,0,0,0,0,0,0,0]
[null,null,4,"Závazky ke společníkům",110,0,0,0,0,0,0,0,0]
[null,null,5,"Závazky k zaměstnancům",111,721,972,964,946,915,922,962,1016]
[null,null,6,"Závazky ze sociálního zabezpečení a zdravotního pojištění",112,364,579,573,552,521,532,551,590]
[null,null,7,"Stát - daňové závazky a dotace",113,124,443,832,1871,846,426,52,221]
[null,null,8,"Kratkodobé přijaté zálohy",114,43778,46153,71922,69472,87591,69498,77110,92930]
[null,null,9,"Vydané dluhopisy",115,0,0,0,0,0,0,0,0]
[null,null,10,"Dohadné účty pasivní ",116,576,454,935,2755,1563,451,313,5138]
[null,null,11,"Jiné závazky",117,1750,3442,3434,3434,3434,3438,4652,4691]
["B.","IV.",null,"Bankovní úvěry a výpomoci",118,{"$f":"F58+F59+F60","v":20902},19894,15563,22446,20285,28869,23538,30932]
["B.","IV.",1,"Bankovní úvěry dlouhodobé",119,16049,13428,10151,8097,5337,6956,7341,14642]
[null,null,2,"Krátkodobé bankovní úvěry ",120,2621,2621,2621,2621,5021,21294,15574,15859]
[null,null,3,"Krátkodobé finanční výpomoci",121,2232,3845,2791,11728,9927,619,623,431]
["C.","I.",null,"Časové rozlišení",122,{"$f":"F62+F63","v":9779},12669,12093,7419,5888,1970,362,61]
["C.","I.",1,"Výdaje příštích období",123,9779,12669,12093,7419,5888,1970,362,59]
[null,null,2,"Výnosy příštích období ",124,0,0,0,0,0,0,0,2]

{"sheet":"Výkaz zisků a ztrát","index":2,"n_rows":67,"n_cols":18,"rows_kept":67,"cut":false,"hidden":false,"merged":[[52,15,53,15],[52,16,53,16],[52,17,53,17],[52,10,53,10],[52,11,53,11],[52,12,53,12],[52,13,53,13],[52,14,53,14],[7,3,7,8],[9,3,9,8],[8,0,9,1],[8,3,8,8],[10,1,10,2],[10,3,10,8],[12,3,12,8],[13,3,13,8],[14,3,14,8],[11,1,12,1],[11,3,11,8],[13,0,13,2],[14,1,14,2],[15,3,15,8],[16,3,16,8],[17,3,17,8],[18,3,18,8],[15,1,18,1],[24,1,24,2],[27,1,27,2],[19,1,19,2],[19,3,19,8],[20,3,20,8],[21,3,21,8],[22,3,22,8],[20,1,20,2],[21,0,21,2],[23,3,23,8],[24,3,24,8],[25,3,25,8],[26,3,26,8],[27,3,27,8],[31,3,31,8],[31,1,31,2],[32,0,33,2],[28,3,28,8],[29,1,29,2],[29,3,29,8],[30,0,30,2],[30,3,30,8],[28,0,28,2],[0,0,0,2],[0,3,0,8],[1,0,2,2],[1,3,2,8],[3,0,3,2],[3,3,3,8],[4,1,4,2],[4,3,4,8],[5,0,5,2],[5,3,5,8],[6,0,6,2],[6,3,6,8],[66,0,66,2],[64,1,64,2],[65,0,65,2],[64,3,64,8],[65,3,65,8],[0,10,1,17],[32,12,33,12],[32,13,33,13],[32,14,33,14],[32,15,33,15],[32,16,33,16],[32,17,33,17],[32,10,33,10],[32,11,33,11],[52,9,53,9],[52,3,53,8],[32,3,33,8],[66,3,66,8],[32,9,33,9]]}
["Označení",null,null,"TEXT",null,null,null,null,null,"Číslo","Skutečnost v účetním období"]
["a",null,null,"b  ",null,null,null,null,null,"řádku"]
[null,null,null,null,null,null,null,null,null,"c",2007,2008,2009,2010,2011,2012,2013,2014]
["I.",null,null,"Tržby za prodej zboží ",null,null,null,null,null,"01",122668,132612,176212,128204,129831,123837,141429,163426]
["A.",null,null,"Náklady vynaložené na prodané zboží",null,null,null,null,null,"02",100601,111336,140201,100417,95994,89291,103968,125318]
["+",null,null,"Obchodní marže",null,null,null,null,null,"03",{"$f":"K4-K5","v":22067},{"$f":"L4-L5","v":21276},36011,27787,33837,34546,37461,38108]
["II.",null,null,"Výkony",null,null,null,null,null,"04",{"$f":"SUM(K8:K10)","v":102192},{"$f":"SUM(L8:L10)","v":143638},120924,102480,{"$f":"SUM(O8:O10)","v":122495},73223,76584,92913]
[null,"II.",1,"Tržby za prodej vlastních výrobků a služeb",null,null,null,null,null,"05",102080,141658,120843,98323,103843,47291,75562,68665]
[null,null,2,"Změna stavu zásob vlastní činnosti",null,null,null,null,null,"06",110,1980,72,4117,18650,-22078,1018,24230]
[null,null,3,"Aktivace",null,null,null,null,null,"07",2,0,9,40,2,48010,4,18]
["B.",null,null,"Výkonová spotřeba",null,null,null,null,null,"08",{"$f":"K12+K13","v":102434},138017,121929,98912,121797,77986,81631,98435]
["B.",null,1,"Spotřeba materiálu a energie",null,null,null,null,null,"09",24289,39214,31141,31298,27312,28433,26141,38818]
["B.",null,2,"Služby",null,null,null,null,null,"10",78145,98803,90788,67614,94485,49553,55490,59617]
["+",null,null,"Přidaná hodnota",null,null,null,null,null,"11",{"$f":"K6+K7-K11","v":21825},26897,35006,31355,34535,29783,32414,32586]
["C.",null,null,"Osobní náklady",null,null,null,null,null,"12",{"$f":"K16+K17+K18+K19","v":14923},19361,24450,20630,20536,20851,20973,22313]
["C.",null,1,"Mzdové náklady",null,null,null,null,null,"13",10825,14047,17972,15086,14955,15203,15185,16185]
["C.",null,2,"Odměny členům orgánů společnosti a družstva",null,null,null,null,null,"14",0,0,0,0,0,0,0,0]
["C.",null,3,"Náklady na sociální zabezpečení a zdravotní pojištění",null,null,null,null,null,"15",3745,4872,5880,5011,5026,5108,5110,5442]
["C.",null,4,"Sociální náklady",null,null,null,null,null,"16",353,442,598,533,555,540,678,686]
["D.",null,null,"Daně a poplatky",null,null,null,null,null,"17",134,324,295,241,266,343,445,239]
["E.",null,null,"Odpisy  dlouhodobého nehmotného a hmotného majetku",null,null,null,null,null,18,2750,3296,5180,4653,4328,4444,4713,5179]
["III.",null,null,"Tržby z prodeje dlouhodobého majetku a materiálu",null,null,null,null,null,19,{"$f":"K23+K24","v":678},3971,4622,5425,3466,43514,12620,816]
[null,"III.",1,"Tržby z prodeje dlouhodobého majetku ",null,null,null,null,null,20,678,3038,2252,1037,1242,42674,10831,0]
[null,null,2,"Tržby z prodeje materiálu",null,null,null,null,null,21,0,933,2370,4388,2224,840,1789,816]
["F.",null,null,"Zůstatková cena prodaného dlouhodobého majetku a materiálu",null,null,null,null,null,22,{"$f":"K26+K27","v":178},2559,3163,4487,2183,39807,11504,612]
["F.",null,1,"Zůstatková cena prodaného dlouhodobého majetku",null,null,null,null,null,23,178,1681,889,212,69,39068,9775,0]
["F.",null,2,"Prodaný materiál",null,null,null,null,null,24,0,878,2274,4275,2114,739,1729,612]
["G.",null,null,"Změna stavu rezerv a opravných položek v provozní oblasti a komplexních nákladů příštích období",null,null,null,null,null,25,337,131,1601,719,832,1104,1306,371]
["IV.",null,null,"Ostatní provozní výnosy",null,null,null,null,null,26,380,567,790,1212,640,812,523,191]
["H.",null,null,"Ostatní provozní náklady",null,null,null,null,null,27,1223,1709,1619,1163,1249,2150,2075,1498]
["V.",null,null,"Převod provozních výnosů",null,null,null,null,null,28,187,218,251,116,193,280,296,274]
["I.",null,null,"Převod provozních nákladů",null,null,null,null,null,29,187,218,251,116,193,280,296,274]
["*",null,null,"Provozní výsledek hospodaření",null,null,null,null,null,30,{"$f":"K14-K15-K20-K21+K22-K25-K28+K29-K30-K31+K32","v":3338},4055,4110,6099,9247,5410,4541,3381]
[]
[]
["VI",null,null,"Tržby z prodeje cenných papírů a podílů",null,null,null,null,null,31,0,0,0,0,0,0,0,0]
["J.",null,null,"Prodané cenné papíry a podíly",null,null,null,null,null,32,0,0,0,0,0,0,0,0]
[null,"VII.",null,"Výnosy z dlouhodobého finančního majetku",null,null,null,null,null,33,{"$f":"K39+K40+K41","v":0},0,0,0,0,0,0,0]
[null,"VII.",1,"Výnosy z podílů v ovládaných osobách a v účetních jednotkách pod podstatným vlivem",null,null,null,null,null,34,0,0,0,0,0,0,0,0]
[null,"VII.",2,"Výnosy z ostatních dlouhodobých cenných papírů a podílů",null,null,null,null,null,35,0,0,0,0,0,0,0,0]
[null,"VII.",3,"Výnosy z ostatního dlouhodobého finančního majetku",null,null,null,null,null,36,0,0,0,0,0,0,0,0]
[null,"VIII.",null,"Výnosy z krátkodobého finančního majetku",null,null,null,null,null,37,0,0,0,0,0,0,0,0]
["K.",null,null,"Náklady z finančního majetku",null,null,null,null,null,38,0,0,0,0,0,0,0,0]
[null,"IX.",null,"Výnosy z přecenění cenných papírů a derivátů",null,null,null,null,null,39,0,0,0,0,0,0,0,0]
["L.",null,null,"Náklady z přecenění cenných papírů a derivátů",null,null,null,null,null,40,0,0,0,0,0,0,163,-163]
["M.",null,null,"Změna stavu rezerv a opravných položek ve finanční oblasti",null,null,null,null,null,41,0,0,0,0,0,0,0,0]
["X.",null,null,"Výnosové úroky",null,null,null,null,null,42,10,4,3,1,8,8,10,16]
["N.",null,null,"Nákladové úroky",null,null,null,null,null,43,1369,1790,1548,1119,1109,1084,961,848]
["XI.",null,null,"Ostatní finanční výnosy",null,null,null,null,null,44,773,1228,591,615,257,210,1303,3323]
["O.",null,null,"Ostatní finanční náklady",null,null,null,null,null,45,1023,1764,1016,1217,1288,532,715,861]
["XII.",null,null,"Převod finančních výnosů",null,null,null,null,null,46,0,0,0,0,0,0,0,0]
["P.",null,null,"Převod finančních nákladů",null,null,null,null,null,47,0,0,0,0,0,0,0,0]
["*",null,null,"Finanční výsledek hospodaření",null,null,null,null,null,48,{"$f":"K36-K37+K38+K42-K43+K44-K45-K46+K47-K48+K49-K50-K51+K52","v":-1609},-2322,-1970,-1720,-2132,-1398,-526,1793]
[]
["Q.",null,null,"Daň z příjmů za běžnou činnost",null,null,null,null,null,49,{"$f":"K56+K57","v":221},297,422,861,1674,1098,882,1158]
["Q.",null,1,"     -splatná",null,null,null,null,null,50,0,0,405,656,1374,1061,924,1051]
["Q.",null,2,"     -odložená",null,null,null,null,null,51,221,297,17,205,300,37,-42,107]
["**",null,null,"Výsledek hospodaření za běžnou činnost",null,null,null,null,null,52,{"$f":"K33+K53-K55","v":1508},{"$f":"L33+L53-L55","v":1436},1718,3518,5441,2914,3133,4016]
["XIII.",null,null,"Mimořádné výnosy",null,null,null,null,null,53,0,0,0,0,0,0,0,0]
["R.",null,null,"Mimořádné náklady",null,null,null,null,null,54,0,0,0,0,0,0,0,0]
["S.",null,null,"Daň z příjmů z mimořádné činnosti",null,null,null,null,null,55,{"$f":"K62+K63","v":0},0,0,0,0,0,0,0]
["S.",null,1,"     -splatná",null,null,null,null,null,56,0,0,0,0,0,0,0,0]
["S.",null,2,"     -odložená",null,null,null,null,null,57,0,0,0,0,0,0,0,0]
["*",null,null,"Mimořádný výsledek hospodaření",null,null,null,null,null,58,{"$f":"K59-K60-K61","v":0},0,0,0,0,0,0,0]
["T.",null,null,"Převod podílu na výsledku hospodaření společníkům (+/-)",null,null,null,null,null,59,0,0,0,0,0,0,0,0]
["***",null,null,"Výsledek hospodaření za účetní období (+/-)",null,null,null,null,null,60,{"$f":"K58+K64-K65","v":1508},1436,1718,3518,5441,2914,3133,4016]
["****",null,null,"Výsledek hospodaření  před zdaněním (+/-)",null,null,null,null,null,61,{"$f":"K33+K53+K59-K60","v":1729},{"$f":"L33+L53+L59-L60","v":1733},{"$f":"M33+M53+M59-M60","v":2140},4379,7115,4012,4015,5174]

{"sheet":"Spuštění programu","index":3,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,15,18,23],[1,1,3,14],[9,15,11,23],[14,15,15,23],[1,15,3,23],[4,15,5,23],[6,15,8,23],[12,15,13,23]]}
[]
[null,"Program pro finanční analýzu",null,null,null,null,null,null,null,null,null,null,null,null,null,"Návod na obsluhu programu:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1) Po spuštění programu se otevře hlavní menu, ve kterém lze přepnat mezi listy výkazů a nebo spustit finanční analýzu. "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2) Pro úspěšný průběh finanční analýzy je důležité správně vyplnit příslušné výkazy a to jak část Aktiv, tak i část Pasiv, totéž platí pro výkaz zisků a ztrát, bez takto vyplněných výkazů program nemůže poskytnout správné výsledky ukazatelů."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3) Při vyplňování výkazů vyplňujte pouze bílá pole, jinak barevně značená pole obsahují vzorce a jsou chráněna proti zápisu tento prvek slouží tomu aby nedošlo ke znehodnocení funkčnosti programu."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4) Pro snadnější navigování mezi listy, je na každém listu příslušné tlačítko, které vám otevře hlavní menu, nebo menu navigace."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5) Při vypočtení určitého ukazatele se program přesměruje na příslušný list, ve kterém je tabulka s výsledky."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6) Pakliže po vypočítání příslušného ukazatele se ve výsledné tabulce objeví hodnota NULL, tak došlo k dělení nulou, to znamená, že položka kterou dělíme má buď hodnotu nula a nebo je špatně vyplněná (nevyplněná vůbec)."]

{"sheet":"Rozdílové ukazatele","index":4,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,1,3,9]]}
[]
[]
[null,"Rozdílové ukazatele"]
[]
[null,null,2007,2008,2009,2010,2011,2012,2013,2014]
[null,"Čisté pohotové prostředky",-91540,-115629,-126984,-132775,-116783,-92081,-104123,-137423]
[null,"Čistý pracovní kapitál",21967,25870,23688,31089,45016,38563,38113,33841]

{"sheet":"Absolutní ukazatele","index":5,"n_rows":28,"n_cols":19,"rows_kept":28,"cut":false,"hidden":false,"merged":[[44,11,44,17],[1,1,2,8],[15,2,15,8],[15,11,15,18],[1,10,2,18]]}
[]
[null,"Horizontální analýza rozvahy",null,null,null,null,null,null,null,null,"Vertikální analýza rozvahy"]
[]
[null,"AKTIVA","07 - 08","08 - 09","09 - 10","10 - 11","11 - 12","12 - 13","13 - 14",null,"AKTIVA","2007","2008","2009","2010","2011","2012","2013","2014"]
[null,"AKTIVA CELKEM","19,2%","2,2%","6,2%","-1,9%","-8,4%","8,7%","18,1%",null,"AKTIVA CELKEM",1,1,1,1,1,1,1,1]
[null,"Dlouhodobý majetek","1,9%","-3,1%","-2,5%","-4,9%","26,5%","-12,3%","27,2%",null,"Dlouhodobý majetek","31,4%","26,8%","25,4%","23,4%","22,6%","31,3%","25,2%","27,2%"]
[null,"Dlouhodobý nehmotný majetek","-26,7%","-58,8%","-6,7%","81,7%","91,2%","14,1%","-21,2%",null,"Dlouhodobý nehmotný majetek","0,5%","0,3%","0,1%","0,1%","0,2%","0,4%","0,4%","0,3%"]
[null,"Dlouhodobý hmotný majetek","2,5%","-2,6%","-2,6%","-2,8%","26,8%","-12,6%",0.28000000000000003,null,"Dlouhodobý hmotný majetek","29,9%","25,7%","24,5%","22,5%","22,3%","30,9%","24,8%","26,9%"]
[null,"Dlouhodobý finanční majetek",0,0,0,"-81,1%",-1,"NULL","NULL",null,"Dlouhodobý finanční majetek",0.01,"0,8%","0,8%","0,8%","0,1%",0,0,0]
[null,"Oběžná aktiva","27,1%","4,2%","9,3%","-0,7%","-18,7%","18,4%","14,7%",null,"Oběžná aktiva","68,1%","72,7%","74,1%","76,3%","77,2%","68,5%","74,6%","72,5%"]
[null,"Zásoby","29,9%","13,7%","8,7%","61,3%","-47,2%","-3,7%","104,9%",null,"Zásoby","10,4%","11,3%","12,6%","12,9%","21,2%","12,2%","10,8%","18,8%"]
[null,"Dlouhodobé pohledávky","4,2%","36,2%","18,5%",0.1,"-6,9%","-7,6%","-23,3%",null,"Dlouhodobé pohledávky","2,4%","2,1%","2,7%","3,1%","3,4%","3,5%",0.03,"1,9%"]
[null,"Krátkodobé pohledávky","24,6%",0.04,"8,3%","-15,4%","-8,6%",0.13,"5,7%",null,"Krátkodobé pohledávky","54,9%","57,4%","58,4%","59,6%","51,4%","51,3%","53,3%","47,7%"]
[null,"Finanční majetek","368,8%","-80,9%","125,4%","52,5%","19,7%","425,8%","-35,8%",null,"Finanční majetek","0,5%","1,9%","0,4%","0,8%","1,2%","1,6%","7,5%","4,1%"]
[null,"Časové rozlišení","27,4%","-0,8%","-21,8%","-41,6%","-8,4%","-32,2%","166,3%",null,"Časové rozlišení","0,5%","0,5%","0,5%","0,4%","0,2%","0,2%","0,1%","0,3%"]
[null,"PASIVA",null,null,null,null,null,null,null,null,"PASIVA"]
[null,"PASIVA CELKEM","19,2%","2,2%","6,2%","-1,9%","-8,4%","8,7%","18,1%",null,"PASIVA CELKEM",1,1,1,1,1,1,1,1]
[null,"Vlastní kapitál","3,3%","3,9%","7,6%","27,2%","1,5%","1,3%","5,9%",null,"Vlastní kapitál","25,7%","22,3%","22,6%",0.23,"29,8%",0.33,"30,8%","27,6%"]
[null,"Základní kapitál",0,0,0,0,0,0,0,null,"Základní kapitál","27,6%","23,1%","22,6%","21,3%","21,7%","23,7%","21,8%","18,5%"]
[null,"Kapitálové fondy","NULL","NULL","NULL","NULL","-23,9%","-36,8%","-3,5%",null,"Kapitálové fondy",0,0,0,0,"3,8%","3,2%","1,8%","1,5%"]
[null,"Výsledek hospodaření minulých let","-28,8%","-38,4%","-74,6%","-603,2%","185,4%","34,8%","29,2%",null,"Výsledek hospodaření minulých let",-0.03,"-1,8%","-1,1%","-0,3%","1,3%","4,1%","5,1%","5,5%"]
[null,"Výsledek hospodaření běžného ÚO","-4,8%","19,6%","104,8%","54,7%","-46,4%","7,5%","28,2%",null,"Výsledek hospodaření běžného ÚO","0,9%","0,7%","0,8%","1,6%","2,6%","1,5%","1,5%","1,6%"]
[null,"Cizí zdroje","24,3%","2,3%","9,4%",-0.1,"-10,4%","13,7%","23,7%",null,"Cizí zdroje","68,5%","71,4%","71,4%","73,6%","67,5%",0.66,"69,1%","72,4%"]
[null,"Rezervy","NULL","NULL","NULL","NULL","NULL","NULL","NULL",null,"Rezervy",0,0,0,0,0,0,0,0]
[null,"Dlouhodobé závazky","113,4%","-19,5%","4,7%","42,6%","15,4%","-42,3%",-0.08,null,"Dlouhodobé závazky",0.01,"1,7%","1,4%","1,3%","1,9%","2,4%","1,3%",0.01]
[null,"Krátkodobé závazky","29,4%","6,9%","5,3%","-11,2%","-20,3%","26,3%",0.23,null,"Krátkodobé závazky",0.55000000000000004,"59,7%","62,5%","61,9%",0.56000000000000005,"48,8%","56,7%",0.59]
[null,"Bankovní úvěry a výpomoci","-4,8%","-21,8%","44,2%","-9,6%","42,3%","-18,5%","31,4%",null,"Bankovní úvěry a výpomoci","12,5%","9,9%","7,6%","10,3%","9,5%","14,8%","11,1%","12,4%"]
[null,"Časové rozlišení","29,6%","-4,5%","-38,7%","-20,6%","-66,5%","-81,6%","-83,1%",null,"Časové rozlišení","5,8%","6,3%","5,9%","3,4%","2,8%",0.01,"0,2%",0]

{"sheet":"Ukazatele likvidity","index":6,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,3,9]]}
[]
[]
[null,"Ukazatele likvidity"]
[]
[null,null,2007,2008,2009,2010,2011,2012,2013,2014]
[null,"Okamžitá likvidita",8.999999612569809E-3,3.2000001519918442E-2,6.0000000521540642E-3,1.2000000104308128E-2,2.0999999716877937E-2,3.2000001519918442E-2,0.13300000131130219,7.0000000298023224E-2]
[null,"Pohotová likvidita",1.0490000247955322,1.0269999504089355,0.98400002717971802,1.0230000019073486,1,1.1549999713897705,1.1260000467300415,0.91100001335144043]
[null,"Běžná likvidita",1.2380000352859497,1.215999960899353,1.184999942779541,1.2309999465942383,1.3769999742507935,1.4049999713897705,1.3170000314712524,1.2289999723434448]

{"sheet":"Ukazatele zadluženosti","index":7,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,3,9]]}
[]
[]
[null,"Ukazatele zadluženosti"]
[]
[null,null,2007,2008,2009,2010,2011,2012,2013,2014]
[null,"Celková zadluženost",68.5,71.400001525878906,71.400001525878906,73.599998474121094,67.5,66,69.099998474121094,72.400001525878906]
[null,"Míra samofinancování",25.700000762939453,22.299999237060547,22.600000381469727,23,29.799999237060547,33,30.799999237060547,27.600000381469727]
[null,"Ukazatel úrokového krytí",2.4000000953674316,2.2999999523162842,2.7000000476837158,5.5,8.3000001907348633,5,4.6999998092651367,4]

{"sheet":"Ukazatele rentability","index":8,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,3,9]]}
[]
[]
[null,"Ukazatele rentability"]
[]
[null,null,2007,2008,2009,2010,2011,2012,2013,2014]
[null,"ROI (Vložený kapitál)",1.9900000095367432,2.0299999713897705,2.0099999904632568,2.809999942779541,4.3400001525878906,2.7699999809265137,2.1400001049041748,1.3500000238418579]
[null,"ROA (Aktiva)",0.89999997615814209,0.72000002861022949,0.8399999737739563,1.6200000047683716,2.5499999523162842,1.4900000095367432,1.4800000190734863,1.6000000238418579]
[null,"ROE (Vlastní kapitál)",3.4900000095367432,3.2200000286102295,3.7100000381469727,7.059999942779541,8.5900001525878906,4.5300002098083496,4.8000001907348633,5.809999942779541]
[null,"ROS (tržby)",0.67000001668930054,0.50999999046325684,0.56999999284744263,1.4900000095367432,2.130000114440918,1.2100000381469727,1.3600000143051147,1.559999942779541]
[null,"ROCE (Dlouhodobé zdroje)",3.369999885559082,2.9900000095367432,3.5,6.6700000762939453,8.0600004196166992,4.2199997901916504,4.6100001335144043,5.6100001335144043]

{"sheet":"Ukazatele aktivity","index":9,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,3,9],[5,10,7,10],[8,10,10,10],[2,10,4,10]]}
[]
[]
[null,"Ukazatele aktivity"]
[]
[null,null,2007,2008,2009,2010,2011,2012,2013,2014]
[null,"Obrat celkových aktiv",1.2999999523162842,1.3999999761581421,1.5,1.1000000238418579,1.2000000476837158,1.2000000476837158,1.1000000238418579,1,"Ukazatele počtu obrátek [počet obrátek za rok]"]
[null,"Obrat stálých aktiv",4.3000001907348633,5.1999998092651367,5.8000001907348633,4.6999998092651367,5.3000001907348633,3.9000000953674316,4.3000001907348633,3.7999999523162842]
[null,"Obrat zásob",13,12.399999618530273,11.699999809265137,8.3999996185302734,5.6999998092651367,10.100000381469727,10.100000381469727,5.5]
[null,"Doba obratu zásob",27.799999237060547,29.100000381469727,30.700000762939453,42.599998474121094,63.400001525878906,35.599998474121094,35.799999237060547,65.800003051757812,"Ukazatele doby obratu [dny]"]
[null,"Doba obratu pohledávek",153.5,152.80000305175781,149.10000610351562,207.19999694824219,164.19999694824219,159.89999389648437,186.10000610351562,174]
[null,"Doba obratu závazků",150.10000610351562,158,155.69999694824219,209.39999389648437,173.60000610351562,149.5,191.69999694824219,210.39999389648437]

{"sheet":"Souhrnné indexy","index":10,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,1,3,9]]}
[]
[]
[null,"Souhrnné indexy hodnocení"]
[]
[null,null,2007,2008,2009,2010,2011,2012,2013,2014]
[null,"Altmanův index (Z - skóre)",1.809999942779541,1.8200000524520874,1.8700000047683716,1.5299999713897705,1.809999942779541,1.8400000333786011,1.6299999952316284,1.4700000286102295]
[null,"Index IN 05",0.75999999046325684,0.75999999046325684,0.77999997138977051,0.8399999737739563,1.0700000524520874,0.87000000476837158,0.80000001192092896,0.70999997854232788]