{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Homepage","Data entry","Results-hidden","Results"],"not_rendered":{"images":2,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Homepage","index":0,"n_rows":33,"n_cols":6,"rows_kept":33,"merged":[[3,5,3,9],[4,5,4,9],[5,2,6,10],[8,2,8,10],[9,2,10,10],[11,2,11,10],[12,2,13,10],[15,2,15,9],[16,2,17,10],[18,2,19,10],[20,2,21,10],[23,2,23,10],[24,2,24,9],[25,2,26,10],[27,2,28,10],[29,2,29,10],[30,2,30,10],[31,2,31,10],[32,2,32,10],[33,2,33,10],[34,2,34,9]]}
[]
[]
[{"$nulls":5},"Chargeable event gains - income tax calculator"]
[{"$nulls":5},"For use by Financial Advisers only"]
[]
[null,null,"Please read the following. Click the button at the bottom right of the page to confirm you have read and understood the conditions of using this tool and its' limititations"]
[]
[]
[null,null,"Welcome to the Quilter chargeable event gains – income tax calculator."]
[null,null,"This financial planning tool provides the income tax liability of your client based on the information you provide. It only shows the liability relating to chargeable event gain(s) from your clients’ life/redemption bond(s)  and life assurance plans. The income tax liability on other income is outside of the scope of this tool."]
[]
[null,null,"It can be used when advising UK tax resident individuals only. It is not suitable for trustees or company owned investments.  "]
[null,null,"Before using this tool you need to obtain the information of your clients’ income for the respective tax year in which the gain(s) occurred. You will also need to know the chargeable event gain(s) which is chargeable or for proposed gains, the gain you have calculated yourself."]
[]
[]
[null,null,"The information you will need to use this financial planning tool: "]
[null,null,"Chargeable event details – the amount of the gain, the number of complete years the bond or plan was in force at the time of the event, whether the insurer and therefore the gain (s) is onshore or offshore and whether your client has spent any time outside of the UK i.e. non-resident."]
[]
[null,null,"Your clients’ income details – you are required to enter earned income (including pensions and rental income), savings income (excluding the chargeable event gains), dividend income and any personal pension contributions eligible for relief at source. "]
[]
[null,null,"The result calculated by this tool is based on the information you provide at the date the calculation is made. It is your responsibility to ensure that the information you have input into this tool is accurate, if it is not the figures provided following the calculation will not be correct and should not be relied upon. "]
[]
[]
[null,null,"By using this calculator you have accepted the following:"]
[null,null,"Taxation and reliefs"]
[null,null,"Every care has been taken to ensure that the information contained in this tool is correct and in accordance with our understanding of the law relating to chargeable events and HM Revenue and Customs practice as at  May 2023. This could change in the future. "]
[]
[null,null,"You should be satisfied that the information you have entered and the results of any calculation are correct, before acting or refraining from acting in reliance upon the information given. "]
[]
[null,null,"Quilter accepts no responsibility for actions taken or refrained from being taken following use of this financial planning tool."]
[null,null,"Chargeable event gains should be disclosed on your client's self-assessment return, for the relevant tax year. "]
[null,null,"Where you are calculating the liability for a gain(s) made on an onshore bond basic rate tax is treated as already paid. If you are calculating the liability for a gain on an offshore bond no tax is treated as already being paid. "]
[null,null,"The order of income used by this calculator is earnings, savings (incl. offshore gains), dividends then onshore gains. Allowances available to your client are used against other income prior to being used by chargeable event gains for the purposes of the top slicing relief calculation"]

{"sheet":"Data entry","index":1,"n_rows":106,"n_cols":11,"rows_kept":106,"merged":[[2,3,2,5],[13,6,13,8]]}
[]
[]
[{"$nulls":3},"Chargeable event gains - income tax calculator"]
[]
[null,null,"Step 1 - check allowances"]
[null,null,"Personal allowance",{"v":12570,"d":"£12,570"}]
[null,null,"Basic rate band",{"v":37700,"d":"£37,700"}]
[null,null,"Higher rate band (£125,140 - basic rate band)",{"$f":"125140-D7","v":{"v":87440,"d":"£87,440"}}]
[null,null,"Starting rate for savings",{"v":5000,"d":"£5,000"}]
[null,null,"Personal savings allowance - basic rate",{"v":1000,"d":"£1,000"}]
[null,null,"Personal savings allowance - higher rate",{"v":500,"d":"£500"}]
[null,null,"Personal savings allowance - additional rate",{"v":0,"d":"£0"}]
[null,null,"Dividend allowance",{"v":1000,"d":"£1,000"}]
[{"$nulls":6},"Optional - leave blank if not applicable"]
[null,null,"Step 2 - enter bond gains","Amount","No. of complete years","Onshore or offshore?","No. of non-UK days","Non-UK yrs","No. of days owned","Aggregate slice "]
[null,null,"Chargeable event gain 1",{"v":0,"d":"£0"},0,null,null,{"$f":"ROUNDDOWN((G16/365),0)","v":0},null,{"$f":"IFERROR(IF(G16=0,D16/E16,(D16-(D16*(G16/I16)))/MAX((E16-H16),1)),0)","v":{"v":0,"d":"£0.00"}},{"$f":"IF(G16=0,D16,ROUNDDOWN(D16-(D16*(G16/I16)),0))","v":0}]
[null,null,"Chargeable event gain 2",{"v":0,"d":"£0"},0,null,null,{"$f":"ROUNDDOWN((G17/365),0)","v":0},null,{"$f":"IFERROR(IF(G17=0,D17/E17,(D17-(D17*(G17/I17)))/MAX((E17-H17),1)),0)","v":{"v":0,"d":"£0.00"}},{"$f":"IF(G17=0,D17,ROUNDDOWN(D17-(D17*(G17/I17)),0))","v":0}]
[null,null,"Chargeable event gain 3",{"v":0,"d":"£0"},0,null,null,{"$f":"ROUNDDOWN((G18/365),0)","v":0},null,{"v":0,"d":"£0.00"},0]
[null,null,"Chargeable event gain 4",{"v":0,"d":"£0"},0,null,null,{"$f":"ROUNDDOWN((G19/365),0)","v":0},null,{"v":0,"d":"£0.00"},0]
[null,null,"Chargeable event gain 5",{"v":0,"d":"£0"},0,null,null,0,null,{"v":0,"d":"£0.00"},0]
[null,null,"Chargeable event gain 6",{"v":0,"d":"£0"},0,null,null,0,null,{"v":0,"d":"£0.00"},0]
[null,null,"Chargeable event gain 7",{"v":0,"d":"£0"},0,null,null,0,null,{"v":0,"d":"£0.00"},0]
[null,null,"Chargeable event gain 8",{"v":0,"d":"£0"},0,null,null,0,null,{"v":0,"d":"£0.00"},0]
[null,null,"Chargeable event gain 9",{"v":0,"d":"£0"},0,null,null,0,null,{"v":0,"d":"£0.00"},0]
[null,null,"Chargeable event gain 10",{"v":0,"d":"£0"},0,null,null,{"$f":"ROUNDDOWN((G25/365),0)","v":0},null,{"v":0,"d":"£0.00"},0]
[{"$nulls":9},{"$f":"SUM(J16:J25)","v":{"v":0,"d":"£0.00"}},{"$f":"SUM(K16:K25)","v":{"v":0,"d":"£0.00"}}]
[]
[null,null,"Step 3 - enter other income"]
[null,null,"Earned income (PAYE, Pension, Rental)",{"v":0,"d":"£0.00"},{"$f":"SUM((D29+D30+D31)-D32+K26)","v":{"v":0,"d":"£0.00"}},{"$f":"SUM((D29+D30+D31)-D32+J26)","v":{"v":0,"d":"£0.00"}}]
[null,null,"Savings Income (interest)",{"v":0,"d":"£0.00"},{"$f":"IF(E29>D8+D7,\"Additional Rate\", IF(E29<=D6+D7,\"Basic Rate\",\"Higher Rate\"))","v":"Basic Rate"},{"$f":"IF(F29>D8+D7,\"Additional Rate\", IF(F29<=D6+D7,\"Basic Rate\",\"Higher Rate\"))","v":"Basic Rate"}]
[null,null,"Dividend income",{"v":0,"d":"£0.00"}]
[null,null,"Gross pension contributions",{"v":0,"d":"£0.00"}]
{"$rows_empty":72}
[{"$nulls":6},"Onshore"]
[{"$nulls":6},"Offshore"]

{"sheet":"Results-hidden","index":2,"n_rows":77,"n_cols":16,"rows_kept":77,"hidden":true,"merged":[[16,11,17,15],[18,11,19,15],[22,11,23,15],[24,11,25,15],[26,5,26,9],[26,11,26,15]]}
[]
[{"$nulls":5},"Results summary"]
[null,null,"Summary",null,null,"Offshore Bond gains allocated",null,"Bond gain left","Rate","Tax",null,"Onshore bonds gains allocated",null,"Bond gain left","Rate","Tax"]
[]
[null,null,"Total Onshore bond gain",{"$f":"SUMIF('Data entry'!F16:F25,\"Onshore\",'Data entry'!K16:K25)","v":{"v":0,"d":"£0"}},null,"Within personal allowance",{"$f":"MIN(D41,D6)","v":{"v":0,"d":"£0"}},{"$f":"D34-G5","v":{"v":0,"d":"£0"}},{"v":0,"d":"0%"},{"$f":"G5*I5","v":{"v":0,"d":"£0"}},null,"Within personal allowance",{"$f":"MIN(D50,D5)","v":{"v":0,"d":"£0"}},{"$f":"D36-M5","v":{"v":0,"d":"£0"}},{"v":0,"d":"0%"},{"$f":"M5*O5","v":{"v":0,"d":"£0"}}]
[null,null,"Total Offshore bond gain",{"$f":"SUMIF('Data entry'!F16:F25,\"Offshore\",'Data entry'!K16:K25)","v":{"v":0,"d":"£0"}},null,"Starting rate for savings",{"$f":"MIN(D42,H5)","v":{"v":0,"d":"£0"}},{"$f":"H5-G6","v":{"v":0,"d":"£0"}},{"v":0,"d":"0%"},{"v":0,"d":"£0"},null,"Starting rate for savings",{"$f":"MIN(D51,N5)","v":{"v":0,"d":"£0"}},{"$f":"N5-M6","v":{"v":0,"d":"£0"}},{"v":0,"d":"0%"},{"v":0,"d":"£0"}]
[null,null,"Total aggregate slice",{"$f":"'Data entry'!J26","v":{"v":0,"d":"£0"}},null,"Personal savings allowance",{"$f":"MIN(D43,H6)","v":{"v":0,"d":"£0"}},{"$f":"H6-G7","v":{"v":0,"d":"£0"}},{"v":0,"d":"0%"},{"v":0,"d":"£0"},null,"Personal savings allowance",{"$f":"MIN(D52,N6)","v":{"v":0,"d":"£0"}},{"$f":"N6-M7","v":{"v":0,"d":"£0"}},{"v":0,"d":"0%"},{"v":0,"d":"£0"}]
[null,null,"Average years",{"$f":"IFERROR('Data entry'!K26/'Data entry'!J26,0)","v":{"v":0,"d":"0.000"}},null,"Basic rate",{"$f":"MIN(D45,H7)","v":{"v":0,"d":"£0"}},{"$f":"H7-G8","v":{"v":0,"d":"£0"}},{"v":0.2,"d":"20%"},{"v":0,"d":"£0"},null,"Basic rate",{"$f":"MIN(D54,N7)","v":{"v":0,"d":"£0"}},{"$f":"N7-M8","v":{"v":0,"d":"£0"}},{"v":0.2,"d":"20%"},{"v":0,"d":"£0"}]
[null,null,"Average years (onshore)",{"$f":"IFERROR(D69,0)","v":{"v":0,"d":"0.000"}},null,"Higher rate ",{"$f":"MIN(D46,H8)","v":{"v":0,"d":"£0"}},{"$f":"H8-G9","v":{"v":0,"d":"£0"}},{"v":0.4,"d":"40%"},{"v":0,"d":"£0"},null,"Higher rate ",{"$f":"MIN(D55,N8)","v":{"v":0,"d":"£0"}},{"$f":"N8-M9","v":{"v":0,"d":"£0"}},{"v":0.4,"d":"40%"},{"v":0,"d":"£0"}]
[null,null,"Personal allowance",{"$f":"MAX(0,IF('Data entry'!E29>100000,'Data entry'!D6-(('Data entry'!E29-100000)/2),'Data entry'!D6))","v":{"v":12570,"d":"£12,570"}},{"$f":"MAX(0,IF('Data entry'!F29>100000,'Data entry'!D6-(('Data entry'!F29-100000)/2),'Data entry'!D6))","v":{"v":12570,"d":"£12,570"}},"Additional rate",{"$f":"H9","v":{"v":0,"d":"£0"}},{"$f":"H9-G10","v":{"v":0,"d":"£0"}},{"v":0.45,"d":"45%"},{"v":0,"d":"£0"},null,"Additional rate",{"$f":"N9","v":{"v":0,"d":"£0"}},{"$f":"N9-M10","v":{"v":0,"d":"£0"}},{"v":0.45,"d":"45%"},{"v":0,"d":"£0"}]
[null,null,"Basic rate band",{"$f":"'Data entry'!D7+'Data entry'!D32","v":{"v":37700,"d":"£37,700"}},null,"Total liability on Offshore gain(s)",{"$nulls":3},{"$f":"SUM(J5:J10)","v":{"v":0,"d":"£0"}},null,"Total tax on Onshore gain(s)",{"$nulls":3},{"$f":"SUM(P5:P10)","v":{"v":0,"d":"£0"}}]
[null,null,"Higher rate band",{"$f":"'Data entry'!D8","v":{"v":87440,"d":"£87,440"}},{"$nulls":7},"Onshore credit",{"$nulls":3},{"$f":"ROUNDUP(D5*0.2,0)-(M5*0.2)","v":{"v":0,"d":"£0"}}]
[null,null,"Personal savings allowance",{"$f":"IF(D16=\"Basic Rate\", 'Data entry'!D10,IF(D16=\"Higher Rate\",'Data entry'!D11,'Data entry'!D12))","v":{"v":1000,"d":"£1,000"}},{"$f":"IF(E16=\"Basic Rate\", 'Data entry'!D10,IF(E16=\"Higher Rate\",'Data entry'!D11,'Data entry'!D12))","v":{"v":1000,"d":"£1,000"}},{"$nulls":6},"Total liability on Onshore gain(s)",{"$nulls":3},{"$f":"MAX(0,SUM(P5:P10)-P12)","v":{"v":0,"d":"£0"}}]
[null,null,"PSA available for bond gains",{"$f":"D43","v":{"v":1000,"d":"£1,000"}},{"$f":"D61","v":{"v":1000,"d":"£1,000.00"}},"Slice in bands"]
[null,null,"Dividend allowance",{"$f":"'Data entry'!D13","v":{"v":1000,"d":"£1,000"}},null,"Personal allowance",{"$f":"MIN(D7,D59)","v":{"v":0,"d":"£0"}},{"$f":"D7-G15","v":{"v":0,"d":"£0"}},{"v":0,"d":"0%"},{"$f":"G15*I15","v":{"v":0,"d":"£0"}}]
[null,null,"Tax payer ",{"$f":"'Data entry'!E30","v":"Basic Rate"},{"$f":"'Data entry'!F30","v":"Basic Rate"},"Starting rate for savings",{"$f":"MIN(D60,H15)","v":{"v":0,"d":"£0"}},{"$f":"H15-G16","v":{"v":0,"d":"£0"}},{"v":0,"d":"0%"},{"$f":"G16*I16","v":{"v":0,"d":"£0"}},null,"Important Information"]
[{"$nulls":5},"Personal savings allowance",{"$f":"MIN(D61,H16)","v":{"v":0,"d":"£0"}},{"$f":"H16-G17","v":{"v":0,"d":"£0"}},{"v":0,"d":"0%"},{"v":0,"d":"£0"},null,"The order of income used by this calculator is always earnings, savings (incl. offshore gains), dividends then onshore gains"]
[{"$nulls":5},"Basic rate",{"$f":"MIN(D63,H17)","v":{"v":0,"d":"£0"}},{"$f":"H17-G18","v":{"v":0,"d":"£0"}},{"v":0.2,"d":"20%"},{"v":0,"d":"£0"}]
[{"$nulls":5},"Higher rate ",{"$f":"MIN(D64,H18)","v":{"v":0,"d":"£0"}},{"$f":"H18-G19","v":{"v":0,"d":"£0"}},{"v":0.4,"d":"40%"},{"v":0,"d":"£0"},null,"This calculator always uses other savings prior to bond gains when allocating allowances"]
[{"$nulls":5},"Additional rate",{"$f":"H19","v":{"v":0,"d":"£0"}},{"$f":"H19-G20","v":{"v":0,"d":"£0"}},{"v":0.45,"d":"45%"},{"v":0,"d":"£0"}]
[{"$nulls":5},"Total tax due on slice",{"$nulls":3},{"$f":"SUM(J15:J20)","v":{"v":0,"d":"£0"}},null,"This calculator allows you to calculate UK Income Tax on chargeable events  "]
[{"$nulls":5},"Basic rate treated as paid*",{"$nulls":3},{"$f":"IFERROR(ROUNDUP((D5+D6)/D8*0.2,0)-ROUNDUP((G15*0.2),0),0)","v":{"v":0,"d":"£0"}}]
[{"$nulls":5},"Total relieved liability**",{"$nulls":3},{"$f":"MAX(0,(J21-J22)*D8)","v":{"v":0,"d":"£0"}},null,"This calculator is based on Old Mutual Wealth’s interpretation of the law and HM Revenue and Customs practice as at June 2019. We believe this to be correct, but cannot guarantee it. Tax relief and the tax treatment of investment funds may change. "]
[{"$nulls":5},"Relief and tax due "]
[{"$nulls":5},"Top slicing relief***",{"$nulls":3},{"$f":"IF(D8=0,0,P13+P39-J23)","v":{"v":0,"d":"£0"}},null,"You should be satisfied that the information you have entered and the results of any calculation are correct, before acting or refraining from acting in reliance upon the information given. "]
[{"$nulls":5},"Tax due on gain(s) after relief",{"$nulls":3},{"$f":"MAX(0,J11+P13-J25)","v":{"v":0,"d":"£0"}}]
[{"$nulls":5},"* Tax treated as paid is included for offshore bonds for the purpose of top slicing relief only (s531 ITTOIA 2005)                                                                                                                                                          ** Tax due on aggregate slice multiplied by average years                                                             *** The difference between the total tax due above the tax credit on the total offshore and onshore gain(s) and the relieved liability",{"$nulls":5},"We accept no responsibility for any tax liability that may arise as a result of your decision to advise your clients following the use of this tool. "]
[]
[]
[]
[null,null,"Income order",{"$nulls":8},"Combined top slicing only"]
[null,null,"Earned income",{"$f":"'Data entry'!D29","v":{"v":0,"d":"£0.00"}},{"$nulls":7},"Within personal allowance",{"$f":"MIN(D72,(D6+D5))","v":{"v":0,"d":"£0"}},{"$f":"(D34+D36)-M32","v":{"v":0,"d":"£0"}},{"v":0,"d":"0%"},{"$f":"M32*O32","v":{"v":0,"d":"£0"}}]
[null,null,"Savings income",{"$f":"'Data entry'!D30","v":{"v":0,"d":"£0.00"}},{"$nulls":7},"Starting rate for savings",{"$f":"MIN(D73,N32)","v":{"v":0,"d":"£0"}},{"$f":"N32-M33","v":{"v":0,"d":"£0"}},{"v":0,"d":"0%"},{"v":0,"d":"£0"}]
[null,null,"Offshore bond gains",{"$f":"D6","v":{"v":0,"d":"£0.00"}},{"$nulls":7},"Personal savings allowance",{"$f":"MIN(D74,N33)","v":{"v":0,"d":"£0"}},{"$f":"N33-M34","v":{"v":0,"d":"£0"}},{"v":0,"d":"0%"},{"v":0,"d":"£0"}]
[null,null,"Dividends ",{"$f":"'Data entry'!D31","v":{"v":0,"d":"£0.00"}},{"$nulls":7},"Basic rate",{"$f":"MIN(D76,N34)","v":{"v":0,"d":"£0"}},{"$f":"N34-M35","v":{"v":0,"d":"£0"}},{"v":0.2,"d":"20%"},{"v":0,"d":"£0"}]
[null,null,"Onshore bond gains",{"$f":"D5","v":{"v":0,"d":"£0.00"}},{"$nulls":7},"Higher rate ",{"$f":"MIN(D77,N35)","v":{"v":0,"d":"£0"}},{"$f":"N35-M36","v":{"v":0,"d":"£0"}},{"v":0.4,"d":"40%"},{"v":0,"d":"£0"}]
[{"$nulls":11},"Additional rate",{"$f":"N36","v":{"v":0,"d":"£0"}},{"$f":"N36-M37","v":{"v":0,"d":"£0"}},{"v":0.45,"d":"45%"},{"v":0,"d":"£0"}]
[{"$nulls":11},"Total tax on combined gains",{"$nulls":3},{"$f":"SUM(P32:P37)","v":{"v":0,"d":"£0"}}]
[{"$nulls":11},"Total liability for slicing only",{"$nulls":3},{"$f":"MAX(0,P38-((D6+D5)*0.2-(M32*0.2)))","v":{"v":0,"d":"£0"}}]
[null,null,"Allowances left after income Offshore",{"$nulls":9},{"$f":"ROUNDUP((D5+D6)*0.2,0)-(M32*0.2)","v":{"v":0,"d":"£0.00"}}]
[null,null,"Personal allowance",{"$f":"MAX(0,D$10-D$32-D$33)","v":{"v":12570,"d":"£12,570"}}]
[null,null,"Starting rate for savings",{"$f":"MAX(0,IF(D$32+D$33>=D$10+'Data entry'!D$9,0,MIN(D$10+'Data entry'!D$9-(D$32+D$33),'Data entry'!D9)))","v":{"v":5000,"d":"£5,000"}}]
[null,null,"PSA basic",{"$f":"MAX(0,IF(D$33=0,D$13,D$13-IF(D$33+D$32<=D$10+'Data entry'!D$9,0,IF(D$32>=D$10+'Data entry'!D$9,D$33,(D$32+D$33)-(D$10+'Data entry'!D$9)))))","v":{"v":1000,"d":"£1,000.00"}},{"$f":"MAX(0,D11+D10-D32-D33)","v":{"v":50270,"d":"£50,270.00"}},{"$f":"MIN(D43,E43)","v":{"v":1000,"d":"£1,000.00"}}]
[null,null,"PSA higher",{"$f":"MAX(0,D13-F43-D33)","v":{"v":0,"d":"£0.00"}}]
[null,null,"Basic rate allowance",{"$f":"MAX(0,D$11-(MAX(0,D$32+D$33-D$10))-F43-D42)","v":{"v":31700,"d":"£31,700.00"}}]
[null,null,"Higher rate allowance",{"$f":"MAX(0,D$12-MAX(0,(D$32+D$33-D$11-D$10))-D44)","v":{"v":87440,"d":"£87,440.00"}}]
[]
[]
[null,null,"Allowances left after income Onshore"]
[null,null,"Personal allowance",{"$f":"MAX(0,D$10-D$32-D$33-D35-D34)","v":{"v":12570,"d":"£12,570"}}]
[null,null,"Starting rate for savings",{"$f":"MAX(0,IF(D$32+D$33+D$34+D$35>=D$10+'Data entry'!D$9,0,MIN(D$10+'Data entry'!D$9-(D$32+D$33+D$34+D$35),'Data entry'!D9)))","v":{"v":5000,"d":"£5,000"}}]
[null,null,"PSA basic",{"$f":"MAX(0,IF(D$33+D$34=0,D$13,D$13-IF(D$33+D$32+D$34<=D$10+'Data entry'!D$9,0,IF(D$32>=D$10+'Data entry'!D$9,D$33+D$34,(D$32+D$33+D$34)-(D$10+'Data entry'!D$9)))))","v":{"v":1000,"d":"£1,000.00"}},{"$f":"MAX(0,D$11+D$10-D$32-D$33-D$34)","v":{"v":50270,"d":"£50,270.00"}},{"$f":"MIN(D52,E52)","v":{"v":1000,"d":"£1,000.00"}}]
[null,null,"PSA higher",{"$f":"MAX(0,D$13-F52-D$33)","v":{"v":0,"d":"£0.00"}}]
[null,null,"Basic rate allowance",{"$f":"MAX(0,D$11-MAX(0,(D$32+D$33+D$34+D$35-D$10))-F52-D51)","v":{"v":31700,"d":"£31,700.00"}}]
[null,null,"Higher rate allowance",{"$f":"MAX(0,D$12-MAX(0,(D$32+D$33+D$34+D$35-D$11-D$10))-D53)","v":{"v":87440,"d":"£87,440.00"}}]
[]
[]
[null,null,"Allowances left after income Slice"]
[null,null,"Personal allowance",{"$f":"MAX(0,E$10-D$32-D$33-D35)","v":{"v":12570,"d":"£12,570"}}]
[null,null,"Starting rate for savings",{"$f":"MAX(0,IF(D$32+D$33+D$35>=E$10+'Data entry'!D$9,0,MIN(E$10+'Data entry'!D$9-(D$32+D$33+D$35),'Data entry'!D9)))","v":{"v":5000,"d":"£5,000"}}]
[null,null,"PSA basic",{"$f":"MAX(0,IF(D$33=0,E$13,E$13-IF(D$33+D$32<=E$10+'Data entry'!D$9,0,IF(D$32>=E$10+'Data entry'!D$9,D$33,(D$32+D$33)-(E$10+'Data entry'!D$9)))))","v":{"v":1000,"d":"£1,000.00"}},{"$f":"MAX(0,D$11+E$10-D$32-D$33)","v":{"v":50270,"d":"£50,270.00"}},{"$f":"MIN(D61,E61)","v":{"v":1000,"d":"£1,000.00"}}]
[null,null,"PSA higher",{"$f":"MAX(0,E13-F61-D33)","v":{"v":0,"d":"£0.00"}}]
[null,null,"Basic rate allowance",{"$f":"MAX(0,D$11-MAX(0,(D$32+D$33+D$35-E$10))-F61-D60)","v":{"v":31700,"d":"£31,700.00"}}]
[null,null,"Higher rate allowance",{"$f":"MAX(0,D$12-MAX(0,(D$32+D$33+D$35-D$11-E$10))-D62)","v":{"v":87440,"d":"£87,440.00"}}]
[]
[null,null,"Onshore average years"]
[null,null,"Total gain",{"$f":"SUMIF('Data entry'!F16:F25,\"Onshore\",'Data entry'!D16:D25)","v":0}]
[null,null,"Aggregate gain ",{"$f":"SUMIF('Data entry'!F16:F25,\"Onshore\",'Data entry'!J16:J25)","v":0}]
[{"$nulls":3},{"$f":"IFERROR(D67/D68,0)","v":0}]
[]
[null,null,"Allowances left after income combined (top slicing only)"]
[null,null,"Personal allowance",{"$f":"MAX(0,D10-D$32-D$33-D35)","v":{"v":12570,"d":"£12,570"}}]
[null,null,"Starting rate for savings",{"$f":"MAX(0,IF(D$32+D$33+D$35>=D$10+'Data entry'!D$9,0,MIN(D$10+'Data entry'!D$9-(D$32+D$33+D$35),'Data entry'!D9)))","v":{"v":5000,"d":"£5,000"}}]
[null,null,"PSA basic",{"$f":"MAX(0,IF(D$33=0,D$13,D$13-IF(D$33+D$32<=D$10+'Data entry'!D$9,0,IF(D$32>=D$10+'Data entry'!D$9,D$33,(D$32+D$33)-(D$10+'Data entry'!D$9)))))","v":{"v":1000,"d":"£1,000.00"}},{"$f":"MAX(0,D$11+E$10-D$32-D$33)","v":{"v":50270,"d":"£50,270.00"}},{"$f":"MIN(D74,E74)","v":{"v":1000,"d":"£1,000.00"}}]
[null,null,"PSA higher",{"$f":"MAX(0,D$13-F74-D$33)","v":{"v":0,"d":"£0.00"}}]
[null,null,"Basic rate allowance",{"$f":"MAX(0,D$11-MAX(0,(D$32+D$33+D$35-D$10))-F74-D73)","v":{"v":31700,"d":"£31,700.00"}}]
[null,null,"Higher rate allowance",{"$f":"MAX(0,D$12-MAX(0,(D$32+D$33+D$35-D$11-D$10))-D75)","v":{"v":87440,"d":"£87,440.00"}}]

{"sheet":"Results","index":3,"n_rows":73,"n_cols":10,"rows_kept":73,"merged":[[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[16,2,18,6],[19,2,19,9],[20,2,20,9],[63,2,64,9],[65,2,65,9],[66,2,66,9],[67,2,67,10],[68,2,68,9],[69,2,69,9],[71,2,71,9],[72,2,72,9],[73,2,73,6]]}
[]
[]
[]
[{"$nulls":3},"Results summary"]
[]
[null,null,"Input summary"]
[]
[null,null,"Income details entered",{"$nulls":4},"Chargeable event gains entered (after time apportionment if applicable)"]
[null,null,"Earned income (PAYE, Pension, Rental)",null,{"$f":"'Data entry'!D29","v":{"v":0,"d":"£0"}},null,null,"Total onshore gains ",{"$f":"'Results-hidden'!D5","v":{"v":0,"d":"£0"}}]
[null,null,"Savings Income (interest)",null,{"$f":"'Data entry'!D30","v":{"v":0,"d":"£0"}},null,null,"Total offshore gains ",{"$f":"'Results-hidden'!D6","v":{"v":0,"d":"£0"}}]
[null,null,"Dividend income",null,{"$f":"'Data entry'!D31","v":{"v":0,"d":"£0"}},null,null,"Total aggregate slice",{"$f":"'Results-hidden'!D7","v":{"v":0,"d":"£0"}}]
[null,null,"Gross pension contributions",null,{"$f":"'Data entry'!D32","v":{"v":0,"d":"£0"}},null,null,"Average years",{"$f":"'Results-hidden'!D8","v":{"v":0,"d":"0.000"}}]
[]
[null,null,"High level results"]
[null,null,"Top slicing relief given",null,{"$f":"E57","v":{"v":0,"d":"£0"}}]
[null,null,"Tax due on gain(s) after relief",null,{"$f":"J57","v":{"v":0,"d":"£0"}}]
[null,null,{"$f":"IF(E36<'Data entry'!D6,\"Please note, total income including the bond gain(s) exceeds £100,000. Personal allowance is lost at a rate of £1 for every £2 above this. This may result in additional tax for your client even if there is no tax due on the bond gain\",\"\")","v":""}]
[]
[]
[null,null,"The amount of relief available is determined by comparing the total liability and the relieved liability. These steps are explained further with example in our Quick reference guide - 5 which can be found here:"]
[null,null,"https://platform.quilter.com/support-and-help/platform-articles-and-technical-insights/chargeable-events-hub/"]
[null,null,"Calculation steps in detail"]
[null,null,"Tax before relief"]
[null,null,"Tax before top slicing relief (onshore gains)","Gain(s) in bands","Tax",null,null,"Tax before top slicing relief (offshore gains)","Gain(s) in bands","Tax"]
[null,null,"Personal allowance",{"$f":"'Results-hidden'!M5","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!P5","v":{"v":0,"d":"£0"}},null,null,"Personal allowance",{"$f":"'Results-hidden'!G5","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!J5","v":{"v":0,"d":"£0"}}]
[null,null,"Starting rate for savings",{"$f":"'Results-hidden'!M6","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!P6","v":{"v":0,"d":"£0"}},null,null,"Starting rate for savings",{"$f":"'Results-hidden'!G6","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!J6","v":{"v":0,"d":"£0"}}]
[null,null,"Personal savings allowance",{"$f":"'Results-hidden'!M7","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!P7","v":{"v":0,"d":"£0"}},null,null,"Personal savings allowance",{"$f":"'Results-hidden'!G7","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!J7","v":{"v":0,"d":"£0"}}]
[null,null,"Basic rate",{"$f":"'Results-hidden'!M8","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!P8","v":{"v":0,"d":"£0"}},null,null,"Basic rate",{"$f":"'Results-hidden'!G8","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!J8","v":{"v":0,"d":"£0"}}]
[null,null,"Higher rate ",{"$f":"'Results-hidden'!M9","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!P9","v":{"v":0,"d":"£0"}},null,null,"Higher rate ",{"$f":"'Results-hidden'!G9","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!J9","v":{"v":0,"d":"£0"}}]
[null,null,"Additional rate",{"$f":"'Results-hidden'!M10","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!P10","v":{"v":0,"d":"£0"}},null,null,"Additional rate",{"$f":"'Results-hidden'!G10","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!J10","v":{"v":0,"d":"£0"}}]
[null,null,"Total tax on Onshore gain(s)",null,{"$f":"'Results-hidden'!P11","v":{"v":0,"d":"£0"}},null,null,"Total liability on offshore gain(s)",null,{"$f":"'Results-hidden'!J11","v":{"v":0,"d":"£0"}}]
[null,null,"Onshore credit",null,{"$f":"'Results-hidden'!P12","v":{"v":0,"d":"£0"}}]
[null,null,"Total liability on Onshore gain(s)",null,{"$f":"'Results-hidden'!P13","v":{"v":0,"d":"£0"}},null,null,"Total tax before top slicing relief (onshore & offshore gains)",null,{"$f":"'Results-hidden'!P13+'Results-hidden'!J11","v":{"v":0,"d":"£0"}}]
[null,null,"Calculating the relief"]
[null,null,"Step 1 - allowances available"]
[null,null,"Personal allowance",null,{"$f":"'Results-hidden'!D10","v":{"v":12570,"d":"£12,570"}},null,null,"Personal allowance based on aggregate slice",null,{"$f":"'Results-hidden'!E10","v":{"v":12570,"d":"£12,570"}}]
[null,null,"Personal allowance available for bond gain(s)",null,{"$f":"'Results-hidden'!D72","v":{"v":12570,"d":"£12,570"}},null,null,"Personal allowance available for aggregate slice",null,{"$f":"'Results-hidden'!D59","v":{"v":12570,"d":"£12,570"}}]
[null,null,"Personal savings allowance",null,{"$f":"'Results-hidden'!D13","v":{"v":1000,"d":"£1,000"}},null,null,"Personal savings allowance based on aggregate slice",null,{"$f":"'Results-hidden'!E13","v":{"v":1000,"d":"£1,000"}}]
[null,null,"Personal savings allowance available for bond gain(s)",null,{"$f":"'Results-hidden'!D14","v":{"v":1000,"d":"£1,000"}},null,null,"Personal savings allowance available for aggregate slice",null,{"$f":"'Results-hidden'!E14","v":{"v":1000,"d":"£1,000"}}]
[]
[null,null,"Step 2 - total liability of gain(s) above basic rate credit *","Gain(s) in bands","Tax",null,null,"Step 3 - relieved liability above basic rate credit ","Gain(s) in bands","Tax"]
[null,null,"Personal allowance",{"$f":"'Results-hidden'!M32","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!P32","v":{"v":0,"d":"£0"}},null,null,"Personal allowance",{"$f":"'Results-hidden'!$G$15","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!$J$15","v":{"v":0,"d":"£0"}}]
[null,null,"Starting rate for savings",{"$f":"'Results-hidden'!M33","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!P33","v":{"v":0,"d":"£0"}},null,null,"Starting rate for savings",{"$f":"'Results-hidden'!$G$16","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!$J$16","v":{"v":0,"d":"£0"}}]
[null,null,"Personal savings allowance",{"$f":"'Results-hidden'!M34","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!P34","v":{"v":0,"d":"£0"}},null,null,"Personal savings allowance",{"$f":"'Results-hidden'!$G$17","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!$J$17","v":{"v":0,"d":"£0"}}]
[null,null,"Basic rate",{"$f":"'Results-hidden'!M35","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!P35","v":{"v":0,"d":"£0"}},null,null,"Basic rate",{"$f":"'Results-hidden'!$G$18","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!$J$18","v":{"v":0,"d":"£0"}}]
[null,null,"Higher rate ",{"$f":"'Results-hidden'!M36","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!P36","v":{"v":0,"d":"£0"}},null,null,"Higher rate ",{"$f":"'Results-hidden'!$G$19","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!$J$19","v":{"v":0,"d":"£0"}}]
[null,null,"Additional rate",{"$f":"'Results-hidden'!M37","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!P37","v":{"v":0,"d":"£0"}},null,null,"Additional rate",{"$f":"'Results-hidden'!$G$20","v":{"v":0,"d":"£0"}},{"$f":"'Results-hidden'!$J$20","v":{"v":0,"d":"£0"}}]
[null,null,"Total tax on gain(s)",null,{"$f":"'Results-hidden'!P38","v":{"v":0,"d":"£0"}},null,null,"Total tax due on slice",null,{"$f":"'Results-hidden'!$J$21","v":{"v":0,"d":"£0"}}]
[null,null,"Tax credit**",null,{"$f":"'Results-hidden'!M40","v":{"v":0,"d":"£0"}},null,null,"Tax credit**",null,{"$f":"'Results-hidden'!$J$22","v":{"v":0,"d":"£0"}}]
[null,null,"Total liability on gain(s)",null,{"$f":"MAX(0,E48-E49)","v":{"v":0,"d":"£0"}},null,null,"Total liability on slice (onshore & offshore combined)",null,{"$f":"MAX(J48-J49,0)","v":{"v":0,"d":"£0"}}]
[]
[null,null,"Total liability (onshore & offshore combined)",null,{"$f":"E50","v":{"v":0,"d":"£0"}},null,null,"Total relieved liability (total liability on slice x average years)",null,{"$f":"'Results-hidden'!$J$23","v":{"v":0,"d":"£0"}}]
[]
[null,null,"Step 4 - top slicing relief amount",{"$nulls":4},"Step 5 - Tax after relief"]
[null,null,"Total liability (onshore & offshore) minus",null,{"$f":"E52","v":{"v":0,"d":"£0"}},null,null,"Total tax before top slicing relief (onshore & offshore gains) minus",null,{"$f":"J33","v":{"v":0,"d":"£0"}}]
[null,null,"Total relieved liability (total liability on slice x average years)","-",{"$f":"J52","v":{"v":0,"d":"£0"}},null,null,"Top slicing relief (Step 4)","-",{"$f":"E57","v":{"v":0,"d":"£0"}}]
[{"$nulls":4},{"$f":"E55-E56","v":{"v":0,"d":"£0"}},{"$nulls":4},{"$f":"MAX(0,J55-J56)","v":{"v":0,"d":"£0"}}]
[]
[]
[]
[]
[]
[null,null,"Important Information"]
[null,null,"The order of income used by this calculator is earnings, savings (incl. offshore gains), dividends then onshore gains including where income sits within an allowance. When calculating the amount of relief the order is changed so that gains (onshore and offshore) form highest part of income"]
[]
[null,null,"In line with legislation this calculator always uses other income prior to chargeable event gains when allocating allowances"]
[null,null,"This calculator allows you to calculate UK Income Tax on chargeable events  "]
[null,null,"This calculator is based on Quilter’s interpretation of the law and HM Revenue and Customs practice as at  May 2023. We believe this to be correct, but cannot guarantee it. Tax relief and the tax treatment of investment funds may change. "]
[null,null,"You should be satisfied that the information you have entered and the results of any calculation are correct, before acting or refraining from acting in reliance upon the information given. "]
[null,null,"We accept no responsibility for any tax liability that may arise as a result of your decision to advise your clients following the use of this tool. "]
[]
[null,null,"* Tax treated as paid is included for offshore bonds for the purpose of top slicing relief only (s531 ITTOIA 2005)    "]
[null,null,"** The tax credit is calculated as 20% of the gain. The gain is reduced for this purpose by any amount within the personal allowance"]