{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Programi","Prihodi","Prihodi (plan)","Kupci","Dobavljaci","Zalihe","Krediti","Ostale obveze","Investicije","EU projekti","Obrtna sredstva","Restrukturiranje","Izjava","VIKR"],"not_rendered":{"charts":0,"images":5,"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":68,"n_cols":9,"rows_kept":68,"cut":false,"hidden":false,"merged":[[66,8,66,12],[65,8,65,12],[64,8,64,12],[27,8,27,12],[3,8,4,13],[53,8,53,12],[61,8,61,12],[28,8,28,12],[55,8,56,12],[6,1,6,5],[20,1,20,5],[13,8,13,12],[15,8,17,12],[14,8,14,12],[67,8,69,12],[7,2,8,5],[46,1,46,5],[36,2,37,5],[21,2,22,5],[59,1,59,5],[33,1,33,5],[30,7,31,7],[62,8,62,12],[63,8,63,12],[41,8,41,12],[60,8,60,12],[40,8,40,12],[54,8,54,12],[29,8,30,12],[42,8,43,12]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,"Uz zahtjev za kreditiranje potrebno je popuniti i dostaviti sljedeće dokumente"]
[null,"Programi kreditiranja"]
[]
[null,"Investicijski krediti"]
[null,null,"• Program kreditiranja energetske obnove zgrada",null,null,null,null,null,"Struktura redovnih prihoda"]
[null,null,null,null,null,null,null,null,"Struktura redovnih prihoda (plan)"]
[null,null,"• Gospodarstvo",null,null,null,null,null,"Potraživanja od kupca"]
[null,null,"• Infrastruktura",null,null,null,null,null,"Obveze prema dobavljačima"]
[null,null,"• Malo i srednje poduzetništvo",null,null,null,null,null,"Pregled vrsta, stanja i starosti zaliha"]
[null,null,"• Nova proizvodnja",null,null,null,null,null,"Pregled kreditne zaduženosti"]
[null,null,"• Početnici",null,null,null,null,null,"Ostale obveze"]
[null,null,"• Poduzetništvo mladih",null,null,null,null,null,"Podaci o ulaganju - Investicijski kredit"]
[null,null,"• Pronalasci",null,null,null,null,null,"VIKR - utvrđivanje usklađenosti devizne pozicije klijenta (popunjava se samo za kredite iznad 1,5 mln kn i za kredite u kunama uz valutnu klauzulu)"]
[null,null,"• Turizam"]
[null,null,"• Zaštita okoliša"]
[null,null,"• Žene poduzetnice"]
[]
[null,"Obrtna sredstva"]
[null,null,"• Financiranje izrade projektne i ostale investicijske dokumentacije",null,null,null,null,null,"Struktura redovnih prihoda"]
[null,null,null,null,null,null,null,null,"Struktura redovnih prihoda (plan)"]
[null,null,"• Likvidnost",null,null,null,null,null,"Potraživanja od kupca"]
[null,null,"• Priprema izvoza",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,"Podaci o ulaganju - Obrtna sredstva"]
[null,null,null,null,null,null,null,null,"VIKR - utvrđivanje usklađenosti devizne pozicije klijenta (popunjava se samo za kredite iznad 1,5 mln kn i za kredite u kunama uz valutnu klauzulu)\n"]
[]
[]
[]
[null,"EU projekti"]
[null,null,"• Kreditiranje EU projekata javnog sektora",null,null,null,null,null,"Struktura redovnih prihoda"]
[null,null,"• Kreditiranje EU projekata privatnog sektora",null,null,null,null,null,"Struktura redovnih prihoda (plan)"]
[null,null,"• Kreditiranje EU projekata ruralnog razvoja, ribarstva 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,"Podaci o ulaganju - EU projekti"]
[null,null,null,null,null,null,null,null,"VIKR - utvrđivanje usklađenosti devizne pozicije klijenta (popunjava se samo za kredite iznad 1,5 mln kn i za kredite u kunama uz valutnu klauzulu)."]
[]
[]
[]
[null,"Financijsko restrukturiranje"]
[null,null,"• Restrukturiranje",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,"Podaci o ulaganju - Financijsko restrukturiranje"]
[null,null,null,null,null,null,null,null,"VIKR - utvrđivanje usklađenosti devizne pozicije klijenta (popunjava se samo za kredite iznad 1,5 mln kn i za kredite u kunama uz valutnu klauzulu)."]
[]
[]
[]
[null,"Ostali programi kreditiranja"]
[null,null,"• Kredit kupcu",null,null,null,null,null,"Struktura redovnih prihoda"]
[null,null,"• Kredit dobavljača",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 - utvrđivanje usklađenosti devizne pozicije klijenta (popunjava se samo za kredite iznad 1,5 mln kn i za kredite u kunama uz valutnu klauzulu)."]

{"sheet":"Prihodi","index":1,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,14,0,18],[2,9,2,10],[0,0,0,4],[18,0,18,3],[18,4,18,5],[18,7,18,8],[18,10,18,11],[18,13,18,14],[18,16,18,17],[17,16,17,17],[16,0,16,3],[16,4,16,5],[16,7,16,8],[16,10,16,11],[16,13,16,14],[16,16,16,17],[17,0,17,3],[17,4,17,5],[17,7,17,8],[17,10,17,11],[17,13,17,14],[14,16,14,17],[15,0,15,3],[15,4,15,5],[15,7,15,8],[15,10,15,11],[15,13,15,14],[15,16,15,17],[14,13,14,14],[13,0,13,3],[14,0,14,3],[14,4,14,5],[14,7,14,8],[14,10,14,11],[11,16,11,17],[10,0,10,3],[10,4,10,5],[10,7,10,8],[10,10,10,11],[10,13,10,14],[10,16,10,17],[11,0,11,3],[11,4,11,5],[11,7,11,8],[11,10,11,11],[11,13,11,14],[9,16,9,17],[8,0,8,3],[8,4,8,5],[8,7,8,8],[8,10,8,11],[8,13,8,14],[8,16,8,17],[9,0,9,3],[9,4,9,5],[9,7,9,8],[9,10,9,11],[9,13,9,14],[7,0,7,3],[7,4,7,5],[7,7,7,8],[7,10,7,11],[7,13,7,14],[4,0,4,4],[5,0,5,3],[5,4,5,5],[5,7,5,8],[2,0,2,1],[2,2,2,6],[6,0,6,3],[6,4,6,5],[6,7,6,8],[6,10,6,11],[6,13,6,14],[5,10,5,11],[5,13,5,14],[7,16,7,17],[5,16,5,17],[2,16,2,18],[2,14,2,15],[6,16,6,17]]}
["Struktura redovnih prihoda",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tablice klijenta stranica 1."]
[]
["Naziv klijenta:",null,null,null,null,null,null,null,"OIB:",null,null,null,null,null,"Datum izvještaja:"]
[]
["Struktura redovnih prihoda"]
["Vrsta prihoda",null,null,null,2013,null,"%",2014,null,"%",2015,null,"%",2016,null,"%","2017* ",null,"%"]
[]
[]
[]
[]
[]
["Ukupno",null,null,null,{"$f":"SUM(E7:F11)","v":0},null,{"$f":"SUM(G7:G11)","v":0},{"$f":"SUM(H7:I11)","v":0},null,{"$f":"SUM(J7:J11)","v":0},{"$f":"SUM(K7:L11)","v":0},null,{"$f":"SUM(M7:M11)","v":0},{"$f":"SUM(N7:O11)","v":0},null,{"$f":"SUM(P7:P11)","v":0},{"$f":"SUM(Q7:R11)","v":0},null,{"$f":"SUM(S7:S11)","v":0}]
[]
["Struktura izvanrednih prihoda"]
["Vrsta prihoda",null,null,null,2013,null,"%",2014,null,"%",2015,null,"%",2016,null,"%","2017* ",null,"%"]
[]
[]
[]
["Ukupno",null,null,null,{"$f":"SUM(E16:F18)","v":0},null,{"$f":"SUM(G16:G18)","v":0},{"$f":"SUM(H16:I18)","v":0},null,{"$f":"SUM(J16:J18)","v":0},{"$f":"SUM(K16:L18)","v":0},null,{"$f":"SUM(M16:M18)","v":0},{"$f":"SUM(N16:O18)","v":0},null,{"$f":"SUM(P16:P18)","v":0},{"$f":"SUM(Q16:R18)","v":0},null,{"$f":"SUM(S16:S18)","v":0}]
[]
["* privremena izvješća najnovijeg datuma"]

{"sheet":"Prihodi (plan)","index":2,"n_rows":19,"n_cols":19,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,10,18,11],[18,13,18,14],[0,0,0,4],[0,14,0,18],[2,0,2,1],[2,2,2,6],[2,9,2,10],[2,16,2,18],[18,16,18,17],[17,16,17,17],[16,0,16,3],[16,4,16,5],[16,7,16,8],[16,10,16,11],[16,13,16,14],[16,16,16,17],[18,0,18,3],[18,4,18,5],[18,7,18,8],[14,16,14,17],[15,0,15,3],[15,4,15,5],[15,7,15,8],[15,10,15,11],[15,13,15,14],[15,16,15,17],[14,13,14,14],[17,0,17,3],[17,4,17,5],[17,7,17,8],[17,10,17,11],[17,13,17,14],[13,0,13,3],[14,0,14,3],[14,4,14,5],[14,7,14,8],[14,10,14,11],[8,16,8,17],[7,16,7,17],[7,0,7,3],[11,16,11,17],[10,0,10,3],[10,4,10,5],[10,7,10,8],[10,10,10,11],[10,13,10,14],[10,16,10,17],[11,0,11,3],[11,4,11,5],[11,7,11,8],[11,10,11,11],[11,13,11,14],[9,16,9,17],[7,10,7,11],[7,13,7,14],[9,0,9,3],[9,4,9,5],[9,7,9,8],[9,10,9,11],[9,13,9,14],[8,4,8,5],[8,7,8,8],[8,10,8,11],[8,13,8,14],[8,0,8,3],[4,0,4,4],[7,4,7,5],[7,7,7,8],[2,14,2,15],[5,16,5,17],[6,0,6,3],[6,4,6,5],[6,7,6,8],[6,10,6,11],[6,13,6,14],[6,16,6,17],[5,0,5,3],[5,4,5,5],[5,7,5,8],[5,10,5,11],[5,13,5,14]]}
["Struktura redovnih prihoda (plan)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tablice klijenta stranica 2."]
[]
["Naziv klijenta:",null,{"$f":"Prihodi!C3","v":0},null,null,null,null,null,"OIB:",{"$f":"+Prihodi!J3","v":0},null,null,null,null,"Datum izvještaja:",null,{"$f":"+Prihodi!Q3","v":"00:00:00"}]
[]
["Struktura redovnih prihoda (plan)"]
["Vrsta prihoda",null,null,null,2017,null,"%",2018,null,"%",2019,null,"%",2020,null,"%",2021,null,"%"]
[]
[]
[]
[]
[]
["Ukupno",null,null,null,{"$f":"SUM(E7:F11)","v":0},null,{"$f":"SUM(G7:G11)","v":0},{"$f":"SUM(H7:I11)","v":0},null,{"$f":"SUM(J7:J11)","v":0},{"$f":"SUM(K7:L11)","v":0},null,{"$f":"SUM(M7:M11)","v":0},{"$f":"SUM(N7:O11)","v":0},null,{"$f":"SUM(P7:P11)","v":0},{"$f":"SUM(Q7:R11)","v":0},null,{"$f":"SUM(S7:S11)","v":0}]
[]
["Struktura izvanrednih prihoda (plan)"]
["Vrsta prihoda",null,null,null,2017,null,"%",2018,null,"%",2019,null,"%",2020,null,"%",2021,null,"%"]
[]
[]
[]
["Ukupno",null,null,null,{"$f":"SUM(E16:F18)","v":0},null,{"$f":"SUM(G16:G18)","v":0},{"$f":"SUM(H16:I18)","v":0},null,{"$f":"SUM(J16:J18)","v":0},{"$f":"SUM(K16:L18)","v":0},null,{"$f":"SUM(M16:M18)","v":0},{"$f":"SUM(N16:O18)","v":0},null,{"$f":"SUM(P16:P18)","v":0},{"$f":"SUM(Q16:R18)","v":0},null,{"$f":"SUM(S16:S18)","v":0}]

{"sheet":"Kupci","index":3,"n_rows":37,"n_cols":19,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,0,2,1],[2,2,2,6],[2,9,2,10],[0,10,0,16],[31,11,31,12],[33,7,33,8],[33,9,33,10],[33,11,33,12],[23,7,23,8],[23,9,23,10],[23,11,23,12],[24,7,24,8],[24,9,24,10],[24,11,24,12],[25,7,25,8],[25,9,25,10],[25,11,25,12],[26,7,26,8],[26,9,26,10],[26,11,26,12],[27,7,27,8],[26,4,26,5],[27,4,27,5],[34,7,34,8],[34,9,34,10],[34,11,34,12],[33,4,33,5],[34,4,34,5],[34,0,34,3],[29,7,29,8],[29,9,29,10],[29,11,29,12],[32,7,32,8],[32,9,32,10],[32,11,32,12],[30,7,30,8],[30,9,30,10],[30,11,30,12],[31,7,31,8],[31,9,31,10],[29,0,29,3],[30,0,30,3],[31,0,31,3],[32,0,32,3],[33,0,33,3],[29,4,29,5],[30,4,30,5],[31,4,31,5],[32,4,32,5],[28,4,28,5],[28,0,28,3],[28,7,28,8],[28,9,28,10],[28,11,28,12],[21,13,21,16],[20,15,20,16],[25,0,25,3],[26,0,26,3],[27,0,27,3],[23,4,23,5],[24,4,24,5],[25,4,25,5],[27,9,27,10],[27,11,27,12],[23,0,23,3],[24,0,24,3],[21,18,22,26],[22,7,22,8],[21,7,21,12],[22,9,22,10],[22,11,22,12],[5,12,6,12],[7,0,7,3],[7,4,7,5],[8,0,8,3],[8,4,8,5],[7,10,7,11],[8,10,8,11],[18,0,18,3],[18,4,18,5],[15,7,15,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[15,0,15,3],[15,4,15,5],[16,0,16,3],[16,4,16,5],[17,4,17,5],[12,0,12,3],[2,12,2,13],[2,14,2,16],[21,0,22,3],[21,4,22,5],[21,6,22,6],[5,7,6,8],[5,9,6,9],[5,0,6,3],[5,4,6,5],[5,10,6,11],[7,7,7,8],[8,7,8,8],[9,7,9,8],[10,7,10,8],[11,7,11,8],[9,0,9,3],[9,4,9,5],[10,0,10,3],[15,10,15,11],[16,10,16,11],[17,10,17,11],[18,10,18,11],[5,6,6,6],[17,0,17,3],[12,4,12,5],[9,10,9,11],[10,10,10,11],[11,10,11,11],[12,10,12,11],[13,10,13,11],[13,0,13,3],[13,4,13,5],[14,0,14,3],[14,4,14,5],[14,10,14,11],[10,4,10,5],[11,0,11,3],[11,4,11,5],[12,7,12,8],[13,7,13,8],[14,7,14,8]]}
["Potraživanja od kupca",null,null,null,null,null,null,null,null,null,"Tablice klijenta stranica 3."]
[]
["Naziv klijenta:",null,{"$f":"Prihodi!C3","v":0},null,null,null,null,null,"OIB:",{"$f":"+Prihodi!J3","v":0},null,null,"Datum izvještaja:",null,{"$f":"+Prihodi!Q3","v":"00:00:00"}]
[]
["Promet s kupcima",null,null,null,null,null,null,null,null,null,null,null,"(iznosi u kn)"]
["*Najveći kupci 1",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 %"]
[]
["1."]
["2."]
["3."]
["4."]
["5."]
["6."]
["7."]
["8."]
["9."]
["10."]
["ostali (broj)"]
["Ukupno",null,null,null,{"$f":"SUM(E8:F18)","v":0},null,{"$f":"SUM(G8:G18)","v":0},{"$f":"SUM(H8:I18)","v":0},null,{"$f":"SUM(J8:J18)","v":0},{"$f":"SUM(K8:L18)","v":0},null,{"$f":"SUM(M8:M18)","v":0}]
[]
["Potraživanja od kupca",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(iznosi u 000 kn)"]
["*Najveći kupci 1",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,"1 Unose se samo kupci koji u godišnjem prometu sudjeluju s više od 5%, a ostali sumarno pod \"ostali\". U 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"]
["1.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* Zvjezdicom se označuju kupci-povezane osobe."]
["2."]
["3."]
["4."]
["5."]
["6."]
["7."]
["8."]
["9."]
["10."]
["ostali (broj)"]
["Ukupno",null,null,null,{"$f":"SUM(E24:F34)","v":0},null,{"$f":"SUM(G24:G34)","v":0},{"$f":"SUM(H24:I34)","v":0},null,{"$f":"SUM(J24:K34)","v":0},null,{"$f":"SUM(L24:M34)","v":0},null,{"$f":"AVERAGE(N24:N34)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(O24:O34)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P24:P34)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(Q24:Q34)","v":{"$error":"#DIV/0!"}}]
[]
["Navedeni iznosi uključuju PDV:",null,null,null,"Da","Ne"]

{"sheet":"Dobavljaci","index":4,"n_rows":37,"n_cols":19,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,4],[0,10,0,16],[2,0,2,1],[2,2,2,6],[2,9,2,10],[5,18,6,26],[34,0,34,3],[34,4,34,5],[34,7,34,8],[34,9,34,10],[34,11,34,12],[33,0,33,3],[33,4,33,5],[33,7,33,8],[33,9,33,10],[33,11,33,12],[32,0,32,3],[32,4,32,5],[32,7,32,8],[32,9,32,10],[32,11,32,12],[29,11,29,12],[28,0,28,3],[28,4,28,5],[28,7,28,8],[28,9,28,10],[28,11,28,12],[29,0,29,3],[29,4,29,5],[31,11,31,12],[30,0,30,3],[30,4,30,5],[30,7,30,8],[30,9,30,10],[30,11,30,12],[31,0,31,3],[31,4,31,5],[31,7,31,8],[31,9,31,10],[29,7,29,8],[29,9,29,10],[26,7,26,8],[26,9,26,10],[26,11,26,12],[27,0,27,3],[27,4,27,5],[11,7,11,8],[27,7,27,8],[27,9,27,10],[21,6,22,6],[14,0,14,3],[14,4,14,5],[14,7,14,8],[14,10,14,11],[15,0,15,3],[15,4,15,5],[15,7,15,8],[15,10,15,11],[12,4,12,5],[12,7,12,8],[12,10,12,11],[13,0,13,3],[13,4,13,5],[18,0,18,3],[18,4,18,5],[10,0,10,3],[10,4,10,5],[10,10,10,11],[11,0,11,3],[11,4,11,5],[11,10,11,11],[12,0,12,3],[25,0,25,3],[27,11,27,12],[26,0,26,3],[26,4,26,5],[24,0,24,3],[24,4,24,5],[24,7,24,8],[24,9,24,10],[23,0,23,3],[23,4,23,5],[23,7,23,8],[23,9,23,10],[10,7,10,8],[25,4,25,5],[21,7,21,12],[21,0,22,3],[21,4,22,5],[21,13,21,16],[22,7,22,8],[22,9,22,10],[22,11,22,12],[23,11,23,12],[24,11,24,12],[25,7,25,8],[25,9,25,10],[25,11,25,12],[2,12,2,13],[2,14,2,16],[20,15,20,16],[5,0,6,3],[5,4,6,5],[5,6,6,6],[5,7,6,8],[5,9,6,9],[5,10,6,11],[5,12,6,12],[7,0,7,3],[7,4,7,5],[7,7,7,8],[7,10,7,11],[8,0,8,3],[8,4,8,5],[8,7,8,8],[8,10,8,11],[9,0,9,3],[9,4,9,5],[9,7,9,8],[9,10,9,11],[13,7,13,8],[13,10,13,11],[18,7,18,8],[18,10,18,11],[16,0,16,3],[16,4,16,5],[16,7,16,8],[16,10,16,11],[17,0,17,3],[17,4,17,5],[17,7,17,8],[17,10,17,11]]}
["Obveze prema dobavljačima",null,null,null,null,null,null,null,null,null,"Tablice klijenta stranica 4."]
[]
["Naziv klijenta:",null,{"$f":"Prihodi!C3","v":0},null,null,null,null,null,"OIB:",{"$f":"+Prihodi!J3","v":0},null,null,"Datum izvještaja:",null,{"$f":"+Prihodi!Q3","v":"00:00:00"}]
[]
["Promet s dobavljačima",null,null,null,null,null,null,null,null,null,null,null,"(iznosi u kn)"]
["*Najveći dobavljači 1",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,"1 Unose se samo dobavljači koji u godišnjem prometu sudjeluju s više od 5%, a ostali sumarno pod \"ostali\". U slučaju inozmenih dobavljača navesti na kraju naziv države porijekla, npr. GER, USA, ITA,…"]
[]
["1.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* Zvjezdicom se označuju dobavljači-povezane osobe."]
["2."]
["3."]
["4."]
["5."]
["6."]
["7."]
["8."]
["9."]
["10."]
["ostali (broj)"]
["Ukupno",null,null,null,{"$f":"SUM(E8:F18)","v":0},null,{"$f":"SUM(G8:G18)","v":0},{"$f":"SUM(H8:I18)","v":0},null,{"$f":"SUM(J8:J18)","v":0},{"$f":"SUM(K8:L18)","v":0},null,{"$f":"SUM(M8:M18)","v":0}]
[]
["Obveze prema dobavljačima",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(iznosi u 000 kn)"]
["*Najveći dobavljači 1",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,null,null,null,"ukupno stanje na datum izvještaja ",null,"nedospjele obveze",null,"dospjele obveze",null,"1 - 30","31 - 60","61 - 90","> 90"]
["1."]
["2."]
["3."]
["4."]
["5."]
["6."]
["7."]
["8."]
["9."]
["10."]
["ostali (broj)"]
["Ukupno",null,null,null,{"$f":"SUM(E24:F34)","v":0},null,{"$f":"SUM(G24:G34)","v":0},{"$f":"SUM(H24:I34)","v":0},null,{"$f":"SUM(J24:K34)","v":0},null,{"$f":"SUM(L24:M34)","v":0},null,{"$f":"AVERAGE(N24:N34)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(O24:O34)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(P24:P34)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(Q24:Q34)","v":{"$error":"#DIV/0!"}}]
[]
["Navedeni iznosi uključuju PDV:",null,null,null,"Da","Ne"]

{"sheet":"Zalihe","index":5,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[[15,0,15,3],[16,0,16,3],[17,0,17,3],[8,0,8,3],[9,0,9,3],[11,4,11,6],[12,4,12,6],[13,4,13,6],[12,0,12,3],[10,0,10,3],[11,0,11,3],[14,0,14,3],[5,4,6,6],[9,4,9,6],[10,4,10,6],[17,14,17,16],[21,10,22,12],[23,10,23,12],[15,14,15,16],[16,14,16,16],[18,14,18,16],[14,7,14,9],[10,14,10,16],[7,7,7,9],[8,7,8,9],[9,7,9,9],[10,7,10,9],[11,7,11,9],[15,7,15,9],[16,7,16,9],[18,7,18,9],[18,4,18,6],[17,4,17,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[0,0,0,4],[0,10,0,16],[2,0,2,1],[2,2,2,6],[2,9,2,10],[2,14,2,16],[2,12,2,13],[13,14,13,16],[14,14,14,16],[13,0,13,3],[5,14,6,16],[7,4,7,6],[8,4,8,6],[5,0,6,3],[5,7,6,9],[5,10,5,13],[7,0,7,3],[11,14,11,16],[12,14,12,16],[12,7,12,9],[13,7,13,9],[7,14,7,16],[8,14,8,16],[9,14,9,16],[33,7,33,9],[25,0,25,3],[26,0,26,3],[27,0,27,3],[28,0,28,3],[17,7,17,9],[21,0,22,3],[23,0,23,3],[21,4,22,6],[23,4,23,6],[21,7,22,9],[23,7,23,9],[28,7,28,9],[29,7,29,9],[30,7,30,9],[31,7,31,9],[18,0,18,3],[34,7,34,9],[34,0,34,3],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,4,27,6],[28,4,28,6],[29,4,29,6],[30,4,30,6],[31,4,31,6],[32,4,32,6],[33,4,33,6],[34,4,34,6],[29,0,29,3],[30,0,30,3],[31,0,31,3],[32,0,32,3],[33,0,33,3],[24,0,24,3],[24,7,24,9],[25,7,25,9],[26,7,26,9],[27,7,27,9],[32,7,32,9],[34,10,34,12],[21,13,22,16],[23,13,23,16],[24,13,24,16],[25,13,25,16],[26,13,26,16],[27,13,27,16],[28,13,28,16],[29,13,29,16],[30,13,30,16],[31,13,31,16],[32,13,32,16],[33,13,33,16],[34,13,34,16],[29,10,29,12],[30,10,30,12],[31,10,31,12],[32,10,32,12],[33,10,33,12],[24,10,24,12],[25,10,25,12],[26,10,26,12],[27,10,27,12],[28,10,28,12]]}
["Pregled vrsta, stanja i starosti zaliha",null,null,null,null,null,null,null,null,null,"Tablice klijenta stranica 5."]
[]
["Naziv klijenta:",null,{"$f":"Prihodi!C3","v":0},null,null,null,null,null,"OIB:",{"$f":"+Prihodi!J3","v":0},null,null,"Datum izvještaja:",null,{"$f":"+Prihodi!Q3","v":"00:00:00"}]
[]
["Pregled vrsta, stanja i starosti zaliha"]
["Vrsta zaliha\n(glavne skupine)",null,null,null,"Stanje zaliha na 31.12.2016. godine",null,null,"Stanje zaliha na datum izvještaja",null,null,"Starost zaliha u danima",null,null,null,"Sadašnja tržišna vrijednost",null,null,null,"* Unose se samo zalihe koje u godišnjem prometu sudjeluju s više od 5%, a ostale sumarno pod \"ostale\"."]
[null,null,null,null,null,null,null,null,null,null,"1 - 90","91 - 180","181 - 360","> 360"]
["1."]
["2."]
["3."]
["4."]
["5."]
["6."]
["7."]
["8."]
["9."]
["10."]
["ostali (broj dob.)."]
["Ukupno:",null,null,null,{"$f":"SUM(E8:G18)","v":0},null,null,{"$f":"SUM(H8:J18)","v":0},null,null,{"$f":"AVERAGE(K8:K18)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(L8:L18)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(M8:M18)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N8:N18)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O8:Q18)","v":0}]
[]
["Pregled potraživanja, ugovora i zaliha koja su pod zalogom"]
["Potraživanje / Ugovor / Vrsta zaliha",null,null,null,"Vrijednost potraživanja / zaliha na dan izvještaja",null,null,"Iznos zaloga",null,null,"Nositelj zaloga",null,null,"Opis osnove za realiziran zalog"]
[]
["1."]
["2."]
["3."]
["4."]
["5."]
["6."]
["7."]
["8."]
["9."]
["10."]
["ostali (broj dob.)."]
["Ukupno:",null,null,null,{"$f":"SUM(E24:G34)","v":0},null,null,{"$f":"SUM(H24:J34)","v":0}]

{"sheet":"Krediti","index":6,"n_rows":46,"n_cols":25,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,4],[0,10,0,16],[2,0,2,1],[2,2,2,6],[2,9,2,10],[2,14,2,16],[0,19,0,25],[2,21,2,22],[2,12,2,13],[2,23,2,25],[45,22,45,23],[44,14,44,15],[44,16,44,17],[44,19,44,21],[44,22,44,23],[45,0,45,3],[45,4,45,5],[45,6,45,7],[45,8,45,9],[45,10,45,11],[45,12,45,13],[44,0,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9],[44,10,44,11],[44,12,44,13],[45,14,45,15],[45,16,45,17],[45,19,45,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],[43,14,43,15],[43,16,43,17],[43,19,43,21],[43,22,43,23],[42,0,42,3],[42,4,42,5],[42,6,42,7],[42,8,42,9],[42,10,42,11],[42,12,42,13],[42,14,42,15],[42,16,42,17],[42,19,42,21],[40,14,40,15],[40,16,40,17],[40,19,40,21],[40,22,40,23],[41,0,41,3],[41,4,41,5],[41,6,41,7],[41,8,41,9],[41,10,41,11],[41,12,41,13],[40,0,40,3],[40,4,40,5],[40,6,40,7],[40,8,40,9],[40,10,40,11],[40,12,40,13],[41,14,41,15],[41,16,41,17],[41,19,41,21],[41,22,41,23],[38,12,39,13],[38,14,39,15],[38,16,39,17],[38,18,39,18],[38,19,39,21],[38,22,39,23],[27,0,27,6],[38,0,39,3],[38,4,39,5],[38,6,39,7],[38,8,39,9],[38,10,39,11],[35,12,35,13],[35,14,35,15],[35,16,35,17],[35,19,35,21],[35,22,35,23],[37,0,37,3],[34,12,34,13],[34,14,34,15],[34,16,34,17],[34,19,34,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],[32,12,32,13],[32,14,32,15],[32,16,32,17],[32,19,32,21],[31,0,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[31,10,31,11],[32,22,32,23],[33,0,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[33,10,33,11],[31,12,31,13],[31,14,31,15],[31,16,31,17],[31,19,31,21],[31,22,31,23],[32,0,32,3],[32,4,32,5],[32,6,32,7],[32,8,32,9],[32,10,32,11],[28,14,29,15],[28,16,29,17],[28,18,29,18],[28,19,29,21],[28,22,29,23],[30,0,30,3],[30,4,30,5],[30,6,30,7],[30,8,30,9],[30,10,30,11],[28,0,29,3],[28,4,29,5],[28,6,29,7],[28,8,29,9],[28,10,29,11],[28,12,29,13],[30,12,30,13],[30,14,30,15],[30,16,30,17],[30,19,30,21],[30,22,30,23],[25,22,25,23],[24,22,24,23],[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],[19,14,19,15],[19,16,19,17],[19,19,19,21],[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],[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],[22,22,22,23],[17,8,17,9],[17,10,17,11],[17,12,17,13],[17,14,17,15],[17,16,17,17],[17,19,17,21],[18,22,18,23],[19,22,19,23],[20,0,20,3],[20,4,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[20,14,20,15],[20,16,20,17],[20,19,20,21],[20,22,20,23],[19,0,19,3],[19,4,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[19,12,19,13],[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],[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],[12,22,12,23],[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],[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],[8,19,8,21],[9,22,9,23],[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],[11,22,11,23],[10,0,10,3],[10,4,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11],[10,12,10,13],[10,14,10,15],[10,16,10,17],[10,19,10,21],[5,19,6,21],[4,0,4,3],[5,0,6,3],[5,4,6,5],[5,6,6,7],[5,8,6,9],[8,22,8,23],[9,0,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[9,12,9,13],[9,14,9,15],[9,16,9,17],[9,19,9,21],[8,0,8,3],[8,4,8,5],[8,6,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[8,14,8,15],[8,16,8,17],[35,24,35,25],[15,24,15,25],[16,0,16,25],[17,24,17,25],[18,24,18,25],[19,24,19,25],[20,24,20,25],[21,24,21,25],[22,24,22,25],[23,24,23,25],[15,22,15,23],[17,22,17,23],[18,0,18,3],[18,4,18,5],[18,6,18,7],[18,8,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,15],[18,16,18,17],[18,19,18,21],[17,0,17,3],[17,4,17,5],[17,6,17,7],[4,24,4,25],[24,24,24,25],[25,24,25,25],[28,24,29,25],[30,24,30,25],[31,24,31,25],[32,24,32,25],[33,24,33,25],[34,24,34,25],[5,24,6,25],[7,0,7,24],[8,24,8,25],[9,24,9,25],[10,24,10,25],[11,24,11,25],[12,24,12,25],[13,24,13,25],[14,24,14,25],[5,22,6,23],[5,10,6,11],[5,12,6,13],[5,14,6,15],[5,16,6,17],[5,18,6,18]]}
["Pregled kreditne zaduženosti",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tablice klijenta stranica 6."]
[]
["Naziv klijenta:",null,{"$f":"Prihodi!C3","v":0},null,null,null,null,null,"OIB:",{"$f":"+Prihodi!J3","v":0},null,null,null,null,null,null,null,null,null,null,null,"Datum izvještaja:",null,{"$f":"+Prihodi!Q3","v":"00:00:00"}]
[]
["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"]
["1."]
["2."]
["3."]
["4."]
["5."]
["6."]
["7."]
["Ukupno kratkoročna zaduženost",null,null,null,{"$f":"SUM(E9:F15)","v":0},null,{"$f":"SUM(G9:H15)","v":0},null,null,null,{"$f":"SUM(K9:L15)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W9:X15)","v":0},null,{"$f":"SUM(Y9:Z15)","v":0}]
["Dugoročna zaduženost"]
["1."]
["2."]
["3."]
["4."]
["5."]
["6."]
["7."]
["Ukupno dugoročna zaduženost",null,null,null,{"$f":"SUM(E18:F24)","v":0},null,{"$f":"SUM(G18:H24)","v":0},null,null,null,{"$f":"SUM(K18:L24)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W18:X24)","v":0},null,{"$f":"SUM(Y18:Z24)","v":0}]
["Ukupno",null,null,null,{"$f":"E16+E25","v":0},null,{"$f":"G16+G25","v":0},null,null,null,{"$f":"K16+K25","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W16+W25","v":0},null,{"$f":"Y16+Y25","v":0}]
[]
["Struktura obveza po zajmovima (od trgovačkih društva, fizičkih osoba i ostalo)"]
["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"]
[]
["1."]
["2."]
["3."]
["4."]
["5."]
["Ukupno dugoročna zaduženost",null,null,null,{"$f":"SUM(E31:F35)","v":0},null,{"$f":"SUM(G31:H35)","v":0},null,null,null,{"$f":"SUM(K31:L35)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W31:X35)","v":0},null,{"$f":"SUM(Y31:Z35)","v":0}]
[]
["Potraživanja po danim zajmovima"]
["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"]
[]
["1."]
["2."]
["3."]
["4."]
["5."]
["Ukupno dugoročna zaduženost",null,null,null,{"$f":"SUM(E41:F45)","v":0},null,{"$f":"SUM(G41:H45)","v":0},null,null,null,{"$f":"SUM(K41:L45)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W41:X45)","v":0}]

{"sheet":"Ostale obveze","index":7,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,0,2,1],[2,2,2,6],[2,9,2,10],[2,16,2,17],[2,18,2,20],[0,17,0,20],[24,16,24,17],[24,18,24,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],[22,16,22,17],[22,18,22,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],[23,16,23,17],[23,18,23,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],[20,16,20,17],[20,18,20,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],[21,16,21,17],[21,18,21,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],[17,16,18,17],[17,18,18,20],[19,0,19,3],[19,4,19,6],[19,7,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,15],[19,16,19,17],[19,18,19,20],[17,0,18,3],[17,4,18,6],[17,7,18,9],[17,10,18,11],[17,12,18,13],[17,14,18,15],[13,16,13,17],[13,18,13,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],[14,16,14,17],[14,18,14,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],[11,16,11,17],[11,18,11,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],[12,16,12,17],[12,18,12,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],[7,12,7,13],[7,14,7,15],[9,16,9,17],[9,18,9,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],[10,16,10,17],[10,18,10,20],[9,0,9,3],[9,4,9,6],[9,7,9,9],[9,10,9,11],[9,12,9,13],[9,14,9,15],[4,18,4,20],[16,18,16,20],[5,0,6,3],[5,4,6,6],[5,7,6,9],[5,10,6,11],[5,12,6,13],[5,14,6,15],[5,16,6,17],[5,18,6,20],[7,16,7,17],[7,18,7,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],[8,16,8,17],[8,18,8,20],[7,0,7,3],[7,4,7,6],[7,7,7,9],[7,10,7,11]]}
["Ostale obveze",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tablice klijenta stranica 7."]
[]
["Naziv klijenta:",null,{"$f":"Prihodi!C3","v":0},null,null,null,null,null,"OIB:",{"$f":"+Prihodi!J3","v":0},null,null,null,null,null,null,"Datum izvještaja:",null,{"$f":"+Prihodi!Q3","v":"00:00:00"}]
[]
["Obveze po otvorenim akreditivima, izdanim garancijama i operativnom leasingu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(iznosi 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"]
[]
["1."]
["2."]
["3."]
["4."]
["5."]
["6."]
["7."]
["Ukupno",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K8:L14)","v":0},null,{"$f":"SUM(M8:N14)","v":0},null,null,null,{"$f":"SUM(Q8:R14)","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,"(iznosi 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"]
[]
["1."]
["2."]
["3."]
["4."]
["5."]
["Ukupno",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K20:L24)","v":0},null,{"$f":"SUM(M20:N24)","v":0},null,null,null,{"$f":"SUM(Q20:R24)","v":0}]

{"sheet":"Investicije","index":8,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,0,4,1],[4,2,4,6],[2,8,2,9],[2,10,2,11],[4,9,4,11],[0,0,0,5],[0,6,0,11],[38,10,38,11],[32,10,32,11],[33,10,33,11],[34,10,34,11],[35,10,35,11],[36,10,36,11],[37,10,37,11],[33,0,38,2],[33,4,33,9],[34,4,34,9],[35,4,35,9],[36,4,36,9],[37,4,37,9],[38,4,38,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,6,20,7],[21,6,21,7],[22,6,22,7],[19,4,19,5],[20,4,20,5],[23,6,23,7],[24,6,24,7],[26,0,26,3],[30,0,30,3],[31,0,32,2],[27,0,27,2],[28,0,28,2],[27,3,27,11],[28,3,28,11],[31,10,31,11],[30,10,30,11],[30,4,30,9],[31,4,31,9],[32,4,32,9],[23,10,23,11],[24,10,24,11],[24,8,24,9],[24,4,24,5],[24,1,24,3],[23,1,23,3],[23,4,23,5],[17,10,17,11],[18,10,18,11],[19,10,19,11],[20,10,20,11],[21,10,21,11],[22,10,22,11],[23,8,23,9],[21,4,21,5],[22,4,22,5],[17,4,17,5],[18,4,18,5],[20,1,20,3],[21,1,21,3],[22,1,22,3],[20,8,20,9],[21,8,21,9],[22,8,22,9],[12,10,12,11],[13,10,13,11],[14,10,14,11],[15,10,15,11],[16,10,16,11],[9,6,9,7],[10,6,10,7],[11,6,11,7],[12,6,12,7],[13,6,13,7],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[15,6,15,7],[16,6,16,7],[6,9,6,11],[6,0,6,7],[7,10,8,11],[9,4,9,5],[10,4,10,5],[7,4,7,7],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[9,10,9,11],[10,10,10,11],[11,10,11,11],[17,6,17,7],[18,6,18,7],[19,6,19,7],[14,6,14,7],[7,13,8,21],[28,13,28,21],[7,0,8,0],[7,1,8,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[8,4,8,5],[8,6,8,7],[7,8,8,9],[27,13,27,21],[11,4,11,5]]}
["Podaci o ulaganju - Investicijski kredit",null,null,null,null,null,"Tablice klijenta stranica 8."]
[]
[null,null,null,null,null,null,null,null,"Datum izvještaja:",null,{"$f":"+Prihodi!Q4","v":"00:00:00"}]
[]
["Naziv klijenta:",null,0,null,null,null,null,null,"OIB:",0]
[]
["Struktura investicije i izvori sredstva",null,null,null,null,null,null,null,null,"Iznosi u kn bez PDV-a"]
["Rb.","Stavka1",null,null,"Vlastita sredstva",null,null,null,"Kredit HBOR-a",null,"Ukupno",null,null,"1 Navesti stavke ulaganja kao: osnivačka ulaganja, zemljište, nasad, građevinski objekti, oprema i uređaji."]
[null,null,null,null,"Vlastiti izvori",null,"Ostali izvori"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E10:J10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E11:J11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
["I.","Osnovna sredstva ukupno",null,null,null,null,null,null,null,null,0]
["II.","Obrtna sredstva ",null,null,null,null,null,null,null,null,0]
["III.","Sveukupno (I. + II.)",null,null,{"$f":"E23+E24","v":0},null,{"$f":"G23+G24","v":0},null,{"$f":"I23+I24","v":0},null,{"$f":"K23+K24","v":0}]
[]
["Prethodno uložena sredstva"]
["Vlastita sredstva2",null,null,null,null,null,null,null,null,null,null,null,null,"2 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-a3",null,null,null,null,null,null,null,null,null,null,null,null,"3 Navesti ako postoje stavke ukupnog 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",null,null,null,"označiti",null,null,null,null,null,"iznos u kn"]
["Vlastita sredstva",null,null,null,"Novčana sredstva investitora"]
[null,null,null,null,"Osnovna sredstva Investitora pribavljena radi investicije"]
["Ostali izvori financiranja",null,null,null,"EU sredstva"]
[null,null,null,null,"Novčana sredstva drugih pravnih i fizičkih osoba"]
[null,null,null,null,"Kreditna sredstva drugih financijskih institucija"]
[null,null,null,null,"Ulog drugih pravnih ili fizičkih osoba (u novcu ili stvarima)"]
[null,null,null,null,"Ostalo (niže navesti što):"]

{"sheet":"EU projekti","index":9,"n_rows":58,"n_cols":14,"rows_kept":58,"cut":false,"hidden":false,"merged":[[2,8,2,9],[2,10,2,11],[4,0,4,1],[4,2,4,6],[4,9,4,11],[0,0,0,5],[0,6,0,11],[36,1,36,9],[37,1,37,9],[30,1,30,3],[30,4,30,5],[30,6,30,7],[30,8,30,9],[30,10,30,11],[31,1,31,3],[31,6,31,7],[31,8,31,9],[31,10,31,11],[11,10,11,11],[12,10,12,11],[13,10,13,11],[7,1,7,9],[8,1,8,9],[9,1,9,9],[38,1,38,9],[39,1,39,9],[40,1,40,9],[47,13,47,21],[48,0,48,2],[48,3,48,11],[48,13,48,21],[41,1,41,9],[42,1,42,9],[43,1,43,9],[44,0,44,9],[46,0,46,3],[47,0,47,2],[47,3,47,11],[10,1,10,9],[11,1,11,9],[12,1,12,9],[13,1,13,9],[28,6,28,7],[28,8,28,9],[28,10,28,11],[29,1,29,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[29,10,29,11],[26,1,26,3],[26,4,26,5],[26,8,26,9],[26,10,26,11],[27,1,27,3],[27,4,27,5],[27,6,27,7],[27,8,27,9],[27,10,27,11],[28,1,28,3],[28,4,28,5],[26,6,26,7],[6,0,6,9],[6,10,6,11],[7,10,7,11],[8,10,8,11],[9,10,9,11],[10,10,10,11],[31,4,31,5],[55,4,55,9],[55,10,55,11],[50,0,50,3],[50,4,50,9],[50,10,50,11],[32,1,32,3],[32,4,32,5],[32,6,32,7],[32,8,32,9],[32,10,32,11],[33,1,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[33,10,33,11],[35,10,35,11],[35,0,35,9],[56,4,56,9],[56,10,56,11],[57,4,57,9],[57,10,57,11],[51,0,52,2],[51,4,51,9],[51,10,51,11],[52,4,52,9],[52,10,52,11],[53,0,58,2],[53,4,53,9],[53,10,53,11],[54,4,54,9],[54,10,54,11],[58,4,58,9],[58,10,58,11],[36,10,36,11],[37,10,37,11],[38,10,38,11],[39,10,39,11],[40,10,40,11],[41,10,41,11],[42,10,42,11],[43,10,43,11],[44,10,44,11],[24,1,24,3],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[25,1,25,3],[25,4,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[22,1,22,3],[22,4,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[23,1,23,3],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[20,1,20,3],[20,4,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[21,1,21,3],[21,4,21,5],[21,6,21,7],[21,8,21,9],[21,10,21,11],[15,0,15,7],[15,9,15,11],[18,1,18,3],[18,4,18,5],[18,6,18,7],[18,8,18,9],[18,10,18,11],[19,1,19,3],[19,4,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[16,0,17,0],[16,1,17,3],[16,4,17,5],[16,6,17,7],[16,8,17,9],[16,10,17,11]]}
["Podaci o ulaganju - EU projekti",null,null,null,null,null,"Tablice klijenta stranica 8."]
[]
[null,null,null,null,null,null,null,null,"Datum izvještaja:",null,{"$f":"+Prihodi!Q4","v":"00:00:00"}]
[]
["Naziv klijenta:",null,0,null,null,null,null,null,"OIB:",0]
[]
["Kredit HBOR-a i prihvatljivi iznos granta za HBOR",null,null,null,null,null,null,null,null,null,"Iznos u kn"]
["A.","Ukupni iznos projekta (prihvatljivi i neprihvatljivi troškovi)",null,null,null,null,null,null,null,null,null,null,null,"1 U slučaju jednokratne isplate granta nije moguće prihvatiti izračun iz točke F."]
["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%)1"]
["G.","Potrebno financirati kreditom (A. - B. - F.)"]
[]
["Struktura investicije i izvori sredstva",null,null,null,null,null,null,null,null,"Iznosi u kn bez PDV-a"]
["Rb.","Stavka2",null,null,"Iznosi ulaganja",null,"Prihvatljivi troškovi",null,"Postotak potpore u %",null,"Iznos granta",null,null,"2 Navesti stavke ulaganja kao: osnivačka ulaganja, zemljište, nasad, građvenski objekti, oprema i uređaji."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3 U izračun se ne uzimaju prihvatljivi izdaci koji su po svojoj naravi dio obrtnih sredstava."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["I.","Osnovna sredstva ukupno"]
["II.","Obrtna sredstva3"]
["III.","Sveukupno (I. + II.)",null,null,{"$f":"E32+E33","v":0},null,{"$f":"G32+G33","v":0},null,null,null,{"$f":"K32+K33","v":0}]
[]
["Plan izvora financiranja",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,{"$f":"K40+K41","v":0}]
[null,"- troškovi projekta"]
[null,"- obrtna sredstva"]
["3.","Grant",null,null,null,null,null,null,null,null,{"$f":"+K43+K44","v":0}]
[null,"- predujam"]
[null,"- rate"]
["Ukupno (1. + 2. + 3.)",null,null,null,null,null,null,null,null,null,{"$f":"K37+K39+K42","v":0}]
[]
["Prethodno uložena sredstva"]
["Vlastita sredstva4",null,null,null,null,null,null,null,null,null,null,null,null,"4 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-a5",null,null,null,null,null,null,null,null,null,null,null,null,"5 Navesti ako postoje stavke ukupnog 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",null,null,null,"označiti",null,null,null,null,null,"iznos u kn"]
["Vlastita sredstva",null,null,null,"Novčana sredstva investitora"]
[null,null,null,null,"Osnovna sredstva Investitora pribavljena radi investicije"]
["Ostali izvori financiranja",null,null,null,"EU sredstva"]
[null,null,null,null,"Novčana sredstva drugih pravnih i fizičkih osoba"]
[null,null,null,null,"Kreditna sredstva drugih financijskih institucija"]
[null,null,null,null,"Ulog drugih pravnih ili fizičkih osoba (u novcu ili stvarima)"]
[null,null,null,null,"Ostalo (niže navesti što):"]

{"sheet":"Obrtna sredstva","index":10,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[17,1,17,8],[10,9,10,11],[9,9,9,11],[7,1,7,8],[8,1,8,8],[9,1,9,8],[10,1,10,8],[7,9,7,11],[8,9,8,11],[15,9,15,11],[16,9,16,11],[17,9,17,11],[12,10,12,11],[7,13,10,19],[19,9,19,11],[20,9,20,11],[21,9,21,11],[11,1,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,9],[11,10,11,11],[0,6,0,11],[6,0,6,7],[6,9,6,11],[2,8,2,9],[2,10,2,11],[4,0,4,1],[4,2,4,6],[4,9,4,11],[24,1,24,3],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[23,1,23,8],[12,0,12,9],[13,1,13,8],[14,1,14,8],[15,1,15,8],[16,1,16,8],[20,1,20,8],[21,1,21,8],[22,1,22,8],[19,1,19,8],[18,1,18,8],[22,9,22,11],[23,9,23,11],[13,9,13,11],[14,9,14,11],[18,9,18,11]]}
["Podaci o ulaganju - Obrtna sredstva",null,null,null,null,null,"Tablice klijenta stranica 8."]
[]
[null,null,null,null,null,null,null,null,"Datum izvještaja:",null,{"$f":"+Prihodi!Q4","v":"00:00:00"}]
[]
["Naziv klijenta:",null,0,null,null,null,null,null,"OIB:",0]
[]
["Proračun potrebnih obrtnih sredstava1",null,null,null,null,null,null,null,null,"Iznos u kn"]
["1.","Planirana vrijednost prihoda od proizvodnje i/ili izvoza za tekuću godinu",null,null,null,null,null,null,null,null,null,null,null,"1 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)."]
["2.","PBDV - prosječan broj dana vezivanja"]
["3.","KO - Koeficijent obrtaja (KO=365/PBDV)"]
["4.","OBS - Potrebna obrtna sredstva (OBS=Planirana vrijednost prihoda/KO)"]
[]
["Specifikacija namjene ulaganja/kredita"]
["RB","Stavka",null,null,null,null,null,null,null,"Iznos u kn"]
["1."]
["2."]
["3."]
["4."]
["5."]
["6."]
["7."]
["8."]
["9."]
[null,"Ukupno:",null,null,null,null,null,null,null,{"$f":"SUM(J15:L23)","v":0}]

{"sheet":"Restrukturiranje","index":11,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,8,2,9],[2,10,2,11],[4,0,4,1],[4,2,4,6],[4,9,4,11],[0,6,0,11],[34,0,34,4],[34,5,34,8],[34,9,34,11],[35,0,35,4],[35,5,35,8],[35,9,35,11],[32,0,32,4],[32,5,32,8],[32,9,32,11],[33,0,33,4],[33,5,33,8],[33,9,33,11],[30,0,30,4],[30,5,30,8],[30,9,30,11],[31,0,31,4],[31,5,31,8],[31,9,31,11],[27,9,27,11],[28,0,28,4],[28,5,28,8],[28,9,28,11],[29,0,29,4],[29,5,29,8],[29,9,29,11],[27,0,27,8],[25,0,25,4],[25,5,25,8],[25,9,25,11],[26,0,26,4],[26,5,26,8],[26,9,26,11],[23,0,23,4],[23,5,23,8],[23,9,23,11],[24,0,24,4],[24,5,24,8],[24,9,24,11],[21,9,21,11],[22,0,22,4],[22,5,22,8],[22,9,22,11],[19,0,19,4],[19,5,19,8],[19,9,19,11],[20,0,20,4],[20,5,20,8],[20,9,20,11],[7,13,7,20],[11,9,11,11],[10,0,10,8],[7,9,7,11],[7,6,7,8],[7,3,7,5],[7,0,7,2],[6,9,6,11],[6,0,6,5],[8,0,8,2],[8,3,8,5],[8,6,8,8],[8,9,8,11],[6,6,6,8],[36,0,36,4],[36,5,36,8],[36,9,36,11],[11,0,11,8],[12,0,12,8],[16,9,17,11],[18,0,18,8],[14,0,14,11],[15,9,15,11],[15,0,15,8],[12,9,12,11],[21,0,21,4],[21,5,21,8],[18,9,18,11],[16,0,17,4],[16,5,17,8]]}
["Podaci o ulaganju - Financijsko restrukturiranje",null,null,null,null,null,"Tablice klijenta stranica 8."]
[]
[null,null,null,null,null,null,null,null,"Datum izvještaja:",null,{"$f":"+Prihodi!Q4","v":"00:00:00"}]
[]
["Naziv klijenta:",null,0,null,null,null,null,null,"OIB:",0]
[]
["Udio kapitala u pasivi bilance1",null,null,null,null,null,null,null,null,"Iznos u kn"]
["Pokazatelji",null,null,"Datum",null,null,"Udio %",null,null,"Ispunjava uvjeti ≥ 10%",null,null,null,"1 Ispunjava se za trgovačka društva i ostale poslovne subjekte u sustavu poreza na dobit"]
["Kapital u pasivi bilance",null,null,null,null,null,null,null,null,"                   Da\n                   Ne"]
[]
["Ostali uvjeti1"]
["Neto dobit u zadnje dvije poslovne godine",null,null,null,null,null,null,null,null,"                   Nije isplaćena\n                   Isplaćena"]
["Pozajmice u zadnje dvije poslovne godine \n(osim pozajmica povezanim osobama za potrebe operativnog razvoja i poslovanja)",null,null,null,null,null,null,null,null,"                   Nisu isplaćene\n                   Isplaćene"]
[]
["Namjena ulaganja/kredita"]
["Stanje na dan (upisati datum):"]
["Stavka",null,null,null,null,"Uvjeti\n(datum odobrenja, rok otplate, kamatna stopa)",null,null,null,"Iznos u kn"]
[]
["I. Kreditne obveze ukupno (prema stavkama niže)",null,null,null,null,null,null,null,null,{"$f":"SUM(J20:L27)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
["II. Dobavljači ukupno (prema stavkama niže)",null,null,null,null,null,null,null,null,{"$f":"SUM(J29:L36)","v":0}]
[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,"-"]
["III. Sveukupno",null,null,null,null,null,null,null,null,{"$f":"J19+J28","v":0}]

{"sheet":"Izjava","index":12,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[26,0,27,2],[13,0,13,4],[13,5,13,9],[15,0,15,9],[9,0,9,9],[16,0,16,4],[16,5,16,9],[22,0,22,13],[14,0,14,8],[17,0,17,4],[17,5,17,9],[18,0,18,4],[18,5,18,9],[19,0,19,4],[19,5,19,9],[21,0,21,9],[2,3,2,5],[25,0,25,2],[34,0,34,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],[31,0,31,13]]}
[]
[]
[null,null,null,"Izjava klijenta"]
[]
["Naziv klijenta:"]
[{"$f":"+Prihodi!C3","v":0}]
["OIB:",null,null,null,null,"Datum izvještaja:"]
[{"$f":"+Prihodi!J3","v":0},null,null,null,null,{"$f":"+Prihodi!Q3","v":"00:00:00"}]
[]
["Podaci o osobi koja je popunjavala Tablice klijenta:"]
["Ime i prezime:",null,null,null,null,"Funkcija:"]
[]
["Telefon:",null,null,null,null,"E-mail:"]
[]
[]
["Podaci o ovlaštenoj osobi"]
["Ime i prezime:",null,null,null,null,"Funkcija:"]
[]
["Telefon:",null,null,null,null,"E-mail:"]
[]
[]
["Potvrđujemo da su svi podaci u niže navedenim Tablicama klijenta točni i potpuni:"]
["  • 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 ovisno o programu kreditiranja:\n       • Podaci o ulaganju - Investicijski kredit,\n       • Podaci o ulaganju - EU projekti,\n       • Podaci o ulaganju - Obrtnih sredstva,\n       • Podaci o ulaganju - Financijsko restrukturiranje."]
[]
[]
["Mjesto i datum",null,null,null,"Potpis ovlaštene osobe i pečat"]
[]
[]
[]
[]
[]
["\n\n\n\n\n"]

{"sheet":"VIKR","index":13,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[7,16,7,18],[0,17,0,20],[2,0,2,1],[2,2,2,6],[2,9,2,10],[2,14,2,15],[2,16,2,18],[0,0,0,8],[5,0,6,6],[7,0,7,6],[6,7,6,9],[6,10,6,12],[6,16,6,18],[5,7,5,18],[6,13,6,15],[7,7,7,9],[7,10,7,12],[7,13,7,15],[34,0,34,7],[8,7,8,9],[8,10,8,12],[8,13,8,15],[19,0,23,6],[9,10,9,12],[9,13,9,15],[8,0,8,6],[9,0,9,6],[17,0,18,4],[16,0,16,4],[10,0,10,6],[11,0,11,6],[8,16,8,18],[9,7,9,9],[35,0,38,7],[18,14,18,18],[10,7,10,9],[10,10,10,12],[10,13,10,15],[10,16,10,18],[11,10,11,12],[11,13,11,15],[11,16,11,18],[24,0,33,7],[11,7,11,9],[9,16,9,18]]}
["VIKR - utvrđivanje usklađenosti devizne pozicije klijenta "]
[]
["Naziv klijenta:",null,{"$f":"Prihodi!C3","v":0},null,null,null,null,null,"OIB:",{"$f":"+Prihodi!J3","v":0},null,null,null,null,"Datum izvještaja:",null,{"$f":"+Prihodi!Q3","v":"00:00:00"}]
[]
["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,"EUR",null,null,"USD",null,null,"CHF"]
["1. Devizni priljevi i priljevi u kunama koji su valutno indeksirani1"]
["2. Devizni odljevi i odljevi u kunama koji su valutno indeksirani2"]
["3. Devizni odljevi i odljevi u kunama koji su valutno indeksirani, a koji se očekuju od novo odobrenih kredita HBOR-a (ovu poziciju ispunjava HBOR)3"]
["4.  Iznos kratkoročnih deviznih obveza i obveza uz valutnu klauzulu osiguranih založnim deviznim depozitom u istoj valuti u kojoj je odobren plasman4."]
["5. Usklađenost devizne pozicije (5.= 1./(2. + 3. - 4.))",null,null,null,null,null,null,{"$f":"H8/(H9+H10-H11)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"K8/(K9+K10-K11)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"N8/(N9+N10-N11)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"Q8/(Q9+Q10-Q11)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
["Mjesto i datum",null,null,null,null,null,null,null,null,null,null,null,null,null,"Potpis ovlaštene osobe i pečat"]
[]
[]
["1 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."]
[]
[]
[]
[]
["2 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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3 Ovu stavku ispunjava HBOR."]
["4 Potrebno 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."]