{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Income Tax (for Top Slicing)","Inputs","Inputs Printer Friendly","Non SRIT - UFPLS","Net UFPLS Income","Non SRIT - DD","Net DD Income","Workings (Top Slicing)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"Income Tax (for Top Slicing)","index":0,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
["Existing Position",null,null,null,null,null,"After new contribution"]
["Allowances"]
["Adjusted Net Income (for allowance purposes)",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"A3","v":"Adjusted Net Income (for allowance purposes)"},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Personal Allowance",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C3-#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"A5","v":"Personal Allowance"},null,{"$f":"C5","v":{"$error":"#REF!"}},{"$f":"I3-#REF!","v":{"$error":"#REF!"}}]
["Adjustment",null,{"$f":"IF(D5<1,0,(IF(D5>(2*#REF!),-C5,MAX(-C5,D5/-2))))","v":{"$error":"#REF!"}},{"$f":"SUM(C5:C6)","v":{"$error":"#REF!"}},null,null,{"$f":"A6","v":"Adjustment"},null,{"$f":"IF(J5<1,0,(IF(#REF!>(2*#REF!),-I5,MAX(-I5,J5/-2))))","v":{"$error":"#REF!"}},{"$f":"SUM(I5:I6)","v":{"$error":"#REF!"}}]
[]
["Additional Age Allowance",null,{"$f":"IF(#REF!=\"After 5 April 1948\",0,#REF!)","v":{"$error":"#REF!"}},{"$f":"C3-#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"A8","v":"Additional Age Allowance"},null,{"$f":"C8","v":{"$error":"#REF!"}},{"$f":"I3-#REF!","v":{"$error":"#REF!"}}]
["Adjustment",null,{"$f":"IF(D8<1,0,(IF(E8>(2*#REF!),-C8,MAX(-C8,D8/-2))))","v":{"$error":"#REF!"}},{"$f":"SUM(C8:C9)","v":{"$error":"#REF!"}},null,null,{"$f":"A9","v":"Adjustment"},null,{"$f":"IF(J8<1,0,(IF(#REF!>(2*#REF!),-I8,MAX(-I8,J8/-2))))","v":{"$error":"#REF!"}},{"$f":"SUM(I8:I9)","v":{"$error":"#REF!"}}]
[]
["Total Allowance",null,null,{"$f":"D6+D9","v":{"$error":"#REF!"}},null,null,{"$f":"A11","v":"Total Allowance"},null,null,{"$f":"J6+J9","v":{"$error":"#REF!"}}]
[]
["Tax Calculation"]
[]
["Income",null,null,{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"A15","v":"Income"},null,null,null,{"$f":"D15","v":{"$error":"#REF!"}}]
["Less ",null,null,null,null,null,{"$f":"A16","v":"Less "}]
["Contributions Paid Gross",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"A17","v":"Contributions Paid Gross"},null,null,{"$f":"C17+#REF!","v":{"$error":"#REF!"}}]
["Allowance",null,{"$f":"'Income Tax (for Top Slicing)'!D11","v":{"$error":"#REF!"}},{"$f":"SUM(C17:C18)","v":{"$error":"#REF!"}},null,null,{"$f":"A18","v":"Allowance"},null,null,{"$f":"J11","v":{"$error":"#REF!"}},{"$f":"SUM(J17:J18)","v":{"$error":"#REF!"}}]
["Taxable Income",null,null,{"$f":"D15-D18","v":{"$error":"#REF!"}},null,null,{"$f":"A19","v":"Taxable Income"},null,null,null,{"$f":"K15-K18","v":{"$error":"#REF!"}}]
[]
[]
["Income",null,null,null,null,null,{"$f":"A22","v":"Income"}]
[{"$f":"'Workings (Top Slicing)'!F7","v":{"$error":"#REF!"}},"@",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"A23*C23","v":{"$error":"#REF!"}},null,null,{"$f":"'Workings (Top Slicing)'!L7","v":{"$error":"#REF!"}},"@",{"$f":"C23","v":{"$error":"#REF!"}},{"$f":"G23*I23","v":{"$error":"#REF!"}}]
[{"$f":"'Workings (Top Slicing)'!F8","v":{"$error":"#REF!"}},"@",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"A24*C24","v":{"$error":"#REF!"}},null,null,{"$f":"'Workings (Top Slicing)'!L8","v":{"$error":"#REF!"}},"@",{"$f":"C24","v":{"$error":"#REF!"}},{"$f":"G24*I24","v":{"$error":"#REF!"}}]
[{"$f":"'Workings (Top Slicing)'!F9","v":{"$error":"#REF!"}},"@",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"A25*C25","v":{"$error":"#REF!"}},{"$f":"SUM(D23:D25)","v":{"$error":"#REF!"}},null,{"$f":"'Workings (Top Slicing)'!L9","v":{"$error":"#REF!"}},"@",{"$f":"C25","v":{"$error":"#REF!"}},{"$f":"G25*I25","v":{"$error":"#REF!"}},{"$f":"SUM(J23:J25)","v":{"$error":"#REF!"}}]
["Dividend",null,null,null,null,null,{"$f":"A26","v":"Dividend"}]
[{"$f":"'Workings (Top Slicing)'!F14","v":{"$error":"#REF!"}},"@",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"A27*C27","v":{"$error":"#REF!"}},null,null,{"$f":"'Workings (Top Slicing)'!L14","v":{"$error":"#REF!"}},"@",{"$f":"C27","v":{"$error":"#REF!"}},{"$f":"G27*I27","v":{"$error":"#REF!"}}]
[{"$f":"'Workings (Top Slicing)'!F15","v":{"$error":"#REF!"}},"@",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"A28*C28","v":{"$error":"#REF!"}},null,null,{"$f":"'Workings (Top Slicing)'!L15","v":{"$error":"#REF!"}},"@",{"$f":"C28","v":{"$error":"#REF!"}},{"$f":"G28*I28","v":{"$error":"#REF!"}}]
[{"$f":"'Workings (Top Slicing)'!F16","v":{"$error":"#REF!"}},"@",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"A29*C29","v":{"$error":"#REF!"}},{"$f":"SUM(D27:D29)","v":{"$error":"#REF!"}},null,{"$f":"'Workings (Top Slicing)'!L16","v":{"$error":"#REF!"}},"@",{"$f":"C29","v":{"$error":"#REF!"}},{"$f":"G29*I29","v":{"$error":"#REF!"}},{"$f":"SUM(J27:J29)","v":{"$error":"#REF!"}}]
[]
["Bond Gain",null,null,null,null,null,{"$f":"A31","v":"Bond Gain"}]
[{"$f":"'Workings (Top Slicing)'!F19","v":{"$error":"#REF!"}},"@",0,{"$f":"A32*C32","v":{"$error":"#REF!"}},null,null,{"$f":"'Workings (Top Slicing)'!L19","v":{"$error":"#REF!"}},"@",0,{"$f":"G32*I32","v":{"$error":"#REF!"}}]
[{"$f":"'Workings (Top Slicing)'!F20","v":{"$error":"#REF!"}},"@",{"$f":"C23","v":{"$error":"#REF!"}},{"$f":"A33*C33","v":{"$error":"#REF!"}},null,null,{"$f":"'Workings (Top Slicing)'!L20","v":{"$error":"#REF!"}},"@",{"$f":"C33","v":{"$error":"#REF!"}},{"$f":"G33*I33","v":{"$error":"#REF!"}}]
[{"$f":"'Workings (Top Slicing)'!F21","v":{"$error":"#REF!"}},"@",{"$f":"C24","v":{"$error":"#REF!"}},{"$f":"A34*C34","v":{"$error":"#REF!"}},null,null,{"$f":"'Workings (Top Slicing)'!L21","v":{"$error":"#REF!"}},"@",{"$f":"C34","v":{"$error":"#REF!"}},{"$f":"G34*I34","v":{"$error":"#REF!"}}]
[{"$f":"'Workings (Top Slicing)'!F22","v":{"$error":"#REF!"}},"@",{"$f":"C25","v":{"$error":"#REF!"}},{"$f":"A35*C35","v":{"$error":"#REF!"}},{"$f":"SUM(D33:D35)","v":{"$error":"#REF!"}},null,{"$f":"'Workings (Top Slicing)'!L22","v":{"$error":"#REF!"}},"@",{"$f":"C35","v":{"$error":"#REF!"}},{"$f":"G35*I35","v":{"$error":"#REF!"}},{"$f":"SUM(J33:J35)","v":{"$error":"#REF!"}}]
["Capital Gain",null,null,null,null,null,{"$f":"A36","v":"Capital Gain"}]
[{"$f":"'Workings (Top Slicing)'!F25","v":{"$error":"#REF!"}},"@",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"A37*C37","v":{"$error":"#REF!"}},null,null,{"$f":"'Workings (Top Slicing)'!L25","v":{"$error":"#REF!"}},"@",{"$f":"C37","v":{"$error":"#REF!"}},{"$f":"G37*I37","v":{"$error":"#REF!"}}]
[{"$f":"'Workings (Top Slicing)'!F26","v":{"$error":"#REF!"}},"@",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"A38*C38","v":{"$error":"#REF!"}},{"$f":"SUM(D37:D38)","v":{"$error":"#REF!"}},null,{"$f":"'Workings (Top Slicing)'!L26","v":{"$error":"#REF!"}},"@",{"$f":"C38","v":{"$error":"#REF!"}},{"$f":"G38*I38","v":{"$error":"#REF!"}},{"$f":"SUM(J37:J38)","v":{"$error":"#REF!"}}]
["Total Tax Payable",null,null,null,{"$f":"SUM(E25:E38)","v":{"$error":"#REF!"}},null,"Total Tax Payable",null,null,null,{"$f":"SUM(K25:K38)","v":{"$error":"#REF!"}}]
["Less Dividend Tax Credit",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"Less Dividend Tax Credit",null,null,{"$f":"D40","v":{"$error":"#REF!"}}]
["        Onshore Bond Tax Credit",null,{"$f":"IF(#REF!=\"Yes\",#REF!*'Income Tax (for Top Slicing)'!C33,0)","v":{"$error":"#REF!"}},null,null,null,"        Onshore Bond Tax Credit",null,{"$f":"C41","v":{"$error":"#REF!"}}]
["        Top Slicing Relief",null,{"$f":"'Workings (Top Slicing)'!D50","v":{"$error":"#REF!"}},null,null,null,"        Top Slicing Relief",null,{"$f":"'Workings (Top Slicing)'!J50","v":{"$error":"#REF!"}}]
[null,null,"Restricted to tax on total bond gain.",{"$f":"MIN(SUM(C41:C42),E35)","v":{"$error":"#REF!"}},{"$f":"SUM(D40:D43)","v":{"$error":"#REF!"}},null,null,null,"Restricted to tax on total bond gain.",{"$f":"MIN(SUM(I41:I42),K35)","v":{"$error":"#REF!"}},{"$f":"SUM(J40:J43)","v":{"$error":"#REF!"}}]
["Tax to pay",null,null,null,{"$f":"MAX(0,E39-E43)","v":{"$error":"#REF!"}},null,"Tax to pay",null,null,null,{"$f":"MAX(0,K39-K43)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
["Warnings????"]

{"sheet":"Inputs","index":1,"n_rows":40,"n_cols":22,"rows_kept":40,"cut":false,"hidden":false,"merged":[[12,18,13,21],[27,17,27,21],[35,16,35,20],[39,2,51,12],[12,2,14,4],[8,2,8,4],[7,8,7,10],[7,11,7,12],[0,15,0,16],[6,15,6,17],[0,2,0,5],[3,2,4,4],[6,2,6,4]]}
[null,null,"Emergency Tax Tool\nbuilt by M&G",null,null,null,null,null,null,null,"Tax Year 2024/25",null,null,null,null,"Dropdowns"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drawdown","Gross Value",null,null,"SUICIDE Code"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UFPLS","Net Value",null,null,{"$f":"TODAY()","v":"2024-04-05"}]
[null,null,"Input your details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-04-05"]
[]
[]
[null,null,"Type of Payment",null,null,null,null,null,null,null,null,null,null,null,null,"Logic for the question"]
[null,null,null,null,null,null,null,null,"Please Enter the Value",null,null,0,null,null,null,null,null,{"$f":"IF(AND(F7=P2,F9=Q2),1,0)","v":0}]
[null,null,"Gross or Net Value Required",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F7=P2,F9=Q3),2,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F7=P3,F9=Q2),3,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F7=P3,F9=Q3),4,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum for Logic",null,{"$f":"SUM(R8:R11)","v":0}]
[null,null,"Results",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Results pulled through from Tabs"]
[null,null,null,null,null,null,null,"Amount",null,"Tax Rate",null,"Tax Due"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P2","v":"Drawdown"},{"$f":"P2","v":"Drawdown"},{"$f":"P3","v":"UFPLS"},{"$f":"P3","v":"UFPLS"}]
[null,null,"Amount Free of Tax",null,null,null,null,{"$f":"IF(R12=1,S19,IF(R12=2,T19,IF(R12=3,U19,IF(R12=4,V19,0))))","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"Q2","v":"Gross Value"},{"$f":"Q3","v":"Net Value"},{"$f":"Q2","v":"Gross Value"},{"$f":"Q3","v":"Net Value"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"'Non SRIT - DD'!C2","v":0},{"$f":"'Net DD Income'!E2","v":0},{"$f":"'Non SRIT - UFPLS'!C3","v":0},{"$f":"'Net UFPLS Income'!G2","v":0}]
[null,null,"Income Taxable Element",null,null,null,null,{"$f":"IF(R12=1,S20,IF(R12=2,T20,IF(R12=3,U20,IF(R12=4,V20,0))))","v":0},null,null,null,null,null,null,null,null,null,"Tax Free if UFPLS",0,0,{"$f":"U18*0.25","v":0},{"$f":"V18*0.25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taxable Element",{"$f":"'Non SRIT - DD'!C3","v":0},{"$f":"T18","v":0},{"$f":"'Non SRIT - UFPLS'!C4","v":0},{"$f":"'Net UFPLS Income'!G3","v":0}]
[null,null,"Total Payment",null,null,null,null,{"$f":"H17+H19","v":0},null,null,null,null,null,null,null,null,null,"Tax Free",{"$f":"'Non SRIT - DD'!F2","v":0},{"$f":"'Net DD Income'!F22","v":0},{"$f":"'Non SRIT - UFPLS'!F3","v":0},{"$f":"'Net UFPLS Income'!F23","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Basic rate",{"$f":"'Non SRIT - DD'!F3","v":0},{"$f":"'Net DD Income'!F23","v":0},{"$f":"'Non SRIT - UFPLS'!F4","v":0},{"$f":"'Net UFPLS Income'!F24","v":0}]
[null,null,"Income Tax",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Higher rate",{"$f":"'Non SRIT - DD'!F4","v":0},{"$f":"'Net DD Income'!F24","v":0},{"$f":"'Non SRIT - UFPLS'!F5","v":0},{"$f":"'Net UFPLS Income'!F25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional Rate",{"$f":"'Non SRIT - DD'!F5","v":0},{"$f":"'Net DD Income'!F25","v":0},{"$f":"'Non SRIT - UFPLS'!F6","v":0},{"$f":"'Net UFPLS Income'!F26","v":0}]
[null,null,"Tax Free",null,null,null,null,{"$f":"IF(R12=1,S21,IF(R12=2,T21,IF(R12=3,U21,IF(R12=4,V21,0))))","v":0},null,0,null,{"$f":"H25*J25","v":0}]
[]
[null,null,"Basic Rate",null,null,null,null,{"$f":"IF(R12=1,S22,IF(R12=2,T22,IF(R12=3,U22,IF(R12=4,V22,0))))","v":0},null,0.2,null,{"$f":"H27*J27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parameters"]
[null,null,"Higher Rate",null,null,null,null,{"$f":"IF(R12=1,S23,IF(R12=2,T23,IF(R12=3,U23,IF(R12=4,V23,0))))","v":0},null,0.4,null,{"$f":"H29*J29","v":0},null,null,null,null,"Pers Allow",12579,"Use Block ten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Div by 12",{"$f":"R29/12","v":1048.25}]
[null,null,"Additional Rate",null,null,null,null,{"$f":"IF(R12=1,S24,IF(R12=2,T24,IF(R12=3,U24,IF(R12=4,V24,0))))","v":0},null,0.45,null,{"$f":"H31*J31","v":0}]
[]
[]
[null,null,"Total Tax",null,null,null,null,null,null,null,null,{"$f":"SUM(L25:L33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"Only yellow boxes need updated"]
[null,null,"Net amount after Emergency Tax is applied",null,null,null,null,{"$f":"H21-L34","v":0},null,null,null,null,null,null,null,null,"Income Tax rates and taxable bands"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personal Allowance",null,null,null,{"$f":"R29","v":12579},{"$f":"ROUNDUP(U37/12,0)","v":1049}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Basic rate",0.2,0,"to",37700,{"$f":"ROUNDUP(U38/12,0)","v":3142}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Higher rate",0.4,{"$f":"U38+1","v":37701},"to",125140,{"$f":"ROUNDUP((U39-U38)/12,0)","v":7287}]
[null,null,"This calculator is designed to give a general demonstration of how the operation of Emergency Tax has an effect on the payment of an Uncrystallised Fund Pension Lump Sum (UFPLS) and the first payment from drawdown. It does not take into account all the possible individual circumstances that may impact on the outcome. It should not be taken as offering advice or any recommendation.\n\nThe calculator assumes 25% of the UFPLS is entitled to be paid tax-free, however there are limited circumstances where this is not the case and professional advice should be sought to confirm individual treatment. For drawdown the whole payment will be taxable.\n\nThis calculator does not consider the Scottish Rate of Income Tax as emergency tax is based on UK rates.\n\nPlease note, this tool will cease to operate at the end of the tax year displayed above.\n\nThe information in this modeller is based on our understanding as at March 2024 of current taxation, legislation and HM Revenue & Customs practice all of which is subject to change without notice and before every care has been taken as to its accuracy, but it must be appreciated that neither Prudential nor its representatives can accept any responsibility for loss, however caused, suffered by any person who has acted or refrained from acting as a result of material contained in this calculator.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional rate",0.45,"Over ",null,{"$f":"U39","v":125140},{"$f":"U40/12","v":10428.333333333334}]

{"sheet":"Inputs Printer Friendly","index":2,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,2,54,12],[12,2,14,4],[0,2,0,5],[3,2,4,4],[6,2,6,4],[7,8,7,10],[7,11,7,12],[8,2,8,4]]}
[null,null,"Emergency Tax Tool\nbuilt by M&G",null,null,null,null,null,null,null,{"$f":"Inputs!K1","v":"Tax Year 2024/25"}]
[]
[]
[null,null,{"$f":"Inputs!C4","v":"Input your details"}]
[]
[]
[null,null,{"$f":"Inputs!C7","v":"Type of Payment"},null,null,{"$f":"Inputs!F7","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"Inputs!I8","v":"Please Enter the Value"},null,null,{"$f":"Inputs!L8","v":0}]
[null,null,{"$f":"Inputs!C9","v":"Gross or Net Value Required"},null,null,{"$f":"Inputs!F9","v":0}]
[]
[]
[]
[null,null,"Results"]
[null,null,null,null,null,null,null,"Amount",null,"Tax Rate",null,"Tax Due"]
[]
[]
[null,null,{"$f":"Inputs!C17","v":"Amount Free of Tax"},null,null,null,null,{"$f":"Inputs!H17","v":0}]
[]
[null,null,{"$f":"Inputs!C19","v":"Income Taxable Element"},null,null,null,null,{"$f":"Inputs!H19","v":0}]
[]
[null,null,{"$f":"Inputs!C21","v":"Total Payment"},null,null,null,null,{"$f":"Inputs!H21","v":0}]
[]
[null,null,{"$f":"Inputs!C23","v":"Income Tax"}]
[]
[null,null,{"$f":"Inputs!C25","v":"Tax Free"},null,null,null,null,{"$f":"Inputs!H25","v":0},null,{"$f":"Inputs!J25","v":0},null,{"$f":"Inputs!L25","v":0}]
[]
[null,null,{"$f":"Inputs!C27","v":"Basic Rate"},null,null,null,null,{"$f":"Inputs!H27","v":0},null,{"$f":"Inputs!J27","v":0.2},null,{"$f":"Inputs!L27","v":0}]
[]
[null,null,{"$f":"Inputs!C29","v":"Higher Rate"},null,null,null,null,{"$f":"Inputs!H29","v":0},null,{"$f":"Inputs!J29","v":0.4},null,{"$f":"Inputs!L29","v":0}]
[]
[null,null,{"$f":"Inputs!C31","v":"Additional Rate"},null,null,null,null,{"$f":"Inputs!H31","v":0},null,{"$f":"Inputs!J31","v":0.45},null,{"$f":"Inputs!L31","v":0}]
[]
[]
[null,null,{"$f":"Inputs!C34","v":"Total Tax"},null,null,null,null,null,null,null,null,{"$f":"Inputs!L34","v":0}]
[]
[null,null,{"$f":"Inputs!C36","v":"Net amount after Emergency Tax is applied"},null,null,null,null,{"$f":"Inputs!H36","v":0}]
[]
[]
[]
[null,null,{"$f":"Inputs!C40","v":"This calculator is designed to give a general demonstration of how the operation of Emergency Tax has an effect on the payment of an Uncrystallised Fund Pension Lump Sum (UFPLS) and the first payment from drawdown. It does not take into account all the possible individual circumstances that may impact on the outcome. It should not be taken as offering advice or any recommendation.\n\nThe calculator assumes 25% of the UFPLS is entitled to be paid tax-free, however there are limited circumstances where this is not the case and professional advice should be sought to confirm individual treatment. For drawdown the whole payment will be taxable.\n\nThis calculator does not consider the Scottish Rate of Income Tax as emergency tax is based on UK rates.\n\nPlease note, this tool will cease to operate at the end of the tax year displayed above.\n\nThe information in this modeller is based on our understanding as at March 2024 of current taxation, legislation and HM Revenue & Customs practice all of which is subject to change without notice and before every care has been taken as to its accuracy, but it must be appreciated that neither Prudential nor its representatives can accept any responsibility for loss, however caused, suffered by any person who has acted or refrained from acting as a result of material contained in this calculator."}]

{"sheet":"Non SRIT - UFPLS","index":3,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Tax Year","2020/21"]
[null,"UFPLS (gross)",{"$f":"Inputs!L8","v":0},null,"Tax Free",{"$f":"F25","v":0},"@",0,{"$f":"F3*H3","v":0}]
[null,"Taxable element",{"$f":"C3*0.75","v":0},null,"Basic rate",{"$f":"F26","v":0},"@",0.2,{"$f":"F4*H4","v":0}]
[null,null,null,null,"Higher rate",{"$f":"F27","v":0},"@",0.4,{"$f":"F5*H5","v":0}]
[null,null,null,null,"Additional Rate",{"$f":"F28","v":0},"@",0.45,{"$f":"F6*H6","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I3:I6)","v":0},null,null,null,null,null,null,null,"*"]
[null,null,null,null,null,null,null,null,"*may be small differences due to rounding"]
[]
[null,null,"INTERNAL USE ONLY",null,null,"Net Income",null,null,{"$f":"C3-I7","v":0}]
[]
[null,null,null,null,null,"Tax Rounded",null,null,{"$f":"I7","v":0}]
[null,null,null,null,null,"Net Income Rounded",null,null,{"$f":"I10","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Existing Position"]
[]
[null,null,"Do not alter - parameter in inputs",null,"Taxable ",{"$f":"C4","v":0}]
[]
[null,null,"Allowances","Still to tax","Allowance balance"]
[null,"Tax Free",{"$f":"Inputs!V37","v":1049},{"$f":"F22","v":0},{"$f":"MAX(0,C25-F25)","v":1049},{"$f":"IF(F22<C25,F22,C25)","v":0}]
[null,"Basic Rate",{"$f":"Inputs!V38","v":3142},{"$f":"F22-F25","v":0},{"$f":"MAX(0,C26-F26)","v":3142},{"$f":"MIN(D26,C26)","v":0}]
[null,"Higher Rate",{"$f":"Inputs!V39","v":7287},{"$f":"MAX(0,D26-F26)","v":0},{"$f":"MAX(0,C27-F27)","v":7287},{"$f":"MIN(D27,C27)","v":0}]
[null,"Additional Rate       >",null,{"$f":"MAX(0,D27-F27)","v":0},0,{"$f":"D28","v":0}]

{"sheet":"Net UFPLS Income","index":4,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[null,"Net Figure Required",null,null,null,null,{"$f":"Inputs!L8","v":0}]
[null,"Gross UFPLS Needed",null,null,null,null,{"$f":"VLOOKUP(\"use\",G9:H12,2,FALSE)","v":0}]
[null,"Taxable",null,null,null,null,{"$f":"G2*0.75","v":0},null,{"$f":"G2-G1","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I3","v":0}]
[]
[null,"Do not alter - parameter in inputs"]
[]
[null,"Band","Band Less Tax","TFC","Net Income Full band","Net Income Cumulative Full Band","Logic for usage","Calculated Gross  Figure"]
["NRT",{"$f":"Inputs!V37","v":1049},{"$f":"'Net DD Income'!C9","v":1049},{"$f":"C9/3","v":349.66666666666669},{"$f":"C9+D9","v":1398.6666666666667},{"$f":"E9","v":1398.6666666666667},{"$f":"IF(G1<=E9,\"Use\",\"Don't Use\")","v":"Use"},{"$f":"G1","v":0}]
["BRT",{"$f":"Inputs!V38","v":3142},{"$f":"'Net DD Income'!C10","v":2513.6000000000004},{"$f":"B10/3","v":1047.3333333333333},{"$f":"C10+D10","v":3560.9333333333334},{"$f":"F9+E10","v":4959.6000000000004},{"$f":"IF(AND(G1>F9,G1<=F10, G1<F11),\"use\",\"Don't use\")","v":"Don't use"},{"$f":"((G1-F9)/0.85)+E9","v":-246.82352941176487}]
["HRT",{"$f":"Inputs!V39","v":7287},{"$f":"'Net DD Income'!C11","v":4372.2},{"$f":"B11/3","v":2429},{"$f":"C11+D11","v":6801.2},{"$f":"F10+E11","v":11760.8},{"$f":"IF(AND(G1>F10,G1<=F11, G1<F12),\"use\",\"Don't use\")","v":"Don't use"},{"$f":"((G1-F10)/0.7)+B10+B9+D9+D10","v":-1497.142857142858}]
["ART",2000000000,{"$f":"'Net DD Income'!C12","v":1100000000000},{"$f":"C12/3","v":366666666666.66669},{"$f":"C12+E11","v":1100000006801.2},{"$f":"F11+E12","v":1100000018562},{"$f":"IF(G1>F11,\"use\",\"Don't use\")","v":"Don't use"},{"$f":"((G1-F11)/0.6625)+B11+B10+B9+D11+D10+D9","v":-2448.1509433962278}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Do not alter - parameter in inputs",null,"Taxable ",{"$f":"G3","v":0}]
[]
[null,null,"Allowances","Still to tax","Allowance balance"]
[null,"Tax Free",{"$f":"B9","v":1049},{"$f":"F20","v":0},{"$f":"MAX(0,C23-F23)","v":1049},{"$f":"IF(F20<C23,F20,C23)","v":0}]
[null,"Basic Rate",{"$f":"B10","v":3142},{"$f":"F20-F23","v":0},{"$f":"MAX(0,C24-F24)","v":3142},{"$f":"MIN(D24,C24)","v":0}]
[null,"Higher Rate",7287,{"$f":"MAX(0,D24-F24)","v":0},{"$f":"MAX(0,C25-F25)","v":7287},{"$f":"MIN(D25,C25)","v":0}]
[null,"Additional Rate       >",null,{"$f":"MAX(0,D25-F25)","v":0},0,{"$f":"D26","v":0}]

{"sheet":"Non SRIT - DD","index":5,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[null,"Tax Year","2019/20"]
[null,"DD (gross)",{"$f":"Inputs!L8","v":0},null,"Tax Free",{"$f":"F25","v":0},"@",{"$f":"'Non SRIT - UFPLS'!H3","v":0},{"$f":"F2*H2","v":0}]
[null,"Taxable element",{"$f":"C2","v":0},null,"Basic rate",{"$f":"F26","v":0},"@",{"$f":"'Non SRIT - UFPLS'!H4","v":0.2},{"$f":"F3*H3","v":0}]
[null,null,null,null,"Higher rate",{"$f":"F27","v":0},"@",{"$f":"'Non SRIT - UFPLS'!H5","v":0.4},{"$f":"F4*H4","v":0}]
[null,null,null,null,"Additional Rate",{"$f":"F28","v":0},"@",{"$f":"'Non SRIT - UFPLS'!H6","v":0.45},{"$f":"F5*H5","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I2:I5)","v":0}]
[null,null,null,null,null,null,null,null,"*may be small differences due to rounding",null,null,null,null,null,null,null,"*"]
[]
[null,null,null,null,null,"Net Income",null,null,{"$f":"C2-I6","v":0}]
[]
[null,null,null,null,null,"Tax Rounded",null,null,{"$f":"I6","v":0}]
[null,null,null,null,null,"Net Income Rounded",null,null,{"$f":"I9","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"Existing Position"]
[]
[null,null,"Do not alter - parameter in inputs",null,"Taxable ",{"$f":"C3","v":0}]
[]
[null,null,"Allowances","Still to tax","Allowance balance"]
[null,"Tax Free",{"$f":"Inputs!V37","v":1049},{"$f":"F22","v":0},{"$f":"MAX(0,C25-F25)","v":1049},{"$f":"IF(F22<C25,F22,C25)","v":0}]
[null,"Basic Rate",{"$f":"Inputs!V38","v":3142},{"$f":"F22-F25","v":0},{"$f":"MAX(0,C26-F26)","v":3142},{"$f":"MIN(D26,C26)","v":0}]
[null,"Higher Rate",{"$f":"Inputs!V39","v":7287},{"$f":"MAX(0,D26-F26)","v":0},{"$f":"MAX(0,C27-F27)","v":7287},{"$f":"MIN(D27,C27)","v":0}]
[null,"Additional Rate       >",null,{"$f":"MAX(0,D27-F27)","v":0},0,{"$f":"D28","v":0}]

{"sheet":"Net DD Income","index":6,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[null,"Net Figure Required",null,null,{"$f":"Inputs!L8","v":0}]
[null,"Gross DD Income Needed",null,null,{"$f":"VLOOKUP(\"use\",E9:F12,2,FALSE)","v":0}]
[null,null,null,null,null,null,{"$f":"E2-E1","v":0}]
[null,null,null,null,null,null,{"$f":"G3","v":0}]
[]
[null,"Do not alter - parameter in inputs"]
[]
[null,"Band","Net Income Full band","Net Income Cumulative Full Band","Logic for usage","Calculated Gross  Figure"]
["NRT",{"$f":"Inputs!V37","v":1049},{"$f":"B9*(1-'Non SRIT - UFPLS'!H3)","v":1049},{"$f":"C9","v":1049},{"$f":"IF(E1<=D9,\"Use\",\"Don't Use\")","v":"Use"},{"$f":"E1","v":0}]
["BRT",{"$f":"Inputs!V38","v":3142},{"$f":"B10*(1-'Non SRIT - UFPLS'!H4)","v":2513.6000000000004},{"$f":"C10+C9","v":3562.6000000000004},{"$f":"IF(AND(E1>D9,E1<=D10, E1<D11),\"use\",\"Don't use\")","v":"Don't use"},{"$f":"((E1-D9)/0.8)+D9","v":-262.25}]
["HRT",{"$f":"Inputs!V39","v":7287},{"$f":"B11*(1-'Non SRIT - UFPLS'!H5)","v":4372.2},{"$f":"C11+D10","v":7934.8},{"$f":"IF(AND(E1>D10,E1<=D11, E1<D12),\"use\",\"Don't use\")","v":"Don't use"},{"$f":"((E1-C10-C9)/0.6)+B10+B9","v":-1746.6666666666679}]
["ART",2000000000000,{"$f":"B12*(1-'Non SRIT - UFPLS'!H6)","v":1100000000000},{"$f":"C12+D11","v":1100000007934.8},{"$f":"IF(E1>D11,\"use\",\"Don't use\")","v":"Don't use"},{"$f":"((E1-D11)/0.55)+B11+B10+B9","v":-2948.9090909090901}]
[]
[]
[]
[]
[]
[]
[null,null,"Do not alter - parameter in inputs",null,"Taxable ",{"$f":"E2","v":0}]
[]
[null,null,"Allowances","Still to tax","Allowance balance"]
[null,"Tax Free",{"$f":"B9","v":1049},{"$f":"F19","v":0},{"$f":"MAX(0,C22-F22)","v":1049},{"$f":"IF(F19<C22,F19,C22)","v":0}]
[null,"Basic Rate",{"$f":"B10","v":3142},{"$f":"F19-F22","v":0},{"$f":"MAX(0,C23-F23)","v":3142},{"$f":"MIN(D23,C23)","v":0}]
[null,"Higher Rate",{"$f":"B11","v":7287},{"$f":"MAX(0,D23-F23)","v":0},{"$f":"MAX(0,C24-F24)","v":7287},{"$f":"MIN(D24,C24)","v":0}]
[null,"Additional Rate       >",null,{"$f":"MAX(0,D24-F24)","v":0},0,{"$f":"D25","v":0}]

{"sheet":"Workings (Top Slicing)","index":7,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
[null,"Existing Position",null,null,null,null,null,"After new contribution"]
[]
[null,"Taxable Income",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Taxable Income",null,null,null,{"$f":"F3","v":{"$error":"#REF!"}}]
[]
[null,null,"Allowances","Still to tax","Allowance balance",null,null,null,"Allowances","Still to tax","Allowance balance"]
[null,"Tax Free",{"$f":"'Income Tax (for Top Slicing)'!D18","v":{"$error":"#REF!"}},{"$f":"F3","v":{"$error":"#REF!"}},{"$f":"MAX(0,C6-F6)","v":{"$error":"#REF!"}},{"$f":"IF(F3<C6,F3,C6)","v":{"$error":"#REF!"}},null,"TaxFree",{"$f":"'Income Tax (for Top Slicing)'!K18","v":{"$error":"#REF!"}},{"$f":"L3","v":{"$error":"#REF!"}},{"$f":"MAX(0,I6-L6)","v":{"$error":"#REF!"}},{"$f":"IF(L3<I6,L3,I6)","v":{"$error":"#REF!"}}]
[null,"Basic Rate",{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"F3-F6","v":{"$error":"#REF!"}},{"$f":"MAX(0,C7-F7)","v":{"$error":"#REF!"}},{"$f":"MIN(D7,C7)","v":{"$error":"#REF!"}},null,"Basic Rate",{"$f":"C7+#REF!","v":{"$error":"#REF!"}},{"$f":"L3-L6","v":{"$error":"#REF!"}},{"$f":"MAX(0,I7-L7)","v":{"$error":"#REF!"}},{"$f":"MIN(J7,I7)","v":{"$error":"#REF!"}}]
[null,"Higher Rate",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"MAX(0,D7-F7)","v":{"$error":"#REF!"}},{"$f":"MAX(0,C8-F8)","v":{"$error":"#REF!"}},{"$f":"MIN(D8,C8)","v":{"$error":"#REF!"}},null,"Higher Rate",{"$f":"C8","v":{"$error":"#REF!"}},{"$f":"MAX(0,J7-L7)","v":{"$error":"#REF!"}},{"$f":"MAX(0,I8-L8)","v":{"$error":"#REF!"}},{"$f":"MIN(J8,I8)","v":{"$error":"#REF!"}}]
[null,"Additional Rate       >",{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"MAX(0,D8-F8)","v":{"$error":"#REF!"}},0,{"$f":"D9","v":{"$error":"#REF!"}},null,"Additional Rate       >",{"$f":"C9+#REF!","v":{"$error":"#REF!"}},{"$f":"J8-L8","v":{"$error":"#REF!"}},0,{"$f":"J9","v":{"$error":"#REF!"}}]
[]
[]
[null,"Dividend",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Dividend",null,null,null,{"$f":"F12","v":{"$error":"#REF!"}}]
[null,"Tax Free",{"$f":"MAX(0,E6)","v":{"$error":"#REF!"}},{"$f":"F12","v":{"$error":"#REF!"}},{"$f":"MIN(E6,E6-F13)","v":{"$error":"#REF!"}},{"$f":"MIN(C13,D13)","v":{"$error":"#REF!"}},null,"Tax Free",{"$f":"MAX(0,K6)","v":{"$error":"#REF!"}},{"$f":"L12","v":{"$error":"#REF!"}},{"$f":"MIN(K6,K6-L13)","v":{"$error":"#REF!"}},{"$f":"MIN(I13,J13)","v":{"$error":"#REF!"}}]
[null,"Basic Rate",{"$f":"MAX(0,E7)","v":{"$error":"#REF!"}},{"$f":"D13-F13","v":{"$error":"#REF!"}},{"$f":"MIN(E7,E7-F14)","v":{"$error":"#REF!"}},{"$f":"MIN(C14,D14)","v":{"$error":"#REF!"}},null,"Basic Rate",{"$f":"MAX(0,K7)","v":{"$error":"#REF!"}},{"$f":"L12-L13","v":{"$error":"#REF!"}},{"$f":"MIN(K7,K7-L14)","v":{"$error":"#REF!"}},{"$f":"MIN(I14,J14)","v":{"$error":"#REF!"}}]
[null,"Higher Rate",{"$f":"MAX(0,E8)","v":{"$error":"#REF!"}},{"$f":"MAX(0,D14-F14)","v":{"$error":"#REF!"}},{"$f":"MAX(0,C15-D15)","v":{"$error":"#REF!"}},{"$f":"MIN(D15,C15)","v":{"$error":"#REF!"}},null,"Higher Rate",{"$f":"MAX(0,K8)","v":{"$error":"#REF!"}},{"$f":"J14-L14","v":{"$error":"#REF!"}},{"$f":"MAX(0,I15-J15)","v":{"$error":"#REF!"}},{"$f":"MIN(J15,I15)","v":{"$error":"#REF!"}}]
[null,"Additional Rate       >",{"$f":"MAX(E15,0)","v":{"$error":"#REF!"}},{"$f":"MAX(0,D15-F15)","v":{"$error":"#REF!"}},0,{"$f":"D16","v":{"$error":"#REF!"}},null,"Additional Rate       >",{"$f":"MAX(K15,0)","v":{"$error":"#REF!"}},{"$f":"J15-L15","v":{"$error":"#REF!"}},0,{"$f":"J16","v":{"$error":"#REF!"}}]
[]
[null,"Bond Gain",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Bond Gain",null,null,null,{"$f":"F18","v":{"$error":"#REF!"}}]
[null,"Tax Free",{"$f":"MAX(0,E13)","v":{"$error":"#REF!"}},{"$f":"MAX(0,F18)","v":{"$error":"#REF!"}},{"$f":"MAX(0,MIN(E13,E13-F19))","v":{"$error":"#REF!"}},{"$f":"MIN(D19,C19)","v":{"$error":"#REF!"}},null,"TaxFree",{"$f":"MAX(0,K13)","v":{"$error":"#REF!"}},{"$f":"MAX(0,L18)","v":{"$error":"#REF!"}},{"$f":"MAX(0,MIN(K13,K13-L19))","v":{"$error":"#REF!"}},{"$f":"MIN(J19,I19)","v":{"$error":"#REF!"}}]
[null,"Basic Rate",{"$f":"MAX(0,E14)","v":{"$error":"#REF!"}},{"$f":"MAX(0,D19-F19)","v":{"$error":"#REF!"}},{"$f":"MIN(E14,E14-F20)","v":{"$error":"#REF!"}},{"$f":"MIN(D20,C20)","v":{"$error":"#REF!"}},null,"Basic Rate",{"$f":"MAX(0,K14)","v":{"$error":"#REF!"}},{"$f":"L18-L19","v":{"$error":"#REF!"}},{"$f":"MIN(K14,K14-L20)","v":{"$error":"#REF!"}},{"$f":"MIN(J20,I20)","v":{"$error":"#REF!"}}]
[null,"Higher Rate",{"$f":"MAX(0,E15)","v":{"$error":"#REF!"}},{"$f":"MAX(0,D20-F20)","v":{"$error":"#REF!"}},{"$f":"MAX(0,C21-D21)","v":{"$error":"#REF!"}},{"$f":"MIN(D21,C21)","v":{"$error":"#REF!"}},null,"Higher Rate",{"$f":"MAX(0,K15)","v":{"$error":"#REF!"}},{"$f":"J20-L20","v":{"$error":"#REF!"}},{"$f":"MAX(0,I21-J21)","v":{"$error":"#REF!"}},{"$f":"MIN(J21,I21)","v":{"$error":"#REF!"}}]
[null,"Additional Rate       >",{"$f":"MAX(E21,0)","v":{"$error":"#REF!"}},{"$f":"MAX(0,D21-F21)","v":{"$error":"#REF!"}},0,{"$f":"D22","v":{"$error":"#REF!"}},null,"Additional Rate       >",{"$f":"MAX(K21,0)","v":{"$error":"#REF!"}},{"$f":"J21-L21","v":{"$error":"#REF!"}},0,{"$f":"J22","v":{"$error":"#REF!"}}]
[]
[null,"Capital Gain",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Capital Gain",null,null,null,{"$f":"F24","v":{"$error":"#REF!"}}]
[null,"Basic Rate",{"$f":"MAX(0,E20)","v":{"$error":"#REF!"}},{"$f":"F24","v":{"$error":"#REF!"}},null,{"$f":"MIN(D25,C25)","v":{"$error":"#REF!"}},null,"Basic Rate",{"$f":"MAX(0,K20)","v":{"$error":"#REF!"}},{"$f":"L24","v":{"$error":"#REF!"}},null,{"$f":"MIN(J25,I25)","v":{"$error":"#REF!"}}]
[null,"Higher Rate            >",{"$f":"MAX(0,D25-C25)","v":{"$error":"#REF!"}},{"$f":"MAX(0,D25-F25)","v":{"$error":"#REF!"}},null,{"$f":"D26","v":{"$error":"#REF!"}},null,"Higher Rate",{"$f":"MAX(0,J25-I25)","v":{"$error":"#REF!"}},{"$f":"MAX(0,J25-L25)","v":{"$error":"#REF!"}},null,{"$f":"J26","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B30","v":{"$error":"#REF!"}},{"$f":"C30","v":{"$error":"#REF!"}}]
[]
[null,"Tax Free",{"$f":"F6+F13+F41","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B32","v":"Tax Free"},{"$f":"L6+L13+L41","v":{"$error":"#REF!"}}]
[null,"Basic Rate",{"$f":"F7+F14+F42+F25","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B33","v":"Basic Rate"},{"$f":"L7+L14+L42+L25","v":{"$error":"#REF!"}}]
[null,"Higher Rate",{"$f":"F8+F15+F43+F26","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B34","v":"Higher Rate"},{"$f":"L8+L15+L43+L26","v":{"$error":"#REF!"}}]
[null,"Additional Rate       >",{"$f":"F9+F16+F44+F28","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"B35","v":"Additional Rate       >"},{"$f":"L9+L16+L44+L28","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"MIN(C34,C34-((C34-C6)/2))","v":{"$error":"#REF!"}}]
[]
[]
[null,"Bond Slice","Allowances","Still to tax","Allowance balance",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"B40","v":"Bond Slice"},"Allowances","Still to tax","Allowance balance",{"$f":"F40","v":{"$error":"#REF!"}}]
[null,{"$f":"B19","v":"Tax Free"},{"$error":"#REF!"},{"$f":"F40","v":{"$error":"#REF!"}},{"$f":"E19","v":{"$error":"#REF!"}},{"$f":"MIN(C41,D41)","v":{"$error":"#REF!"}},null,{"$f":"H19","v":"TaxFree"},{"$error":"#REF!"},{"$f":"L40","v":{"$error":"#REF!"}},{"$f":"K19","v":{"$error":"#REF!"}},{"$f":"MIN(I41,J41)","v":{"$error":"#REF!"}}]
[null,"Basic Rate",{"$error":"#REF!"},{"$f":"MAX(0,D41-F41)","v":{"$error":"#REF!"}},{"$f":"E20","v":{"$error":"#REF!"}},{"$f":"MIN(C42,D42)","v":{"$error":"#REF!"}},null,"Basic Rate",{"$error":"#REF!"},{"$f":"MAX(0,J41-L41)","v":{"$error":"#REF!"}},{"$f":"K20","v":{"$error":"#REF!"}},{"$f":"MIN(I42,J42)","v":{"$error":"#REF!"}}]
[null,"Higher Rate",{"$error":"#REF!"},{"$f":"MAX(0,D42-F42)","v":{"$error":"#REF!"}},{"$f":"E21","v":{"$error":"#REF!"}},{"$f":"MIN(C43,D43)","v":{"$error":"#REF!"}},null,"Higher Rate",{"$error":"#REF!"},{"$f":"MAX(0,J42-L42)","v":{"$error":"#REF!"}},{"$f":"K21","v":{"$error":"#REF!"}},{"$f":"MIN(I43,J43)","v":{"$error":"#REF!"}}]
[null,"Additional Rate       >",{"$error":"#REF!"},{"$f":"MAX(0,D43-F43)","v":{"$error":"#REF!"}},{"$f":"E22","v":0},{"$f":"MIN(C44,D44)","v":{"$error":"#REF!"}},null,"Additional Rate       >",{"$error":"#REF!"},{"$f":"MAX(0,J43-L43)","v":{"$error":"#REF!"}},{"$f":"K22","v":0},{"$f":"MIN(I44,J44)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Additional tax on full gain",null,{"$f":"((F21*'Income Tax (for Top Slicing)'!C33)+('Workings (Top Slicing)'!F22*('Income Tax (for Top Slicing)'!C35-'Income Tax (for Top Slicing)'!C33)))","v":{"$error":"#REF!"}},null,null,null,"Additional tax on full gain",null,{"$f":"((L21*'Income Tax (for Top Slicing)'!I33)+('Workings (Top Slicing)'!L22*('Income Tax (for Top Slicing)'!I35-'Income Tax (for Top Slicing)'!I33)))","v":{"$error":"#REF!"}}]
[null,"Tax on slice",{"$f":"((F43*'Income Tax (for Top Slicing)'!C33)+('Workings (Top Slicing)'!F44*('Income Tax (for Top Slicing)'!C35-'Income Tax (for Top Slicing)'!C33)))","v":{"$error":"#REF!"}},null,null,null,null,"Tax on slice",{"$f":"((L43*'Income Tax (for Top Slicing)'!I33)+('Workings (Top Slicing)'!L44*('Income Tax (for Top Slicing)'!I35-'Income Tax (for Top Slicing)'!I33)))","v":{"$error":"#REF!"}}]
[null,"No. of slice years",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C48*C49","v":{"$error":"#REF!"}},null,null,null,"No. of slice years",{"$f":"C49","v":{"$error":"#REF!"}},{"$f":"I48*I49","v":{"$error":"#REF!"}}]
[null,"Top Slice Relief",null,{"$f":"D47-D49","v":{"$error":"#REF!"}},null,null,null,"Top Slice Relief",null,{"$f":"J47-J49","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,{"$f":"F21*0.2","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"F22*0.3","v":{"$error":"#REF!"}}]