{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Inputs","Sheet2"],"not_rendered":{"charts":0,"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":"Inputs","index":0,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[null,null,"Lump Sum Allowance and Lump Sum Death Benefit Allowance "]
[null,null,"Reductions for pre-6th April 2024 Benefit Crystallisation Events"]
[]
[null,"This calculator is designed to help you assess the impact of benefit crystallisation events (BCEs) that occurred"]
[null,"prior to 6th April 2024, on a client's lump sum allowance and lump sum death benefit allowance."]
[]
[null,"It compares the reduction to the allowances using the 'default' or 'standard' calculation with the reduction "]
[null,"using a Transitional Tax-Free Amount Certificate.  Please note that certificates must be obtained prior to the first"]
[null,"relevant crystallisation event after 5th April 2024.  Once in force, a certificate cannot be revoked."]
[]
[null,null,null,null,"Input Amounts Below"]
[null,"Select Protection Type (if any)",null,null,"None"]
[null,"Please Input Individual Protection Amount",null,null,1073100]
[]
[null,"Please provide total lifetime allowance % used as at 5th April 2024 (max 100%)*"]
[]
[null,"Total tax-free payments received prior to 6th April 2024**"]
[]
[null,"Has the client received a serious ill-health lump sum prior to 6th April 2024?",null,null,"No"]
[null,"Enter amount of serious-ill health lump sum",null,null,0]
[]
[]
[null,"Starting lump sum allowance",null,null,{"$f":"IF(E12=\"Individual Protection (any)\",E25*0.25,VLOOKUP(E12,Sheet2!$A$6:$C$15,3,FALSE)*0.25)","v":268275}]
[]
[null,"Starting lump sum and death benefit allowance",null,null,{"$f":"IF(E12=Sheet2!A10,Inputs!E13,VLOOKUP(E12,Sheet2!$A$6:$C$15,3,FALSE))","v":1073100}]
[]
[null,"Default adjustments to LSA",null,null,{"$f":"MAX(0,E15*0.25*E25)","v":0}]
[]
[null,"Default adjustments to LSDBA",null,null,{"$f":"MAX(0,E15*E25*IF(E19=\"No\",0.25,1))","v":0}]
[]
[]
[]
[]
[null,"Default Basis","Allowance","Used","Remaining"]
[null,"Lump sum allowance",{"$f":"VLOOKUP($E$12,Sheet2!$A$6:$C$10,3,FALSE)*0.25","v":268275},{"$f":"C35-E35","v":0},{"$f":"IF(E15<1,E23-E27,0)","v":268275}]
[null,"Lump sum and death benefit allowance",{"$f":"VLOOKUP($E$12,Sheet2!$A$6:$C$10,3,FALSE)","v":1073100},{"$f":"C36-E36","v":0},{"$f":"IF(E15<1,E25-E29,0)","v":1073100}]
[]
[null,"Transitional Tax-Free Amount Certificate","Allowance","Used","Remaining"]
[null,"Lump sum allowance",{"$f":"IF(E15=0,\"N/A\",VLOOKUP($E$12,Sheet2!$A$6:$C$10,3,FALSE)*0.25)","v":"N/A"},{"$f":"IF(E15=0,\"N/A\",C39-E39)","v":"N/A"},{"$f":"IF(E15=0,\"N/A\",MAX(0,E23-E17))","v":"N/A"}]
[null,"Lump sum and death benefit allowance",{"$f":"IF(E15=0,\"N/A\",VLOOKUP($E$12,Sheet2!$A$6:$C$10,3,FALSE))","v":"N/A"},{"$f":"IF(E15=0,\"N/A\",C40-E40)","v":"N/A"},{"$f":"IF(E15=0,\"N/A\",MAX(0,E25-E17-IF(E19=\"Yes\",E20,0)))","v":"N/A"}]
[]
[null,"* For clients aged 75 prior to 6 April 2024, only include BCE 5, 5A and 5B if the client received a tax-free lump sum "]
[null,"   between age 75 and 5th April 2024."]
[]
[null,"** Include all pension commencement lump sums and 25% of any uncrystallised funds pension lump sums."]
[]
[null,"Do not use for clients with enhanced or primary protection, or if pension benefits were taken prior to 6th April 2006."]
[]
[null,"Please note: - this calculator is provided by Integrated Financial Arrangements Limited for use only by professional "]
[null,"advisers registered to use the Transact platform.  It is based on our current understanding of the Finance Act 2024"]
[null," and draft HMRC guidance which may change at any time.  Changes may also apply retrospectively.   Any changes "]
[null,"could impact the figures provided."]
[]
[null,"The calculator and figures provided are for guidance and information only.  They do not, and are not intended to,"]
[null," constitute professional advice, a recommendation or a financial promotion."]
[]
[null,"Integrated Financial Arrangements Ltd. 4th Floor, 2 Gresham Street, London EC2V 7AD. Tel: 020 7608 4900."]
[null,"(Registered office: as above; Registered in England and Wales under number: 03727592). Authorised and regulated by"]
[null," the Financial Conduct Authority (entered on the Financial Services Register; no. 190856)."]

{"sheet":"Sheet2","index":1,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["Protection Types"]
[]
["None",null,1073100]
["Fixed Protection 2012",null,1800000]
["Fixed Protection 2014",null,1500000]
["Fixed Protection 2016",null,1250000]
["Individual Protection (any)",null,{"$f":"Inputs!E13","v":1073100}]
[]
[]
[]
[]
[]
[]
["Yes"]
["No"]
["Individual Protection 2016"]