{"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":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,1,2,7],[13,1,14,1],[20,1,20,7],[32,1,33,1],[38,1,38,7],[39,1,39,7],[40,1,40,7]]}
[null,"Enkel de gele cellen aanpassen"]
[]
[null,"JE INKOMSTEN BEREKENEN VANAF DE TOTAALPRIJS VOOR DE CONSUMENT"]
[]
[null,null,null,"BTW 21 %",null,"BTW 6 %",null,"Geen BTW**"]
[null,"Totaalprijs voor de Consument (incl. BTW)",null,121.0,null,106.0,null,100.0]
[null,"BTW",null,{"$f":"D6-D8","v":21},null,{"$f":"F6-F8","v":6},null,{"$f":"H6-H8","v":0}]
[null,"Prijs zonder belastingen (excl. BTW)",null,{"$f":"D6/1.21","v":100},null,{"$f":"F6/1.06","v":100},null,{"$f":"H6","v":100}]
[null,"Vergoeding Buurderij-Verantwoordelijke (excl. BTW)",null,{"$f":"D8*0.0835","v":8.35},null,{"$f":"F8*0.0835","v":8.35},null,{"$f":"H8*0.0835","v":8.35},null,null,null,{"$f":"F9/F8","v":0.0835}]
[null,"Vergoeding Boeren & Buren (excl. BTW)",null,{"$f":"D8*0.1165","v":11.65},null,{"$f":"F8*0.1165","v":11.65},null,{"$f":"H8*0.1165","v":11.65},null,null,null,{"$f":"F10/F8","v":0.1165}]
[null,"Je inkomsten na belastingen",null,{"$f":"D8-D9-D10","v":80},null,{"$f":"F8-F9-F10","v":80},null,{"$f":"H8-H9-H10","v":80},null,null,null,"BTW verschil producent",{"$f":"F13-F14","v":3.5535}]
[{"$nulls":11},"Totaal producent",{"$f":"F11+M11","v":83.5535}]
[null,"Geïnde BTW",null,{"$f":"D7","v":21},null,{"$f":"F7","v":6},null,{"$f":"H7","v":0},null,null,null,"Percentage",{"$f":"M12/F6","v":0.788240566}]
[null,"Gefactureerde of te liquideren BTW door de Buurderij-Verantwoordelijke en/of Boeren & Buren*",null,{"$f":"D10*0.21","v":2.4465},null,{"$f":"F10*0.21","v":2.4465},null,{"$f":"H10*0.21","v":2.4465},{"$nulls":4},{"$f":"F14/F8","v":0.024465}]
[null,null,"of",{"$f":"D14+D9*0.21","v":4.2},null,{"$f":"F14+F9*0.21","v":4.2},null,{"$f":"H14+H9*0.21","v":4.2},{"$nulls":4},{"$f":"F15/F8","v":0.042}]
[]
[null,"Wat op je rekening wordt gestort",null,{"$f":"D6-D9-D10-D15","v":96.8},null,{"$f":"F6-F9-F10-F15","v":81.8},null,{"$f":"H6-H9-H10-H15","v":75.8}]
[null,null,"of",{"$f":"D6-D9-D10-D14","v":98.5535},null,{"$f":"F6-F9-F10-F14","v":83.5535},null,{"$f":"H6-H9-H10-H14","v":77.5535},null,null,null,{"$f":"F18/F6","v":0.788240566},"Percentage voor producent"]
[{"$nulls":5},{"$f":"F8-F9-F10+F13-F15","v":81.8}]
[{"$nulls":5},{"$f":"F8-F9-F10+F13-F14","v":83.5535}]
[null,"DE PRIJS VOOR DE CONSUMENT BEREKENEN OP BASIS VAN JE INKOMSTEN NA BELASTINGEN"]
[]
[null,null,null,"BTW",null,"BTW",null,"Geen BTW**"]
[null,null,null,0.21,null,0.06,null,0.0]
[null,"Je inkomsten na belastingen",null,{"$f":"D11","v":80},null,80.0,null,80.0,null,null,null,{"$f":"F25/F28","v":0.8}]
[null,"Vergoeding Buurderij-Verantwoordelijke (excl. BTW)",0.0835,{"$f":"D28*$C$26","v":8.35},null,{"$f":"F28*$C$26","v":8.35},null,{"$f":"H28*$C$26","v":8.35},null,null,null,{"$f":"F26/F28","v":0.0835}]
[null,"Vergoeding Boeren & Buren (excl. BTW)",0.1165,{"$f":"D28*$C$27","v":11.65},null,{"$f":"F28*$C$27","v":11.65},null,{"$f":"H28*$C$27","v":11.65},null,null,null,{"$f":"F27/F28","v":0.1165}]
[null,"Prijs zonder belastingen (excl. BTW)",null,{"$f":"D25/(1-($C$26+$C$27))","v":100},null,{"$f":"F25/(1-($C$26+$C$27))","v":100},null,{"$f":"H25/(1-($C$26+$C$27))","v":100}]
[null,"BTW",null,{"$f":"D28*D24","v":21},null,{"$f":"F28*F24","v":6},null,{"$f":"H28*H24","v":0}]
[null,"Totaalprijs voor de Consument (incl. BTW)",null,{"$f":"D28*(1+D24)","v":121},null,{"$f":"F28*(1+F24)","v":106},null,{"$f":"H28*(1+H24)","v":100}]
[]
[null,"Geïnde BTW",null,{"$f":"D29","v":21},null,{"$f":"F29","v":6},null,{"$f":"H29","v":0}]
[null,"Gefactureerde of te liquideren BTW door de Buurderij-Verantwoordelijke en/of Boeren & Buren*",null,{"$f":"D27*0.21","v":2.4465},null,{"$f":"F27*0.21","v":2.4465},null,{"$f":"H27*0.21","v":2.4465}]
[null,null,"of",{"$f":"D33+D26*0.21","v":4.2},null,{"$f":"F33+0.21*F26","v":4.2},null,{"$f":"H33+0.21*H26","v":4.2}]
[]
[null,"Wat op je rekening wordt gestort",null,{"$f":"D30-D27-D26-D34","v":96.8},null,{"$f":"F30-F27-F26-F34","v":81.8},null,{"$f":"H30-H27-H26-H34","v":75.8}]
[null,null,"of",{"$f":"D30-D27-D26-D33","v":98.5535},null,{"$f":"F30-F27-F26-F33","v":83.5535},null,{"$f":"H30-H27-H26-H33","v":77.5535}]
[]
[null,"* De BTW wordt gefactureerd als je Buurderij-Verantwoordelijke een Belgische onderneming heeft die BTW-plichtig is (tarief van 21 % op de vergoeding voor diensten). De vergoeding van de diensten aangeboden door Boeren & Buren worden gefactureerd door Equanum BVBA, die BTW-plichtig is.\nHoud er rekening mee dat een groot 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."]