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

{"sheet":"Cashflowprognose","index":0,"n_rows":64,"n_cols":16,"rows_kept":64,"merged":[[4,14,5,14]]}
[{"$nulls":15}," "]
[]
[null,"Beginbedrag in contanten",{"v":10000,"d":"€ 10,000.00"},null,"Startdatum",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)","v":"2019-11-01"},null,"Waarschuwing minimaal kassaldo",null,{"v":2000,"d":"€ 2,000.00"}]
[]
[null,null,{"$f":"IF(Start_Date=\"\",\"\",Start_Date)","v":"2019-11-01"},{"$f":"IF(C5=\"\",\"\",DATE(YEAR(C5),MONTH(C5)+1,1))","v":"2019-12-01"},{"$f":"IF(D5=\"\",\"\",DATE(YEAR(D5),MONTH(D5)+1,1))","v":"2020-01-01"},"2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","Totaal"]
[null,"Kassaldo (begin van de maand)",{"$f":"C3","v":{"v":10000,"d":"€ 10,000.00"}},{"$f":"C55","v":{"v":8050,"d":"€ 8,050.00"}},{"v":9350,"d":"€ 9,350.00"},{"v":890,"d":"€ 890.00"},{"v":2190,"d":"€ 2,190.00"},{"v":13590,"d":"€ 13,590.00"},{"v":13790,"d":"€ 13,790.00"},{"v":15290,"d":"€ 15,290.00"},{"v":16410,"d":"€ 16,410.00"},{"v":14360,"d":"€ 14,360.00"},{"v":16560,"d":"€ 16,560.00"},{"v":18780,"d":"€ 18,780.00"}]
[]
[null,"Kasontvangsten"]
[]
[null,"Kasverkopen",{"v":2500,"d":"€ 2,500.00"},{"v":3000,"d":"€ 3,000.00"},{"v":3600,"d":"€ 3,600.00"},{"v":3000,"d":"€ 3,000.00"},{"v":14000,"d":"€ 14,000.00"},{"v":6000,"d":"€ 6,000.00"},{"v":3000,"d":"€ 3,000.00"},{"v":2800,"d":"€ 2,800.00"},{"v":3500,"d":"€ 3,500.00"},{"v":4000,"d":"€ 4,000.00"},{"v":3800,"d":"€ 3,800.00"},{"v":4200,"d":"€ 4,200.00"},{"$f":"SUM(C10:N10)","v":{"v":53400,"d":"€ 53,400.00"}}]
[null,"Retouren en vergoedingen",null,null,{"v":200,"d":"€ 200.00"},{"$nulls":9},{"v":200,"d":"€ 200.00"}]
[null,"Inningen op vorderingen",{"$nulls":12},0]
[null,"Rente, overige inkomsten",{"$nulls":12},0]
[null,"Leningopbrengsten",{"$nulls":12},0]
[null,"Eigenaarsbijdragen",{"$nulls":12},0]
[null,"Overige ontvangstbewijzen",{"$nulls":12},0]
[null,"Totaal kasontvangsten",{"$f":"SUM(C10,C12:C16,(C11*-1))","v":{"v":2500,"d":"€ 2,500.00"}},{"$f":"SUM(D10,D12:D16,(D11*-1))","v":{"v":3000,"d":"€ 3,000.00"}},{"v":3400,"d":"€ 3,400.00"},{"v":3000,"d":"€ 3,000.00"},{"v":14000,"d":"€ 14,000.00"},{"v":6000,"d":"€ 6,000.00"},{"v":3000,"d":"€ 3,000.00"},{"v":2800,"d":"€ 2,800.00"},{"v":3500,"d":"€ 3,500.00"},{"v":4000,"d":"€ 4,000.00"},{"v":3800,"d":"€ 3,800.00"},{"v":4200,"d":"€ 4,200.00"},{"$f":"SUM(O10:O16)","v":{"v":53600,"d":"€ 53,600.00"}}]
[null,"Totaal beschikbaar kas",{"$f":"(C6+C17)","v":{"v":12500,"d":"€ 12,500.00"}},{"v":11050,"d":"€ 11,050.00"},{"v":12750,"d":"€ 12,750.00"},{"v":3890,"d":"€ 3,890.00"},{"v":16190,"d":"€ 16,190.00"},{"v":19590,"d":"€ 19,590.00"},{"v":16790,"d":"€ 16,790.00"},{"v":18090,"d":"€ 18,090.00"},{"v":19910,"d":"€ 19,910.00"},{"v":18360,"d":"€ 18,360.00"},{"v":20360,"d":"€ 20,360.00"},{"v":22980,"d":"€ 22,980.00"}]
[]
[null,"Kasuitgaven"]
[]
[null,"Reclame",{"v":3000,"d":"€ 3,000.00"},{"$nulls":11},{"$f":"SUM(C22:N22)","v":{"v":3000,"d":"€ 3,000.00"}}]
[null,"Commissies en kosten",{"v":250,"d":"€ 250.00"},{"v":300,"d":"€ 300.00"},{"v":360,"d":"€ 360.00"},{"v":300,"d":"€ 300.00"},{"v":1400,"d":"€ 1,400.00"},{"v":400,"d":"€ 400.00"},{"v":300,"d":"€ 300.00"},{"v":280,"d":"€ 280.00"},{"v":350,"d":"€ 350.00"},{"v":400,"d":"€ 400.00"},{"v":380,"d":"€ 380.00"},{"v":420,"d":"€ 420.00"},{"v":5140,"d":"€ 5,140.00"}]
[null,"Contractarbeid",null,{"v":200,"d":"€ 200.00"},null,{"v":200,"d":"€ 200.00"},null,{"v":200,"d":"€ 200.00"},null,{"v":200,"d":"€ 200.00"},null,{"v":200,"d":"€ 200.00"},null,{"v":200,"d":"€ 200.00"},{"v":1200,"d":"€ 1,200.00"}]
[null,"Personeelsvoorzieningen",{"$nulls":12},0]
[null,"Verzekering (anders dan gezondheidsverzekering)",null,null,{"v":4000,"d":"€ 4,000.00"},null,null,{"v":4000,"d":"€ 4,000.00"},null,null,{"v":4000,"d":"€ 4,000.00"},null,null,{"v":4000,"d":"€ 4,000.00"},{"v":16000,"d":"€ 16,000.00"}]
[null,"Renteuitgaven",{"$nulls":12},0]
[null,"Materiaal en voorraad (in COGS)",{"v":1200,"d":"€ 1,200.00"},{"v":1200,"d":"€ 1,200.00"},{"v":7500,"d":"€ 7,500.00"},{"v":1200,"d":"€ 1,200.00"},{"v":1200,"d":"€ 1,200.00"},{"v":1200,"d":"€ 1,200.00"},{"v":1200,"d":"€ 1,200.00"},{"v":1200,"d":"€ 1,200.00"},{"v":1200,"d":"€ 1,200.00"},{"v":1200,"d":"€ 1,200.00"},{"v":1200,"d":"€ 1,200.00"},{"v":1200,"d":"€ 1,200.00"},{"v":20700,"d":"€ 20,700.00"}]
[null,"Maaltijden en amusement",{"$nulls":12},0]
[null,"Hypotheekrente",{"$nulls":12},0]
[null,"Kantooruitgaven",{"$nulls":12},0]
[null,"Renteuitgaven",{"$nulls":12},0]
[null,"Pensioen en winstdelingsregeling",{"$nulls":12},0]
[null,"Aankopen voor wederverkoop",{"$nulls":12},0]
[null,"Huur of lease",{"$nulls":12},0]
[null,"Huur of lease: voertuigen, apparatuur",{"$nulls":12},0]
[null,"Reparatie en onderhoud",{"$nulls":12},0]
[null,"Voorraad (niet in de COGS)",{"$nulls":12},0]
[null,"Belastingen en licenties",{"$nulls":12},0]
[null,"Reiskosten",{"$nulls":12},0]
[null,"Gas, water en elektra",{"$nulls":12},0]
[null,"Salarissen (exclusief arbeidskrediet)",{"$nulls":12},0]
[null,"Overige uitgaven",{"$nulls":12},0]
[null,"Overige uitgaven",{"$nulls":12},0]
[null,"Overige uitgaven",{"$nulls":12},0]
[null,"Diversen",{"$nulls":12},0]
[null,"Subtotaal",{"$f":"SUM(C22:C46)","v":{"v":4450,"d":"€ 4,450.00"}},{"v":1700,"d":"€ 1,700.00"},{"v":11860,"d":"€ 11,860.00"},{"v":1700,"d":"€ 1,700.00"},{"v":2600,"d":"€ 2,600.00"},{"v":5800,"d":"€ 5,800.00"},{"v":1500,"d":"€ 1,500.00"},{"v":1680,"d":"€ 1,680.00"},{"v":5550,"d":"€ 5,550.00"},{"v":1800,"d":"€ 1,800.00"},{"v":1580,"d":"€ 1,580.00"},{"v":5820,"d":"€ 5,820.00"},{"v":46040,"d":"€ 46,040.00"}]
[]
[null,"Betaling hoofdsom lening",{"$nulls":12},0]
[null,"Vermogensaankopen",{"$nulls":12},0]
[null,"Overige opstartkosten",{"$nulls":12},0]
[null,"Ter voorziening en/of zekerheidstelling",{"$nulls":12},0]
[null,"Opname door eigenaren",{"$nulls":12},0]
[null,"Totaal uitgegeven geld",{"$f":"C47-SUM(C49:C53)","v":{"v":4450,"d":"€ 4,450.00"}},{"$f":"D47-SUM(D49:D53)","v":{"v":1700,"d":"€ 1,700.00"}},{"v":11860,"d":"€ 11,860.00"},{"v":1700,"d":"€ 1,700.00"},{"v":2600,"d":"€ 2,600.00"},{"v":5800,"d":"€ 5,800.00"},{"v":1500,"d":"€ 1,500.00"},{"v":1680,"d":"€ 1,680.00"},{"v":5550,"d":"€ 5,550.00"},{"v":1800,"d":"€ 1,800.00"},{"v":1580,"d":"€ 1,580.00"},{"v":5820,"d":"€ 5,820.00"},{"$f":"SUM(O47,O49:O53)","v":{"v":46040,"d":"€ 46,040.00"}}]
[null,"Kassaldo (eind van de maand)",{"$f":"(C18-C54)","v":{"v":8050,"d":"€ 8,050.00"}},{"v":9350,"d":"€ 9,350.00"},{"v":890,"d":"€ 890.00"},{"v":2190,"d":"€ 2,190.00"},{"v":13590,"d":"€ 13,590.00"},{"v":13790,"d":"€ 13,790.00"},{"v":15290,"d":"€ 15,290.00"},{"v":16410,"d":"€ 16,410.00"},{"v":14360,"d":"€ 14,360.00"},{"v":16560,"d":"€ 16,560.00"},{"v":18780,"d":"€ 18,780.00"},{"v":17160,"d":"€ 17,160.00"}]
[]
[null,"Andere operationele gegevens"]
[]
[null,"Omzetvolume (dollar)"]
[null,"Debiteurensaldo"]
[null,"Saldo slechte schulden"]
[null,"Beschikbare voorraad"]
[null,"Saldo crediteuren"]
[null,"Afschrijving"]

{"sheet":"Cashflowgrafiek","index":1,"n_rows":15,"n_cols":15,"rows_kept":15}
[{"$nulls":11}," "]
[]
[null,"Maand","Contant geld",{"$nulls":9},{"$f":"B3","v":"Maand"},"Niet onder minimum","Onder minimum"]
[null,{"$f":"Cashflowprognose!C5","v":"2019-11-01"},{"$f":"Cashflowprognose!C6","v":{"v":10000,"d":"€ 10,000.00"}},{"$nulls":9},{"$f":"B4","v":"2019-11-01"},{"$f":"IF(C4<Cash_Minimum,0,C4)","v":{"v":10000,"d":"€ 10,000.00"}},{"$f":"IF(C4<Cash_Minimum,C4,0)","v":0}]
[null,{"$f":"Cashflowprognose!D5","v":"2019-12-01"},{"$f":"Cashflowprognose!D6","v":{"v":8050,"d":"€ 8,050.00"}},{"$nulls":9},"2019-12-01",{"v":8050,"d":"€ 8,050.00"},0]
[null,{"$f":"Cashflowprognose!E5","v":"2020-01-01"},{"$f":"Cashflowprognose!E6","v":{"v":9350,"d":"€ 9,350.00"}},{"$nulls":9},"2020-01-01",{"v":9350,"d":"€ 9,350.00"},0]
[null,{"$f":"Cashflowprognose!F5","v":"2020-02-01"},{"$f":"Cashflowprognose!F6","v":{"v":890,"d":"€ 890.00"}},{"$nulls":9},"2020-02-01",0,{"v":890,"d":"€ 890.00"}]
[null,{"$f":"Cashflowprognose!G5","v":"2020-03-01"},{"$f":"Cashflowprognose!G6","v":{"v":2190,"d":"€ 2,190.00"}},{"$nulls":9},"2020-03-01",{"v":2190,"d":"€ 2,190.00"},0]
[null,{"$f":"Cashflowprognose!H5","v":"2020-04-01"},{"$f":"Cashflowprognose!H6","v":{"v":13590,"d":"€ 13,590.00"}},{"$nulls":9},"2020-04-01",{"v":13590,"d":"€ 13,590.00"},0]
[null,{"$f":"Cashflowprognose!I5","v":"2020-05-01"},{"$f":"Cashflowprognose!I6","v":{"v":13790,"d":"€ 13,790.00"}},{"$nulls":9},"2020-05-01",{"v":13790,"d":"€ 13,790.00"},0]
[null,{"$f":"Cashflowprognose!J5","v":"2020-06-01"},{"$f":"Cashflowprognose!J6","v":{"v":15290,"d":"€ 15,290.00"}},{"$nulls":9},"2020-06-01",{"v":15290,"d":"€ 15,290.00"},0]
[null,{"$f":"Cashflowprognose!K5","v":"2020-07-01"},{"$f":"Cashflowprognose!K6","v":{"v":16410,"d":"€ 16,410.00"}},{"$nulls":9},"2020-07-01",{"v":16410,"d":"€ 16,410.00"},0]
[null,{"$f":"Cashflowprognose!L5","v":"2020-08-01"},{"$f":"Cashflowprognose!L6","v":{"v":14360,"d":"€ 14,360.00"}},{"$nulls":9},"2020-08-01",{"v":14360,"d":"€ 14,360.00"},0]
[null,{"$f":"Cashflowprognose!M5","v":"2020-09-01"},{"$f":"Cashflowprognose!M6","v":{"v":16560,"d":"€ 16,560.00"}},{"$nulls":9},"2020-09-01",{"v":16560,"d":"€ 16,560.00"},0]
[null,{"$f":"Cashflowprognose!N5","v":"2020-10-01"},{"$f":"Cashflowprognose!N6","v":{"v":18780,"d":"€ 18,780.00"}},{"$nulls":9},"2020-10-01",{"v":18780,"d":"€ 18,780.00"},0]