{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"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":"Sheet1","index":0,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,1,2,7],[13,1,14,1],[20,1,20,7],[31,1,32,1],[37,1,37,7],[38,1,38,7],[39,1,39,7]]}
[null,"Enkel de gele cellen aanpassen"]
[]
[null,"JE INKOMSTEN BEREKENEN VANAF DE TOTAALPRIJS VOOR DE CONSUMENT"]
[]
[null,null,null,"BTW 21 %",null,"BTW 9 %",null,"Geen BTW***"]
[null,"Totaalprijs voor de Consument (incl. BTW)",null,9.0,null,39.2,null,9.0]
[null,"BTW",null,{"$f":"D6-D8","v":1.561983471},null,{"$f":"F6-F8","v":3.236697248},null,{"$f":"H6-H8","v":0}]
[null,"Prijs zonder belastingen (excl. BTW)",null,{"$f":"D6/1.21","v":7.438016529},null,{"$f":"F6/1.09","v":35.96330275},null,{"$f":"H6","v":9}]
[null,"Vergoeding Buurderij-Verantwoordelijke (excl. BTW)",null,{"$f":"D8*0.1","v":0.7438016529},null,{"$f":"F8*0.1","v":3.596330275},null,{"$f":"H8*0.1","v":0.9},null,null,null,{"$f":"F9/F8","v":0.1}]
[null,"Vergoeding Boeren & Buren (excl. BTW)",null,{"$f":"D8*0.13","v":0.9669421488},null,{"$f":"F8*0.13","v":4.675229358},null,{"$f":"H8*0.13","v":1.17},null,null,null,{"$f":"F10/F8","v":0.13}]
[null,"Je inkomsten na belastingen",null,{"$f":"D8-D9-D10","v":5.727272727},null,{"$f":"F8-F9-F10","v":27.69174312},null,{"$f":"H8-H9-H10","v":6.93},null,null,null,"BTW verschil producent",{"$f":"F13-F14","v":3.236697248}]
[{"$nulls":11},"Totaal producent",{"$f":"F11+M11","v":30.92844037}]
[null,"Geïnde BTW",null,{"$f":"D7","v":1.561983471},null,{"$f":"F7","v":3.236697248},null,{"$f":"H7","v":0},null,null,null,"Percentage",{"$f":"M12/F6","v":0.7889908257}]
[null,"Boeren & Buren rekent geen BTW*. \nGefactureerde of te liquideren BTW door de Buurderij-Verantwoordelijke** ",null,{"$f":"D10*0","v":0},null,{"$f":"F10*0","v":0},null,{"$f":"H10*0","v":0},{"$nulls":4},{"$f":"F14/F8","v":0},{"$f":"0.0835*0.21","v":0.017535}]
[null,null,"of",{"$f":"D9*0.21","v":0.1561983471},null,{"$f":"F9*0.21","v":0.7552293578},null,{"$f":"H9*0.21","v":0.189},{"$nulls":4},{"$f":"F15/F8","v":0.021},{"$f":"0.0835*0.21*2","v":0.03507}]
[]
[null,"Wat op je rekening wordt gestort",null,{"$f":"D6-D9-D10-D14","v":7.289256198},null,{"$f":"F6-F9-F10-F14","v":30.92844037},null,{"$f":"H6-H9-H10-H14","v":6.93}]
[null,null,"of",{"$f":"D6-D9-D10-D15","v":7.133057851},null,{"$f":"F6-F9-F10-F15","v":30.17321101},null,{"$f":"H6-H9-H10-H15","v":6.741},null,null,null,{"$f":"F17/F6","v":0.7889908257},"Percentage voor producent"]
[{"$nulls":5},{"$f":"F8-F9-F10+F13-F15","v":30.17321101}]
[{"$nulls":5},{"$f":"F8-F9-F10+F13-F14","v":30.92844037}]
[null,"DE PRIJS VOOR DE CONSUMENT BEREKENEN OP BASIS VAN JE INKOMSTEN NA BELASTINGEN"]
[]
[null,null,null,"BTW 21 %",null,"BTW 9 %",null,"Geen BTW***"]
[null,"Je inkomsten na belastingen",null,5.73,null,80.0,null,80.0,null,null,null,{"$f":"F24/F27","v":0.77}]
[null,"Vergoeding Buurderij-Verantwoordelijke (excl. BTW)",null,{"$f":"D27*0.1","v":0.7441558442},null,{"$f":"F27*0.1","v":10.38961039},null,{"$f":"H27*0.1","v":10.38961039},null,null,null,{"$f":"F25/F27","v":0.1}]
[null,"Vergoeding Boeren & Buren (excl. BTW)",null,{"$f":"D27*0.13","v":0.9674025974},null,{"$f":"F27*0.13","v":13.50649351},null,{"$f":"H27*0.13","v":13.50649351},null,null,null,{"$f":"F26/F27","v":0.13}]
[null,"Prijs zonder belastingen (excl. BTW)",null,{"$f":"D24/0.77","v":7.441558442},null,{"$f":"F24/0.77","v":103.8961039},null,{"$f":"H24/0.77","v":103.8961039}]
[null,"BTW",null,{"$f":"D27*0.21","v":1.562727273},null,{"$f":"F27*0.09","v":9.350649351},null,{"$f":"H29*0","v":0}]
[null,"Totaalprijs voor de Consument (incl. BTW)",null,{"$f":"D27*1.21","v":9.004285714},null,{"$f":"F27+F28","v":113.2467532},null,{"$f":"H27","v":103.8961039}]
[]
[null,"Geïnde BTW",null,{"$f":"D28","v":1.562727273},null,{"$f":"F28","v":9.350649351},null,{"$f":"H28","v":0}]
[null,"Boeren & Buren rekent geen BTW*. \nGefactureerde of te liquideren BTW door de Buurderij-Verantwoordelijke** ",null,{"$f":"D26*0","v":0},null,{"$f":"F26*0","v":0},null,{"$f":"H26*0","v":0}]
[null,null,"of",{"$f":"D25*0.21","v":0.1562727273},null,{"$f":"F25*0.21","v":2.181818182},null,{"$f":"H25*0.21","v":2.181818182}]
[]
[null,"Wat op je rekening wordt gestort",null,{"$f":"D29-D26-D25-D33","v":7.136454545},null,{"$f":"F29-F26-F25-F33","v":87.16883117},null,{"$f":"H29-H26-H25-H33","v":77.81818182}]
[null,null,"of",{"$f":"D29-D26-D25-D32","v":7.292727273},null,{"$f":"F29-F26-F25-F32","v":89.35064935},null,{"$f":"H29-H26-H25-H32","v":80}]
[]
[null,"*De vergoeding van de diensten aangeboden door Boeren & Buren wordt voorlopig gefactureerd door Equanum BVBA (een Belgische onderneming), die gezien het een intracommunautaire transactie betreft, vrijgesteld is van BTW. \n"]
[null,"**De BTW wordt gefactureerd als je Buurderij-Verantwoordelijke een Nederlandse onderneming heeft die BTW-plichtig is (tarief van 21 % op de vergoeding voor diensten). Houd er rekening mee dat een deel van de Buurderij-Verantwoordelijken geen BTW factureren."]
[null,"*** Als je niet BTW-plichtig bent, zal je de gefactureerde BTW door de Buurderij-Verantwoordelijke en/of Boeren & Buren niet kunnen inbrengen. Gelieve hier rekening mee te houden tijdens het berekenen van je marges."]