{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Home","Inputs","Summary","Print Friendly Summary","Glossary of terms for inputs","LSA Chart","LSDBA Chart"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Home","index":0,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,4,19,10],[12,1,12,10],[3,1,9,11],[0,1,0,7]]}
[null,"LSA/LSDBA Modelling Tool\nbuilt by M&G",null,null,null,null,null,null,null,null,null,"2025/26"]
[]
[null,"Important information about this tool"]
[null,"This tool allows you to estimate the potential LSA and LSDBA availability for your client.\nWe have assumed the user is familiar with HMRC rules on pension benefits and the operation of the LSA and LSDBA.  \nThe tool does not cater for those with Enhanced Protection with protected tax free cash, unless the protection is 25%. \nThis tool is not a personal illustration and the values presented do not suggest any recommendation and should not be taken as offering advice.\nThe figures represent only potential growth and LSA and LSDBA availability over the terms shown and is not an indicator of future performance.\nThe tool is based on our current understanding of HMRC rules and practice relating to the operation of the LSA & LSDBA. \nTax rules can change and the impact of taxation (and any tax reliefs) depends on individual's circumstances.\nEvery care has been taken to the accuracy of this tool, but it must be appreciated that we cannot accept any responsibility for loss, however caused, suffered by any person who has acted or refrained from acting as a result of material contained in this tool.\nRed figures indicate an input error e.g. a benefit payment higher than the available fund.\nWhere a field has a red tag in the top right corner this provides further information about the figures calculated.\nThe value of an investment can go down as well as up. Your clients may get back less than they have paid in.\nAll benefit payments are gross and don't factor in any tax the individual may be liable for.\nThis tool will cease to operate at the end of the tax year shown above."]
[]
[]
[]
[]
[]
[]
[]
[null,"Assumptions used in this tool"]
[null,"Assumes all pre 24 and post 24 drawdowns are each held in a single arrangement."]
[null,"LSA/LSDBA used elsewhere is immediately after any LSA/LSDBA used in year."]
[null,"All moves to drawdown/UFPLS allow tax free amount of the lower of 25% of fund movement, the available LSA and available LSDBA."]
[null,"Benefits and contributions are annual in advance."]
[null,"Growth is applied annually in arrears"]
[null,"Death is assumed to occur at the end of the year."]
[]
[null,null,null,null,"To use the tool go to \"Inputs\" tab."]

{"sheet":"Inputs","index":1,"n_rows":54,"n_cols":51,"rows_kept":54,"cut":false,"hidden":false,"merged":[[10,46,10,48],[10,8,10,22],[10,25,10,31],[10,33,10,37],[10,40,10,42],[3,15,3,19],[7,1,7,4],[10,1,10,5],[1,15,1,19],[3,1,3,5],[6,1,6,4],[3,8,3,13],[1,1,1,12],[1,28,1,30],[6,25,6,27],[7,25,7,27],[5,29,5,33],[6,29,6,33],[7,29,7,33]]}
[null,1,2,3,4,5,null,6,7,null,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46]
[null,"Inputs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kill code"]
[null,1,{"$f":"B3+1","v":2},{"$f":"C3+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
[null,"Assumptions & Values",null,null,null,null,null,null,"Available Allowances",null,null,null,null,null,null,"Current Fund Values",null,null,null,null,null,null,null,null,null,"Warnings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(AT6<TODAY())","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unvested",null,null,null,500000,null,null,null,null,null,{"$f":"IF(AT54>0,\" Benefits started pre 57.\",\"\")","v":""},null,null,null,{"$f":"IF(AV54>0,\"Pre 24 income too high.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-04-05"]
[null,"Net fund growth",null,null,null,0.04,null,null,"LSA",null,null,null,null,268275,null,"Post April 2024 drawdown",null,null,null,0,null,null,null,null,null,{"$f":"IF(AU54>0,\" Unvested withdrawals too high.\",\"\")","v":""},null,null,null,{"$f":"IF(AS54>0,\" Contributions post 75.\",\"\")","v":""}]
[null,"Age at start",null,null,null,50,null,null,"LSDBA",null,null,null,null,1073100,null,"Pre April 2024 drawdown",null,null,null,0,null,null,null,null,null,{"$f":"IF(AW54>0,\"Post 24 income too high.\",\"\")","v":""},null,null,null,{"$f":"IF((AX54+AY54)>0,\" Allowances used elsewhere too high\",\"\")","v":""}]
[]
[]
[null,"Available Allowances",null,null,null,null,null,null,"Unvested Pot",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P7","v":"Post April 2024 drawdown"},null,null,null,null,null,null,null,{"$f":"P8","v":"Pre April 2024 drawdown"},null,null,null,null,null,null,"Allowances Used Elsewhere",null,null,null,null,null,"Fund Exhaustion"]
[null,"Age","Year","LSA",null,"LSDBA","Unvested Fund to use LSA",null,"Fund\n(Start of Year)","Tax Free Cash Payable","Cum Tax Free","Cum Income",null,"Contributions",null,"UFPLS","Tax Free","Income",null,"Drawdown","Tax Free","Designation","Fund \n(End of Year)",null,null,"Fund\n(Start of Year)",null,"Designation",null,"Income",null,"Fund \n(End of Year)",null,"Fund\n(Start of Year)",null,"Income",null,"Fund \n(End of Year)",0,null,"LSA",null,"LSDBA",null,"Cont warning","Benefit age  warning","Unvested","Pre 24","Post 24","LSA elsewhere","LSDBA elsewhere"]
[null,{"$f":"F8","v":50},1,{"$f":"N7","v":268275},null,{"$f":"N8","v":1073100},{"$f":"D13*4","v":1073100},null,{"$f":"T6","v":500000},{"$f":"I13/4","v":125000},{"$f":"Q13+U13","v":0},{"$f":"R13+AD13+AJ13","v":0},null,0,null,0,{"$f":"MIN(P13*0.25,D13,F13)","v":0},{"$f":"P13-Q13","v":0},null,0,{"$f":"MIN(T13*0.25,D13-Q13,F13-Q13)","v":0},{"$f":"T13-U13","v":0},{"$f":"(I13+N13-P13-T13)*(1+$F$7)","v":520000},null,null,{"$f":"T7","v":0},null,{"$f":"V13","v":0},null,0,null,{"$f":"(Z13+AB13-AD13)*(1+$F$7)","v":0},null,{"$f":"T8","v":0},null,0,null,{"$f":"(AH13-AJ13)*(1+$F$7)","v":0},null,null,0,null,0,null,{"$f":"AND(N13>0,B13>=75)","v":false},{"$f":"AND(T13+P13>0,B13<57)","v":false},{"$f":"AND(W13<0)","v":false},{"$f":"AND(AF13<0)","v":false},{"$f":"AND(AL13<0)","v":false},{"$f":"AND(D13-Q13-U13-AO13<0)","v":false},{"$f":"AND(D13-Q13-U13-AQ13<0)","v":false}]
[null,{"$f":"$B$13+C13","v":51},2,{"$f":"MAX(0,D13-Q13-U13-AO13)","v":268275},null,{"$f":"MAX(0,F13-Q13-U13-AQ13)","v":1073100},{"$f":"D14*4","v":1073100},null,{"$f":"MAX(0,W13)","v":520000},{"$f":"I14/4","v":130000},{"$f":"K13+Q14+U14","v":0},{"$f":"L13+R14+AD14+AJ14","v":0},null,0,null,0,0,{"$f":"P14-Q14","v":0},null,0,0,{"$f":"T14-U14","v":0},540800,null,null,{"$f":"AF13","v":0},null,{"$f":"V14","v":0},null,0,null,{"$f":"(Z14+AB14-AD14)*(1+$F$7)","v":0},null,{"$f":"AL13","v":0},null,0,null,{"$f":"(AH14-AJ14)*(1+$F$7)","v":0},null,null,0,null,0,null,false,false,{"$f":"AND(W14<0)","v":false},{"$f":"AND(AF14<0)","v":false},{"$f":"AND(AL14<0)","v":false},false,false]
[null,{"$f":"$B$13+C14","v":52},3,268275,null,1073100,1073100,null,{"$f":"MAX(0,W14)","v":540800},135200,{"$f":"K14+Q15+U15","v":0},{"$f":"L14+R15+AD15+AJ15","v":0},null,0,null,0,0,0,null,0,0,0,562432,null,null,{"$f":"AF14","v":0},null,0,null,0,null,0,null,{"$f":"AL14","v":0},null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,53,4,268275,null,1073100,1073100,null,562432,140608,0,0,null,0,null,0,0,0,null,0,0,0,584929.28000000003,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,54,5,268275,null,1073100,1073100,null,584929.28000000003,146232.32000000001,0,0,null,0,null,0,0,0,null,0,0,0,608326.45120000001,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,55,6,268275,null,1073100,1073100,null,608326.45120000001,152081.6128,0,0,null,0,null,0,0,0,null,0,0,0,632659.50924799999,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,56,7,268275,null,1073100,1073100,null,632659.50924799999,158164.877312,0,0,null,0,null,0,0,0,null,0,0,0,657965.88961792004,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,57,8,268275,null,1073100,1073100,null,657965.88961792004,164491.47240448001,0,0,null,0,null,0,0,0,null,0,0,0,684284.52520263684,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,58,9,268275,null,1073100,1073100,null,684284.52520263684,171071.13130065921,0,0,null,0,null,0,0,0,null,0,0,0,711655.90621074231,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,59,10,268275,null,1073100,1073100,null,711655.90621074231,177913.97655268558,0,0,null,0,null,0,0,0,null,0,0,0,740122.14245917206,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,10000,null,10000,null,false,false,false,false,false,false,false]
[null,60,11,258275,null,1063100,1033100,null,740122.14245917206,185030.53561479301,0,0,null,0,null,0,0,0,null,0,0,0,769727.02815753897,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,61,12,258275,null,1063100,1033100,null,769727.02815753897,192431.75703938474,0,0,null,0,null,0,0,0,null,0,0,0,800516.10928384052,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,62,13,258275,null,1063100,1033100,null,800516.10928384052,200129.02732096013,0,0,null,0,null,0,0,0,null,0,0,0,832536.75365519419,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,63,14,258275,null,1063100,1033100,null,832536.75365519419,208134.18841379855,0,0,null,0,null,0,0,0,null,0,0,0,865838.22380140203,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,64,15,258275,null,1063100,1033100,null,865838.22380140203,216459.55595035051,0,0,null,0,null,0,0,0,null,0,0,0,900471.7527534581,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,65,16,258275,null,1063100,1033100,null,900471.7527534581,225117.93818836453,0,0,null,0,null,0,0,0,null,0,0,0,936490.62286359642,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,66,17,258275,null,1063100,1033100,null,936490.62286359642,234122.65571589911,0,0,null,0,null,0,0,0,null,0,0,0,973950.24777814036,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,67,18,258275,null,1063100,1033100,null,973950.24777814036,243487.56194453509,0,0,null,0,null,0,0,0,null,0,0,0,1012908.257689266,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,68,19,258275,null,1063100,1033100,null,1012908.257689266,253227.0644223165,0,0,null,0,null,0,0,0,null,0,0,0,1053424.5879968368,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,69,20,258275,null,1063100,1033100,null,1053424.5879968368,263356.14699920919,0,0,null,0,null,0,0,0,null,0,0,0,1095561.5715167103,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,70,21,258275,null,1063100,1033100,null,1095561.5715167103,273890.39287917758,0,0,null,0,null,0,0,0,null,0,0,0,1139384.0343773789,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,71,22,258275,null,1063100,1033100,null,1139384.0343773789,284846.00859434472,0,0,null,0,null,0,0,0,null,0,0,0,1184959.395752474,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,72,23,258275,null,1063100,1033100,null,1184959.395752474,296239.84893811849,0,0,null,0,null,0,0,0,null,0,0,0,1232357.771582573,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,73,24,258275,null,1063100,1033100,null,1232357.771582573,308089.44289564324,0,0,null,0,null,0,0,0,null,0,0,0,1281652.082445876,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,74,25,258275,null,1063100,1033100,null,1281652.082445876,320413.02061146899,0,0,null,0,null,0,0,0,null,0,0,0,1332918.1657437112,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,75,26,258275,null,1063100,1033100,null,1332918.1657437112,333229.54143592779,0,0,null,0,null,0,0,0,null,0,0,0,1386234.8923734596,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,76,27,258275,null,1063100,1033100,null,1386234.8923734596,346558.72309336491,0,0,null,0,null,0,0,0,null,0,0,0,1441684.2880683981,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,77,28,258275,null,1063100,1033100,null,1441684.2880683981,360421.07201709953,0,0,null,0,null,0,0,0,null,0,0,0,1499351.6595911342,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,78,29,258275,null,1063100,1033100,null,1499351.6595911342,374837.91489778354,0,0,null,0,null,0,0,0,null,0,0,0,1559325.7259747796,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,79,30,258275,null,1063100,1033100,null,1559325.7259747796,389831.43149369489,0,0,null,0,null,0,0,0,null,0,0,0,1621698.7550137709,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,80,31,258275,null,1063100,1033100,null,1621698.7550137709,405424.68875344272,0,0,null,0,null,0,0,0,null,0,0,0,1686566.7052143218,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,81,32,258275,null,1063100,1033100,null,1686566.7052143218,421641.67630358046,0,0,null,0,null,0,0,0,null,0,0,0,1754029.3734228949,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,82,33,258275,null,1063100,1033100,null,1754029.3734228949,438507.34335572371,0,0,null,0,null,0,0,0,null,0,0,0,1824190.5483598106,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,83,34,258275,null,1063100,1033100,null,1824190.5483598106,456047.63708995265,0,0,null,0,null,0,0,0,null,0,0,0,1897158.1702942031,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,84,35,258275,null,1063100,1033100,null,1897158.1702942031,474289.54257355077,0,0,null,0,null,0,0,0,null,0,0,0,1973044.4971059712,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,85,36,258275,null,1063100,1033100,null,1973044.4971059712,493261.1242764928,0,0,null,0,null,0,0,0,null,0,0,0,2051966.2769902102,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,86,37,258275,null,1063100,1033100,null,2051966.2769902102,512991.56924755254,0,0,null,0,null,0,0,0,null,0,0,0,2134044.9280698188,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,87,38,258275,null,1063100,1033100,null,2134044.9280698188,533511.23201745469,0,0,null,0,null,0,0,0,null,0,0,0,2219406.7251926116,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,88,39,258275,null,1063100,1033100,null,2219406.7251926116,554851.68129815289,0,0,null,0,null,0,0,0,null,0,0,0,2308182.9942003163,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[null,89,40,258275,null,1063100,1033100,null,2308182.9942003163,577045.74855007906,0,0,null,0,null,0,0,0,null,0,0,0,2400510.3139683288,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0,null,0,null,false,false,false,false,false,false,false]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AS54:AW54)","v":0},null,{"$f":"COUNTIF(AS13:AS52,TRUE)","v":0},{"$f":"COUNTIF(AT13:AT52,TRUE)","v":0},0,0,0,0,0]

{"sheet":"Summary","index":2,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"Summary"]
[]
[null,"Assumptions & Values",null,null,"Position at Age ",50,null,null,null,{"$f":"(F3-Inputs!B13)","v":0}]
[null,"Net fund growth",{"$f":"Inputs!F7","v":0.04}]
[null,"Age at start",{"$f":"Inputs!F8","v":50},null,"Fund Values"]
[null,null,null,null,"Unvested",{"$f":"VLOOKUP($F$3,Inputs!B13:AW52,8)","v":500000}]
[null,null,null,null,"Post 24",{"$f":"VLOOKUP($F$3,Inputs!B13:AW52,25)","v":0}]
[null,"Available Allowances",null,null,"Pre 24",{"$f":"VLOOKUP($F$3,Inputs!B13:AW52,33)","v":0}]
[null,"LSA",{"$f":"Inputs!N7","v":268275}]
[null,"LSDBA",{"$f":"Inputs!N8","v":1073100},null,"Total tax free",{"$f":"VLOOKUP($F$3,Inputs!B13:AW52,10)","v":0}]
[null,null,null,null,"Total income",{"$f":"VLOOKUP($F$3,Inputs!B13:AW52,11)","v":0}]
[null,"Current Fund Values"]
[null,"Unvested",{"$f":"Inputs!T6","v":500000},null,"LSA remaining",{"$f":"VLOOKUP($F$3,Inputs!B13:AW52,3)","v":268275},null,null,null,{"$f":"F13*4","v":1073100}]
[null,"Post April 2024 drawdown",{"$f":"Inputs!T7","v":0},null,null,null,null,null,null,{"$f":"F6","v":500000}]
[null,"Pre April 2024 drawdown",{"$f":"Inputs!T8","v":0},null,"\"Ballpark\" Contribution required to fully use LSA",null,null,null,null,{"$f":"J13-J14","v":573100}]
[null,null,null,null,"As an annual contribution",{"$f":"IF(F3=C5,0,MAX(0,PMT($C$4,J3,0,-J15,1)))","v":0}]
[null,null,null,null,"As a single contribution",{"$f":"IF(F3=C5,0,MAX(0,PV(C4,J3,0,-J15,0)))","v":0}]
[]
[null,null,null,null,"Lump Sum Death Benefit value"]
[null,null,null,null,"Unvested",{"$f":"F6","v":500000}]
[null,null,null,null,"Post 24",{"$f":"F7","v":0}]
[null,null,null,null,"Total",{"$f":"SUM(F20:F21)","v":500000}]
[null,null,null,null,"LSDBA remaining",{"$f":"VLOOKUP($F$3,Inputs!B13:AW52,5)","v":1073100}]
[null,null,null,null,"Excess",{"$f":"MAX(0,F22-F23)","v":0}]
[]
[]
[null,null,null,null,"Unvested Pot target value",500000]
[null,null,null,null,"\"Ballpark\" Benefits to match target value (UFPLS)",{"$f":"IF(F3=C5,0,MAX(0,PMT(C4,J3,0,-J28,1)))","v":0},null,null,null,{"$f":"F20-F27","v":0}]
[]
[null,null,null,null,"Post April 24 pot target value",200000]
[null,null,null,null,"Income to match target value ",{"$f":"IF(F3=C5,0,MAX(0,-PMT(C4,J3,0,J31,1)))","v":0},null,null,null,{"$f":"F21-F30","v":-200000}]
[]
[null,null,null,null,"Excess if target pots met",{"$f":"MAX(0,(F27+F30)-F23)","v":0}]

{"sheet":"Print Friendly Summary","index":3,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"Summary"]
[]
[null,"Assumptions & Values",null,null,{"$f":"Summary!E3","v":"Position at Age "},{"$f":"Summary!F3","v":50}]
[null,{"$f":"Summary!B4","v":"Net fund growth"},{"$f":"Summary!C4","v":0.04}]
[null,{"$f":"Summary!B5","v":"Age at start"},{"$f":"Summary!C5","v":50},null,{"$f":"Summary!E5","v":"Fund Values"}]
[null,null,null,null,{"$f":"Summary!E6","v":"Unvested"},{"$f":"Summary!F6","v":500000}]
[null,null,null,null,{"$f":"Summary!E7","v":"Post 24"},{"$f":"Summary!F7","v":0}]
[null,{"$f":"Summary!B8","v":"Available Allowances"},null,null,{"$f":"Summary!E8","v":"Pre 24"},{"$f":"Summary!F8","v":0}]
[null,{"$f":"Summary!B9","v":"LSA"},{"$f":"Summary!C9","v":268275}]
[null,{"$f":"Summary!B10","v":"LSDBA"},{"$f":"Summary!C10","v":1073100},null,{"$f":"Summary!E10","v":"Total tax free"},{"$f":"Summary!F10","v":0}]
[null,null,null,null,{"$f":"Summary!E11","v":"Total income"},{"$f":"Summary!F11","v":0}]
[null,{"$f":"Summary!B12","v":"Current Fund Values"}]
[null,{"$f":"Summary!B13","v":"Unvested"},{"$f":"Summary!C13","v":500000},null,{"$f":"Summary!E13","v":"LSA remaining"},{"$f":"Summary!F13","v":268275}]
[null,{"$f":"Summary!B14","v":"Post April 2024 drawdown"},{"$f":"Summary!C14","v":0}]
[null,{"$f":"Summary!B15","v":"Pre April 2024 drawdown"},{"$f":"Summary!C15","v":0},null,{"$f":"Summary!E15","v":"\"Ballpark\" Contribution required to fully use LSA"}]
[null,null,null,null,{"$f":"Summary!E16","v":"As an annual contribution"},{"$f":"Summary!F16","v":0}]
[null,null,null,null,{"$f":"Summary!E17","v":"As a single contribution"},{"$f":"Summary!F17","v":0}]
[]
[null,null,null,null,{"$f":"Summary!E19","v":"Lump Sum Death Benefit value"}]
[null,null,null,null,{"$f":"Summary!E20","v":"Unvested"},{"$f":"Summary!F20","v":500000}]
[null,null,null,null,{"$f":"Summary!E21","v":"Post 24"},{"$f":"Summary!F21","v":0}]
[null,null,null,null,{"$f":"Summary!E22","v":"Total"},{"$f":"Summary!F22","v":500000}]
[null,null,null,null,{"$f":"Summary!E23","v":"LSDBA remaining"},{"$f":"Summary!F23","v":1073100}]
[null,null,null,null,{"$f":"Summary!E24","v":"Excess"},{"$f":"Summary!F24","v":0}]
[]
[]
[null,null,null,null,{"$f":"Summary!E27","v":"Unvested Pot target value"},{"$f":"Summary!F27","v":500000}]
[null,null,null,null,{"$f":"Summary!E28","v":"\"Ballpark\" Benefits to match target value (UFPLS)"},{"$f":"Summary!F28","v":0}]
[]
[null,null,null,null,{"$f":"Summary!E30","v":"Post April 24 pot target value"},{"$f":"Summary!F30","v":200000}]
[null,null,null,null,{"$f":"Summary!E31","v":"Income to match target value "},{"$f":"Summary!F31","v":0}]
[]
[null,null,null,null,{"$f":"Summary!E33","v":"Excess if target pots met"},{"$f":"Summary!F33","v":0}]

{"sheet":"Glossary of terms for inputs","index":4,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[[20,2,20,4],[3,2,4,2],[5,2,6,2],[7,2,9,2],[10,2,12,2],[15,2,16,2],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3]]}
[]
[]
[null,null,"Section","Input Name","Description"]
[null,null,{"$f":"Inputs!B4","v":"Assumptions & Values"},{"$f":"Inputs!B7","v":"Net fund growth"},"This is the fund growth after product and adviser charges have been taken into account. "]
[null,null,null,{"$f":"Inputs!B8","v":"Age at start"},"The current age for the client that you wish to start modelling for. "]
[null,null,{"$f":"Inputs!I4","v":"Available Allowances"},{"$f":"Inputs!I7","v":"LSA"},"The starting value of the available Lump Sum Allowance that the client has available. "]
[null,null,null,{"$f":"Inputs!I8","v":"LSDBA"},"The starting value of the available Lump Sum and Death Benefits Allowance that the client has available. "]
[null,null,{"$f":"Inputs!P4","v":"Current Fund Values"},{"$f":"Inputs!P6","v":"Unvested"},"The value of the uncrysttlised money purchase pots that are to be modelled. "]
[null,null,null,{"$f":"Inputs!P7","v":"Post April 2024 drawdown"},"This is for any funds designated to drawdown on or after 6 April 2024, this is important as these funds ARE tested against the LSDBA if death benefits are paid as a lump sum. "]
[null,null,null,{"$f":"Inputs!P8","v":"Pre April 2024 drawdown"},"This is for any funds designated to drawdown prior to 6 April 2024, this is important as these funds are not tested against the LSDBA if death benefits are paid as a lump sum. "]
[null,null,{"$f":"Inputs!I11","v":"Unvested Pot"},{"$f":"Inputs!N12","v":"Contributions"},"The gross value (including tax relief where applicable) of any pension contributions made. "]
[null,null,null,{"$f":"Inputs!P12","v":"UFPLS"},"The gross value of an UFPLS to be taken, the tax free element will be the higher of 25% of the gross value, or the available LSA/LSDBA. "]
[null,null,null,{"$f":"Inputs!T12","v":"Drawdown"},"The gross value of amounts to be crystallised for drawdown designations. PCLS is assumed to be the higher of 25% of the gross value, or the available LSA/LSDBA."]
[null,null,{"$f":"Inputs!Z11","v":"Post April 2024 drawdown"},{"$f":"Inputs!AD12","v":"Income"},"The gross income the client will withdraw from the plan."]
[null,null,{"$f":"Inputs!AH11","v":"Pre April 2024 drawdown"},{"$f":"Inputs!AJ12","v":"Income"},"The gross income the client will withdraw from the plan."]
[null,null,{"$f":"Inputs!AO11","v":"Allowances Used Elsewhere"},{"$f":"Inputs!AO12","v":"LSA"},"The amount of LSA used up by having a RBCE from schemes not included in this model (e.g. Defined Benefit schemes paying a PCLS)."]
[null,null,null,{"$f":"Inputs!AQ12","v":"LSDBA"},"The amount of LSDBA used up by having a RBCE from schemes not included in this model (e.g. Defined Benefit schemes paying a PCLS)."]
[]
[]
[]
[null,null,"Further Resources"]
[null,null,"Lump Sum Allowance (LSA)",null,"https://www.mandg.com/wealth/adviser-services/tech-matters/pensions/benefit-limits/lump-sum-allowance"]
[null,null,"Lump Sum and Death Benefit Allowance (LSDBA)",null,"https://www.mandg.com/wealth/adviser-services/tech-matters/pensions/benefit-limits/lump-sum-and-death-benefit-allowance"]
[null,null,"Relevant Benefit Crystallisation Events (RBCEs)",null,"https://www.mandg.com/wealth/adviser-services/tech-matters/pensions/benefit-limits/relevant-benefit-crystallisation-events"]
[null,null,"Uncrystallised Funds Pension Lump Sums (UFPLS)",null,"https://www.mandg.com/wealth/adviser-services/tech-matters/pensions/lump-sum-options/ufpls"]
[null,null,"Transitional Tax Free Amount Certificates (TTFAC)",null,"https://www.mandg.com/wealth/adviser-services/tech-matters/pensions/benefit-limits/transitional-tax-free-amount-certificates"]
[null,null,"LTA Transitional Tax Free Amount Tool",null,"https://www.mandg.com/wealth/adviser-services/tech-matters/tools-and-calculators/lta-transitional-tax-free-amount-tool"]
[null,null,"Tax Relief Modeller",null,"https://www.mandg.com/wealth/adviser-services/tech-matters/tools-and-calculators/tax-relief-modeller"]

{"sheet":"LSA Chart","index":5,"n_rows":47,"n_cols":18,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Age","Tax Free","Income",{"$f":"Inputs!I11","v":"Unvested Pot"},{"$f":"Inputs!Z11","v":"Post April 2024 drawdown"},{"$f":"Inputs!AH11","v":"Pre April 2024 drawdown"},{"$f":"Inputs!D12","v":"LSA"},{"$f":"Inputs!F12","v":"LSDBA"},{"$f":"Inputs!G12","v":"Unvested Fund to use LSA"},{"$f":"Inputs!J12","v":"Tax Free Cash Payable"},"LSA avialable EOY"]
[null,null,null,null,{"$f":"Inputs!B13","v":50},{"$f":"Inputs!K13","v":0},{"$f":"Inputs!L13","v":0},{"$f":"Inputs!W13","v":520000},{"$f":"Inputs!AF13","v":0},{"$f":"Inputs!AL13","v":0},{"$f":"Inputs!D13","v":268275},{"$f":"Inputs!F13","v":1073100},{"$f":"Inputs!G13","v":1073100},{"$f":"Inputs!J13","v":125000},{"$f":"K8-F8","v":268275},null,{"$f":"$K$8-F8","v":268275},{"$f":"O8+F8","v":268275}]
[null,null,null,null,{"$f":"Inputs!B14","v":51},{"$f":"Inputs!K14","v":0},{"$f":"Inputs!L14","v":0},{"$f":"Inputs!W14","v":540800},{"$f":"Inputs!AF14","v":0},{"$f":"Inputs!AL14","v":0},{"$f":"Inputs!D14","v":268275},{"$f":"Inputs!F14","v":1073100},{"$f":"Inputs!G14","v":1073100},{"$f":"Inputs!J14","v":130000},{"$f":"K9-F9","v":268275},null,{"$f":"$K$8-F9","v":268275},{"$f":"Q9+F9","v":268275}]
[null,null,null,null,{"$f":"Inputs!B15","v":52},{"$f":"Inputs!K15","v":0},{"$f":"Inputs!L15","v":0},{"$f":"Inputs!W15","v":562432},{"$f":"Inputs!AF15","v":0},{"$f":"Inputs!AL15","v":0},{"$f":"Inputs!D15","v":268275},{"$f":"Inputs!F15","v":1073100},{"$f":"Inputs!G15","v":1073100},{"$f":"Inputs!J15","v":135200},268275,null,268275,{"$f":"Q10+F10","v":268275}]
[null,null,null,null,{"$f":"Inputs!B16","v":53},{"$f":"Inputs!K16","v":0},{"$f":"Inputs!L16","v":0},{"$f":"Inputs!W16","v":584929.28000000003},{"$f":"Inputs!AF16","v":0},{"$f":"Inputs!AL16","v":0},{"$f":"Inputs!D16","v":268275},{"$f":"Inputs!F16","v":1073100},{"$f":"Inputs!G16","v":1073100},{"$f":"Inputs!J16","v":140608},268275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B17","v":54},{"$f":"Inputs!K17","v":0},{"$f":"Inputs!L17","v":0},{"$f":"Inputs!W17","v":608326.45120000001},{"$f":"Inputs!AF17","v":0},{"$f":"Inputs!AL17","v":0},{"$f":"Inputs!D17","v":268275},{"$f":"Inputs!F17","v":1073100},{"$f":"Inputs!G17","v":1073100},{"$f":"Inputs!J17","v":146232.32000000001},268275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B18","v":55},{"$f":"Inputs!K18","v":0},{"$f":"Inputs!L18","v":0},{"$f":"Inputs!W18","v":632659.50924799999},{"$f":"Inputs!AF18","v":0},{"$f":"Inputs!AL18","v":0},{"$f":"Inputs!D18","v":268275},{"$f":"Inputs!F18","v":1073100},{"$f":"Inputs!G18","v":1073100},{"$f":"Inputs!J18","v":152081.6128},268275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B19","v":56},{"$f":"Inputs!K19","v":0},{"$f":"Inputs!L19","v":0},{"$f":"Inputs!W19","v":657965.88961792004},{"$f":"Inputs!AF19","v":0},{"$f":"Inputs!AL19","v":0},{"$f":"Inputs!D19","v":268275},{"$f":"Inputs!F19","v":1073100},{"$f":"Inputs!G19","v":1073100},{"$f":"Inputs!J19","v":158164.877312},268275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B20","v":57},{"$f":"Inputs!K20","v":0},{"$f":"Inputs!L20","v":0},{"$f":"Inputs!W20","v":684284.52520263684},{"$f":"Inputs!AF20","v":0},{"$f":"Inputs!AL20","v":0},{"$f":"Inputs!D20","v":268275},{"$f":"Inputs!F20","v":1073100},{"$f":"Inputs!G20","v":1073100},{"$f":"Inputs!J20","v":164491.47240448001},268275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B21","v":58},{"$f":"Inputs!K21","v":0},{"$f":"Inputs!L21","v":0},{"$f":"Inputs!W21","v":711655.90621074231},{"$f":"Inputs!AF21","v":0},{"$f":"Inputs!AL21","v":0},{"$f":"Inputs!D21","v":268275},{"$f":"Inputs!F21","v":1073100},{"$f":"Inputs!G21","v":1073100},{"$f":"Inputs!J21","v":171071.13130065921},268275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B22","v":59},{"$f":"Inputs!K22","v":0},{"$f":"Inputs!L22","v":0},{"$f":"Inputs!W22","v":740122.14245917206},{"$f":"Inputs!AF22","v":0},{"$f":"Inputs!AL22","v":0},{"$f":"Inputs!D22","v":268275},{"$f":"Inputs!F22","v":1073100},{"$f":"Inputs!G22","v":1073100},{"$f":"Inputs!J22","v":177913.97655268558},268275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B23","v":60},{"$f":"Inputs!K23","v":0},{"$f":"Inputs!L23","v":0},{"$f":"Inputs!W23","v":769727.02815753897},{"$f":"Inputs!AF23","v":0},{"$f":"Inputs!AL23","v":0},{"$f":"Inputs!D23","v":258275},{"$f":"Inputs!F23","v":1063100},{"$f":"Inputs!G23","v":1033100},{"$f":"Inputs!J23","v":185030.53561479301},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B24","v":61},{"$f":"Inputs!K24","v":0},{"$f":"Inputs!L24","v":0},{"$f":"Inputs!W24","v":800516.10928384052},{"$f":"Inputs!AF24","v":0},{"$f":"Inputs!AL24","v":0},{"$f":"Inputs!D24","v":258275},{"$f":"Inputs!F24","v":1063100},{"$f":"Inputs!G24","v":1033100},{"$f":"Inputs!J24","v":192431.75703938474},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B25","v":62},{"$f":"Inputs!K25","v":0},{"$f":"Inputs!L25","v":0},{"$f":"Inputs!W25","v":832536.75365519419},{"$f":"Inputs!AF25","v":0},{"$f":"Inputs!AL25","v":0},{"$f":"Inputs!D25","v":258275},{"$f":"Inputs!F25","v":1063100},{"$f":"Inputs!G25","v":1033100},{"$f":"Inputs!J25","v":200129.02732096013},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B26","v":63},{"$f":"Inputs!K26","v":0},{"$f":"Inputs!L26","v":0},{"$f":"Inputs!W26","v":865838.22380140203},{"$f":"Inputs!AF26","v":0},{"$f":"Inputs!AL26","v":0},{"$f":"Inputs!D26","v":258275},{"$f":"Inputs!F26","v":1063100},{"$f":"Inputs!G26","v":1033100},{"$f":"Inputs!J26","v":208134.18841379855},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B27","v":64},{"$f":"Inputs!K27","v":0},{"$f":"Inputs!L27","v":0},{"$f":"Inputs!W27","v":900471.7527534581},{"$f":"Inputs!AF27","v":0},{"$f":"Inputs!AL27","v":0},{"$f":"Inputs!D27","v":258275},{"$f":"Inputs!F27","v":1063100},{"$f":"Inputs!G27","v":1033100},{"$f":"Inputs!J27","v":216459.55595035051},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B28","v":65},{"$f":"Inputs!K28","v":0},{"$f":"Inputs!L28","v":0},{"$f":"Inputs!W28","v":936490.62286359642},{"$f":"Inputs!AF28","v":0},{"$f":"Inputs!AL28","v":0},{"$f":"Inputs!D28","v":258275},{"$f":"Inputs!F28","v":1063100},{"$f":"Inputs!G28","v":1033100},{"$f":"Inputs!J28","v":225117.93818836453},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B29","v":66},{"$f":"Inputs!K29","v":0},{"$f":"Inputs!L29","v":0},{"$f":"Inputs!W29","v":973950.24777814036},{"$f":"Inputs!AF29","v":0},{"$f":"Inputs!AL29","v":0},{"$f":"Inputs!D29","v":258275},{"$f":"Inputs!F29","v":1063100},{"$f":"Inputs!G29","v":1033100},{"$f":"Inputs!J29","v":234122.65571589911},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B30","v":67},{"$f":"Inputs!K30","v":0},{"$f":"Inputs!L30","v":0},{"$f":"Inputs!W30","v":1012908.257689266},{"$f":"Inputs!AF30","v":0},{"$f":"Inputs!AL30","v":0},{"$f":"Inputs!D30","v":258275},{"$f":"Inputs!F30","v":1063100},{"$f":"Inputs!G30","v":1033100},{"$f":"Inputs!J30","v":243487.56194453509},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B31","v":68},{"$f":"Inputs!K31","v":0},{"$f":"Inputs!L31","v":0},{"$f":"Inputs!W31","v":1053424.5879968368},{"$f":"Inputs!AF31","v":0},{"$f":"Inputs!AL31","v":0},{"$f":"Inputs!D31","v":258275},{"$f":"Inputs!F31","v":1063100},{"$f":"Inputs!G31","v":1033100},{"$f":"Inputs!J31","v":253227.0644223165},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B32","v":69},{"$f":"Inputs!K32","v":0},{"$f":"Inputs!L32","v":0},{"$f":"Inputs!W32","v":1095561.5715167103},{"$f":"Inputs!AF32","v":0},{"$f":"Inputs!AL32","v":0},{"$f":"Inputs!D32","v":258275},{"$f":"Inputs!F32","v":1063100},{"$f":"Inputs!G32","v":1033100},{"$f":"Inputs!J32","v":263356.14699920919},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B33","v":70},{"$f":"Inputs!K33","v":0},{"$f":"Inputs!L33","v":0},{"$f":"Inputs!W33","v":1139384.0343773789},{"$f":"Inputs!AF33","v":0},{"$f":"Inputs!AL33","v":0},{"$f":"Inputs!D33","v":258275},{"$f":"Inputs!F33","v":1063100},{"$f":"Inputs!G33","v":1033100},{"$f":"Inputs!J33","v":273890.39287917758},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B34","v":71},{"$f":"Inputs!K34","v":0},{"$f":"Inputs!L34","v":0},{"$f":"Inputs!W34","v":1184959.395752474},{"$f":"Inputs!AF34","v":0},{"$f":"Inputs!AL34","v":0},{"$f":"Inputs!D34","v":258275},{"$f":"Inputs!F34","v":1063100},{"$f":"Inputs!G34","v":1033100},{"$f":"Inputs!J34","v":284846.00859434472},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B35","v":72},{"$f":"Inputs!K35","v":0},{"$f":"Inputs!L35","v":0},{"$f":"Inputs!W35","v":1232357.771582573},{"$f":"Inputs!AF35","v":0},{"$f":"Inputs!AL35","v":0},{"$f":"Inputs!D35","v":258275},{"$f":"Inputs!F35","v":1063100},{"$f":"Inputs!G35","v":1033100},{"$f":"Inputs!J35","v":296239.84893811849},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B36","v":73},{"$f":"Inputs!K36","v":0},{"$f":"Inputs!L36","v":0},{"$f":"Inputs!W36","v":1281652.082445876},{"$f":"Inputs!AF36","v":0},{"$f":"Inputs!AL36","v":0},{"$f":"Inputs!D36","v":258275},{"$f":"Inputs!F36","v":1063100},{"$f":"Inputs!G36","v":1033100},{"$f":"Inputs!J36","v":308089.44289564324},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B37","v":74},{"$f":"Inputs!K37","v":0},{"$f":"Inputs!L37","v":0},{"$f":"Inputs!W37","v":1332918.1657437112},{"$f":"Inputs!AF37","v":0},{"$f":"Inputs!AL37","v":0},{"$f":"Inputs!D37","v":258275},{"$f":"Inputs!F37","v":1063100},{"$f":"Inputs!G37","v":1033100},{"$f":"Inputs!J37","v":320413.02061146899},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B38","v":75},{"$f":"Inputs!K38","v":0},{"$f":"Inputs!L38","v":0},{"$f":"Inputs!W38","v":1386234.8923734596},{"$f":"Inputs!AF38","v":0},{"$f":"Inputs!AL38","v":0},{"$f":"Inputs!D38","v":258275},{"$f":"Inputs!F38","v":1063100},{"$f":"Inputs!G38","v":1033100},{"$f":"Inputs!J38","v":333229.54143592779},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B39","v":76},{"$f":"Inputs!K39","v":0},{"$f":"Inputs!L39","v":0},{"$f":"Inputs!W39","v":1441684.2880683981},{"$f":"Inputs!AF39","v":0},{"$f":"Inputs!AL39","v":0},{"$f":"Inputs!D39","v":258275},{"$f":"Inputs!F39","v":1063100},{"$f":"Inputs!G39","v":1033100},{"$f":"Inputs!J39","v":346558.72309336491},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B40","v":77},{"$f":"Inputs!K40","v":0},{"$f":"Inputs!L40","v":0},{"$f":"Inputs!W40","v":1499351.6595911342},{"$f":"Inputs!AF40","v":0},{"$f":"Inputs!AL40","v":0},{"$f":"Inputs!D40","v":258275},{"$f":"Inputs!F40","v":1063100},{"$f":"Inputs!G40","v":1033100},{"$f":"Inputs!J40","v":360421.07201709953},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B41","v":78},{"$f":"Inputs!K41","v":0},{"$f":"Inputs!L41","v":0},{"$f":"Inputs!W41","v":1559325.7259747796},{"$f":"Inputs!AF41","v":0},{"$f":"Inputs!AL41","v":0},{"$f":"Inputs!D41","v":258275},{"$f":"Inputs!F41","v":1063100},{"$f":"Inputs!G41","v":1033100},{"$f":"Inputs!J41","v":374837.91489778354},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B42","v":79},{"$f":"Inputs!K42","v":0},{"$f":"Inputs!L42","v":0},{"$f":"Inputs!W42","v":1621698.7550137709},{"$f":"Inputs!AF42","v":0},{"$f":"Inputs!AL42","v":0},{"$f":"Inputs!D42","v":258275},{"$f":"Inputs!F42","v":1063100},{"$f":"Inputs!G42","v":1033100},{"$f":"Inputs!J42","v":389831.43149369489},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B43","v":80},{"$f":"Inputs!K43","v":0},{"$f":"Inputs!L43","v":0},{"$f":"Inputs!W43","v":1686566.7052143218},{"$f":"Inputs!AF43","v":0},{"$f":"Inputs!AL43","v":0},{"$f":"Inputs!D43","v":258275},{"$f":"Inputs!F43","v":1063100},{"$f":"Inputs!G43","v":1033100},{"$f":"Inputs!J43","v":405424.68875344272},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B44","v":81},{"$f":"Inputs!K44","v":0},{"$f":"Inputs!L44","v":0},{"$f":"Inputs!W44","v":1754029.3734228949},{"$f":"Inputs!AF44","v":0},{"$f":"Inputs!AL44","v":0},{"$f":"Inputs!D44","v":258275},{"$f":"Inputs!F44","v":1063100},{"$f":"Inputs!G44","v":1033100},{"$f":"Inputs!J44","v":421641.67630358046},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B45","v":82},{"$f":"Inputs!K45","v":0},{"$f":"Inputs!L45","v":0},{"$f":"Inputs!W45","v":1824190.5483598106},{"$f":"Inputs!AF45","v":0},{"$f":"Inputs!AL45","v":0},{"$f":"Inputs!D45","v":258275},{"$f":"Inputs!F45","v":1063100},{"$f":"Inputs!G45","v":1033100},{"$f":"Inputs!J45","v":438507.34335572371},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B46","v":83},{"$f":"Inputs!K46","v":0},{"$f":"Inputs!L46","v":0},{"$f":"Inputs!W46","v":1897158.1702942031},{"$f":"Inputs!AF46","v":0},{"$f":"Inputs!AL46","v":0},{"$f":"Inputs!D46","v":258275},{"$f":"Inputs!F46","v":1063100},{"$f":"Inputs!G46","v":1033100},{"$f":"Inputs!J46","v":456047.63708995265},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B47","v":84},{"$f":"Inputs!K47","v":0},{"$f":"Inputs!L47","v":0},{"$f":"Inputs!W47","v":1973044.4971059712},{"$f":"Inputs!AF47","v":0},{"$f":"Inputs!AL47","v":0},{"$f":"Inputs!D47","v":258275},{"$f":"Inputs!F47","v":1063100},{"$f":"Inputs!G47","v":1033100},{"$f":"Inputs!J47","v":474289.54257355077},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B48","v":85},{"$f":"Inputs!K48","v":0},{"$f":"Inputs!L48","v":0},{"$f":"Inputs!W48","v":2051966.2769902102},{"$f":"Inputs!AF48","v":0},{"$f":"Inputs!AL48","v":0},{"$f":"Inputs!D48","v":258275},{"$f":"Inputs!F48","v":1063100},{"$f":"Inputs!G48","v":1033100},{"$f":"Inputs!J48","v":493261.1242764928},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B49","v":86},{"$f":"Inputs!K49","v":0},{"$f":"Inputs!L49","v":0},{"$f":"Inputs!W49","v":2134044.9280698188},{"$f":"Inputs!AF49","v":0},{"$f":"Inputs!AL49","v":0},{"$f":"Inputs!D49","v":258275},{"$f":"Inputs!F49","v":1063100},{"$f":"Inputs!G49","v":1033100},{"$f":"Inputs!J49","v":512991.56924755254},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B50","v":87},{"$f":"Inputs!K50","v":0},{"$f":"Inputs!L50","v":0},{"$f":"Inputs!W50","v":2219406.7251926116},{"$f":"Inputs!AF50","v":0},{"$f":"Inputs!AL50","v":0},{"$f":"Inputs!D50","v":258275},{"$f":"Inputs!F50","v":1063100},{"$f":"Inputs!G50","v":1033100},{"$f":"Inputs!J50","v":533511.23201745469},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B51","v":88},{"$f":"Inputs!K51","v":0},{"$f":"Inputs!L51","v":0},{"$f":"Inputs!W51","v":2308182.9942003163},{"$f":"Inputs!AF51","v":0},{"$f":"Inputs!AL51","v":0},{"$f":"Inputs!D51","v":258275},{"$f":"Inputs!F51","v":1063100},{"$f":"Inputs!G51","v":1033100},{"$f":"Inputs!J51","v":554851.68129815289},258275,null,268275,268275]
[null,null,null,null,{"$f":"Inputs!B52","v":89},{"$f":"Inputs!K52","v":0},{"$f":"Inputs!L52","v":0},{"$f":"Inputs!W52","v":2400510.3139683288},{"$f":"Inputs!AF52","v":0},{"$f":"Inputs!AL52","v":0},{"$f":"Inputs!D52","v":258275},{"$f":"Inputs!F52","v":1063100},{"$f":"Inputs!G52","v":1033100},{"$f":"Inputs!J52","v":577045.74855007906},258275,null,268275,268275]

{"sheet":"LSDBA Chart","index":6,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Age","Tax Free","Income",{"$f":"Inputs!I11","v":"Unvested Pot"},{"$f":"Inputs!Z11","v":"Post April 2024 drawdown"},{"$f":"Inputs!AH11","v":"Pre April 2024 drawdown"},{"$f":"Inputs!D12","v":"LSA"},{"$f":"Inputs!F12","v":"LSDBA"}]
[null,null,null,null,{"$f":"Inputs!B13","v":50},{"$f":"Inputs!K13","v":0},{"$f":"Inputs!L13","v":0},{"$f":"Inputs!W13","v":520000},{"$f":"Inputs!AF13","v":0},{"$f":"Inputs!AL13","v":0},{"$f":"Inputs!D13","v":268275},{"$f":"Inputs!F13","v":1073100}]
[null,null,null,null,{"$f":"Inputs!B14","v":51},{"$f":"Inputs!K14","v":0},{"$f":"Inputs!L14","v":0},{"$f":"Inputs!W14","v":540800},{"$f":"Inputs!AF14","v":0},{"$f":"Inputs!AL14","v":0},{"$f":"Inputs!D14","v":268275},{"$f":"Inputs!F14","v":1073100}]
[null,null,null,null,{"$f":"Inputs!B15","v":52},{"$f":"Inputs!K15","v":0},{"$f":"Inputs!L15","v":0},{"$f":"Inputs!W15","v":562432},{"$f":"Inputs!AF15","v":0},{"$f":"Inputs!AL15","v":0},{"$f":"Inputs!D15","v":268275},{"$f":"Inputs!F15","v":1073100}]
[null,null,null,null,{"$f":"Inputs!B16","v":53},{"$f":"Inputs!K16","v":0},{"$f":"Inputs!L16","v":0},{"$f":"Inputs!W16","v":584929.28000000003},{"$f":"Inputs!AF16","v":0},{"$f":"Inputs!AL16","v":0},{"$f":"Inputs!D16","v":268275},{"$f":"Inputs!F16","v":1073100}]
[null,null,null,null,{"$f":"Inputs!B17","v":54},{"$f":"Inputs!K17","v":0},{"$f":"Inputs!L17","v":0},{"$f":"Inputs!W17","v":608326.45120000001},{"$f":"Inputs!AF17","v":0},{"$f":"Inputs!AL17","v":0},{"$f":"Inputs!D17","v":268275},{"$f":"Inputs!F17","v":1073100}]
[null,null,null,null,{"$f":"Inputs!B18","v":55},{"$f":"Inputs!K18","v":0},{"$f":"Inputs!L18","v":0},{"$f":"Inputs!W18","v":632659.50924799999},{"$f":"Inputs!AF18","v":0},{"$f":"Inputs!AL18","v":0},{"$f":"Inputs!D18","v":268275},{"$f":"Inputs!F18","v":1073100}]
[null,null,null,null,{"$f":"Inputs!B19","v":56},{"$f":"Inputs!K19","v":0},{"$f":"Inputs!L19","v":0},{"$f":"Inputs!W19","v":657965.88961792004},{"$f":"Inputs!AF19","v":0},{"$f":"Inputs!AL19","v":0},{"$f":"Inputs!D19","v":268275},{"$f":"Inputs!F19","v":1073100}]
[null,null,null,null,{"$f":"Inputs!B20","v":57},{"$f":"Inputs!K20","v":0},{"$f":"Inputs!L20","v":0},{"$f":"Inputs!W20","v":684284.52520263684},{"$f":"Inputs!AF20","v":0},{"$f":"Inputs!AL20","v":0},{"$f":"Inputs!D20","v":268275},{"$f":"Inputs!F20","v":1073100}]
[null,null,null,null,{"$f":"Inputs!B21","v":58},{"$f":"Inputs!K21","v":0},{"$f":"Inputs!L21","v":0},{"$f":"Inputs!W21","v":711655.90621074231},{"$f":"Inputs!AF21","v":0},{"$f":"Inputs!AL21","v":0},{"$f":"Inputs!D21","v":268275},{"$f":"Inputs!F21","v":1073100}]
[null,null,null,null,{"$f":"Inputs!B22","v":59},{"$f":"Inputs!K22","v":0},{"$f":"Inputs!L22","v":0},{"$f":"Inputs!W22","v":740122.14245917206},{"$f":"Inputs!AF22","v":0},{"$f":"Inputs!AL22","v":0},{"$f":"Inputs!D22","v":268275},{"$f":"Inputs!F22","v":1073100}]
[null,null,null,null,{"$f":"Inputs!B23","v":60},{"$f":"Inputs!K23","v":0},{"$f":"Inputs!L23","v":0},{"$f":"Inputs!W23","v":769727.02815753897},{"$f":"Inputs!AF23","v":0},{"$f":"Inputs!AL23","v":0},{"$f":"Inputs!D23","v":258275},{"$f":"Inputs!F23","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B24","v":61},{"$f":"Inputs!K24","v":0},{"$f":"Inputs!L24","v":0},{"$f":"Inputs!W24","v":800516.10928384052},{"$f":"Inputs!AF24","v":0},{"$f":"Inputs!AL24","v":0},{"$f":"Inputs!D24","v":258275},{"$f":"Inputs!F24","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B25","v":62},{"$f":"Inputs!K25","v":0},{"$f":"Inputs!L25","v":0},{"$f":"Inputs!W25","v":832536.75365519419},{"$f":"Inputs!AF25","v":0},{"$f":"Inputs!AL25","v":0},{"$f":"Inputs!D25","v":258275},{"$f":"Inputs!F25","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B26","v":63},{"$f":"Inputs!K26","v":0},{"$f":"Inputs!L26","v":0},{"$f":"Inputs!W26","v":865838.22380140203},{"$f":"Inputs!AF26","v":0},{"$f":"Inputs!AL26","v":0},{"$f":"Inputs!D26","v":258275},{"$f":"Inputs!F26","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B27","v":64},{"$f":"Inputs!K27","v":0},{"$f":"Inputs!L27","v":0},{"$f":"Inputs!W27","v":900471.7527534581},{"$f":"Inputs!AF27","v":0},{"$f":"Inputs!AL27","v":0},{"$f":"Inputs!D27","v":258275},{"$f":"Inputs!F27","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B28","v":65},{"$f":"Inputs!K28","v":0},{"$f":"Inputs!L28","v":0},{"$f":"Inputs!W28","v":936490.62286359642},{"$f":"Inputs!AF28","v":0},{"$f":"Inputs!AL28","v":0},{"$f":"Inputs!D28","v":258275},{"$f":"Inputs!F28","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B29","v":66},{"$f":"Inputs!K29","v":0},{"$f":"Inputs!L29","v":0},{"$f":"Inputs!W29","v":973950.24777814036},{"$f":"Inputs!AF29","v":0},{"$f":"Inputs!AL29","v":0},{"$f":"Inputs!D29","v":258275},{"$f":"Inputs!F29","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B30","v":67},{"$f":"Inputs!K30","v":0},{"$f":"Inputs!L30","v":0},{"$f":"Inputs!W30","v":1012908.257689266},{"$f":"Inputs!AF30","v":0},{"$f":"Inputs!AL30","v":0},{"$f":"Inputs!D30","v":258275},{"$f":"Inputs!F30","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B31","v":68},{"$f":"Inputs!K31","v":0},{"$f":"Inputs!L31","v":0},{"$f":"Inputs!W31","v":1053424.5879968368},{"$f":"Inputs!AF31","v":0},{"$f":"Inputs!AL31","v":0},{"$f":"Inputs!D31","v":258275},{"$f":"Inputs!F31","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B32","v":69},{"$f":"Inputs!K32","v":0},{"$f":"Inputs!L32","v":0},{"$f":"Inputs!W32","v":1095561.5715167103},{"$f":"Inputs!AF32","v":0},{"$f":"Inputs!AL32","v":0},{"$f":"Inputs!D32","v":258275},{"$f":"Inputs!F32","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B33","v":70},{"$f":"Inputs!K33","v":0},{"$f":"Inputs!L33","v":0},{"$f":"Inputs!W33","v":1139384.0343773789},{"$f":"Inputs!AF33","v":0},{"$f":"Inputs!AL33","v":0},{"$f":"Inputs!D33","v":258275},{"$f":"Inputs!F33","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B34","v":71},{"$f":"Inputs!K34","v":0},{"$f":"Inputs!L34","v":0},{"$f":"Inputs!W34","v":1184959.395752474},{"$f":"Inputs!AF34","v":0},{"$f":"Inputs!AL34","v":0},{"$f":"Inputs!D34","v":258275},{"$f":"Inputs!F34","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B35","v":72},{"$f":"Inputs!K35","v":0},{"$f":"Inputs!L35","v":0},{"$f":"Inputs!W35","v":1232357.771582573},{"$f":"Inputs!AF35","v":0},{"$f":"Inputs!AL35","v":0},{"$f":"Inputs!D35","v":258275},{"$f":"Inputs!F35","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B36","v":73},{"$f":"Inputs!K36","v":0},{"$f":"Inputs!L36","v":0},{"$f":"Inputs!W36","v":1281652.082445876},{"$f":"Inputs!AF36","v":0},{"$f":"Inputs!AL36","v":0},{"$f":"Inputs!D36","v":258275},{"$f":"Inputs!F36","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B37","v":74},{"$f":"Inputs!K37","v":0},{"$f":"Inputs!L37","v":0},{"$f":"Inputs!W37","v":1332918.1657437112},{"$f":"Inputs!AF37","v":0},{"$f":"Inputs!AL37","v":0},{"$f":"Inputs!D37","v":258275},{"$f":"Inputs!F37","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B38","v":75},{"$f":"Inputs!K38","v":0},{"$f":"Inputs!L38","v":0},{"$f":"Inputs!W38","v":1386234.8923734596},{"$f":"Inputs!AF38","v":0},{"$f":"Inputs!AL38","v":0},{"$f":"Inputs!D38","v":258275},{"$f":"Inputs!F38","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B39","v":76},{"$f":"Inputs!K39","v":0},{"$f":"Inputs!L39","v":0},{"$f":"Inputs!W39","v":1441684.2880683981},{"$f":"Inputs!AF39","v":0},{"$f":"Inputs!AL39","v":0},{"$f":"Inputs!D39","v":258275},{"$f":"Inputs!F39","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B40","v":77},{"$f":"Inputs!K40","v":0},{"$f":"Inputs!L40","v":0},{"$f":"Inputs!W40","v":1499351.6595911342},{"$f":"Inputs!AF40","v":0},{"$f":"Inputs!AL40","v":0},{"$f":"Inputs!D40","v":258275},{"$f":"Inputs!F40","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B41","v":78},{"$f":"Inputs!K41","v":0},{"$f":"Inputs!L41","v":0},{"$f":"Inputs!W41","v":1559325.7259747796},{"$f":"Inputs!AF41","v":0},{"$f":"Inputs!AL41","v":0},{"$f":"Inputs!D41","v":258275},{"$f":"Inputs!F41","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B42","v":79},{"$f":"Inputs!K42","v":0},{"$f":"Inputs!L42","v":0},{"$f":"Inputs!W42","v":1621698.7550137709},{"$f":"Inputs!AF42","v":0},{"$f":"Inputs!AL42","v":0},{"$f":"Inputs!D42","v":258275},{"$f":"Inputs!F42","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B43","v":80},{"$f":"Inputs!K43","v":0},{"$f":"Inputs!L43","v":0},{"$f":"Inputs!W43","v":1686566.7052143218},{"$f":"Inputs!AF43","v":0},{"$f":"Inputs!AL43","v":0},{"$f":"Inputs!D43","v":258275},{"$f":"Inputs!F43","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B44","v":81},{"$f":"Inputs!K44","v":0},{"$f":"Inputs!L44","v":0},{"$f":"Inputs!W44","v":1754029.3734228949},{"$f":"Inputs!AF44","v":0},{"$f":"Inputs!AL44","v":0},{"$f":"Inputs!D44","v":258275},{"$f":"Inputs!F44","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B45","v":82},{"$f":"Inputs!K45","v":0},{"$f":"Inputs!L45","v":0},{"$f":"Inputs!W45","v":1824190.5483598106},{"$f":"Inputs!AF45","v":0},{"$f":"Inputs!AL45","v":0},{"$f":"Inputs!D45","v":258275},{"$f":"Inputs!F45","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B46","v":83},{"$f":"Inputs!K46","v":0},{"$f":"Inputs!L46","v":0},{"$f":"Inputs!W46","v":1897158.1702942031},{"$f":"Inputs!AF46","v":0},{"$f":"Inputs!AL46","v":0},{"$f":"Inputs!D46","v":258275},{"$f":"Inputs!F46","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B47","v":84},{"$f":"Inputs!K47","v":0},{"$f":"Inputs!L47","v":0},{"$f":"Inputs!W47","v":1973044.4971059712},{"$f":"Inputs!AF47","v":0},{"$f":"Inputs!AL47","v":0},{"$f":"Inputs!D47","v":258275},{"$f":"Inputs!F47","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B48","v":85},{"$f":"Inputs!K48","v":0},{"$f":"Inputs!L48","v":0},{"$f":"Inputs!W48","v":2051966.2769902102},{"$f":"Inputs!AF48","v":0},{"$f":"Inputs!AL48","v":0},{"$f":"Inputs!D48","v":258275},{"$f":"Inputs!F48","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B49","v":86},{"$f":"Inputs!K49","v":0},{"$f":"Inputs!L49","v":0},{"$f":"Inputs!W49","v":2134044.9280698188},{"$f":"Inputs!AF49","v":0},{"$f":"Inputs!AL49","v":0},{"$f":"Inputs!D49","v":258275},{"$f":"Inputs!F49","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B50","v":87},{"$f":"Inputs!K50","v":0},{"$f":"Inputs!L50","v":0},{"$f":"Inputs!W50","v":2219406.7251926116},{"$f":"Inputs!AF50","v":0},{"$f":"Inputs!AL50","v":0},{"$f":"Inputs!D50","v":258275},{"$f":"Inputs!F50","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B51","v":88},{"$f":"Inputs!K51","v":0},{"$f":"Inputs!L51","v":0},{"$f":"Inputs!W51","v":2308182.9942003163},{"$f":"Inputs!AF51","v":0},{"$f":"Inputs!AL51","v":0},{"$f":"Inputs!D51","v":258275},{"$f":"Inputs!F51","v":1063100}]
[null,null,null,null,{"$f":"Inputs!B52","v":89},{"$f":"Inputs!K52","v":0},{"$f":"Inputs!L52","v":0},{"$f":"Inputs!W52","v":2400510.3139683288},{"$f":"Inputs!AF52","v":0},{"$f":"Inputs!AL52","v":0},{"$f":"Inputs!D52","v":258275},{"$f":"Inputs!F52","v":1063100}]