{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Rates and Allowances","Summary","Workings","Workings(Inc Tax)"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Rates and Allowances","index":0,"n_rows":48,"n_cols":15,"rows_kept":48,"cut":false,"hidden":true,"merged":[[10,0,10,4],[11,2,11,5]]}
["Income Tax "]
["Personal Allowance (1)",12570,null,null,null,null,null,null,null,null,null,"Suicide Code"]
["Income limit for Personal Allowance",100000,null,null,null,null,null,null,null,null,null,"2024-04-05"]
["Personal Allowance for people aged 65-74 (1)(2)",{"$f":"B2","v":12570},{"$f":"B4-B2","v":0},null,{"$f":"(C4*2)+B5","v":26100},"No longer used",null,null,null,null,null,{"$f":"TODAY()","v":"2024-01-05"}]
["Income limit for age-related allowances",26100,null,null,null,"No longer used"]
[]
["(1) From the 2010-11 tax year the Personal Allowance reduces where the income is above £100, 000 - by £1 for every £2 of income above the £100,000 limit. This reduction applies irrespective of age."]
["(2) These allowances reduce where the income is above the income limit for age - related allowances - by £1 for every £2 of income above the limit. From the 2010-11 tax year the Personal Allowance "]
["for people aged over 65 can be reduced below the basic Personal Allowance where the income is above £100,000."]
[]
["Income Tax rates and taxable bands",null,null,null,null,null,null,null,null,null,null,null,null,null,"SRIT Bands"]
["Rate","Rate applicable","Applicable limits",null,null,null,null,null,"SRIT","UKIT","Scot Limit","UK Limit"]
["Starter rate",{"$f":"IF(Summary!$F$5=\"Yes\",I13,J13)","v":0},0,"to",{"$f":"IF(Summary!$F$5=\"Yes\",K13,L13)","v":0},null,null,null,0.19,0,2162,0,null,null,{"$f":"B2+K13","v":14732}]
["Basic rate",{"$f":"IF(Summary!$F$5=\"Yes\",I14,J14)","v":0.2},{"$f":"E13","v":0},"to",{"$f":"IF(Summary!$F$5=\"Yes\",K14,L14)+E13","v":37700},null,null,null,0.2,0.2,10956,37700,null,null,{"$f":"O13+K14","v":25688}]
["Intermediate rate",{"$f":"IF(Summary!$F$5=\"Yes\",I15,J15)","v":0},{"$f":"E14","v":37700},"to",{"$f":"IF(Summary!$F$5=\"Yes\",K15,L15)+E14","v":37700},null,null,null,0.21,0,17974,0,null,null,{"$f":"O14+K15","v":43662}]
["Higher rate",{"$f":"IF(Summary!$F$5=\"Yes\",I16,J16)","v":0.4},{"$f":"E15","v":37700},"to",{"$f":"IF(Summary!$F$5=\"Yes\",K16,L16)","v":125140},null,null,null,0.42,0.4,125140,125140]
["Additional rate",{"$f":"IF(Summary!$F$5=\"Yes\",I17,J17)","v":0.45},"Over ",null,{"$f":"E16","v":125140},null,null,null,0.47,0.45]
[]
["Dividends"]
["Ordinary Rate",0.1]
["Higher Rate",0.32500000000000001]
["Additional Rate",0.42499999999999999]
[]
["Corporation Tax"]
["Standard Fraction for Marginal Relief","3/200",{"$f":"3/200","v":1.4999999999999999E-2}]
["Small Compnaies Rate:"]
["Limit",300000]
["Rate",0.2]
[]
["Main Rate:"]
["Limit",1500000]
["Rate",0.26]
[]
[]
["National Insurance"]
["£ per week","£ per week","£ annually"]
["Upper earnings limit, primary Class 1",967,50270]
["Primary threshold",190,12570,null,{"$f":"C37-C38","v":37700}]
["Secondary threshold",175,9100]
["Employees’ primary Class 1 rate between primary threshold and upper earnings limit",0.115]
["Employees’ primary Class 1 rate above upper earnings limit",0.02]
["Employers’ secondary Class 1 rate above secondary threshold",0.13800000000000001]
[]
[]
[null,null,null,null,null,null,null,null,31092]
[null,null,null,null,null,null,null,null,12726,{"$f":"I45-I46","v":18366}]
[null,null,null,null,null,null,null,null,2097]
[null,null,null,null,null,null,null,null,{"$f":"I45-I46-I47","v":16269}]

{"sheet":"Summary","index":1,"n_rows":26,"n_cols":29,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,3,0,7],[0,10,0,11],[56,2,56,15],[21,2,47,7],[6,2,6,5],[16,2,17,4],[48,5,49,7],[52,2,53,15],[18,2,19,5]]}
[null,null,null,"Salary Sacrifice Calculator\nbuilt by M&G",null,null,null,null,null,null,"Tax Year 2023/24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Same Pension - Increased Take home Pay"]
[null,null,"Please enter the calculation to perform",null,null,"Specified Sacrifice Amount",null,null,null,null,null,"Pre Sacrifice",null,"Post Sacrifice",null,"Change",null,null,null,"Increased Pension - Same Take Home Pay"]
[null,null,null,null,null,null,null,null,null,null,"Employee",null,null,null,null,null,null,null,null,"Specified Sacrifice Amount"]
[null,null,"Scottish Tax Payer?",null,null,"No",null,null,null,null,"Salary",{"$f":"F9","v":0},null,{"$f":"'Workings(Inc Tax)'!L3","v":0},null,{"$f":"N5-L5","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Less Income Tax ",{"$f":"Workings!E29","v":0},null,{"$f":"Workings!J29","v":0},null,{"$f":"N6-L6","v":0}]
[null,null,"Pre sacrifice position",null,null,null,null,null,null,null,"Less National Insurance (Class 1)",{"$f":"Workings!E43","v":0},null,{"$f":"Workings!J43","v":0},null,{"$f":"N7-L7","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Salary after tax and NI",{"$f":"L5-L6-L7","v":0},null,{"$f":"N5-N6-N7","v":0},null,{"$f":"N8-L8","v":0}]
[null,null,"Salary",null,null,0,null,null,null,null,"Less Contributions paid net",{"$f":"F11*(1-'Rates and Allowances'!B14)","v":0},null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,"Take Home Pay",{"$f":"L8-L9","v":0},null,{"$f":"N8-N9","v":0},null,{"$f":"N10-L10","v":0},null,null,null,{"$f":"P10","v":0},null,null,null,"Take Home Pay",{"$f":"P10","v":0},"TAX"]
[null,null,"Gross value of individual Relief at Source contributions",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pension Pot",{"$f":"P12","v":0},{"$f":"N5","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Pension Pot",{"$f":"F11+F13","v":0},null,{"$f":"'Workings(Inc Tax)'!R22","v":0},null,{"$f":"N12-L12","v":0},null,null,null,{"$f":"P12","v":0},null,null,null,"Employer costs",{"$f":"P19","v":0},11850,0,{"$f":"AA12*Z12","v":0}]
[null,null,"Employer Pension Contributions",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(2000,(Z11-Z12))","v":-11850},0.19,{"$f":"AA13*Z13","v":-2251.5}]
[null,null,null,null,null,null,null,null,null,null,"Employer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(10150,(Z11-Z12-Z13))","v":0},0.2,{"$f":"AA14*Z14","v":0}]
[null,null,"Percentage of Employer NI to be given up",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T4=F3,F17,0)","v":0},null,null,null,{"$f":"MIN(19430,(Z11-Z12-Z13-Z14))","v":0},0.21,{"$f":"AA15*Z15","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Employer Pension Contribution",{"$f":"F13","v":0},null,{"$f":"'Workings(Inc Tax)'!R22","v":0},null,{"$f":"N16-L16","v":0},null,null,null,{"$f":"F3","v":"Specified Sacrifice Amount"},"Pens right?","Take Home right?",null,null,null,{"$f":"MIN(56570,(Z11-Z12-Z13-Z14-Z15))","v":0},0.41,{"$f":"AA16*Z16","v":0}]
[null,null,"Change to salary - Please not this will also assign any pre-existing personal pension contributions to salary sacrifice",null,null,0,null,null,null,null,"Plus Salary Paid",{"$f":"F9","v":0},null,{"$f":"N5","v":0},null,{"$f":"N17-L17","v":0},null,null,"SPITHP",{"$f":"IF(T16=T2,1,0)","v":0},{"$f":"IF(AND(T17=1,P12<>0),1,0)","v":0},{"$f":"IF(AND(T17=1,P10<=0),1,0)","v":0},null,null,null,null,0.46]
[null,null,null,null,null,null,null,null,null,null,"Plus Employers National Insurance \n(Class 1)",{"$f":"Workings!E48","v":0},null,{"$f":"Workings!J48","v":0},null,{"$f":"N18-L18","v":0},null,null,"IPSTHP",{"$f":"IF(T16=T3,1,0)","v":0},{"$f":"IF(AND(T18=1,P12<=0),1,0)","v":0},{"$f":"IF(AND(T18=1,P10<>0),1,0)","v":0},null,null,null,null,null,{"$f":"SUM(AB12:AB17)","v":-2251.5},{"$f":"N6-AB18","v":2251.5}]
[null,null,{"$f":"IF(V19>0,\"The salary sacrifice is innefective owing to the levels of income and pension contributions\",\"\")","v":""},null,null,null,null,null,null,null,"Cost to employer",{"$f":"SUM(L16:L18)","v":0},null,{"$f":"SUM(N16:N18)","v":0},null,{"$f":"N19-L19","v":0},null,null,null,null,null,{"$f":"SUM(U17:V18)","v":0},null,null,null,"NI"]
[]
[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,{"$f":"N5","v":0}]
[null,null,"This calculator is designed to demonstrate the impact on income tax, national insurance and pension provision where exchanging salary for an employer's pension contribution. \n\nPlease note you will need to ensure that the sacrifice does not take the individual below the minimum wage\n\nThe calculator is only suitable for individuals under state pension age.\n\nThe above is based on our understanding of current taxation, legislation and HM Revenue & Customs practice all of which is subject to change without notice.The impact of taxation and any other reliefs depends on individual circumstances.\n\nEmployee National Insurance is using the \"Effective Annual Rate\" of 11.5%, which factors in the 2% reduction from 6 January 2024 for Primary Class 1 National Insurance. \n\nPlease note, this tool will cease to operate at the end of the tax year displayed above. \n\nTax legislation states that the personal allowance may be deducted in the way which will result in the greatest reduction in the taxpayer's liability to income tax. The calculator however proceeds on the basis that it is offset firstly against non-savings income, then savings income and then dividend income. In particular circumstances, a different order may produce a more beneficial result for the individual."]
[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,{"$f":"MIN(8424,(Z21-Z22))","v":0},0,{"$f":"AA23*Z23","v":0}]
[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,{"$f":"MIN(37926,(Z21-Z23))","v":0},0.12,{"$f":"AA24*Z24","v":0}]
[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,{"$f":"MIN(53650,(Z21-Z23-Z24))","v":0},0.02,{"$f":"AA25*Z25","v":0}]
[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,{"$f":"SUM(AB23:AB25)","v":0},{"$f":"N7-AB26","v":0}]

{"sheet":"Workings","index":2,"n_rows":48,"n_cols":15,"rows_kept":48,"cut":false,"hidden":false,"merged":[[5,13,5,14],[0,1,0,5],[0,8,0,9],[1,1,1,4],[1,6,1,9]]}
[null,"Salary Sacrifice Calculator\nbuilt by M&G",null,null,null,null,null,null,{"$f":"Summary!K1","v":"Tax Year 2023/24"}]
[null,"Pre Sacrifice",null,null,null,null,"Post Sacrifice"]
[]
[null,"Allowances",null,null,null,null,"Allowances"]
[null,"Adjusted Net Income (for allowance purposes)",null,{"$f":"Summary!F9-Summary!F11","v":0},null,null,{"$f":"B5","v":"Adjusted Net Income (for allowance purposes)"},null,{"$f":"'Workings(Inc Tax)'!R10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"KEEP THESE"]
[null,"Personal Allowance",null,{"$f":"'Rates and Allowances'!B2","v":12570},null,null,{"$f":"B7","v":"Personal Allowance"},null,{"$f":"D7","v":12570},null,null,{"$f":"MIN(I7,(I5-'Rates and Allowances'!B3)/2)","v":-50000},null,{"$f":"D5-'Rates and Allowances'!B3","v":-100000},{"$f":"I5-'Rates and Allowances'!B3","v":-100000}]
[null,"Adjustment",null,{"$f":"IF(N7<1,0,(IF(N7>(2*'Rates and Allowances'!B2),-D7,MAX(-D7,N7/-2))))","v":0},{"$f":"SUM(D7:D8)","v":12570},null,{"$f":"B8","v":"Adjustment"},null,{"$f":"IF(O7<1,0,(IF(O7>(2*'Rates and Allowances'!B2),-I7,MAX(-I7,O7/-2))))","v":0},{"$f":"SUM(I7:I8)","v":12570}]
[]
[null,"Additional Age Allowance",null,{"$f":"IF(Summary!F7=\"Under 65\",0,'Rates and Allowances'!C4)","v":0},{"$f":"D5-'Rates and Allowances'!B5","v":-26100},null,{"$f":"B10","v":"Additional Age Allowance"},null,{"$f":"D10","v":0},{"$f":"I5-'Rates and Allowances'!B5","v":-26100}]
[null,"Adjustment",null,{"$f":"IF(E10<0.01,0,MAX(-D10,E10/-2))","v":0},{"$f":"SUM(D10:D11)","v":0},null,{"$f":"B11","v":"Adjustment"},null,{"$f":"IF(J10<0.01,0,MAX(-I10,J10/-2))","v":0},{"$f":"SUM(I10:I11)","v":0}]
[]
[null,"Total Allowance",null,null,{"$f":"E8+E11","v":12570},null,{"$f":"B13","v":"Total Allowance"},null,null,{"$f":"J8+J11","v":12570}]
[]
[null,"Tax Calculation",null,null,null,null,{"$f":"B15","v":"Tax Calculation"}]
[]
[null,"Income",null,null,{"$f":"Summary!F9","v":0},null,{"$f":"B17","v":"Income"},null,null,{"$f":"I5","v":0}]
[null,"Less ",null,null,null,null,{"$f":"B18","v":"Less "}]
[null,"Allowance",null,{"$f":"Workings!E13","v":12570},{"$f":"SUM(D19:D19)","v":12570},null,"Allowance",null,{"$f":"J13","v":12570},{"$f":"SUM(I19:I19)","v":12570}]
[null,"Taxable Income",null,null,{"$f":"MAX(0,E17-E19)","v":0},null,"Taxable Income",null,null,{"$f":"MAX(0,J17-J19)","v":0}]
[]
[]
[null,"Income",null,null,null,null,"Income"]
[null,{"$f":"'Workings(Inc Tax)'!F7","v":0},"@",{"$f":"'Rates and Allowances'!B13","v":0},{"$f":"B24*D24","v":0},null,{"$f":"'Workings(Inc Tax)'!L7","v":0},"@",{"$f":"D24","v":0},{"$f":"G24*I24","v":0}]
[null,{"$f":"'Workings(Inc Tax)'!F8","v":0},"@",{"$f":"'Rates and Allowances'!B14","v":0.2},{"$f":"B25*D25","v":0},null,{"$f":"'Workings(Inc Tax)'!L8","v":0},"@",{"$f":"D25","v":0.2},{"$f":"G25*I25","v":0}]
[null,{"$f":"'Workings(Inc Tax)'!F9","v":0},"@",{"$f":"'Rates and Allowances'!B15","v":0},{"$f":"B26*D26","v":0},null,{"$f":"'Workings(Inc Tax)'!L9","v":0},"@",{"$f":"D26","v":0},{"$f":"G26*I26","v":0}]
[null,{"$f":"'Workings(Inc Tax)'!F10","v":0},"@",{"$f":"'Rates and Allowances'!B16","v":0.4},{"$f":"B27*D27","v":0},null,{"$f":"'Workings(Inc Tax)'!L10","v":0},"@",{"$f":"D27","v":0.4},{"$f":"G27*I27","v":0}]
[null,{"$f":"'Workings(Inc Tax)'!F11","v":0},"@",{"$f":"'Rates and Allowances'!B17","v":0.45},{"$f":"B28*D28","v":0},null,{"$f":"'Workings(Inc Tax)'!L11","v":0},"@",{"$f":"D28","v":0.45},{"$f":"G28*I28","v":0}]
[null,"Tax to pay",null,null,{"$f":"SUM(E24:E28)","v":0},null,"Tax to pay",null,null,{"$f":"SUM(J24:J28)","v":0}]
[]
[]
[null,"National Insurance Calculation",null,null,null,null,{"$f":"B32","v":"National Insurance Calculation"}]
[]
[null,"Salary",null,{"$f":"Summary!F9","v":0},null,null,"Salary",null,{"$f":"'Workings(Inc Tax)'!R10","v":0}]
[]
[null,"Employee",null,null,null,null,"Employee"]
[]
[null,null,"Amount","Rate","NI Payable",null,null,"Amount","Rate","NI Payable"]
[null,"`- to Primary Threshold",{"$f":"MIN(D34,'Rates and Allowances'!C38)","v":0},0,0,null,"`- to Primary Threshold",{"$f":"MIN(I34,'Rates and Allowances'!C38)","v":0},0,0]
[null,"` - Primary Threshold to Upper Earnings Limit",{"$f":"IF(D34=0,0,IF(C39+'Rates and Allowances'!E38<Workings!D34,'Rates and Allowances'!E38,Workings!D34-Workings!C39))","v":0},{"$f":"'Rates and Allowances'!B40","v":0.115},{"$f":"C40*D40","v":0},null,"` - Primary Threshold to Upper Earnings Limit",{"$f":"IF(I34=0,0,IF((H39+'Rates and Allowances'!E38)<Workings!I34,'Rates and Allowances'!E38,Workings!I34-Workings!H39))","v":0},{"$f":"D40","v":0.115},{"$f":"H40*I40","v":0}]
[null,"`- over Upper Earnings Limit",{"$f":"MAX(0,D34-'Rates and Allowances'!C37)","v":0},{"$f":"'Rates and Allowances'!B41","v":0.02},{"$f":"C41*D41","v":0},null,"`- over Upper Earnings Limit",{"$f":"MAX(0,I34-'Rates and Allowances'!C37)","v":0},{"$f":"D41","v":0.02},{"$f":"H41*I41","v":0}]
[]
[null,null,null,"Total",{"$f":"SUM(E39:E42)","v":0},null,null,null,"Total",{"$f":"SUM(J39:J42)","v":0}]
[]
[null,"Employer",null,null,null,null,"Employer"]
[null,null,"Amount","Rate","NI Payable",null,null,"Amount","Rate","NI Payable"]
[null,"`- to Primary Threshold",{"$f":"MIN(D34,'Rates and Allowances'!C39)","v":0},0,{"$f":"C47*D47","v":0},null,"`- to Primary Threshold",{"$f":"MIN(I34,'Rates and Allowances'!C39)","v":0},0,{"$f":"H47*I47","v":0}]
[null,"`- over Secondary Threshold",{"$f":"MAX(D34-'Rates and Allowances'!C39,0)","v":0},{"$f":"'Rates and Allowances'!B42","v":0.13800000000000001},{"$f":"C48*D48","v":0},null,"`- over Secondary Threshold",{"$f":"MAX(I34-'Rates and Allowances'!C39,0)","v":0},{"$f":"D48","v":0.13800000000000001},{"$f":"H48*I48","v":0}]

{"sheet":"Workings(Inc Tax)","index":3,"n_rows":71,"n_cols":18,"rows_kept":71,"cut":false,"hidden":true,"merged":[[15,8,15,9],[15,10,15,11],[14,8,14,11]]}
[null,"Pre Sacrifice",null,null,null,null,null,"Post Sacrifice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Logic for Post Salary in L3"]
[null,"Taxable Income",null,null,null,{"$f":"Summary!F9","v":0},null,"Taxable Income",null,null,null,{"$f":"R10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Same Pension - Increased Take home Pay RUK",null,null,{"$f":"C26","v":0},{"$f":"IF(AND(Summary!$F$5=\"No\",Summary!F3=Summary!T2),'Workings(Inc Tax)'!Q4,0)","v":0}]
[null,null,"Allowances","Still to tax","Allowance balance",null,null,null,"Allowances","Still to tax","Allowance balance",null,null,"Same Pension - Increased Take home Pay SRIT",null,null,{"$f":"C26","v":0},{"$f":"IF(AND(Summary!$F$5=\"Yes\",Summary!F3=Summary!T2),'Workings(Inc Tax)'!Q5,0)","v":0}]
[null,"Tax Free",{"$f":"Workings!E19","v":12570},{"$f":"F3","v":0},{"$f":"MAX(0,C6-F6)","v":12570},{"$f":"IF(F3<C6,F3,C6)","v":0},null,"TaxFree",{"$f":"Workings!J19","v":12570},{"$f":"L3","v":0},{"$f":"MAX(0,I6-L6)","v":12570},{"$f":"IF(L3<I6,L3,I6)","v":0},null,"Increased Pension - Same Take Home Pay RUK",null,null,{"$f":"K49","v":0},{"$f":"IF(AND(Summary!$F$5=\"No\",Summary!F3=Summary!T3),'Workings(Inc Tax)'!Q6,0)","v":0}]
[null,"Starter Rate",{"$f":"'Rates and Allowances'!E13-'Rates and Allowances'!C13","v":0},{"$f":"MAX(D6-F6,0)","v":0},{"$f":"MAX(0,C7-F7)","v":0},{"$f":"MIN(D7,C7)","v":0},null,"Starter Rate",{"$f":"'Rates and Allowances'!E13-'Rates and Allowances'!C13","v":0},{"$f":"MAX(0,J6-L6)","v":0},{"$f":"MAX(0,I7-L7)","v":0},{"$f":"MIN(J7,I7)","v":0},null,"Increased Pension - Same Take Home Pay SRIT",null,null,{"$f":"K71","v":0},{"$f":"IF(AND(Summary!$F$5=\"Yes\",Summary!F3=Summary!T3),'Workings(Inc Tax)'!Q7,0)","v":0}]
[null,"Basic Rate",{"$f":"'Rates and Allowances'!E14-'Rates and Allowances'!C14+Summary!$F$11","v":37700},{"$f":"MAX(D7-F7,0)","v":0},{"$f":"MAX(0,C8-F8)","v":37700},{"$f":"MIN(D8,C8)","v":0},null,"Basic Rate",{"$f":"'Rates and Allowances'!E14-'Rates and Allowances'!C14+Summary!$F$25","v":37700},{"$f":"MAX(0,J7-L7)","v":0},{"$f":"MAX(0,I8-L8)","v":37700},{"$f":"MIN(J8,I8)","v":0},null,"Specified Sacrifice Amount RUK",null,null,{"$f":"G25","v":0},{"$f":"IF(AND(Summary!$F$5=\"No\",Summary!F3=Summary!T4),'Workings(Inc Tax)'!Q8,0)","v":0}]
[null,"Intermediate Rate",{"$f":"'Rates and Allowances'!E15-'Rates and Allowances'!C15","v":0},{"$f":"MAX(D8-F8,0)","v":0},{"$f":"MAX(0,C9-F9)","v":0},{"$f":"MIN(D9,C9)","v":0},null,"Intermediate Rate",{"$f":"'Rates and Allowances'!E15-'Rates and Allowances'!C15","v":0},{"$f":"MAX(0,J8-L8)","v":0},{"$f":"MAX(0,I9-L9)","v":0},{"$f":"MIN(J9,I9)","v":0},null,"Specified Sacrifice Amount SRIT",null,null,{"$f":"G25","v":0},{"$f":"IF(AND(Summary!$F$5=\"Yes\",Summary!F3=Summary!T4),'Workings(Inc Tax)'!Q9,0)","v":0}]
[null,"Higher Rate",{"$f":"'Rates and Allowances'!E16-'Rates and Allowances'!C16","v":87440},{"$f":"MAX(D9-F9,0)","v":0},{"$f":"MAX(0,C10-F10)","v":87440},{"$f":"MIN(D10,C10)","v":0},null,"Higher Rate",{"$f":"'Rates and Allowances'!E16-'Rates and Allowances'!C16","v":87440},{"$f":"MAX(0,J9-L9)","v":0},{"$f":"MAX(0,I10-L10)","v":87440},{"$f":"MIN(J10,I10)","v":0},null,"New Salary to Use",null,null,null,{"$f":"SUM(R4:R9)","v":0}]
[null,"Additional Rate       >",{"$f":"'Rates and Allowances'!E17+Summary!F11","v":125140},{"$f":"MAX(D10-F10,0)","v":0},0,{"$f":"D11","v":0},null,"Additional Rate       >",{"$f":"'Rates and Allowances'!E17+Summary!F26","v":125140},{"$f":"J10-L10","v":0},0,{"$f":"J11","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Logic for Post Pension in XXXX"]
[null,"Same Pension Less Cost",null,null,null,"Specified Salary and move existing to sacrifice",null,null,"Same take home - more pension - employer amounts"]
[null,null,null,null,null,null,null,null,"RUK",null,"SRIT",null,null,"Same Pension - Increased Take home Pay RUK",null,null,{"$f":"C18","v":0},{"$f":"IF(AND(Summary!$F$5=\"No\",Summary!F3=Summary!T2),'Workings(Inc Tax)'!Q16,0)","v":0}]
[null,null,null,null,null,"Salary Reduction",{"$f":"Summary!V15","v":0},null,"Salary Reduction",{"$f":"Summary!F9-'Workings(Inc Tax)'!K49","v":0},"Salary Reduction",{"$f":"Summary!F9-K71","v":0},null,"Same Pension - Increased Take home Pay SRIT",null,null,{"$f":"C18","v":0},{"$f":"IF(AND(Summary!$F$5=\"Yes\",Summary!F3=Summary!T2),'Workings(Inc Tax)'!Q17,0)","v":0}]
[null,"Pension Reduction",{"$f":"Summary!F11","v":0},null,null,"Existing Pension",{"$f":"Summary!F11","v":0},null,"Rate",{"$f":"'Rates and Allowances'!B42","v":0.13800000000000001},"Rate",{"$f":"'Rates and Allowances'!B42","v":0.13800000000000001},null,"Increased Pension - Same Take Home Pay RUK",null,null,{"$f":"J25","v":0},{"$f":"IF(AND(Summary!$F$5=\"No\",Summary!F3=Summary!T3),'Workings(Inc Tax)'!Q18,0)","v":0}]
[null,"Rate",{"$f":"'Rates and Allowances'!B42","v":0.13800000000000001},null,null,"Total Reduction",{"$f":"G17+G18","v":0},null,"NI Saving passed on",{"$f":"Summary!F15","v":0},"NI Saving passed on",{"$f":"Summary!F15","v":0},null,"Increased Pension - Same Take Home Pay SRIT",null,null,{"$f":"L25","v":0},{"$f":"IF(AND(Summary!$F$5=\"Yes\",Summary!F3=Summary!T3),'Workings(Inc Tax)'!Q19,0)","v":0}]
[null,"NI Saving passed on",{"$f":"Summary!F15","v":0},null,null,"Rate",{"$f":"'Rates and Allowances'!B42","v":0.13800000000000001},null,"Existing NI x give up",{"$f":"Summary!L18*'Workings(Inc Tax)'!J19","v":0},"Existing NI x give up",{"$f":"Summary!L18*'Workings(Inc Tax)'!L19","v":0},null,"Specified Sacrifice Amount RUK",null,null,{"$f":"G26","v":0},{"$f":"IF(AND(Summary!$F$5=\"No\",Summary!F3=Summary!T4),'Workings(Inc Tax)'!Q20,0)","v":0}]
[null,"Existing NI x give up",{"$f":"Summary!L18*C20","v":0},null,null,"NI Saving passed on",{"$f":"Summary!F15","v":0},null,"Potential Saving x give up",{"$f":"J17*(J18*J19)","v":0},"Potential Saving x give up",{"$f":"L17*(L18*L19)","v":0},null,"Specified Sacrifice Amount SRIT",null,null,{"$f":"G26","v":0},{"$f":"IF(AND(Summary!$F$5=\"Yes\",Summary!F3=Summary!T4),'Workings(Inc Tax)'!Q21,0)","v":0}]
[null,"Potential Saving x give up",{"$f":"(C18*C19)*C20","v":0},null,null,"Existing NI x give up",{"$f":"Summary!L18*G21","v":0},null,"Max Saving",{"$f":"MIN(J20,J21)","v":0},"Max Saving",{"$f":"MIN(L20,L21)","v":0},null,"New Emp Pension to Use",null,null,null,{"$f":"SUM(R16:R21)+Summary!F13","v":0}]
[null,"Max Saving",{"$f":"MIN(C21,C22)","v":0},null,null,"Potential Saving",{"$f":"(G19*G20)*G21","v":0},null,"Existing Salary",{"$f":"Summary!F9","v":0},"Existing Salary",{"$f":"Summary!F9","v":0}]
[null,"Sal Red Factor",{"$f":"1+(C19*C20)","v":1},null,null,"Max Saving",{"$f":"MIN(G22,G23)","v":0},null,"New Salary",{"$f":"K49","v":0},"New Salary",{"$f":"K71","v":0}]
[null,"Salary Reduction",{"$f":"C18/C24","v":0},{"$f":"Summary!L19-(Summary!L18*'Workings(Inc Tax)'!C20)-Summary!F11","v":0},null,"New Salary",{"$f":"Summary!F9-'Workings(Inc Tax)'!G19","v":0},null,"New Emp Pension",{"$f":"J17+J22","v":0},"New Emp Pension",{"$f":"L17+L22","v":0}]
[null,"New Salary",{"$f":"IF(C21<C22,D25,Summary!F9-'Workings(Inc Tax)'!C25)","v":0},null,null,"New Emp Cont",{"$f":"G19+G24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"For Graphs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Take Home Pay",{"$f":"Summary!P10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pension Pot",{"$f":"Summary!P12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Employer costs",{"$f":"Summary!P19","v":0}]
[]
[]
[null,null,"Salary",{"$f":"Summary!F9","v":0}]
[null,null,"Pension Gross",{"$f":"Summary!F11","v":0},null,null,null,null,"Current Take Home",null,{"$f":"Summary!L10","v":0},28146]
[null,null,null,null,null,null,null,null,"Current Net Pension cont",null,{"$f":"D34*0.8","v":0}]
[]
[]
[null,"Non SRIT",null,null,"NI","Tax",null,"Upper Range",null,"Amount in band"]
[null,0,{"$f":"'Rates and Allowances'!C39","v":9100},{"$f":"C39-B39","v":9100},0,0,{"$f":"D39*(1-(E39+F39))","v":9100},{"$f":"G39","v":9100},{"$f":"IF(K34<=H39,\"Use\",\"Don't Use\")","v":"Use"},{"$f":"IF(I39=\"use\",$K$34,0)","v":0},{"$f":"IF(I39=\"Use\",(J39/(1-(E39+F39))+C38),0)","v":0}]
[null,{"$f":"C39+0.01","v":9100.01},{"$f":"'Rates and Allowances'!C38","v":12570},{"$f":"C40-B40+0.01","v":3470},0,0,{"$f":"D40*(1-(E40+F40))","v":3470},{"$f":"H39+G40","v":12570},{"$f":"IF(AND($K$34>H39,$K$34<=H40,$K$34<H41),\"use\",\"Don't use\")","v":"Don't use"},{"$f":"IF(I40=\"use\",$K$34-H39,0)","v":0},{"$f":"IF(I40=\"Use\",(J40/(1-(E40+F40))+C39),0)","v":0}]
[null,{"$f":"C40+0.01","v":12570.01},{"$f":"'Rates and Allowances'!B2","v":12570},-2.1827852025868566E-13,{"$f":"'Rates and Allowances'!B40","v":0.115},0,-1.9317649042893682E-13,{"$f":"H40+G41","v":12570},"Don't use",0,{"$f":"IF(I41=\"Use\",(J41/(1-(E41+F41))+C40),0)","v":0}]
[null,12570.01,{"$f":"C41+'Rates and Allowances'!L14","v":50270},37700,{"$f":"'Rates and Allowances'!B40","v":0.115},{"$f":"'Rates and Allowances'!J14","v":0.2},25824.500000000004,38394.5,"Don't use",0,{"$f":"IF(I42=\"Use\",(J42/(1-(E42+F42))+C41),0)","v":0}]
[null,50270.01,{"$f":"'Rates and Allowances'!B3","v":100000},49730,{"$f":"'Rates and Allowances'!B41","v":0.02},{"$f":"'Rates and Allowances'!J16","v":0.4},28843.399999999998,67237.899999999994,"Don't use",0,0]
[null,100000.01,{"$f":"C43+('Rates and Allowances'!B2*2)","v":125140},25140.000000000004,{"$f":"'Rates and Allowances'!B41","v":0.02},{"$f":"F43*1.5","v":0.60000000000000009},9553.1999999999989,76791.099999999991,"Don't use",0,{"$f":"IF(I44=\"Use\",(J44/(1-(E44+F44))+C43),0)","v":0}]
[null,125140.01,{"$f":"'Rates and Allowances'!L16","v":125140},5.2386896903788838E-12,{"$f":"'Rates and Allowances'!B41","v":0.02},{"$f":"'Rates and Allowances'!J16","v":0.4},3.0384400204197525E-12,{"$f":"H44+G45","v":76791.099999999991},"Don't use",0,0]
[null,125140.01,2000000000,1999874860,{"$f":"'Rates and Allowances'!B41","v":0.02},{"$f":"'Rates and Allowances'!J17","v":0.45},1059933675.8000001,1060010466.9000001,{"$f":"IF(K34>H45,\"use\",\"Don't use\")","v":"Don't use"},0,{"$f":"IF(I46=\"Use\",(J46/(1-(E46+F46))+C45),0)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,"New Salary - RUK",{"$f":"SUM(K39:K46)","v":0}]
[]
[]
[null,null,"Salary",{"$f":"D33","v":0}]
[null,null,"Pension Gross",{"$f":"D34","v":0},null,null,null,null,"Current Take Home",null,{"$f":"Summary!L10","v":0},28146]
[null,null,null,null,null,null,null,null,"Current Net Pension cont",null,{"$f":"D53*0.8","v":0}]
[]
[]
[null,"SRIT",null,null,"NI","Tax",null,"Upper Range",null,"Amount in band"]
[null,0,{"$f":"'Rates and Allowances'!C39","v":9100},{"$f":"C58-B58","v":9100},0,0,{"$f":"D58*(1-(E58+F58))","v":9100},{"$f":"G58","v":9100},{"$f":"IF(K53<=H58,\"Use\",\"Don't Use\")","v":"Use"},{"$f":"IF(I58=\"use\",$K$34,0)","v":0},{"$f":"IF(I58=\"Use\",(J58/(1-(E58+F58))+C57),0)","v":0}]
[null,{"$f":"C58+0.01","v":9100.01},{"$f":"'Rates and Allowances'!C38","v":12570},{"$f":"C59-B59+0.01","v":3470},0,0,{"$f":"D59*(1-(E59+F59))","v":3470},{"$f":"H58+G59","v":12570},{"$f":"IF(AND($K$34>H58,$K$34<=H59,$K$34<H60),\"use\",\"Don't use\")","v":"Don't use"},{"$f":"IF(I59=\"use\",$K$34-H58,0)","v":0},0]
[null,{"$f":"C59+0.01","v":12570.01},12570,-2.1827852025868566E-13,{"$f":"'Rates and Allowances'!B40","v":0.115},0,-1.9317649042893682E-13,{"$f":"H59+G60","v":12570},{"$f":"IF(AND($K$34>H59,$K$34<=H60,$K$34<H61),\"use\",\"Don't use\")","v":"Don't use"},{"$f":"IF(I60=\"use\",$K$34-H59,0)","v":0},0]
[null,12570.01,{"$f":"'Rates and Allowances'!O13","v":14732},2162,{"$f":"'Rates and Allowances'!B40","v":0.115},{"$f":"'Rates and Allowances'!I13","v":0.19},1502.5900000000001,14072.59,"Don't use",{"$f":"IF(I61=\"use\",$K$34-H60,0)","v":0},0]
[null,14732.01,{"$f":"'Rates and Allowances'!O14","v":25688},10956,{"$f":"'Rates and Allowances'!B40","v":0.115},{"$f":"'Rates and Allowances'!I14","v":0.2},7504.8600000000006,21577.45,"Don't use",{"$f":"IF(I62=\"use\",$K$34-H61,0)","v":0},0]
[null,25688.01,{"$f":"'Rates and Allowances'!O15","v":43662},17974,{"$f":"'Rates and Allowances'!B40","v":0.115},{"$f":"'Rates and Allowances'!I15","v":0.21},12132.45,33709.9,"Don't use",0,0]
[null,43662.01,{"$f":"C42","v":50270},6607.9999999999982,{"$f":"'Rates and Allowances'!B40","v":0.115},{"$f":"'Rates and Allowances'!I16","v":0.42},3072.7199999999989,36782.620000000003,"Don't use",0,0]
[null,50270.01,100000,49730,{"$f":"'Rates and Allowances'!B41","v":0.02},{"$f":"'Rates and Allowances'!I16","v":0.42},27848.800000000003,64631.420000000006,"Don't use",0,0]
[null,100000.01,{"$f":"C65+(2*C60)","v":125140},25140.000000000004,{"$f":"'Rates and Allowances'!B41","v":0.02},{"$f":"F65*1.5","v":0.63},8799,73430.420000000013,"Don't use",{"$f":"IF(I66=\"use\",$K$34-H65,0)","v":0},{"$f":"IF(I66=\"Use\",(J66/(1-(E66+F66))+C65),0)","v":0}]
[null,125140.01,150000,24860.000000000004,{"$f":"'Rates and Allowances'!B41","v":0.02},{"$f":"'Rates and Allowances'!I16","v":0.42},13921.600000000004,{"$f":"H66+G67","v":87352.020000000019},"Don't use",{"$f":"IF(I67=\"use\",$K$34-H66,0)","v":0},0]
[null,150000.01,2000000000,1999850000,{"$f":"'Rates and Allowances'!B41","v":0.02},{"$f":"'Rates and Allowances'!I17","v":0.47},1019923500,{"$f":"H67+G68","v":1020010852.02},{"$f":"IF(K47>H67,\"use\",\"Don't use\")","v":"Don't use"},{"$f":"IF(I68=\"use\",$K$34-H67,0)","v":0},0]
[]
[]
[null,null,null,null,null,null,null,null,null,"New Salary - SRIT",{"$f":"SUM(K58:K68)","v":0}]