{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Home","xxxSheet1","input","report","tax_efficient","xxxcharts","info_input"],"not_rendered":{"charts":8,"images":11,"macros":1,"external_links":0,"defined_names":8,"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,2,17,14],[17,15,17,16],[14,15,14,17],[14,13,14,14],[15,16,15,17]]}
[{"$f":"+IF(LEFT(input!E4,1)=\"S\",\"S_\",\"\")","v":""},"input"]
[]
["BUSINC"]
["2020-03-13",null,"Business incorporation calculator"]
[1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"xxxSheet1","index":1,"n_rows":22,"n_cols":86,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["year","year_name","last_updated","PA","PAT","PAR","SRB","SR","BRB","BR","HRB","HR","AR","DSR","DBR","DHR","DAR","div_allce","sav_allce_BR","sav_allce_HR","LBRB","LBR","UBRB","UBR","OROI","fuel_bik","CGT_LR","CGT_HR","CGT_ER","CGT_AEA","CGT_LRR","CGT_HRR","CT_SPR","CT_MCR","CT_MRF","CT_MRLT","CT_MRUT","CA_MR","CA_SR","NIC_PT","NIC_UEL","NIC_LR","NIC_UR","NIC_ST","NIC_ER","NIC_PT_W","NIC_UEL_W","NIC_LPL","NIC_UPL","NIC_SE1","NIC_SE2","NIC_C2","NIC_C2_EXEMPT","VAT_SR","VAT_RR","S_PA","S_PAT","S_PAR","S_SRB","S_SR","S_BRB","S_BR","S_HRB","S_HR","S_AR","S_ARB","S_TR","S_DSR","S_DBR","S_DHR","S_DAR","S_div_allce","S_sav_allce_BR","S_sav_allce_HR","S_LBRB","S_LBR","S_UBRB","S_UBR","nrb","rate","gross_up","IHT_MRNRB","HICBC_threshold","HICBC_limit","HICBC_divider","HICBC_rate"]
[2022,"2022/2023","2022-03-24",12570,100000,0.5,5000,0,32700,0.2,112300,0.4,0.45,0,8.7499999999999994E-2,0.33750000000000002,0.39350000000000002,2000,1000,500,0,0,0,0,2.5000000000000001E-2,25300,0.1,0.2,0.1,12300,0.18,0.28000000000000003,0.19,0.19,0,300000,1500000,0.18,0.06,9880,50270,0.13250000000000001,3.2500000000000001E-2,9100,0.15049999999999999,190,967,11908,50270,0.10249999999999999,3.2500000000000001E-2,3.15,6725,0.2,0.05,12570,100000,0.5,0,0,10956,0.2,118908,0.41,0.46,null,null,7.4999999999999997E-2,8.7499999999999994E-2,0.33750000000000002,0.39350000000000002,2000,1000,500,2162,0.19,17974,0.21,325000,0.4,0.25,175000,50000,60000,100,0.01]
[2021,"2021/2022","2021-02-28",12570,100000,0.5,5000,0,32700,0.2,112300,0.4,0.45,0,7.4999999999999997E-2,0.32500000000000001,0.38100000000000001,2000,1000,500,0,0,0,0,2.5000000000000001E-2,24600,0.1,0.2,0.1,12300,0.18,0.28000000000000003,0.19,0.19,0,300000,1500000,0.18,0.06,9568,50270,0.12,0.02,8840,0.13800000000000001,184,967,9568,50270,0.09,0.02,3.05,6515,0.2,0.05,12570,100000,0.5,0,0,10629,0.2,118908,0.41,0.46,null,null,7.4999999999999997E-2,7.4999999999999997E-2,0.32500000000000001,0.38100000000000001,2000,1000,500,2097,0.19,18366,0.21,325000,0.4,0.25,175000,50000,60000,100,0.01]
[2020,"2020/2021","2020-03-22",12500,100000,0.5,5000,0,32500,0.2,112500,0.4,0.45,0,7.4999999999999997E-2,0.32500000000000001,0.38100000000000001,2000,1000,500,0,0,0,0,2.5000000000000001E-2,24500,0.1,0.2,0.1,12300,0.18,0.28000000000000003,0.19,0.19,0,300000,1500000,0.18,0.06,9500,50000,0.12,0.02,8788,0.13800000000000001,183,962,9500,50000,0.09,0.02,3.05,6475,0.2,0.05,12500,100000,0.5,0,0,10573,0.2,119070,0.41,0.46,null,null,7.4999999999999997E-2,7.4999999999999997E-2,0.32500000000000001,0.38100000000000001,2000,1000,500,2086,0.19,18272,0.21,325000,0.4,0.25,175000,50000,60000,100,0.01]
[2019,"2019/2020","2019-05-04",12500,100000,0.5,5000,0,32500,0.2,112500,0.4,0.45,0,7.4999999999999997E-2,0.32500000000000001,0.38100000000000001,2000,1000,500,0,0,0,0,2.5000000000000001E-2,24100,0.1,0.2,0.1,12000,0.18,0.28000000000000003,0.19,0.19,0,300000,1500000,0.18,0.06,8632,50000,0.12,0.02,8632,0.13800000000000001,166,962,8632,50000,0.09,0.02,3,6365,0.2,0.05,12500,100000,0.5,0,0,10395,0.2,119070,0.41,0.46,null,null,7.4999999999999997E-2,7.4999999999999997E-2,0.32500000000000001,0.38100000000000001,2000,1000,500,2049,0.19,18486,0.21,325000,0.4,0.25,150000,50000,60000,100,0.01]
[2012,"2012/2013","2018-05-04",8105,100000,0.5,2710,0.1,31660,0.2,115630,0.4,0.5,0.1,0.1,0.32500000000000001,0.42499999999999999,0,0,0,0,0,0,0,0.03,0,0.18,0.28000000000000003,0.1,10600,0.18,0.28000000000000003,0.2,0.24,0.01,300000,1500000,0.18,0.08,7605,42475,0.12,0.02,7488,0.13800000000000001,146,817,7605,42475,0.09,0.02,2.65,0,0.2,0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,325000,0.4,0.25,0,50000,60000,100,0.01]
[2013,"2013/2014","2018-05-04",9440,100000,0.5,2790,0.1,29220,0.2,117990,0.4,0.45,0.1,0.1,0.32500000000000001,0.375,0,0,0,0,0,0,0,0.03,21100,0.18,0.28000000000000003,0.1,10900,0.18,0.28000000000000003,0.2,0.23,7.4999999999999997E-3,300000,1500000,0.18,0.08,7755,41450,0.12,0.02,7696,0.13800000000000001,149,797,7755,41450,0.09,0.02,2.7,0,0.2,0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,325000,0.4,0.25,0,50000,60000,100,0.01]
[2014,"2014/2015","2018-05-04",10000,100000,0.5,2880,0.1,28985,0.2,118135,0.4,0.45,0.1,0.1,0.32500000000000001,0.375,0,0,0,0,0,0,0,0.03,21700,0.18,0.28000000000000003,0.1,11000,0.18,0.28000000000000003,0.2,0.21,2.5000000000000001E-3,300000,1500000,0.18,0.08,7956,41865,0.12,0.02,7956,0.13800000000000001,153,805,7956,41865,0.09,0.02,2.75,0,0.2,0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,325000,0.4,0.25,0,50000,60000,100,0.01]
[2015,"2015/2016","2018-05-04",10600,100000,0.5,5000,0,26785,0.2,118215,0.4,0.45,0.1,0.1,0.32500000000000001,0.375,0,0,0,0,0,0,0,0.03,22100,0.18,0.28000000000000003,0.1,11100,0.18,0.28000000000000003,0.2,0.2,0,300000,1500000,0.18,0.08,8060,42380,0.12,0.02,8112,0.13800000000000001,155,815,8060,42380,0.09,0.02,2.8,5965,0.2,0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,325000,0.4,0.25,0,50000,60000,100,0.01]
[2016,"2016/2017","2018-05-04",11000,100000,0.5,5000,0,27000,0.2,118000,0.4,0.45,7.4999999999999997E-2,7.4999999999999997E-2,0.32500000000000001,0.38100000000000001,5000,1000,500,0,0,0,0,0.03,22200,0.1,0.2,0.1,11100,0.18,0.28000000000000003,0.2,0.2,0,300000,1500000,0.18,0.08,8112,43004,0.12,0.02,8112,0.13800000000000001,156,827,8060,43000,0.09,0.02,2.8,5965,0.2,0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,325000,0.4,0.25,0,50000,60000,100,0.01]
[2017,"2017/2018","2018-05-04",11500,100000,0.5,5000,0,28500,0.2,116500,0.4,0.45,7.4999999999999997E-2,7.4999999999999997E-2,0.32500000000000001,0.38100000000000001,5000,1000,500,0,0,0,0,2.5000000000000001E-2,22600,0.1,0.2,0.1,11300,0.18,0.28000000000000003,0.19,0.19,0,300000,1500000,0.18,0.08,8164,45032,0.12,0.02,8164,0.13800000000000001,157,866,8164,45000,0.09,0.02,2.85,6025,0.2,0.05,11500,100000,0.5,0,0,31500,0.2,118500,0.4,0.45,null,null,7.4999999999999997E-2,7.4999999999999997E-2,0.32500000000000001,0.38100000000000001,5000,1000,500,0,0,0,0,325000,0.4,0.25,100000,50000,60000,100,0.01]
[2018,"2018/2019","2018-05-04",11850,100000,0.5,5000,0,29500,0.2,115500,0.4,0.45,7.4999999999999997E-2,7.4999999999999997E-2,0.32500000000000001,0.38100000000000001,2000,1000,500,0,0,0,0,2.5000000000000001E-2,23400,0.1,0.2,0.1,11700,0.18,0.28000000000000003,0.19,0.19,0,300000,1500000,0.18,0.08,8424,46384,0.12,0.02,8424,0.13800000000000001,162,892,8424,46350,0.09,0.02,2.95,6205,0.2,0.05,11850,100000,0.5,0,0,10150,0.2,118420,0.41,0.46,null,null,7.4999999999999997E-2,7.4999999999999997E-2,0.32500000000000001,0.38100000000000001,2000,1000,500,2000,0.19,19430,0.21,325000,0.4,0.25,125000,50000,60000,100,0.01]
[2023,"2023/24","2023-01-04",12570,100000,0.5,5000,0,32700,0.2,87440,0.4,0.45,0,8.7499999999999994E-2,0.33750000000000002,0.39350000000000002,1000,1000,500,0,0,0,0,0.02,27800,0.1,0.2,0.1,6000,0.18,0.28000000000000003,0.19,0.25,1.4999999999999999E-2,50000,250000,0.18,0.06,9880,50270,0.13250000000000001,3.2500000000000001E-2,9100,0.15049999999999999,190,967,11908,50270,0.10249999999999999,3.2500000000000001E-2,3.45,6725,0.2,0.05,12570,100000,0.5,0,0,10956,0.2,81478,0.42,0.47,null,null,7.4999999999999997E-2,8.7499999999999994E-2,0.33750000000000002,0.39350000000000002,1000,1000,500,2162,0.19,17974,0.21,325000,0.4,0.25,175000,50000,60000,100,0.01]
[2024,"2024/25","2023-01-04",12570,100000,0.5,5000,0,32700,0.2,87440,0.4,0.45,0,8.7499999999999994E-2,0.33750000000000002,0.39350000000000002,500,1000,500,0,0,0,0,0.02,27800,0.1,0.2,0.1,3000,0.18,0.28000000000000003,0.19,0.25,1.4999999999999999E-2,50000,250000,0.18,0.06,9880,50270,0.13250000000000001,3.2500000000000001E-2,9100,0.15049999999999999,190,967,11908,50270,0.10249999999999999,3.2500000000000001E-2,3.45,6725,0.2,0.05,12570,100000,0.5,0,0,11685,0.2,31338,0.42,0.45,{"$f":"125140-75000","v":50140},0.48,7.4999999999999997E-2,8.7499999999999994E-2,0.33750000000000002,0.39350000000000002,500,1000,500,2306,0.19,17101,0.21,325000,0.4,0.25,175000,50000,60000,100,0.01]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022 NIC set to end of year rates"]
[null,null,"if table changes in name need to amend code in tax_efficient macro"]

{"sheet":"input","index":2,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,4,34,5],[26,7,26,8],[28,4,28,5],[28,7,28,8],[26,4,26,5],[20,4,20,5],[20,7,20,8],[32,4,32,5],[22,4,22,5],[22,7,22,8],[24,4,24,5],[24,7,24,8],[3,4,3,5],[19,18,19,19],[6,4,6,5],[12,4,12,5],[10,4,10,5],[8,4,8,5],[14,4,14,5],[17,4,17,5],[17,7,17,8]]}
["Home","report",null,null,null,null,"tax_efficient"]
["bhnpi","Input"]
[]
[null,"What tax rules apply to the business owner?",null,null,"Rest of UK",null,null,null,null,null,null,null,null,null,null,null,null,null,"Scottish"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rest of UK"]
[null,"Details for the tax year of incorporation"]
[null,"Brought forward profits at the start of the accounting period:",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"locked and set to nil a decided not needed"]
[]
[null,"Taxable profit as an unincorporated business:",null,null,0]
[]
[null,"Salary:",null,null,0]
[]
[null,"Closing figure per the accounts:",null,null,{"$f":"+E7+E21-H21","v":0}]
[]
[null,"Dividends:",null,null,0]
[]
[]
[null,"Projected profit and drawings",null,null,"Profit you expect to make",null,null,"Target net personal income"]
[]
[null,"Year for formulas"]
[null,{"$f":"CONCATENATE(\"Year \",C21)","v":"Year 1"},1,{"$f":"whatyear(TODAY())","v":2023},0,null,null,0]
[]
[null,{"$f":"CONCATENATE(\"Year \",C23)","v":"Year 2"},2,{"$f":"+whatyear(TODAY())+C23-1","v":2024},0,null,null,0]
[]
[null,{"$f":"CONCATENATE(\"Year \",C25)","v":"Year 3"},3,{"$f":"+whatyear(TODAY())+C25-1","v":2025},0,null,null,0]
[]
[null,{"$f":"CONCATENATE(\"Year \",C27)","v":"Year 4"},4,{"$f":"+whatyear(TODAY())+C27-1","v":2026},null,null,null,0]
[]
[null,{"$f":"CONCATENATE(\"Year \",C29)","v":"Year 5"},5,{"$f":"+whatyear(TODAY())+C29-1","v":2027},0,null,null,0]
[]
[]
[null,"Value and cost of business goodwill"]
[null,"Current value of business's goodwill:",null,null,0]
[]
[null,"Price paid for the business's goodwill:",null,null,0]

{"sheet":"report","index":3,"n_rows":44,"n_cols":17,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["input","tax_efficient"]
["bhnp","Results: Comparison of tax over 5 years"]
[]
[null,"Unincorporated business"]
[null,null,null,0,{"$f":"+D5","v":0},{"$f":"+E5","v":0},0,0,null,null,null,null,null,null,"Hide"]
[null,null,"now year start","2024","2023","2023","2023","2023"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5",null,null,null,null,null,null,null,null,"uses same as first year as no danger has 5 more years in it"]
[null,null,null,"£","£","£","£","£"]
[null,null,"Profit brought forward:",{"$f":"+input!E7","v":0},{"$f":"+D15","v":0},{"$f":"+E15","v":0},{"$f":"+F15","v":0},{"$f":"+G15","v":0}]
[null,null,"Profit:",{"$f":"+input!E21","v":0},{"$f":"+input!E23","v":0},{"$f":"+input!E25","v":0},{"$f":"+input!E27","v":0},{"$f":"+input!E29","v":0}]
[null,null,"Tax:",{"$f":"+-tax(qry_tax_rates22[],country,D10,0,0,y_year)","v":0},{"$f":"+-tax(qry_tax_rates22[],country,E10,0,0,y_year)","v":0},{"$f":"+-tax(qry_tax_rates22[],country,F10,0,0,y_year)","v":0},{"$f":"+-tax(qry_tax_rates22[],country,G10,0,0,y_year)","v":0},{"$f":"+-tax(qry_tax_rates22[],country,H10,0,0,y_year)","v":0}]
[null,null,"NI - classes 2 and 4:",{"$f":"-class4(qry_tax_rates22[],D10,y_year)-(class2_new(qry_tax_rates22[],D10,y_year))","v":0},{"$f":"-class4(qry_tax_rates22[],E10,y_year)-(class2_new(qry_tax_rates22[],E10,y_year))","v":0},{"$f":"-class4(qry_tax_rates22[],F10,y_year)-(class2_new(qry_tax_rates22[],F10,y_year))","v":0},{"$f":"-class4(qry_tax_rates22[],G10,y_year)-(class2_new(qry_tax_rates22[],G10,y_year))","v":0},{"$f":"-class4(qry_tax_rates22[],H10,y_year)-(class2_new(qry_tax_rates22[],H10,y_year))","v":0}]
[null,null,"Retained:",{"$f":"+SUM(D9:D12)","v":0},{"$f":"+SUM(E9:E12)","v":0},{"$f":"+SUM(F9:F12)","v":0},{"$f":"+SUM(G9:G12)","v":0},{"$f":"+SUM(H9:H12)","v":0}]
[null,null,"Drawings:",{"$f":"-input!H21","v":0},{"$f":"-input!H23","v":0},{"$f":"-input!H25","v":0},{"$f":"-input!H27","v":0},{"$f":"-+input!H29","v":0}]
[null,null,"Cumulative profit left in business ",{"$f":"+D13+D14","v":0},{"$f":"E13+E14","v":0},{"$f":"F13+F14","v":0},{"$f":"G13+G14","v":0},{"$f":"H13+H14","v":0}]
[]
[null,null,null,"2024-03-31",{"$f":"D17","v":"2024-03-31"},{"$f":"E17","v":"2024-03-31"},"2024-03-31","2024-03-31",null,null,null,null,null,null,"Hide"]
[null,"Company"]
[null,null,null,"£","£","£","£","£"]
[null,null,"Profit before salary:",{"$f":"+D10","v":0},{"$f":"+E10","v":0},{"$f":"+F10","v":0},{"$f":"+G10","v":0},{"$f":"+H10","v":0}]
[null,null,"Salary:",{"$f":"-MIN(+DC(qry_tax_rates22[],country&\"PA\",y_year),D20)","v":0},{"$f":"-MIN(+DC(qry_tax_rates22[],country&\"PA\",y_year),E20)","v":0},{"$f":"-MIN(+DC(qry_tax_rates22[],country&\"PA\",y_year),F20)","v":0},{"$f":"-MIN(+DC(qry_tax_rates22[],country&\"PA\",y_year),G20)","v":0},{"$f":"-MIN(+DC(qry_tax_rates22[],country&\"PA\",y_year),H20)","v":0}]
[null,null,"Employers' NI:",{"$f":"-class1er(qry_tax_rates22[],-D21,D6)","v":0},{"$f":"-class1er(qry_tax_rates22[],-E21,E6)","v":0},{"$f":"-class1er(qry_tax_rates22[],-F21,F6)","v":0},{"$f":"-class1er(qry_tax_rates22[],-G21,G6)","v":0},{"$f":"-class1er(qry_tax_rates22[],-H21,H6)","v":0}]
[null,null,"Profit:",{"$f":"+SUM(D20:D22)","v":0},{"$f":"+SUM(E20:E22)","v":0},{"$f":"+SUM(F20:F22)","v":0},{"$f":"+SUM(G20:G22)","v":0},{"$f":"+SUM(H20:H22)","v":0}]
[null,null,"Tax",{"$f":"-ct(qry_tax_rates22[],D23,D17)","v":0},{"$f":"-ct(qry_tax_rates22[],E23,E17)","v":0},{"$f":"-ct(qry_tax_rates22[],F23,F17)","v":0},{"$f":"-ct(qry_tax_rates22[],G23,G17)","v":0},{"$f":"-ct(qry_tax_rates22[],H23,H17)","v":0}]
[null,null,"Profit after tax:",{"$f":"+D23+D24","v":0},{"$f":"+E23+E24","v":0},{"$f":"+F23+F24","v":0},{"$f":"+G23+G24","v":0},{"$f":"+H23+H24","v":0}]
[null,null,"Profit brought forward:",{"$f":"+D9","v":0},{"$f":"+D28","v":-24875.534246575342},{"$f":"+E28","v":-24875.534246575342},{"$f":"+F28","v":-24875.534246575342},{"$f":"+G28","v":-24875.534246575342}]
[null,null,"Dividends: ",-24875.534246575342,0,0,0,0,null,null,null,null,null,null,"Goal seek so that net = drawings"]
[null,null,"Cumulative profit left in company (reserves) ",{"$f":"+SUM(D25:D27)","v":-24875.534246575342},{"$f":"+SUM(E25:E27)","v":-24875.534246575342},{"$f":"+SUM(F25:F27)","v":-24875.534246575342},{"$f":"+SUM(G25:G27)","v":-24875.534246575342},{"$f":"+SUM(H25:H27)","v":-24875.534246575342}]
[]
[null," Your income from the company"]
[null,null,null,"£","£","£","£","£"]
[null,null,"Salary:",{"$f":"-D21","v":0},{"$f":"-E21","v":0},{"$f":"-F21","v":0},{"$f":"-G21","v":0},{"$f":"-H21","v":0}]
[null,null,"Dividend:",{"$f":"-+D27","v":24875.534246575342},{"$f":"-+E27","v":0},{"$f":"-+F27","v":0},{"$f":"-+G27","v":0},{"$f":"-+H27","v":0}]
[null,null,"Less tax:",{"$f":"-tax(qry_tax_rates22[],country,D32,0,D33,y_year)","v":-1032.9842465753425},{"$f":"-tax(qry_tax_rates22[],country,E32,0,E33,y_year)","v":0},{"$f":"-tax(qry_tax_rates22[],country,F32,0,F33,y_year)","v":0},{"$f":"-tax(qry_tax_rates22[],country,G32,0,G33,y_year)","v":0},{"$f":"-tax(qry_tax_rates22[],country,H32,0,H33,y_year)","v":0}]
[null,null,"Less NI:",{"$f":"-class1ee(qry_tax_rates22[],D32,y_year)","v":0},{"$f":"-class1ee(qry_tax_rates22[],E32,y_year)","v":0},{"$f":"-class1ee(qry_tax_rates22[],F32,y_year)","v":0},{"$f":"-class1ee(qry_tax_rates22[],G32,y_year)","v":0},{"$f":"-class1ee(qry_tax_rates22[],H32,y_year)","v":0}]
[null,null,"Your net income:",{"$f":"+SUM(D32:D35)","v":23842.55},{"$f":"+SUM(E32:E35)","v":0},{"$f":"+SUM(F32:F35)","v":0},{"$f":"+SUM(G32:G35)","v":0},{"$f":"+SUM(H32:H35)","v":0}]
[]
[null,"Comparison of tax positions"]
[null,null,null,"£","£","£","£","£"]
[null,null,"Total tax paid as sole trader:",{"$f":"-(D11+D12)","v":0},{"$f":"-(E11+E12)","v":0},{"$f":"-(F11+F12)","v":0},{"$f":"-(G11+G12)","v":0},{"$f":"-(H11+H12)","v":0}]
[null,null,"Total tax on company and you as director:",{"$f":"-(+D22+D24+D34+D35)","v":1032.9842465753425},{"$f":"-(+E22+E24+E34+E35)","v":0},{"$f":"-(+F22+F24+F34+F35)","v":0},{"$f":"-(+G22+G24+G34+G35)","v":0},{"$f":"-(+H22+H24+H34+H35)","v":0}]
[null,null,"Tax saved by incorporating",{"$f":"+D40-D41","v":-1032.9842465753425},{"$f":"+E40-E41","v":0},{"$f":"+F40-F41","v":0},{"$f":"+G40-G41","v":0},{"$f":"+H40-H41","v":0},{"$f":"+SUM(D42:H42)","v":-1032.9842465753425}]
[]
[null,"Tax saving over 5 years",null,null,null,null,null,{"$f":"+SUM(D42:H42)","v":-1032.9842465753425}]

{"sheet":"tax_efficient","index":4,"n_rows":65,"n_cols":16,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["report"]
["bhp","Results: Your and your company's capital position"]
[]
[null,"Sale of unincorporated business to your company",null,null,null,null,null,"£"]
[null,null,null,1,{"$f":"+D5","v":1},{"$f":"+E5","v":1},1,1,null,null,null,null,null,null,"Hide"]
[null,null,"Sale price:",null,null,null,null,{"$f":"+input!E33","v":0},null,null,null,null,null,null,null,"careful - hidden row 5 has added years in it - but all at one to stop exceeding years in tax tables"]
[null,null,"Amount you originally paid for business:",null,null,null,null,{"$f":"+input!E35","v":0}]
[null,null,"Capital gain:",null,null,null,null,{"$f":"+H6-H7","v":0}]
[]
[null,null,"Annual exempt amount:",null,null,null,null,{"$f":"+MIN(DC(qry_tax_rates22[],\"CGT_AEA\",report!D6-1),H8)","v":0}]
[null,null,"Net gain:",null,null,null,null,{"$f":"+H8-H10","v":0}]
[null,null,"Capital gains tax due"]
[null,null,{"$f":"+IF(P20=0,CONCATENATE(\"All of gain at \",TEXT(DC(qry_tax_rates22[],\"CGT_LR\",y_year),\"#%\")),IF(P19=0,CONCATENATE(\"All of gain at \",TEXT(DC(qry_tax_rates22[],\"CGT_HR\",y_year),\"#%\")),CONCATENATE(TEXT(P19,\"£#,###\"),\" at \",TEXT(DC(qry_tax_rates22[],\"CGT_LR\",y_year),\"#%\"))))","v":"All of gain at 10%"},null,null,null,null,{"$f":"+IF(P19=0,+P20*DC(qry_tax_rates22[],\"CGT_HR\",y_year),+P19*DC(qry_tax_rates22[],\"CGT_LR\",y_year))","v":0},null,null,null,null,null,null,"Based on income from last accounts"]
[null,null,{"$f":"IF(AND(P19>0,P20>0),CONCATENATE(\"Balance of gain at \",TEXT(DC(qry_tax_rates22[],\"CGT_HR\",y_year),\"#%\")),\"\")","v":""},null,null,null,null,{"$f":"+IF(P19=0,\"\",IF(P20>0,P20*DC(qry_tax_rates22[],\"CGT_HR\",y_year),\"\"))","v":""},null,null,null,null,null,null,"Total income",{"$f":"+input!E9","v":0}]
[null,null,"Total CGT payable:",null,null,null,null,{"$f":"+SUM(H13:H14)","v":0},null,null,null,null,null,null,"PA",{"$f":"+PA_amt(qry_tax_rates22[],country,0,P14,report!D6-1)","v":12570}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SRB+BRB",{"$f":"+DC(qry_tax_rates22[],\"SRB\",y_year)+DC(qry_tax_rates22[],\"BRB\",y_year)","v":37700}]
[null,"Summary of cash position following sale",null,null,null,null,null,null,null,null,null,null,null,null,"space",{"$f":"MAX(0,P16+P15-P14)","v":50270}]
[null,null,null,null,null,null,null,"£"]
[null,null,"Proceeds credited to your director's loan account:",null,null,null,null,{"$f":"+H6","v":0},null,null,null,null,null,null,"at LR",{"$f":"+MIN(P17,H11)","v":0}]
[null,null,"CGT payable:",null,null,null,null,{"$f":"+H15","v":0},null,null,null,null,null,null,"at HR",{"$f":"+H11-P19","v":0}]
[null,null,"Balance remaining in your loan account:",null,null,null,null,{"$f":"+H19-H20","v":0}]
[]
[]
[null,null,null,{"$f":"+DATE((whatyear(TODAY()))+D5,3,31)","v":"2024-03-31"},{"$f":"+DATE((whatyear(TODAY()))+E5,3,31)","v":"2024-03-31"},{"$f":"+DATE((whatyear(TODAY()))+F5,3,31)","v":"2024-03-31"},{"$f":"+DATE((whatyear(TODAY()))+G5,3,31)","v":"2024-03-31"},{"$f":"+DATE((whatyear(TODAY()))+H5,3,31)","v":"2024-03-31"},null,null,null,null,null,null,"Hide"]
[null,"Company's reserves"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,"now hidden year starting for formula purpose",{"$f":"+report!D6","v":"2024"},{"$f":"+report!E6","v":"2023"},{"$f":"+report!F6","v":"2023"},{"$f":"+report!G6","v":"2023"},{"$f":"+report!H6","v":"2023"}]
[null,null,null,"£","£","£","£","£"]
[null,null,"Profit:",{"$f":"+report!D20","v":0},{"$f":"+report!E20","v":0},{"$f":"+report!F20","v":0},{"$f":"+report!G20","v":0},{"$f":"+report!H20","v":0}]
[null,null,"Less salary paid to you:",{"$f":"MIN(+report!D21,D29)","v":0},{"$f":"MIN(+report!E21,E29)","v":0},{"$f":"MIN(+report!F21,F29)","v":0},{"$f":"MIN(+report!G21,G29)","v":0},{"$f":"MIN(+report!H21,H29)","v":0}]
[null,null,"Less employers' NI payable on salary:",{"$f":"+ROUND(-class1er(qry_tax_rates22[],D30,D27-1),0)","v":0},{"$f":"+ROUND(-class1er(qry_tax_rates22[],E30,E27-1),0)","v":0},{"$f":"+ROUND(-class1er(qry_tax_rates22[],F30,F27-1),0)","v":0},{"$f":"+ROUND(-class1er(qry_tax_rates22[],G30,G27-1),0)","v":0},{"$f":"+ROUND(-class1er(qry_tax_rates22[],H30,H27-1),0)","v":0}]
[null,null,null,{"$f":"+SUM(D29:D31)","v":0},{"$f":"+SUM(E29:E31)","v":0},{"$f":"+SUM(F29:F31)","v":0},{"$f":"+SUM(G29:G31)","v":0},{"$f":"+SUM(H29:H31)","v":0}]
[null,null,"Less corporation tax: ",{"$f":"+ROUND(-ct(qry_tax_rates22[],D32,D24),0)","v":0},{"$f":"+ROUND(-ct(qry_tax_rates22[],E32,E24),0)","v":0},{"$f":"+ROUND(-ct(qry_tax_rates22[],F32,F24),0)","v":0},{"$f":"+ROUND(-ct(qry_tax_rates22[],G32,G24),0)","v":0},{"$f":"+ROUND(-ct(qry_tax_rates22[],H32,H24),0)","v":0},{"$f":"+ROUND(-ct(qry_tax_rates22[],country,I32,I24),0)","v":{"$error":"#VALUE!"}}]
[null,null,"After-tax profit:",{"$f":"+SUM(D32:D33)","v":0},{"$f":"+SUM(E32:E33)","v":0},{"$f":"+SUM(F32:F33)","v":0},{"$f":"+SUM(G32:G33)","v":0},{"$f":"+SUM(H32:H33)","v":0}]
[null,null,"Profit brought forward:",{"$f":"+report!D9","v":0},{"$f":"+D37","v":-22218},{"$f":"+E37","v":-22218},{"$f":"+F37","v":-22218},{"$f":"+G37","v":-22218}]
[null,null,"Dividends paid to you:",-22218,0,0,0,0,null,null,null,null,null,null,"Set at drawings above +tax and NIC above less salary"]
[null,null,"Cumulative value (reserves) left in company  ",{"$f":"+SUM(D34:D36)","v":-22218},{"$f":"+SUM(E34:E36)","v":-22218},{"$f":"+SUM(F34:F36)","v":-22218},{"$f":"+SUM(G34:G36)","v":-22218},{"$f":"+SUM(H34:H36)","v":-22218}]
[]
[null,"Credits to and deductions from your loan account"]
[null,null,null,"£","£","£","£","£"]
[null,null,"Loan account starting balance:",{"$f":"+H21","v":0},{"$f":"+D50","v":6417},{"$f":"+E50","v":6417},{"$f":"+F50","v":6417},{"$f":"+G50","v":6417}]
[null,null,"Add to loan account:"]
[null,null,"Gross salary",{"$f":"-D30","v":0},{"$f":"-E30","v":0},{"$f":"-F30","v":0},{"$f":"-G30","v":0},{"$f":"-H30","v":0}]
[null,null,"Dividend",{"$f":"-+D36","v":22218},{"$f":"-+E36","v":0},{"$f":"-+F36","v":0},{"$f":"-+G36","v":0},{"$f":"-+H36","v":0}]
[null,null,null,{"$f":"+D44+D43+D41","v":22218},{"$f":"+E44+E43+E41","v":6417},{"$f":"+F44+F43+F41","v":6417},{"$f":"+G44+G43+G41","v":6417},{"$f":"+H44+H43+H41","v":6417}]
[null,null,"Deducted from your loan account:"]
[null,null,"Tax",{"$f":"+tax(qry_tax_rates22[],country,D43,0,D44,y_year)","v":800.44999999999993},{"$f":"+tax(qry_tax_rates22[],country,E43,0,E44,y_year)","v":0},{"$f":"+tax(qry_tax_rates22[],country,F43,0,F44,y_year)","v":0},{"$f":"+tax(qry_tax_rates22[],country,G43,0,G44,y_year)","v":0},{"$f":"+tax(qry_tax_rates22[],country,H43,0,H44,y_year)","v":0}]
[null,null,"NI",{"$f":"+class1ee(qry_tax_rates22[],D43,y_year)","v":0},{"$f":"+class1ee(qry_tax_rates22[],E43,y_year)","v":0},{"$f":"+class1ee(qry_tax_rates22[],F43,y_year)","v":0},{"$f":"+class1ee(qry_tax_rates22[],G43,y_year)","v":0},{"$f":"+class1ee(qry_tax_rates22[],H43,y_year)","v":0}]
[null,null,"Your drawings from business:",15000,0,0,0,0]
[null,null,"Your loan account closing balance",{"$f":"ROUNDDOWN(+D45-D47-D48-D49,0)","v":6417},{"$f":"ROUNDDOWN(+E45-E47-E48-E49,0)","v":6417},{"$f":"ROUNDDOWN(+F45-F47-F48-F49,0)","v":6417},{"$f":"ROUNDDOWN(+G45-G47-G48-G49,0)","v":6417},{"$f":"ROUNDDOWN(+H45-H47-H48-H49,0)","v":6417}]
[null,null,null,0,0,0,0,0]
[null,"Summary"]
[null,null,"Drawings need fully met",{"$f":"+IF(D49=-report!D14,\"Yes\",\"No\")","v":"No"},{"$f":"+IF(E49=-report!E14,\"Yes\",\"No\")","v":"Yes"},{"$f":"+IF(F49=-report!F14,\"Yes\",\"No\")","v":"Yes"},{"$f":"+IF(G49=-report!G14,\"Yes\",\"No\")","v":"Yes"},{"$f":"+IF(H49=-report!H14,\"Yes\",\"No\")","v":"Yes"}]
[]
[null,null,"Total tax as percentage of funds available",null,null,{"$f":"+(SUM(D47:H48)+SUM(D33:H33)+H15)/(H50+SUM(D47:H49))","v":3.6027987010210441E-2},null,null,null,null,null,null,null,null,"First year tax burden in CGT - also has the tax and NIC in denominator as drawings"]
[null,null,"Sole trade - tax as percentage of funds available",null,null,{"$f":"+(SUM(report!D11:H12)/SUM(report!D10:H10))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+SUM(D56:H56)","v":{"$error":"#DIV/0!"}}]
[null,null,null,{"$f":"+IF(D51=1,\"Underfunded\",\"\")","v":""},{"$f":"+IF(E51=1,\"Underfunded\",\"\")","v":""},{"$f":"+IF(F51=1,\"Underfunded\",\"\")","v":""},{"$f":"+IF(G51=1,\"Underfunded\",\"\")","v":""},{"$f":"+IF(H51=1,\"Underfunded\",\"\")","v":""}]
[]
[]
[]
[null,null,"drawings requested",{"$f":"+input!H21","v":0},{"$f":"+input!H23","v":0},{"$f":"+input!H25","v":0},{"$f":"+input!H27","v":0},{"$f":"+input!H29","v":0}]
[null,null,"Target drawings",{"$f":"+input!H21","v":0},{"$f":"+input!H23","v":0},{"$f":"+input!H25","v":0},{"$f":"+input!H27","v":0},{"$f":"+input!H29","v":0}]
[]
[]
[null,null,null,{"$f":"+DC(qry_tax_rates22[],country,\"BRB\",2015)","v":{"$error":"#VALUE!"}}]

{"sheet":"xxxcharts","index":5,"n_rows":16,"n_cols":23,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["tax_efficient"]
[null,"Summary"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Absolutes",null,null,null,"Percentages"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sole trade","Incorp","With sale",null,"Sole trade","Incorp","With sale"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total profits (+gain) & b/f",{"$f":"+SUM(report!D10:H10)+report!D9","v":0},{"$f":"+Q7","v":0},{"$f":"+R7+tax_efficient!H6","v":0},null,"As sole trade","As a company","When you sell\nyour business \nto the company"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drawn & kept",{"$f":"+-SUM(report!D14:H14)","v":0},{"$f":"+SUM(report!D36:H36)","v":23842.55},{"$f":"+SUM(tax_efficient!$D$49:$H$49)","v":15000},"Money drawn from business",{"$f":"+Q8/Q$7","v":{"$error":"#DIV/0!"}},{"$f":"+R8/R$7","v":{"$error":"#DIV/0!"}},{"$f":"+S8/S$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Left to draw",{"$f":"+SUM(report!H15)","v":0},null,{"$f":"+SUM(tax_efficient!$H$50)","v":6417},"Available to be drawn tax free",{"$f":"Q9/Q$7","v":{"$error":"#DIV/0!"}},null,{"$f":"+S9/S$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Left in company",null,{"$f":"+SUM(report!H28)","v":-24875.534246575342},{"$f":"+SUM(tax_efficient!$H$37)","v":-22218},"Available to draw as taxable income",null,{"$f":"R10/R$7","v":{"$error":"#DIV/0!"}},{"$f":"+S10/S$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total tax & NIC",{"$f":"-SUM(report!D11:H12)","v":0},{"$f":"-SUM(report!D24:H24)-SUM(report!D22:H22)-SUM(report!D34:H35)","v":1032.9842465753425},{"$f":"+SUM(tax_efficient!$H$15)+-SUM(tax_efficient!$D$31:$H$31)+SUM(tax_efficient!$D$47:$H$48)+-SUM(tax_efficient!$D$33:$H$33)+N(\"careful as figures +ve and -ve\")","v":800.44999999999993},"Total Tax & NI payable ",{"$f":"+Q11/Q$7","v":{"$error":"#DIV/0!"}},{"$f":"+R11/R$7","v":{"$error":"#DIV/0!"}},{"$f":"+S11/S$7","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"+SUM(Q8:Q11)","v":0},{"$f":"+SUM(R8:R11)","v":0},{"$f":"+SUM(S8:S11)","v":-0.55000000000006821}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"change to stack",null,{"$f":"+R12-R7","v":0},{"$f":"+S12-S7","v":-0.55000000000006821}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lines between",null,null,"Allows CGT on sale"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Has proceeds of sale included as undrawn",null,null,"work this out - looks awful"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As it should do"]

{"sheet":"info_input","index":6,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["input","report","tax_efficient"]
["bhp","Information - input"]
[]
[null,"Details for the tax year of incorporation"]
[]
[null,"Tax year of incorporation","The rates from this year will be used for all future year calculations"]
[]
[null,"Taxable profit as an unincorporated business","Enter the profit of the unincoprorated business for the final year before it is incorporated."]
[]
[null,"Salary/dividends","Enter any salary or dividends you received in the tax year of incorporation."]
[]
[null,null,"These figures are used to calculate the likely capital gains tax payable on the incorporation of the business."]
[]
[null,"Projected profit and drawings"]
[]
[null,"Profit you expect to make","Enter an estimate of the profit you expect your business to make over the next five years."]
[]
[null,"Drawings you intend to take","Enter an estimate of the amounts you expect to draw, excluding payments for tax and NI, over the next five years."]
[]
[null,"Value and cost of business"]
[]
[null,"Current value of business's goodwill","Enter an estimate of how much your business's goodwill is worth."]
[]
[null,"Price paid for the business's goodwill (if any)","The amount paid to a third party for the goodwill of your business. "]