{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Finanční tok","Graf finančního toku"],"not_rendered":{"charts":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Finanční tok","index":0,"n_rows":61,"n_cols":16,"rows_kept":61,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"Projekce finančního toku malých podniků"]
[null,"Název společnosti"]
[null,"Počáteční datum",{"$f":"TODAY()","v":"2019-04-25"}]
[null,"Upozornění na minimální zůstatek v hotovosti",null,{"$f":"Minimální_hotovost","v":0},{"$f":"Minimální_hotovost","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Počáteční","I-18","II-18","III-18","IV-18","V-18","VI-18","VII-18","VIII-18","IX-19","X-18","XI-18","XII-18","Celkem"]
[null,"Pokladní hotovost (začátek měsíce)",null,{"$f":"C53","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"PŘÍJMY V HOTOVOSTI"," ","I-18","II-18","III-18","IV-18","V-18","VI-18","VII-18","VIII-18","IX-18","X-18","XI-18","XII-18","Celkem"]
[null,"Prodeje v hotovosti",{"$nulls":13},{"$f":"SUM(D10:O10)","v":0}]
[null,"Vratky a příspěvky",{"$nulls":13},0]
[null,"Kolekce pohledávek",{"$nulls":13},0]
[null,"Úrok, ostatní příjmy",{"$nulls":13},0]
[null,"Výtěžek půjčky",{"$nulls":13},0]
[null,"Příspěvky vlastníka",{"$nulls":13},0]
[null,"CELKOVÉ PŘÍJMY V HOTOVOSTI",null,{"$f":"SUM(D10,D12:D15,(D11*-1))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(109,PříjmyVHotovosti[Celkem])","v":0}]
[null,"Celková dostupná hotovost",{"$f":"(C7+PříjmyVHotovosti[[#Totals],[ ]])","v":0},{"$f":"(D7+PříjmyVHotovosti[[#Totals],[I-18]])","v":0},{"$f":"(E7+PříjmyVHotovosti[[#Totals],[II-18]])","v":0},{"$f":"(F7+PříjmyVHotovosti[[#Totals],[III-18]])","v":0},{"$f":"(G7+PříjmyVHotovosti[[#Totals],[IV-18]])","v":0},{"$f":"(H7+PříjmyVHotovosti[[#Totals],[V-18]])","v":0},{"$f":"(I7+PříjmyVHotovosti[[#Totals],[VI-18]])","v":0},{"$f":"(J7+PříjmyVHotovosti[[#Totals],[VII-18]])","v":0},{"$f":"(K7+PříjmyVHotovosti[[#Totals],[VIII-18]])","v":0},{"$f":"(L7+PříjmyVHotovosti[[#Totals],[IX-18]])","v":0},{"$f":"(M7+PříjmyVHotovosti[[#Totals],[X-18]])","v":0},{"$f":"(N7+PříjmyVHotovosti[[#Totals],[XI-18]])","v":0},{"$f":"(O7+PříjmyVHotovosti[[#Totals],[XII-18]])","v":0}]
[]
[null,"VYPLACENO V HOTOVOSTI"," ","I-18","II-18","III-18","IV-18","V-18","VI-18","VII-18","VIII-18","IX-18","X-18","XI-18","XII-18","Celkem"]
[null,"Reklama",{"$nulls":13},{"$f":"SUM(D20:O20)","v":0}]
[null,"Provize a poplatky",{"$nulls":13},0]
[null,"Smluvní práce",{"$nulls":13},0]
[null,"Programy zaměstnaneckých benefitů",{"$nulls":13},0]
[null,"Pojištění (jiné než zdravotní)",{"$nulls":13},0]
[null,"Úrokové výdaje",{"$nulls":13},0]
[null,"Materiály a zásoby (v COGS)",{"$nulls":13},0]
[null,"Jídlo a zábava",{"$nulls":13},0]
[null,"Hypoteční úrok",{"$nulls":13},0]
[null,"Výdaje na kancelář",{"$nulls":13},0]
[null,"Další úrokové výdaje",{"$nulls":13},0]
[null,"Důchodový plán a plán podílu na zisku",{"$nulls":13},0]
[null,"Nákupy pro další prodej",{"$nulls":13},0]
[null,"Nájem nebo pronájem",{"$nulls":13},0]
[null,"Nájem nebo pronájem: vozidla, vybavení",{"$nulls":13},0]
[null,"Opravy a údržba",{"$nulls":13},0]
[null,"Zásoby (mimo COGS)",{"$nulls":13},0]
[null,"Daně a licence",{"$nulls":13},0]
[null,"Cestování",{"$nulls":13},0]
[null,"Energie",{"$nulls":13},0]
[null,"Mzdy (bez slevy na dani)",{"$nulls":13},0]
[null,"Jiné výdaje",{"$nulls":13},0]
[null,"Jiné výdaje",{"$nulls":13},0]
[null,"Jiné výdaje",{"$nulls":13},0]
[null,"Různé",{"$nulls":13},0]
[null,"MEZISOUČET",null,{"$f":"SUBTOTAL(109,Výdaje[I-18])","v":0},{"$f":"SUBTOTAL(109,Výdaje[II-18])","v":0},{"$f":"SUBTOTAL(109,Výdaje[III-18])","v":0},{"$f":"SUBTOTAL(109,Výdaje[IV-18])","v":0},{"$f":"SUBTOTAL(109,Výdaje[V-18])","v":0},{"$f":"SUBTOTAL(109,Výdaje[VI-18])","v":0},{"$f":"SUBTOTAL(109,Výdaje[VII-18])","v":0},{"$f":"SUBTOTAL(109,Výdaje[VIII-18])","v":0},{"$f":"SUBTOTAL(109,Výdaje[IX-18])","v":0},{"$f":"SUBTOTAL(109,Výdaje[X-18])","v":0},{"$f":"SUBTOTAL(109,Výdaje[XI-18])","v":0},{"$f":"SUBTOTAL(109,Výdaje[XII-18])","v":0},{"$f":"SUBTOTAL(109,Výdaje[Celkem])","v":0}]
[null,"VYPLACENO V HOTOVOSTI"," ","I-18","II-18","III-18","IV-18","V-18","VI-18","VII-18","VIII-18","IX-18","X-18","XI-18","XII-18","Celkem"]
[null,"Splátka jistiny půjčky",{"$nulls":13},{"$f":"SUM(D47:O47)","v":0}]
[null,"Kapitálové nákupy",{"$nulls":13},0]
[null,"Další náklady na uvedení do provozu",{"$nulls":13},0]
[null,"Rezervovat nebo uložit zálohu",{"$nulls":13},0]
[null,"Výběr vlastníka",{"$nulls":13},0]
[null,"VYPLACENO V HOTOVOSTI CELKEM",null,{"$f":"Výdaje[[#Totals],[I-18]]+SUBTOTAL(109,VyplacenoVHotovosti[I-18])","v":0},{"$f":"Výdaje[[#Totals],[II-18]]+SUBTOTAL(109,VyplacenoVHotovosti[II-18])","v":0},{"$f":"Výdaje[[#Totals],[III-18]]+SUBTOTAL(109,VyplacenoVHotovosti[III-18])","v":0},{"$f":"Výdaje[[#Totals],[IV-18]]+SUBTOTAL(109,VyplacenoVHotovosti[IV-18])","v":0},{"$f":"Výdaje[[#Totals],[V-18]]+SUBTOTAL(109,VyplacenoVHotovosti[V-18])","v":0},{"$f":"Výdaje[[#Totals],[VI-18]]+SUBTOTAL(109,VyplacenoVHotovosti[VI-18])","v":0},{"$f":"Výdaje[[#Totals],[VII-18]]+SUBTOTAL(109,VyplacenoVHotovosti[VII-18])","v":0},{"$f":"Výdaje[[#Totals],[VIII-18]]+SUBTOTAL(109,VyplacenoVHotovosti[VIII-18])","v":0},{"$f":"Výdaje[[#Totals],[IX-18]]+SUBTOTAL(109,VyplacenoVHotovosti[IX-18])","v":0},{"$f":"Výdaje[[#Totals],[X-18]]+SUBTOTAL(109,VyplacenoVHotovosti[X-18])","v":0},{"$f":"Výdaje[[#Totals],[XI-18]]+SUBTOTAL(109,VyplacenoVHotovosti[XI-18])","v":0},{"$f":"Výdaje[[#Totals],[XII-18]]+SUBTOTAL(109,VyplacenoVHotovosti[XII-18])","v":0},0]
[null,"Pokladní hotovost (konec měsíce)",{"$f":"C17","v":0},{"$f":"D17-VyplacenoVHotovosti[[#Totals],[I-18]]","v":0},{"$f":"E17-VyplacenoVHotovosti[[#Totals],[II-18]]","v":0},{"$f":"F17-VyplacenoVHotovosti[[#Totals],[III-18]]","v":0},{"$f":"G17-VyplacenoVHotovosti[[#Totals],[IV-18]]","v":0},{"$f":"H17-VyplacenoVHotovosti[[#Totals],[V-18]]","v":0},{"$f":"I17-VyplacenoVHotovosti[[#Totals],[VI-18]]","v":0},{"$f":"J17-VyplacenoVHotovosti[[#Totals],[VII-18]]","v":0},{"$f":"K17-VyplacenoVHotovosti[[#Totals],[VIII-18]]","v":0},{"$f":"L17-VyplacenoVHotovosti[[#Totals],[IX-18]]","v":0},{"$f":"M17-VyplacenoVHotovosti[[#Totals],[X-18]]","v":0},{"$f":"N17-VyplacenoVHotovosti[[#Totals],[XI-18]]","v":0},{"$f":"O17-VyplacenoVHotovosti[[#Totals],[XII-18]]","v":0}]
[]
[null,"DALŠÍ PROVOZNÍ ÚDAJE"," ","I-18","II-18","III-18","IV-18","V-18","VI-18","VII-18","VIII-18","IX-18","X-18","XI-18","XII-18","Celkem"]
[null,"Objem prodeje (dolary)",{"$nulls":13},{"$f":"SUM(DalšíProvozníÚdaje[[#This Row],[I-18]:[XII-18]])","v":0}]
[null,"Zůstatek pohledávek",{"$nulls":13},{"$f":"SUM(DalšíProvozníÚdaje[[#This Row],[I-18]:[XII-18]])","v":0}]
[null,"Zůstatek nedobytných pohledávek",{"$nulls":13},{"$f":"SUM(DalšíProvozníÚdaje[[#This Row],[I-18]:[XII-18]])","v":0}]
[null,"Zásoby na skladě",{"$nulls":13},{"$f":"SUM(DalšíProvozníÚdaje[[#This Row],[I-18]:[XII-18]])","v":0}]
[null,"Zůstatek závazků",{"$nulls":13},{"$f":"SUM(DalšíProvozníÚdaje[[#This Row],[I-18]:[XII-18]])","v":0}]
[null,"Odpisy",{"$nulls":13},{"$f":"SUM(DalšíProvozníÚdaje[[#This Row],[I-18]:[XII-18]])","v":0}]

{"sheet":"Graf finančního toku","index":1,"n_rows":37,"n_cols":4,"rows_kept":37,"merged":[[1,1,34,16],[36,1,36,2]]}
[]
[null,"V této buňce jsou kombinovaný graf ukazující upozornění na minimální pokladní hotovost a projekce finančního toku."]
{"$rows_empty":34}
[null,"Upozornění na minimální zůstatek v hotovosti",null,{"$f":"[0]!Minimální_hotovost","v":{"v":0,"d":"0 Kč"}}]