{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Splash","Main","Question 1","Question_2","Inputs","TAA","Calcs","Results","Output","Lists"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":188,"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":"Splash","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[null,"Annual Allowance & Carry Forward \nCalculator - 2024/25"]
["2023-24","Please enable Macros to use this tool"]

{"sheet":"Main","index":1,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[[28,2,30,3],[23,2,24,3],[1,2,3,2],[5,2,7,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Important notes"]
[]
[null,null,"This tool calculates three results: "]
[null,null,"(i) the maximum contribution available for the current tax year without exceeding the annual allowance"]
[null,null,"(ii) the effect of 'adjusted income' on the annual allowance from April 2016"]
[null,null,"(iii) the annual allowance excess in the current and previous years."]
[]
[null,null,"The output from this calculator does not constitute an illustration."]
[]
[null,null,"This calculator is for guidance purposes only.  For exact figures you will need to speak to your scheme administrator."]
[]
[null,null,"This calculator has been designed to reflect Scottish Widows' current understanding of the latest Finance Act. Legislation is subject to change and users will need to be satisfied that the results reflect their own interpretation 'of the legislation."]
[]
[]
[null,null,"The results shown are solely a function of the data input."]
[]
[null,null,"Every care has been taken to ensure that this information is correct and in accordance with our understanding of the law and HM Revenue & Customs practice, which may change. However, independent confirmation should be obtained before acting or refraining from acting in reliance upon the information given."]
[]
[]
[]
[null,null,"This calculator is for professional adviser use only, not to be relied upon by any other person."]
[]
[null,null,"Scottish Widows Limited. Registered in England and Wales No. 3196171. Registered office in the United Kingdom at 25 Gresham Street, London EC2V 7HN."]
[null,null,"Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.  Financial Services Register number 181655."]

{"sheet":"Question 1","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[[1,2,3,2],[5,2,7,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Question 1"]
[]
[null,null,"Has the client exceeded their standard or tapered annual allowance in a previous tax year?","Yes"]

{"sheet":"Question_2","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[[1,2,3,2],[5,2,7,2],[14,2,15,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Question 2"]
[]
[null,null,"Select the earliest tax year (2011-12 onwards) in which the client exceeded their standard or tapered annual allowance","2011-12"]

{"sheet":"Inputs","index":4,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[14,5,14,6],[14,3,14,4],[15,4,16,4],[12,3,12,4],[3,2,4,5],[3,6,4,6]]}
[]
[null,null,"Has the client exceeded their standard or tapered annual allowance in a previous tax year?",null,null,null,"--Please Select--"]
[]
[null,null,"Select the earliest tax year (2008-09 onwards) to include in the calculation of annual allowance and carry forward.",null,null,null,"--Please Select--"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Client name"]
[]
[null,null,"Tax Year","Eligibility & Input Amount",null,"Tapered Annual Allowance (TAA)"]
[null,null,"Pension Input Period","Eligible for ","Pension Input \nAmount","Adjusted","Threshold"]
[null,null,"(PIP)","Carry Forward",null,"Income","Income"]
[]
[null,null,"Tax year 2008/09","Yes",0,"n/a","n/a"]
[]
[null,null,"Tax year 2009/10","Yes",0,"n/a","n/a"]
[]
[null,null,"Tax year 2010/11","Yes",0,"n/a","n/a"]
[]
[null,null,"Tax year 2011/12","Yes",0,"n/a","n/a"]
[]
[null,null,"Tax year 2012/13","Yes",0,"n/a","n/a"]
[]
[null,null,"Tax year 2013/14","Yes",0,"n/a","n/a"]
[]
[null,null,"Tax year 2014/15","Yes",0,"n/a","n/a"]
[]
[null,null,"Pre alignment year","Yes",0,"n/a","n/a"]
[]
[null,null,"Post alignment year","Yes",0,"n/a","n/a"]
[]
[null,null,"Tax year 2016/17","Yes",0,0,"£110k or less"]
[]
[null,null,"Tax year 2017/18","Yes",0,0,"£110k or less"]
[]
[null,null,"Tax year 2018/19","Yes",0,0,"£110k or less"]
[]
[null,null,"Tax year 2019/20","Yes",0,0,"£110k or less"]
[]
[null,null,"Tax year 2020/21","Yes",0,0,"£200k or less"]
[]
[null,null,"Tax year 2021/22","Yes",0,0,"£200k or less"]
[]
[null,null,"Tax year 2022/23","Yes",0,0,"£200k or less"]
[]
[null,null,"Tax year 2023/24","Yes",0,0,"£200k or less"]
[]
[null,null,"Tax year 2024/25","n/a",0,0,"£200k or less"]

{"sheet":"TAA","index":5,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":false,"merged":[[19,8,21,10],[28,8,31,10],[47,3,53,3],[9,1,9,12],[11,1,11,12],[33,2,33,11],[19,3,25,3],[29,3,30,3],[44,2,44,11],[39,8,42,10],[35,8,37,10],[23,8,25,10],[14,8,16,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"In-Year Annual Allowance Calculator"]
[]
[]
[null,null,"Enter client's contributions for the current tax year in the boxes below:"]
[]
[null,null,null,null,null,null,null,null,"Select the tax year you would like to calculate annual allowance details for."]
[null,null,null,"Tax Year",null,"Year that AA is to be calculated for:","select tax year"]
[]
[]
[]
[null,null,null,"Defined Contributions Schemes",null,"Total employer contributions:",0,null,"Enter total amount paid in the relevant tax year, specifying amount paid via post 8/7/2015 salary exchange."]
[]
[null,null,null,null,null,"- of which, post 8/7/15 salary sacrifice:",0]
[]
[null,null,null,null,null,"Total member contributions via net pay:",0,null,"Enter total contributions paid under relief at source, net pay and paid gross e.g. to section 226 contracts."]
[null,null,null,null,null,"Total member contributions via relief at source:",0]
[null,null,null,null,null,"Total member contributions paid gross:",0]
[]
[]
[null,null,null,null,null,null,null,null,"Total pension input amount to defined benefit schemes, including gross member contributions paid."]
[null,null,null,"Defined Benefit Schemes",null,"Total benefits accrued this tax year:",0]
[null,null,null,null,null,"Total member contributions:",0]
[]
[]
[null,null,"To calculate the client's tapered annual allowance for the current tax year complete the followng section. If this section is left blank the standard £40,000 annual allowance will be used."]
[]
[null,null,null,null,null,null,null,null,"Enter total taxable income after \ndeduction of available tax reliefs."]
[null,null,null,"Taxable Income",null,"As per 'step 2' of the income tax calculation:",0]
[]
[]
[null,null,null,null,null,null,null,null,"Enter total as per the Income Tax (Earnings and Pensions) Act 2003."]
[null,null,null,"Other",null,"Relief claimed on overseas contributions:",0]
[null,null,null,"Payments",null,"Relevant lump sum death benefits:",0]
[]
[]
[null,null,"RESULTS"]
[]
[]
[null,null,null,{"$f":"IF(OR(TAATaxYear=\"select tax year\",TAATaxYear=\"\"),\"select tax year\",TAATaxYear)","v":"select tax year"},null,"Total Pension Input Amount",{"$f":"IF(TAATaxYear=\"select tax year\",0,IF(TAATaxYear=\"select tax year\",0,G20+SUM(G24:G26)+G30+G41))","v":0}]
[]
[null,null,null,null,null,"Adjusted Income",{"$f":"IF(TAATaxYear=\"select tax year\",0,IF(TAATaxYear=\"\",0,IF(OR(TAATaxYear=\"2008/09\",TAATaxYear=\"2009/10\",TAATaxYear=\"2010/11\",TAATaxYear=\"2011/12\",TAATaxYear=\"2012/13\",TAATaxYear=\"2013/14\",TAATaxYear=\"2014/15\",TAATaxYear=\"2015/16\"),0,MAX(0,G37+G20+G24+G26+G30+G41-G42))))","v":0}]
[]
[null,null,null,null,null,"Threshold Income",{"$f":"IF(TAATaxYear=\"select tax year\",0,IF(TAATaxYear=\"\",0,IF(OR(TAATaxYear=\"2008/09\",TAATaxYear=\"2009/10\",TAATaxYear=\"2010/11\",TAATaxYear=\"2011/12\",TAATaxYear=\"2012/13\",TAATaxYear=\"2013/14\",TAATaxYear=\"2014/15\",TAATaxYear=\"2015/16\"),0,MAX(0,G37+G22-G25-G42))))","v":0}]
[]
[null,null,null,null,null,"Annual Allowance / Tapered Annual Allowance",{"$f":"IF(TAATaxYear=\"select tax year\",0,IF(TAATaxYear=\"\",0,IF(OR(TAATaxYear=\"2008/09\",TAATaxYear=\"2009/10\",TAATaxYear=\"2010/11\",TAATaxYear=\"2011/12\",TAATaxYear=\"2012/13\",TAATaxYear=\"2013/14\",TAATaxYear=\"2014/15\",TAATaxYear=\"2015/16\"),Annual_Allowance_2,IF(TAATaxYear=\"2016/17\",Calcs!J40,IF(TAATaxYear=\"2017/18\",Calcs!J41,IF(TAATaxYear=\"2018/19\",Calcs!J42,\nIF(TAATaxYear=\"2019/20\",Calcs!J43,IF(TAATaxYear=\"2020/21\",Calcs!J44,IF(TAATaxYear=\"2021/22\",Calcs!J45,IF(TAATaxYear=\"2022/23\",Calcs!J46,IF(TAATaxYear=\"2023/24\",Calcs!J47,IF(TAATaxYear=\"2024/25\",Calcs!J48,0))))))))))))","v":0}]
[]
[]
[]
[null,null,null,null,"Adjusted Income"]
[]
[null,null,null,null,"Threshold Income"]
[]
[null,null,null,null,"Taper Applies?"]
[]
[null,null,null,null,"Annual Allowance"]

{"sheet":"Calcs","index":6,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,"Adjusted Inc",150000,"Threshold Inc",110000,"Adjusted Inc 2",240000,"Threshold Inc 2",200000,"Adjusted Inc 3",260000]
[null,"Annual Allowance 1",50000,"Annual Allowance 3",80000,"Today's date:",{"$f":"TODAY()","v":"2024-03-06"}]
[null,"Annual Allowance 2",40000,"Min TAA",10000,"Min TAA 2",4000]
[null,"Annual Allowance 4",60000]
[]
[null,"Tax year","Eligible?","AA","PIA","Unused\n(in year)","In Year AA\nExcess","CF +1","CF +2","CF +3","CF to Post","Carry forward","available to current year","AA Excess","Avilable carry forward"]
[null,"Tax year 2008/09",{"$f":"IF(Eligible1=\"Yes\",1,0)","v":1},{"$f":"IF(CalcsEligible1=1,Annual_Allowance_1,0)","v":50000},{"$f":"IF(CalcsEligible1=0,0,DB_PIA1)","v":0},{"$f":"MAX(0,D7-DB_PIA1)","v":50000},"n/a","n/a","n/a",{"$f":"IF(_XS1112>=calcsUnused0809,calcsUnused0809,_XS1112)","v":0},null,{"$f":"SUM(J7:K7)","v":0}]
[null,"Tax year 2009/10",{"$f":"IF(Eligible2=\"Yes\",1,0)","v":1},{"$f":"IF(CalcsEligible2=1,Annual_Allowance_1,0)","v":50000},{"$f":"IF(CalcsEligible2=0,0,DB_PIA2)","v":0},{"$f":"MAX(0,D8-DB_PIA2)","v":50000},"n/a","n/a",{"$f":"IF((_XS1112-J7)>=calcsUnused0910,calcsUnused0910,_XS1112-J7)","v":0},{"$f":"IF(_XS1213>=calcsUnused0910-I8,calcsUnused0910-I8,_XS1213)","v":0},null,{"$f":"SUM(I8:K8)","v":0}]
[null,"Tax year 2010/11",{"$f":"IF(Eligible3=\"Yes\",1,0)","v":1},{"$f":"IF(CalcsEligible3=1,Annual_Allowance_1,0)","v":50000},{"$f":"IF(CalcsEligible3=0,0,DB_PIA3)","v":0},{"$f":"MAX(0,D9-DB_PIA3)","v":50000},"n/a",{"$f":"IF((_XS1112-J7-I8)>=calcsUnused1011,calcsUnused1011,_XS1112-I8-J7)","v":0},{"$f":"IF((_XS1213-J8)>=calcsUnused1011-H9,calcsUnused1011-H9,_XS1213-J8)","v":0},{"$f":"IF(_XS1314>=calcsUnused1011-H9-I9,calcsUnused1011-H9-I9,_XS1314)","v":0},null,{"$f":"SUM(H9:K9)","v":0}]
[null,"Tax year 2011/12",{"$f":"IF(Eligible4=\"Yes\",1,0)","v":1},{"$f":"IF(CalcsEligible4=1,Annual_Allowance_1,0)","v":50000},{"$f":"IF(CalcsEligible4=0,0,DB_PIA4)","v":0},{"$f":"MAX(0,D10-DB_PIA4)","v":50000},{"$f":"IF(CalcsEligible4=0,0,MAX(0,DB_PIA4-D10))","v":0},{"$f":"IF((_XS1213-I9-J8)>=calcsUnused1112,calcsUnused1112,_XS1213-J8-I9)","v":0},{"$f":"IF((_XS1314-J9)>=calcsUnused1112-H10,calcsUnused1112-H10,_XS1314-J9)","v":0},{"$f":"IF(_XS1415>=calcsUnused1112-H10-I10,calcsUnused1112-H10-I10,_XS1415)","v":0},null,{"$f":"SUM(H10:K10)","v":0},{"$f":"J7+I8+H9","v":0},{"$f":"MAX(0,G10-M10)","v":0}]
[null,"Tax year 2012/13",{"$f":"IF(Eligible5=\"Yes\",1,0)","v":1},{"$f":"IF(CalcsEligible5=1,Annual_Allowance_1,0)","v":50000},{"$f":"IF(CalcsEligible5=0,0,DB_PIA5)","v":0},{"$f":"MAX(0,D11-DB_PIA5)","v":50000},{"$f":"IF(CalcsEligible5=0,0,MAX(0,DB_PIA5-D11))","v":0},{"$f":"IF((_XS1314-I10-J9)>=calcsUnused1213,calcsUnused1213,_XS1314-J9-I10)","v":0},{"$f":"IF((_XS1415-J10)>=calcsUnused1213-H11,calcsUnused1213-H11,_XS1415-J10)","v":0},{"$f":"IF(_preAlign>=calcsUnused1213-H11-I11,calcsUnused1213-H11-I11,_preAlign)","v":0},{"$f":"IF(_postAlign-K14>=calcsUnused1213-H11-I11-J11,calcsUnused1213-H11-I11-J11,_postAlign-K14)","v":0},0,{"$f":"J8+I9+H10","v":0},{"$f":"MAX(0,G11-M11)","v":0}]
[null,"Tax year 2013/14",{"$f":"IF(Eligible6=\"Yes\",1,0)","v":1},{"$f":"IF(CalcsEligible6=1,Annual_Allowance_1,0)","v":50000},{"$f":"IF(CalcsEligible6=0,0,DB_PIA6)","v":0},{"$f":"MAX(0,D12-DB_PIA6)","v":50000},{"$f":"IF(CalcsEligible6=0,0,MAX(0,DB_PIA6-D12))","v":0},{"$f":"IF((_XS1415-J10-I11)>=calcsUnused1314,calcsUnused1314,_XS1415-J10-I11)","v":0},{"$f":"IF((_preAlign-J11)>=calcsUnused1314-H12,calcsUnused1314-H12,_preAlign-J11)","v":0},{"$f":"IF(_XS1617>=calcsUnused1314-H12-I12-K12,calcsUnused1314-H12-I12-K12,_XS1617)","v":0},{"$f":"IF(_postAlign-K14-K11>=calcsUnused1314-H12-I12,calcsUnused1314-H12-I12,_postAlign-K14-K11)","v":0},{"$f":"SUM(H12:K12)","v":0},{"$f":"J9+I10+H11","v":0},0]
[null,"Tax year 2014/15",{"$f":"IF(Eligible7=\"Yes\",1,0)","v":1},{"$f":"IF(CalcsEligible7=1,Annual_Allowance_2,0)","v":40000},{"$f":"IF(CalcsEligible7=0,0,DB_PIA7)","v":0},{"$f":"MAX(0,D13-DB_PIA7)","v":40000},{"$f":"IF(CalcsEligible7=0,0,MAX(0,DB_PIA7-D13))","v":0},{"$f":"IF((_preAlign-J11-I12)>=calcsUnused1415,calcsUnused1415,_preAlign-J11-I12)","v":0},{"$f":"IF((_XS1617-J12)>=calcsUnused1415-K13-H13,calcsUnused1415-K13-H13,_XS1617-J12)","v":0},{"$f":"IF(_XS1718>=calcsUnused1415-H13-K13-I13,calcsUnused1415-H13-K13-I13,_XS1718)","v":0},{"$f":"IF(_postAlign-K14-K11-K12>=calcsUnused1415-H13,calcsUnused1415-H13,_postAlign-K14-K11-K12)","v":0},0,{"$f":"J10+I11+H12","v":0},0]
[null,"Pre-Alignment",{"$f":"IF(Eligible8=\"Yes\",1,0)","v":1},{"$f":"IF(CalcsEligible8=1,Annual_Allowance_3,0)","v":80000},{"$f":"IF(CalcsEligible8=0,0,DB_PIA8)","v":0},{"$f":"MAX(0,D14-DB_PIA8)","v":80000},{"$f":"IF(CalcsEligible8=0,0,MAX(0,DB_PIA8-D14))","v":0},{"$f":"IF(_XS1617-J12-I13>=MIN(40000,calcsUnusedPre)-K14,MIN(40000,calcsUnusedPre)-K14,_XS1617-J12-I13)","v":0},{"$f":"IF(_XS1718-J13>=MIN(40000,calcsUnusedPre)-K14-H14,MIN(40000,calcsUnusedPre)-K14-H14,_XS1718-J13)","v":0},{"$f":"IF(_XS1819>=MIN(40000,calcsUnusedPre)-K14-H14-I14,MIN(40000,calcsUnusedPre)-K14-H14-I14,_XS1819)","v":0},{"$f":"IF(_postAlign>=MIN(calcsUnusedPre,40000),MIN(40000,calcsUnusedPre),_postAlign)","v":0},0,{"$f":"J11+I12+H13","v":0},0]
[null,"Post-Alignment","n/a",0,{"$f":"IF(CalcsEligible8=0,0,DB_PIA9)","v":0},{"$f":"MAX(0,D15-DB_PIA9)","v":0},{"$f":"IF(CalcsEligible8=0,0,MAX(0,DB_PIA9-D15))","v":0},0,0,0,0,0,{"$f":"SUM(K11:K14)","v":0},{"$f":"MAX(0,G15-M15)","v":0}]
[null,"Tax year 2016/17",{"$f":"IF(Eligible10=\"Yes\",1,0)","v":1},{"$f":"IF(CalcsEligible10=1,IF(AND(AdjInc1617>TAAthreshold1,TAAeligible1=2),MAX(MinTaper,Annual_Allowance_2-(AdjInc1617-TAAthreshold1)/2),Annual_Allowance_2),0)","v":40000},{"$f":"IF(CalcsEligible10=0,0,DB_PIA10)","v":0},{"$f":"MAX(0,D16-DB_PIA10)","v":40000},{"$f":"IF(CalcsEligible10=0,0,MAX(0,DB_PIA10-D16))","v":0},{"$f":"IF(_XS1718-J13-I14>=calcsUnused1617,calcsUnused1617,_XS1718-I14-J13)","v":0},{"$f":"IF(_XS1819-J14>=calcsUnused1617-H16,calcsUnused1617-H16,_XS1819-J14)","v":0},{"$f":"IF(_XS1920>calcsUnused1617-H16-I16,calcsUnused1617-H16-I16,_XS1920)","v":0},null,0,{"$f":"H14+I13+J12","v":0},0]
[null,"Tax year 2017/18",{"$f":"IF(Eligible11=\"Yes\",1,0)","v":1},{"$f":"IF(CalcsEligible11=1,IF(AND(AdjInc1718>TAAthreshold1,TAAEligible2=2),MAX(MinTaper,Annual_Allowance_2-(AdjInc1718-TAAthreshold1)/2),Annual_Allowance_2),0)","v":40000},{"$f":"IF(CalcsEligible11=0,0,DB_PIA11)","v":0},{"$f":"MAX(0,D17-DB_PIA11)","v":40000},{"$f":"IF(CalcsEligible11=0,0,MAX(0,DB_PIA11-D17))","v":0},{"$f":"IF(_XS1819-J14-I16>=calcsUnused1718,calcsUnused1718,_XS1819-I16-J14)","v":0},{"$f":"IF(_XS1920-J16>=calcsUnused1718-H17,calcsUnused1718-H17,_XS1920-J16)","v":0},{"$f":"IF(_XS2021>calcsUnused1718-H17-I17,calcsUnused1718-H17-I17,_XS2021)","v":0},null,0,{"$f":"H16+I14+J13","v":0},0]
[null,"Tax year 2018/19",{"$f":"IF(Eligible12=\"Yes\",1,0)","v":1},{"$f":"IF(CalcsEligible12=1,IF(AND(AdjInc1819>TAAthreshold1,TAAeligible3=2),MAX(MinTaper,Annual_Allowance_2-(AdjInc1819-TAAthreshold1)/2),Annual_Allowance_2),0)","v":40000},{"$f":"IF(CalcsEligible12=0,0,DB_PIA12)","v":0},{"$f":"MAX(0,D18-DB_PIA12)","v":40000},{"$f":"IF(CalcsEligible12=0,0,MAX(0,DB_PIA12-D18))","v":0},{"$f":"IF(_XS1920-J16-I17>=calcsUnused1819,calcsUnused1819,_XS1920-J16-I17)","v":0},{"$f":"IF(_XS2021-J17>=calcsUnused1819-H18,calcsUnused1819-H18,_XS2021-J17)","v":0},{"$f":"IF(_XS2122>calcsUnused1819-H18-I18,calcsUnused1819-H18-I18,_XS2122)","v":0},null,0,{"$f":"H17+I16+J14","v":0},0]
[null,"Tax year 2019/20",{"$f":"IF(Eligible13=\"Yes\",1,0)","v":1},{"$f":"IF(CalcsEligible13=1,IF(AND(AdjInc1920>TAAthreshold1,TAAEligible4=2),MAX(MinTaper,Annual_Allowance_2-(AdjInc1920-TAAthreshold1)/2),Annual_Allowance_2),0)","v":40000},{"$f":"IF(CalcsEligible13=0,0,DB_PIA13)","v":0},{"$f":"MAX(0,D19-DB_PIA13)","v":40000},{"$f":"IF(CalcsEligible13=0,0,MAX(0,DB_PIA13-D19))","v":0},{"$f":"IF(_XS2021-J17-I18>=calcsUnused1920,calcsUnused1920,_XS2021-I18-J17)","v":0},{"$f":"IF(_XS2122-J18>0,MIN(_XS2122-J18,Unused1920-H19),0)","v":0},{"$f":"IF(_XS2223>calcsUnused1920-H19-I19,calcsUnused1920-H19-I19,_XS2223)","v":0},null,0,{"$f":"H18+I17+J16","v":0},0]
[null,"Tax year 2020/21",{"$f":"IF(Eligible14=\"Yes\",1,0)","v":1},{"$f":"IF(CalcsEligible14=1,IF(AND(AdjInc2021>240000,TAAEligible5=2),MAX(4000,Annual_Allowance_2-(AdjInc2021-240000)/2),Annual_Allowance_2),0)","v":40000},{"$f":"IF(CalcsEligible14=0,0,DB_PIA14)","v":0},{"$f":"MAX(0,D20-DB_PIA14)","v":40000},{"$f":"IF(CalcsEligible14=0,0,MAX(0,DB_PIA14-D20))","v":0},{"$f":"IF(_XS2122-J18-I19>=calcsUnused2021,calcsUnused2021,_XS2122-J18-I19)","v":0},{"$f":"IF(_XS2223-J19>0,MIN(_XS2223-J19,Unused2021-H20),0)","v":0},{"$f":"IF(_XS2324>calcsUnused2021-H20-I20,calcsUnused2021-H20-I20,_XS2324)","v":0},null,0,0,0]
[null,"Tax year 2021/22",{"$f":"IF(Eligible15=\"Yes\",1,0)","v":1},{"$f":"IF(CalcsEligible15=1,IF(AND(AdjInc2122>240000,TAAEligible6=2),MAX(4000,Annual_Allowance_2-(AdjInc2122-240000)/2),Annual_Allowance_2),0)","v":40000},{"$f":"IF(CalcsEligible15=0,0,DB_PIA15)","v":0},{"$f":"MAX(0,D21-DB_PIA15)","v":40000},{"$f":"IF(CalcsEligible15=0,0,MAX(0,DB_PIA15-D21))","v":0},{"$f":"IF(_XS2223-J19-I20>=calcsUnused2122,calcsUnused2122,_XS2223-J19-I20)","v":0},{"$f":"IF(_XS2324-J20>0,MIN(_XS2324-J20,Unused2122-H21),0)","v":0},{"$f":"IF(_XS2425>calcsUnused2122-H21-I21,calcsUnused2122-H21-I21,_XS2425)","v":0},null,0,0,0,{"$f":"MAX(0,D21-Calcs_PIA15-H21-I21-J21)","v":40000}]
[null,"Tax year 2022/23",{"$f":"IF(Eligible16=\"Yes\",1,0)","v":1},{"$f":"IF(CalcsEligible16=1,IF(AND(AdjInc2223>TAAthreshold3,TAAEligible7=2),MAX(4000,Annual_Allowance_2-(AdjInc2223-240000)/2),Annual_Allowance_2),0)","v":40000},{"$f":"IF(CalcsEligible16=0,0,DB_PIA16)","v":0},{"$f":"MAX(0,D22-DB_PIA16)","v":40000},{"$f":"IF(CalcsEligible16=0,0,MAX(0,DB_PIA16-D22))","v":0},{"$f":"IF(_XS2324-J20-I21>=calcsUnused2223,calcsUnused2223,_XS2324-J20-I21)","v":0},{"$f":"IF(_XS2425-J21>0,MIN(_XS2425-J21,Unused2223-H22),0)","v":0},"n/a",null,0,0,0,{"$f":"MAX(0,D22-Calcs_PIA16-H22-I22)","v":40000}]
[null,"Tax year 2023/24",{"$f":"IF(Eligible17=\"Yes\",1,0)","v":1},{"$f":"IF(AND(AdjInc2324>TAAthreshold5,TAAEligible8=2),MAX(MinTaper,Annual_Allowance_4-(AdjInc2324-TAAthreshold5)/2),Annual_Allowance_4)","v":60000},{"$f":"DB_PIA17","v":0},{"$f":"MAX(0,D23-DB_PIA17)","v":60000},{"$f":"MAX(0,DB_PIA17-D23)","v":0},{"$f":"IF(_XS2425-J21-I22>=calcsUnused2324,calcsUnused2324,_XS2425-J21-I22)","v":0},"n/a","n/a",null,{"$f":"SUM(H23:K23)","v":0},0,0,{"$f":"MAX(0,D23-Calcs_PIA17-H23)","v":60000}]
[null,"Tax year 2024/25","n/a",{"$f":"IF(AND(AdjInc2425>TAAthreshold5,TAAEligible9=2),MAX(MinTaper,Annual_Allowance_4-(AdjInc2425-TAAthreshold5)/2),Annual_Allowance_4)","v":60000},{"$f":"DB_PIA18","v":0},{"$f":"MAX(0,D24-DB_PIA18)","v":60000},{"$f":"MAX(0,DB_PIA18-D24)","v":0},"n/a","n/a","n/a",null,{"$f":"SUM(H24:K24)","v":0},{"$f":"H23+I22+J21","v":0},{"$f":"MAX(0,G24-M24)","v":0},{"$f":"MAX(0,D24-Calcs_PIA18)","v":60000}]
[]
[null,"TAA income figures"]
[null,"Adjusted Income",{"$f":"AdjustedIncome_TAA","v":0}]
[null,"Threshold Income",{"$f":"IF(ThresholdIncome_TAA>110000,1,0)","v":0}]
[null,"Threshold Income 2",{"$f":"IF(ThresholdIncome_TAA>200000,1,0)","v":0}]
[]
[]
[]
[]
[null,"Total PIA",{"$f":"TotalPIA_TAA","v":0}]
[]
[null,"Questions"]
[null,"Q1",{"$f":"IF(Q1_answerSelection=\"No\",0,IF(Q1_answerSelection=\"Yes\",1,2))","v":2}]
[null,"Q2",{"$f":"IF(OR(Q2_answerSelection=\"--Please Select--\",Q2_answerSelection=\"\"),\"none\",Q2_answerSelection)","v":"none"},{"$f":"IF(OR(question_one=0,AND(question_one=1,question_two<>\"none\")),\"PASS\",\"FAIL\")","v":"FAIL"}]
[]
[null,"TAA Eligible",null,null,null,null,"2016/17",{"$f":"AdjustedIncome_TAA","v":0},{"$f":"ThresholdIncome_TAA","v":0},{"$f":"IF(TAATaxYear=Calcs!G40,MAX(MinTaper,Annual_Allowance_2-MAX(0,H40-TAAthreshold1)/2),Annual_Allowance_2)","v":40000}]
[null,"2016/17",{"$f":"IF(AdjInc1617>TAAthreshold1,1,0)","v":0},{"$f":"IF(ThreshInc1617=\">£110k\",1,0)","v":0},{"$f":"SUM(C41:D41)","v":0},null,"2017/18",0,0,{"$f":"IF(TAATaxYear=Calcs!G41,MAX(MinTaper,Annual_Allowance_2-MAX(0,H41-TAAthreshold1)/2),Annual_Allowance_2)","v":40000}]
[null,"2017/8",{"$f":"IF(AdjInc1718>TAAthreshold1,1,0)","v":0},{"$f":"IF(ThreshInc1718=\">£110k\",1,0)","v":0},{"$f":"SUM(C42:D42)","v":0},null,"2018/19",0,0,{"$f":"IF(TAATaxYear=Calcs!G42,MAX(MinTaper,Annual_Allowance_2-MAX(0,H42-TAAthreshold1)/2),Annual_Allowance_2)","v":40000}]
[null,"2018/19",{"$f":"IF(AdjInc1819>TAAthreshold1,1,0)","v":0},{"$f":"IF(Threshinc1819=\">£110k\",1,0)","v":0},0,null,"2019/20",0,0,{"$f":"IF(TAATaxYear=Calcs!G43,MAX(MinTaper,Annual_Allowance_2-MAX(0,H43-TAAthreshold1)/2),Annual_Allowance_2)","v":40000}]
[null,"2019/20",{"$f":"IF(AdjInc1920>TAAthreshold1,1,0)","v":0},{"$f":"IF(ThreshInc1920=\">£110k\",1,0)","v":0},0,null,"2020/21",0,0,{"$f":"IF(TAATaxYear=Calcs!G44,MAX(MinTaper2,Annual_Allowance_2-MAX(0,H44-TAAthreshold3)/2),Annual_Allowance_2)","v":40000}]
[null,"2020/21",{"$f":"IF(AdjInc2021>TAAthreshold3,1,0)","v":0},{"$f":"IF(ThreshInc2021=\">£200k\",1,0)","v":0},0,null,"2021/22",0,0,{"$f":"IF(TAATaxYear=Calcs!G45,MAX(MinTaper2,Annual_Allowance_2-MAX(0,H45-TAAthreshold3)/2),Annual_Allowance_2)","v":40000}]
[null,"2021/22",{"$f":"IF(AdjInc2122>TAAthreshold3,1,0)","v":0},{"$f":"IF(ThreshInc2122=\">£200k\",1,0)","v":0},0,null,"2022/23",0,0,{"$f":"IF(TAATaxYear=Calcs!G46,MAX(MinTaper2,Annual_Allowance_2-MAX(0,H46-TAAthreshold3)/2),Annual_Allowance_2)","v":40000}]
[null,"2022/23",{"$f":"IF(AdjInc2223>TAAthreshold3,1,0)","v":0},{"$f":"IF(ThreshInc2223=\">£200k\",1,0)","v":0},0,null,"2023/24",{"$f":"AdjustedIncome_TAA","v":0},0,{"$f":"IF(TAATaxYear=Calcs!G47,MAX(MinTaper,Annual_Allowance_4-MAX(0,H47-TAAthreshold5)/2),Annual_Allowance_4)","v":60000}]
[null,"2023/24",{"$f":"IF(AdjInc2324>TAAthreshold5,1,0)","v":0},{"$f":"IF(ThreshInc2324=\">£200k\",1,0)","v":0},{"$f":"SUM(C48:D48)","v":0},null,"2024/25",{"$f":"AdjustedIncome_TAA","v":0},0,{"$f":"IF(TAATaxYear=Calcs!G48,MAX(MinTaper,Annual_Allowance_4-MAX(0,H48-TAAthreshold5)/2),Annual_Allowance_4)","v":60000}]
[null,"2024/25",{"$f":"IF(AdjInc2425>TAAthreshold5,1,0)","v":0},{"$f":"IF(ThreshInc2425=\">£200k\",1,0)","v":0},{"$f":"SUM(C49:D49)","v":0}]

{"sheet":"Results","index":7,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,11,7,11],[5,12,7,18],[37,2,37,6],[12,3,12,7],[14,3,14,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"RESULTS"]
[]
[null,null,"Client name",{"$f":"IF(Client=\"\",\"\",Client)","v":""}]
[]
[null,null,"Pension Input Period","Annual\nAllowance","Original \nPIA","Previous Carry forward","Annual Allowance Excess","Unused Annual Allowance"]
[null,null,"Tax year 2008/09",{"$f":"Calcs!D7","v":50000},{"$f":"Calcs!E7","v":0},{"$f":"Calcs!L7","v":0},{"$f":"Calcs!N7","v":0}]
[null,null,"Tax year 2009/10",{"$f":"Calcs!D8","v":50000},{"$f":"Calcs!E8","v":0},{"$f":"Calcs!L8","v":0},{"$f":"Calcs!N8","v":0}]
[null,null,"Tax year 2010/11",{"$f":"Calcs!D9","v":50000},{"$f":"Calcs!E9","v":0},{"$f":"Calcs!L9","v":0},{"$f":"Calcs!N9","v":0}]
[null,null,"Tax year 2011/12",{"$f":"Calcs!D10","v":50000},{"$f":"Calcs!E10","v":0},{"$f":"Calcs!L10","v":0},{"$f":"Calcs!N10","v":0}]
[null,null,"Tax year 2012/13",{"$f":"Calcs!D11","v":50000},{"$f":"Calcs!E11","v":0},{"$f":"Calcs!L11","v":0},{"$f":"Calcs!N11","v":0}]
[null,null,"Tax year 2013/14",{"$f":"Calcs!D12","v":50000},{"$f":"Calcs!E12","v":0},{"$f":"Calcs!L12","v":0},{"$f":"Calcs!N12","v":0}]
[null,null,"Tax Year 2014/15",{"$f":"Calcs!D13","v":40000},{"$f":"Calcs!E13","v":0},{"$f":"Calcs!L13","v":0},{"$f":"Calcs!N13","v":0}]
[null,null,"Pre-Alignment",{"$f":"Calcs!D14","v":80000},{"$f":"Calcs!E14","v":0},{"$f":"Calcs!L14","v":0},{"$f":"Calcs!N14","v":0}]
[null,null,"Post-Alignment",{"$f":"Calcs!D15","v":0},{"$f":"Calcs!E15","v":0},{"$f":"Calcs!L15","v":0},{"$f":"Calcs!N15","v":0}]
[null,null,"Tax year 2016/17",{"$f":"Calcs!D16","v":40000},{"$f":"Calcs_PIA10","v":0},{"$f":"Calcs!L16","v":0},{"$f":"Calcs!N16","v":0}]
[null,null,"Tax year 2017/18",{"$f":"Calcs!D17","v":40000},{"$f":"Calcs_PIA11","v":0},{"$f":"Calcs!L17","v":0},{"$f":"Calcs!N17","v":0}]
[null,null,"Tax year 2018/19",{"$f":"Calcs!D18","v":40000},{"$f":"Calcs_PIA12","v":0},{"$f":"Calcs!L18","v":0},{"$f":"Calcs!N18","v":0}]
[null,null,"Tax Year 2019/20",{"$f":"Calcs!D19","v":40000},{"$f":"Calcs_PIA13","v":0},{"$f":"Calcs!L19","v":0},{"$f":"Calcs!N19","v":0}]
[null,null,"Tax year 2020/21",{"$f":"Calcs!D20","v":40000},{"$f":"Calcs_PIA14","v":0},{"$f":"Calcs!L20","v":0},{"$f":"Calcs!N20","v":0}]
[null,null,"Tax Year 2021/22",{"$f":"Calcs!D21","v":40000},{"$f":"Calcs_PIA15","v":0},{"$f":"Calcs!L21","v":0},{"$f":"Calcs!N21","v":0},{"$f":"Calcs!O21","v":40000}]
[null,null,"Tax Year 2022/23",{"$f":"Calcs!D22","v":40000},{"$f":"Calcs_PIA16","v":0},{"$f":"Calcs!L22","v":0},{"$f":"Calcs!N22","v":0},{"$f":"Calcs!O22","v":40000}]
[null,null,"Tax Year 2023/24",{"$f":"Calcs!D23","v":60000},{"$f":"Calcs_PIA17","v":0},{"$f":"Calcs!L23","v":0},{"$f":"Calcs!N23","v":0},{"$f":"Calcs!O23","v":60000}]
[null,null,"Tax Year 2024/25",{"$f":"Calcs!D24","v":60000},{"$f":"Calcs_PIA18","v":0},{"$f":"Calcs!L25","v":0},{"$f":"Calcs!N24","v":0},{"$f":"Calcs!O24","v":60000}]
[]
[]
[null,null,"Remaining annual allowance (plus carry forward) for tax year 2024/25:     ",null,null,null,null,{"$f":"SUM(H32:H35)","v":200000}]

{"sheet":"Output","index":8,"n_rows":68,"n_cols":7,"rows_kept":68,"cut":false,"hidden":false,"merged":[[11,2,12,2],[35,2,36,2]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Client Name",{"$f":"IF(Client=\"\",\"\",Client)","v":""}]
[]
[null,null,"Inputs"]
[]
[null,null,"Tax year","Eligible for","Annual ","Original","Previous"]
[null,null,null,"Carry Forward","Allowance","PIA","Carry Forward"]
[null,null,"2008/09",{"$f":"Eligible1","v":"Yes"},"-",{"$f":"Calcs_PIA1","v":0},{"$f":"Results!F18","v":0}]
[null,null,"2009/10",{"$f":"Eligible2","v":"Yes"},"-",{"$f":"Calcs_PIA2","v":0},{"$f":"Results!F19","v":0}]
[null,null,"2010/11",{"$f":"Eligible3","v":"Yes"},"-",{"$f":"Calcs_PIA3","v":0},{"$f":"Results!F20","v":0}]
[null,null,"2011/12",{"$f":"Eligible4","v":"Yes"},{"$f":"ClientAA11","v":50000},{"$f":"Calcs_PIA4","v":0},{"$f":"Results!F21","v":0}]
[null,null,"2012/13",{"$f":"Eligible5","v":"Yes"},{"$f":"ClientAA12","v":50000},{"$f":"Calcs_PIA5","v":0},{"$f":"Results!F22","v":0}]
[null,null,"2013/14",{"$f":"Eligible6","v":"Yes"},{"$f":"ClientAA13","v":50000},{"$f":"Calcs_PIA6","v":0},{"$f":"Results!F23","v":0}]
[null,null,"2014/15",{"$f":"Eligible7","v":"Yes"},{"$f":"ClientAA14","v":40000},{"$f":"Calcs_PIA7","v":0},{"$f":"Results!F24","v":0}]
[null,null,"Pre-Alignment",{"$f":"Eligible8","v":"Yes"},{"$f":"ClientAApre","v":80000},{"$f":"Calcs_PIA8","v":0},{"$f":"Results!F25","v":0}]
[null,null,"Post-Alignment",{"$f":"D21","v":"Yes"},0,{"$f":"Calcs_PIA9","v":0},{"$f":"Results!F26","v":0}]
[null,null,"2016/17",{"$f":"Eligible10","v":"Yes"},{"$f":"ClientAA16","v":40000},{"$f":"Calcs_PIA10","v":0},{"$f":"Results!F27","v":0}]
[null,null,"2017/18",{"$f":"Eligible11","v":"Yes"},{"$f":"ClientAA17","v":40000},{"$f":"Calcs_PIA11","v":0},{"$f":"Results!F28","v":0}]
[null,null,"2018/19",{"$f":"Eligible12","v":"Yes"},{"$f":"ClientAA18","v":40000},{"$f":"Calcs_PIA12","v":0},{"$f":"Results!F29","v":0}]
[null,null,"2019/20",{"$f":"Eligible13","v":"Yes"},{"$f":"ClientAA19","v":40000},{"$f":"Calcs_PIA13","v":0},{"$f":"Results!F30","v":0}]
[null,null,"2020/21",{"$f":"Eligible14","v":"Yes"},{"$f":"ClientAA20","v":40000},{"$f":"Calcs_PIA14","v":0},{"$f":"Results!F31","v":0}]
[null,null,"2021/22",{"$f":"Eligible15","v":"Yes"},{"$f":"ClientAA21","v":40000},{"$f":"Calcs_PIA15","v":0},{"$f":"Results!F32","v":0}]
[null,null,"2022/23",{"$f":"Eligible16","v":"Yes"},{"$f":"ClientAA22","v":40000},{"$f":"Calcs_PIA16","v":0},{"$f":"Results!F33","v":0}]
[null,null,"2023/24",{"$f":"Eligible17","v":"Yes"},{"$f":"ClientAA23","v":60000},{"$f":"Calcs_PIA17","v":0},{"$f":"Results!F34","v":0}]
[null,null,"2024/25","n/a",{"$f":"ClientAA24","v":60000},{"$f":"Calcs_PIA18","v":0},{"$f":"Results!F35","v":0}]
[]
[]
[null,null,"Results"]
[]
[null,null,"Pension input period","AA","Unused Annual"]
[null,null,null,"Excess","Allowance"]
[null,null,"2021/22",{"$f":"Results!G32","v":0},{"$f":"Results!H32","v":40000}]
[null,null,"2022/23",{"$f":"Results!G33","v":0},{"$f":"Results!H33","v":40000}]
[null,null,"2023/24",{"$f":"Results!G34","v":0},{"$f":"Results!H34","v":60000}]
[null,null,"2024/25",{"$f":"Results!G35","v":0},{"$f":"Results!H35","v":60000}]
[]
[null,null,null,"Total AA plus carry forward:",{"$f":"SUM(E38:E41)","v":200000}]
[]
[null,null,"N.B. Tax relief on personal contributions will be restricted to 100% of client's relevant UK earnings."]
[]
[null,null,"Important notes"]
[]
[null,null,"The output from this calculator does not constitute an illustration."]
[]
[null,null,"This calculator is for guidance purposes only.  For exact figures speak to your scheme administrator."]
[]
[null,null,"This calculator has been designed to reflect Scottish Widows' current understanding of the latest Finance Act."]
[null,null,"Legislation is subject to change and users will need to be satisfied that the results reflect their own interpretation"]
[null,null,"of the legislation."]
[]
[null,null,"The results shown are solely a function of the data entered."]
[]
[null,null,"Every care has been taken to ensure that this information is correct and in accordance with our "]
[null,null,"understanding of the law and HM Revenue & Customs practice, which may change. However, independent"]
[null,null,"confirmation should be obtained before acting or refraining from acting in reliance upon the information given."]
[]
[null,null,"This calculator is for professional adviser use only, not to be relied upon by any other person."]
[]
[]
[null,null,"Scottish Widows Limited. Registered in England and Wales No. 3196171. Registered office in the United Kingdom at 25 Gresham Street, London EC2V 7HN."]
[null,null,"Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.  Financial Services Register number 181655."]
[null,null,null,null,null,"Printed on: ",{"$f":"TODAY()","v":"2024-03-06"}]

{"sheet":"Lists","index":9,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["--Please Select--","--Please Select--",null,null,null,null,null,null,null,null,null,null,null,"To do"]
["Yes",null,null,"2024/25"]
["No",null,null,"2023/24"]
[null,null,null,"2022/23"]
[null,"2021/22",{"$f":"IF(question_one=0,\"OPEN\",IF(C6=\"OPEN\",\"OPEN\",IF(question_two=B5,\"OPEN\",\"CLOSE\")))","v":"CLOSE"},"2021/22"]
[null,"2020/21",{"$f":"IF(C7=\"OPEN\",\"OPEN\",IF(question_two=B6,\"OPEN\",\"CLOSE\"))","v":"CLOSE"},{"$f":"IF(C6=\"OPEN\",B6,\"n/a\")","v":"n/a"}]
[null,"2019/20","CLOSE","n/a"]
[null,"2018/19","CLOSE","n/a"]
[null,"2017/18","CLOSE","n/a"]
[null,"2016/17","CLOSE","n/a"]
[null,"2015/16","CLOSE","n/a"]
[null,"2014/15","CLOSE","n/a"]
[null,"2013/14","CLOSE","n/a"]
[null,"2012/13","CLOSE","n/a"]
[null,"2011/12","CLOSE","n/a"]
[null,"2010/11","CLOSE","n/a"]
[null,"2009/10","CLOSE","n/a"]
[null,"2008/09","CLOSE","n/a"]