{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Input","Output","Instellingen","Blad1"],"not_rendered":{"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":28,"n_cols":5,"rows_kept":28,"merged":[[9,4,9,5],[10,2,10,6]]}
[]
[]
[]
[]
[null,"Wat is voordeliger voor mij als werknemer?"]
[null," Privé leasen of via m'n werkgever"]
[]
[null,null,"Vul de lichtblauwe cellen in om te berekenen wat voor jou de voordeligste optie is."]
[null,null,"Klik daarna op de knop \"Start\" om de berekening te starten. "]
[]
[null,null,"Gegevens auto"]
[]
[]
[null,null,"Cataloguswaarde in euro's incl BTW/BPM",null,{"v":50000,"d":"€ 50,000.00"}]
[null,null,"Leaseprijs per maand in euro's incl. BTW",null,{"v":600,"d":"€ 600.00"}]
[null,null,"Brandstofverbruik km/per liter 1 op",null,10]
[null,null,"Brandstofprijs in euro's per liter",null,{"v":1.85,"d":"€ 1.85"}]
[]
[null,null,"Gegevens privé"]
[]
[]
[null,null,"Zakelijke kilometers per jaar (aantal)",null,{"v":30000,"d":"30,000"}]
[null,null,"Privé kilometers per jaar (aantal)",null,{"v":10000,"d":"10,000"}]
[null,null,"Netto km-vergoeding per km in eurocenten",null,{"v":0.19,"d":"€ 0.19"}]
[null,null,"Eigen bijdrage per maand in euro's",null,{"v":50,"d":"€ 50"}]
[null,null,"IB-tarief ",null,{"v":0.5,"d":"50.00%"}]
[null,null,"Bijtellings % zakelijke auto",null,{"v":0.22,"d":"22%"}]
[null,null,"Werkgever betaalt brandstofkosten? ",null,"Ja"]

{"sheet":"Output","index":1,"n_rows":38,"n_cols":6,"rows_kept":38,"merged":[[9,4,9,5],[10,4,10,5],[13,2,13,6],[37,2,37,5],[38,2,38,4]]}
[]
[]
[]
[]
[null,"Wat is voordeliger voor mij als werknemer?"]
[null," Privé leasen of via m'n werkgever"]
[]
[]
[{"$nulls":3},"Uitkomst",null,{"$f":"IF(E25-E35<0,\"Auto via werkgever \",\"Privé leasen\")","v":"Auto via werkgever "}]
[{"$nulls":3},"Verschil op jaarbasis",{"$f":"IF((E25-E35)<0,(E25-E35)*-1,E25-E35)","v":{"v":3100,"d":"€ 3,100"}}]
[{"$nulls":3},"Besparing na 5 jaar",{"$f":"Output!E10*5","v":{"v":15500,"d":"€ 15,500"}}]
[]
[]
[null,null,"Berekening op jaarbasis"]
[]
[null,null,"Via m'n werkgever"]
[]
[{"$nulls":4},"Netto"]
[{"$nulls":4},"€"]
[null,null,"Eigen bijdrage bruto",null,{"$f":"Input!E25*12","v":600}]
[null,null,"Brandstofkosten (zakelijk en privé)",null,{"$f":"IF(Input!E28=\"Ja\",0,Output!E32)","v":0}]
[null,null,"Minder IB i.v.m. eigen bijdrage",null,{"$f":"IF(-(Input!E25*12)*Input!E26>Output!E23,-Output!E23,-(Input!E25*12)*Input!E26)","v":-300}]
[null,null,"Bijtelling Inkomstenbelasting",null,{"$f":"IF(Input!E23<500,0,IF(Input!E14<=50000,Input!E14*Input!E26*Input!E27,IF(AND(Input!E14>50000,Input!E26=4%),(50000*Input!E26*Input!E27)+((Input!E14-50000)*22%*Input!E26),Input!E14*22%*Input!E26)))","v":{"v":5500,"d":"5,500"}}]
[]
[null,null,"Kosten via werkgever",null,{"$f":"SUM(E20:E23)","v":{"v":5800,"d":"5,800"}}]
[]
[null,null,"Privé"]
[]
[{"$nulls":4},"Netto"]
[{"$nulls":4},"€"]
[null,null,"Leasebedrag",null,{"$f":"Input!E15*12","v":{"v":7200,"d":"7,200"}}]
[null,null,"Brandstofkosten zakelijke kilometers",null,{"$f":"((Input!E22+Input!E23)/Input!E16)*Input!E17","v":{"v":7400,"d":"7,400"}}]
[null,null,"Declareren zakelijke kilometers",null,{"$f":"-Input!E22*Input!E24","v":{"v":-5700,"d":"-5,700"}}]
[]
[null,null,"Kosten privé leasen",null,{"$f":"SUM(E31:E33)","v":{"v":8900,"d":"8,900"}}]
[]
[null,null,"IB = Inkomstenbelasting"]
[null,null,"(1) Uitgangspunt: brandstofkosten worden door werkgever betaald."]

{"sheet":"Instellingen","index":2,"n_rows":5,"n_cols":2,"rows_kept":5,"hidden":true}
[]
[]
[null,"Lijst"]
[null,"Ja"]
[null,"Nee"]

{"sheet":"Blad1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}