{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Protok gotovine","Grafikon protoka gotovine"],"not_rendered":{"charts":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Protok gotovine","index":0,"n_rows":61,"n_cols":16,"rows_kept":61,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"Projekcija protoka novca malog preduzeća"]
[null,"Ime preduzeća"]
[null,"Datum početka",{"$f":"TODAY()","v":"2019-04-24"}]
[null,"Minimalno upozorenje o gotovinskom saldu",null,{"$f":"Cash_minimum","v":0},{"$f":"Cash_minimum","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Početak","jan.18","feb.18","mar.18","apr.18","maj.18","jun.18","jul.18","avg.18","sep.18","okt.18","nov.18","dec.18","Zbir"]
[null,"Novac na raspolaganju (na početku meseca)",null,{"$f":"C53","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"PRIZNANICE"," ","jan.18","feb.18","mar.18","apr.18","maj.18","jun.18","jul.18","avg.18","sep.18","okt.18","nov.18","dec.18","Zbir"]
[null,"Prodaja novca",{"$nulls":13},{"$f":"SUM(D10:O10)","v":0}]
[null,"Povraćaji od prodaje i naknade",{"$nulls":13},0]
[null,"Naplate na račune potraživanja",{"$nulls":13},0]
[null,"Kamata, ostali prihodi",{"$nulls":13},0]
[null,"Sredstva od kredita",{"$nulls":13},0]
[null,"Doprinosi vlasnika",{"$nulls":13},0]
[null,"PRIZNANICE ZA UKUPAN IZNOS GOTOVINE",null,{"$f":"SUM(D10,D12:D15,(D11*-1))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(109,CashReceipts[Zbir])","v":0}]
[null,"Ukupan iznos dostupnog novca",{"$f":"(C7+CashReceipts[[#Totals],[ ]])","v":0},{"$f":"(D7+CashReceipts[[#Totals],[jan.18]])","v":0},{"$f":"(E7+CashReceipts[[#Totals],[feb.18]])","v":0},{"$f":"(F7+CashReceipts[[#Totals],[mar.18]])","v":0},{"$f":"(G7+CashReceipts[[#Totals],[apr.18]])","v":0},{"$f":"(H7+CashReceipts[[#Totals],[maj.18]])","v":0},{"$f":"(I7+CashReceipts[[#Totals],[jun.18]])","v":0},{"$f":"(J7+CashReceipts[[#Totals],[jul.18]])","v":0},{"$f":"(K7+CashReceipts[[#Totals],[avg.18]])","v":0},{"$f":"(L7+CashReceipts[[#Totals],[sep.18]])","v":0},{"$f":"(M7+CashReceipts[[#Totals],[okt.18]])","v":0},{"$f":"(N7+CashReceipts[[#Totals],[nov.18]])","v":0},{"$f":"(O7+CashReceipts[[#Totals],[dec.18]])","v":0}]
[]
[null,"ISPLAĆEN NOVAC"," ","jan.18","feb.18","mar.18","apr.18","maj.18","jun.18","jul.18","avg.18","sep.18","okt.18","nov.18","dec.18","Zbir"]
[null,"Reklamiranje",{"$nulls":13},{"$f":"SUM(D20:O20)","v":0}]
[null,"Provizije i naknade",{"$nulls":13},0]
[null,"Ugovor o radu",{"$nulls":13},0]
[null,"Programi za naknade zaposlenima",{"$nulls":13},0]
[null,"Osiguranja (osim zdravstvenog)",{"$nulls":13},0]
[null,"Troškovi kamate",{"$nulls":13},0]
[null,"Materijali i pribori (izražen u TPR)",{"$nulls":13},0]
[null,"Obroci i zabava",{"$nulls":13},0]
[null,"Kamata na hipoteku",{"$nulls":13},0]
[null,"Kancelarijski troškovi",{"$nulls":13},0]
[null,"Ostali troškovi kamate",{"$nulls":13},0]
[null,"Penzioni plan i plan raspodele profita",{"$nulls":13},0]
[null,"Kupovina za ponovnu prodaju",{"$nulls":13},0]
[null,"Zakup ili iznajmljivanje",{"$nulls":13},0]
[null,"Zakup ili iznajmljivanje: vozila i opreme",{"$nulls":13},0]
[null,"Popravke i održavanje",{"$nulls":13},0]
[null,"Zalihe (nisu izražene u TPR)",{"$nulls":13},0]
[null,"Porezi i licence",{"$nulls":13},0]
[null,"Putovanje",{"$nulls":13},0]
[null,"Komunalne usluge",{"$nulls":13},0]
[null,"Plata (manje emp. kredita)",{"$nulls":13},0]
[null,"Ostali troškovi",{"$nulls":13},0]
[null,"Ostali troškovi",{"$nulls":13},0]
[null,"Ostali troškovi",{"$nulls":13},0]
[null,"Razno",{"$nulls":13},0]
[null,"MEĐUVREDNOST",null,{"$f":"SUBTOTAL(109,Troškovi[jan.18])","v":0},{"$f":"SUBTOTAL(109,Troškovi[feb.18])","v":0},{"$f":"SUBTOTAL(109,Troškovi[mar.18])","v":0},{"$f":"SUBTOTAL(109,Troškovi[apr.18])","v":0},{"$f":"SUBTOTAL(109,Troškovi[maj.18])","v":0},{"$f":"SUBTOTAL(109,Troškovi[jun.18])","v":0},{"$f":"SUBTOTAL(109,Troškovi[jul.18])","v":0},{"$f":"SUBTOTAL(109,Troškovi[avg.18])","v":0},{"$f":"SUBTOTAL(109,Troškovi[sep.18])","v":0},{"$f":"SUBTOTAL(109,Troškovi[okt.18])","v":0},{"$f":"SUBTOTAL(109,Troškovi[nov.18])","v":0},{"$f":"SUBTOTAL(109,Troškovi[dec.18])","v":0},{"$f":"SUBTOTAL(109,Troškovi[Zbir])","v":0}]
[null,"ISPLAĆEN NOVAC"," ","jan.18","feb.18","mar.18","apr.18","maj.18","jun.18","jul.18","avg.18","sep.18","okt.18","nov.18","dec.18","Zbir"]
[null,"IZNOS GLAVNICE KREDITA",{"$nulls":13},{"$f":"SUM(D47:O47)","v":0}]
[null,"Kapitalne kupovine",{"$nulls":13},0]
[null,"Ostali troškovi pokretanja preduzeća",{"$nulls":13},0]
[null,"Da biste rezervisali i/ili deponovali",{"$nulls":13},0]
[null,"Povlačenje vlasnika",{"$nulls":13},0]
[null,"UKUPAN ISPLAĆEN NOVAC",null,{"$f":"Troškovi[[#Totals],[jan.18]]+SUBTOTAL(109,CashPaidOut[jan.18])","v":0},{"$f":"Troškovi[[#Totals],[feb.18]]+SUBTOTAL(109,CashPaidOut[feb.18])","v":0},{"$f":"Troškovi[[#Totals],[mar.18]]+SUBTOTAL(109,CashPaidOut[mar.18])","v":0},{"$f":"Troškovi[[#Totals],[apr.18]]+SUBTOTAL(109,CashPaidOut[apr.18])","v":0},{"$f":"Troškovi[[#Totals],[maj.18]]+SUBTOTAL(109,CashPaidOut[maj.18])","v":0},{"$f":"Troškovi[[#Totals],[jun.18]]+SUBTOTAL(109,CashPaidOut[jun.18])","v":0},{"$f":"Troškovi[[#Totals],[jul.18]]+SUBTOTAL(109,CashPaidOut[jul.18])","v":0},{"$f":"Troškovi[[#Totals],[avg.18]]+SUBTOTAL(109,CashPaidOut[avg.18])","v":0},{"$f":"Troškovi[[#Totals],[sep.18]]+SUBTOTAL(109,CashPaidOut[sep.18])","v":0},{"$f":"Troškovi[[#Totals],[okt.18]]+SUBTOTAL(109,CashPaidOut[okt.18])","v":0},{"$f":"Troškovi[[#Totals],[nov.18]]+SUBTOTAL(109,CashPaidOut[nov.18])","v":0},{"$f":"Troškovi[[#Totals],[dec.18]]+SUBTOTAL(109,CashPaidOut[dec.18])","v":0},0]
[null,"Novac na raspolaganju (kraj meseca)",{"$f":"C17","v":0},{"$f":"D17-CashPaidOut[[#Totals],[jan.18]]","v":0},{"$f":"E17-CashPaidOut[[#Totals],[feb.18]]","v":0},{"$f":"F17-CashPaidOut[[#Totals],[mar.18]]","v":0},{"$f":"G17-CashPaidOut[[#Totals],[apr.18]]","v":0},{"$f":"H17-CashPaidOut[[#Totals],[maj.18]]","v":0},{"$f":"I17-CashPaidOut[[#Totals],[jun.18]]","v":0},{"$f":"J17-CashPaidOut[[#Totals],[jul.18]]","v":0},{"$f":"K17-CashPaidOut[[#Totals],[avg.18]]","v":0},{"$f":"L17-CashPaidOut[[#Totals],[sep.18]]","v":0},{"$f":"M17-CashPaidOut[[#Totals],[okt.18]]","v":0},{"$f":"N17-CashPaidOut[[#Totals],[nov.18]]","v":0},{"$f":"O17-CashPaidOut[[#Totals],[dec.18]]","v":0}]
[]
[null,"DRUGI OPERATIVNI PODACI"," ","jan.18","feb.18","mar.18","apr.18","maj.18","jun.18","jul.18","avg.18","sep.18","okt.18","nov.18","dec.18","Zbir"]
[null,"Obim prodaje (u dolarima)",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[jan.18]:[dec.18]])","v":0}]
[null,"Saldo potraživanja po računima",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[jan.18]:[dec.18]])","v":0}]
[null,"Saldo dugova",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[jan.18]:[dec.18]])","v":0}]
[null,"Raspoložive zalihe",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[jan.18]:[dec.18]])","v":0}]
[null,"Saldo dugovanja na računima",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[jan.18]:[dec.18]])","v":0}]
[null,"Amortizacija",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[jan.18]:[dec.18]])","v":0}]

{"sheet":"Grafikon protoka gotovine","index":1,"n_rows":37,"n_cols":4,"rows_kept":37,"merged":[[1,1,34,16],[36,1,36,2]]}
[]
[null,"Kombinovani grafikon koji prikazuje Upozorenje o minimumu novca na raspolaganju i Projekciju protoka gotovine nalazi se u ovoj ćeliji."]
{"$rows_empty":34}
[null,"Minimalno upozorenje o gotovinskom saldu",null,{"$f":"[0]!Cash_minimum","v":{"v":0,"d":"0 RSD"}}]