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

{"sheet":"Cashflow","index":0,"n_rows":62,"n_cols":16,"rows_kept":62,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"ADATUM CORPORATION"]
[null,"Kasstroomprojectie voor kleine bedrijven"]
[]
[null,"Startdatum",{"$f":"TODAY()","v":"2023-03-20"}]
[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,"Vanaf","Jan-xx","Feb-xx","Mrt-xx","Apr-xx","Mei-xx","Jun-xx","Jul-xx","Aug-xx","Sep-xx","Okt-xx","Nov-xx","Dec-xx","Totaal"]
[null,"Kassaldo (begin van de maand)",null,{"$f":"C54","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"KASONTVANGSTEN"," ","Jan-xx","Feb-xx","Mrt-xx","Apr-xx","Mei-xx","Jun-xx","Jul-xx","Aug-xx","Sep-xx","Okt-xx","Nov-xx","Dec-xx","Totaal"]
[null,"Kasverkopen",{"$nulls":13},{"$f":"SUM(D11:O11)","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(D11,D13:D16,(D12*-1))","v":0},{"$f":"SUM(E11,E13:E16,(E12*-1))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(109,Kasontvangsten[Totaal])","v":0}]
[null,"Totaal beschikbaar kas",{"$f":"(C8+Kasontvangsten[[#Totals],[ ]])","v":0},{"$f":"(D8+Kasontvangsten[[#Totals],[Jan-xx]])","v":0},{"$f":"(E8+Kasontvangsten[[#Totals],[Feb-xx]])","v":0},{"$f":"(F8+Kasontvangsten[[#Totals],[Mrt-xx]])","v":0},{"$f":"(G8+Kasontvangsten[[#Totals],[Apr-xx]])","v":0},{"$f":"(H8+Kasontvangsten[[#Totals],[Mei-xx]])","v":0},{"$f":"(I8+Kasontvangsten[[#Totals],[Jun-xx]])","v":0},{"$f":"(J8+Kasontvangsten[[#Totals],[Jul-xx]])","v":0},{"$f":"(K8+Kasontvangsten[[#Totals],[Aug-xx]])","v":0},{"$f":"(L8+Kasontvangsten[[#Totals],[Sep-xx]])","v":0},{"$f":"(M8+Kasontvangsten[[#Totals],[Okt-xx]])","v":0},{"$f":"(N8+Kasontvangsten[[#Totals],[Nov-xx]])","v":0},{"$f":"(O8+Kasontvangsten[[#Totals],[Dec-xx]])","v":0}]
[]
[null,"KASUITGAVEN"," ","Jan-xx","Feb-xx","Mrt-xx","Apr-xx","Mei-xx","Jun-xx","Jul-xx","Aug-xx","Sep-xx","Okt-xx","Nov-xx","Dec-xx","Totaal"]
[null,"Reclame",{"$nulls":13},{"$f":"SUM(D21:O21)","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,Onkosten[Jan-xx])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Feb-xx])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Mrt-xx])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Apr-xx])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Mei-xx])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Jun-xx])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Jul-xx])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Aug-xx])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Sep-xx])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Okt-xx])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Nov-xx])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Dec-xx])","v":0},{"$f":"SUBTOTAL(109,Onkosten[Totaal])","v":0}]
[null,"KASUITGAVEN"," ","Jan-xx","Feb-xx","Mrt-xx","Apr-xx","Mei-xx","Jun-xx","Jul-xx","Aug-xx","Sep-xx","Okt-xx","Nov-xx","Dec-xx","Totaal"]
[null,"Betaling hoofdsom lening",{"$nulls":13},{"$f":"SUM(D48:O48)","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":"Onkosten[[#Totals],[Jan-xx]]+SUBTOTAL(109,Kasuitgaven[Jan-xx])","v":0},{"$f":"Onkosten[[#Totals],[Feb-xx]]+SUBTOTAL(109,Kasuitgaven[Feb-xx])","v":0},{"$f":"Onkosten[[#Totals],[Mrt-xx]]+SUBTOTAL(109,Kasuitgaven[Mrt-xx])","v":0},{"$f":"Onkosten[[#Totals],[Apr-xx]]+SUBTOTAL(109,Kasuitgaven[Apr-xx])","v":0},{"$f":"Onkosten[[#Totals],[Mei-xx]]+SUBTOTAL(109,Kasuitgaven[Mei-xx])","v":0},{"$f":"Onkosten[[#Totals],[Jun-xx]]+SUBTOTAL(109,Kasuitgaven[Jun-xx])","v":0},{"$f":"Onkosten[[#Totals],[Jul-xx]]+SUBTOTAL(109,Kasuitgaven[Jul-xx])","v":0},{"$f":"Onkosten[[#Totals],[Aug-xx]]+SUBTOTAL(109,Kasuitgaven[Aug-xx])","v":0},{"$f":"Onkosten[[#Totals],[Sep-xx]]+SUBTOTAL(109,Kasuitgaven[Sep-xx])","v":0},{"$f":"Onkosten[[#Totals],[Okt-xx]]+SUBTOTAL(109,Kasuitgaven[Okt-xx])","v":0},{"$f":"Onkosten[[#Totals],[Nov-xx]]+SUBTOTAL(109,Kasuitgaven[Nov-xx])","v":0},{"$f":"Onkosten[[#Totals],[Dec-xx]]+SUBTOTAL(109,Kasuitgaven[Dec-xx])","v":0},0]
[null,"Kassaldo (eind van de maand)",{"$f":"C18","v":0},{"$f":"D18-Kasuitgaven[[#Totals],[Jan-xx]]","v":0},{"$f":"E18-Kasuitgaven[[#Totals],[Feb-xx]]","v":0},{"$f":"F18-Kasuitgaven[[#Totals],[Mrt-xx]]","v":0},{"$f":"G18-Kasuitgaven[[#Totals],[Apr-xx]]","v":0},{"$f":"H18-Kasuitgaven[[#Totals],[Mei-xx]]","v":0},{"$f":"I18-Kasuitgaven[[#Totals],[Jun-xx]]","v":0},{"$f":"J18-Kasuitgaven[[#Totals],[Jul-xx]]","v":0},{"$f":"K18-Kasuitgaven[[#Totals],[Aug-xx]]","v":0},{"$f":"L18-Kasuitgaven[[#Totals],[Sep-xx]]","v":0},{"$f":"M18-Kasuitgaven[[#Totals],[Okt-xx]]","v":0},{"$f":"N18-Kasuitgaven[[#Totals],[Nov-xx]]","v":0},{"$f":"O18-Kasuitgaven[[#Totals],[Dec-xx]]","v":0}]
[]
[null,"ANDERE OPERATIONELE GEGEVENS"," ","Jan-xx","Feb-xx","Mrt-xx","Apr-xx","Mei-xx","Jun-xx","Jul-xx","Aug-xx","Sep-xx","Okt-xx","Nov-xx","Dec-xx","Totaal"]
[null,"Omzetvolume (dollar)",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[Jan-xx]:[Dec-xx]])","v":0}]
[null,"Debiteurensaldo",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[Dec-xx]])","v":0}]
[null,"Saldo slechte schulden",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[Dec-xx]])","v":0}]
[null,"Beschikbare voorraad",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[Dec-xx]])","v":0}]
[null,"Saldo crediteuren",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[ ]:[Dec-xx]])","v":0}]
[null,"Afschrijving",{"$nulls":13},{"$f":"SUM(OtherOperationalData[[#This Row],[Jan-xx]:[Dec-xx]])","v":0}]

{"sheet":"Cashflowgrafiek","index":1,"n_rows":2,"n_cols":7,"rows_kept":2,"merged":[[1,1,1,5],[53,2,53,3]]}
[]
[null,"Waarschuwing minimaal kassaldo:",{"$nulls":4},{"$f":"[0]!Cash_minimum","v":{"v":0,"d":"€ 0"}}]