{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Personbiler","Varebiler","Motorcykler","Autocamper","Veteranbiler","Veteranmotorcykler"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Personbiler","index":0,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[[4,0,4,2],[10,0,10,2]]}
[]
[]
[]
[]
["Køretøj - tekniske oplysninger"]
["CO2-udslip (WLTP-målt)",0,"g / km"]
["Elektrisk forbrug",0,"Wh / km"]
["Elektrisk rækkevidde",0]
["Batterikapacitet",{"$f":"B7/1000*B8","v":0},"kWh"]
[]
["Registreringsafgift"]
["Prisoplysninger","NYT","BRUGT"]
["Handelspris",null,0]
["Nypris",null,0]
["Bruttoafgiftspligtig værdi",0,0,{"$f":"IFERROR((C13/C14),1)","v":1}]
[]
["Regulering til afgiftspligtig værdi"]
["Batterikapacitetsfradrag",{"$f":"IF(B6<50,MIN($B$9,45)*-1700,0)","v":0},{"$f":"IF(B6<50,MIN($B$9,45)*-1700,0)","v":0}]
["Afgiftspligtig værdi",{"$f":"B15+B18","v":0},{"$f":"C15+C18","v":0}]
[]
["Afgift (25 %) af afgiftspligtig værdi op til 65.000",{"$f":"MIN(B19,65000)*25%","v":0},{"$f":"MIN(C19,65000*IFERROR((C13/C14),1))*25%","v":0}]
["Afgift (85 %) af afgiftspligtig værdi ml. 65.000 og 202.200",{"$f":"MAX(MIN(B19,202200)-65000,0)*85%","v":0},{"$f":"MAX(MIN(C19,202200*IFERROR((C13/C14),1))-(65000*IFERROR((C13/C14),1)),0)*85%","v":0}]
["Afgift (150 %) af afgiftspligtig værdi over 202.200",{"$f":"MAX(B19-202200,0)*150%","v":0},{"$f":"MAX(C19-(202200*IFERROR((C13/C14),1)),0)*150%","v":0}]
["Bruttoafgift",{"$f":"SUM(B21:B23)","v":0},{"$f":"SUM(C21:C23)","v":0}]
[]
["Regulering til afgiften"]
["CO2-tillæg 1 (250 kr. af op til og med 125 g.)",{"$f":"MAX((MIN($B$6,125)-0),0)*250","v":0},{"$f":"MAX((MIN($B$6,125)-0),0)*(250*IFERROR((C13/C14),1))","v":0}]
["CO2-tillæg 2 (500 kr. udledning mellem 126 og 160 g.)",{"$f":"MAX((MIN($B$6,160)-125),0)*500","v":0},{"$f":"MAX((MIN($B$6,160)-125),0)*(500*IFERROR((C13/C14),1))","v":0}]
["CO2-tillæg 3 (950 kr. af udledning over 160 g.)",{"$f":"MAX((MIN($B$6,1000)-160),0)*950","v":0},{"$f":"MAX((MIN($B$6,1000)-160),0)*(950*IFERROR((C13/C14),1))","v":0}]
["CO2-tillæg",{"$f":"SUM(B27:B29)","v":0},{"$f":"SUM(C27:C29)","v":0}]
[]
["Registreringsafgift",{"$f":"B24+B30","v":0},{"$f":"C24+C30","v":0}]
["Bundfradrag",{"$f":"-MIN(21700,B32)","v":0},{"$f":"-MIN(21700*IFERROR((C13/C14),1),C32)","v":0}]
["Registreringsafgift før evt. indfasning",{"$f":"MAX(B32+B33,0)","v":0},{"$f":"C32+C33","v":0}]
[{"$f":"\"Indfasning (\"&IF($B$6=0,40,IF($B$6<50,45,100))&\"%) af registreringsafgift\"","v":"Indfasning (40%) af registreringsafgift"},{"$f":"IF($B$6=0,40%,IF($B$6<50,45%,1))*B34","v":0},{"$f":"IF($B$6=0,40%,IF($B$6<50,45%,1))*C34","v":0}]
["Ekstra bundfradrag",{"$f":"MAX(-B35,IF($B$6=0,-170000,IF($B$6<50,-50000,0)))","v":0},{"$f":"MAX(-C35,IF($B$6=0,-170000*IFERROR((C13/C14),1),IF($B$6<50,-50000*IFERROR((C13/C14),1),0)))","v":0}]
["ENDELIG REGISTRERINGSAFGIFT",{"$f":"SUM(B35:B36)","v":0},{"$f":"SUM(C35:C36)","v":0}]
["Målsøgning til brug for brugte",null,{"$f":"C39-C13","v":0},"NB! Tryk beregn ovenfor."]
["Køretøjets pris inkl. registreringsafgift",{"$f":"B15+B37","v":0},{"$f":"C15+C37","v":0}]

{"sheet":"Varebiler","index":1,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,0,4,2],[12,0,12,2]]}
[]
[]
[]
[]
["Køretøj - tekniske oplysninger"]
["CO2-emission",0,"g / km"]
["Elektrisk forbrug",0,"Wh / km"]
["Elektrisk rækkevidde",0,"km"]
["Batterikapacitet",{"$f":"B7/1000*B8","v":0},"kWh"]
["Totalvægt",null,"kg"]
["Åben, eller uden sideruder bag førersædet?","Nej"]
[]
["Registreringsafgift"]
["Prisoplysninger","NYT","BRUGT"]
["Handelspris",null,0,{"$f":"IFERROR((C15/C16),1)","v":1}]
["Nypris",null,0]
["Bruttoafgiftspligtig værdi",0,0]
[]
["Regulering til afgiftspligtig værdi"]
["Batterikapacitetsfradrag",{"$f":"IF(B6<50,MIN($B$9,45)*-1700,0)","v":0},{"$f":"IF(B6<50,MIN($B$9,45)*-1700,0)","v":0}]
["Afgiftspligtig værdi",{"$f":"B17+B20","v":0},{"$f":"C17+C20","v":0}]
[]
["Afgift (0 %) af afgiftspligtig værdi op til 75.000",{"$f":"MIN(B21,75000)*0%","v":0},{"$f":"MIN(C21,75000*IFERROR((C15/C16),1))*0%","v":0}]
["Afgift (50 %) af afgiftspligtig værdi over 75.000",{"$f":"MAX(B21-75000,0)*50%","v":0},{"$f":"MAX(C21-(75000*IFERROR((C15/C16),1)),0)*50%","v":0}]
["Bruttoafgift",{"$f":"SUM(B23:B24)","v":0},{"$f":"SUM(C23:C24)","v":0}]
[]
["Regulering til afgiften"]
["CO2-tillæg",{"$f":"$B$6*250","v":0},{"$f":"$B$6*(250*IFERROR((C15/C16),1))","v":0}]
["CO2-tillæg",{"$f":"SUM(B28:B28)","v":0},{"$f":"SUM(C28:C28)","v":0}]
[]
["Registreringsafgift",{"$f":"B25+B29","v":0},{"$f":"C25+C29","v":0}]
["Bundfradrag",{"$f":"-MIN(30000,B31)","v":0},{"$f":"-MIN(30000*IFERROR((C15/C16),1),C31)","v":0}]
["Registreringsafgift før evt. indfasning",{"$f":"B31+B32","v":0},{"$f":"C31+C32","v":0}]
[{"$f":"\"Indfasning (\"&IF($B$6=0,40,IF($B$6<50,45,100))&\"%) af registreringsafgift\"","v":"Indfasning (40%) af registreringsafgift"},{"$f":"IF($B$6=0,40%,IF($B$6<50,45%,1))*B33","v":0},{"$f":"IF($B$6=0,40%,IF($B$6<50,45%,1))*C33","v":0}]
["Ekstra bundfradrag",{"$f":"MAX(-B34,IF($B$6=0,-80000,IF($B$6<50,-50000,0)))","v":0},{"$f":"MAX(-C34,IF($B$6=0,-80000*IFERROR((C15/C16),1),IF($B$6<50,-50000*IFERROR((C15/C16),1),0)))","v":0}]
["ENDELIG REGISTRERINGSAFGIFT",{"$f":"IF(AND(B10>3000,B11=\"Ja\"),MIN(SUM(B34:B35),47000),SUM(B34:B35))","v":0},{"$f":"IF(AND(B10>3000,B11=\"Ja\"),MIN(SUM(C34:C35),47000*IFERROR((C15/C16),1)),SUM(C34:C35))","v":0}]
["Målsøgning til brug for brugte",null,{"$f":"C38-C15","v":0}]
["Køretøjets pris inkl. registreringsafgift",{"$f":"B17+B36","v":0},{"$f":"C17+C36","v":0}]

{"sheet":"Motorcykler","index":2,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,0,4,2]]}
[]
[]
[]
[]
["Køretøj - tekniske oplysninger"]
["El-drevet motorcykel?","Nej"]
[]
["Registreringsafgift","NYT","BRUGT"]
["Prisoplysninger"]
["Handelspris",null,0]
["Nypris",null,0]
["Bruttoafgiftspligtig værdi",0,0]
[]
["Afgiftspligtig værdi",{"$f":"B12","v":0},{"$f":"C12","v":0}]
[null,null,null,{"$f":"IFERROR((C10/C11),1)","v":1}]
["Afgift (25 %) af afgiftspligtig værdi op til 20.000",{"$f":"MIN(B14,20000)*25%","v":0},{"$f":"MIN(C14,(20000*IFERROR((C10/C11),1)))*25%","v":0}]
["Afgift (85 %) af afgiftspligtig værdi ml. 20.000 og 68.000",{"$f":"MAX(MIN(B14,68000)-20000,0)*85%","v":0},{"$f":"MAX(MIN(C14,(68000*IFERROR((C10/C11),1)))-(20000*IFERROR((C10/C11),1)),0)*85%","v":0}]
["Afgift (150 %) af afgiftspligtig værdi over 68.000",{"$f":"MAX(B14-68000,0)*150%","v":0},{"$f":"MAX(C14-(68000*IFERROR((C10/C11),1)),0)*150%","v":0}]
["Bruttoafgift",{"$f":"SUM(B16:B18)","v":0},{"$f":"SUM(C16:C18)","v":0}]
[]
["Registreringsafgift",{"$f":"IF($B$6=\"Ja\",40%*B19,B19)","v":0},{"$f":"IF($B$6=\"Ja\",40%*C19,C19)","v":0}]
["Bundfradrag",{"$f":"IF($B$6=\"Ja\",MAX(-106500,-B21),0)","v":0},{"$f":"-IF($B$6=\"Ja\",MIN(106500*IFERROR((C10/C11),1),C21),0)","v":0}]
["ENDELIG REGISTRERINGSAFGIFT",{"$f":"SUM(B21:B22)","v":0},{"$f":"SUM(C21:C22)","v":0}]
["Målsøgning til brug for brugte",null,{"$f":"C25-C10","v":0}]
["Køretøjets pris inkl. registreringsafgift",{"$f":"B12+B23","v":0},{"$f":"C12+C23","v":0}]

{"sheet":"Autocamper","index":3,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[[4,0,4,2]]}
[]
[]
[]
[]
["Køretøj - tekniske oplysninger"]
["CO2-emission",0,"g / km"]
["Elektrisk forbrug",0,"Wh / km"]
["Elektrisk rækkevidde",0,"km"]
["Batterikapacitet",{"$f":"B7/1000*B8","v":0},"kWh"]
[]
["Registreringsafgift"]
["Bilens pris før registreringsafgift","NYT","BRUGT"]
["Handelspris",null,0]
["Nypris",null,0]
["Bruttoafgiftspligtig værdi",0,0]
[]
["Regulering til afgiftspligtig værdi"]
["Værdi af beboelsesdel",0,0]
["Batterikapacitetsfradrag",{"$f":"IF(B6<50,MIN(B9,45)*-1700,0)","v":0},{"$f":"IF(B6<50,MIN(B9,45)*-1700,0)","v":0}]
["Afgiftspligtig værdi",{"$f":"MAX(B15-B18+B19,0)","v":0},{"$f":"MAX(C15-C18+C19,0)","v":0}]
[]
["Afgift (25 %) af afgiftspligtig værdi op til 65.000",{"$f":"MIN(B20,65000)*25%","v":0},{"$f":"MIN(C20,65000*IFERROR((C13/C14),1))*25%","v":0}]
["Afgift (85 %) af afgiftspligtig værdi ml. 65.000 og 202.200",{"$f":"MAX(MIN(B20,202200)-65000,0)*85%","v":0},{"$f":"MAX(MIN(C20,(202200*IFERROR((C13/C14),1)))-(65000*IFERROR((C13/C14),1)),0)*85%","v":0}]
["Afgift (150 %) af afgiftspligtig værdi over 202.200",{"$f":"MAX(B20-202200,0)*150%","v":0},{"$f":"MAX(C20-(202200*IFERROR((C13/C14),1)),0)*150%","v":0}]
["Bruttoafgift",{"$f":"SUM(B22:B24)","v":0},{"$f":"SUM(C22:C24)","v":0}]
[]
["Regulering til afgiften"]
["CO2-tillæg",{"$f":"$B$6*250","v":0},{"$f":"$B$6*(250*IFERROR((C13/C14),1))","v":0}]
["CO2-tillæg",{"$f":"B28","v":0},{"$f":"C28","v":0}]
[]
["Registreringsafgift",{"$f":"B25+B29","v":0},{"$f":"C25+C29","v":0}]
["Bundfradrag",{"$f":"-MIN(21700,B31)","v":0},{"$f":"-MIN(21700*IFERROR((C13/C14),1),C31)","v":0}]
[{"$f":"\"Indfasning (\"&IF($B$6=0,40,IF($B$6<50,45,100))&\"%) af registreringsafgift\"","v":"Indfasning (40%) af registreringsafgift"},{"$f":"IF($B$6=0,40%,IF($B$6<50,45%,1))*(B31+B32)","v":0},{"$f":"IF($B$6=0,40%,IF($B$6<50,45%,1))*(C31+C32)","v":0}]
["Ekstra bundfradrag",{"$f":"MAX(-B33,IF($B$6=0,-170000,IF($B$6<50,-50000,0)))","v":0},{"$f":"MAX(-C33,IF($B$6=0,-170000*IFERROR((C13/C14),1),IF($B$6<50,-50000*IFERROR((C13/C14),1),0)))","v":0}]
["Registreringsafgift, § 5a, stk. 2, 2. pkt.",{"$f":"SUM(B33:B34)","v":0},{"$f":"SUM(C33:C34)","v":0}]
["Registreringsafgift, § 5a, stk. 2, 3. pkt.",{"$f":"(MAX(B15-12100,0)*45%)","v":0},{"$f":"(MAX(C15-12100,0)*45%)","v":0}]
["ENDELIG REGISTRERINGSAFGIFT",{"$f":"MAX(B35:B36)","v":0},{"$f":"MAX(C35:C36)","v":0}]
[null,null,{"$f":"C39-C13","v":0}]
["Handelspris inkl. registreringsafgift",{"$f":"B15+B37","v":0},{"$f":"C15+C37","v":0}]

{"sheet":"Veteranbiler","index":4,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,0,4,2],[21,0,21,2]]}
[]
[]
[]
[]
["Registreringsafgift"]
["Prisoplysninger"]
["Handelspris"]
["Nypris"]
["Afgiftspligtig værdi som nyt"]
[]
["Afgiftspligtig værdi",{"$f":"75%*B9","v":0},{"$f":"C9","v":0}]
[]
["Afgift (25 %) af afgiftspligtig værdi op til 65.000",{"$f":"MIN(B11,65000)*25%","v":0},{"$f":"MIN(C11,65000*IFERROR((C7/C8),1))*25%","v":0}]
["Afgift (85 %) af afgiftspligtig værdi ml. 65.000 og 202.200",{"$f":"MAX(MIN(B11,202200)-65000,0)*85%","v":0},{"$f":"MAX(MIN(C11,202200*IFERROR((C7/C8),1))-(65000*IFERROR((C7/C8),1)),0)*85%","v":0}]
["Afgift (150 %) af afgiftspligtig værdi over 202.200",{"$f":"MAX(B11-202200,0)*150%","v":0},{"$f":"MAX(C11-(202200*IFERROR((C7/C8),1)),0)*150%","v":0}]
["Bruttoafgift",{"$f":"SUM(B13:B15)","v":0},{"$f":"SUM(C13:C15)","v":0}]
[]
["Registreringsafgift",{"$f":"B16","v":0},{"$f":"C16","v":0}]
["Målsøgning til brug for brugte",null,{"$f":"C20-C7","v":0}]
["Køretøjets pris inkl. registreringsafgift",null,{"$f":"C11+C18","v":0}]
[]
["For veteranbiler beregnes registreringsafgiften enten ud fra 75 % af bilens oprindelige afgiftspligtige værdi som ny, eller ud fra bilens aktuelle handelspris. Den registreringsafgift, der skal betales, vil være den laveste af de to beregnede registreringsafgifter (de grå markerede celler)."]

{"sheet":"Veteranmotorcykler","index":5,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,0,4,2],[21,0,21,2]]}
[]
[]
[]
[]
["Registreringsafgift"]
["Prisoplysninger"]
["Handelspris"]
["Nypris"]
["Afgiftspligtig værdi som nyt"]
[]
["Afgiftspligtig værdi",{"$f":"B9","v":0},{"$f":"C9","v":0}]
[null,null,null,{"$f":"IFERROR((C7/C8),1)","v":1}]
["Afgift (25 %) af afgiftspligtig værdi op til 20.000",{"$f":"MIN(B11,20000)*25%","v":0},{"$f":"MIN(C11,(20000*IFERROR((C7/C8),1)))*25%","v":0}]
["Afgift (85 %) af afgiftspligtig værdi ml. 20.000 og 68.000",{"$f":"MAX(MIN(B11,68000)-20000,0)*85%","v":0},{"$f":"MAX(MIN(C11,(68000*IFERROR((C7/C8),1)))-(20000*IFERROR((C7/C8),1)),0)*85%","v":0}]
["Afgift (150 %) af afgiftspligtig værdi over 68.000",{"$f":"MAX(B11-68000,0)*150%","v":0},{"$f":"MAX(C11-(68000*IFERROR((C7/C8),1)),0)*150%","v":0}]
["Bruttoafgift",{"$f":"SUM(B13:B15)","v":0},{"$f":"SUM(C13:C15)","v":0}]
[]
["Registreringsafgift",{"$f":"B16","v":0},{"$f":"C16","v":0}]
["Målsøgning til brug for brugte",null,{"$f":"C20-C7","v":0}]
["Køretøjets pris inkl. registreringsafgift",null,{"$f":"C9+C18","v":0}]
[]
["For veteranmotorcykler beregnes registreringsafgiften enten ud fra 40 % af motorcyklens oprindelige afgiftspligtige værdi som ny, eller ud fra motorcyklens aktuelle handelspris. Den registreringsafgift, der skal betales, vil være den laveste af de to beregnede registreringsafgifter (de grå markerede celler)."]