{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Liquiditeitsbegroting"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Liquiditeitsbegroting","index":0,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[9,0,9,1],[10,0,10,1],[12,0,12,1],[0,0,0,4],[6,0,6,1],[7,0,7,1],[6,2,6,3],[7,2,7,3],[13,0,13,1],[14,0,14,1],[17,0,17,1],[18,0,18,1],[20,0,20,1],[44,0,44,1],[15,0,15,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[42,0,42,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[22,0,22,1],[36,0,36,1],[23,0,23,1]]}
["Liquiditeitsbegroting"]
["Ter info: ","Enkel de groen gekleurde vakken zijn te vullen. De overige vakken worden doorgerekend en zijn niet te wijzigen. "]
[null,"Houd in de liquiditeitsbegroting rekening met inkomende- en uitgaande  betalingen. Houd hiernaast rekening met"]
[null,"de opschorting van ABN AMRO bank, de steunmaatregelingen van de overheid, inbreng van (eventueel) "]
[null,"beschikbare middelen in privé, lagere kosten door verminderde business en noodzakelijke privé-onttrekkingen."]
[]
["Datum (dd-mm-jjjj)"]
["Huidige banksaldo",null,0,null,"per maand"]
[{"$nulls":4},"uitstel ontvangen"]
["Maand",null,{"$f":"MONTH($C$7)","v":1},2,{"$f":"MONTH($C$7+(31*2))","v":3},{"$f":"MONTH($C$7+31*3)","v":4},{"$f":"MONTH($C$7+31*4)","v":5},{"$f":"MONTH($C$7+31*5)","v":6},{"$f":"MONTH($C$7+31*6)","v":7},{"$f":"MONTH($C$7+31*7)","v":8},{"$f":"MONTH($C$7+31*8)","v":9},{"$f":"MONTH($C$7+31*9)","v":10},{"$f":"MONTH($C$7+31*10)","v":11},{"$f":"MONTH($C$7+31*11)","v":12}]
["Saldo bank/kas",null,{"$f":"C8","v":0},{"$f":"C45","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["Aanvullende financiering",{"$nulls":13},"Totaal"]
[" Eigen inbreng",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C14:N14)","v":0}]
[" (Achtergestelde) lening",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" NOW bijdrage",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" Overige bijdrage",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" Aanvullende financiering ABN AMRO",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Totaal financieringen",null,{"$f":"SUM(C14:C18)","v":0},{"$f":"SUM(D14:D18)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Verkoop (inkomende betalingen)",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C21:N21)","v":0}]
[]
["Uitgaven"]
["Inkoop (uitgaande betalingen)",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C24:N24)","v":0}]
[]
["Kosten incl. BTW"]
[" Personeel: ","Lonen",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C27:N27)","v":0}]
[null,"Sociale lasten",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C28:N28)","v":0}]
[null,"Overige personeelskosten",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C29:N29)","v":0}]
[null,"Privéonttrekkingen / managementfee",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C30:N30)","v":0}]
[" Huisvestingskosten",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" Vervoerskosten",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" Verkoopkosten",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" Overige bedrijfskosten",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Totale bedrijfskosten",null,{"$f":"SUM(C27:C34)","v":0},{"$f":"SUM(D27:D34)","v":0},{"$f":"SUM(E27:E34)","v":0},{"$f":"SUM(F27:F34)","v":0},{"$f":"SUM(G27:G34)","v":0},{"$f":"SUM(H27:H34)","v":0},{"$f":"SUM(I27:I34)","v":0},{"$f":"SUM(J27:J34)","v":0},{"$f":"SUM(K27:K34)","v":0},{"$f":"SUM(L27:L34)","v":0},{"$f":"SUM(M27:M34)","v":0},{"$f":"SUM(N27:N34)","v":0},{"$f":"SUM(O27:O34)","v":0}]
[]
["BTW afdracht",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C37:N37)","v":0}]
[]
[" Rente lening(en)",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C39:N39)","v":0}]
[" Aflossingen lening(en)",null,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C40:N40)","v":0}]
["Totaal rente en aflossing",null,{"$f":"SUM(C39:C40)","v":0},{"$f":"SUM(D39:D40)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C41:N41)","v":0}]
[]
["Kasmutatie per maand",null,{"$f":"C19+C21-C24-C35-C37-C41","v":0},{"$f":"D19+D21-D24-D35-D37-D41","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C43:N43)","v":0}]
[]
["Eindsaldo",null,{"$f":"C11+C43","v":0},{"$f":"D11+D43","v":0},0,0,0,0,0,0,0,0,0,0]