{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Home","input"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Home","index":0,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,15,16,16],[17,15,17,16],[14,16,14,17],[17,2,17,8],[15,16,15,17]]}
["input"]
[]
[]
[null,null,"Car capital contribution calculator"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last updated:",null,"2024-03-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"} copyright"]
[null,null,"39-41 Bank Street § Ashford § Kent TN23 1DQ § ",null,null,null,null,null,null,null,null,null,null,null,null,"} disclaimer"]

{"sheet":"input","index":1,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"total"]
[null,"Car capital contribution calculator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P4-1","v":2022}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+whatyear(TODAY())","v":2023},null,"Scotland"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+#REF!+1","v":{"$error":"#REF!"}}]
[null,"Director / employee tax saving",null,null,null,null,null,null,null,"£"]
[null,"Capital contribution to cost of car",null,null,null,null,null,null,null,0]
[]
[null,"Benefit-in-kind percentage based on CO2 emissions",null,null,null,null,null,null,null,0.15]
[]
[null,"Annual reduction in benefit-in-kind resulting from contribution",null,null,null,null,null,null,null,{"$f":"+MIN(J7,5000)*J9","v":0},null,{"$f":"+IF(J7>5000,\"Contribution limited to £5,000\",\"\")","v":""}]
[]
[null,"Highest rate of tax payable by director / employee",null,null,null,null,null,null,null,0.2]
[]
[null,"Tax saved per year by director / employee",null,null,null,null,null,null,null,{"$f":"+J13*J11","v":0}]
[]
[]
[]
[null,"Employer's National Insurance saving"]
[]
[null,"Employer's saving per year resulting from capital contribution",null,null,null,null,null,null,null,{"$f":"+J11*dc(\"NIC_ER\",whatyear(TODAY()))","v":0}]