{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Programi","Izjava","Investicije","EU projekti","Obrtna sredstva","Restrukturiranje","Prihodi","Prihodi (plan)","Kupci","Dobavljaci","Zalihe","Krediti","Ostale obveze","VIKR"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":14,"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":"Programi","index":0,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[18,8,18,12],[26,8,27,13],[39,8,40,13],[52,8,53,13],[44,8,44,13],[4,1,4,6],[17,1,17,6],[13,8,14,13],[5,8,5,13],[6,8,6,13],[30,1,30,6],[59,8,59,12],[60,8,60,12],[31,8,31,12],[57,8,57,12],[58,8,58,12],[63,8,63,12],[62,8,62,12],[61,8,61,12],[64,8,65,13],[43,1,43,6],[56,1,56,6]]}
[]
[]
[]
[null,"Vrsta i popis programa:",null,null,null,null,null,"Ovisno o vrsti programa, popunjavaju se tablice:"]
[null,"Investicijski kredit",null,null,null,null,null,"Klik na ikonu za početak"]
[null,null,"• Energetska obnova zgrada",null,null,null,null,null,"Podaci o ulaganju - Investicijski kredit"]
[null,null,"• Gospodarstvo",null,null,null,null,null,"Struktura redovnih prihoda"]
[null,null,"• Infrastruktura",null,null,null,null,null,"Struktura redovnih prihoda (plan)"]
[null,null,"• Malo i srednje poduzetništvo",null,null,null,null,null,"Potraživanja od kupca"]
[null,null,"• Nova proizvodnja",null,null,null,null,null,"Obveze prema dobavljačima"]
[null,null,"• Početnici",null,null,null,null,null,"Pregled vrsta, stanja i starosti zaliha"]
[null,null,"• Poduzetništvo mladih",null,null,null,null,null,"Pregled kreditne zaduženosti"]
[null,null,"• Pronalasci",null,null,null,null,null,"Ostale obveze"]
[null,null,"• Turizam",null,null,null,null,null,"VIKR - obrazac za utvrđivanje usklađenosti devizne pozicije klijenta (za kredite iznad 1,5 milijuna kn uz valutnu klauzulu)"]
[null,null,"• Zaštita okoliša"]
[null,null,"• Žene poduzetnice"]
[]
[null,"Obrtna sredstva",null,null,null,null,null,"Klik na ikonu za početak"]
[null,null,"• Priprema izvoza",null,null,null,null,null,"Podaci o ulaganju - Obrtna sredstva"]
[null,null,"• Likvidnost",null,null,null,null,null,"Struktura redovnih prihoda"]
[null,null,"• Izrada projektne i ostale investicijske",null,null,null,null,null,"Struktura redovnih prihoda (plan)"]
[null,null,"dokumentacije",null,null,null,null,null,"Potraživanja od kupca"]
[null,null,null,null,null,null,null,null,"Obveze prema dobavljačima"]
[null,null,null,null,null,null,null,null,"Pregled vrsta, stanja i starosti zaliha"]
[null,null,null,null,null,null,null,null,"Pregled kreditne zaduženosti"]
[null,null,null,null,null,null,null,null,"Ostale obveze"]
[null,null,null,null,null,null,null,null,"VIKR - obrazac za utvrđivanje usklađenosti devizne pozicije klijenta (za kredite iznad 1,5 milijuna kn uz valutnu klauzulu)"]
[]
[]
[]
[null,"EU projekti",null,null,null,null,null,"Klik na ikonu za početak"]
[null,null,"• EU projekti javnog sektora",null,null,null,null,null,"Podaci o ulaganju - EU projekti"]
[null,null,"• EU projekti privatnog sektora",null,null,null,null,null,"Struktura redovnih prihoda"]
[null,null,"• EU projekti ruralnog razvoja, ribarstva ",null,null,null,null,null,"Struktura redovnih prihoda (plan)"]
[null,null,"i vinske omotnice",null,null,null,null,null,"Potraživanja od kupca"]
[null,null,null,null,null,null,null,null,"Obveze prema dobavljačima"]
[null,null,null,null,null,null,null,null,"Pregled vrsta, stanja i starosti zaliha"]
[null,null,null,null,null,null,null,null,"Pregled kreditne zaduženosti"]
[null,null,null,null,null,null,null,null,"Ostale obveze"]
[null,null,null,null,null,null,null,null,"VIKR - obrazac za utvrđivanje usklađenosti devizne pozicije klijenta (za kredite iznad 1,5 milijuna kn uz valutnu klauzulu)"]
[]
[]
[]
[null,"Financijsko restrukturiranje",null,null,null,null,null,"Klik na ikonu za početak"]
[null,null,"• Restrukturiranje",null,null,null,null,null,"Podaci o ulaganju - Financijsko restrukturiranje"]
[null,null,null,null,null,null,null,null,"Struktura redovnih prihoda"]
[null,null,null,null,null,null,null,null,"Struktura redovnih prihoda (plan)"]
[null,null,null,null,null,null,null,null,"Potraživanja od kupca"]
[null,null,null,null,null,null,null,null,"Obveze prema dobavljačima"]
[null,null,null,null,null,null,null,null,"Pregled vrsta, stanja i starosti zaliha"]
[null,null,null,null,null,null,null,null,"Pregled kreditne zaduženosti"]
[null,null,null,null,null,null,null,null,"Ostale obveze"]
[null,null,null,null,null,null,null,null,"VIKR - obrazac za utvrđivanje usklađenosti devizne pozicije klijenta (za kredite iznad 1,5 milijuna kn uz valutnu klauzulu)"]
[]
[]
[]
[null,"Ostali programi",null,null,null,null,null,"Klik na ikonu za početak"]
[null,null,"• Kredit dobavljača",null,null,null,null,null,"Struktura redovnih prihoda"]
[null,null,"• Izvozne bankarske garancije",null,null,null,null,null,"Struktura redovnih prihoda (plan)"]
[null,null,"• Činidbene bankarske garancije",null,null,null,null,null,"Potraživanja od kupca"]
[null,null,null,null,null,null,null,null,"Obveze prema dobavljačima"]
[null,null,null,null,null,null,null,null,"Pregled vrsta, stanja i starosti zaliha"]
[null,null,null,null,null,null,null,null,"Pregled kreditne zaduženosti"]
[null,null,null,null,null,null,null,null,"Ostale obveze"]
[null,null,null,null,null,null,null,null,"VIKR - obrazac za utvrđivanje usklađenosti devizne pozicije klijenta (za kredite iznad 1,5 milijuna kn uz valutnu klauzulu)"]

{"sheet":"Izjava","index":1,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[26,0,26,3],[22,0,22,9],[13,0,13,4],[13,5,13,9],[15,0,15,9],[18,0,18,4],[18,5,18,9],[19,0,19,4],[19,5,19,9],[21,0,21,9],[9,0,9,9],[16,0,16,4],[16,5,16,9],[14,0,14,8],[17,0,17,4],[17,5,17,9],[2,3,2,6],[24,0,24,2],[33,0,33,9],[5,0,5,9],[4,0,4,9],[6,0,6,4],[6,5,6,9],[7,0,7,4],[7,5,7,9],[10,0,10,4],[10,5,10,9],[11,0,11,4],[11,5,11,9],[12,0,12,4],[12,5,12,9],[30,0,30,13]]}
[]
[]
[null,null,null,"Izjava klijenta"]
[]
["Naziv klijenta:"]
[]
["OIB:",null,null,null,null,"Datum izvještaja:"]
[]
[]
["Podaci o ovlaštenoj osobi"]
["Ime i prezime:",null,null,null,null,"Funkcija:"]
[]
["Telefon:",null,null,null,null,"E-mail:"]
[]
[]
["Podaci o osobi koja popunjava Tablice (ako je osoba različta od ovlaštene osobe)"]
["Ime i prezime:",null,null,null,null,"Funkcija:"]
[]
["Telefon:",null,null,null,null,"E-mail:"]
[]
[]
["Potvrđujemo da su svi podaci u tablicama točni i potpuni:"]
[" - Podaci o ulaganju,\n - Struktura redovnih prihoda\n - Struktura redovnih prihoda (plan),\n - Potraživanja od kupca,\n - Obveze prema dobavljačima,\n - Pregled vrsta, stanja i starosti zaliha,\n - Pregled kreditne zaduženosti,\n - Ostale obveze, te dodatno ako se dostavlja:\n - Obrazac za utvrđivanje devizne usklađenosti klijenta."]
[]
["Mjesto i datum",null,null,null,null,"Ime i prezime ovlaštene osobe i potpis"]
[]
[]
[]
[]
[]
["\n\n\n\n\n"]

{"sheet":"Investicije","index":2,"n_rows":46,"n_cols":18,"rows_kept":46,"cut":false,"hidden":false,"merged":[[25,17,26,27],[29,17,30,27],[31,17,32,27],[3,13,3,15],[6,14,6,15],[0,0,0,6],[8,9,8,10],[7,11,7,13],[8,11,8,12],[7,14,8,15],[13,1,13,4],[14,1,14,4],[3,2,3,6],[2,14,2,15],[10,1,10,4],[11,1,11,4],[9,7,9,8],[10,7,10,8],[11,7,11,8],[9,11,9,12],[10,11,10,12],[11,11,11,12],[7,0,8,0],[7,1,8,4],[7,5,8,6],[8,7,8,8],[7,7,7,10],[9,14,9,15],[20,1,20,4],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[12,1,12,4],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[17,9,17,10],[18,9,18,10],[19,9,19,10],[20,9,20,10],[12,7,12,8],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[16,14,16,15],[17,14,17,15],[18,14,18,15],[19,14,19,15],[20,14,20,15],[12,11,12,12],[13,11,13,12],[14,11,14,12],[15,11,15,12],[16,11,16,12],[14,14,14,15],[21,14,21,15],[22,14,22,15],[23,14,23,15],[9,1,9,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[9,5,9,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[9,9,9,10],[21,7,21,8],[21,9,21,10],[21,11,21,12],[17,11,17,12],[18,11,18,12],[19,11,19,12],[20,11,20,12],[10,14,10,15],[11,14,11,15],[12,14,12,15],[13,14,13,15],[15,14,15,15],[42,0,42,13],[25,0,26,2],[22,11,22,12],[22,9,22,10],[22,7,22,8],[23,7,23,8],[23,9,23,10],[23,11,23,12],[25,3,26,15],[29,3,30,15],[43,0,43,13],[42,14,42,15],[43,14,43,15],[44,14,44,15],[45,14,45,15],[29,0,30,2],[31,0,32,2],[37,14,37,15],[38,14,38,15],[39,14,39,15],[40,14,40,15],[41,14,41,15],[35,14,35,15],[36,14,36,15],[31,3,32,15],[44,0,44,13],[45,0,45,13],[35,0,35,13],[36,0,36,13],[37,0,37,13],[38,0,38,13],[39,0,39,13],[40,0,40,13],[41,0,41,13]]}
["Podaci o ulaganju - Investicijski kredit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tablice - 1"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Datum izvještaja:",null,{"$f":"Izjava!F8","v":"00:00:00"}]
["Naziv klijenta:",null,{"$f":"Izjava!A6","v":0},null,null,null,null,null,null,null,null,null,"OIB:",{"$f":"Izjava!A8","v":0}]
[]
["PDV uključen:"]
["Struktura investicije i izvori sredstva",null,null,null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Rb.","Namjena",null,null,null,"Ukupno",null,"Vlastita sredstva",null,null,null,"Kredit HBOR-a",null,null,"od kredita za refundaciju"]
[null,null,null,null,null,null,null,"Vlastiti izvori",null,"Ostali izvori",null,"Iznos",null,"%",null,null,null,"Namjena: navesti stavke ulaganja kao osnivačka ulaganja, zemljište, nasad, građevinski objekti, oprema i uređaji i sl."]
["I.","Osnovna sredstva ukupno",null,null,null,{"$f":"SUM(F11:G21)","v":0},null,{"$f":"SUM(H11:I21)","v":0},null,{"$f":"SUM(J11:K21)","v":0},null,{"$f":"SUM(L11:M21:M21)","v":0},null,{"$f":"L10/L23","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O11:P21)","v":0}]
[null,null,null,null,null,{"$f":"SUM(H11:M11)","v":0},null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,{"$f":"SUM(H12:M12)","v":0},null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,0,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,0,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,0,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,0,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,0,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,0,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,0,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,0,null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,0,null,null,null,null,null,null,null,"-"]
["II.","Obrtna sredstva ukupno",null,null,null,{"$f":"SUM(H22:M22)","v":0},null,null,null,null,null,null,null,{"$f":"L22/L23","v":{"$error":"#DIV/0!"}}]
["III.","Sveukupno (I. + II.)",null,null,null,{"$f":"SUM(F10,F22)","v":0},null,{"$f":"SUM(H10,H22)","v":0},null,{"$f":"SUM(J10,J22)","v":0},null,{"$f":"SUM(L10,L22)","v":0},null,1,{"$f":"SUM(O10,O22)","v":0}]
["III.","Sveukupno %",null,null,null,1,null,{"$f":"H23/F23","v":{"$error":"#DIV/0!"}},null,{"$f":"J23/F23","v":{"$error":"#DIV/0!"}},null,{"$f":"L23/F23","v":{"$error":"#DIV/0!"}},null,"-",{"$f":"O23/L23","v":{"$error":"#DIV/0!"}}]
[]
["Pojašnjenja",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pojašnjenja: navesti ako su eventualno navedeni iznosi s PDV-om i zašto (u slučajevima kada korisnik kredita obavlja isporuku dobara ili pruža usluge koje su po Zakonu o porezu na dodanu vrijednost izuzete od obračunavanja PDV-a, a u tu svrhu se odobrava kredit HBOR-a, kao i u slučajevima kada korisnik kredita ne ostvaruje prihod dovoljan za ulazak u sustav PDV-a, HBOR može razmotriti kreditiranje predračunske vrijednosti investicije s PDV-om). Navesti eventualno druge važne napomene."]
[]
[]
["Prethodno uložena sredstva"]
["Vlastita sredstva",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vlastita sredstva: navesti ako postoje stavke vlastitih sredstava u strukturi investicije koje su realizirane. Za svaku stavku navesti: naziv, osnovu realizacije (ugovoreno i/ili plaćeno), iznos i datum realizacije."]
[]
["Kredit HBOR-a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kredit HBOR-a: navesti ako postoje stavke kredita u strukturi investicije koje su plaćene iz vlastitih sredstava ili se planiraju platiti prije povlačenja sredstava kredita. Za svaku stavku navesti: naziv, iznos i datum (ili planirani datum) plaćanja. Refundaciju sredstava HBOR može prihvatiti iznimno za propisane vrste ulaganja i na propisani način (Odluka o općim uvjetima kreditnog poslovanja HBOR-a, točka 5.6. Način korištenja kredita - kod izravnog kreditiranja)."]
[]
[]
["Vrsta vlastitog udjela u investiciji (označiti)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Vlastiti izvori financiranja",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O37:P38)","v":0}]
["      Novčana sredstva investitora"]
["      Osnovna sredstva investitora pribavljena radi investicije"]
["Ostali izvori financiranja",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O40:P45)","v":0}]
["      EU sredstva"]
["      Novčana sredstva drugih pravnih i fizičkih osoba"]
["      Kreditna sredstva drugih financijskih institucija"]
["      Ulog drugih pravnih ili fizičkih osoba (u novcu ili stvarima)"]
["      Ostalo (niže navesti što):"]
[]
["Ukupno",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O36,O39)","v":0}]

{"sheet":"EU projekti","index":3,"n_rows":65,"n_cols":15,"rows_kept":65,"cut":false,"hidden":false,"merged":[[30,14,30,24],[17,14,17,24],[12,14,12,24],[44,14,45,25],[48,14,49,25],[50,14,51,25],[27,1,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[26,7,26,8],[20,11,20,12],[21,1,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[24,1,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[25,1,25,4],[26,1,26,4],[18,1,18,4],[18,7,18,8],[18,9,18,10],[18,11,18,12],[18,5,18,6],[20,1,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[19,1,19,4],[7,11,7,12],[8,11,8,12],[9,11,9,12],[10,11,10,12],[11,11,11,12],[12,11,12,12],[13,11,13,12],[15,9,15,10],[16,11,17,12],[16,9,17,10],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[28,1,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[29,1,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[21,11,21,12],[25,5,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,12],[26,9,26,10],[26,11,26,12],[23,1,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[26,5,26,6],[22,1,22,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[22,11,22,12],[56,11,56,12],[57,11,57,12],[58,11,58,12],[59,11,59,12],[44,0,45,2],[48,0,49,2],[50,0,51,2],[56,0,56,10],[57,0,57,10],[58,0,58,10],[59,0,59,10],[54,11,54,12],[55,11,55,12],[61,11,61,12],[62,11,62,12],[63,11,63,12],[64,11,64,12],[60,11,60,12],[60,0,60,10],[61,0,61,10],[62,0,62,10],[63,0,63,10],[64,0,64,10],[40,1,40,10],[41,1,41,10],[42,0,42,10],[54,0,54,10],[55,0,55,10],[39,11,39,12],[40,11,40,12],[41,11,41,12],[30,1,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,10],[35,1,35,12],[34,1,34,10],[36,1,36,10],[37,1,37,10],[38,1,38,10],[42,11,42,12],[34,11,34,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[30,11,30,12],[31,1,31,4],[2,11,2,12],[3,9,3,12],[44,3,45,12],[48,3,49,12],[50,3,51,12],[15,0,15,6],[7,1,7,10],[8,1,8,10],[9,1,9,10],[10,1,10,10],[11,1,11,10],[12,1,12,10],[13,1,13,10],[3,2,3,6],[15,11,15,12],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[16,0,17,0],[16,1,17,4],[16,5,17,6],[16,7,17,8],[39,1,39,10]]}
["Podaci o ulaganju - EU projekti",null,null,null,null,null,null,null,null,null,null,null,"Tablice - 1"]
[]
[null,null,null,null,null,null,null,null,"Datum izvještaja:",null,null,{"$f":"Izjava!F8","v":"00:00:00"}]
["Naziv klijenta:",null,{"$f":"Izjava!A6","v":0},null,null,null,null,null,"OIB:",{"$f":"Izjava!A8","v":0}]
[]
["PDV uključen:"]
["Kredit HBOR-a i prihvatljivi iznos granta za HBOR",null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["A.","Ukupni iznos projekta (prihvatljivi i neprihvatljivi troškovi)"]
["B.","Vlastita sredstva u investiciji (ne uključuje grant)"]
["C.","Prihvatljivi troškovi (sukladno prijavi ili odluci provedbenog tijela)"]
["D.","Neprihvatljivi troškovi"]
["E.","Predviđeni iznos granta"]
["F.","Prihvatljivi iznos granta za HBOR (max. Do 70%)",null,null,null,null,null,null,null,null,null,null,null,null,"Prihvatljivi iznos granta za HBOR: u slučaju jednokrtne isplate granta nije moguće prihvatiti izračun granta iz točke F."]
["G.","Potrebno financirati kreditom (A. - B. - F.)",null,null,null,null,null,null,null,null,null,{"$f":"L8-L9-L13","v":0}]
[]
["Struktura investicije",null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Rb.","Namjena",null,null,null,"Iznosi ulaganja",null,"Prihvatljivi troškovi",null,"Postotak potpore u %",null,"Iznos granta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Namjena: navesti stavke ulaganja kao osnivačka ulaganja, zemljište, nasad, građevinski objekti, oprema i uređaji i sl."]
["I.","Osnovna sredstva ukupno",null,null,null,{"$f":"SUM(F20:G30)","v":0},null,{"$f":"SUM(H20:I30)","v":0},null,{"$f":"+L19/H19","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(L20:M30)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+L20/H20","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"+L21/H21","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
["II.","Obrtna sredstva ukupno",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,null,"Obrtna sredstva ukupno: u izračun se ne uzimaju prihvatljivi izdaci koji su po svojoj naravi dio obrtnih sredstava."]
["III.","Sveukupno (I. + II.)",null,null,null,{"$f":"F19+F31","v":0},null,{"$f":"H19+H31","v":0},null,{"$f":"+L32/H32","v":{"$error":"#DIV/0!"}},null,{"$f":"L19+L31","v":0}]
[]
["Plan izvora financiranja",null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["1. ","Vlastita sredstva (niže navesti namjenu):"]
[]
["2.","Kredit HBOR-a",null,null,null,null,null,null,null,null,null,{"$f":"L38+L39","v":0}]
[null,"- troškovi projekta"]
[null,"- obrtna sredstva"]
["3.","Grant",null,null,null,null,null,null,null,null,null,{"$f":"L41+L42","v":0}]
[null,"- predujam"]
[null,"- rate"]
["Ukupno (1. + 2. + 3.)",null,null,null,null,null,null,null,null,null,null,{"$f":"L35+L37+L40","v":0}]
[]
["Pojašnjenja",null,null,null,null,null,null,null,null,null,null,null,null,null,"Pojašnjenja: navesti ako su eventualno navedeni iznosi s PDV-om i zašto (u slučajevima kada korisnik kredita obavlja isporuku dobara ili pruža usluge koje su po Zakonu o porezu na dodanu vrijednost izuzete od obračunavanja PDV-a, a u tu svrhu se odobrava kredit HBOR-a, kao i u slučajevima kada korisnik kredita ne ostvaruje prihod dovoljan za ulazak u sustav PDV-a, HBOR može razmotriti kreditiranje predračunske vrijednosti investicije s PDV-om). Navesti eventualno druge važne napomene."]
[]
[]
["Prethodno uložena sredstva"]
["Vlastita sredstva",null,null,null,null,null,null,null,null,null,null,null,null,null,"Vlastita sredstva: navesti ako postoje stavke vlastitih sredstava u strukturi investicije koje su realizirane. Za svaku stavku navesti: naziv, osnovu realizacije (ugovoreno i/ili plaćeno), iznos i datum realizacije."]
[]
["Kredit HBOR-a",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kredit HBOR-a: navesti ako postoje stavke kredita u strukturi investicije koje su plaćene iz vlastitih sredstava ili se planiraju platiti prije povlačenja sredstava kredita. Za svaku stavku navesti: naziv, iznos i datum (ili planirani datum) plaćanja. Refundaciju sredstava HBOR može prihvatiti iznimno za propisane vrste ulaganja i na propisani način (Odluka o općim uvjetima kreditnog poslovanja HBOR-a, točka 5.6. Način korištenja kredita - kod izravnog kreditiranja)."]
[]
[]
["Vrsta vlastitog udjela u investiciji (označiti)",null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Vlastiti izvori financiranja",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L56:M57)","v":0}]
["      Novčana sredstva investitora"]
["      Osnovna sredstva investitora pribavljena radi investicije"]
["Ostali izvori financiranja",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L59:M64)","v":0}]
["      EU sredstva"]
["      Novčana sredstva drugih pravnih i fizičkih osoba"]
["      Kreditna sredstva drugih financijskih institucija"]
["      Ulog drugih pravnih ili fizičkih osoba (u novcu ili stvarima)"]
["      Ostalo (niže navesti što):"]
[]
["Ukupno",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L55,L58)","v":0}]

{"sheet":"Obrtna sredstva","index":4,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,10,2,11],[3,2,3,6],[3,9,3,11],[6,0,6,9],[8,1,8,9],[8,10,8,11],[9,1,9,9],[9,10,9,11],[10,1,10,9],[10,10,10,11],[11,1,11,9],[11,10,11,11],[19,0,19,4],[12,1,12,9],[12,10,12,11],[13,1,13,9],[13,10,13,11],[14,1,14,9],[14,10,14,11],[15,1,15,9],[15,10,15,11],[16,1,16,9],[16,10,16,11],[17,10,17,11],[19,13,21,24],[21,10,21,11],[22,10,22,11],[23,10,23,11],[24,10,24,11]]}
["Podaci o ulaganju - Obrtna sredstva",null,null,null,null,null,null,null,null,null,null,"Tablice - 1"]
[]
[null,null,null,null,null,null,null,null,"Datum izvještaja:",null,"00:00:00"]
["Naziv klijenta:",null,0,null,null,null,null,null,"OIB:",0]
[]
["PDV uključen:"]
["Namjena kredita"]
["Rb.","Namjena",null,null,null,null,null,null,null,null,null,"Iznos u kn"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ukupno:",null,null,null,null,null,null,null,null,0]
[]
["Proračun potrebnih obrtnih sredstava",null,null,null,null,null,null,null,null,null,null,null,null,"Proračun potrebnih obrtnih sredstava: za podnositelje zahtjeva u djelatnostima proizvodnje i/ili izvoza. Vrijeme vezivanja obrtnih sredstava u proizvodnji (prosječan broj dana vezivanja) podrazumijeva prosječno vrijeme proizvodnje (na temelju zaliha materijala, zaliha nedovšrene proizvodnje i zaliha gotovih proizvoda), isporuke i naplate (na temelju potpisanih ugovora, narudžbi).\n"]
["(popunjava se za programe Kreditiranje proizvodnje i Priprema izvoza)",null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["1.","Planirana vrijednost prihoda od proizvodnje i/ili izvoza za tekuću godinu"]
["2.","PBDV - prosječan broj dana vezivanja"]
["3.","KO - Koeficijent obrtaja (KO=365/PBDV)",null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]
["4.","OBS - Potrebna obrtna sredstva (OBS=Planirana vrijednost prihoda/KO)",null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"}]

{"sheet":"Restrukturiranje","index":5,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[25,14,26,23],[22,11,22,12],[23,1,23,10],[23,11,23,12],[2,11,2,12],[8,1,8,10],[8,11,8,12],[6,6,6,10],[6,11,6,12],[3,2,3,7],[3,10,3,12],[9,1,9,10],[9,11,9,12],[10,1,10,10],[10,11,10,12],[15,1,15,10],[15,11,15,12],[11,1,11,10],[12,1,12,10],[13,1,13,10],[14,1,14,10],[11,11,11,12],[12,11,12,12],[13,11,13,12],[14,11,14,12],[24,1,24,10],[24,11,24,12],[26,0,26,5],[16,1,16,10],[16,11,16,12],[17,1,17,10],[17,11,17,12],[18,1,18,10],[18,11,18,12],[19,1,19,10],[19,11,19,12],[20,1,20,10],[20,11,20,12],[21,1,21,10],[21,11,21,12],[22,1,22,10],[27,0,31,12],[38,1,38,3],[38,4,38,5],[38,6,38,8],[38,9,38,10],[38,11,38,12],[37,1,37,3],[37,4,37,5],[37,6,37,8],[37,9,37,10],[37,11,37,12]]}
["Podaci o ulaganju - Restrukturiranje",null,null,null,null,null,null,null,null,null,null,null,"Tablice - 1"]
[]
[null,null,null,null,null,null,null,null,null,"Datum izvještaja:",null,{"$f":"Izjava!F8","v":"00:00:00"}]
["Naziv klijenta:",null,{"$f":"Izjava!A6","v":0},null,null,null,null,null,null,"OIB:",{"$f":"Izjava!A8","v":0}]
[]
["PDV uključen:"]
[null,null,null,null,null,null,"Stanje na dan (upisati datum):"]
["Rb.","Namjena",null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["I.","Kreditne obveze ukupno",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L10:M16)","v":0}]
[]
[]
[]
[]
[]
[]
[]
["II.","Obveze prema dobavljačima ukupno",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L18:M24)","v":0}]
[]
[]
[]
[]
[]
[]
[]
["III.","Sveukupno (I. + II.)",null,null,null,null,null,null,null,null,null,{"$f":"L9+L17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uvjeti odobrenih kredita i druge napomene: navesti datum ugovaranja kredita, ugovoreni iznos, namjenu, kamatnu stopu, rok otplate kredita."]
["Uvjeti odobrenih kredita i druge napomene"]
[]
[]
[]
[]
[]
["(popuniti za trgovačka društva i ostale poslovne subjekte u sustavu poreza na dobit)"]
["1."]
["2."]
["(popuniti za sve poslovne subjekte)"]
["3."]

{"sheet":"Prihodi","index":6,"n_rows":23,"n_cols":22,"rows_kept":23,"cut":false,"hidden":false,"merged":[[7,21,7,27],[16,21,16,27],[19,11,19,12],[19,14,19,15],[19,17,19,18],[18,17,18,18],[13,14,13,15],[13,17,13,18],[12,17,12,18],[9,17,9,18],[7,17,7,18],[8,17,8,18],[7,14,7,15],[18,0,18,4],[18,5,18,6],[18,8,18,9],[18,11,18,12],[18,14,18,15],[6,17,6,19],[15,17,15,19],[22,0,22,4],[22,5,22,6],[22,8,22,9],[22,11,22,12],[20,0,20,4],[20,5,20,6],[20,8,20,9],[20,11,20,12],[15,0,15,4],[13,0,13,4],[13,5,13,6],[13,8,13,9],[13,11,13,12],[20,14,20,15],[20,17,20,18],[16,17,16,18],[17,0,17,4],[17,5,17,6],[17,8,17,9],[17,11,17,12],[17,14,17,15],[17,17,17,18],[16,0,16,4],[16,5,16,6],[16,8,16,9],[16,11,16,12],[16,14,16,15],[19,0,19,4],[19,5,19,6],[19,8,19,9],[22,14,22,15],[22,17,22,18],[21,0,21,4],[21,5,21,6],[21,8,21,9],[21,11,21,12],[21,14,21,15],[21,17,21,18],[12,0,12,4],[12,5,12,6],[12,8,12,9],[12,11,12,12],[12,14,12,15],[11,8,11,9],[11,11,11,12],[11,14,11,15],[11,17,11,18],[10,0,10,4],[10,5,10,6],[10,8,10,9],[10,11,10,12],[10,14,10,15],[10,17,10,18],[11,0,11,4],[11,5,11,6],[8,0,8,4],[8,5,8,6],[8,8,8,9],[8,11,8,12],[8,14,8,15],[9,0,9,4],[9,5,9,6],[9,8,9,9],[9,11,9,12],[9,14,9,15],[6,0,6,5],[7,0,7,4],[7,5,7,6],[7,8,7,9],[7,11,7,12],[0,15,0,19],[4,0,4,1],[4,2,4,7],[1,18,1,19],[1,15,1,17],[1,5,1,14],[4,9,4,10],[4,11,4,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tablice - 1.1."]
[null,null,null,null,null,"Struktura redovnih prihoda",null,null,null,null,null,null,null,null,null,"Datum izvještaja:",null,null,{"$f":"Izjava!F8","v":"00:00:00"}]
[]
[]
["Naziv klijenta:",null,{"$f":"Izjava!A6","v":0},null,null,null,null,null,null,"OIB:",null,{"$f":"Izjava!A8","v":0}]
[]
["Struktura redovnih prihoda",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Vrsta prihoda",null,null,null,null,2013,null,"%",2014,null,"%",2015,null,"%",2016,null,"%",2017,null,"%",null,"2017: privremena izvješća najnovijeg datuma"]
[]
[]
[]
[]
[]
["Ukupno",null,null,null,null,{"$f":"SUM(F9:G13)","v":0},null,{"$f":"SUM(H9:H13)","v":0},{"$f":"SUM(I9:J13)","v":0},null,{"$f":"SUM(K9:K13)","v":0},{"$f":"SUM(L9:M13)","v":0},null,{"$f":"SUM(N9:N13)","v":0},{"$f":"SUM(O9:P13)","v":0},null,{"$f":"SUM(Q9:Q13)","v":0},{"$f":"SUM(R9:S13)","v":0},null,{"$f":"SUM(T9:T13)","v":0}]
[]
["Struktura izvanrednih prihoda",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Vrsta prihoda",null,null,null,null,2013,null,"%",2014,null,"%",2015,null,"%",2016,null,"%",2017,null,"%",null,"2017: privremena izvješća najnovijeg datuma"]
[]
[]
[]
[]
[]
["Ukupno",null,null,null,null,{"$f":"SUM(F18:G22)","v":0},null,{"$f":"SUM(H18:H22)","v":0},{"$f":"SUM(I18:J22)","v":0},null,{"$f":"SUM(K18:K22)","v":0},{"$f":"SUM(L18:M22)","v":0},null,{"$f":"SUM(N18:N22)","v":0},{"$f":"SUM(O18:P22)","v":0},null,{"$f":"SUM(Q18:Q22)","v":0},{"$f":"SUM(R18:S22)","v":0},null,{"$f":"SUM(T18:T22)","v":0}]

{"sheet":"Prihodi (plan)","index":7,"n_rows":23,"n_cols":20,"rows_kept":23,"cut":false,"hidden":false,"merged":[[18,17,18,18],[19,0,19,4],[19,5,19,6],[19,8,19,9],[19,11,19,12],[19,14,19,15],[19,17,19,18],[18,0,18,4],[18,5,18,6],[18,8,18,9],[18,11,18,12],[18,14,18,15],[15,17,15,19],[4,0,4,1],[4,2,4,7],[1,5,1,14],[15,0,15,4],[9,0,9,4],[9,11,9,12],[9,14,9,15],[11,0,11,4],[11,5,11,6],[11,8,11,9],[11,11,11,12],[11,14,11,15],[10,5,10,6],[10,8,10,9],[10,11,10,12],[0,15,0,19],[1,15,1,17],[1,18,1,19],[22,11,22,12],[22,14,22,15],[22,17,22,18],[21,17,21,18],[20,17,20,18],[16,17,16,18],[17,17,17,18],[16,14,16,15],[21,11,21,12],[21,14,21,15],[9,17,9,18],[13,14,13,15],[11,17,11,18],[20,0,20,4],[20,5,20,6],[20,8,20,9],[20,11,20,12],[20,14,20,15],[22,0,22,4],[22,5,22,6],[22,8,22,9],[21,0,21,4],[21,5,21,6],[21,8,21,9],[17,0,17,4],[17,5,17,6],[17,8,17,9],[17,11,17,12],[17,14,17,15],[16,0,16,4],[16,5,16,6],[16,8,16,9],[16,11,16,12],[10,17,10,18],[13,17,13,18],[12,0,12,4],[12,5,12,6],[12,8,12,9],[12,11,12,12],[12,14,12,15],[12,17,12,18],[13,0,13,4],[13,5,13,6],[13,8,13,9],[13,11,13,12],[10,14,10,15],[10,0,10,4],[6,0,6,5],[9,5,9,6],[9,8,9,9],[4,9,4,10],[4,11,4,13],[7,17,7,18],[8,0,8,4],[8,5,8,6],[8,8,8,9],[8,11,8,12],[8,14,8,15],[8,17,8,18],[7,0,7,4],[7,5,7,6],[7,8,7,9],[7,11,7,12],[7,14,7,15],[6,17,6,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tablice - 1.2."]
[null,null,null,null,null,"Struktura redovnih prihoda (plan)",null,null,null,null,null,null,null,null,null,"Datum izvještaja:",null,null,{"$f":"Izjava!F8","v":"00:00:00"}]
[]
[]
["Naziv klijenta:",null,{"$f":"Izjava!A6","v":0},null,null,null,null,null,null,"OIB:",null,{"$f":"Izjava!A8","v":0}]
[]
["Struktura redovnih prihoda (plan)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Vrsta prihoda",null,null,null,null,2017,null,"%",2018,null,"%",2019,null,"%",2020,null,"%",2021,null,"%"]
[]
[]
[]
[]
[]
["Ukupno",null,null,null,null,{"$f":"SUM(F9:G13)","v":0},null,{"$f":"SUM(H9:H13)","v":0},{"$f":"SUM(I9:J13)","v":0},null,{"$f":"SUM(K9:K13)","v":0},{"$f":"SUM(L9:M13)","v":0},null,{"$f":"SUM(N9:N13)","v":0},{"$f":"SUM(O9:P13)","v":0},null,{"$f":"SUM(Q9:Q13)","v":0},{"$f":"SUM(R9:S13)","v":0},null,{"$f":"SUM(T9:T13)","v":0}]
[]
["Struktura izvanrednih prihoda (plan)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Vrsta prihoda",null,null,null,null,2017,null,"%",2018,null,"%",2019,null,"%",2020,null,"%",2021,null,"%"]
[]
[]
[]
[]
[]
["Ukupno",null,null,null,null,{"$f":"SUM(F18:G22)","v":0},null,{"$f":"SUM(H18:H22)","v":0},{"$f":"SUM(I18:J22)","v":0},null,{"$f":"SUM(K18:K22)","v":0},{"$f":"SUM(L18:M22)","v":0},null,{"$f":"SUM(N18:N22)","v":0},{"$f":"SUM(O18:P22)","v":0},null,{"$f":"SUM(Q18:Q22)","v":0},{"$f":"SUM(R18:S22)","v":0},null,{"$f":"SUM(T18:T22)","v":0}]

{"sheet":"Kupci","index":8,"n_rows":38,"n_cols":19,"rows_kept":38,"cut":false,"hidden":false,"merged":[[8,18,10,30],[24,18,26,29],[0,12,0,16],[1,12,1,14],[1,15,1,16],[1,5,1,11],[4,0,4,1],[4,2,4,7],[34,11,34,12],[29,4,29,5],[24,13,24,16],[30,4,30,5],[28,0,28,3],[29,0,29,3],[30,0,30,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[26,0,26,3],[27,0,27,3],[24,0,25,3],[24,4,25,5],[24,6,25,6],[19,4,19,5],[36,7,36,8],[36,9,36,10],[36,11,36,12],[26,7,26,8],[26,9,26,10],[26,11,26,12],[27,7,27,8],[27,9,27,10],[27,11,27,12],[28,7,28,8],[28,9,28,10],[28,11,28,12],[29,7,29,8],[29,9,29,10],[29,11,29,12],[30,7,30,8],[30,9,30,10],[30,11,30,12],[37,7,37,8],[37,9,37,10],[37,11,37,12],[36,4,36,5],[37,4,37,5],[37,0,37,3],[32,7,32,8],[32,9,32,10],[32,11,32,12],[35,7,35,8],[35,9,35,10],[35,11,35,12],[33,7,33,8],[33,9,33,10],[33,11,33,12],[34,7,34,8],[34,9,34,10],[32,0,32,3],[33,0,33,3],[34,0,34,3],[35,0,35,3],[36,0,36,3],[32,4,32,5],[33,4,33,5],[20,4,20,5],[34,4,34,5],[35,4,35,5],[31,4,31,5],[31,0,31,3],[31,7,31,8],[31,9,31,10],[31,11,31,12],[8,0,9,3],[8,4,9,5],[15,0,15,3],[19,10,19,11],[20,10,20,11],[21,10,21,11],[8,6,9,6],[20,0,20,3],[15,4,15,5],[12,10,12,11],[13,10,13,11],[14,10,14,11],[15,10,15,11],[16,10,16,11],[16,0,16,3],[16,4,16,5],[23,14,23,16],[25,7,25,8],[24,7,24,12],[25,9,25,10],[25,11,25,12],[8,12,9,12],[10,0,10,3],[10,4,10,5],[11,0,11,3],[11,4,11,5],[10,10,10,11],[11,10,11,11],[21,0,21,3],[21,4,21,5],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[18,0,18,3],[18,4,18,5],[19,0,19,3],[12,0,12,3],[12,4,12,5],[13,0,13,3],[17,0,17,3],[17,4,17,5],[17,10,17,11],[13,4,13,5],[14,0,14,3],[14,4,14,5],[8,7,9,8],[18,10,18,11],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[7,10,7,12],[4,9,4,10],[4,11,4,13],[8,10,9,11],[15,7,15,8],[16,7,16,8],[17,7,17,8],[14,7,14,8],[8,9,9,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Tablice - 1.3."]
[null,null,null,null,null,"Potraživanja od kupca",null,null,null,null,null,null,"Datum izvještaja:",null,null,{"$f":"Izjava!F8","v":"00:00:00"}]
[]
[]
["Naziv klijenta:",null,{"$f":"Izjava!A6","v":0},null,null,null,null,null,null,"OIB:",null,{"$f":"Izjava!A8","v":0}]
[]
["PDV uključen:"]
["Promet s kupcima",null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Najveći kupci",null,null,null,"Promet u 2015. godini",null,"Udio u prometu %","Promet u 2016. godini",null,"Udio u prometu %","Promet od 01.01.2017. do dan izvještaja",null,"Udio u prometu %",null,null,null,null,null,"Najveći kupci: * Zvjezdicom se označuju kupci-povezane osobe\n\nUnose se samo kupci koji u godišnjem prometu sudjeluju s više od 5%, a ostali sumarno pod \"ostali\". \nU slučaju inozemnih kupaca navesti na kraju naziv države porijekla, npr. GER, USA, ITA,…"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ukupno",null,null,null,{"$f":"SUM(E11:F21)","v":0},null,{"$f":"SUM(G11:G21)","v":0},{"$f":"SUM(H11:I21)","v":0},null,{"$f":"SUM(J11:J21)","v":0},{"$f":"SUM(K11:L21)","v":0},null,{"$f":"SUM(M11:M21)","v":0}]
[]
["Potraživanja od kupca",null,null,null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Najveći kupci",null,null,null,"Promet u 2016. godini",null,"Udio u prometu %","Stanje potraživanja",null,null,null,null,null,"Starost dospjelih potraživanja u danima",null,null,null,null,"Najveći kupci: * Zvjezdicom se označuju kupci-povezane osobe\n\nUnose se samo kupci koji u godišnjem prometu sudjeluju s više od 5%, a ostali sumarno pod \"ostali\". \nU slučaju inozemnih kupaca navesti na kraju naziv države porijekla, npr. GER, USA, ITA,…"]
[null,null,null,null,null,null,null,"ukupno stanje na datum izvještaja",null,"nedospjela potraživanja",null,"dospjela potraživanja",null,"1 - 30","31 - 60","61 - 90","> 90"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ukupno",null,null,null,{"$f":"SUM(E27:F37)","v":0},null,{"$f":"SUM(G27:G37)","v":0},{"$f":"SUM(H27:I37)","v":0},null,{"$f":"SUM(J27:K37)","v":0},null,{"$f":"SUM(L27:M37)","v":0},null,{"$f":"AVERAGE(N27:N37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(O27:O37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P27:P37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(Q27:Q37)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Dobavljaci","index":9,"n_rows":38,"n_cols":19,"rows_kept":38,"cut":false,"hidden":false,"merged":[[8,18,10,26],[24,18,26,26],[7,10,7,12],[23,14,23,16],[37,0,37,3],[37,4,37,5],[37,7,37,8],[37,9,37,10],[37,11,37,12],[36,0,36,3],[36,4,36,5],[36,7,36,8],[36,9,36,10],[36,11,36,12],[35,0,35,3],[35,4,35,5],[35,7,35,8],[35,9,35,10],[35,11,35,12],[32,11,32,12],[31,0,31,3],[31,4,31,5],[21,4,21,5],[31,7,31,8],[31,9,31,10],[31,11,31,12],[32,0,32,3],[32,4,32,5],[34,11,34,12],[33,0,33,3],[33,4,33,5],[33,7,33,8],[33,9,33,10],[33,11,33,12],[34,0,34,3],[34,4,34,5],[34,7,34,8],[34,9,34,10],[32,7,32,8],[32,9,32,10],[24,0,25,3],[24,4,25,5],[29,7,29,8],[29,9,29,10],[29,11,29,12],[30,0,30,3],[30,4,30,5],[14,7,14,8],[30,7,30,8],[30,9,30,10],[24,6,25,6],[17,0,17,3],[17,4,17,5],[17,7,17,8],[17,10,17,11],[18,0,18,3],[18,4,18,5],[18,7,18,8],[18,10,18,11],[15,4,15,5],[15,7,15,8],[15,10,15,11],[16,0,16,3],[16,4,16,5],[28,0,28,3],[30,11,30,12],[29,0,29,3],[29,4,29,5],[27,0,27,3],[27,4,27,5],[27,7,27,8],[27,9,27,10],[26,0,26,3],[26,4,26,5],[26,7,26,8],[26,9,26,10],[28,4,28,5],[24,13,24,16],[25,7,25,8],[25,9,25,10],[25,11,25,12],[26,11,26,12],[27,11,27,12],[28,7,28,8],[28,9,28,10],[28,11,28,12],[24,7,24,12],[8,0,9,3],[8,4,9,5],[8,6,9,6],[8,7,9,8],[8,9,9,9],[8,10,9,11],[8,12,9,12],[10,0,10,3],[10,4,10,5],[10,7,10,8],[10,10,10,11],[21,0,21,3],[11,0,11,3],[11,4,11,5],[11,7,11,8],[11,10,11,11],[12,0,12,3],[12,4,12,5],[12,7,12,8],[12,10,12,11],[16,7,16,8],[16,10,16,11],[13,0,13,3],[13,4,13,5],[4,9,4,10],[4,11,4,13],[0,12,0,16],[1,5,1,11],[1,12,1,14],[1,15,1,16],[4,0,4,1],[4,2,4,7],[21,7,21,8],[21,10,21,11],[19,0,19,3],[19,4,19,5],[19,7,19,8],[19,10,19,11],[20,0,20,3],[20,4,20,5],[20,7,20,8],[20,10,20,11],[13,10,13,11],[14,0,14,3],[14,4,14,5],[14,10,14,11],[15,0,15,3],[13,7,13,8]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Tablice - 1.4."]
[null,null,null,null,null,"Obveze prema dobavljačima",null,null,null,null,null,null,"Datum izvještaja:",null,null,{"$f":"Izjava!F8","v":"00:00:00"}]
[]
[]
["Naziv klijenta:",null,{"$f":"Izjava!A6","v":0},null,null,null,null,null,null,"OIB:",null,{"$f":"Izjava!A8","v":0}]
[]
["PDV uključen:"]
["Promet s dobavljačima",null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Najveći dobavljači",null,null,null,"Promet u 2015. godini",null,"Udio u prometu %","Promet u 2016. godini",null,"Udio u prometu %","Promet od 01.01.2017. do dan izvještaja",null,"Udio u prometu %",null,null,null,null,null,"Najveći dobavljači: * Zvjezdicom se označuju dobavljači-povezane osobe\n\nUnose se samo dobavljači koji u godišnjem prometu sudjeluju s više od 5%, a ostali sumarno pod \"ostali\". U slučaju inozemnih dobavljača navesti na kraju naziv države porijekla, npr. GER, USA, ITA,…"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ukupno",null,null,null,{"$f":"SUM(E11:F21)","v":0},null,{"$f":"SUM(G11:G21)","v":0},{"$f":"SUM(H11:I21)","v":0},null,{"$f":"SUM(J11:J21)","v":0},{"$f":"SUM(K11:L21)","v":0},null,{"$f":"SUM(M11:M21)","v":0}]
[]
["Obveze prema dobavljačima",null,null,null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Najveći dobavljači",null,null,null,"Promet u 2016. godini",null,"Udio u prometu %","Stanje potraživanja",null,null,null,null,null,"Starost dospjelih obveza u danima",null,null,null,null,"Najveći dobavljači: * Zvjezdicom se označuju dobavljači-povezane osobe\n\nUnose se samo dobavljači koji u godišnjem prometu sudjeluju s više od 5%, a ostali sumarno pod \"ostali\". U slučaju inozemnih dobavljača navesti na kraju naziv države porijekla, npr. GER, USA, ITA,…"]
[null,null,null,null,null,null,null,"ukupno stanje na datum izvještaja ",null,"nedospjele obveze",null,"dospjele obveze",null,"1 - 30","31 - 60","61 - 90","> 90"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ukupno",null,null,null,{"$f":"SUM(E27:F37)","v":0},null,{"$f":"SUM(G27:G37)","v":0},{"$f":"SUM(H27:I37)","v":0},null,{"$f":"SUM(J27:K37)","v":0},null,{"$f":"SUM(L27:M37)","v":0},null,{"$f":"AVERAGE(N27:N37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(O27:O37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P27:P37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(Q27:Q37)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Zalihe","index":10,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[7,4,8,5],[11,4,11,5],[12,4,12,5],[17,4,17,5],[6,12,6,13],[18,4,18,5],[17,0,17,3],[18,0,18,3],[19,0,19,3],[10,0,10,3],[11,0,11,3],[13,4,13,5],[14,4,14,5],[15,4,15,5],[14,0,14,3],[12,0,12,3],[13,0,13,3],[16,0,16,3],[15,0,15,3],[16,4,16,5],[19,4,19,5],[23,8,24,10],[25,8,25,10],[17,12,17,13],[18,12,18,13],[20,12,20,13],[16,6,16,7],[12,12,12,13],[9,6,9,7],[10,6,10,7],[11,6,11,7],[12,6,12,7],[13,6,13,7],[17,6,17,7],[18,6,18,7],[20,6,20,7],[15,12,15,13],[16,12,16,13],[15,6,15,7],[19,6,19,7],[22,12,22,13],[35,6,35,7],[27,0,27,3],[28,0,28,3],[29,0,29,3],[30,0,30,3],[32,6,32,7],[33,6,33,7],[23,0,24,3],[25,0,25,3],[23,4,24,5],[25,4,25,5],[23,6,24,7],[25,6,25,7],[30,6,30,7],[31,6,31,7],[36,6,36,7],[36,0,36,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[30,4,30,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[34,4,34,5],[35,4,35,5],[36,4,36,5],[31,0,31,3],[32,0,32,3],[33,0,33,3],[34,0,34,3],[35,0,35,3],[26,0,26,3],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,6,29,7],[34,6,34,7],[36,8,36,10],[23,11,24,13],[25,11,25,13],[26,11,26,13],[27,11,27,13],[28,11,28,13],[29,11,29,13],[30,11,30,13],[31,11,31,13],[32,11,32,13],[33,11,33,13],[34,11,34,13],[35,11,35,13],[36,11,36,13],[31,8,31,10],[32,8,32,10],[33,8,33,10],[34,8,34,10],[35,8,35,10],[26,8,26,10],[27,8,27,10],[28,8,28,10],[29,8,29,10],[30,8,30,10],[4,8,4,9],[4,10,4,12],[0,10,0,13],[4,0,4,1],[4,2,4,6],[20,0,20,3],[20,4,20,5],[7,12,8,13],[9,4,9,5],[10,4,10,5],[7,0,8,3],[7,6,8,7],[7,8,7,11],[9,0,9,3],[13,12,13,13],[14,12,14,13],[14,6,14,7],[9,12,9,13],[10,12,10,13],[11,12,11,13],[19,12,19,13],[1,12,1,13],[1,9,1,11],[1,5,2,8]]}
[null,null,null,null,null,null,null,null,null,null,"Tablice - 1.5."]
[null,null,null,null,null,"Pregled vrsta, stanja i starosti zaliha",null,null,null,"Datum izvještaja:",null,null,{"$f":"Izjava!G8","v":"00:00:00"}]
[]
[]
["Naziv klijenta:",null,{"$f":"Izjava!A6","v":0},null,null,null,null,null,"OIB:",null,{"$f":"Izjava!A8","v":0}]
[]
["Pregled vrsta, stanja i starosti zaliha",null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Vrsta zaliha\n(glavne skupine)",null,null,null,"Stanje zaliha na 31.12.2016. godine",null,"Stanje zaliha na datum izvještaja",null,"Starost zaliha u danima",null,null,null,"Sadašnja tržišna vrijednost"]
[null,null,null,null,null,null,null,null,"1 - 90","91 - 180","181 - 360","> 360",null,null,null,"Vrsta zaliha: unose se samo zalihe koje u godišnjem prometu sudjeluju s više od 5%, a ostale sumarno pod \"ostale\"."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ukupno:",null,null,null,{"$f":"SUM(E10:F20)","v":0},null,{"$f":"SUM(G10:H20)","v":0},null,{"$f":"AVERAGE(I10:I20)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(J10:J20)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(K10:K20)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(L10:L20)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M10:N20)","v":0}]
[]
["Pregled potraživanja, ugovora i zaliha koja su pod zalogom",null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Potraživanje / Ugovor / Vrsta zaliha",null,null,null,"Vrijednost potraživanja / zaliha na dan izvještaja",null,"Iznos zaloga",null,"Nositelj zaloga",null,null,"Opis osnove za \nrealiziran zalog"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ukupno:",null,null,null,{"$f":"SUM(E26:F36)","v":0},null,{"$f":"SUM(G26:H36)","v":0}]

{"sheet":"Krediti","index":11,"n_rows":48,"n_cols":25,"rows_kept":48,"cut":false,"hidden":false,"merged":[[9,0,9,25],[18,0,18,25],[0,12,0,16],[47,22,47,23],[46,14,46,15],[46,16,46,17],[46,19,46,21],[46,22,46,23],[47,0,47,3],[47,4,47,5],[47,6,47,7],[47,8,47,9],[47,10,47,11],[47,12,47,13],[46,0,46,3],[46,4,46,5],[46,6,46,7],[46,8,46,9],[46,10,46,11],[46,12,46,13],[47,14,47,15],[47,16,47,17],[47,19,47,21],[44,22,44,23],[45,22,45,23],[44,0,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9],[44,10,44,11],[44,12,44,13],[44,14,44,15],[44,16,44,17],[44,19,44,21],[45,0,45,3],[45,4,45,5],[45,6,45,7],[45,8,45,9],[45,10,45,11],[45,12,45,13],[45,14,45,15],[45,16,45,17],[45,19,45,21],[37,16,37,17],[37,19,37,21],[37,22,37,23],[42,14,42,15],[42,16,42,17],[42,19,42,21],[42,22,42,23],[43,0,43,3],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,10,43,11],[43,12,43,13],[42,0,42,3],[42,4,42,5],[42,6,42,7],[42,8,42,9],[42,10,42,11],[42,12,42,13],[43,14,43,15],[43,16,43,17],[43,19,43,21],[43,22,43,23],[36,22,36,23],[36,0,36,3],[36,4,36,5],[36,6,36,7],[36,8,36,9],[36,10,36,11],[40,18,41,18],[40,19,41,21],[40,22,41,23],[40,0,41,3],[40,4,41,5],[40,6,41,7],[40,8,41,9],[40,10,41,11],[37,4,37,5],[37,6,37,7],[37,8,37,9],[37,10,37,11],[37,0,37,3],[40,12,41,13],[40,14,41,15],[40,16,41,17],[37,12,37,13],[37,14,37,15],[35,19,35,21],[33,0,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[33,10,33,11],[36,12,36,13],[36,14,36,15],[36,16,36,17],[36,19,36,21],[34,22,34,23],[35,0,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[35,10,35,11],[33,12,33,13],[33,14,33,15],[33,16,33,17],[33,19,33,21],[33,22,33,23],[34,0,34,3],[34,4,34,5],[34,6,34,7],[34,8,34,9],[34,10,34,11],[35,22,35,23],[34,12,34,13],[34,14,34,15],[34,16,34,17],[34,19,34,21],[35,12,35,13],[35,14,35,15],[35,16,35,17],[30,14,31,15],[30,16,31,17],[30,18,31,18],[30,19,31,21],[30,22,31,23],[32,0,32,3],[32,4,32,5],[32,6,32,7],[32,8,32,9],[32,10,32,11],[30,0,31,3],[30,4,31,5],[30,6,31,7],[30,8,31,9],[30,10,31,11],[30,12,31,13],[32,12,32,13],[32,14,32,15],[32,16,32,17],[32,19,32,21],[32,22,32,23],[27,22,27,23],[26,22,26,23],[27,0,27,3],[27,4,27,5],[27,6,27,7],[27,8,27,9],[27,10,27,11],[27,12,27,13],[27,14,27,15],[27,16,27,17],[27,19,27,21],[25,22,25,23],[26,0,26,3],[26,4,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[26,14,26,15],[26,16,26,17],[26,19,26,21],[25,0,25,3],[25,4,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[25,14,25,15],[25,16,25,17],[25,19,25,21],[23,22,23,23],[24,0,24,3],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[24,12,24,13],[24,14,24,15],[24,16,24,17],[24,19,24,21],[23,0,23,3],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[23,16,23,17],[23,19,23,21],[24,22,24,23],[20,22,20,23],[21,22,21,23],[22,0,22,3],[22,4,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[22,12,22,13],[22,14,22,15],[22,16,22,17],[22,19,22,21],[22,22,22,23],[21,0,21,3],[21,4,21,5],[21,6,21,7],[21,8,21,9],[21,10,21,11],[21,12,21,13],[21,14,21,15],[21,16,21,17],[21,19,21,21],[20,14,20,15],[20,16,20,17],[20,19,20,21],[16,22,16,23],[17,0,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,9],[17,10,17,11],[17,12,17,13],[17,14,17,15],[17,16,17,17],[17,19,17,21],[16,0,16,3],[16,4,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[16,14,16,15],[16,16,16,17],[16,19,16,21],[17,22,17,23],[14,22,14,23],[15,0,15,3],[15,4,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,12,15,13],[15,14,15,15],[15,16,15,17],[15,19,15,21],[15,22,15,23],[14,0,14,3],[14,4,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[14,12,14,13],[14,14,14,15],[14,16,14,17],[14,19,14,21],[7,10,8,11],[7,12,8,13],[7,14,8,15],[7,16,8,17],[7,18,8,18],[7,19,8,21],[19,0,19,3],[19,4,19,5],[19,6,19,7],[10,4,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11],[10,12,10,13],[10,14,10,15],[7,0,8,3],[13,0,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[13,12,13,13],[13,14,13,15],[13,16,13,17],[37,24,37,25],[17,24,17,25],[19,24,19,25],[20,24,20,25],[21,24,21,25],[22,24,22,25],[23,24,23,25],[24,24,24,25],[25,24,25,25],[11,22,11,23],[12,22,12,23],[13,19,13,21],[13,22,13,23],[12,0,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[12,12,12,13],[12,14,12,15],[12,16,12,17],[12,19,12,21],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[10,16,10,17],[10,19,10,21],[19,8,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,15],[19,16,19,17],[19,19,19,21],[0,21,0,25],[1,21,1,23],[1,24,1,25],[1,5,1,20],[6,24,6,25],[26,24,26,25],[6,0,6,3],[7,4,8,5],[7,6,8,7],[7,8,8,9],[10,22,10,23],[11,0,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,15],[11,16,11,17],[11,19,11,21],[10,0,10,3],[7,24,8,25],[10,24,10,25],[4,9,4,10],[4,11,4,13],[29,0,29,21],[29,24,29,25],[39,22,39,23],[39,0,39,18],[4,0,4,1],[4,2,4,7],[27,24,27,25],[30,24,31,25],[32,24,32,25],[33,24,33,25],[34,24,34,25],[35,24,35,25],[36,24,36,25],[11,24,11,25],[12,24,12,25],[13,24,13,25],[14,24,14,25],[15,24,15,25],[16,24,16,25],[7,22,8,23],[19,22,19,23],[20,0,20,3],[20,4,20,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tablice - 1.6."]
[null,null,null,null,null,"Pregled kreditne zaduženosti",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datum izvještaja:",null,null,{"$f":"Izjava!F8","v":"00:00:00"}]
[]
[]
["Naziv klijenta:",null,{"$f":"Izjava!A6","v":0},null,null,null,null,null,null,"OIB:",null,{"$f":"Izjava!A8","v":0}]
[]
["Pregled kreditne zaduženosti",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Kreditor/Vrsta produkta",null,null,null,"Završno stanje prethodne godine",null,"Stanje na datum izvještaja",null,"Datum odobrenja",null,"Odobreni iznos",null,"Početak otplate",null,"Krajnji datum dospijeća",null,"Način otplate",null,"Kamatna stopa","Instrumenti osiguranja/procijenjena vrijednost",null,null,"Otplata glavnice u prethodnoj godini",null,"Otplata glavnice u tekućoj godini"]
[]
["Kratkoročna zaduženost"]
[]
[]
[]
[]
[]
[]
[]
["Ukupno",null,null,null,{"$f":"SUM(E11:F17)","v":0},null,{"$f":"SUM(G11:H17)","v":0},null,null,null,{"$f":"SUM(K11:L17)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W11:X17)","v":0},null,{"$f":"SUM(Y11:Z17)","v":0}]
["Dugoročna zaduženost"]
[]
[]
[]
[]
[]
[]
[]
["Ukupno",null,null,null,{"$f":"SUM(E20:F26)","v":0},null,{"$f":"SUM(G20:H26)","v":0},null,null,null,{"$f":"SUM(K20:L26)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W20:X26)","v":0},null,{"$f":"SUM(Y20:Z26)","v":0}]
["Sveukupno",null,null,null,{"$f":"E18+E27","v":0},null,{"$f":"G18+G27","v":0},null,null,null,{"$f":"K18+K27","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W18+W27","v":0},null,{"$f":"Y18+Y27","v":0}]
[]
["Struktura obveza po zajmovima (od trgovačkih društva, fizičkih osoba i ostalo)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Zajmodavatelj/Namjena",null,null,null,"Završno stanje prethodne godine",null,"Stanje na datum izvještaja",null,"Datum odobrenja",null,"Odobreni iznos",null,"Početak otplate",null,"Krajnji datum dospijeća",null,"Način otplate",null,"Kamatna stopa","Instrumenti osiguranja/procijenjena vrijednost",null,null,"Otplata glavnice u prethodnoj godini",null,"Otplata glavnice u tekućoj godini"]
[]
[]
[]
[]
[]
[]
["Ukupno dugoročna zaduženost",null,null,null,{"$f":"SUM(E33:F37)","v":0},null,{"$f":"SUM(G33:H37)","v":0},null,null,null,{"$f":"SUM(K33:L37)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W33:X37)","v":0},null,{"$f":"SUM(Y33:Z37)","v":0}]
[]
["Potraživanja po danim zajmovima",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Zajmodavatelj/Namjena",null,null,null,"Završno stanje prethodne godine",null,"Stanje na datum izvještaja",null,"Datum odobrenja",null,"Odobreni iznos",null,"Početak otplate",null,"Krajnji datum dospijeća",null,"Način otplate",null,"Kamatna stopa","Instrumenti osiguranja/procijenjena vrijednost",null,null,"Otplata glavnice u tekućoj godini"]
[]
[]
[]
[]
[]
[]
["Ukupno dugoročna zaduženost",null,null,null,{"$f":"SUM(E43:F47)","v":0},null,{"$f":"SUM(G43:H47)","v":0},null,null,null,{"$f":"SUM(K43:L47)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W43:X47)","v":0}]

{"sheet":"Ostale obveze","index":12,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,16,25,17],[25,18,25,20],[25,0,25,3],[25,4,25,6],[25,7,25,9],[25,10,25,11],[25,12,25,13],[25,14,25,15],[23,16,23,17],[23,18,23,20],[24,0,24,3],[24,4,24,6],[24,7,24,9],[24,10,24,11],[24,12,24,13],[24,14,24,15],[24,16,24,17],[24,18,24,20],[23,0,23,3],[23,4,23,6],[23,7,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[21,16,21,17],[21,18,21,20],[22,0,22,3],[22,4,22,6],[22,7,22,9],[22,10,22,11],[22,12,22,13],[22,14,22,15],[22,16,22,17],[22,18,22,20],[21,0,21,3],[21,4,21,6],[21,7,21,9],[21,10,21,11],[21,12,21,13],[21,14,21,15],[18,16,19,17],[18,18,19,20],[20,0,20,3],[20,4,20,6],[20,7,20,9],[20,10,20,11],[20,12,20,13],[20,14,20,15],[20,16,20,17],[20,18,20,20],[18,0,19,3],[18,4,19,6],[18,7,19,9],[18,10,19,11],[18,12,19,13],[18,14,19,15],[14,16,14,17],[14,18,14,20],[15,0,15,3],[15,4,15,6],[15,7,15,9],[15,10,15,11],[15,12,15,13],[15,14,15,15],[15,16,15,17],[15,18,15,20],[14,0,14,3],[14,4,14,6],[14,7,14,9],[14,10,14,11],[14,12,14,13],[14,14,14,15],[12,16,12,17],[12,18,12,20],[13,0,13,3],[13,4,13,6],[13,7,13,9],[13,10,13,11],[13,12,13,13],[13,14,13,15],[13,16,13,17],[13,18,13,20],[12,0,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,13],[12,14,12,15],[10,16,10,17],[10,18,10,20],[11,0,11,3],[11,4,11,6],[11,7,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,15],[11,16,11,17],[11,18,11,20],[10,0,10,3],[10,4,10,6],[10,7,10,9],[10,10,10,11],[10,12,10,13],[10,14,10,15],[9,12,9,13],[9,14,9,15],[9,16,9,17],[9,18,9,20],[8,0,8,3],[8,4,8,6],[8,7,8,9],[8,10,8,11],[8,12,8,13],[8,14,8,15],[5,19,5,20],[17,19,17,20],[4,9,4,10],[4,11,4,13],[4,0,4,1],[4,2,4,7],[1,5,1,15],[0,16,0,20],[1,16,1,18],[1,19,1,20],[6,0,7,3],[6,4,7,6],[6,7,7,9],[6,10,7,11],[6,12,7,13],[6,14,7,15],[6,16,7,17],[6,18,7,20],[8,16,8,17],[8,18,8,20],[9,0,9,3],[9,4,9,6],[9,7,9,9],[9,10,9,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tablice - 1.7."]
[null,null,null,null,null,"Ostale obveze",null,null,null,null,null,null,null,null,null,null,"Datum izvještaja:",null,null,{"$f":"Izjava!F8","v":"00:00:00"}]
[]
[]
["Naziv klijenta:",null,{"$f":"Izjava!A6","v":0},null,null,null,null,null,null,"OIB:",null,{"$f":"Izjava!A8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Vrsta proizvoda",null,null,null,"Izdavatelj",null,null,"Korisnik",null,null,"Početni iznos",null,"Ostalo za naplatu",null,"Datum dospijeća",null,"Dospjele obveze",null,"Instrumenti osiguranja/procijenjena vrijednost"]
[]
[]
[]
[]
[]
[]
[]
[]
["Ukupno",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K9:L15)","v":0},null,{"$f":"SUM(M9:N15)","v":0},null,null,null,{"$f":"SUM(Q9:R15)","v":0}]
[]
["Potencijalne obveze po danim jamstvima/sudužništva",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["Osnova izlaganja",null,null,null,"Vrsta izloženosti",null,null,"Korisnik",null,null,"Početni iznos",null,"Stanje na datum izvještaja",null,"Datum dospijeća",null,"Dospjele obveze",null,"Instrumenti osiguranja/procijenjena vrijednost"]
[]
[]
[]
[]
[]
[]
["Ukupno",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K21:L25)","v":0},null,{"$f":"SUM(M21:N25)","v":0},null,null,null,{"$f":"SUM(Q21:R25)","v":0}]

{"sheet":"VIKR","index":13,"n_rows":14,"n_cols":21,"rows_kept":14,"cut":false,"hidden":false,"merged":[[4,2,4,7],[11,16,11,18],[7,0,8,6],[9,0,9,6],[8,7,8,9],[8,10,8,12],[8,16,8,18],[7,7,7,18],[8,13,8,15],[9,7,9,9],[10,16,10,18],[11,7,11,9],[2,20,5,38],[12,20,13,38],[7,20,11,38],[9,16,9,18],[9,10,9,12],[9,13,9,15],[1,5,2,13],[10,7,10,9],[10,10,10,12],[10,13,10,15],[11,10,11,12],[11,13,11,15],[10,0,10,6],[11,0,11,6],[12,0,12,6],[4,0,4,1],[48,0,51,7],[12,7,12,9],[12,10,12,12],[12,13,12,15],[12,16,12,18],[13,10,13,12],[13,13,13,15],[13,16,13,18],[37,0,46,7],[13,7,13,9],[37,12,37,20],[47,0,47,7],[32,0,36,6],[13,0,13,6],[0,15,0,18],[1,14,1,16],[1,17,1,18],[4,9,4,10],[4,11,4,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tablice - 1.8.",null,null,null,null,"Iznosi po valutama: unesite valutu"]
[null,null,null,null,null,"VIKR - Obrazac za utvrđivanje usklađenosti devizne pozicije klijenta ",null,null,null,null,null,null,null,null,"Datum izvještaja:",null,null,{"$f":"Izjava!F8","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Devizni priljevi uključuju planirane priljeve u tekućoj godini što podrazumijeva:\n• priljeve od potraživanja od stranih kupaca;\n• priljeve uz valutnu klauzulu od domaćih kupaca;\n• priljeve od budućih deviznih prihoda i prihoda uz valutnu klauzulu;\n• priljeve od avansa u devizama;\n• ostale planirane priljeve u tekućoj godini u devizama i uz deviznu klauzulu."]
[]
["Naziv klijenta:",null,{"$f":"Izjava!A6","v":0},null,null,null,null,null,null,"OIB:",null,{"$f":"Izjava!A8","v":0}]
[]
["Obrazac za utvrđivanje usklađenosti devizne pozicije klijenta"]
["Opis pozicije",null,null,null,null,null,null,"Iznosi po valutama",null,null,null,null,null,null,null,null,null,null,null,null,"Devizni odljevi uključuju planirane odljeve u tekućoj godini što podrazumijeva:\n• odljeve temeljem obveza za kratkoročne devizne kredite i kredite uz valutnu klauzulu (obveze za glavnicu i kamate);\n• odljeve temeljem obveza prema leasing kućama (visina leasing obroka bez PDV-a);\n• odljeve prema inozemnim dobavljačima i domaćim dobavljačima uz valutnu klauzulu;\n• ostale planirane devizne odljeve i odljeve uz valutnu klauzulu.\n\nTemelj za unos navedenih stavki jest Bilanca prethodnog obračunskog razdoblja. Međutim, u iznos planiranih deviznih odljeva potrebno je uključiti i odljeve u tekućoj godini temeljem novih planiranih kratkoročnih deviznih kredita i kredita uz valutnu klauzulu te dio obveza po dugoročnim deviznim kreditima i kreditima uz valutnu klauzulu koje dospijevaju u tekućoj godini.\nPlanirane odljeve u tekućoj godini temeljem novih kredita čija se realizacija očekuje putem HBOR-a, potrebno je isključiti iz predmetne stavke."]
[]
["1. Devizni priljevi i priljevi u kunama koji su valutno indeksirani"]
["2. Devizni odljevi i odljevi u kunama koji su valutno indeksirani"]
["3. Devizni odljevi i odljevi u kunama koji su valutno indeksirani, a koji se očekuju od novo odobrenih kredita HBOR-a (ispunjava HBOR)"]
["4.  Iznos kratkoročnih deviznih obveza i obveza uz valutnu klauzulu osiguranih založnim deviznim depozitom u istoj valuti u kojoj je odobren plasman",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iznos kratkoročnih deviznih obveza i obveza uz valutnu klauzulu osiguranih založnim deviznim depozitom u istoj valuti u kojoj je odobren plasman: \nPotrebno je upisati samo dio kratkoročnih obveza (kratkoročne obveze podrazumijevaju kratkoročne devizne obveze ili  dio dugoročnih deviznih obveza koji dospijeva u tekućoj godini) koji je upotpunosti (u 100 %-tnom iznosu) pokriven ročno usklađenim založenim deviznim depozitom u istoj valuti. U slučaju da je samo dio obveza osiguran predmetnim depozitom, potrebno je upisati samo iznos osiguranog dijela obveze."]
["5. Usklađenost devizne pozicije (5.= 1./(2. + 3. - 4.)) (ispunjava HBOR)"]