{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Cashflow","Cashflowgrafiek"],"not_rendered":{"charts":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Cashflow","index":0,"n_rows":61,"n_cols":16,"rows_kept":61,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"Kasstroomprojectie voor kleine bedrijf"]
[null,"Bedrijfsnaam"]
[null,"Startdatum",{"$f":"TODAY()","v":"2019-04-19"}]
[null,"Minimum waarschuwing kassaldo",null,{"$f":"Cash_minimum","v":0},{"$f":"Cash_minimum","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Begin-","jan-18","feb-18","mrt-18","apr-18","mei-18","jun-18","jul-18","aug-18","sep-18","okt-18","nov-18","dec-18","Totaal"]
[null,"Kassaldo (begin van de maand)",null,{"$f":"C53","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Kasontvangsten"," ","jan-18","feb-18","mrt-18","apr-18","mei-18","jun-18","jul-18","aug-18","sep-18","okt-18","nov-18","dec-18","Totaal"]
[null,"Kasverkopen",{"$nulls":13},{"$f":"SUM(D10:O10)","v":0}]
[null,"Retouren en vergoedingen",{"$nulls":13},0]
[null,"Inningen op vorderingen",{"$nulls":13},0]
[null,"Rente, overige inkomsten",{"$nulls":13},0]
[null,"Leningopbrengsten",{"$nulls":13},0]
[null,"Eigenaarsbijdragen",{"$nulls":13},0]
[null,"Totaal kasontvangsten",null,{"$f":"SUM(D10,D12:D15,(D11*-1))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(109,Kasontvangsten[Totaal])","v":0}]
[null,"Totaal beschikbaar kas",{"$f":"(C7+Kasontvangsten[[#Totals],[ ]])","v":0},{"$f":"(D7+Kasontvangsten[[#Totals],[jan-18]])","v":0},{"$f":"(E7+Kasontvangsten[[#Totals],[feb-18]])","v":0},{"$f":"(F7+Kasontvangsten[[#Totals],[mrt-18]])","v":0},{"$f":"(G7+Kasontvangsten[[#Totals],[apr-18]])","v":0},{"$f":"(H7+Kasontvangsten[[#Totals],[mei-18]])","v":0},{"$f":"(I7+Kasontvangsten[[#Totals],[jun-18]])","v":0},{"$f":"(J7+Kasontvangsten[[#Totals],[jul-18]])","v":0},{"$f":"(K7+Kasontvangsten[[#Totals],[aug-18]])","v":0},{"$f":"(L7+Kasontvangsten[[#Totals],[sep-18]])","v":0},{"$f":"(M7+Kasontvangsten[[#Totals],[okt-18]])","v":0},{"$f":"(N7+Kasontvangsten[[#Totals],[nov-18]])","v":0},{"$f":"(O7+Kasontvangsten[[#Totals],[dec-18]])","v":0}]
[]
[null,"Kasuitgaven"," ","jan-18","feb-18","mrt-18","apr-18","mei-18","jun-18","jul-18","aug-18","sep-18","okt-18","nov-18","dec-18","Totaal"]
[null,"Reclame",{"$nulls":13},{"$f":"SUM(D20:O20)","v":0}]
[null,"Commissies en kosten",{"$nulls":13},0]
[null,"Contractarbeid",{"$nulls":13},0]
[null,"Personeelsvoorzieningen",{"$nulls":13},0]
[null,"Verzekering (anders dan gezondheidsverzekering)",{"$nulls":13},0]
[null,"Renteuitgaven",{"$nulls":13},0]
[null,"Materiaal en voorraad (in COGS)",{"$nulls":13},0]
[null,"Maaltijden en amusement",{"$nulls":13},0]
[null,"Hypotheekrente",{"$nulls":13},0]
[null,"Kantooruitgaven",{"$nulls":13},0]
[null,"Renteuitgaven",{"$nulls":13},0]
[null,"Pensioen en winstdelingsregeling",{"$nulls":13},0]
[null,"Aankopen voor wederverkoop",{"$nulls":13},0]
[null,"Huur of lease",{"$nulls":13},0]
[null,"Huur of lease: voertuigen, apparatuur",{"$nulls":13},0]
[null,"Reparatie en onderhoud",{"$nulls":13},0]
[null,"Voorraad (niet in de COGS)",{"$nulls":13},0]
[null,"Belastingen en licenties",{"$nulls":13},0]
[null,"Reiskosten",{"$nulls":13},0]
[null,"Gas, water en elektra",{"$nulls":13},0]
[null,"Salarissen (exclusief arbeidskrediet)",{"$nulls":13},0]
[null,"Overige uitgaven",{"$nulls":13},0]
[null,"Overige uitgaven",{"$nulls":13},0]
[null,"Overige uitgaven",{"$nulls":13},0]
[null,"Diversen",{"$nulls":13},0]
[null,"SUBTOTAAL",null,{"$f":"SUBTOTAL(109,Expenses[jan-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[feb-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[mrt-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[apr-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[mei-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[jun-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[jul-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[aug-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[sep-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[okt-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[nov-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[dec-18])","v":0},{"$f":"SUBTOTAL(109,Expenses[Totaal])","v":0}]
[null,"Kasuitgaven"," ","jan-18","feb-18","mrt-18","apr-18","mei-18","jun-18","jul-18","aug-18","sep-18","okt-18","nov-18","dec-18","Totaal"]
[null,"Betaling hoofdsom lening",{"$nulls":13},{"$f":"SUM(D47:O47)","v":0}]
[null,"Vermogensaankopen",{"$nulls":13},0]
[null,"Overige opstartkosten",{"$nulls":13},0]
[null,"Ter voorziening en/of zekerheidstelling",{"$nulls":13},0]
[null,"Opname door eigenaren",{"$nulls":13},0]
[null,"Totaal kasuitgaven",null,{"$f":"Expenses[[#Totals],[jan-18]]+SUBTOTAL(109,Kasuitgaven[jan-18])","v":0},{"$f":"Expenses[[#Totals],[feb-18]]+SUBTOTAL(109,Kasuitgaven[feb-18])","v":0},{"$f":"Expenses[[#Totals],[mrt-18]]+SUBTOTAL(109,Kasuitgaven[mrt-18])","v":0},{"$f":"Expenses[[#Totals],[apr-18]]+SUBTOTAL(109,Kasuitgaven[apr-18])","v":0},{"$f":"Expenses[[#Totals],[mei-18]]+SUBTOTAL(109,Kasuitgaven[mei-18])","v":0},{"$f":"Expenses[[#Totals],[jun-18]]+SUBTOTAL(109,Kasuitgaven[jun-18])","v":0},{"$f":"Expenses[[#Totals],[jul-18]]+SUBTOTAL(109,Kasuitgaven[jul-18])","v":0},{"$f":"Expenses[[#Totals],[aug-18]]+SUBTOTAL(109,Kasuitgaven[aug-18])","v":0},{"$f":"Expenses[[#Totals],[sep-18]]+SUBTOTAL(109,Kasuitgaven[sep-18])","v":0},{"$f":"Expenses[[#Totals],[okt-18]]+SUBTOTAL(109,Kasuitgaven[okt-18])","v":0},{"$f":"Expenses[[#Totals],[nov-18]]+SUBTOTAL(109,Kasuitgaven[nov-18])","v":0},{"$f":"Expenses[[#Totals],[dec-18]]+SUBTOTAL(109,Kasuitgaven[dec-18])","v":0},0]
[null,"Kassaldo (eind van de maand)",{"$f":"C17","v":0},{"$f":"D17-Kasuitgaven[[#Totals],[jan-18]]","v":0},{"$f":"E17-Kasuitgaven[[#Totals],[feb-18]]","v":0},{"$f":"F17-Kasuitgaven[[#Totals],[mrt-18]]","v":0},{"$f":"G17-Kasuitgaven[[#Totals],[apr-18]]","v":0},{"$f":"H17-Kasuitgaven[[#Totals],[mei-18]]","v":0},{"$f":"I17-Kasuitgaven[[#Totals],[jun-18]]","v":0},{"$f":"J17-Kasuitgaven[[#Totals],[jul-18]]","v":0},{"$f":"K17-Kasuitgaven[[#Totals],[aug-18]]","v":0},{"$f":"L17-Kasuitgaven[[#Totals],[sep-18]]","v":0},{"$f":"M17-Kasuitgaven[[#Totals],[okt-18]]","v":0},{"$f":"N17-Kasuitgaven[[#Totals],[nov-18]]","v":0},{"$f":"O17-Kasuitgaven[[#Totals],[dec-18]]","v":0}]
[]
[null,"Andere operationele gegevens"," ","jan-18","feb-18","mrt-18","apr-18","mei-18","jun-18","jul-18","aug-18","sep-18","okt-18","nov-18","dec-18","Totaal"]
[null,"Omzetvolume (dollar)",{"$nulls":13},{"$f":"SUM(AndereOperationeleGegevens[[#This Row],[jan-18]:[dec-18]])","v":0}]
[null,"Debiteurensaldo",{"$nulls":13},{"$f":"SUM(AndereOperationeleGegevens[[#This Row],[jan-18]:[dec-18]])","v":0}]
[null,"Saldo slechte schulden",{"$nulls":13},{"$f":"SUM(AndereOperationeleGegevens[[#This Row],[jan-18]:[dec-18]])","v":0}]
[null,"Beschikbare voorraad",{"$nulls":13},{"$f":"SUM(AndereOperationeleGegevens[[#This Row],[jan-18]:[dec-18]])","v":0}]
[null,"Saldo crediteuren",{"$nulls":13},{"$f":"SUM(AndereOperationeleGegevens[[#This Row],[jan-18]:[dec-18]])","v":0}]
[null,"Afschrijving",{"$nulls":13},{"$f":"SUM(AndereOperationeleGegevens[[#This Row],[jan-18]:[dec-18]])","v":0}]

{"sheet":"Cashflowgrafiek","index":1,"n_rows":37,"n_cols":4,"rows_kept":37,"merged":[[1,1,34,16],[36,1,36,2]]}
[]
[null,"Combinatiegrafiek met melding voor Minimum in kas en Geraamde cashflow staat in deze cel."]
{"$rows_empty":34}
[null,"Minimum waarschuwing kassaldo",null,{"$f":"[0]!Cash_minimum","v":{"v":0,"d":"€ 0"}}]