{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Select sheets","Base data","Statement - SZRB guarantee","List of required documents","Additional financial data JU","Additional financial data PU","Customers, suppliers JU","Analysis of revenues PU","Customers, suppliers PU","Receiv., liabilities,stock JU","Receiv., liabilities,stock PU","Loans, liabilities, leasing JU","Loans, liabilities, leasing PU","Additional information","Owners management, shares PU ","A-Assets and liab. projections","A-Income and expend. project.","A - Balance sheet projections","B - Profit and loss projections","Verzia","Preliminary interest-FACTORING"],"not_rendered":{"charts":4,"images":13,"macros":1,"external_links":1,"defined_names":30,"comments":3,"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":"Select sheets","index":0,"n_rows":138,"n_cols":10,"rows_kept":138,"cut":false,"hidden":false,"merged":[]}
[]
["Select sheets:",null,null,null,null,null,null,null,"Version:","3.5.0"]
[]
[null,"Bookeeping method"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Jednoduché účtovníctvo"]
["Podvojné účtovníctvo"]

{"sheet":"Base data","index":1,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[[38,1,38,3],[37,1,37,3],[61,4,61,5],[61,1,61,2],[62,1,62,2],[55,3,55,5],[18,11,18,12],[19,8,19,10],[19,11,19,12],[6,1,6,5],[8,1,8,5],[10,1,10,2],[12,1,12,5],[10,4,10,5],[20,8,20,10],[20,11,20,12],[18,8,18,10],[40,1,40,3],[40,4,40,5],[21,11,21,12],[23,8,23,10],[23,11,23,12],[24,8,24,10],[24,11,24,12],[21,8,21,10],[38,4,38,5],[37,4,37,5],[36,1,36,3],[36,4,36,5],[31,1,31,4],[1,0,1,5],[32,1,32,4],[56,3,56,5],[41,1,41,3],[41,4,41,5],[42,1,42,3],[42,4,42,5],[14,2,14,4],[18,1,18,5],[20,1,20,2],[22,1,22,5],[29,1,29,4],[30,1,30,4],[24,1,24,5],[26,1,26,5],[28,1,28,4]]}
[null,"CRP for double-entry bookeeping"]
["Basic client identification data"]
[]
["Client´s basic data"]
[]
[]
["Name:"]
[]
["Address:"]
[]
["Client code:",null,null,"DIČ:"]
[]
["Main activity, OKEČ:"]
[]
[]
["Data about the required loan"]
[]
[]
["Type of credit:"]
[]
["Amount (EUR 000):",null,null,null,"Currency:"]
[]
["Purpose of credit:"]
[]
["Last drawdown date:"]
[]
["Repayment schedule:"]
[]
["Proposed collateral (EUR 000):","Description",null,null,null,"Value"]
[]
[]
[]
[null,"Total",null,null,null,{"$f":"IF(SUM(F30:F32)=0,\"\",SUM(F30:F32))","v":""}]
[]
["Requirement for SZRB guarantee:","NO"]
[]
["Contact persons:","Name",null,null,"Phone"]
[]
[]
[]
["Documents prepared by:","Name",null,null,"Phone"]
[]
[]
[]
["Date:"]
[]
[]
["Person obligated with in the meaning of Law no. 211/2000 Z.z. about free access to information"]
[]
[null,null,"Yes",null,"No"]
[]
["I declare, that all documents and data, which were submitted with the credit request are true"]
[]
[]
[]
[null,null,null,".........................................................."]
[null,null,null,"Stamp and signature of the statutory body"]
[]
[]
["Senior business manager / business manager data:"]
[]
["Name:",null,null,null," ....................................."]
["Business unit:",null,null,null,"Verified - sign of SBM/BM"]
[]
[null,null,null,null,null,1]
["Note:"]
["* legal representative is signing original and copy af letter"]

{"sheet":"Statement - SZRB guarantee","index":2,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":true,"merged":[[3,2,3,3],[9,2,9,3],[6,2,6,3],[41,3,41,4],[29,3,29,4],[30,3,30,4],[40,3,40,4]]}
[]
["Klient: "]
[null,{"$f":"\"Client: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Client: "}]
["Zoznam dokumentov požadovaných bankou pre stanovenie ratingu a posúdenie žiadosti o úver ",null,"Vyhlásenie klienta pre potreby Záruky SZRB"]
[]
["Pozn. Predložte prosím krížikom označené dokumenty"]
[null,null,"Klient čestne vyhlasuje, že nemá záväzky po lehote splatnosti voči Sociálnej poisťovni a.s., daňovým úradom, iným správcom dane, úradom práce sociálnych vecí a rodiny a zdravotným poisťovniam, a že voči nemu nie sú vedené súdne spory o zaplatenie peňažných dávok, návrh na exekúciu, výkon rozhodnutia, konkurz, reštrukturalizácia resp. vyrovnanie v zmysle zákona č. 7/2005 Z.z. o konkurze a reštrukturalizácii v znení neskorších predpisov."]
[]
[]
[null,null,"Klient vyhlasuje, že v „CRP“, vrátane príloh a dokladov na predloženie, ktorých bol vyzvaný bankou uviedol všetky údaje, skutočnosti a zámery úplne a pravdivo a nezatajil žiadne svoje záväzky a majetok, ktorý by bol vhodný na zabezpečenie úveru."]
[]
[]
[]
[null,null,"Vyhlasujem, že údaje a dokumenty predložené k žiadosti o úver sú pravdivé"]
[]
[]
[]
[null,"Dátum podpisu vyhlásenia:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"......................................................................... "]
[null,null,null,"Pečiatka a podpis štatutárneho zástupcu *"]
[]
[]
[]
[]
[]
[]
[null,"Údaje o senior business managerovi/business managerovi"]
[]
[null,"Meno a priezvisko:"]
[null,"Organizačná jednotka:",null,"  ............................................."]
[null,null,null,"Overené - podpis SBM/BM"]
[]
[]
[null,"Poznámka:"]
[null,"* štatutárny zástupca sa podpíše jedenkrát na origináli a jedenkrát na kópii tohto listu"]
[null,null,null,null,2]

{"sheet":"List of required documents","index":3,"n_rows":64,"n_cols":5,"rows_kept":64,"cut":false,"hidden":true,"merged":[[60,2,60,3],[58,2,58,3],[57,2,57,3],[19,3,19,6],[20,3,20,6],[21,3,21,6],[59,2,59,3],[21,0,21,1],[12,0,12,1],[10,3,10,6],[11,3,11,6],[12,3,12,6],[13,3,13,6],[14,3,14,6],[13,0,13,1],[14,0,14,1],[19,0,19,1],[10,0,10,1],[11,0,11,1],[15,0,15,1],[18,0,18,1],[15,3,15,6],[18,3,18,6],[6,0,6,1],[8,0,8,1],[8,3,8,6],[6,3,6,6],[20,0,20,1],[7,0,7,1],[9,3,9,6],[9,0,9,1],[16,3,16,6],[17,3,17,6],[16,0,16,1],[17,0,17,1]]}
[]
[{"$f":"\"Client: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Client: "}]
[]
["List of documents required by bank for determination of rating and assessment of credit application "]
[]
[]
["Document",null,"Form ","Condition"]
["GENERAL DOCUMENTS:"]
["Commercial register or business licence",null,"O","current, not older then 3 months in time of loan documentation signing"]
["Deed of foundation, partnership contract and statutes",null,"C","current"]
["if single-entry bookkeeping: Assets and liabilities statement, Income and expenses statement\nIf double-entry bookkeeping: Balance sheet, Profit and loss statement",null,"O","for 2 finiished accounting periods and current (not older than 3 months)"]
["Tax return with stamp (or confirmation about submittion of tax return with stamp of Tax office) + audit report (if available)",null,"C","for 2 finiished accounting periods "]
["Business plan + Financial statements projections*",null,null,"for min 2 next accounting periods"]
["Contracts and invoices documenting the purpose of the use of the credit",null,"O"]
["Certificates of settlement of liabilities to the Tax Office, Social insurence company and health insurence companies in case their existence in time of financial statements complation",null,"O","not older then 3 months in tiem of first loan drawdown"]
["Age structure of trade accounts receivables / payables in customers / suppliers",null,null,"status as of actual financial statements"]
["Contracts of purchase, Contracts of lease, Contracts",null,"C"]
["Documents confirming ownership to assets stated for pledge",null,"C"]
["DOCUMENTS RELATED TO COLLATERAL "]
["Expert opinion",null,"O"]
["Letter of ownership",null,"O","current, not older then 3 months in time of loan documentation signing, usable for legal acts"]
["Insurance contract on pledged property",null,"C","current"]
[]
[]
[]
[]
[]
[]
[]
["* in case of investment loan, please submit financial projections for current year and next two years, if custom manufacturing than for one next yera (alternatively min list of future contracts)"]
[]
["Legend:"]
["O - originál, C - copy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Reported periods - Technical parameters",null,null,null,{"$f":"IF(B63=0,\"OK - periods follow\",\"change periods - they don´t follow!!!\")","v":"OK - periods follow"}]
["Period","Previous accounting period","Last finished accounting period",null,"Current period of current year"]
[null,"Fact","Fact",null,"Fact"]
["From ","2010-01-01",{"$f":"B61+1","v":"2011-01-01"},null,{"$f":"C61+1","v":"2012-01-01"}]
["To","2010-12-31","2011-12-31",null,"2012-03-31"]
[]
[null,{"$f":"SUM(C63:J64)+F65","v":0},{"$f":"C60-B61-1","v":0},{"$f":"D60-C61-1","v":-40909},{"$f":"E60-D61-1","v":40908}]
[null,null,{"$f":"IF(OR((C61-C60+1)=365,(C61-C60+1)=366),0,1)","v":0},{"$f":"IF(OR((D61-D60+1)=365,(D61-D60+1)=366),0,1)","v":1},{"$f":"IF(AND(E61-E60+1<=366,E61-E60>0),0,1)","v":0}]

{"sheet":"Additional financial data JU","index":4,"n_rows":91,"n_cols":8,"rows_kept":91,"cut":false,"hidden":true,"merged":[[90,0,90,14],[53,0,53,4],[78,0,78,6],[80,0,80,6],[81,0,82,0],[81,1,81,2],[81,3,81,4],[81,5,81,6],[8,1,10,1],[49,1,50,1],[18,0,18,4],[39,1,48,1],[24,0,24,1],[25,0,25,1],[34,1,38,1],[11,1,13,1],[14,1,17,1]]}
[]
[{"$f":"\"Klient: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Klient: "}]
[]
["Doplňujúce údaje  k Výkazu o majetku a záväzkoch a počet zamestnancov"]
[]
[]
[null,null,null,null,"(EUR 000)"]
["Položka","Riadok",{"$f":"'List of required documents'!B61","v":"2010-12-31"},{"$f":"'List of required documents'!C61","v":"2011-12-31"},{"$f":"'List of required documents'!E61","v":"2012-03-31"}]
["Pozemky",2]
["Stavby"]
["Samostatné hnuteľné veci a súbory hnuteľných vecí (Stroje, prístroje a zariadenia, dopr. prostriedky a inventár)"]
["Pohľadávky z obchodného styku",7]
["Pohľadávky voči štátu"]
["Poskytnuté preddavky"]
["Záväzky z obchodného styku",16]
["Záväzky voči štátu"]
["Prijaté preddavky"]
["Záväzky z leasingu"]
[]
[]
[]
[]
["Počet zamestnancov"]
[]
["Ukazovateľ",null,{"$f":"'List of required documents'!B61","v":"2010-12-31"},{"$f":"'List of required documents'!C61","v":"2011-12-31"},{"$f":"'List of required documents'!E61","v":"2012-03-31"}]
["Priemerný stav zamestnancov"]
[]
[null,null,null,null,3]
[]
["Doplňujúce údaje k Výkazu o príjmoch a výdavkoch"]
[]
[]
[null,null,null,null,"(EUR 000)"]
["Položka","Riadok",{"$f":"'List of required documents'!B61","v":"2010-12-31"},{"$f":"'List of required documents'!C61","v":"2011-12-31"},{"$f":"'List of required documents'!E61","v":"2012-03-31"}]
["Tržby z predaja dlhodobého nehmotného a hmotného majetku (nehmotného a hmotného investičného majetku)","03"]
["Výnosové úroky"]
["Kurzové zisky"]
["                                                                                                    1)"]
["                                                                                                    1)"]
["Platené nájomné",10]
["Opravy a udržiavanie"]
["Energia"]
["Kooperácie (subdodávky) - služby priamo súvisiace s výrobou 2)"]
["Dane a poplatky"]
["Odpisy dlhodobého nehmotného a hmotného majetku (nehmotného a hmotného investičného majetku)"]
["    - odpisy sú súčasťou prevádzkovej réžie                               3)"]
["Zostatková cena predaného dlhodobého nehmotného a hmotného majetku (nehmotného a hmotného inv. majetku)"]
["Kurzové straty"]
["Úroky z úverov a iných pôžičiek"]
["                                                                                                          4)",10]
["                                                                                                          4)"]
["Peňažný vklad podnikateľa"]
["Výdavky na osobnú spotrebu"]
[]
["1) Iné 2 najvýznamnejšie položky ostatných príjmov okrem vyššie uvedených"]
["2) Služby prijaté od iných subjektov, priamo súvisiace s tržbami z hlavnej činnosti (napr. externé poddodávky v stavebníctve,"]
["    náklady na externú prepravu u prepravných spoločností a pod.)"]
["3) uviesť ANO, resp. NIE"]
["4) Iné 2 najvýznamnejšie položky prevádzkovej réžie okrem vyššie uvedených"]
[]
["Rozbor príjmov podľa podnikateľských aktivít"]
[null,null,null,null,null,null,null,"(EUR 000)"]
["Podnikateľská aktivita","Riadok",{"$f":"'[1]Zoznam požadovaných dokumentov'!B56","v":"2009-12-31"},"Podiel",{"$f":"'[1]Zoznam požadovaných dokumentov'!C56","v":"2010-12-31"},"Podiel",{"$f":"'[1]Zoznam požadovaných dokumentov'!E56","v":"2011-03-07"},"Podiel"]
["Príjmy celkom, z toho:","01-02",null,{"$f":"IF(C64=0,\"\",C64/C64)","v":""},null,{"$f":"IF(E64=0,\"\",E64/E64)","v":""},null,{"$f":"IF(G64=0,\"\",G64/G64)","v":""}]
["Príjmy z predaja výrobkov, z toho:","01",null,{"$f":"IF(C$64=0,\"\",C65/C$64)","v":""},null,{"$f":"IF(E$64=0,\"\",E65/E$64)","v":""},null,{"$f":"IF(G$64=0,\"\",G65/G$64)","v":""}]
[null,null,null,{"$f":"IF(C$64=0,\"\",C66/C$64)","v":""},null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,{"$f":"IF(C$64=0,\"\",C68/C$64)","v":""},null,"",null,""]
["Príjmy z predaja služieb, z toho:","01",null,"",null,"",null,""]
[null,null,null,{"$f":"IF(C$64=0,\"\",C70/C$64)","v":""},null,"",null,""]
[null,null,null,"",null,"",null,""]
[null,null,null,{"$f":"IF(C$64=0,\"\",C72/C$64)","v":""},null,"",null,""]
["Príjmy z predaja tovaru, z toho:","02",null,{"$f":"IF(C$64=0,\"\",C73/C$64)","v":""},null,"",null,""]
[null,null,null,{"$f":"IF(C$64=0,\"\",C74/C$64)","v":""},null,"",null,""]
[null,null,null,{"$f":"IF(C$64=0,\"\",C75/C$64)","v":""},null,"",null,""]
[null,null,null,{"$f":"IF(C$64=0,\"\",C76/C$64)","v":""},null,"",null,""]
["Špecifikujte prosím príjmy podľa vlastných výrobkov, služieb a tovarov, ktoré majú podiel na celkových príjmoch min. 15%"]
["Napr. v prípade predaja potravín vyšpecifikujte cukrovinky ak majú podiel na celkových príjmoch min. 15%"]
["Špecifikujte prosím výkony podľa vyprodukovaných / predaných objemových jedniek (kusy, tony, m2, m3, litre, GJ, kWh, ....) typických pre predmet podnikania"]
[]
["Rozbor výkonov podľa vyprodukovaných / predaných objemových jednotiek (pre max 5 najdôležitejších produktov / tovarov)"]
[null,{"$f":"'List of required documents'!B61","v":"2010-12-31"},null,{"$f":"'List of required documents'!C61","v":"2011-12-31"},null,{"$f":"'List of required documents'!E61","v":"2012-03-31"}]
[null,"objemové jednotky","EUR","objemové jednotky","EUR","objemové jednotky","EUR"]
[]
[]
[]
[]
[]
[]
["Komentár k rozboru príjmov:"]
["uveďte prosím dôvody zmeny štruktúry príjmov v minulosti (faktory ktoré ovplyvnili výšku a štruktúru príjmov)  "]

{"sheet":"Additional financial data PU","index":5,"n_rows":89,"n_cols":7,"rows_kept":89,"cut":false,"hidden":true,"merged":[[28,0,28,6],[36,0,36,2],[37,0,37,2],[49,1,50,1],[49,3,50,3],[85,0,85,6],[49,4,50,4],[49,5,50,5],[49,6,50,6],[59,1,60,1],[59,3,60,3],[59,4,60,4],[59,5,60,5],[59,6,60,6],[83,0,83,6]]}
[]
[{"$f":"\"Client: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Client: "}]
[]
["Additional data to balance sheet"]
[null,null,null,null,null,null,"(EUR 000)"]
["Item","Account","Line*","2008-12-31",{"$f":"'List of required documents'!B61","v":"2010-12-31"},{"$f":"'List of required documents'!C61","v":"2011-12-31"},{"$f":"'List of required documents'!E61","v":"2012-03-31"}]
["Long term advance payments",314,"039 (041)"]
["Short term advance payments",314,"047 (048)"]
["Long term trade account receivables from subsidiary and parent","311A, 315A","039 (041)"]
["Long term loans given to controling entity (parent company)                                                1)                          ","351A","041 (042)"]
["Other long term receivables from group companies (given loans)","378A","044 (045)"]
["Short term trade receivables from group comapnies ","311A, 315A","047 (048)"]
["Short term loans given to controling entity (parent company)      1)","351A","049 (049)"]
["Other short term receivables from group companies (given loans)","378A","054 (054)"]
["Long term trade liabilities from group companies ","479A","095 (095)"]
["Other long term liabilities from group companies (received loans)","479A","104 (103)"]
["Short term trade liabilities from group companies","321A, 325A","107 (106)"]
["Other short term liabilities from group companies (received loans)"," 379A","116 (114)"]
["Received short term operating advanced payments",324,"107 (106)"]
["Liabilities to owners form received loans     2)",365,"112 (110)"]
["Liabilities to owners from previous years undistributed profit",364,"112 (110)"]
["Liabilities from investments","321A","107 (106)"]
["Deferred imcome, from that:",384,"124, 125 (122, 123)"]
["       Subsidy for purchase of Long term property","384A","124 (122)"]
["Amount of right for dotation for purchase od Long term property accounted on account 346 - dotation from state budget","346A","053 (053)"]
["Payed dividends, profit shares for period","MD 364"]
["Subordinated debts based on Subordinated bank contract                        3)"]
[]
["* numbers of lines related to financial statements valid from 01.01.2011 (numbers of lines in brackets related to financial statements valid to 31.12.2010)"]
["1) Fill in only daughters companies"]
["2) Specifiy please the sum, account and line of balance sheet, if received loans are accounted at different acounts (exept of 365)"]
["3) Specifiy please the sum, account and line of balance sheet, on which are subordinated liabilities acconted"]
[]
[]
["Number of employees"]
[]
["Indicator",null,null,"2007-12-31",{"$f":"'List of required documents'!B61","v":"2010-12-31"},{"$f":"'List of required documents'!C61","v":"2011-12-31"},{"$f":"'List of required documents'!E61","v":"2012-03-31"}]
["Average number of employees"]
[null,null,null,null,null,null,3]
["Additional data to Profit and loss statement"]
[null,null,null,null,null,null,"(EUR 000)"]
["Item","Account","Line","2007-12-31",{"$f":"'List of required documents'!B61","v":"2010-12-31"},{"$f":"'List of required documents'!C61","v":"2011-12-31"},{"$f":"'List of required documents'!E61","v":"2012-03-31"}]
["Own work capitalized (account group 62), from that:",null,"6 (7)"]
["   - activation of core plump",624,"6 (7)"]
["   - activation of non-current assets","623, 624","7 (7)"]
["Energy consumptions (energy and other noninventory items)","502, 503","9 (9)"]
["Services total, from that:",null,"10 (10)"]
["   - Repair and maintenance",511,"10 (10)"]
["   - Rental expense","518A","10 (10)"]
["   - Subcontractor expenses - services related directly to production 1)                                                                                                                                                    ","518A","10 (10)"]
["         súvisiace s výrobou                                       1)",null,"10 (10)"]
["   -                                                                             2)","518A","10 (10)"]
["   -                                                                             2)","518A","10 (10)"]
["   -                                                                             2)","518A","10 (10)"]
["Revenues from sale of material",642,"19 (19)"]
["Carrying value of sold material",542,"20 (20)"]
["Others revenues from operational activities total, from that:           "," 644,645,646,648,655,657","22 (21)"]
["   - Revenues from written off receivable",646,"22 (21)"]
["   - Settlement of current purposes dotation","648A","22 (21)"]
["   - Settlement of dotation for purchase of LT","648A","22 (21)"]
["     property (investment dotation)",null,"22 (21)"]
["   -                                                                           3)",null,"22 (21)"]
["   -                                                                           3)",null,"22 (21)"]
["   -                                                                           3)",null,"22 (21)"]
["Other expenses from operational activities total, from that:           ","543,544,545,546,547,548,549,555,557","23 (22)"]
["   - Written off receivables",546,"23 (22)"]
["   -                                                                           3)",null,"23 (22)"]
["   -                                                                           3)",null,"23 (22)"]
["   -                                                                           3)",null,"23(22)"]
["Creation of long term provisions:                  ","548, 568, resp.related cost account","23,43, resp.related line of profit and loss account"]
["   -                                                                           4)"]
["   -                                                                           4)"]
["   -                                                                           4)"]
["Reversal of long term provisions:                   ","(-548),(-568), resp.related cost account","23,43, resp.related line of profit and loss account"]
["   -                                                                           4)"]
["   -                                                                           4)"]
["   -                                                                           4)"]
[]
["By agricultural companies please fill in:"]
[]
["Revenues from purchase of basic herd",641,"19 (19)"]
["Carrying value of sold basic herd",541,"20 (20)"]
[]
["1) Services received from other subjects directly related to revenues from main activity (for example. external subsupplies in building industry, expenses on external transportation and so on.)"]
["2) Other 3 main items of services excluding upper mentioned "]
["3) Fill please description, account and value of significant items of other revenues and expenses from operational activities (for example insurance incoming, incoming of VAT, refacturation, penalties, creation of rectifying items and so on.)"]
["4) Fill please type of provisions, which are accounting through profit and loss statement "]
["A = analytical evidence"]
[null,null,null,null,null,null,4]

{"sheet":"Customers, suppliers JU","index":6,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":true,"merged":[[0,1,0,7],[16,0,16,12],[36,0,36,12]]}
[]
[{"$f":"\"Klient: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Klient: "}]
[]
["Uveďte minimálne 5 najväčších odberateľov podľa podielu na príjmoch"]
[{"$f":"\"Pozn.: Štruktúru odberateľov k \"&TEXT('List of required documents'!$C$61,\"dd.mm.yyyy\")&\" považujte za východiskovú.\"","v":"Pozn.: Štruktúru odberateľov k 31.12.2011 považujte za východiskovú."},null,null,null,null,null,null,null,null,null,null,null,"(EUR 000)"]
["Názov odberateľa","Štát odberateľa","Forma spolupráce 1)","Dĺžka spolupráce (v rokoch)","Obsah dodávok","Mena 2)","Dohodnuté splatnosti (počet dní)",{"$f":"'List of required documents'!B61","v":"2010-12-31"},"Podiel [%]",{"$f":"'List of required documents'!C61","v":"2011-12-31"},"Podiel [%]",{"$f":"'List of required documents'!E61","v":"2012-03-31"},"Podiel [%]"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H$13=\"\",\"\",H7/H$13)","v":""},null,{"$f":"IF(J$13=\"\",\"\",J7/J$13)","v":""},null,{"$f":"IF(L$13=\"\",\"\",L7/L$13)","v":""}]
[null,null,null,null,null,null,null,null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,"",null,""]
["Ostatní",null,null,null,null,null,null,{"$f":"IF(H13=\"\",\"\",H13-SUM(H7:H11))","v":""},"",{"$f":"IF(J13=\"\",\"\",J13-SUM(J7:J11))","v":""},"",{"$f":"IF(L13=\"\",\"\",L13-SUM(L7:L11))","v":""},""]
["Príjmy celkom ",null,null,null,null,null,null,{"$f":"IF('Additional financial data JU'!C64=\"\",\"\",'Additional financial data JU'!C64)","v":""},"",{"$f":"IF('Additional financial data JU'!E64=\"\",\"\",'Additional financial data JU'!E64)","v":""},"",{"$f":"IF('Additional financial data JU'!G64=\"\",\"\",'Additional financial data JU'!G64)","v":""},""]
["1) - mena v ktorej je kontrahovaná predajná cena, číselné údaje sú však v EUR 000"]
[]
["Komentár k štruktúre odberateľov:"]
["špecifikujte prosím dôvody zmien v odberateľskom portfóliu v minulosti, možnosti nahradenia kľúčových odberateľov v prípade ich výpadku vrátane popisu dôsledkov pre firmu a najdôležitejšie uzatvorené kontrakty (odberateľ, výška, trvanie kontraktu) na najbližšie obdobie"]
[]
[]
[]
[]
[]
[]
[]
["Uveďte minimálne 5 najväčších dodávateľov podľa podielu na dodávkach materiálu, tovaru, energie a služieb"]
[{"$f":"\"Pozn.: Štruktúru odberateľov k \"&TEXT('List of required documents'!$C$61,\"dd.mm.yyyy\")&\" považujte za východiskovú.\"","v":"Pozn.: Štruktúru odberateľov k 31.12.2011 považujte za východiskovú."},null,null,null,null,null,null,null,null,null,null,null,"(EUR 000)"]
["Názov dodávateľa","Štát dodávateľa","Forma spolupráce 1)","Dĺžka spolupráce (v rokoch)","Obsah dodávok","Mena 2)","Dohodnuté splatnosti (počet dní)",{"$f":"'List of required documents'!B61","v":"2010-12-31"},"Podiel [%]",{"$f":"'List of required documents'!C61","v":"2011-12-31"},"Podiel [%]",{"$f":"'List of required documents'!E61","v":"2012-03-31"},"Podiel [%]"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H$34=0,\"\",H28/H$34)","v":""},null,{"$f":"IF(J$34=0,\"\",J28/J$34)","v":""},null,{"$f":"IF(L$34=0,\"\",L28/L$34)","v":""}]
[null,null,null,null,null,null,null,null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,{"$f":"IF(J$34=0,\"\",J32/J$34)","v":""},null,""]
["Ostatní",null,null,null,null,null,null,{"$f":"IF(H34=0,\"\",H34-SUM(H28:H32))","v":""},"",{"$f":"IF(J34=0,\"\",J34-SUM(J28:J32))","v":""},"",{"$f":"IF(L34=0,\"\",L34-SUM(L28:L32))","v":""},""]
["Dodávky celkom",null,null,null,null,null,null,null,"",null,"",null,""]
[]
["Komentár k štruktúre dodávateľov:"]
["špecifikujte prosím dôvody zmien v dodávateľskom portfóliu v minulosti, možnosti nahradenia kľúčových dodávateľov v prípade ich výpadku vrátane popisu dôsledkov pre firmu a najdôležitejšie uzatvorené kontrakty (dodávateľ, výška, trvanie kontraktu) na najbližšie obdobie"]
[]
[]
[]
[]
[]
[]
[]
["3 najväčší konkurenti"]
[]
["Názov konkurenta","Podiel na trhu v %"]
[]
[]
[]
[]
["1) - uveďte formu spolupráce - napr. kontrakt, rámcová zmluva, zmluva o dielo, objednávka"]
["2) - mena v ktorej je kontrahovaná nákupná cena, číselné údaje sú však v EUR 000"]
[null,null,null,null,null,null,null,null,null,null,null,null,5]

{"sheet":"Analysis of revenues PU","index":7,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":true,"merged":[[40,0,40,6],[29,0,29,6],[42,0,42,14],[33,0,34,0],[31,0,31,6],[33,5,33,6],[33,1,33,2],[33,3,33,4]]}
[" "]
[{"$f":"\"Client: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Client: "}]
[]
["Analyses of revenues by business activities"]
[null,null,null,null,null,null,"(EUR 000)"]
["Business activity",{"$f":"'List of required documents'!B61","v":"2010-12-31"},"Share",{"$f":"'List of required documents'!C61","v":"2011-12-31"},"Share",{"$f":"'List of required documents'!E61","v":"2012-03-31"},"Share"]
["Revenues total, from that:",null,{"$f":"IF(B7=0,\"\",B7/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D7/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F7/F$8)","v":""}]
["Revenues from the sale of own products total (účet 601), from that:",null,{"$f":"IF(B7=0,\"\",B8/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D8/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F8/F$8)","v":""}]
[null,null,{"$f":"IF(B7=0,\"\",B9/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D9/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F9/F$8)","v":""}]
[null,null,{"$f":"IF(B7=0,\"\",B10/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D10/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F10/F$8)","v":""}]
[null,null,{"$f":"IF(B7=0,\"\",B11/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D11/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F11/F$8)","v":""}]
[null,null,{"$f":"IF(B7=0,\"\",B12/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D12/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F12/F$8)","v":""}]
[null,null,{"$f":"IF(B7=0,\"\",B13/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D13/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F13/F$8)","v":""}]
["Revenues from the sale of services total (účet 602), from that:",null,{"$f":"IF(B7=0,\"\",B14/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D14/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F14/F$8)","v":""}]
[null,null,{"$f":"IF(B7=0,\"\",B15/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D15/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F15/F$8)","v":""}]
[null,null,{"$f":"IF(B7=0,\"\",B16/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D16/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F16/F$8)","v":""}]
[null,null,{"$f":"IF(B7=0,\"\",B17/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D17/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F17/F$8)","v":""}]
[null,null,{"$f":"IF(B7=0,\"\",B18/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D18/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F18/F$8)","v":""}]
[null,null,{"$f":"IF(B7=0,\"\",B19/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D19/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F19/F$8)","v":""}]
["Revenues from the sale of goods total (účet 604), from that:",null,{"$f":"IF(B7=0,\"\",B20/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D20/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F20/F$8)","v":""}]
[null,null,{"$f":"IF(B7=0,\"\",B21/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D21/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F21/F$8)","v":""}]
[null,null,{"$f":"IF(B7=0,\"\",B22/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D22/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F22/F$8)","v":""}]
[null,null,{"$f":"IF(B7=0,\"\",B23/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D23/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F23/F$8)","v":""}]
[null,null,{"$f":"IF(B7=0,\"\",B24/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D24/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F24/F$8)","v":""}]
[null,null,{"$f":"IF(B7=0,\"\",B25/B$8)","v":""},null,{"$f":"IF(D7=0,\"\",D25/D$8)","v":""},null,{"$f":"IF(F7=0,\"\",F25/F$8)","v":""}]
[]
[]
["Specify please the revenues according to your products, services and goods, whitch have the share on total revenues min. 15%"]
["For example. in case of seling food-stuff you can specify sweets when they have share over 15% on total revenues"]
["Specifiy please the revenues according to produced / sold volume (pieces, tonnes, m2, m3, liters, GJ, kWh, ....) typical for business."]
[]
["Analyses of business activities according to produced / sold volume (for max 5 most important products / goods)"]
[]
[null,{"$f":"'List of required documents'!B61","v":"2010-12-31"},null,{"$f":"'List of required documents'!C61","v":"2011-12-31"},null,{"$f":"'List of required documents'!E61","v":"2012-03-31"}]
[null,"volume","EUR","volume","EUR","volume","EUR"]
[]
[]
[]
[]
[]
[]
["Comment:"]
["(specify please reasons for change of turnover structure in the past (factors which influenced volume of turnover and its structure)  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,5]
[]
[null,null,null,null,null,null,5]

{"sheet":"Customers, suppliers PU","index":8,"n_rows":65,"n_cols":15,"rows_kept":65,"cut":false,"hidden":true,"merged":[[0,1,0,14],[15,0,15,14],[40,0,40,14]]}
[]
[{"$f":"\"Client: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Client: "}]
[]
["5 current main customers due to revenues share (601, 602, 604)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(EUR 000)"]
["Name of customer","Customer state","Form of cooperation 1)","Time of cooperation (in years)","Content of supplies","Currency 2)","Contractual payments (number of days)",{"$f":"#REF!","v":{"$error":"#REF!"}},"Podiel [%]",{"$f":"#REF!","v":{"$error":"#REF!"}},"Podiel [%]",{"$f":"'List of required documents'!C61","v":"2011-12-31"},"Share\n[%]",{"$f":"'List of required documents'!E61","v":"2012-03-31"},"Share\n[%]"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H$13=\"\",\"\",H7/H$13)","v":{"$error":"#REF!"}},null,{"$f":"IF(J$13=\"\",\"\",J7/J$13)","v":{"$error":"#REF!"}},null,{"$f":"IF(L$13=\"\",\"\",L7/L$13)","v":""},null,{"$f":"IF(N$13=\"\",\"\",N7/N$13)","v":""}]
[null,null,null,null,null,null,null,null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,"",null,""]
[null,null,null,null,null,null,null,null,{"$error":"#REF!"},null,{"$error":"#REF!"},null,"",null,""]
["Others",null,null,null,null,null,null,{"$f":"IF(H13=\"\",\"\",H13-SUM(H7:H11))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(J13=\"\",\"\",J13-SUM(J7:J11))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(L13=\"\",\"\",L13-L7-L8-L9-L10-L11)","v":""},"",{"$f":"IF(N13=\"\",\"\",N13-N7-N8-N9-N10-N11)","v":""},""]
["Revenues total (601+602+604)",null,null,null,null,null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF('Analysis of revenues PU'!D7=\"\",\"\",'Analysis of revenues PU'!D7)","v":""},{"$f":"IF(L$38=0,\"\",L13/L$13)","v":""},{"$f":"IF('Analysis of revenues PU'!F7=\"\",\"\",'Analysis of revenues PU'!F7)","v":""},{"$f":"IF(N$38=0,\"\",N13/N$13)","v":""}]
[]
["Comment to customers:"]
["(Specify please reasons for change of structure of customers portfolio in the past, posibilities of replacement of key customers in case of finished cooperation including specification of results for client, and also specify most important signed contracts (customer, amount, duration) for the next period.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["5 current main suppliers due to share on supplies of material, goods, energy and services"]
[]
["(Acquisition of material / account 111, Acquisition of goods / acount 131, Consumption of energy / account 502, consumption of other non-inventory supplies / account 503, Services / account 51)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(EUR 000)"]
["Name of supplier","Supplier state","Form of cooperation 1)","Time of cooperation (in years)","Content of supplies","Currency 2)","Contractual payments (number of days)",{"$f":"#REF!","v":{"$error":"#REF!"}},"Podiel [%]",{"$f":"#REF!","v":{"$error":"#REF!"}},"Podiel [%]",{"$f":"'List of required documents'!C61","v":"2011-12-31"},"Share [%]",{"$f":"'List of required documents'!E61","v":"2012-03-31"},"Share [%]"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H$38=0,\"\",H32/H$38)","v":""},null,{"$f":"IF(J$38=0,\"\",J32/J$38)","v":""},null,{"$f":"IF(L$38=0,\"\",L32/L$38)","v":""},null,{"$f":"IF(N$38=0,\"\",N32/N$38)","v":""}]
[null,null,null,null,null,null,null,null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,"",null,"",null,"",null,""]
["Others",null,null,null,null,null,null,{"$f":"IF(H38=0,\"\",H38-SUM(H32:H36))","v":""},"",{"$f":"IF(J38=0,\"\",J38-SUM(J32:J36))","v":""},"",{"$f":"IF(L38=0,\"\",L38-SUM(L32:L36))","v":""},"",{"$f":"IF(N38=0,\"\",N38-SUM(N32:N36))","v":""},""]
["Supplies total",null,null,null,null,null,null,null,"",null,"",null,"",null,""]
[]
["Comment to suppliers:"]
["(Specify please reasons for change of structure of suppliers portfolio in the past, posibilities of replacement of key suppliers in case of finished cooperation including specification of results for client, and also specify most important signed contracts (supplier, amount, duration) for the next period.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3 most important competitors"]
[]
["Name of competitor","Market share in %"]
[]
[]
[]
[]
["1) form of cooperation - for example contract, framework agreement, contract for work, order"]
["2) currency in which the purchase price is contracted, but numbers are in EUR 000"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]

{"sheet":"Receiv., liabilities,stock JU","index":9,"n_rows":118,"n_cols":21,"rows_kept":118,"cut":false,"hidden":true,"merged":[[113,7,113,14],[114,7,114,14],[115,7,115,14],[111,7,112,14],[113,3,113,4],[114,3,114,4],[115,3,115,4],[113,5,113,6],[114,5,114,6],[115,5,115,6],[111,0,112,0],[107,5,107,6],[111,3,112,4],[111,5,112,6],[103,3,104,4],[103,5,104,6],[105,3,105,4],[105,5,105,6],[106,3,106,4],[106,5,106,6],[0,1,0,8],[103,0,104,0],[103,7,104,14],[105,7,105,14],[107,3,107,4],[106,7,106,14],[107,7,107,14]]}
[]
[{"$f":"\"Klient: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Klient: "}]
[]
["Časová štruktúra pohľadávok z obchodného styku",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hodnoty pre graf"]
[null,null,null,null,null,null,"(EUR 000)"]
[null,{"$f":"'List of required documents'!B61","v":"2010-12-31"},"Podiel",{"$f":"'List of required documents'!C61","v":"2011-12-31"},"Podiel",{"$f":"'List of required documents'!E61","v":"2012-03-31"},"Podiel",null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"B6","v":"2010-12-31"},{"$f":"D6","v":"2011-12-31"},{"$f":"F6","v":"2012-03-31"}]
["Pohľadávky z OS celkom, z toho:",null,{"$f":"IF(B$7=0,\"\",B7/B$7)","v":""},null,{"$f":"IF(D$7=0,\"\",D7/D$7)","v":""},null,{"$f":"IF(F$7=0,\"\",F7/F$7)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"B7","v":0},{"$f":"D7","v":0},{"$f":"F7","v":0}]
[" - Do lehoty splatnosti",{"$f":"IF(B7=0,\"\",B7-SUM(B10:B14))","v":""},{"$f":"IF(B$7=0,\"\",B8/B$7)","v":""},{"$f":"IF(D7=0,\"\",D7-SUM(D10:D14))","v":""},{"$f":"IF(D$7=0,\"\",D8/D$7)","v":""},{"$f":"IF(F7=0,\"\",F7-SUM(F10:F14))","v":""},{"$f":"IF(F$7=0,\"\",F8/F$7)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"","",""]
[" - Po lehote splatnosti celkom, z toho:",{"$f":"IF(SUM(B10:B14)=0,\"\",SUM(B10:B14))","v":""},{"$f":"IF(SUM(B10:B14)=0,\"\",B9/B$7)","v":""},{"$f":"IF(SUM(D10:D14)=0,\"\",SUM(D10:D14))","v":""},{"$f":"IF(SUM(D10:D14)=0,\"\",D9/D$7)","v":""},{"$f":"IF(SUM(F10:F14)=0,\"\",SUM(F10:F14))","v":""},{"$f":"IF(SUM(F10:F14)=0,\"\",F9/F$7)","v":""}]
["    - do 30 dní po LS",null,{"$f":"IF(B$7=0,\"\",B10/B$7)","v":""},null,{"$f":"IF(D$7=0,\"\",D10/D$7)","v":""},null,{"$f":"IF(F$7=0,\"\",F10/F$7)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,0,0]
["    - od 31do 90 dní po LS",null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,0,0]
["    - od 91 do 180 dní po LS",null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,0,0]
["    - od 181 do 360 dní po LS",null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,0,0]
["    - nad 360 dní po LS",null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,0,0]
["Nedobytné pohľadávky",null,"",null,"",null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Komentár k riešeniu polehotných pohľadávok:"]
["špecifikujte prosím odberateľov, výšku pohľadávky, pôvodnú splatnosť, riešenie a predpokladanú sumu inkasa"]
[]
[]
[]
[]
["Koeficienty paušálnej tvorby opravných položiek k pohľadávkam"]
[null,null,null,null,null,"(%)"]
["Potreba dotvorenia OP ",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Do lehoty splatnosti",0,null,0,null,0]
["Do 30 dní po LS",0,null,0,null,0]
["Do 90 dní po LS",0,null,0,null,0]
["Do 180 dní po LS",0.2,null,0.2,null,0.2]
["Do 360 dní po LS",0.5,null,0.5,null,0.5]
["Nad 360 dní po LS",1,null,1,null,1]
[]
["Paušálna tvorba opravných položiek k pohľadávkam"]
[null,null,null,null,null,"(SKK 000)"]
["Paušálna tvorba OP ",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Do lehoty splatnosti",{"$f":"B38*B8","v":{"$error":"#VALUE!"}},null,{"$f":"D38*D8","v":{"$error":"#VALUE!"}},null,{"$f":"F38*F8","v":{"$error":"#VALUE!"}}]
["Do 30 dní po LS",{"$f":"B39*B10","v":0},null,{"$f":"D39*D10","v":0},null,{"$f":"F39*F10","v":0}]
["Do 90 dní po LS",{"$f":"B40*B11","v":0},null,{"$f":"D40*D11","v":0},null,{"$f":"F40*F11","v":0}]
["Do 180 dní po LS",{"$f":"B41*B12","v":0},null,{"$f":"D41*D12","v":0},null,{"$f":"F41*F12","v":0}]
["Do 360 dní po LS",{"$f":"B42*B13","v":0},null,{"$f":"D42*D13","v":0},null,{"$f":"F42*F13","v":0}]
["Nad 360 dní po LS",{"$f":"B43*B14","v":0},null,{"$f":"D43*D14","v":0},null,{"$f":"F43*F14","v":0}]
["Paušálne OP celkom",{"$f":"SUM(B48:B53)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(D48:D53)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(F48:F53)","v":{"$error":"#VALUE!"}}]
["Vytvorené opravné položky",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Potreba dotvorenia OP",{"$f":"IF(#REF!>=B54,0,IF(B54=0,\"\",B54-B55))","v":{"$error":"#REF!"}},null,{"$f":"IF(#REF!>=D54,0,IF(D54=0,\"\",D54-D55))","v":{"$error":"#REF!"}},null,{"$f":"IF(#REF!>=F54,0,IF(F54=0,\"\",F54-F55))","v":{"$error":"#REF!"}}]
[]
[]
["Časová štruktúra záväzkov z obchodného styku a voči štátnym inštitúciam"]
[null,null,null,null,null,null,"(EUR 000)"]
[null,{"$f":"'List of required documents'!B61","v":"2010-12-31"},"Podiel",{"$f":"'List of required documents'!C61","v":"2011-12-31"},"Podiel",{"$f":"'List of required documents'!E61","v":"2012-03-31"},"Podiel",null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"B61","v":"2010-12-31"},{"$f":"D61","v":"2011-12-31"},{"$f":"F61","v":"2012-03-31"}]
["Záväzky z OS, z toho:",null,{"$f":"IF(B$62=0,\"\",B62/B$62)","v":""},null,{"$f":"IF(D$62=0,\"\",D62/D$62)","v":""},null,{"$f":"IF(F$62=0,\"\",F62/F$62)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"B62","v":0},{"$f":"D62","v":0},{"$f":"F62","v":0}]
[" - Do lehoty splatnosti",{"$f":"IF(B62=0,\"\",B62-SUM(B65:B69))","v":""},{"$f":"IF(B$62=0,\"\",B63/B$62)","v":""},{"$f":"IF(D62=0,\"\",D62-SUM(D65:D69))","v":""},{"$f":"IF(D$62=0,\"\",D63/D$62)","v":""},{"$f":"IF(F62=0,\"\",F62-SUM(F65:F69))","v":""},{"$f":"IF(F$62=0,\"\",F63/F$62)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"","",""]
[" - Po lehote splatnosti celkom, z toho:",{"$f":"IF(SUM(B65:B69)=0,\"\",SUM(B65:B69))","v":""},{"$f":"IF(SUM(B65:B69)=0,\"\",B64/B$62)","v":""},{"$f":"IF(SUM(D65:D69)=0,\"\",SUM(D65:D69))","v":""},{"$f":"IF(SUM(D65:D69)=0,\"\",D64/D$62)","v":""},{"$f":"IF(SUM(F65:F69)=0,\"\",SUM(F65:F69))","v":""},{"$f":"IF(SUM(F65:F69)=0,\"\",F64/F$62)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"B64","v":""},{"$f":"D64","v":""},{"$f":"F64","v":""}]
["    - do 30 dní po LS",null,"",null,{"$f":"IF(D$62=0,\"\",D65/D$62)","v":""},null,{"$f":"IF(F$62=0,\"\",F65/F$62)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,0,0]
["    - od 31 do 90 dní po LS",null,"",null,{"$f":"IF(D$62=0,\"\",D66/D$62)","v":""},null,{"$f":"IF(F$62=0,\"\",F66/F$62)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,0,0]
["    - od 91 do 180 dní po LS",null,"",null,{"$f":"IF(D$62=0,\"\",D67/D$62)","v":""},null,{"$f":"IF(F$62=0,\"\",F67/F$62)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,0,0]
["    - od 181 do 360 dní po LS",null,"",null,{"$f":"IF(D$62=0,\"\",D68/D$62)","v":""},null,{"$f":"IF(F$62=0,\"\",F68/F$62)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,0,0]
["    - nad 360 dní po LS",null,"",null,{"$f":"IF(D$62=0,\"\",D69/D$62)","v":""},null,{"$f":"IF(F$62=0,\"\",F69/F$62)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},0,0,0]
["Záväzky voči štátnym inštit.,z toho:",{"$f":"IF(SUM(B71:B72)=0,\"\",SUM(B71:B72))","v":""},{"$f":"IF(SUM(B71:B72)=0,\"\",B70/B$70)","v":""},{"$f":"IF(SUM(D71:D72)=0,\"\",SUM(D71:D72))","v":""},{"$f":"IF(SUM(D71:D72)=0,\"\",D70/D$70)","v":""},{"$f":"IF(SUM(F71:F72)=0,\"\",SUM(F71:F72))","v":""},{"$f":"IF(SUM(F71:F72)=0,\"\",F70/F$70)","v":""}]
[" - Záväzky do lehoty splatnosti",null,{"$f":"IF(SUM(B71:B72)=0,\"\",B71/B$70)","v":""},null,{"$f":"IF(SUM(D71:D72)=0,\"\",D71/D$70)","v":""},null,{"$f":"IF(SUM(F71:F72)=0,\"\",F71/F$70)","v":""}]
[" - Záväzky po lehote splatnosti",null,{"$f":"IF(SUM(B71:B72)=0,\"\",B72/B$70)","v":""},null,{"$f":"IF(SUM(D71:D72)=0,\"\",D72/D$70)","v":""},null,{"$f":"IF(SUM(F71:F72)=0,\"\",F72/F$70)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Komentár k riešeniu polehotných záväzkov:"]
["špecifikujte prosím dodávateľov , výšku záväzku, pôvodnú splatnosť, riešenie a predpokladanú sumu zaplatenia"]
[]
[]
[]
[]
[]
["Neobracajúce sa a nepredajné zásoby"]
[null,null,null,null,null,null,"(EUR 000)"]
[null,{"$f":"'List of required documents'!B61","v":"2010-12-31"},"Podiel",{"$f":"'List of required documents'!C61","v":"2011-12-31"},"Podiel",{"$f":"'List of required documents'!E61","v":"2012-03-31"},"Podiel"]
["Zásoby brutto celkom, z toho:",null,{"$f":"IF(B$95=0,\"\",B95/B$95)","v":""},null,{"$f":"IF(D$95=0,\"\",D95/D$95)","v":""},null,{"$f":"IF(F$95=0,\"\",F95/F$95)","v":""}]
["   - nepredajné zásoby",null,"",null,"",null,""]
["   - zásoby na sklade nad 1 rok",null,"",null,"",null,""]
["   - zásoby na sklade nad 1/2 roka",null,"",null,"",null,""]
["Vytvorené opravné položky",null,"",null,"",null,""]
["Zásoby netto celkom",{"$f":"IF(B95=\"\",\"\",B95-B99)","v":""},"",{"$f":"IF(D95=\"\",\"\",D95-D99)","v":""},"",{"$f":"IF(F95=\"\",\"\",F95-F99)","v":""},""]
[]
["Súdne spory"]
[]
["Veriteľ",null,null,"Aktuálna výška záväzku",null,"Dátum vzniku súdneho sporu",null,"Popis príčin vzniku súdneho sporu, aktuálneho stavu, riešenia a očakávaného termínu jeho ukončenia + predložiť dokumenty súvisiace so súdnym sporom"]
[]
[]
[]
[]
[]
["Exekúcie"]
[]
["Veriteľ",null,null,"Aktuálna výška exekúcie",null,"Dátum vzniku exekúcie",null,"Popis príčin vzniku exekúcie, aktuálneho stavu, riešenia a očakávaného termínu jej ukončenia + predložiť dokumenty súvisiace s exekučným konaním"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]

{"sheet":"Receiv., liabilities,stock PU","index":10,"n_rows":146,"n_cols":21,"rows_kept":146,"cut":false,"hidden":true,"merged":[[116,5,116,6],[117,5,117,6],[118,5,118,6],[119,5,119,6],[137,7,137,16],[138,7,138,16],[130,7,130,16],[134,0,135,0],[134,5,135,5],[134,6,135,6],[134,7,135,16],[136,7,136,16],[126,0,127,0],[126,5,127,5],[126,6,127,6],[126,7,127,16],[128,7,128,16],[129,7,129,16],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[120,5,120,6],[121,5,121,6],[65,8,65,9],[66,8,66,9],[67,8,67,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[16,8,16,9],[15,8,15,9],[14,5,14,6],[15,5,15,6],[16,5,16,6],[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[81,7,81,8],[64,5,64,6],[65,5,65,6],[66,5,66,6],[67,5,67,6],[68,5,68,6],[69,5,69,6],[70,5,70,6],[71,5,71,6],[72,5,72,6],[77,7,77,8],[78,7,78,8],[79,7,79,8],[80,7,80,8],[74,5,74,9],[75,7,75,9],[75,5,75,6],[76,7,76,8],[72,8,72,9],[68,8,68,9],[69,8,69,9],[70,8,70,9],[71,8,71,9],[64,8,64,9],[112,8,112,9],[112,10,112,11],[112,12,112,13],[110,8,110,9],[110,10,110,11],[110,12,110,13],[111,8,111,9],[111,10,111,11],[111,12,111,13],[74,10,76,10],[142,0,143,0],[142,5,143,5],[142,6,143,6],[106,14,106,16],[108,8,108,9],[108,10,108,11],[108,12,108,13],[109,8,109,9],[109,10,109,11],[109,12,109,13],[106,0,107,0],[107,8,107,9],[107,10,107,11],[107,12,107,13],[106,8,106,13],[106,5,106,7],[122,5,122,6],[116,8,116,9],[117,8,117,9],[118,8,118,9],[119,8,119,9],[120,8,120,9],[121,8,121,9],[122,8,122,9]]}
[]
[{"$f":"\"Client: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Client: "}]
[]
["Age structure of trade accounts receivables   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hodnoty pre graf"]
[null,null,null,null,null,null,null,null,null,null,"(EUR 000)"]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Podiel",{"$f":"#REF!","v":{"$error":"#REF!"}},"Podiel",{"$f":"'List of required documents'!C61","v":"2011-12-31"},null,"Share",{"$f":"'List of required documents'!E61","v":"2012-03-31"},null,"Share",null,null,null,null,null,null,null,null,{"$f":"F6","v":"2011-12-31"},{"$f":"I6","v":"2012-03-31"}]
["Trade acc. receiv. brutto, from that:",null,{"$f":"IF(B$7=0,\"\",B7/B$7)","v":""},null,{"$f":"IF(D$7=0,\"\",D7/D$7)","v":""},null,null,{"$f":"IF(F$7=0,\"\",F7/F$7)","v":""},null,null,{"$f":"IF(I$7=0,\"\",I7/I$7)","v":""},null,null,null,null,null,null,null,null,{"$f":"F7","v":0},{"$f":"J7","v":0}]
[" - in due",{"$f":"IF(B7=0,\"\",B7-SUM(B10:B14))","v":""},{"$f":"IF(B$7=0,\"\",B8/B$7)","v":""},{"$f":"IF(D7=0,\"\",D7-SUM(D10:D14))","v":""},{"$f":"IF(D$7=0,\"\",D8/D$7)","v":""},{"$f":"IF(F7=0,\"\",F7-SUM(F10:F14))","v":""},null,{"$f":"IF(F$7=0,\"\",F8/F$7)","v":""},{"$f":"IF(I7=0,\"\",I7-SUM(I10:I14))","v":""},null,{"$f":"IF(I$7=0,\"\",I8/I$7)","v":""},null,null,null,null,null,null,null,null,{"$f":"F8","v":""},{"$f":"I8","v":""}]
[" - Overdue total, from that:",{"$f":"IF(SUM(B10:B14)=0,\"\",SUM(B10:B14))","v":""},{"$f":"IF(SUM(B10:B14)=0,\"\",B9/B$7)","v":""},{"$f":"IF(SUM(D10:D14)=0,\"\",SUM(D10:D14))","v":""},{"$f":"IF(SUM(D10:D14)=0,\"\",D9/D$7)","v":""},{"$f":"IF(SUM(F10:F14)=0,\"\",SUM(F10:F14))","v":""},null,{"$f":"IF(SUM(F10:F14)=0,\"\",F9/F$7)","v":""},{"$f":"IF(SUM(I10:I14)=0,\"\",SUM(I10:I14))","v":""},null,{"$f":"IF(SUM(I10:I14)=0,\"\",I9/I$7)","v":""}]
["    - till 30 days after maturity",null,{"$f":"IF(B$7=0,\"\",B10/B$7)","v":""},null,{"$f":"IF(D$7=0,\"\",D10/D$7)","v":""},null,null,{"$f":"IF(F$7=0,\"\",F10/F$7)","v":""},null,null,{"$f":"IF(I$7=0,\"\",I10/I$7)","v":""},null,null,null,null,null,null,null,null,{"$f":"F10","v":0},{"$f":"J10","v":0}]
["    - from 31till 90 days after maturity",null,"",null,"",null,null,"",null,null,"",null,null,null,null,null,null,null,null,0,{"$f":"J11","v":0}]
["    - from 91 till 180 days after maturity",null,"",null,"",null,null,"",null,null,"",null,null,null,null,null,null,null,null,0,{"$f":"J12","v":0}]
["    - from 181 till 360 days after maturity",null,"",null,"",null,null,"",null,null,"",null,null,null,null,null,null,null,null,0,{"$f":"J13","v":0}]
["    - over 360 days after maturity",null,"",null,"",null,null,"",null,null,"",null,null,null,null,null,null,null,null,0,{"$f":"J14","v":0}]
["Created of adjustments 391",null,"",null,"",null,null,"",null,null,"",null,null,null,null,null,null,null,null,0]
["Acc. receivables netto",{"$f":"IF(B7-B15=0,\"\",B7-B15)","v":""},"",{"$f":"IF(D7-D15=0,\"\",D7-D15)","v":""},"",{"$f":"IF(F7-F15=0,\"\",F7-F15)","v":""},null,"",{"$f":"IF(I7-I15=0,\"\",I7-I15)","v":""},null,""]
["Bad acc. receivables brutto",null,"",null,"",null,null,"",null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Do 30 dní po LS",{"$f":"B36*B10","v":0},null,{"$f":"D36*D10","v":0},null,{"$f":"F36*F10","v":0},null,null,null,{"$f":"J36*J10","v":0}]
["Do 90 dní po LS",{"$f":"B37*B11","v":0},null,{"$f":"D37*D11","v":0},null,{"$f":"F37*F11","v":0},null,null,null,{"$f":"J37*J11","v":0}]
["Do 180 dní po LS",{"$f":"B38*B12","v":0},null,{"$f":"D38*D12","v":0},null,{"$f":"F38*F12","v":0},null,null,null,{"$f":"J38*J12","v":0}]
["Do 360 dní po LS",{"$f":"B39*B13","v":0},null,{"$f":"D39*D13","v":0},null,{"$f":"F39*F13","v":0},null,null,null,{"$f":"J39*J13","v":0}]
["Nad 360 dní po LS",{"$f":"B40*B14","v":0},null,{"$f":"D40*D14","v":0},null,{"$f":"F40*F14","v":0},null,null,null,{"$f":"J40*J14","v":0}]
["Paušálne OP celkom",{"$f":"SUM(B45:B50)","v":0},null,{"$f":"SUM(D45:D50)","v":0},null,{"$f":"SUM(F45:F50)","v":0},null,null,null,{"$f":"SUM(J45:J50)","v":0}]
["Vytvorené opravné položky",{"$f":"B15","v":0},null,{"$f":"D15","v":0},null,{"$f":"F15","v":0},null,null,null,{"$f":"J15","v":0}]
["Potreba dotvorenia OP",{"$f":"IF(B51<B52,0,IF(B51=0,\"\",B51-B52))","v":""},null,{"$f":"IF(D51<D52,0,IF(D51=0,\"\",D51-D52))","v":""},null,{"$f":"IF(F51<F52,0,IF(F51=0,\"\",F51-F52))","v":""},null,null,null,{"$f":"IF(J51<J52,0,IF(J51=0,\"\",J51-J52))","v":""}]
["Comment to solving of overdue receivables:"]
["Please, specify customers, amount of receivable, original maturity, solution and prediction of incoming"]
[]
[]
[]
[]
[]
[]
[]
["Age structure of trade accounts payables and liabilities toward state authorities"]
[null,null,null,null,null,null,null,null,null,null,"(EUR 000)",null,null,null,null,null,null,null,null,"Hodnoty pre graf"]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Podiel",{"$f":"#REF!","v":{"$error":"#REF!"}},"Podiel",{"$f":"'List of required documents'!C61","v":"2011-12-31"},null,"Share",{"$f":"'List of required documents'!E61","v":"2012-03-31"},null,"Share"]
["Trade accounts payables, from that:",null,{"$f":"IF(B$66=0,\"\",B66/B$66)","v":""},null,{"$f":"IF(D$66=0,\"\",D66/D$66)","v":""},null,null,{"$f":"IF(F$66=0,\"\",F66/F$66)","v":""},null,null,{"$f":"IF(I$66=0,\"\",I66/I$66)","v":""},null,null,null,null,null,null,null,null,{"$f":"F65","v":"2011-12-31"},{"$f":"I65","v":"2012-03-31"}]
[" - in due",{"$f":"IF(B66=0,\"\",B66-SUM(B69:B73))","v":""},{"$f":"IF(B$66=0,\"\",B67/B$66)","v":""},{"$f":"IF(D66=0,\"\",D66-SUM(D69:D73))","v":""},{"$f":"IF(D$66=0,\"\",D67/D$66)","v":""},{"$f":"IF(F66=0,\"\",F66-SUM(F69:F73))","v":""},null,{"$f":"IF(F$66=0,\"\",F67/F$66)","v":""},{"$f":"IF(I66=0,\"\",I66-SUM(I69:I73))","v":""},null,{"$f":"IF(I$66=0,\"\",I67/I$66)","v":""},null,null,null,null,null,null,null,null,{"$f":"F66","v":0},{"$f":"J66","v":0}]
[" - overdue total, from that:",{"$f":"IF(SUM(B69:B73)=0,\"\",SUM(B69:B73))","v":""},{"$f":"IF(SUM(B69:B73)=0,\"\",B68/B$66)","v":""},{"$f":"IF(SUM(D69:D73)=0,\"\",SUM(D69:D73))","v":""},{"$f":"IF(SUM(D69:D73)=0,\"\",D68/D$66)","v":""},{"$f":"IF(SUM(F69:F73)=0,\"\",SUM(F69:F73))","v":""},null,{"$f":"IF(SUM(F69:F73)=0,\"\",F68/F$66)","v":""},{"$f":"IF(SUM(I69:I73)=0,\"\",SUM(I69:I73))","v":""},null,{"$f":"IF(SUM(I69:I73)=0,\"\",I68/I$66)","v":""},null,null,null,null,null,null,null,null,{"$f":"F67","v":""},{"$f":"I67","v":""}]
["    - till 30 days after maturity",null,{"$f":"IF(B$66=0,\"\",B69/B$66)","v":""},null,{"$f":"IF(D$66=0,\"\",D69/D$66)","v":""},null,null,{"$f":"IF(F$66=0,\"\",F69/F$66)","v":""},null,null,{"$f":"IF(I$66=0,\"\",I69/I$66)","v":""}]
["    - from 31 till 90 after maturity",null,{"$f":"IF(B$66=0,\"\",B70/B$66)","v":""},null,{"$f":"IF(D$66=0,\"\",D70/D$66)","v":""},null,null,{"$f":"IF(F$66=0,\"\",F70/F$66)","v":""},null,null,{"$f":"IF(I$66=0,\"\",I70/I$66)","v":""},null,null,null,null,null,null,null,null,{"$f":"F69","v":0},{"$f":"J69","v":0}]
["    - from 91 till 180 days after maturity",null,{"$f":"IF(B$66=0,\"\",B71/B$66)","v":""},null,{"$f":"IF(D$66=0,\"\",D71/D$66)","v":""},null,null,{"$f":"IF(F$66=0,\"\",F71/F$66)","v":""},null,null,{"$f":"IF(I$66=0,\"\",I71/I$66)","v":""},null,null,null,null,null,null,null,null,{"$f":"F70","v":0},{"$f":"J70","v":0}]
["    - from 181 till 360 days after maturity",null,{"$f":"IF(B$66=0,\"\",B72/B$66)","v":""},null,{"$f":"IF(D$66=0,\"\",D72/D$66)","v":""},null,null,{"$f":"IF(F$66=0,\"\",F72/F$66)","v":""},null,null,{"$f":"IF(I$66=0,\"\",I72/I$66)","v":""},null,null,null,null,null,null,null,null,{"$f":"F71","v":0},{"$f":"J71","v":0}]
["    - over 360 days after maturity",null,{"$f":"IF(B$66=0,\"\",B73/B$66)","v":""},null,{"$f":"IF(D$66=0,\"\",D73/D$66)","v":""},null,null,{"$f":"IF(F$66=0,\"\",F73/F$66)","v":""},null,null,{"$f":"IF(I$66=0,\"\",I73/I$66)","v":""},null,null,null,null,null,null,null,null,{"$f":"F72","v":0},{"$f":"J72","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F73","v":0},{"$f":"J73","v":0}]
[null,null,null,null,null,"Stav záväzku",null,null,null,null,"Repayment schedule (yes/no)"]
["State authorithies liabilities, from that:",null,null,null,null,{"$f":"'List of required documents'!C61","v":"2011-12-31"},null,{"$f":"'List of required documents'!E61","v":"2012-03-31"}]
[null,null,null,null,null,"in due","overdue","in due",null,"overdue"]
["Tax office"]
["Social insurance company"]
["Health insurance companies"]
["Other (customs office, ...)"]
["Total",null,null,null,null,{"$f":"IF((SUM(F78:F81))=0,\" \",SUM(F78:F81))","v":" "},{"$f":"IF((SUM(G78:G81))=0,\" \",SUM(G78:G81))","v":" "},{"$f":"IF((SUM(H78:H81))=0,\" \",SUM(H78:H81))","v":" "},null,{"$f":"IF((SUM(J78:J81))=0,\" \",SUM(J78:J81))","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Comment to solving of overdue liabilities:"]
["Please, specify: suppliers, amount of liability, original maturity, solution and prediction of payment"]
[]
[]
[]
[]
[]
[]
[]
["Provisions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(EUR 000)"]
["Type of provision",null,null,null,null,{"$f":"'List of required documents'!B61","v":"2010-12-31"},null,null,{"$f":"'List of required documents'!C61","v":"2011-12-31"},null,null,null,null,null,{"$f":"'List of required documents'!E61","v":"2012-03-31"}]
[null,null,null,null,null,"outstanding","creation","reversal","outstanding",null,"creation",null,"reversal",null,"outstanding","creation","reversal"]
[]
[]
[]
[]
[]
[]
["Remnant stocks"]
[null,null,null,null,null,null,null,null,null,null,"(EUR 000)"]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Podiel",{"$f":"#REF!","v":{"$error":"#REF!"}},"Podiel",{"$f":"'List of required documents'!C61","v":"2011-12-31"},null,"Share",{"$f":"'List of required documents'!E61","v":"2012-03-31"},null,"Share"]
["Stock brutto total, from that:",null,{"$f":"IF(B$118=0,\"\",B118/B$118)","v":""},null,{"$f":"IF(D$118=0,\"\",D118/D$118)","v":""},null,null,{"$f":"IF(F$118=0,\"\",F118/F$118)","v":""},null,null,{"$f":"IF(I$118=0,\"\",I118/I$118)","v":""}]
["   - remnant stocks ",null,{"$f":"IF(B$118=0,\"\",B119/B$118)","v":""},null,{"$f":"IF(D$118=0,\"\",D119/D$118)","v":""},null,null,"",null,null,""]
["   - stock in warehouse over 1 year",null,null,null,null,null,null,"",null,null,""]
["   - stock in warehouse over 1/2 year",null,null,null,null,null,null,"",null,null,""]
["Created adjustments",null,{"$f":"IF(B$118=0,\"\",B122/B$118)","v":""},null,{"$f":"IF(D$118=0,\"\",D122/D$118)","v":""},null,null,"",null,null,""]
["Stocks netto total",{"$f":"IF(B118=0,\"\",B118-B122)","v":""},{"$f":"IF(B$118=0,\"\",B123/B$118)","v":""},{"$f":"IF(D118=0,\"\",D118-D122)","v":""},{"$f":"IF(D$118=0,\"\",D123/D$118)","v":""},{"$f":"IF(F118=0,\"\",F118-F122)","v":""},null,"",{"$f":"IF(I118=0,\"\",I118-I122)","v":""},null,""]
[]
["Lawsuits"]
[]
["Creditor",null,null,null,null,"Outstanding of liabilites","Lawsuit from","Reasons of arising of lawsuit, actual status, expected solution and expected duration + submit documents related to lawsuit "]
[]
[]
[]
[]
[]
["Execution"]
[]
["Creditor",null,null,null,null,"Amount of execution","Execution from ","Reasons of arising of execution, actual status, expected solution and expected duration + submit documents related to execution"]
[]
[]
[]
[]
[]
["Ongoing controls"]
[]
["Control authority",null,null,null,null,"Ongoing control (yes / no)","Expected ending date of  control"]
[]
["Tax office"]
["Customs office",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]

{"sheet":"Loans, liabilities, leasing JU","index":11,"n_rows":62,"n_cols":15,"rows_kept":62,"cut":false,"hidden":true,"merged":[[25,0,25,7],[8,11,8,12],[8,13,8,14],[0,3,0,9],[5,0,5,6],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,8,10]]}
[]
[{"$f":"\"Klient: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Klient: "}]
[]
["Prehľad úverov, pôžičiek od bankových i nebankových subjektov a leasingov"]
[]
[]
[]
["Číselné hodnoty (EUR 000), stavy zodpovedajúce stavom vykazovaným vo Výkaze o majetku a záväzkoch"]
["Veriteľ","Druh záväzku 1)","Účel ","Mena 2)","Max.limit","Splátka istiny rok 3)","Dátum splatnosti","Úroková sadzba [% p.a.]","Popis zabezpečenia (vrátane avalu zmenky)",{"$f":"'List of required documents'!B61","v":"2010-12-31"},null,{"$f":"'List of required documents'!C61","v":"2011-12-31"},null,{"$f":"'List of required documents'!E61","v":"2012-03-31"}]
[null,null,null,null,null,{"$f":"'List of required documents'!C61","v":"2011-12-31"},null,null,null,"zostatok celkom","z toho: CPLTD 4)","zostatok celkom","z toho: CPLTD 4)","zostatok celkom","z toho: CPLTD 4)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Spolu",null,null,null,null,{"$f":"IF(SUM(F11:F23)=0,\"\",SUM(F11:F23))","v":""},null,null,null,{"$f":"IF(SUM(J11:J23)=0,\"\",SUM(J11:J23))","v":""},"","","","",""]
[]
["1) - druh záväzku: napr. investičný úver,prevádzkový úver, KTK, leasing, DLD pôžička a pod."]
["2) - mena v ktorej je poskytnutý úver (pôžička, leasing), číselné údaje sú však v EUR 000"]
["3) - pri leasingových zmluvách uveďte hodnou istiny bez dohodnutých finančných platieb"]
["4) - CPLTD  je krátkodobá časť dlhodobého záväzku splatná do 1 roka"]
[]
["Prehľad podsúvahových záväzkov (bankové záruky, ručiteľské záväzky, vystavené alebo avalované zmenky)"]
["uveďte prosím veriteľa, druh záväzku, účel, dátum vzniku, pôvodnú výšku a dátum splatnosti"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["áno"]
["nie"]

{"sheet":"Loans, liabilities, leasing PU","index":12,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":true,"merged":[[5,5,5,7],[3,0,3,15],[6,10,6,11],[6,12,6,13],[6,14,6,15],[6,0,7,0],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,6,6]]}
[]
[{"$f":"\"Client: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Client: "}]
[]
["List of loans, borrowings from bank and nonbank entities and leasings"]
[]
["Numeric values (EUR 000), situation due to the balance sheet"]
["Creditor","Type of liability 1)","Purpose","Currency 2)","Max. limit","Year principal repayment and repayment related to interim period",null,"Tenor","Interest rate [% p.a.]","Description of collateral (including bill aval)",{"$f":"'List of required documents'!B61","v":"2010-12-31"},null,{"$f":"'List of required documents'!C61","v":"2011-12-31"},null,{"$f":"'List of required documents'!E61","v":"2012-03-31"},null,{"$f":"(\"Zmena od \"&TEXT(#REF!,\"dd.mm.yy\")&\" do \"&TEXT(#REF!,\"dd.mm.yy\"))","v":{"$error":"#REF!"}},{"$f":"(\"Zmena od \"&TEXT(#REF!,\"dd.mm.yy\")&\" do \"&TEXT(#REF!,\"dd.mm.yy\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"'List of required documents'!C61","v":"2011-12-31"},{"$f":"'List of required documents'!E61","v":"2012-03-31"},null,null,null,"outstanding","from that: CPLTD 4)","outstanding","from that: CPLTD 4)","outstanding","from that: CPLTD 4)",{"$f":"(M8-L8)","v":{"$error":"#VALUE!"}},{"$f":"(P8-M8)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,{"$f":"IF(SUM(F9:F19)=0,\"\",SUM(F9:F19))","v":""},"",null,null,null,{"$f":"IF(SUM(K9:K19)=0,\"\",SUM(K9:K19))","v":""},"",{"$f":"IF(SUM(M9:M19)=0,\"\",SUM(M9:M19))","v":""},{"$f":"IF(SUM(N9:N19)=0,\"\",SUM(N9:N19))","v":""},{"$f":"IF(SUM(O9:O19)=0,\"\",SUM(O9:O19))","v":""},{"$f":"IF(SUM(P9:P19)=0,\"\",SUM(P9:R19))","v":""},{"$f":"SUM(Q8:Q19)","v":{"$error":"#VALUE!"}},{"$f":"SUM(R8:R19)","v":{"$error":"#VALUE!"}}]
["1) - type of liability: for example investment loan, operating loan, overdraft, leasing, long term loan, etc."]
["2) - currency which is in the loan / leasing contract, but numeric data in EUR"]
["3) - leasing comtracts - principal without financial payments"]
["4) - CPLTD = current portion of long term debt"]
[]
["List of off-balance liabilities (bank quarantees, pledges, issued and accepted bills)"]
["(Specify please name of creditor, type of liability, purpose, date of formation, initial amount and tenor.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]

{"sheet":"Additional information","index":13,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"\"Client: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Client: "}]
[]
["Additional information *)"]
[]
["Comment to business"]
[]
[]
[]
[]
[]
["Comment to investment expenditure for the last year + plan for 1 year"]
[]
[]
[]
["Competitors, market situation, market share, market prediction"]
[]
[]
[]
[]
[]
["*) fill in the client or BM/SBM of SLSP on base of conversation with client",null,null,null,null,null,null,8]

{"sheet":"Owners management, shares PU ","index":14,"n_rows":74,"n_cols":10,"rows_kept":74,"cut":false,"hidden":true,"merged":[[0,1,0,6],[61,0,61,4],[6,4,6,9],[8,4,8,9],[9,4,9,9],[10,4,10,9],[50,4,51,4],[33,5,33,9],[34,5,34,9],[35,5,35,9],[47,0,47,9],[50,0,51,0],[50,2,51,2],[50,3,51,3],[50,5,51,5],[50,1,51,1],[50,6,51,6],[50,7,51,7],[50,8,51,8],[50,9,51,9],[29,5,29,9],[30,5,30,9],[31,5,31,9],[32,5,32,9],[28,5,28,9],[12,4,12,9],[13,4,13,9],[7,4,7,9],[11,4,11,9],[10,1,10,2],[12,1,12,2],[13,1,13,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[11,1,11,2],[34,1,34,2],[35,1,35,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2]]}
[]
[{"$f":"\"Client: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Client: "}]
[]
["Ownership structure"]
[]
["Structure to the date:",{"$f":"'List of required documents'!E61","v":"2012-03-31"}]
["Name of the owner","Share on register capital [%]",null,"Owner from"]
[]
[]
[]
[]
[]
[]
["Spolu",{"$f":"IF(SUM(B8:C13)=0,\"\",SUM(B8:C13))","v":""}]
[]
["Comment: "]
["(Specify please all changes of ownership structure in last 24 months including reason which lead to them.)"]
[]
[]
[]
[]
[]
[]
[]
[]
["Management"]
[]
["Structure to the date:",{"$f":"'List of required documents'!E61","v":"2012-03-31"}]
["Name","In company from",null,"Function","In function from","Referencies, achievements"]
[]
[]
[]
[]
[]
[]
[]
[]
["Comment:"]
["(Specify please all changes of mnagement structure in last 24 months including reason which lead to them.)"]
[]
[]
[]
[]
[]
[]
[]
[]
["Group of operational related persons *"]
[]
["Stav k dátumu:",{"$f":"'List of required documents'!E61","v":"2012-03-31"}]
["Name","subject of business","IČO","owners","Share on register capital (higher than 20%)","Revenues","Earnings before financial result and taxes","Earnings before taxes","Equity","Balance sum"]
[]
[]
[]
[]
[]
[]
[]
[]
["Total",null,null,null,{"$f":"IF(SUM(E53:E59)=0,\"\",SUM(E53:E59))","v":""},"","","","",""]
[]
["* 1) property (shares on register capital in other companies) 2) personal (participation of owners or managment in managment entities of other companies or shares on register capital of other companies) 3) economic (in case of third parties loans)"]
[]
["Comment:"]
["(Specify please all changes in group of operational related persons in last 24 months including reason which lead to them.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,9]

{"sheet":"A-Assets and liab. projections","index":15,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":true,"merged":[[3,0,3,5],[35,0,36,5],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,8,5]]}
[]
[{"$f":"\"Klient: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Klient: "}]
[]
["Projekcie vyplňte prosím v prípade investičného úveru (na bežný rok a ďalšie dva nasledujúce roky) a v prípade zákazkovej výroby (na 1 rok, príp. minimálne prehľad kontraktov zazmluvnenosti)"]
[]
["Projekcia Výkazu o majetku a záväzkoch"]
[]
["P.č.","Ukazovateľ","Posledné daňové obdobie","K 31.12. bežného roka","K 31.12 bežného roka +1","K 31.12. bežného roka +2"]
[]
[1,"MAJETOK CELKOM r.č. 2+3+4+5+6+7",{"$f":"C11+C12+C16+C17+C18+C21","v":0},{"$f":"D11+D12+D16+D17+D18+D21","v":0},{"$f":"E11+E12+E16+E17+E18+E21","v":0},{"$f":"F11+F12+F16+F17+F18+F21","v":0}]
[2,"Dlhodobý nehmotný majetok (Nehmotný IM)"]
[3,"Dlhodobý hmotný majetok (Hmotný IM), z toho:",{"$f":"SUM(C13:C15)","v":0},{"$f":"SUM(D13:D15)","v":0},{"$f":"SUM(E13:E15)","v":0},{"$f":"SUM(F13:F15)","v":0}]
[null,"a/ Pozemky a stavby"]
[null,"b/ Samostatné hnuteľné veci a súbory hnuteľných vecí (stroje, prístroje a zariadenia, dopravné prostriedky a inventár)"]
[null,"c/ Ostatný Dlhodobý hmotný majetok"]
[4,"Dlhodobý finančný majetok (Finančné investície)"]
[5,"Zásoby"]
[6,"Pohľadávky, z toho:",{"$f":"SUM(C19:C20)","v":0},{"$f":"SUM(D19:D20)","v":0},{"$f":"SUM(E19:E20)","v":0},{"$f":"SUM(F19:F20)","v":0}]
[null,"a/ Pohľadávky z obchodného styku"]
[null,"b/ Pohľadávky voči štátu"]
[7,"Krátkodobý finančný majetok"]
[8,"ZÁVAZKY CELKOM r.č. 9+10+11",{"$f":"C23+C24+C28","v":0},{"$f":"D23+D24+D28","v":0},{"$f":"E23+E24+E28","v":0},{"$f":"F23+F24+F28","v":0}]
[9,"Rezervy"]
[10,"Záväzky, z toho:",{"$f":"SUM(C25:C27)","v":0},{"$f":"SUM(D25:D27)","v":0},{"$f":"SUM(E25:E27)","v":0},{"$f":"SUM(F25:F27)","v":0}]
[null,"a/ Záväzky z obchodného styku"]
[null,"b/ Záväzky voči štátu"]
[null,"c/ Záväzky z leasingu"]
[11,"Úvery a pôžičky, z toho:",{"$f":"C29+C31+C33+C34","v":0},{"$f":"D29+D31+D33+D34","v":0},{"$f":"E29+E31+E33+E34","v":0},{"$f":"F29+F31+F33+F34","v":0}]
[null,"a/ Dlhodobé bankové úvery celkom, z toho:"]
[null,"         voči SLSP"]
[null,"b/ Krátkodobé bankové úvery celkom, z toho:"]
[null,"        voči SLSP"]
[null,"c/ Dlhodobé nebankové úvery a pôžičky"]
[null,"d/ Krátkodobé nebankové úvery a pôžičky"]
[12,"ROZDIEL MAJETKU A ZÁVAZKOV r.č. 1 - 8 ",{"$f":"C10-C22","v":0},{"$f":"D10-D22","v":0},{"$f":"E10-E22","v":0},{"$f":"F10-F22","v":0}]
[]
[]
[null,null,null,null,null,9]

{"sheet":"A-Income and expend. project.","index":16,"n_rows":122,"n_cols":6,"rows_kept":122,"cut":false,"hidden":true,"merged":[[5,4,6,4],[5,5,6,5],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,3,6,3]]}
[]
[{"$f":"\"Klient: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Klient: "}]
[]
["Projekcia Výkazu o príjmoch a výdavkoch"]
[]
["P.č.","Ukazovateľ","Posledné daňové obdobie","K 31.12. bežného roka","K 31.12 bežného roka +1","K 31.12. bežného roka +2"]
[]
[1,"PRÍJMY CELKOM r.č. 2+3+4",{"$f":"C9+C11+C11","v":0},{"$f":"D9+D11+D11","v":0},{"$f":"E9+E11+E11","v":0},{"$f":"F9+F11+F11","v":0}]
[2,"Príjmy z predaja tovaru"]
[3,"Príjmy z predaja vlastných výrobkov a služieb"]
[4,"Ostatné príjmy"]
[5,"VÝDAVKY CELKOM r.č. 6+7+8+9",{"$f":"SUM(C13:C16)","v":0},{"$f":"SUM(D13:D16)","v":0},{"$f":"SUM(E13:E16)","v":0},{"$f":"SUM(F13:F16)","v":0}]
[6,"Nákup materiálu"]
[7,"Nákup tovaru"]
[8,"Osobné náklady (mzdy + odvody do fondov)"]
[9,"Prevádzková réžia, z toho:",{"$f":"SUM(C17:C25)","v":0},{"$f":"SUM(D17:D25)","v":0},{"$f":"SUM(E17:E25)","v":0},{"$f":"SUM(F17:F25)","v":0}]
[null,"a/ Platené nájomné"]
[null,"b/ Opravy a udržiavanie"]
[null,"c/ Energia"]
[null,"d/ Služby priamo súvisiace s výrobou (subdodávky)"]
[null,"e/ Dane a poplatky"]
[null,"f/ Odpisy dlhodobého nehmotného a hmotného majetku"]
[null,"g/ Úroky z úverov a pôžičiek"]
[null,"h/ Uveďte ďalšie významné položky réžie"]
[null,"i/ Uveďte ďalšie významné položky réžie"]
[10,"ROZDIEL PRÍJMOV A VÝDAVKOV r.č. 1-5",{"$f":"C8-C12","v":0},{"$f":"D8-D12","v":0},{"$f":"E8-E12","v":0},{"$f":"F8-F12","v":0}]
[11,"Peňažný vklad vlastníka",null,0,0,0]
[12,"Výdavky na osobnú spotrebu"]
[13,"Daň z príjmov"]
[14,"Priemerný plánovaný počet zamestnancov"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Klient: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Klient: "}]

{"sheet":"A - Balance sheet projections","index":17,"n_rows":64,"n_cols":6,"rows_kept":64,"cut":false,"hidden":true,"merged":[[3,0,3,5],[7,5,8,5],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4]]}
[]
[{"$f":"\"Client: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Client: "}]
[]
["Fill in in case of investment loan (for current year and next two years) and custom manufacturing (for one next yera alternatively min list of future contracts)."]
[]
["Projections of balance sheet"]
[]
["No.","Indicator","Last tax period","as of 31.12. of current year","as of 31.12. of current year + 1","as of 31.12. of current year + 2"]
[]
[1,"Receivables related to unpaid register capital"]
[2,"NON - CURRENT ASSETS line no. 3+4+5",{"$f":"C12+C13+C18","v":0},{"$f":"D12+D13+D18","v":0},{"$f":"E12+E13+E18","v":0},{"$f":"F12+F13+F18","v":0}]
[3,"Non-current intangible assets"]
[4,"LT tangible assets, from that:",{"$f":"SUM(C14:C17)","v":0},{"$f":"SUM(D14:D17)","v":0},{"$f":"SUM(E14:E17)","v":0},{"$f":"SUM(F14:F17)","v":0}]
[null,"a/ Land"]
[null,"b/ Buildings"]
[null,"c/ Individual movable assets and sets of movable"]
[null,"d/ Other LT tangible assets"]
[5,"Non-current financial assets, from that:",{"$f":"SUM(C19:C20)","v":0},{"$f":"SUM(D19:D20)","v":0},{"$f":"SUM(E19:E20)","v":0},{"$f":"SUM(F19:F20)","v":0}]
[null,"a/ Financial investments"]
[null,"b/ Loans"]
[6,"CURRENT ASSETS line no. 7+8+9+10+11+12+13+14",{"$f":"SUM(C22:C29)","v":0},{"$f":"SUM(D22:D29)","v":0},{"$f":"SUM(E22:E29)","v":0},{"$f":"SUM(F22:F29)","v":0}]
[7,"Inventory total"]
[8,"LT loans given to controlling entity (parent company)                                 "]
[9,"Other LT receivables"]
[10,"ST account receivables"]
[11,"ST loans given to controlling entity (parent company)                                 "]
[12,"Other ST receivables "]
[13,"ST receivables to state authority"]
[14,"Financial accounts"]
[15,"Accruals/deferrals"]
[16,"TOTAL assets netto line no. 1+2+6+15",{"$f":"C10+C11+C21+C30","v":0},{"$f":"D10+D11+D21+D30","v":0},{"$f":"E10+E11+E21+E30","v":0},{"$f":"F10+F11+F21+F30","v":0}]
[17,"EQUITY line no.18+19+20+21+22",{"$f":"C33+C34+C35+C36+C37","v":0},{"$f":"D33+D34+D35+D36+D37","v":0},{"$f":"E33+E34+E35+E36+E37","v":0},{"$f":"F33+F34+F35+F36+F37","v":0}]
[18,"Registered capital"]
[19,"Capital funds"]
[20,"Funds created from profit"]
[21,"Net profit/loss from previous years"]
[22,"Net profit/loss for the accounting period",{"$f":"'B - Profit and loss projections'!C37","v":0},{"$f":"'B - Profit and loss projections'!D37","v":0},{"$f":"'B - Profit and loss projections'!E37","v":0},{"$f":"'B - Profit and loss projections'!F37","v":0}]
[23,"LIABILITIES line no.24+25+26+27+28+29+30+31+32+33+34+35",{"$f":"C39+C40+C41+C42+C44+C45+C46+C47+C48+C49+C50+C51","v":0},{"$f":"D39+D40+D41+D42+D44+D45+D46+D47+D48+D49+D50+D51","v":0},{"$f":"E39+E40+E41+E42+E44+E45+E46+E47+E48+E49+E50+E51","v":0},{"$f":"F39+F40+F41+F42+F44+F45+F46+F47+F48+F49+F50+F51","v":0}]
[24,"LT reserves"]
[25,"ST reserves"]
[26,"LT loans received from controlling entity (parent company)                                 "]
[27,"Leasing liabilities:"]
[null,"from that ST part of leasing liabilities"]
[28,"Other LT liabilities"]
[29,"ST accounts payables"]
[30,"ST loans received from controlling entity (parent company)                                 "]
[31,"Liabilities to owners from received loans"]
[32,"Liabilities to owners from undistributed profit"]
[33,"Others ST liabilities "]
[34,"ST liabilities to state authority"]
[35,"Bank loans and financial assistance, from that:",{"$f":"C52+C55+C57","v":0},{"$f":"D52+D55+D57","v":0},{"$f":"E52+E55+E57","v":0},{"$f":"F52+F55+F57","v":0}]
[null,"a/ LT bank loans total, from that:"]
[null,"     SLSP"]
[null,"     ST part of LT loans"]
[null,"b/ ST bank loans total, from that:"]
[null,"     SLSP"]
[null,"c/ ST financial assistance"]
[36,"Accruals/Deferrals :"]
[null,"from that dotations for purchase of LT property"]
[37,"TOTAL EQUITY AND LIABILITY line no. 17+23+36",{"$f":"C32+C38+C58","v":0},{"$f":"D32+D38+D58","v":0},{"$f":"E32+E38+E58","v":0},{"$f":"F32+F38+F58","v":0}]
[38,"Zero control: Assets - Liabilities",{"$f":"C31-C60","v":0},{"$f":"D31-D60","v":0},{"$f":"E31-E60","v":0},{"$f":"F31-F60","v":0}]
[]
[39,"Plan amount of dividends"]
[40,"Subordinated liabilities in base of subordination bank contract"]

{"sheet":"B - Profit and loss projections","index":18,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":true,"merged":[[5,4,6,4],[5,5,6,5],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,3,6,3]]}
[]
[{"$f":"\"Client: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Client: "}]
[]
["Profit and loss statement projections"]
[]
["No.","Indicator","Last tax period","as of 31.12. of current year","as of 31.12. of current year + 1","as of 31.12. of current year + 2"]
[]
[1,"Revenues from sale of goods"]
[2,"Costs of sold goods"]
[3,"Revenues from sale of own products and services"]
[4,"Activation"]
[5,"Consumption of material and energy, from that:"]
[null,"a/ Energy"]
[6,"Services, from that:",{"$f":"SUM(C15:C19)","v":0},{"$f":"SUM(D15:D19)","v":0},{"$f":"SUM(E15:E19)","v":0},{"$f":"SUM(F15:F19)","v":0}]
[null,"a/ Rental expense"]
[null,"b/ Services directly related to production (subcontractor)"]
[null,"c/ Repair and maintenance (account 511)"]
[null,"d/ Fill in other relevant items"]
[null,"e/ Fill in other relevant items"]
[7,"Personal expense"]
[8,"Taxes and fees"]
[9,"Depreciation/amortization of tangible/intangible LT property"]
[10,"Revenues from sale of LT property"]
[11,"Revenues from sale of material"]
[12,"Carrying value of sold LT property"]
[13,"Carrying value of sold material"]
[14,"Other revenues from operational activities:"]
[null,"from that settlement od dotation for purchase of LT property"]
[15,"Other costs for operational activities "]
[16,"OPERATIONAL RESULT (EBIT) line no. 1-2+3+4-5-6-7-8-9+10+11-12-13+14-15",{"$f":"C8-C9+C10+C11-C12-C14-C20-C21-C22+C23-C25+C27-C29+C24-C26","v":0},{"$f":"D8-D9+D10+D11-D12-D14-D20-D21-D22+D23-D25+D27-D29+D24-D26","v":0},{"$f":"E8-E9+E10+E11-E12-E14-E20-E21-E22+E23-E25+E27-E29+E24-E26","v":0},{"$f":"F8-F9+F10+F11-F12-F14-F20-F21-F22+F23-F25+F27-F29+F24-F26","v":0}]
[17,"Interest income"]
[18,"Interest expense"]
[19,"Other income from financial activities "]
[20,"Other expense from financial activities"]
[21,"FINANCIAL RESULT line no. 17-18+19-20",{"$f":"C31-C32+C33-C34","v":0},{"$f":"D31-D32+D33-D34","v":0},{"$f":"E31-E32+E33-E34","v":0},{"$f":"F31-F32+F33-F34","v":0}]
[22,"Tax from ordinary activities"]
[23,"FINANCIAL RESULT FROM ORDINARY ACTIVITIES line no. 16+/-21-22",{"$f":"C30+C35-C36","v":0},{"$f":"D30+D35-D36","v":0},{"$f":"E30+E35-E36","v":0},{"$f":"F30+F35-F36","v":0}]
[24,"Average planned number of employees"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,12]

{"sheet":"Verzia","index":19,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Verzia","3.1.0","Datum","2011-11-22","LastEdit","SBE"]

{"sheet":"Preliminary interest-FACTORING","index":20,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[28,6,28,9],[28,3,28,5],[5,0,6,0],[5,1,5,2],[5,3,5,4],[7,0,8,0],[7,1,7,2],[7,3,7,4],[9,0,10,0],[9,1,9,2],[9,3,9,4],[11,0,12,0],[11,1,11,2],[11,3,11,4],[17,0,18,0],[17,1,17,2],[17,3,17,4],[13,0,14,0],[13,1,13,2],[13,3,13,4],[15,0,16,0],[15,1,15,2],[15,3,15,4],[19,0,20,0],[19,1,19,2],[19,3,19,4],[21,0,22,0],[21,1,21,2],[21,3,21,4],[23,0,24,0],[23,1,23,2],[23,3,23,4],[25,0,26,0],[25,1,25,2],[25,3,25,4],[29,3,29,5],[30,3,30,5],[31,3,31,5],[29,6,29,9],[30,6,30,9],[31,6,31,9]]}
[]
[{"$f":"\"Client: \"&IF('Base data'!$B$7=0,\"\",'Base data'!$B$7)","v":"Client: "}]
[]
["Preliminary interest in factoring"]
[]
["No.","Name of customer",null,"Adresa",null,"country","IČO","delivery terms","currency ","cooperation from"]
[null,"revenues for last tax period","planed revenues for current year","thereof, realized","maturity of invoices","real maturity","number of invoices in month","average month value of invoices","max value of invoices in month","reguired factoring limit \ncurrency / maturity"]
["1.",null,null,null,null," "]
[]
["2."]
[]
["3.",null,null,null,null," "]
[]
["4.",null,null,null,null," "]
[]
["5.",null,null,null,null," "]
[]
["6.",null,null,null,null," "]
[]
["7.",null,null,null,null," "]
[]
["8.",null,null,null,null," "]
[]
["9.",null,null,null,null," "]
[]
["10.",null,null,null,null," "]
[]
[]
["Additional information",null,null,"yes / no",null,null,"notes"]
["Client of SLSP, a.s."]
["Registered pledge over receivables in NCR"]
["Cooperation with other factoring company"]