{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Pension Inputs","Carry Forward Summary Workings","Carry Forward Full Workings","Tapered AA Calculations","Summary Print Friendly","Tapered Calcs - Print Friendly"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"Pension Inputs","index":0,"n_rows":51,"n_cols":28,"rows_kept":51,"cut":false,"hidden":false,"merged":[[14,42,14,43],[14,34,14,35],[14,36,14,37],[14,30,14,31],[7,14,9,19],[14,32,14,33],[14,19,15,19],[36,27,36,30],[37,27,45,30],[14,38,14,39],[14,40,14,41],[16,34,35,35],[0,11,0,12],[0,14,0,15],[33,14,33,15],[33,17,33,18],[30,19,31,19],[16,19,17,19],[14,17,15,18],[11,14,12,19],[20,19,21,19],[18,19,19,19],[22,19,23,19],[31,12,32,15],[21,16,23,17],[17,14,18,17],[37,16,37,19],[38,16,38,19],[43,16,43,19],[30,17,31,18],[24,17,25,18],[24,19,25,19],[35,16,35,19],[36,16,36,19],[50,11,50,19],[47,12,47,15],[39,16,39,19],[40,16,40,19],[41,16,41,19],[42,16,42,19],[46,16,46,19],[44,16,44,19]]}
[null,null,null,null,null,null,null,null,null,null,null,"Annual Allowance Calculator\nbuilt by M&G",null,null,"Tax Year 2024/25"]
["No"]
[null,null,null,null,null,null,null,"For conditional for year joined scheme","Conditional for warnings",null,null,"What tax year did individual first join a pension?",null,null,"Instructions for use"]
["2008/09",1,null,null,null,null,null,{"$f":"IF($C$7>B4,1,0)","v":0},null,null,null,"(If a member prior to 2008/09 tax year select 2008/09).","2008/09",null,"Step1: Input tax year first joined a pension scheme."]
["2009/10",2,null,null,null,null,null,0,null,null,null,null,{"$f":"IF('Carry Forward Full Workings'!W20>0,\"Pension Inputs have been entered for a year prior to scheme membership - please amend.\",\"\")","v":""},null,"Step2: Calculate tapered AA if applicable using grey button on right hand side."]
["2010/11",3,null,null,null,null,null,0,null,null,null,null,null,null,"Step3: Input existing pension input amounts in white boxes. Inputs are required until there is 3 clear years with no AA excess"]
["2011/12",4,{"$f":"VLOOKUP(M4,A4:B23,2,FALSE)","v":1},"Added to lookup to capture 2020/23",null,null,null,0,null,null,null,"Total inputs for PIPs ending in Tax Year:","Existing Inputs"]
["2012/13",5,null,null,null,null,null,0,null,null,null,{"$f":"A4","v":"2008/09"},0,null,"2008/09 to 2010/11 - Inputs are capped at £50,000 for Carry Forward calculations    "]
["2013/14",6,null,null,null,null,null,0,null,null,null,{"$f":"A5","v":"2009/10"},0]
["2014/15",7,null,null,null,null,null,0,null,null,null,{"$f":"A6","v":"2010/11"},0]
["2015/16 (pre alignment)",8,null,null,null,null,null,0,null,null,null,{"$f":"A7","v":"2011/12"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suicide Code"]
["2015/16 (post alignment)",8.5,null,null,null,null,null,0,null,null,null,"Inputs prior to 14/10/2010",0,null,"Straddling PIPs - if total inputs are less than or equal to £50,000 then put all in as post 14/10/2010. \nIf total inputs are over £50,000 then you need to enter the pre and post 14/10/10 split of inputs. ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-04-08"}]
["2016/17",9,null,null,null,null,null,0,{"$f":"IF('Tapered AA Calculations'!L42>0,IF(M20<>'Tapered AA Calculations'!L42,1,0),0)","v":0},null,null,"Inputs on or after 14/10/2010",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-04-05"]
["2017/18",10,null,null,null,null,null,0,{"$f":"IF('Tapered AA Calculations'!S43>0,IF(M21<>'Tapered AA Calculations'!S43,1,0),0)","v":0},null,null,{"$f":"A8","v":"2012/13"},0]
["2018/19",11,null,null,null,0,null,0,{"$f":"IF('Tapered AA Calculations'!Z43>0,IF(M22<>'Tapered AA Calculations'!Z43,1,0),0)","v":0},null,null,{"$f":"A9","v":"2013/14"},0,null,null,null,null,null,null,null,{"$f":"IF(AND(O20>0,O20<10000),\"WARNING - This is less than the minimum taper\",\"\")","v":""}]
["2019/20",12,null,null,null,0,null,0,{"$f":"IF('Tapered AA Calculations'!AG43>0,IF(M23<>'Tapered AA Calculations'!AG43,1,0),0)","v":0},null,null,{"$f":"A10","v":"2014/15"},0]
["2020/21",13,null,null,null,0,null,0,{"$f":"IF('Tapered AA Calculations'!AN43>0,IF(M24<>'Tapered AA Calculations'!AN43,1,0),0)","v":0},null,null,"2015/16"]
["2021/22",14,null,null,null,null,null,0,{"$f":"IF('Tapered AA Calculations'!AU43>0,IF(M25<>'Tapered AA Calculations'!AU43,1,0),0)","v":0},null,null,"Inputs prior to 09/07/15",0,null,"Tapered Annual Allowance Details",null,null,null,null,null,{"$f":"IF(AND(O21>0,O21<10000),\"WARNING - This is less than the minimum taper\",\"\")","v":""}]
["2022/23",15,"Added for 2022/23",null,null,0,null,{"$f":"IF($C$7>B19,1,0)","v":0},{"$f":"IF('Tapered AA Calculations'!BB43>0,IF(M26<>'Tapered AA Calculations'!BB43,1,0),0)","v":0},null,null,"Inputs on or after 09/07/15",0]
["2023/24",16,null,null,null,0,null,{"$f":"IF($C$7>B20,1,0)","v":0},{"$f":"IF('Tapered AA Calculations'!BP43>0,IF(M27<>'Tapered AA Calculations'!BP43,1,0),0)","v":0},null,null,{"$f":"A13","v":"2016/17"},0,null,0]
["2024/25",17,null,null,null,0,null,{"$f":"IF($C$7>B21,1,0)","v":0},{"$f":"IF('Tapered AA Calculations'!BP43>0,IF(M28<>'Tapered AA Calculations'!BP43,1,0),0)","v":0},null,null,{"$f":"A14","v":"2017/18"},0,null,0,null,null,null,null,null,{"$f":"IF(AND(O22>0,O22<10000),\"WARNING - This is less than the minimum taper\",\"\")","v":""}]
[null,null,null,null,null,0,null,null,null,null,null,"2018/19",0,null,0,null,"Input the taper figures here if known - or select relevant tab(s) to calculate."]
[null,null,null,null,null,0,null,null,null,null,null,"2019/20",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"2020/21",0,null,0,null,null,null,null,null,{"$f":"IF(AND(O23>0,O23<10000),\"WARNING - This is less than the minimum taper\",\"\")","v":""}]
[null,null,null,null,null,0,null,null,null,null,null,"2021/22",0,null,0]
[null,null,null,null,null,0,null,null,null,null,null,"2022/23",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"2023/24",0,null,0]
[null,null,null,null,null,0,null,null,null,null,null,"2024/25",0,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(O24>0,O24<4000),\"WARNING - This is less than the minimum taper\",\"\")","v":""}]
[null,null,null,null,null,0,null,null,null,null,null,null,"Summary Information"]
[null,null,null,null,null,0]
[null,null,null,null,null,0,null,null,null,null,null,null,null,null,"                  Existing Inputs",null,null,null,null,null,{"$f":"IF(AND(O25>0,O25<4000),\"WARNING - This is less than the minimum taper\",\"\")","v":""},null,null,null,null,null,null,"This is new for 2022/23"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Annual Allowance",null,null,{"$f":"'Carry Forward Full Workings'!U5","v":60000}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Inputs ",null,null,{"$f":"'Carry Forward Full Workings'!U13","v":0},{"$f":"IF('Tapered AA Calculations'!BP42>0,IF('Tapered AA Calculations'!BP43>=0,IF(M28='Tapered AA Calculations'!BP43,\"\",\"Pension inputs above do not equal pension inputs in the 2024/25 taper calculator\"),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Unused allowance from this year ",null,null,{"$f":"'Carry Forward Full Workings'!U115","v":60000},null,null,null,null,{"$f":"IF(AND(O26>0,O26<4000),\"WARNING - This is less than the minimum taper\",\"\")","v":""},null,null,null,null,null,null,"Testing comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tapered AA Calculations'!L42>0,IF('Tapered AA Calculations'!L43>=0,IF(M20='Tapered AA Calculations'!L43,\"\",\"Pension inputs above do not equal pension inputs in the 2016/17 taper calculator\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"These warnngs are not present in most of the taper tabs, and need to be added"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Carry Forward available from:",null,null,null,{"$f":"IF('Tapered AA Calculations'!S42>0,IF('Tapered AA Calculations'!S42>=0,IF(M21='Tapered AA Calculations'!S43,\"\",\"Pension inputs above do not equal pension inputs in the 2017/18 taper calculator\"),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tapered AA Calculations'!Z42>0,IF('Tapered AA Calculations'!Z43>=0,IF(M22='Tapered AA Calculations'!Z43,\"\",\"Pension inputs above do not equal pension inputs in the 2018/19 taper calculator\"),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L25","v":"2021/22"},null,{"$f":"'Carry Forward Full Workings'!U100","v":40000},null,{"$f":"IF('Tapered AA Calculations'!AG42>0,IF('Tapered AA Calculations'!AG43>=0,IF(M23='Tapered AA Calculations'!AG43,\"\",\"Pension inputs above do not equal pension inputs in the 2019/20 taper calculator\"),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L26","v":"2022/23"},null,{"$f":"'Carry Forward Full Workings'!U105","v":40000},null,{"$f":"IF('Tapered AA Calculations'!AN42>0,IF('Tapered AA Calculations'!AN43>=0,IF(M24='Tapered AA Calculations'!AN43,\"\",\"Pension inputs above do not equal pension inputs in the 2020/21 taper calculator\"),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L27","v":"2023/24"},null,{"$f":"'Carry Forward Full Workings'!U110","v":60000},{"$f":"SUM(O41:O43)","v":140000},{"$f":"IF('Tapered AA Calculations'!AU42>0,IF('Tapered AA Calculations'!AU43>=0,IF(M25='Tapered AA Calculations'!AU43,\"\",\"Pension inputs above do not equal pension inputs in the 2021/22 taper calculator\"),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tapered AA Calculations'!BB42>0,IF('Tapered AA Calculations'!BB43>=0,IF(M26='Tapered AA Calculations'!BB43,\"\",\"Pension inputs above do not equal pension inputs in the 2022/23 taper calculator\"),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Maximum Allowance Remaining This Year",null,null,{"$f":"P43+P37","v":200000},{"$f":"IF('Tapered AA Calculations'!BI42>0,IF('Tapered AA Calculations'!BI43>=0,IF(M27='Tapered AA Calculations'!BI43,\"\",\"Pension inputs above do not equal pension inputs in the 2023/24 taper calculator\"),\"\"),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Chargeable Amount",null,null,{"$f":"'Carry Forward Full Workings'!U21","v":0},{"$f":"IF(SUM('Carry Forward Full Workings'!G21:T21)>0,\"Please note there have been chargeable amounts in previous tax years\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"See Carry Forward Workings for summary or full calculations"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"This calculator is designed to give a general demonstration of how a client's pension contributions can determine any unused Annual Allowance; the client may be able to 'carry forward' unused allowance from the last three years to increase their limit for the current tax year. The Annual Allowance calculator takes in the details of the client's previous and expected contributions to their pension arrangements. It then works out if the client could be subject to an Annual Allowance charge; the amount of unused Annual Allowance including any carry forward opportunities.\n\n\nIt does not take into account all the possible individual circumstances that may impact on the tax position of the investment. It should not be taken as offering advice or any recommendation.\n\nThe default values presented on the tool, do not suggest any recommendation from M&G. The information in this modeller is based on our understanding as at March 2023 of current taxation, legislation and HM Revenue & Customs practice all of which is subject to change without notice."]

{"sheet":"Carry Forward Summary Workings","index":1,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[20,6,23,10],[23,0,23,3],[15,0,15,4],[21,0,21,4],[26,0,26,4]]}
["Annual Allowance Calculator - Summary Workings\nbuilt by M&G"]
[]
[null,{"$f":"'Pension Inputs'!A18","v":"2021/22"},{"$f":"'Pension Inputs'!A19","v":"2022/23"},{"$f":"'Pension Inputs'!A20","v":"2023/24"},{"$f":"'Pension Inputs'!A21","v":"2024/25"}]
[]
["Annual Allowance",{"$f":"'Carry Forward Full Workings'!R7","v":40000},{"$f":"'Carry Forward Full Workings'!S7","v":40000},{"$f":"'Carry Forward Full Workings'!T7","v":60000},{"$f":"'Carry Forward Full Workings'!U7","v":60000}]
[]
["Carry Forward",{"$f":"'Carry Forward Full Workings'!R9","v":120000},{"$f":"'Carry Forward Full Workings'!S9","v":120000},{"$f":"'Carry Forward Full Workings'!T9","v":120000},{"$f":"'Carry Forward Full Workings'!U9","v":140000}]
[]
["Maximum Allowance",{"$f":"SUM(B5:B7)","v":160000},{"$f":"SUM(C5:C7)","v":160000},{"$f":"SUM(D5:D7)","v":180000},{"$f":"SUM(E5:E7)","v":200000}]
[]
["Total Inputs",{"$f":"'Carry Forward Full Workings'!R13","v":0},{"$f":"'Carry Forward Full Workings'!S13","v":0},{"$f":"'Carry Forward Full Workings'!T13","v":0},{"$f":"'Carry Forward Full Workings'!U13","v":0}]
[]
["Unused",{"$f":"MAX(0,B5-B11)","v":40000},{"$f":"MAX(0,C5-C11)","v":40000},60000,60000]
[]
["Excess over standard Annual Allowance",{"$f":"'Carry Forward Full Workings'!R16","v":0},{"$f":"'Carry Forward Full Workings'!S16","v":0},{"$f":"'Carry Forward Full Workings'!T16","v":0},{"$f":"'Carry Forward Full Workings'!U16","v":0}]
[{"$f":"IF((B15+C15+D15)>0,\"As there is an excess in the previous three years it's recommended to check the full workings\",\"\")","v":""}]
[]
["Used by 2022/23",{"$f":"'Carry Forward Full Workings'!S99","v":0}]
["Used by 2023/24",{"$f":"'Carry Forward Full Workings'!T99","v":0},{"$f":"'Carry Forward Full Workings'!T104","v":0}]
["Used by 2024/25",{"$f":"'Carry Forward Full Workings'!U99","v":0},{"$f":"'Carry Forward Full Workings'!U104","v":0},{"$f":"'Carry Forward Full Workings'!U109","v":0}]
["Unused",{"$f":"MAX(0,B5-B11-B18-B19-B20)","v":40000},{"$f":"MAX(0,C5-C11-C18-C19-C20)","v":40000},{"$f":"MAX(0,D5-D11-D18-D19-D20)","v":60000},{"$f":"MAX(0,E5-E11-E18-E19-E20)","v":60000},null,"Check conditional formatting, for unused from three years ago and chargable amount warning. "]
[{"$f":"IF(B21>0,\"Please note - the unused allowance from three tax years ago will not be available next tax year\",\"\")","v":"Please note - the unused allowance from three tax years ago will not be available next tax year"}]
[]
["Total Allowance Remaining This Year",null,null,null,{"$f":"MAX(0,E9-E11)","v":200000}]
[]
["Chargeable Amount",{"$f":"IF('Carry Forward Full Workings'!R21>0,'Carry Forward Full Workings'!R21,\"\")","v":""},{"$f":"IF('Carry Forward Full Workings'!S21>0,'Carry Forward Full Workings'!S21,\"\")","v":""},{"$f":"IF('Carry Forward Full Workings'!T21>0,'Carry Forward Full Workings'!T21,\"\")","v":""},{"$f":"IF('Carry Forward Full Workings'!U21>0,'Carry Forward Full Workings'!U21,\"\")","v":""}]
[{"$f":"IF(SUM('Carry Forward Full Workings'!G21:Q21)>0,\"Please note there have been chargeable amounts in previous tax years\",\"\")","v":""}]

{"sheet":"Carry Forward Full Workings","index":2,"n_rows":137,"n_cols":24,"rows_kept":137,"cut":false,"hidden":false,"merged":[[0,5,0,6],[0,2,0,4],[132,4,132,7],[1,10,1,11],[24,10,24,11],[127,5,127,7],[129,3,129,4],[130,3,130,4],[20,3,21,5]]}
[null,null,"Annual Allowance Calculator -  Full Workings\nbuilt by M&G",null,null,{"$f":"'Pension Inputs'!O1","v":"Tax Year 2024/25"}]
[null,null,null,null,null,null,null,null,null,null,"2015/16"]
[null,null,null,1,2,3,4,5,6,7,8,8.5,9,10,11,12,13,14,15,16,17,null,{"$f":"'Pension Inputs'!C7","v":1},"Inputted tax year joined scheme"]
[null,null,null,{"$f":"'Pension Inputs'!$A4","v":"2008/09"},{"$f":"'Pension Inputs'!$A5","v":"2009/10"},{"$f":"'Pension Inputs'!$A6","v":"2010/11"},{"$f":"'Pension Inputs'!$A7","v":"2011/12"},{"$f":"'Pension Inputs'!$A8","v":"2012/13"},{"$f":"'Pension Inputs'!$A9","v":"2013/14"},{"$f":"'Pension Inputs'!$A10","v":"2014/15"},"Pre Alignment","Post Alignment",{"$f":"'Pension Inputs'!$A13","v":"2016/17"},{"$f":"'Pension Inputs'!$A14","v":"2017/18"},{"$f":"'Pension Inputs'!$A15","v":"2018/19"},{"$f":"'Pension Inputs'!$A16","v":"2019/20"},{"$f":"'Pension Inputs'!$A17","v":"2020/21"},{"$f":"'Pension Inputs'!$A18","v":"2021/22"},{"$f":"'Pension Inputs'!$A19","v":"2022/23"},{"$f":"'Pension Inputs'!$A20","v":"2023/24"},{"$f":"'Pension Inputs'!$A21","v":"2024/25"}]
[null,null,"Annual Allowance Limit",50000,50000,50000,50000,50000,50000,40000,80000,40000,{"$f":"IF('Pension Inputs'!O20>0,'Pension Inputs'!O20,'Tapered AA Calculations'!K35)","v":40000},{"$f":"IF('Pension Inputs'!O21>0,'Pension Inputs'!O21,'Tapered AA Calculations'!R35)","v":40000},{"$f":"IF('Pension Inputs'!O22>0,'Pension Inputs'!O22,'Tapered AA Calculations'!Y35)","v":40000},{"$f":"IF('Pension Inputs'!O23>0,'Pension Inputs'!O23,'Tapered AA Calculations'!AF35)","v":40000},{"$f":"IF('Pension Inputs'!O24>0,'Pension Inputs'!O24,'Tapered AA Calculations'!AM35)","v":40000},{"$f":"IF('Pension Inputs'!O25>0,'Pension Inputs'!O25,'Tapered AA Calculations'!AT35)","v":40000},{"$f":"IF('Pension Inputs'!O26>0,'Pension Inputs'!O26,'Tapered AA Calculations'!BA35)","v":40000},{"$f":"IF('Pension Inputs'!O27>0,'Pension Inputs'!O27,'Tapered AA Calculations'!BH35)","v":60000},{"$f":"IF('Pension Inputs'!O28>0,'Pension Inputs'!O28,'Tapered AA Calculations'!BO35)","v":60000}]
[]
[null,null,"Annual Allowance",{"$f":"IF(D3<'Pension Inputs'!$C$7,0,D5)","v":50000},{"$f":"IF(E3<'Pension Inputs'!$C$7,0,E5)","v":50000},{"$f":"IF(F3<'Pension Inputs'!$C$7,0,F5)","v":50000},{"$f":"IF(G3<'Pension Inputs'!$C$7,0,G5)","v":50000},{"$f":"IF(H3<'Pension Inputs'!$C$7,0,H5)","v":50000},{"$f":"IF(I3<'Pension Inputs'!$C$7,0,I5)","v":50000},{"$f":"IF(J3<'Pension Inputs'!$C$7,0,J5)","v":40000},{"$f":"IF(K3<'Pension Inputs'!$C$7,0,K5)","v":80000},{"$f":"IF(W3=L3,L5,0)","v":0},{"$f":"IF(M3<'Pension Inputs'!$C$7,0,M5)","v":40000},{"$f":"IF(N3<'Pension Inputs'!$C$7,0,N5)","v":40000},{"$f":"IF(O3<'Pension Inputs'!$C$7,0,O5)","v":40000},{"$f":"IF(P3<'Pension Inputs'!$C$7,0,P5)","v":40000},{"$f":"IF(Q3<'Pension Inputs'!$C$7,0,Q5)","v":40000},{"$f":"IF(R3<'Pension Inputs'!$C$7,0,R5)","v":40000},{"$f":"IF(S3<'Pension Inputs'!$C$7,0,S5)","v":40000},{"$f":"IF(T3<'Pension Inputs'!$C$7,0,T5)","v":60000},{"$f":"IF(U3<'Pension Inputs'!$C$7,0,U5)","v":60000}]
[]
[null,null,"Carry Forward",0,{"$f":"E28","v":50000},{"$f":"F28+F33","v":100000},{"$f":"G28+G33+G38","v":150000},{"$f":"H33+H38+H43","v":150000},{"$f":"I38+I43+I48","v":150000},{"$f":"J43+J48+J53","v":150000},{"$f":"K48+K53+K58","v":140000},{"$f":"L48+L53+L58+L63","v":180000},{"$f":"M53+M58+M63+M70","v":130000},{"$f":"N58+N63+N68+N73","v":120000},{"$f":"O78+O73+O68+O63","v":120000},{"$f":"P83+P78+P73","v":120000},{"$f":"Q88+Q83+Q78","v":120000},{"$f":"R93+R88+R83","v":120000},{"$f":"S98+S93+S88","v":120000},{"$f":"T103+T98+T93","v":120000},{"$f":"U108+U103+U98","v":140000}]
[]
[null,null,"Maximum Allowance","N/A","N/A","N/A",{"$f":"SUM(G7:G9)","v":200000},200000,200000,190000,220000,{"$f":"SUM(L7:L9)","v":180000},170000,160000,160000,160000,{"$f":"SUM(Q7:Q9)","v":160000},{"$f":"SUM(R7:R9)","v":160000},{"$f":"SUM(S7:S9)","v":160000},{"$f":"SUM(T7:T9)","v":180000},{"$f":"SUM(U7:U9)","v":200000}]
[]
[null,null,"Total Inputs (08/09, 09/10 & 10/11 inputs capped at £50,000)",{"$f":"IF(D3<W3,0,MIN(50000,'Pension Inputs'!M8))","v":0},{"$f":"IF(E3<W3,0,MIN(50000,'Pension Inputs'!M9))","v":0},{"$f":"IF(F3<W3,0,MIN(50000,'Pension Inputs'!M10))","v":0},{"$f":"IF(G3<W3,0,('Pension Inputs'!M12+'Pension Inputs'!M13))","v":0},{"$f":"IF(H3<W3,0,'Pension Inputs'!$M14)","v":0},{"$f":"IF(I3<W3,0,'Pension Inputs'!$M15)","v":0},{"$f":"IF(J3<W3,0,'Pension Inputs'!$M16)","v":0},{"$f":"IF(K3<W3,0,'Pension Inputs'!M18)","v":0},{"$f":"IF(L3<W3,0,'Pension Inputs'!M19)","v":0},{"$f":"IF(M3<W3,0,'Pension Inputs'!$M20)","v":0},{"$f":"IF(N3<W3,0,'Pension Inputs'!$M21)","v":0},{"$f":"IF(O3<W3,0,'Pension Inputs'!$M22)","v":0},{"$f":"IF(P3<W3,0,'Pension Inputs'!$M23)","v":0},{"$f":"IF(Q3<$W$3,0,'Pension Inputs'!$M24)","v":0},{"$f":"IF(R3<$W$3,0,'Pension Inputs'!$M25)","v":0},{"$f":"IF(S3<$W$3,0,'Pension Inputs'!$M26)","v":0},{"$f":"IF(T3<$W$3,0,'Pension Inputs'!$M27)","v":0},{"$f":"IF(U3<$W$3,0,'Pension Inputs'!$M28)","v":0}]
[]
[null,null,null,{"$f":"MIN(0,D7-D13)","v":0},{"$f":"MIN(0,E7-E13)","v":0},{"$f":"MIN(0,F7-F13)","v":0},{"$f":"H132*-1","v":0},{"$f":"MIN(0,H7-H13)","v":0},0,0,0,0,0,0,0,{"$f":"MIN(0,P7-P13)","v":0},0,0,0,0,0]
[null,null,"Excess over standard Annual Allowance",{"$f":"D15*-1","v":0},0,0,{"$f":"G15*-1","v":0},0,0,0,0,{"$f":"L15*-1","v":0},0,0,0,0,{"$f":"Q15*-1","v":0},{"$f":"R15*-1","v":0},{"$f":"S15*-1","v":0},{"$f":"T15*-1","v":0},{"$f":"U15*-1","v":0}]
[]
[null,null,"Chargeable Amount logic",null,null,null,{"$f":"IF(G21>0,1,0)","v":0},{"$f":"IF(H21>0,1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"In scheme (based on inputs)",{"$f":"IF(D3>=$W$3,\"YES\",IF(SUM($D$13:D13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(E3>=$W$3,\"YES\",IF(SUM($D$13:E13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(F3>=$W$3,\"YES\",IF(SUM($D$13:F13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(G3>=$W$3,\"YES\",IF(SUM($D$13:G13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(H3>=$W$3,\"YES\",IF(SUM($D$13:H13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(I3>=$W$3,\"YES\",IF(SUM($D$13:I13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(J3>=$W$3,\"YES\",IF(SUM($D$13:J13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(K3>=$W$3,\"YES\",IF(SUM($D$13:K13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(L3>=$W$3,\"YES\",IF(SUM($D$13:L13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(M3>=$W$3,\"YES\",IF(SUM($D$13:M13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(N3>=$W$3,\"YES\",IF(SUM($D$13:N13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(O3>=$W$3,\"YES\",IF(SUM($D$13:O13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(P3>=$W$3,\"YES\",IF(SUM($D$13:P13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(Q3>=$W$3,\"YES\",IF(SUM($D$13:Q13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(R3>=$W$3,\"YES\",IF(SUM($D$13:R13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(S3>=$W$3,\"YES\",IF(SUM($D$13:S13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(T3>=$W$3,\"YES\",IF(SUM($D$13:T13)>0,\"YES\",\"NO\"))","v":"YES"},{"$f":"IF(U3>=$W$3,\"YES\",IF(SUM($D$13:U13)>0,\"YES\",\"NO\"))","v":"YES"},null,{"$f":"COUNTIF(D19:K19,\"YES\")","v":8},">0 means they had nil allowance post, 0 means they joined after budget (assuming inputs OK)"]
[null,null,"Date joined scheme wrong (inputs before date selected) ",{"$f":"AND(D3<$W$3,D13>0)","v":false},{"$f":"AND(E3<$W$3,SUM($D$13:E13)>0)","v":false},{"$f":"AND(F3<$W$3,SUM($D$13:F13)>0)","v":false},{"$f":"AND(G3<$W$3,SUM($D$13:G13)>0)","v":false},{"$f":"AND(H3<$W$3,SUM($D$13:H13)>0)","v":false},{"$f":"AND(I3<$W$3,SUM($D$13:I13)>0)","v":false},{"$f":"AND(J3<$W$3,SUM($D$13:J13)>0)","v":false},{"$f":"AND(K3<$W$3,SUM($D$13:K13)>0)","v":false},{"$f":"AND(L3<$W$3,SUM($D$13:L13)>0)","v":false},{"$f":"AND(M3<$W$3,SUM($D$13:M13)>0)","v":false},{"$f":"AND(N3<$W$3,SUM($D$13:N13)>0)","v":false},null,{"$f":"AND(P3<$W$3,SUM($D$13:P13)>0)","v":false},{"$f":"AND(Q3<$W$3,SUM($D$13:Q13)>0)","v":false},{"$f":"AND(R3<$W$3,SUM($D$13:R13)>0)","v":false},{"$f":"AND(S3<$W$3,SUM($D$13:S13)>0)","v":false},{"$f":"AND(T3<$W$3,SUM($D$13:T13)>0)","v":false},{"$f":"AND(U3<$W$3,SUM($D$13:U13)>0)","v":false},null,{"$f":"COUNTIF(D20:T20,TRUE)","v":0},">0 means warning on summary page:"]
[null,null,"Chargeable Amount","Inputs are capped at £50,000",null,null,{"$f":"G41","v":0},{"$f":"H46","v":0},{"$f":"I51","v":0},{"$f":"J56","v":0},{"$f":"K61","v":0},{"$f":"L61","v":0},{"$f":"M71","v":0},{"$f":"N76","v":0},{"$f":"O81","v":0},{"$f":"P86","v":0},{"$f":"Q91","v":0},{"$f":"R96","v":0},{"$f":"S101","v":0},{"$f":"T106","v":0},{"$f":"U111","v":0},null,"Previous cargeable event logic",{"$f":"IF((SUM(G21:T21)>0),1,0)","v":0}]
[]
[null,null,"Carry Forward still available this year",null,null,null,{"$f":"G30+G35+G40","v":150000},{"$f":"H35+H40+H45","v":150000},{"$f":"I40+I45+I50","v":150000},{"$f":"J45+J50+J55","v":150000},{"$f":"K50+K55+K60+K65","v":180000},{"$f":"L50+L55+L60+L65","v":180000},{"$f":"M55+M60+M65+M70","v":130000},{"$f":"N60+N65+N70+N75","v":120000},{"$f":"O65+O70+O75+O80","v":120000},{"$f":"P85+P80+P75","v":120000},{"$f":"Q90+Q85+Q80","v":120000},{"$f":"R95+R90+R85","v":120000},{"$f":"S100+S95+S90","v":120000},{"$f":"T105+T100+T95","v":120000},{"$f":"U110+U115+U120","v":120000}]
[]
[null,null,"Carry Forward Calculations - Existing Inputs",null,null,null,null,null,null,null,{"$f":"K2","v":"2015/16"}]
[null,null,null,{"$f":"D4","v":"2008/09"},"2009/10","2010/11","2011/12","2012/13","2013/14","2014/15","Pre Alignment","Post Alignment","2016/17","2017/18","2018/19","2019/20","2020/21",{"$f":"R4","v":"2021/22"},"2022/23","2023/24","2024/25"]
[null,1,{"$f":"'Pension Inputs'!$A4","v":"2008/09"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,"Unused",{"$f":"D7","v":50000},{"$f":"D30","v":50000},{"$f":"E30","v":50000},{"$f":"F30","v":50000}]
[null,null,"Used up",{"$f":"MIN(D7,D13)","v":0},0,0,{"$f":"IF(G16=0,0,IF(G28-G16<0,G28,G16))","v":0}]
[null,null,"Available",{"$f":"MAX(0,D28-D29)","v":50000},{"$f":"MAX(0,E28-E29)","v":50000},{"$f":"MAX(0,F28-F29)","v":50000},{"$f":"MAX(0,G28-G29)","v":50000}]
[null,null,null,null,null,"Excess remaining",{"$f":"G16-G29","v":0},{"$f":"H16","v":0}]
[null,2,{"$f":"'Pension Inputs'!$A5","v":"2009/10"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2]
[null,null,{"$f":"C$28","v":"Unused"},null,{"$f":"E7","v":50000},{"$f":"E35","v":50000},{"$f":"F35","v":50000},{"$f":"G35","v":50000}]
[null,null,{"$f":"C$29","v":"Used up"},null,{"$f":"MIN(E7,E13)","v":0},0,{"$f":"IF(G16=0,0,IF(G33-G31<0,G33,G31))","v":0},{"$f":"IF(H16=0,0,IF(H33-H31<0,H33,H31))","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,{"$f":"E33-E34","v":50000},{"$f":"F33-F34","v":50000},{"$f":"G33-G34","v":50000},{"$f":"H33-H34","v":50000}]
[null,null,null,null,null,"Excess remaining",{"$f":"G31-G34","v":0},{"$f":"H31-H34","v":0},{"$f":"I16","v":0}]
[null,3,{"$f":"'Pension Inputs'!$A6","v":"2010/11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3]
[null,null,{"$f":"C$28","v":"Unused"},null,null,{"$f":"F7","v":50000},{"$f":"F40","v":50000},{"$f":"G40","v":50000},{"$f":"H40","v":50000}]
[null,null,{"$f":"C$29","v":"Used up"},null,null,{"$f":"MIN(F7,F13)","v":0},{"$f":"IF(G16=0,0,IF(G38-G36<0,G38,G36))","v":0},{"$f":"IF(H16=0,0,IF(H38-H36<0,H38,H36))","v":0},{"$f":"IF(I15=0,0,IF(((I15*-1)-I29-I34)>I38,I38,(I15*-1)-I29-I34))","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,null,{"$f":"F38-F39","v":50000},{"$f":"G38-G39","v":50000},{"$f":"H38-H39","v":50000},{"$f":"I38-I39","v":50000}]
[null,null,null,null,null,"Excess remaining",{"$f":"G36-G39","v":0},{"$f":"H36-H39","v":0},{"$f":"I36-I39","v":0},{"$f":"J16","v":0}]
[null,4,{"$f":"'Pension Inputs'!$A7","v":"2011/12"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,4]
[null,null,{"$f":"C$28","v":"Unused"},null,null,null,{"$f":"G7","v":50000},{"$f":"G45","v":50000},{"$f":"H45","v":50000},{"$f":"I45","v":50000}]
[null,null,{"$f":"C$29","v":"Used up"},null,null,null,{"$f":"MIN(G7,G13)","v":0},{"$f":"IF(H16=0,0,IF(H43-H41<0,H43,H41))","v":0},{"$f":"IF(I16=0,0,IF(I43-I41<0,I43,I41))","v":0},{"$f":"IF(J16=0,0,IF(J43-J41<0,J43,J41))","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,null,null,{"$f":"MAX(0,G43-G44)","v":50000},{"$f":"H43-H44","v":50000},{"$f":"I43-I44","v":50000},{"$f":"J43-J44","v":50000}]
[null,null,null,null,null,null,"Excess remaining",{"$f":"H41-H44","v":0},{"$f":"I41-I44","v":0},{"$f":"J41-J44","v":0},{"$f":"K16","v":0}]
[null,5,{"$f":"'Pension Inputs'!$A8","v":"2012/13"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5]
[null,null,{"$f":"C$28","v":"Unused"},null,null,null,null,{"$f":"H7","v":50000},{"$f":"H50","v":50000},{"$f":"I50","v":50000},{"$f":"J50","v":50000},{"$f":"K50","v":50000}]
[null,null,{"$f":"C$29","v":"Used up"},null,null,null,null,{"$f":"MIN(H7,H13)","v":0},{"$f":"IF(I16=0,0,IF(I48-I46<0,I48,I46))","v":0},{"$f":"IF(J16=0,0,IF(J48-J46<0,J48,J46))","v":0},{"$f":"IF(K16=0,0,IF(K48-K46<0,K48,K46))","v":0},{"$f":"IF(L66=0,0,IF(L48-L66<0,L48,L66))","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,null,null,null,{"$f":"H48-H49","v":50000},{"$f":"I48-I49","v":50000},{"$f":"J48-J49","v":50000},{"$f":"K48-K49","v":50000},{"$f":"L48-L49","v":50000}]
[null,null,null,null,null,null,null,"Excess remaining",{"$f":"I46-I49","v":0},{"$f":"J46-J49","v":0},{"$f":"K16-K49","v":0},{"$f":"L66-L49","v":0},{"$f":"M16","v":0}]
[null,6,{"$f":"'Pension Inputs'!$A9","v":"2013/14"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,6]
[null,null,{"$f":"C$28","v":"Unused"},null,null,null,null,null,{"$f":"I7","v":50000},{"$f":"I55","v":50000},{"$f":"J55","v":50000},{"$f":"K55","v":50000},{"$f":"L55","v":50000}]
[null,null,{"$f":"C$29","v":"Used up"},null,null,null,null,null,{"$f":"MIN(I7,I13)","v":0},{"$f":"IF(J16=0,0,IF(J53-J51<0,J53,J51))","v":0},{"$f":"IF(K16=0,0,IF(K53-K51<0,K53,K51))","v":0},{"$f":"IF(L51=0,0,IF(L53-L51<0,L53,L51))","v":0},{"$f":"IF(M16=0,0,IF(M53-M51<0,M53,M51))","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,null,null,null,null,{"$f":"I53-I54","v":50000},{"$f":"J53-J54","v":50000},{"$f":"K53-K54","v":50000},{"$f":"L53-L54","v":50000},{"$f":"M53-M54","v":50000}]
[null,null,null,null,null,null,null,null,"Excess remaining",{"$f":"J51-J54","v":0},{"$f":"K51-K54","v":0},{"$f":"L51-L54","v":0},{"$f":"M51-M54","v":0},{"$f":"N16","v":0}]
[null,7,{"$f":"'Pension Inputs'!$A10","v":"2014/15"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,7]
[null,null,{"$f":"C$28","v":"Unused"},null,null,null,null,null,null,{"$f":"J7","v":40000},{"$f":"J60","v":40000},{"$f":"K60","v":40000},{"$f":"L60","v":40000},{"$f":"M60","v":40000}]
[null,null,{"$f":"C$29","v":"Used up"},null,null,null,null,null,null,{"$f":"MIN(J7,J13)","v":0},{"$f":"IF(K16=0,0,IF(K58-K56<0,K58,K56))","v":0},{"$f":"IF(L16=0,0,IF(L58-L56<0,L58,L56))","v":0},{"$f":"IF(M16=0,0,IF(M58-M56<0,M58,M56))","v":0},{"$f":"IF(N16=0,0,IF(N58-N56<0,N58,N56))","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,null,null,null,null,null,{"$f":"J58-J59","v":40000},{"$f":"K58-K59","v":40000},{"$f":"L58-L59","v":40000},{"$f":"M58-M59","v":40000},{"$f":"N58-N59","v":40000}]
[null,null,null,null,null,null,null,null,null,"Excess remaining",{"$f":"K56-K59","v":0},{"$f":"L56-L59","v":0},{"$f":"M56-M59","v":0},{"$f":"N56-N59","v":0},{"$f":"O16","v":0}]
[null,8,{"$f":"'Pension Inputs'!$A11","v":"2015/16 (pre alignment)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,8]
[null,null,{"$f":"C$28","v":"Unused"},null,null,null,null,null,null,null,{"$f":"K7","v":80000},{"$f":"K65","v":40000},{"$f":"L65","v":40000},{"$f":"M65","v":40000},{"$f":"N65","v":40000}]
[null,null,{"$f":"C$29","v":"Used up"},null,null,null,null,null,null,null,{"$f":"MIN(K7,K13)","v":0},{"$f":"MIN(L63,L13)","v":0},{"$f":"IF(M16=0,0,IF(M63-M61<0,M63,M61))","v":0},{"$f":"IF(N16=0,0,IF(N63-N61<0,N63,N61))","v":0},{"$f":"IF(O16=0,0,IF(O63-O61<0,O63,O61))","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,null,null,null,null,null,null,{"$f":"MIN(K63-K64,40000)","v":40000},{"$f":"L63-L64","v":40000},{"$f":"M63-M64","v":40000},{"$f":"N63-N64","v":40000},{"$f":"O63-O64","v":40000}]
[null,null,null,null,null,null,null,null,null,null,"Excess remaining",{"$f":"L16-L64","v":0},{"$f":"M61-M64","v":0},{"$f":"N61-N64","v":0},{"$f":"O61-O64","v":0},{"$f":"P16","v":0}]
[null,null,{"$f":"'Pension Inputs'!$A12","v":"2015/16 (post alignment)"}]
[null,null,{"$f":"C$28","v":"Unused"},null,null,null,null,null,null,null,null,{"$f":"L7","v":0},{"$f":"L70","v":0},{"$f":"M70","v":0},{"$f":"N70","v":0}]
[null,null,{"$f":"C$29","v":"Used up"},null,null,null,null,null,null,null,null,{"$f":"MIN(L7,L13)","v":0},{"$f":"IF(M16=0,0,IF(M68-M66<0,M68,M66))","v":0},{"$f":"IF(N16=0,0,IF(N68-N66<0,N68,N66))","v":0},{"$f":"IF(O16=0,0,IF(O68-O66<0,O68,O66))","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,null,null,null,null,null,null,null,{"$f":"L68-L69","v":0},{"$f":"M68-M69","v":0},{"$f":"N68-N69","v":0},{"$f":"O68-O69","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Excess remaining",{"$f":"L16","v":0},{"$f":"M66-M69","v":0},{"$f":"N66-N69","v":0},{"$f":"O66-O69","v":0}]
[null,9,{"$f":"'Pension Inputs'!$A13","v":"2016/17"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,9]
[null,null,{"$f":"C$28","v":"Unused"},null,null,null,null,null,null,null,null,null,{"$f":"M7","v":40000},{"$f":"M75","v":40000},{"$f":"N75","v":40000},{"$f":"O75","v":40000}]
[null,null,{"$f":"C$29","v":"Used up"},null,null,null,null,null,null,null,null,null,{"$f":"MIN(M7,M13)","v":0},{"$f":"IF(N16=0,0,IF(N73-N71<0,N73,N71))","v":0},{"$f":"IF(O16=0,0,IF(O73-O71<0,O73,O71))","v":0},{"$f":"IF(P16=0,0,IF(P73-P66<0,P73,P66))","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,null,null,null,null,null,null,null,null,{"$f":"M73-M74","v":40000},{"$f":"N73-N74","v":40000},{"$f":"O73-O74","v":40000},{"$f":"P73-P74","v":40000}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Excess remaining",{"$f":"N71-N74","v":0},{"$f":"O71-O74","v":0},{"$f":"P66-P74","v":0},{"$f":"Q16","v":0}]
[null,10,{"$f":"'Pension Inputs'!$A14","v":"2017/18"}]
[null,null,{"$f":"C$28","v":"Unused"},null,null,null,null,null,null,null,null,null,null,{"$f":"N7","v":40000},{"$f":"N80","v":40000},{"$f":"O80","v":40000},{"$f":"P80","v":40000}]
[null,null,{"$f":"C$29","v":"Used up"},null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(N7,N13)","v":0},{"$f":"IF(O16=0,0,IF(O78-O76<0,O78,O76))","v":0},{"$f":"IF(P16=0,0,IF(P78-P76<0,P78,P76))","v":0},{"$f":"IF(Q16=0,0,IF(Q78-Q16<0,Q78,Q16))","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,null,null,null,null,null,null,null,null,null,{"$f":"N78-N79","v":40000},{"$f":"O78-O79","v":40000},{"$f":"P78-P79","v":40000},{"$f":"Q78-Q79","v":40000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Excess remaining",{"$f":"O76-O79","v":0},{"$f":"P76-P79","v":0},{"$f":"Q76-Q79","v":0},{"$f":"R16","v":0}]
[null,11,{"$f":"'Pension Inputs'!A15","v":"2018/19"}]
[null,null,{"$f":"C$28","v":"Unused"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"O7","v":40000},{"$f":"O85","v":40000},{"$f":"P85","v":40000},{"$f":"Q85","v":40000}]
[null,null,{"$f":"C$29","v":"Used up"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(O7,O13)","v":0},{"$f":"IF(P16=0,0,IF(P83-P81<0,P83,P81))","v":0},{"$f":"IF(Q16=0,0,IF(Q83-Q81<0,Q83,Q81))","v":0},{"$f":"IF(R16=0,0,IF(R83-R16<0,R83,R16))","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"O83-O84","v":40000},{"$f":"P83-P84","v":40000},{"$f":"Q83-Q84","v":40000},{"$f":"R83-R84","v":40000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excess remaining",{"$f":"P81-P84","v":0},{"$f":"Q81-Q84","v":0},{"$f":"R81-R84","v":0},{"$f":"S16","v":0}]
[null,null,{"$f":"'Pension Inputs'!A16","v":"2019/20"}]
[null,null,{"$f":"C$28","v":"Unused"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P7","v":40000},{"$f":"P90","v":40000},{"$f":"Q90","v":40000},{"$f":"R90","v":40000}]
[null,null,{"$f":"C$29","v":"Used up"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(P7,P13)","v":0},{"$f":"IF(Q16=0,0,IF(Q88-Q86<0,Q88,Q86))","v":0},{"$f":"IF(R16=0,0,IF(R88-R86<0,R88,R86))","v":0},{"$f":"IF(S16=0,0,IF(S88-S16<0,S88,S16))","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P88-P89","v":40000},{"$f":"Q88-Q89","v":40000},{"$f":"R88-R89","v":40000},{"$f":"S88-S89","v":40000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excess remaining",{"$f":"Q86-Q89","v":0},{"$f":"R86-R89","v":0},{"$f":"S86-S89","v":0},{"$f":"T16","v":0}]
[null,null,{"$f":"'Pension Inputs'!A17","v":"2020/21"}]
[null,null,{"$f":"C$28","v":"Unused"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q7","v":40000},{"$f":"Q95","v":40000},{"$f":"R95","v":40000},{"$f":"S95","v":40000}]
[null,null,{"$f":"C$29","v":"Used up"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(Q7,Q13)","v":0},{"$f":"IF(R16=0,0,IF(R93-R91<0,R93,R91))","v":0},{"$f":"IF(S16=0,0,IF(S93-S91<0,S93,S91))","v":0},{"$f":"IF(T16=0,0,IF(T93-T91<0,T93,T91))","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q93-Q94","v":40000},{"$f":"R93-R94","v":40000},{"$f":"S93-S94","v":40000},{"$f":"T93-T94","v":40000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excess remaining",{"$f":"R91-R94","v":0},{"$f":"S91-S94","v":0},{"$f":"T91-T94","v":0},{"$f":"U16","v":0}]
[null,null,{"$f":"'Pension Inputs'!A18","v":"2021/22"}]
[null,null,{"$f":"C$28","v":"Unused"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":40000},{"$f":"R100","v":40000},{"$f":"S100","v":40000},{"$f":"T100","v":40000}]
[null,null,{"$f":"C$29","v":"Used up"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(R7,R13)","v":0},{"$f":"IF(S16=0,0,IF(S98-S96<0,S98,S96))","v":0},{"$f":"IF(T16=0,0,IF(T98-T96<0,T98,T96))","v":0},{"$f":"IF(U16=0,0,IF(U98-U96<0,U98,U96))","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R98-R99","v":40000},{"$f":"S98-S99","v":40000},{"$f":"T98-T99","v":40000},{"$f":"U98-U99","v":40000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excess remaining",{"$f":"S96-S99","v":0},{"$f":"T96-T99","v":0},{"$f":"U96-U99","v":0}]
[null,null,{"$f":"'Pension Inputs'!A19","v":"2022/23"}]
[null,null,{"$f":"C$28","v":"Unused"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S7","v":40000},{"$f":"S105","v":40000},{"$f":"T105","v":40000}]
[null,null,{"$f":"C$29","v":"Used up"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(S7,S13)","v":0},{"$f":"IF(T16=0,0,IF(T103-T101<0,T103,T101))","v":0},{"$f":"IF(U16=0,0,IF(U103-U101<0,U103,U101))","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S103-S104","v":40000},{"$f":"T103-T104","v":40000},{"$f":"U103-U104","v":40000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excess remaining",{"$f":"T101-T104","v":0},{"$f":"U101-U104","v":0}]
[null,null,{"$f":"'Pension Inputs'!A20","v":"2023/24"}]
[null,null,{"$f":"C$28","v":"Unused"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T7","v":60000},{"$f":"T110","v":60000}]
[null,null,{"$f":"C$29","v":"Used up"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(T7,T13)","v":0},{"$f":"IF(U16=0,0,IF(U108-U106<0,U108,U106))","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T108-T109","v":60000},{"$f":"U108-U109","v":60000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U106-U109","v":0}]
[null,null,{"$f":"'Pension Inputs'!A21","v":"2024/25"}]
[null,null,{"$f":"C$28","v":"Unused"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U7","v":60000}]
[null,null,{"$f":"C$29","v":"Used up"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(U7,U13)","v":0}]
[null,null,{"$f":"C$30","v":"Available"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U113-U114","v":60000}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"2010 Straddling PIP calculation"]
[null,null,null,null,null,"Allowance","Actual","Excess"]
[null,null,null,"Pre 14/10/10",null,{"$f":"255000-(MIN(50000,G131))","v":255000},{"$f":"'Pension Inputs'!M12","v":0},{"$f":"MAX(0,G130-F130)","v":0}]
[null,null,null,"Post 14/10/10",null,{"$f":"G5","v":50000},{"$f":"'Pension Inputs'!M13","v":0},{"$f":"MAX(0,G131-F131)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H130:H131)","v":0}]
[null,null,null,null,"2015 Pre and Post Budget PIPs"]
[null,null,null,null,null,"Allowance","Actual","Excess"]
[null,null,null,null,"Pre 9/7/15",{"$f":"K7","v":80000},{"$f":"'Pension Inputs'!M18","v":0},{"$f":"MAX(0,G135-F135)","v":0}]
[null,null,null,null,"Post 9/7/15",{"$f":"IF(H135>0,0,MIN(40000,80000-G135))","v":40000},{"$f":"'Pension Inputs'!M19","v":0},{"$f":"MAX(0,G136-F136)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H135:H136)","v":0}]

{"sheet":"Tapered AA Calculations","index":3,"n_rows":43,"n_cols":68,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,63,2,67],[33,66,33,67],[34,66,34,67],[2,1,2,2],[2,56,2,60],[33,59,33,60],[34,59,34,60],[0,4,0,5],[2,42,2,46],[33,45,33,46],[34,45,34,46],[2,49,2,53],[33,52,33,53],[34,52,34,53],[2,28,2,32],[33,31,33,32],[34,31,34,32],[2,35,2,39],[33,38,33,39],[36,7,36,10],[29,4,36,4],[34,38,34,39],[2,14,2,18],[2,21,2,25],[34,10,34,11],[33,10,33,11],[33,17,33,18],[34,17,34,18],[33,24,33,25],[34,24,34,25],[2,7,2,11]]}
[null,null,null,null,"Tapered Annual Allowance Calculations\nbuilt by M&G",null,0]
[]
[null,"Please select the year (or years) that you need to do taper calculations for. ",null,null,"Instructions:\nInput relevant figures in white boxes. Tapered Allowance will be calculated where relevant.\nFor income definitions see Pensions Tax Manual - PTM057100",null,null,"2016/17 Tax Year",null,null,null,null,null,null,"2017/18 Tax Year",null,null,null,null,null,null,"2018/19 Tax Year",null,null,null,null,null,null,"2019/20 Tax Year",null,null,null,null,null,null,"2020/21 Tax Year",null,null,null,null,null,null,"2021/22 Tax Year",null,null,null,null,null,null,"2022/23 Tax Year",null,null,null,null,null,null,"2023/24 Tax Year",null,null,null,null,null,null,"2024/25 Tax Year"]
[]
[null,null,null,null,null,null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome",null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome",null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome",null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome",null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome",null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome",null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome",null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome",null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome"]
[]
[null,null,null,null,"Total Income",null,null,0,null,{"$f":"H7","v":0},null,{"$f":"H7","v":0},null,null,0,null,{"$f":"O7","v":0},null,{"$f":"O7","v":0},null,null,0,null,{"$f":"V7","v":0},null,{"$f":"V7","v":0},null,null,0,null,{"$f":"AC7","v":0},null,{"$f":"AC7","v":0},null,null,0,null,{"$f":"AJ7","v":0},null,{"$f":"AJ7","v":0},null,null,0,null,{"$f":"AQ7","v":0},null,{"$f":"AQ7","v":0},null,null,0,null,{"$f":"AX7","v":0},null,{"$f":"AX7","v":0},null,null,0,null,{"$f":"BE7","v":0},null,{"$f":"BE7","v":0},null,null,0,null,{"$f":"BL7","v":0},null,{"$f":"BL7","v":0}]
[null,null,null,null,"(please remember to deduct net pay contributions from this figure)",null,null,null,null,"-",null,"-",null,null,null,null,"-",null,"-",null,null,null,null,"-",null,"-",null,null,null,null,"-",null,"-",null,null,null,null,"-",null,"-",null,null,null,null,"-",null,"-",null,null,null,null,"-",null,"-",null,null,null,null,"-",null,"-",null,null,null,null,"-",null,"-"]
[]
[null,null,null,null,"Allowable Reliefs",null,null,0,null,{"$f":"H10","v":0},null,{"$f":"H10","v":0},null,null,0,null,{"$f":"O10","v":0},null,{"$f":"O10","v":0},null,null,0,null,{"$f":"V10","v":0},null,{"$f":"V10","v":0},null,null,0,null,{"$f":"AC10","v":0},null,{"$f":"AC10","v":0},null,null,0,null,{"$f":"AJ10","v":0},null,{"$f":"AJ10","v":0},null,null,0,null,{"$f":"AQ10","v":0},null,{"$f":"AQ10","v":0},null,null,0,null,{"$f":"AX10","v":0},null,{"$f":"AX10","v":0},null,null,0,null,{"$f":"BE10","v":0},null,{"$f":"BE10","v":0},null,null,0,null,{"$f":"BL10","v":0},null,{"$f":"BL10","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,"+",null,null,null,null,null,null,"+",null,null,null,null,null,null,"+",null,null,null,null,null,null,"+",null,null,null,null,null,null,"+",null,null,null,null,null,null,"+"]
[null,null,null,null,"Net Pay Contributions",null,null,0,null,{"$f":"H12","v":0},null,null,null,null,0,null,{"$f":"O12","v":0},null,null,null,null,0,null,{"$f":"V12","v":0},null,null,null,null,0,null,{"$f":"AC12","v":0},null,null,null,null,0,null,{"$f":"AJ12","v":0},null,null,null,null,0,null,{"$f":"AQ12","v":0},null,null,null,null,0,null,{"$f":"AX12","v":0},null,null,null,null,0,null,{"$f":"BE12","v":0},null,null,null,null,0,null,{"$f":"BL12","v":0}]
[null,null,null,null,"(including any s226 contributions)",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[]
[null,null,null,null,"Relief at Source contributions (Gross)",null,null,0,null,null,null,{"$f":"H15","v":0},null,null,0,null,null,null,{"$f":"O15","v":0},null,null,0,null,null,null,{"$f":"V15","v":0},null,null,0,null,null,null,{"$f":"AC15","v":0},null,null,0,null,null,null,{"$f":"AJ15","v":0},null,null,0,null,null,null,{"$f":"AQ15","v":0},null,null,0,null,null,null,{"$f":"AX15","v":0},null,null,0,null,null,null,{"$f":"BE15","v":0},null,null,0,null,null,null,{"$f":"BL15","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,"+",null,null,null,null,null,null,"+",null,null,null,null,null,null,"+",null,null,null,null,null,null,"+",null,null,null,null,null,null,"+",null,null,null,null,null,null,"+"]
[null,null,null,null,"Value of employer pension contributions"]
[null,null,null,null,"Employer Penson Contributions to Money Purchase",null,null,0,null,{"$f":"H18","v":0},null,null,null,null,0,null,{"$f":"O18","v":0},null,null,null,null,0,null,{"$f":"V18","v":0},null,null,null,null,0,null,{"$f":"AC18","v":0},null,null,null,null,0,null,{"$f":"AJ18","v":0},null,null,null,null,0,null,{"$f":"AQ18","v":0},null,null,null,null,0,null,{"$f":"AX18","v":0},null,null,null,null,0,null,{"$f":"BE18","v":0},null,null,null,null,0,null,{"$f":"BL18","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,"+",null,null,null,null,null,null,"+",null,null,null,null,null,null,"+",null,null,null,null,null,null,"+",null,null,null,null,null,null,"+",null,null,null,null,null,null,"+"]
[null,null,null,null,"Total DB Pension Input Amount for year",null,null,0,null,{"$f":"H20","v":0},null,null,null,null,0,null,{"$f":"O20","v":0},null,null,null,null,0,null,{"$f":"V20","v":0},null,null,null,null,0,null,{"$f":"AC20","v":0},null,null,null,null,0,null,{"$f":"AJ20","v":0},null,null,null,null,0,null,{"$f":"AQ20","v":0},null,null,null,null,0,null,{"$f":"AX20","v":0},null,null,null,null,0,null,{"$f":"BE20","v":0},null,null,null,null,0,null,{"$f":"BL20","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,"-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-",null,null,null,null,null,null,"-"]
[null,null,null,null,"Total gross employee contribution to DB  scheme(s) included above",null,null,0,null,{"$f":"H22","v":0},null,null,null,null,0,null,{"$f":"O22","v":0},null,null,null,null,0,null,{"$f":"V22","v":0},null,null,null,null,0,null,{"$f":"AC22","v":0},null,null,null,null,0,null,{"$f":"AJ22","v":0},null,null,null,null,0,null,{"$f":"AQ22","v":0},null,null,null,null,0,null,{"$f":"AX22","v":0},null,null,null,null,0,null,{"$f":"BE22","v":0},null,null,null,null,0,null,{"$f":"BL22","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,null,null,"+",null,null,null,null,null,null,"+",null,null,null,null,null,null,"+",null,null,null,null,null,null,"+",null,null,null,null,null,null,"+",null,null,null,null,null,null,"+"]
[null,null,null,null,"Employment Income given up post 09/07/15",null,null,0,null,null,null,{"$f":"H25","v":0},null,null,0,null,null,null,{"$f":"O25","v":0},null,null,0,null,null,null,{"$f":"V25","v":0},null,null,0,null,null,null,{"$f":"AC25","v":0},null,null,0,null,null,null,{"$f":"AJ25","v":0},null,null,0,null,null,null,{"$f":"AQ25","v":0},null,null,0,null,null,null,{"$f":"AX25","v":0},null,null,0,null,null,null,{"$f":"BE25","v":0},null,null,0,null,null,null,{"$f":"BL25","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,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,"Taxable Lump Sum Death Benefits (Gross Value)",null,null,0,null,{"$f":"H28","v":0},null,{"$f":"H28","v":0},null,null,0,null,{"$f":"O28","v":0},null,{"$f":"O28","v":0},null,null,0,null,{"$f":"V28","v":0},null,{"$f":"V28","v":0},null,null,0,null,{"$f":"AC28","v":0},null,{"$f":"AC28","v":0},null,null,0,null,{"$f":"AJ28","v":0},null,{"$f":"AJ28","v":0},null,null,0,null,{"$f":"AQ28","v":0},null,{"$f":"AQ28","v":0},null,null,0,null,{"$f":"AX28","v":0},null,{"$f":"AX28","v":0},null,null,0,null,{"$f":"BE28","v":0},null,{"$f":"BE28","v":0},null,null,9,null,{"$f":"BL28","v":9},null,{"$f":"BL28","v":9}]
[]
[null,null,null,null,"Warning, once you have calculated the remaining AA for the member be aware that any further contributions may change the tapered calculation. \n\nFor instance if the employer is planning to contribute the remaining AA for a member, the contribution they can make will be  two thirds of the remaining AA that has been calculated. ",null,null,"Totals",null,{"$f":"J7-J10+J12+(J18+J20-J22)-J28","v":0},null,{"$f":"L7-L10-L15+L25-L28","v":0},null,null,"Totals",null,{"$f":"Q7-Q10+Q12+(Q18+Q20-Q22)-Q28","v":0},null,{"$f":"S7-S10-S15+S25-S28","v":0},null,null,null,null,{"$f":"X7-X10+X12+(X18+X20-X22)-X28","v":0},null,{"$f":"Z7-Z10-Z15+Z25-Z28","v":0},null,null,null,null,{"$f":"AE7-AE10+AE12+(AE18+AE20-AE22)-AE28","v":0},null,{"$f":"AG7-AG10-AG15+AG25-AG28","v":0},null,null,null,null,{"$f":"AL7-AL10+AL12+(AL18+AL20-AL22)-AL28","v":0},null,{"$f":"AN7-AN10-AN15+AN25-AN28","v":0},null,null,null,null,{"$f":"AS7-AS10+AS12+(AS18+AS20-AS22)-AS28","v":0},null,{"$f":"AU7-AU10-AU15+AU25-AU28","v":0},null,null,null,null,{"$f":"AZ7-AZ10+AZ12+(AZ18+AZ20-AZ22)-AZ28","v":0},null,{"$f":"BB7-BB10-BB15+BB25-BB28","v":0},null,null,null,null,{"$f":"BG7-BG10+BG12+(BG18+BG20-BG22)-BG28","v":0},null,{"$f":"BI7-BI10-BI15+BI25-BI28","v":0},null,null,null,null,{"$f":"BN7-BN10+BN12+(BN18+BN20-BN22)-BN28","v":-9},null,{"$f":"BP7-BP10-BP15+BP25-BP28","v":-9}]
[]
[null,null,null,null,null,null,null,"Limit breached?",null,{"$f":"IF(J30>150002,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(L30>110000,\"Yes\",\"No\")","v":"No"},null,null,"Limit breached?",null,{"$f":"IF(Q30>150002,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(S30>110000,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(X30>150002,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(Z30>110000,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(AE30>150002,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AG30>110000,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(AL30>240002,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AN30>200000,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(AS30>240002,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AU30>200000,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(AZ30>240002,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(BB30>200000,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(BG30>260002,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(BI30>200000,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(BN30>260002,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(BP30>200000,\"Yes\",\"No\")","v":"No"}]
[]
[null,null,null,null,null,null,null,"Is the Taper Triggered?",null,null,{"$f":"IF((J32=\"YES\")*AND(L32=\"YES\"),\"Yes\",\"No\")","v":"No"},null,null,null,"Is the Taper Triggered?",null,null,{"$f":"IF((Q32=\"YES\")*AND(S32=\"YES\"),\"Yes\",\"No\")","v":"No"},null,null,null,"Is the Taper Triggered?",null,null,{"$f":"IF((X32=\"YES\")*AND(Z32=\"YES\"),\"Yes\",\"No\")","v":"No"},null,null,null,"Is the Taper Triggered?",null,null,{"$f":"IF((AE32=\"YES\")*AND(AG32=\"YES\"),\"Yes\",\"No\")","v":"No"},null,null,null,"Is the Taper Triggered?",null,null,{"$f":"IF((AL32=\"YES\")*AND(AN32=\"YES\"),\"Yes\",\"No\")","v":"No"},null,null,null,"Is the Taper Triggered?",null,null,{"$f":"IF((AS32=\"YES\")*AND(AU32=\"YES\"),\"Yes\",\"No\")","v":"No"},null,null,null,"Is the Taper Triggered?",null,null,{"$f":"IF((AZ32=\"YES\")*AND(BB32=\"YES\"),\"Yes\",\"No\")","v":"No"},null,null,null,"Is the Taper Triggered?",null,null,{"$f":"IF((BG32=\"YES\")*AND(BI32=\"YES\"),\"Yes\",\"No\")","v":"No"},null,null,null,"Is the Taper Triggered?",null,null,{"$f":"IF((BN32=\"YES\")*AND(BP32=\"YES\"),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,"Annual Allowance for 2016/17",null,null,{"$f":"ROUNDUP(MAX(10000,0,IF(K34=\"Yes\",40000-((J30-150000)/2),40000)),0)","v":40000},null,null,null,"Annual Allowance for 2017/18",null,null,{"$f":"ROUNDUP(MAX(10000,0,IF(R34=\"Yes\",40000-((Q30-150000)/2),40000)),0)","v":40000},null,null,null,"Annual Allowance for 2018/19",null,null,{"$f":"ROUNDUP(MAX(10000,0,IF(Y34=\"Yes\",40000-((X30-150000)/2),40000)),0)","v":40000},null,null,null,"Annual Allowance for 2019/20",null,null,{"$f":"ROUNDUP(MAX(10000,0,IF(AF34=\"Yes\",40000-((AE30-150000)/2),40000)),0)","v":40000},null,null,null,"Annual Allowance for 2020/21",null,null,{"$f":"ROUNDUP(MAX(4000,0,IF(AM34=\"Yes\",40000-((AL30-240000)/2),40000)),0)","v":40000},null,null,null,"Annual Allowance for 2021/22",null,null,{"$f":"ROUNDUP(MAX(4000,0,IF(AT34=\"Yes\",40000-((AS30-240000)/2),40000)),0)","v":40000},null,null,null,"Annual Allowance for 2022/23",null,null,{"$f":"ROUNDUP(MAX(4000,0,IF(BA34=\"Yes\",40000-((AZ30-240000)/2),40000)),0)","v":40000},null,null,null,"Annual Allowance for 2023/24",null,null,{"$f":"ROUNDUP(MAX(10000,0,IF(BH34=\"Yes\",60000-((BG30-260000)/2),60000)),0)","v":60000},null,null,null,"Annual Allowance for 2024/25",null,null,{"$f":"ROUNDUP(MAX(10000,0,IF(BO34=\"Yes\",60000-((BN30-260000)/2),60000)),0)","v":60000}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Total Inputs",null,{"$f":"H7+H10+H12+H15+H18+H20+H22+H25+H28","v":0},null,null,null,null,"Total Inputs",null,{"$f":"O7+O10+O12+O15+O18+O20+O22+O25+O28","v":0},null,null,null,null,"Total Inputs",null,{"$f":"V7+V10+V12+V15+V18+V20+V22+V25+V28","v":0},null,null,null,null,"Total Inputs",null,{"$f":"AC7+AC10+AC12+AC15+AC18+AC20+AC22+AC25+AC28","v":0},null,null,null,null,"Total Inputs",null,{"$f":"AJ7+AJ10+AJ12+AJ15+AJ18+AJ20+AJ22+AJ25+AJ28","v":0},null,null,null,null,"Total Inputs",null,{"$f":"AQ7+AQ10+AQ12+AQ15+AQ18+AQ20+AQ22+AQ25+AQ28","v":0},null,null,null,null,"Total Inputs",null,{"$f":"AX7+AX10+AX12+AX15+AX18+AX20+AX22+AX25+AX28","v":0},null,null,null,null,"Total Inputs",null,{"$f":"BE7+BE10+BE12+BE15+BE18+BE20+BE22+BE25+BE28","v":0},null,null,null,null,"Total Inputs",null,{"$f":"BL7+BL10+BL12+BL15+BL18+BL20+BL22+BL25+BL28","v":9}]
[null,null,null,null,null,null,null,null,null,"AA Input",null,{"$f":"(H12-H22)+H15+H18+H20","v":0},null,null,null,null,"AA Input",null,{"$f":"(O12-O22)+O15+O18+O20","v":0},null,null,null,null,"AA Input",null,{"$f":"(V12-V22)+V15+V18+V20","v":0},null,null,null,null,"AA Input",null,{"$f":"(AC12-AC22)+AC15+AC18+AC20","v":0},null,null,null,null,"AA Input",null,{"$f":"(AJ12-AJ22)+AJ15+AJ18+AJ20","v":0},null,null,null,null,"AA Input",null,{"$f":"(AQ12-AQ22)+AQ15+AQ18+AQ20","v":0},null,null,null,null,"AA Input",null,{"$f":"(AX12-AX22)+AX15+AX18+AX20","v":0},null,null,null,null,"AA Input",null,{"$f":"(BE12-BE22)+BE15+BE18+BE20","v":0},null,null,null,null,"AA Input",null,{"$f":"(BL12-BL22)+BL15+BL18+BL20","v":0}]

{"sheet":"Summary Print Friendly","index":4,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[15,0,15,4],[20,6,23,10],[21,0,21,4],[23,0,23,3],[26,0,26,4]]}
["Annual Allowance Calculator - Summary Workings\nbuilt by M&G"]
[]
[null,{"$f":"'Carry Forward Summary Workings'!B3","v":"2021/22"},{"$f":"'Carry Forward Summary Workings'!C3","v":"2022/23"},{"$f":"'Carry Forward Summary Workings'!D3","v":"2023/24"},{"$f":"'Carry Forward Summary Workings'!E3","v":"2024/25"}]
[]
["Annual Allowance",{"$f":"'Carry Forward Summary Workings'!B5","v":40000},{"$f":"'Carry Forward Summary Workings'!C5","v":40000},{"$f":"'Carry Forward Summary Workings'!D5","v":60000},{"$f":"'Carry Forward Summary Workings'!E5","v":60000}]
[]
["Carry Forward",{"$f":"'Carry Forward Summary Workings'!B7","v":120000},{"$f":"'Carry Forward Summary Workings'!C7","v":120000},{"$f":"'Carry Forward Summary Workings'!D7","v":120000},{"$f":"'Carry Forward Summary Workings'!E7","v":140000}]
[]
["Maximum Allowance",{"$f":"'Carry Forward Summary Workings'!B9","v":160000},{"$f":"'Carry Forward Summary Workings'!C9","v":160000},{"$f":"'Carry Forward Summary Workings'!D9","v":180000},{"$f":"'Carry Forward Summary Workings'!E9","v":200000}]
[]
["Total Inputs",{"$f":"'Carry Forward Summary Workings'!B11","v":0},{"$f":"'Carry Forward Summary Workings'!C11","v":0},{"$f":"'Carry Forward Summary Workings'!D11","v":0},{"$f":"'Carry Forward Summary Workings'!E11","v":0}]
[]
["Unused",{"$f":"'Carry Forward Summary Workings'!B13","v":40000},{"$f":"'Carry Forward Summary Workings'!C13","v":40000},{"$f":"'Carry Forward Summary Workings'!D13","v":60000},{"$f":"'Carry Forward Summary Workings'!E13","v":60000}]
[]
["Excess over standard Annual Allowance",{"$f":"'Carry Forward Summary Workings'!B15","v":0},{"$f":"'Carry Forward Summary Workings'!C15","v":0},{"$f":"'Carry Forward Summary Workings'!D15","v":0},{"$f":"'Carry Forward Summary Workings'!E15","v":0}]
[{"$f":"'Carry Forward Summary Workings'!$A$16","v":""}]
[]
[{"$f":"'Carry Forward Summary Workings'!A18","v":"Used by 2022/23"},{"$f":"'Carry Forward Summary Workings'!B18","v":0}]
[{"$f":"'Carry Forward Summary Workings'!A19","v":"Used by 2023/24"},{"$f":"'Carry Forward Summary Workings'!B19","v":0},{"$f":"'Carry Forward Summary Workings'!C19","v":0}]
[{"$f":"'Carry Forward Summary Workings'!A20","v":"Used by 2024/25"},{"$f":"'Carry Forward Summary Workings'!B20","v":0},{"$f":"'Carry Forward Summary Workings'!C20","v":0},{"$f":"'Carry Forward Summary Workings'!D20","v":0}]
["Unused",{"$f":"MAX(0,B5-B11-B18-B19-B20)","v":40000},{"$f":"MAX(0,C5-C11-C18-C19-C20)","v":40000},{"$f":"MAX(0,D5-D11-D18-D19-D20)","v":60000},{"$f":"MAX(0,E5-E11-E18-E19-E20)","v":60000},null,"Check conditional formatting, for unused from three years ago and chargable amount warning. "]
[{"$f":"'Carry Forward Summary Workings'!$A$22","v":"Please note - the unused allowance from three tax years ago will not be available next tax year"}]
[]
["Total Allowance Remaining This Year",null,null,null,{"$f":"'Carry Forward Summary Workings'!E24","v":200000}]
[]
["Chargeable Amount",{"$f":"'Carry Forward Summary Workings'!B26","v":""},{"$f":"'Carry Forward Summary Workings'!C26","v":""},{"$f":"'Carry Forward Summary Workings'!D26","v":""},{"$f":"'Carry Forward Summary Workings'!E26","v":""}]
[{"$f":"'Carry Forward Summary Workings'!$A$27","v":""}]

{"sheet":"Tapered Calcs - Print Friendly","index":5,"n_rows":43,"n_cols":68,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,63,2,67],[33,66,33,67],[34,66,34,67],[34,59,34,60],[34,24,34,25],[34,31,34,32],[34,38,34,39],[34,45,34,46],[34,52,34,53],[2,42,2,46],[2,49,2,53],[2,56,2,60],[33,38,33,39],[33,45,33,46],[2,35,2,39],[33,52,33,53],[33,59,33,60],[34,10,34,11],[34,17,34,18],[0,4,0,5],[2,7,2,11],[2,14,2,18],[2,21,2,25],[2,28,2,32],[29,4,36,4],[33,10,33,11],[33,17,33,18],[33,24,33,25],[33,31,33,32],[36,7,36,10]]}
[null,null,null,null,"Tapered Annual Allowance Calculations\nbuilt by M&G"]
[]
[null,null,null,null,{"$f":"'Tapered AA Calculations'!E3","v":"Instructions:\nInput relevant figures in white boxes. Tapered Allowance will be calculated where relevant.\nFor income definitions see Pensions Tax Manual - PTM057100"},null,null,"2016/17 Tax Year",null,null,null,null,null,null,"2017/18 Tax Year",null,null,null,null,null,null,"2018/19 Tax Year",null,null,null,null,null,null,"2019/20 Tax Year",null,null,null,null,null,null,"2020/21 Tax Year",null,null,null,null,null,null,"2021/22 Tax Year",null,null,null,null,null,null,"2022/23 Tax Year",null,null,null,null,null,null,"2023/24 Tax Year",null,null,null,null,null,null,"2024/25 Tax Year"]
[]
[null,null,null,null,null,null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome",null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome",null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome",null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome",null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome",null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome",null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome",null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome",null,null,null,null,"Adjusted \nIncome",null,"Threshold\nIncome"]
[]
[null,null,null,null,{"$f":"'Tapered AA Calculations'!E7","v":"Total Income"},null,null,{"$f":"'Tapered AA Calculations'!H7","v":0},null,{"$f":"'Tapered AA Calculations'!J7","v":0},null,{"$f":"'Tapered AA Calculations'!L7","v":0},null,null,{"$f":"'Tapered AA Calculations'!O7","v":0},null,{"$f":"'Tapered AA Calculations'!Q7","v":0},null,{"$f":"'Tapered AA Calculations'!S7","v":0},null,null,{"$f":"'Tapered AA Calculations'!V7","v":0},null,{"$f":"'Tapered AA Calculations'!X7","v":0},null,{"$f":"'Tapered AA Calculations'!Z7","v":0},null,null,{"$f":"'Tapered AA Calculations'!AC7","v":0},null,{"$f":"'Tapered AA Calculations'!AE7","v":0},null,{"$f":"'Tapered AA Calculations'!AG7","v":0},null,null,{"$f":"'Tapered AA Calculations'!AJ7","v":0},null,{"$f":"'Tapered AA Calculations'!AL7","v":0},null,{"$f":"'Tapered AA Calculations'!AN7","v":0},null,null,{"$f":"'Tapered AA Calculations'!AQ7","v":0},null,{"$f":"'Tapered AA Calculations'!AS7","v":0},null,{"$f":"'Tapered AA Calculations'!AU7","v":0},null,null,{"$f":"'Tapered AA Calculations'!AX7","v":0},null,{"$f":"'Tapered AA Calculations'!AZ7","v":0},null,{"$f":"'Tapered AA Calculations'!BB7","v":0},null,null,{"$f":"'Tapered AA Calculations'!BE7","v":0},null,{"$f":"'Tapered AA Calculations'!BG7","v":0},null,{"$f":"'Tapered AA Calculations'!BI7","v":0},null,null,{"$f":"'Tapered AA Calculations'!BL7","v":0},null,{"$f":"'Tapered AA Calculations'!BN7","v":0},null,{"$f":"'Tapered AA Calculations'!BP7","v":0}]
[null,null,null,null,{"$f":"'Tapered AA Calculations'!E8","v":"(please remember to deduct net pay contributions from this figure)"},null,null,null,null,{"$f":"'Tapered AA Calculations'!J8","v":"-"},null,{"$f":"'Tapered AA Calculations'!L8","v":"-"},null,null,null,null,{"$f":"'Tapered AA Calculations'!Q8","v":"-"},null,{"$f":"'Tapered AA Calculations'!S8","v":"-"},null,null,null,null,{"$f":"'Tapered AA Calculations'!X8","v":"-"},null,{"$f":"'Tapered AA Calculations'!Z8","v":"-"},null,null,null,null,{"$f":"'Tapered AA Calculations'!AE8","v":"-"},null,{"$f":"'Tapered AA Calculations'!AG8","v":"-"},null,null,null,null,{"$f":"'Tapered AA Calculations'!AL8","v":"-"},null,{"$f":"'Tapered AA Calculations'!AN8","v":"-"},null,null,null,null,{"$f":"'Tapered AA Calculations'!AS8","v":"-"},null,{"$f":"'Tapered AA Calculations'!AU8","v":"-"},null,null,null,null,{"$f":"'Tapered AA Calculations'!AZ8","v":"-"},null,{"$f":"'Tapered AA Calculations'!BB8","v":"-"},null,null,null,null,{"$f":"'Tapered AA Calculations'!BG8","v":"-"},null,{"$f":"'Tapered AA Calculations'!BI8","v":"-"},null,null,null,null,{"$f":"'Tapered AA Calculations'!BN8","v":"-"},null,{"$f":"'Tapered AA Calculations'!BP8","v":"-"}]
[]
[null,null,null,null,{"$f":"'Tapered AA Calculations'!E10","v":"Allowable Reliefs"},null,null,{"$f":"'Tapered AA Calculations'!H10","v":0},null,{"$f":"'Tapered AA Calculations'!J10","v":0},null,{"$f":"'Tapered AA Calculations'!L10","v":0},null,null,{"$f":"'Tapered AA Calculations'!O10","v":0},null,{"$f":"'Tapered AA Calculations'!Q10","v":0},null,{"$f":"'Tapered AA Calculations'!S10","v":0},null,null,{"$f":"'Tapered AA Calculations'!V10","v":0},null,{"$f":"'Tapered AA Calculations'!X10","v":0},null,{"$f":"'Tapered AA Calculations'!Z10","v":0},null,null,{"$f":"'Tapered AA Calculations'!AC10","v":0},null,{"$f":"'Tapered AA Calculations'!AE10","v":0},null,{"$f":"'Tapered AA Calculations'!AG10","v":0},null,null,{"$f":"'Tapered AA Calculations'!AJ10","v":0},null,{"$f":"'Tapered AA Calculations'!AL10","v":0},null,{"$f":"'Tapered AA Calculations'!AN10","v":0},null,null,{"$f":"'Tapered AA Calculations'!AQ10","v":0},null,{"$f":"'Tapered AA Calculations'!AS10","v":0},null,{"$f":"'Tapered AA Calculations'!AU10","v":0},null,null,{"$f":"'Tapered AA Calculations'!AX10","v":0},null,{"$f":"'Tapered AA Calculations'!AZ10","v":0},null,{"$f":"'Tapered AA Calculations'!BB10","v":0},null,null,{"$f":"'Tapered AA Calculations'!BE10","v":0},null,{"$f":"'Tapered AA Calculations'!BG10","v":0},null,{"$f":"'Tapered AA Calculations'!BI10","v":0},null,null,{"$f":"'Tapered AA Calculations'!BL10","v":0},null,{"$f":"'Tapered AA Calculations'!BN10","v":0},null,{"$f":"'Tapered AA Calculations'!BP10","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!J11","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!Q11","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!X11","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AE11","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AL11","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AS11","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AZ11","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!BG11","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!BN11","v":"+"}]
[null,null,null,null,{"$f":"'Tapered AA Calculations'!E12","v":"Net Pay Contributions"},null,null,{"$f":"'Tapered AA Calculations'!H12","v":0},null,{"$f":"'Tapered AA Calculations'!J12","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!O12","v":0},null,{"$f":"'Tapered AA Calculations'!Q12","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!V12","v":0},null,{"$f":"'Tapered AA Calculations'!X12","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AC12","v":0},null,{"$f":"'Tapered AA Calculations'!AE12","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AJ12","v":0},null,{"$f":"'Tapered AA Calculations'!AL12","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AQ12","v":0},null,{"$f":"'Tapered AA Calculations'!AS12","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AX12","v":0},null,{"$f":"'Tapered AA Calculations'!AZ12","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!BE12","v":0},null,{"$f":"'Tapered AA Calculations'!BG12","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!BL12","v":0},null,{"$f":"'Tapered AA Calculations'!BN12","v":0}]
[null,null,null,null,{"$f":"'Tapered AA Calculations'!E13","v":"(including any s226 contributions)"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!L13","v":"-"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!S13","v":"-"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!Z13","v":"-"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AG13","v":"-"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AN13","v":"-"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AU13","v":"-"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!BB13","v":"-"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!BI13","v":"-"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!BP13","v":"-"}]
[]
[null,null,null,null,{"$f":"'Tapered AA Calculations'!E15","v":"Relief at Source contributions (Gross)"},null,null,{"$f":"'Tapered AA Calculations'!H15","v":0},null,{"$f":"'Tapered AA Calculations'!J15","v":0},null,{"$f":"'Tapered AA Calculations'!L15","v":0},null,null,{"$f":"'Tapered AA Calculations'!O15","v":0},null,{"$f":"'Tapered AA Calculations'!Q15","v":0},null,{"$f":"'Tapered AA Calculations'!S15","v":0},null,null,{"$f":"'Tapered AA Calculations'!V15","v":0},null,{"$f":"'Tapered AA Calculations'!X15","v":0},null,{"$f":"'Tapered AA Calculations'!Z15","v":0},null,null,{"$f":"'Tapered AA Calculations'!AC15","v":0},null,{"$f":"'Tapered AA Calculations'!AE15","v":0},null,{"$f":"'Tapered AA Calculations'!AG15","v":0},null,null,{"$f":"'Tapered AA Calculations'!AJ15","v":0},null,{"$f":"'Tapered AA Calculations'!AL15","v":0},null,{"$f":"'Tapered AA Calculations'!AN15","v":0},null,null,{"$f":"'Tapered AA Calculations'!AQ15","v":0},null,{"$f":"'Tapered AA Calculations'!AS15","v":0},null,{"$f":"'Tapered AA Calculations'!AU15","v":0},null,null,{"$f":"'Tapered AA Calculations'!AX15","v":0},null,{"$f":"'Tapered AA Calculations'!AZ15","v":0},null,{"$f":"'Tapered AA Calculations'!BB15","v":0},null,null,{"$f":"'Tapered AA Calculations'!BE15","v":0},null,{"$f":"'Tapered AA Calculations'!BG15","v":0},null,{"$f":"'Tapered AA Calculations'!BI15","v":0},null,null,{"$f":"'Tapered AA Calculations'!BL15","v":0},null,{"$f":"'Tapered AA Calculations'!BN15","v":0},null,{"$f":"'Tapered AA Calculations'!BP15","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!J16","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!Q16","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!X16","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AE16","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AL16","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AS16","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AZ16","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!BG16","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!BN16","v":"+"}]
[null,null,null,null,{"$f":"'Tapered AA Calculations'!E17","v":"Value of employer pension contributions"}]
[null,null,null,null,{"$f":"'Tapered AA Calculations'!E18","v":"Employer Penson Contributions to Money Purchase"},null,null,{"$f":"'Tapered AA Calculations'!H18","v":0},null,{"$f":"'Tapered AA Calculations'!J18","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!O18","v":0},null,{"$f":"'Tapered AA Calculations'!Q18","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!V18","v":0},null,{"$f":"'Tapered AA Calculations'!X18","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AC18","v":0},null,{"$f":"'Tapered AA Calculations'!AE18","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AJ18","v":0},null,{"$f":"'Tapered AA Calculations'!AL18","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AQ18","v":0},null,{"$f":"'Tapered AA Calculations'!AS18","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AX18","v":0},null,{"$f":"'Tapered AA Calculations'!AZ18","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!BE18","v":0},null,{"$f":"'Tapered AA Calculations'!BG18","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!BL18","v":0},null,{"$f":"'Tapered AA Calculations'!BN18","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!J19","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!Q19","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!X19","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AE19","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AL19","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AS19","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AZ19","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!BG19","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!BN19","v":"+"}]
[null,null,null,null,{"$f":"'Tapered AA Calculations'!E20","v":"Total DB Pension Input Amount for year"},null,null,{"$f":"'Tapered AA Calculations'!H20","v":0},null,{"$f":"'Tapered AA Calculations'!J20","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!O20","v":0},null,{"$f":"'Tapered AA Calculations'!Q20","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!V20","v":0},null,{"$f":"'Tapered AA Calculations'!X20","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AC20","v":0},null,{"$f":"'Tapered AA Calculations'!AE20","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AJ20","v":0},null,{"$f":"'Tapered AA Calculations'!AL20","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AQ20","v":0},null,{"$f":"'Tapered AA Calculations'!AS20","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AX20","v":0},null,{"$f":"'Tapered AA Calculations'!AZ20","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!BE20","v":0},null,{"$f":"'Tapered AA Calculations'!BG20","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!BL20","v":0},null,{"$f":"'Tapered AA Calculations'!BN20","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!J21","v":"-"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!Q21","v":"-"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!X21","v":"-"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AE21","v":"-"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AL21","v":"-"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AS21","v":"-"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AZ21","v":"-"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!BG21","v":"-"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!BN21","v":"-"}]
[null,null,null,null,{"$f":"'Tapered AA Calculations'!E22","v":"Total gross employee contribution to DB  scheme(s) included above"},null,null,{"$f":"'Tapered AA Calculations'!H22","v":0},null,{"$f":"'Tapered AA Calculations'!J22","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!O22","v":0},null,{"$f":"'Tapered AA Calculations'!Q22","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!V22","v":0},null,{"$f":"'Tapered AA Calculations'!X22","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AC22","v":0},null,{"$f":"'Tapered AA Calculations'!AE22","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AJ22","v":0},null,{"$f":"'Tapered AA Calculations'!AL22","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AQ22","v":0},null,{"$f":"'Tapered AA Calculations'!AS22","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AX22","v":0},null,{"$f":"'Tapered AA Calculations'!AZ22","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!BE22","v":0},null,{"$f":"'Tapered AA Calculations'!BG22","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!BL22","v":0},null,{"$f":"'Tapered AA Calculations'!BN22","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!L24","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!S24","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!Z24","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AG24","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AN24","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!AU24","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!BB24","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!BI24","v":"+"},null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!BP24","v":"+"}]
[null,null,null,null,{"$f":"'Tapered AA Calculations'!E25","v":"Employment Income given up post 09/07/15"},null,null,{"$f":"'Tapered AA Calculations'!H25","v":0},null,{"$f":"'Tapered AA Calculations'!J25","v":0},null,{"$f":"'Tapered AA Calculations'!L25","v":0},null,null,{"$f":"'Tapered AA Calculations'!O25","v":0},null,{"$f":"'Tapered AA Calculations'!Q25","v":0},null,{"$f":"'Tapered AA Calculations'!S25","v":0},null,null,{"$f":"'Tapered AA Calculations'!V25","v":0},null,{"$f":"'Tapered AA Calculations'!X25","v":0},null,{"$f":"'Tapered AA Calculations'!Z25","v":0},null,null,{"$f":"'Tapered AA Calculations'!AC25","v":0},null,{"$f":"'Tapered AA Calculations'!AE25","v":0},null,{"$f":"'Tapered AA Calculations'!AG25","v":0},null,null,{"$f":"'Tapered AA Calculations'!AJ25","v":0},null,{"$f":"'Tapered AA Calculations'!AL25","v":0},null,{"$f":"'Tapered AA Calculations'!AN25","v":0},null,null,{"$f":"'Tapered AA Calculations'!AQ25","v":0},null,{"$f":"'Tapered AA Calculations'!AS25","v":0},null,{"$f":"'Tapered AA Calculations'!AU25","v":0},null,null,{"$f":"'Tapered AA Calculations'!AX25","v":0},null,{"$f":"'Tapered AA Calculations'!AZ25","v":0},null,{"$f":"'Tapered AA Calculations'!BB25","v":0},null,null,{"$f":"'Tapered AA Calculations'!BE25","v":0},null,{"$f":"'Tapered AA Calculations'!BG25","v":0},null,{"$f":"'Tapered AA Calculations'!BI25","v":0},null,null,{"$f":"'Tapered AA Calculations'!BL25","v":0},null,{"$f":"'Tapered AA Calculations'!BN25","v":0},null,{"$f":"'Tapered AA Calculations'!BP25","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!J26","v":"-"},null,{"$f":"'Tapered AA Calculations'!L26","v":"-"},null,null,null,null,{"$f":"'Tapered AA Calculations'!Q26","v":"-"},null,{"$f":"'Tapered AA Calculations'!S26","v":"-"},null,null,null,null,{"$f":"'Tapered AA Calculations'!X26","v":"-"},null,{"$f":"'Tapered AA Calculations'!Z26","v":"-"},null,null,null,null,{"$f":"'Tapered AA Calculations'!AE26","v":"-"},null,{"$f":"'Tapered AA Calculations'!AG26","v":"-"},null,null,null,null,{"$f":"'Tapered AA Calculations'!AL26","v":"-"},null,{"$f":"'Tapered AA Calculations'!AN26","v":"-"},null,null,null,null,{"$f":"'Tapered AA Calculations'!AS26","v":"-"},null,{"$f":"'Tapered AA Calculations'!AU26","v":"-"},null,null,null,null,{"$f":"'Tapered AA Calculations'!AZ26","v":"-"},null,{"$f":"'Tapered AA Calculations'!BB26","v":"-"},null,null,null,null,{"$f":"'Tapered AA Calculations'!BG26","v":"-"},null,{"$f":"'Tapered AA Calculations'!BI26","v":"-"},null,null,null,null,{"$f":"'Tapered AA Calculations'!BN26","v":"-"},null,{"$f":"'Tapered AA Calculations'!BP26","v":"-"}]
[]
[null,null,null,null,{"$f":"'Tapered AA Calculations'!E28","v":"Taxable Lump Sum Death Benefits (Gross Value)"},null,null,{"$f":"'Tapered AA Calculations'!H28","v":0},null,{"$f":"'Tapered AA Calculations'!J28","v":0},null,{"$f":"'Tapered AA Calculations'!L28","v":0},null,null,{"$f":"'Tapered AA Calculations'!O28","v":0},null,{"$f":"'Tapered AA Calculations'!Q28","v":0},null,{"$f":"'Tapered AA Calculations'!S28","v":0},null,null,{"$f":"'Tapered AA Calculations'!V28","v":0},null,{"$f":"'Tapered AA Calculations'!X28","v":0},null,{"$f":"'Tapered AA Calculations'!Z28","v":0},null,null,{"$f":"'Tapered AA Calculations'!AC28","v":0},null,{"$f":"'Tapered AA Calculations'!AE28","v":0},null,{"$f":"'Tapered AA Calculations'!AG28","v":0},null,null,{"$f":"'Tapered AA Calculations'!AJ28","v":0},null,{"$f":"'Tapered AA Calculations'!AL28","v":0},null,{"$f":"'Tapered AA Calculations'!AN28","v":0},null,null,{"$f":"'Tapered AA Calculations'!AQ28","v":0},null,{"$f":"'Tapered AA Calculations'!AS28","v":0},null,{"$f":"'Tapered AA Calculations'!AU28","v":0},null,null,{"$f":"'Tapered AA Calculations'!AX28","v":0},null,{"$f":"'Tapered AA Calculations'!AZ28","v":0},null,{"$f":"'Tapered AA Calculations'!BB28","v":0},null,null,{"$f":"'Tapered AA Calculations'!BE28","v":0},null,{"$f":"'Tapered AA Calculations'!BG28","v":0},null,{"$f":"'Tapered AA Calculations'!BI28","v":0},null,null,{"$f":"'Tapered AA Calculations'!BL28","v":9},null,{"$f":"'Tapered AA Calculations'!BN28","v":9},null,{"$f":"'Tapered AA Calculations'!BP28","v":9}]
[]
[null,null,null,null,{"$f":"'Tapered AA Calculations'!E30","v":"Warning, once you have calculated the remaining AA for the member be aware that any further contributions may change the tapered calculation. \n\nFor instance if the employer is planning to contribute the remaining AA for a member, the contribution they can make will be  two thirds of the remaining AA that has been calculated. "},null,null,"Totals",null,{"$f":"'Tapered AA Calculations'!J30","v":0},null,{"$f":"'Tapered AA Calculations'!L30","v":0},null,null,"Totals",null,{"$f":"'Tapered AA Calculations'!Q30","v":0},null,{"$f":"'Tapered AA Calculations'!S30","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!X30","v":0},null,{"$f":"'Tapered AA Calculations'!Z30","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AE30","v":0},null,{"$f":"'Tapered AA Calculations'!AG30","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AL30","v":0},null,{"$f":"'Tapered AA Calculations'!AN30","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AS30","v":0},null,{"$f":"'Tapered AA Calculations'!AU30","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!AZ30","v":0},null,{"$f":"'Tapered AA Calculations'!BB30","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!BG30","v":0},null,{"$f":"'Tapered AA Calculations'!BI30","v":0},null,null,null,null,{"$f":"'Tapered AA Calculations'!BN30","v":-9},null,{"$f":"'Tapered AA Calculations'!BP30","v":-9}]
[]
[null,null,null,null,null,null,null,"Limit breached?",null,{"$f":"'Tapered AA Calculations'!J32","v":"No"},null,{"$f":"'Tapered AA Calculations'!L32","v":"No"},null,null,"Limit breached?",null,{"$f":"'Tapered AA Calculations'!Q32","v":"No"},null,{"$f":"'Tapered AA Calculations'!S32","v":"No"},null,null,null,null,{"$f":"'Tapered AA Calculations'!X32","v":"No"},null,{"$f":"'Tapered AA Calculations'!Z32","v":"No"},null,null,null,null,{"$f":"'Tapered AA Calculations'!AE32","v":"No"},null,{"$f":"'Tapered AA Calculations'!AG32","v":"No"},null,null,null,null,{"$f":"'Tapered AA Calculations'!AL32","v":"No"},null,{"$f":"'Tapered AA Calculations'!AN32","v":"No"},null,null,null,null,{"$f":"'Tapered AA Calculations'!AS32","v":"No"},null,{"$f":"'Tapered AA Calculations'!AU32","v":"No"},null,null,null,null,{"$f":"'Tapered AA Calculations'!AZ32","v":"No"},null,{"$f":"'Tapered AA Calculations'!BB32","v":"No"},null,null,null,null,{"$f":"'Tapered AA Calculations'!BG32","v":"No"},null,{"$f":"'Tapered AA Calculations'!BI32","v":"No"},null,null,null,null,{"$f":"'Tapered AA Calculations'!BN32","v":"No"},null,{"$f":"'Tapered AA Calculations'!BP32","v":"No"}]
[]
[null,null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!H34","v":"Is the Taper Triggered?"},null,null,{"$f":"'Tapered AA Calculations'!K34","v":"No"},null,null,null,{"$f":"'Tapered AA Calculations'!O34","v":"Is the Taper Triggered?"},null,null,{"$f":"'Tapered AA Calculations'!R34","v":"No"},null,null,null,{"$f":"'Tapered AA Calculations'!V34","v":"Is the Taper Triggered?"},null,null,{"$f":"'Tapered AA Calculations'!Y34","v":"No"},null,null,null,{"$f":"'Tapered AA Calculations'!AC34","v":"Is the Taper Triggered?"},null,null,{"$f":"'Tapered AA Calculations'!AF34","v":"No"},null,null,null,{"$f":"'Tapered AA Calculations'!AJ34","v":"Is the Taper Triggered?"},null,null,{"$f":"'Tapered AA Calculations'!AM34","v":"No"},null,null,null,{"$f":"'Tapered AA Calculations'!AQ34","v":"Is the Taper Triggered?"},null,null,{"$f":"'Tapered AA Calculations'!AT34","v":"No"},null,null,null,{"$f":"'Tapered AA Calculations'!AX34","v":"Is the Taper Triggered?"},null,null,{"$f":"'Tapered AA Calculations'!BA34","v":"No"},null,null,null,{"$f":"'Tapered AA Calculations'!BE34","v":"Is the Taper Triggered?"},null,null,{"$f":"'Tapered AA Calculations'!BH34","v":"No"},null,null,null,{"$f":"'Tapered AA Calculations'!BL34","v":"Is the Taper Triggered?"},null,null,{"$f":"'Tapered AA Calculations'!BO34","v":"No"}]
[null,null,null,null,null,null,null,{"$f":"'Tapered AA Calculations'!H35","v":"Annual Allowance for 2016/17"},null,null,{"$f":"'Tapered AA Calculations'!K35","v":40000},null,null,null,{"$f":"'Tapered AA Calculations'!O35","v":"Annual Allowance for 2017/18"},null,null,{"$f":"'Tapered AA Calculations'!R35","v":40000},null,null,null,{"$f":"'Tapered AA Calculations'!V35","v":"Annual Allowance for 2018/19"},null,null,{"$f":"'Tapered AA Calculations'!Y35","v":40000},null,null,null,{"$f":"'Tapered AA Calculations'!AC35","v":"Annual Allowance for 2019/20"},null,null,{"$f":"'Tapered AA Calculations'!AF35","v":40000},null,null,null,{"$f":"'Tapered AA Calculations'!AJ35","v":"Annual Allowance for 2020/21"},null,null,{"$f":"'Tapered AA Calculations'!AM35","v":40000},null,null,null,{"$f":"'Tapered AA Calculations'!AQ35","v":"Annual Allowance for 2021/22"},null,null,{"$f":"'Tapered AA Calculations'!AT35","v":40000},null,null,null,{"$f":"'Tapered AA Calculations'!AX35","v":"Annual Allowance for 2022/23"},null,null,{"$f":"'Tapered AA Calculations'!BA35","v":40000},null,null,null,{"$f":"'Tapered AA Calculations'!BE35","v":"Annual Allowance for 2023/24"},null,null,{"$f":"'Tapered AA Calculations'!BH35","v":60000},null,null,null,{"$f":"'Tapered AA Calculations'!BL35","v":"Annual Allowance for 2024/25"},null,null,{"$f":"'Tapered AA Calculations'!BO35","v":60000}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Total Inputs",null,{"$f":"H7+H10+H12+H15+H18+H20+H22+H25+H28","v":0},null,null,null,null,"Total Inputs",null,{"$f":"O7+O10+O12+O15+O18+O20+O22+O25+O28","v":0},null,null,null,null,"Total Inputs",null,{"$f":"V7+V10+V12+V15+V18+V20+V22+V25+V28","v":0},null,null,null,null,"Total Inputs",null,{"$f":"AC7+AC10+AC12+AC15+AC18+AC20+AC22+AC25+AC28","v":0},null,null,null,null,"Total Inputs",null,{"$f":"AJ7+AJ10+AJ12+AJ15+AJ18+AJ20+AJ22+AJ25+AJ28","v":0},null,null,null,null,"Total Inputs",null,{"$f":"AQ7+AQ10+AQ12+AQ15+AQ18+AQ20+AQ22+AQ25+AQ28","v":0},null,null,null,null,"Total Inputs",null,{"$f":"AX7+AX10+AX12+AX15+AX18+AX20+AX22+AX25+AX28","v":0},null,null,null,null,"Total Inputs",null,{"$f":"BE7+BE10+BE12+BE15+BE18+BE20+BE22+BE25+BE28","v":0},null,null,null,null,"Total Inputs",null,{"$f":"BL7+BL10+BL12+BL15+BL18+BL20+BL22+BL25+BL28","v":9}]
[null,null,null,null,null,null,null,null,null,"AA Input",null,{"$f":"(H12-H22)+H15+H18+H20","v":0},null,null,null,null,"AA Input",null,{"$f":"(O12-O22)+O15+O18+O20","v":0},null,null,null,null,"AA Input",null,{"$f":"(V12-V22)+V15+V18+V20","v":0},null,null,null,null,"AA Input",null,{"$f":"(AC12-AC22)+AC15+AC18+AC20","v":0},null,null,null,null,"AA Input",null,{"$f":"(AJ12-AJ22)+AJ15+AJ18+AJ20","v":0},null,null,null,null,"AA Input",null,{"$f":"(AQ12-AQ22)+AQ15+AQ18+AQ20","v":0},null,null,null,null,"AA Input",null,{"$f":"(AX12-AX22)+AX15+AX18+AX20","v":0},null,null,null,null,"AA Input",null,{"$f":"(BE12-BE22)+BE15+BE18+BE20","v":0},null,null,null,null,"AA Input",null,{"$f":"(BL12-BL22)+BL15+BL18+BL20","v":0}]