{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Estate overview","Gifting details","Results","Data sheet","Current IHT calc","DoD IHT calc","DoD post gifting calc","Control sheet"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":8,"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":"Estate overview","index":0,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,12,46,13],[46,2,48,7],[15,2,15,7],[16,2,16,7],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[26,2,26,7],[24,9,24,10],[25,9,25,10],[26,9,26,10],[28,9,28,10],[17,2,17,7],[9,9,9,10],[11,2,11,7],[12,2,12,7],[13,2,13,7],[14,2,14,7],[18,2,18,7],[20,9,20,10],[24,2,24,7],[25,2,25,7],[17,9,17,10],[18,9,18,10],[34,9,34,10],[38,9,38,10],[40,9,40,10],[41,9,41,10],[32,9,32,10],[6,10,8,12],[42,9,42,10],[46,9,46,10],[9,12,10,13],[11,12,11,13],[12,12,12,13],[13,12,13,13],[14,12,14,13],[26,12,26,13],[15,12,15,13],[16,12,16,13],[17,12,17,13],[18,12,18,13],[24,12,24,13],[25,12,25,13],[33,9,33,10]]}
[]
[]
[]
[]
[null,null,null,null,"Inheritance Tax (IHT) Calculator - step 1"]
[]
[null,null,null,null,null,null,null,null,null,null,"or no previous or new           gifts go to Step 4 -"]
[null,null,"Enter assets and liabilities below",null,null,null,null,"Step 2 - "]
[]
[null,null,"Assets",null,null,null,null,null,null,"Current value",null,null,"Assumed value at death (if different)"]
[]
[null,null,"Value of main home",null,null,null,null,null,null,0]
[null,null,"Second home, business property/land",null,null,null,null,null,null,0]
[null,null,"Car(s), boat, etc",null,null,null,null,null,null,0]
[null,null,"Household contents and personal effects",null,null,null,null,null,null,0]
[null,null,"Bank and building society accounts",null,null,null,null,null,null,0]
[null,null,"Investments (stocks and shares, bonds, offshore accounts, ISAs)",null,null,null,null,null,null,0]
[null,null,"Life assurance policies (if not under trust)",null,null,null,null,null,null,0]
[null,null,"Pensions lump sum (if not under trust)",null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J12:K19)","v":0}]
[]
[null,null,"Less any liabilities "]
[]
[null,null,"Mortgage on main home",null,null,null,null,null,null,0]
[null,null,"Additional mortgage(s), loans, hire purchase, credit cards",null,null,null,null,null,null,0]
[null,null,"Other liabilities (tax bills etc.)",null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J25:K27)","v":0}]
[]
[null,null,"Nil rate bands available"]
[]
[null,null,"Current nil rate band 2023/24",null,null,null,null,null,null,{"$f":"Current_NRB","v":325000}]
[null,null,"Percentage of transferrable nil rate band available",null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Total",{"$f":"(J33+(J33*J34))","v":325000}]
[]
[null,null,"Residence nil rate band available"]
[]
[null,null,"Will residence be left to direct descendants?",null,null,null,null,null,null,"No"]
[]
[null,null,"Residence nil rate band (2023/24)",null,null,null,null,null,null,{"$f":"IF(J39=\"Yes\",Current_RNRB,0)","v":0}]
[null,null,"Percentage of transferrable residence nil rate band available",null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Total",{"$f":"MIN(MAX(J41+(J41*J42)-'Data sheet'!D2,0),MAX(J12-J25,0))","v":0}]
[]
[null,null,"Other"]
[]
[null,null,"Enter any specifc exemptions (E.G amount going to spouse / civil partner, business property relief, charitable legacy, downsizing addition)",null,null,null,null,null,null,0]

{"sheet":"Gifting details","index":1,"n_rows":33,"n_cols":32,"rows_kept":33,"cut":false,"hidden":false,"merged":[[7,9,7,10],[10,10,10,11],[22,10,22,11],[11,10,11,11],[12,10,12,11],[13,10,13,11],[14,10,14,11],[15,10,15,11],[16,10,16,11],[9,7,9,11],[4,3,4,7],[29,10,29,11],[30,10,30,11],[32,4,33,4],[32,9,33,11],[23,10,23,11],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[17,10,17,11],[18,10,18,11],[19,10,19,11],[20,10,20,11],[21,10,21,11]]}
[]
[]
[]
[]
[null,null,null,"     Inheritance Tax (IHT) Calculator - steps 2 & 3"]
[]
[]
[null,null,null,{"$f":"TODAY()","v":"2023-09-20"},{"$f":"DATE(YEAR(D8)-7,MONTH(D8),DAY(D8))","v":"2016-09-20"},null,null,"     Step 4 - "]
[]
[null,null,"Step 2 - Enter gifts in the last 14 years already made",null,null,null,null,"Step 3 - Proposed gifting strategy - items liable to IHT Entry Charge will show in red ",null,null,null,null,null,null,null,null,"Entry charge step 2",null,null,null,null,null,null,null,null,"Entry charge step 3"]
[null,null,"Date of gift dd/mm/yyy","Type of gift","Amount of gift (after exemptions)","Complete years since gift",null,"Date of gift dd/mm/yyy","Type of gift","Amount of gift (after exemptions)","Description e.g. discretionary trust",null,null,null,null,null,"Date of gift","Type","Amount ","Complete years","Rate","<7","Gifts within 7","Tax",null,"Date of gift","Type","Amount ","Rate","<7","Gifts within 7","Tax"]
[null,{"$f":"IF(C12=\"\",\"\",IFERROR(DATEDIF(C12,Results!F$11,\"y\"),0))","v":""},null,null,null,{"$f":"IF(C12=\"\",\"\",IFERROR(DATEDIF(C12,D$8,\"y\"),0))","v":""},{"$f":"IF(F12=\"\",\"\",IF(F12>=14,\"Remove\",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(H12=\"\",\"\",IFERROR(DATEDIF(H12,Results!F$11,\"y\"),0))","v":""},null,null,null,{"$f":"IF(C12=\"\",\"\",C12)","v":""},{"$f":"IF(D12=\"\",\"\",D12)","v":""},{"$f":"IF(E12=\"\",\"\",E12)","v":""},"",{"$f":"Liferate","v":0.2},{"$f":"IFERROR(DATE(YEAR(Q12)-7,MONTH(Q12),DAY(Q12)),\"\")","v":""},{"$f":"SUMIFS(S$12:S$31,Q$12:Q$31,\"<\"&Q12,Q$12:Q$31,\">\"&V12,R$12:R$31,\"<>\"&\"PET\")","v":0},{"$f":"IF(R12<>\"CLT\",0,MAX((S12-MAX(Current_NRB-W12,0)),0)*U12)","v":0},null,{"$f":"IF(H12=\"\",\"\",H12)","v":""},{"$f":"IF(I12=\"\",\"\",I12)","v":""},{"$f":"IF(J12=\"\",\"\",J12)","v":""},{"$f":"Liferate","v":0.2},{"$f":"IFERROR(DATE(YEAR(Z12)-7,MONTH(Z12),DAY(Z12)),\"\")","v":""},{"$f":"SUMIFS(AB$12:AB$31,Z$12:Z$31,\"<\"&Z12,Z$12:Z$31,\">\"&AD12,AA$12:AA$31,\"<>\"&\"PET\")+SUMIFS(S$12:S$31,Q$12:Q$31,\"<\"&Z12,Q$12:Q$31,\">\"&AD12,R$12:R$31,\"<>\"&\"PET\")","v":0},{"$f":"IF(AA12<>\"CLT\",0,MAX((AB12-MAX(Current_NRB-AE12,0)),0)*AC12)","v":0}]
[null,{"$f":"IF(C13=\"\",\"\",IFERROR(DATEDIF(C13,Results!F$11,\"y\"),0))","v":""},null,null,null,{"$f":"IF(C13=\"\",\"\",IFERROR(DATEDIF(C13,D$8,\"y\"),0))","v":""},{"$f":"IF(F13=\"\",\"\",IF(F13>=14,\"Remove\",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(H13=\"\",\"\",IFERROR(DATEDIF(H13,Results!F$11,\"y\"),0))","v":""},null,null,null,{"$f":"IF(C13=\"\",\"\",C13)","v":""},{"$f":"IF(D13=\"\",\"\",D13)","v":""},"","",0.2,{"$f":"IFERROR(DATE(YEAR(Q13)-7,MONTH(Q13),DAY(Q13)),\"\")","v":""},{"$f":"SUMIFS(S$12:S$31,Q$12:Q$31,\"<\"&Q13,Q$12:Q$31,\">\"&V13,R$12:R$31,\"<>\"&\"PET\")","v":0},0,null,{"$f":"IF(H13=\"\",\"\",H13)","v":""},{"$f":"IF(I13=\"\",\"\",I13)","v":""},{"$f":"IF(J13=\"\",\"\",J13)","v":""},0.2,{"$f":"IFERROR(DATE(YEAR(Z13)-7,MONTH(Z13),DAY(Z13)),\"\")","v":""},{"$f":"SUMIFS(AB$12:AB$31,Z$12:Z$31,\"<\"&Z13,Z$12:Z$31,\">\"&AD13,AA$12:AA$31,\"<>\"&\"PET\")+SUMIFS(S$12:S$31,Q$12:Q$31,\"<\"&Z13,Q$12:Q$31,\">\"&AD13,R$12:R$31,\"<>\"&\"PET\")","v":0},0]
[null,{"$f":"IF(C14=\"\",\"\",IFERROR(DATEDIF(C14,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H14=\"\",\"\",IFERROR(DATEDIF(H14,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",{"$f":"SUMIFS(S$12:S$31,Q$12:Q$31,\"<\"&Q14,Q$12:Q$31,\">\"&V14,R$12:R$31,\"<>\"&\"PET\")","v":0},0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C15=\"\",\"\",IFERROR(DATEDIF(C15,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H15=\"\",\"\",IFERROR(DATEDIF(H15,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C16=\"\",\"\",IFERROR(DATEDIF(C16,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H16=\"\",\"\",IFERROR(DATEDIF(H16,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C17=\"\",\"\",IFERROR(DATEDIF(C17,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H17=\"\",\"\",IFERROR(DATEDIF(H17,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C18=\"\",\"\",IFERROR(DATEDIF(C18,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H18=\"\",\"\",IFERROR(DATEDIF(H18,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C19=\"\",\"\",IFERROR(DATEDIF(C19,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H19=\"\",\"\",IFERROR(DATEDIF(H19,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C20=\"\",\"\",IFERROR(DATEDIF(C20,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H20=\"\",\"\",IFERROR(DATEDIF(H20,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C21=\"\",\"\",IFERROR(DATEDIF(C21,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H21=\"\",\"\",IFERROR(DATEDIF(H21,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C22=\"\",\"\",IFERROR(DATEDIF(C22,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H22=\"\",\"\",IFERROR(DATEDIF(H22,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C23=\"\",\"\",IFERROR(DATEDIF(C23,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H23=\"\",\"\",IFERROR(DATEDIF(H23,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C24=\"\",\"\",IFERROR(DATEDIF(C24,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H24=\"\",\"\",IFERROR(DATEDIF(H24,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C25=\"\",\"\",IFERROR(DATEDIF(C25,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H25=\"\",\"\",IFERROR(DATEDIF(H25,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C26=\"\",\"\",IFERROR(DATEDIF(C26,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H26=\"\",\"\",IFERROR(DATEDIF(H26,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C27=\"\",\"\",IFERROR(DATEDIF(C27,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H27=\"\",\"\",IFERROR(DATEDIF(H27,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C28=\"\",\"\",IFERROR(DATEDIF(C28,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H28=\"\",\"\",IFERROR(DATEDIF(H28,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C29=\"\",\"\",IFERROR(DATEDIF(C29,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H29=\"\",\"\",IFERROR(DATEDIF(H29,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C30=\"\",\"\",IFERROR(DATEDIF(C30,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H30=\"\",\"\",IFERROR(DATEDIF(H30,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,{"$f":"IF(C31=\"\",\"\",IFERROR(DATEDIF(C31,Results!F$11,\"y\"),0))","v":""},null,null,null,"","",null,null,null,null,null,{"$f":"IF(H31=\"\",\"\",IFERROR(DATEDIF(H31,Results!F$11,\"y\"),0))","v":""},null,null,null,"","","","",0.2,"",0,0,null,"","","",0.2,"",0,0]
[null,null,null,"Total",{"$f":"SUM(E12:E31)","v":0},null,null,null,"Total",{"$f":"SUM(J12:J31)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J32>'Estate overview'!J21,\"Insufficient money within estate to make gifts\",\"\")","v":""}]

{"sheet":"Results","index":2,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":false,"merged":[[4,3,4,6],[7,5,7,6],[8,5,8,6],[15,5,15,6],[16,5,16,6],[6,2,6,3],[6,4,6,6],[41,5,41,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[35,5,35,6],[7,7,8,8],[11,7,12,8],[38,7,39,8],[38,5,38,6],[39,5,39,6],[28,5,28,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[55,1,56,9],[58,1,58,9],[60,1,60,9],[46,1,48,9],[49,1,51,9],[52,1,53,9]]}
[]
[]
[]
[]
[null,null,null,"     Inheritance Tax (IHT) Calculator - step 4"]
[]
[null,null,"Client name"]
[null,null,"Estate currently liable to IHT",null,null,{"$f":"'Data sheet'!P29","v":0},null,"See calculation"]
[null,null,"Current IHT liability ",null,null,{"$f":"'Data sheet'!P31","v":0}]
[]
[null,null,"Enter assumed date of death (DOD)"]
[null,null,"Estate liable to IHT at DOD (pre gifting solutions)",null,null,{"$f":"IF(F11=\"\",\"Enter date of death above\",IFERROR('Data sheet'!X29,0))","v":"Enter date of death above"},null,"See calculation"]
[null,null,"IHT liability (pre gifting solutions)",null,null,{"$f":"IFERROR('Data sheet'!X31,0)","v":0}]
[]
[null,null,"Proposed gifting solutions (scroll down for impact)"]
[null,null,"Date of gift dd/mm/yyy","Type of gift","Amount of gift (after exemptions)","Description e.g. discretionary trust"]
[null,null,{"$f":"IF('Gifting details'!H12=\"\",\"\",'Gifting details'!H12)","v":""},{"$f":"IF('Gifting details'!I12=\"\",\"\",'Gifting details'!I12)","v":""},{"$f":"IF('Gifting details'!J12=\"\",\"\",'Gifting details'!J12)","v":""},{"$f":"IF('Gifting details'!K12=\"\",\"\",'Gifting details'!K12)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H13=\"\",\"\",'Gifting details'!H13)","v":""},{"$f":"IF('Gifting details'!I13=\"\",\"\",'Gifting details'!I13)","v":""},{"$f":"IF('Gifting details'!J13=\"\",\"\",'Gifting details'!J13)","v":""},{"$f":"IF('Gifting details'!K13=\"\",\"\",'Gifting details'!K13)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H14=\"\",\"\",'Gifting details'!H14)","v":""},{"$f":"IF('Gifting details'!I14=\"\",\"\",'Gifting details'!I14)","v":""},{"$f":"IF('Gifting details'!J14=\"\",\"\",'Gifting details'!J14)","v":""},{"$f":"IF('Gifting details'!K14=\"\",\"\",'Gifting details'!K14)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H15=\"\",\"\",'Gifting details'!H15)","v":""},{"$f":"IF('Gifting details'!I15=\"\",\"\",'Gifting details'!I15)","v":""},{"$f":"IF('Gifting details'!J15=\"\",\"\",'Gifting details'!J15)","v":""},{"$f":"IF('Gifting details'!K15=\"\",\"\",'Gifting details'!K15)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H16=\"\",\"\",'Gifting details'!H16)","v":""},{"$f":"IF('Gifting details'!I16=\"\",\"\",'Gifting details'!I16)","v":""},{"$f":"IF('Gifting details'!J16=\"\",\"\",'Gifting details'!J16)","v":""},{"$f":"IF('Gifting details'!K16=\"\",\"\",'Gifting details'!K16)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H17=\"\",\"\",'Gifting details'!H17)","v":""},{"$f":"IF('Gifting details'!I17=\"\",\"\",'Gifting details'!I17)","v":""},{"$f":"IF('Gifting details'!J17=\"\",\"\",'Gifting details'!J17)","v":""},{"$f":"IF('Gifting details'!K17=\"\",\"\",'Gifting details'!K17)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H18=\"\",\"\",'Gifting details'!H18)","v":""},{"$f":"IF('Gifting details'!I18=\"\",\"\",'Gifting details'!I18)","v":""},{"$f":"IF('Gifting details'!J18=\"\",\"\",'Gifting details'!J18)","v":""},{"$f":"IF('Gifting details'!K18=\"\",\"\",'Gifting details'!K18)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H19=\"\",\"\",'Gifting details'!H19)","v":""},{"$f":"IF('Gifting details'!I19=\"\",\"\",'Gifting details'!I19)","v":""},{"$f":"IF('Gifting details'!J19=\"\",\"\",'Gifting details'!J19)","v":""},{"$f":"IF('Gifting details'!K19=\"\",\"\",'Gifting details'!K19)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H20=\"\",\"\",'Gifting details'!H20)","v":""},{"$f":"IF('Gifting details'!I20=\"\",\"\",'Gifting details'!I20)","v":""},{"$f":"IF('Gifting details'!J20=\"\",\"\",'Gifting details'!J20)","v":""},{"$f":"IF('Gifting details'!K20=\"\",\"\",'Gifting details'!K20)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H21=\"\",\"\",'Gifting details'!H21)","v":""},{"$f":"IF('Gifting details'!I21=\"\",\"\",'Gifting details'!I21)","v":""},{"$f":"IF('Gifting details'!J21=\"\",\"\",'Gifting details'!J21)","v":""},{"$f":"IF('Gifting details'!K21=\"\",\"\",'Gifting details'!K21)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H22=\"\",\"\",'Gifting details'!H22)","v":""},{"$f":"IF('Gifting details'!I22=\"\",\"\",'Gifting details'!I22)","v":""},{"$f":"IF('Gifting details'!J22=\"\",\"\",'Gifting details'!J22)","v":""},{"$f":"IF('Gifting details'!K22=\"\",\"\",'Gifting details'!K22)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H23=\"\",\"\",'Gifting details'!H23)","v":""},{"$f":"IF('Gifting details'!I23=\"\",\"\",'Gifting details'!I23)","v":""},{"$f":"IF('Gifting details'!J23=\"\",\"\",'Gifting details'!J23)","v":""},{"$f":"IF('Gifting details'!K23=\"\",\"\",'Gifting details'!K23)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H24=\"\",\"\",'Gifting details'!H24)","v":""},{"$f":"IF('Gifting details'!I24=\"\",\"\",'Gifting details'!I24)","v":""},{"$f":"IF('Gifting details'!J24=\"\",\"\",'Gifting details'!J24)","v":""},{"$f":"IF('Gifting details'!K24=\"\",\"\",'Gifting details'!K24)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H25=\"\",\"\",'Gifting details'!H25)","v":""},{"$f":"IF('Gifting details'!I25=\"\",\"\",'Gifting details'!I25)","v":""},{"$f":"IF('Gifting details'!J25=\"\",\"\",'Gifting details'!J25)","v":""},{"$f":"IF('Gifting details'!K25=\"\",\"\",'Gifting details'!K25)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H26=\"\",\"\",'Gifting details'!H26)","v":""},{"$f":"IF('Gifting details'!I26=\"\",\"\",'Gifting details'!I26)","v":""},{"$f":"IF('Gifting details'!J26=\"\",\"\",'Gifting details'!J26)","v":""},{"$f":"IF('Gifting details'!K26=\"\",\"\",'Gifting details'!K26)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H27=\"\",\"\",'Gifting details'!H27)","v":""},{"$f":"IF('Gifting details'!I27=\"\",\"\",'Gifting details'!I27)","v":""},{"$f":"IF('Gifting details'!J27=\"\",\"\",'Gifting details'!J27)","v":""},{"$f":"IF('Gifting details'!K27=\"\",\"\",'Gifting details'!K27)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H28=\"\",\"\",'Gifting details'!H28)","v":""},{"$f":"IF('Gifting details'!I28=\"\",\"\",'Gifting details'!I28)","v":""},{"$f":"IF('Gifting details'!J28=\"\",\"\",'Gifting details'!J28)","v":""},{"$f":"IF('Gifting details'!K28=\"\",\"\",'Gifting details'!K28)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H29=\"\",\"\",'Gifting details'!H29)","v":""},{"$f":"IF('Gifting details'!I29=\"\",\"\",'Gifting details'!I29)","v":""},{"$f":"IF('Gifting details'!J29=\"\",\"\",'Gifting details'!J29)","v":""},{"$f":"IF('Gifting details'!K29=\"\",\"\",'Gifting details'!K29)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H30=\"\",\"\",'Gifting details'!H30)","v":""},{"$f":"IF('Gifting details'!I30=\"\",\"\",'Gifting details'!I30)","v":""},{"$f":"IF('Gifting details'!J30=\"\",\"\",'Gifting details'!J30)","v":""},{"$f":"IF('Gifting details'!K30=\"\",\"\",'Gifting details'!K30)","v":""}]
[null,null,{"$f":"IF('Gifting details'!H31=\"\",\"\",'Gifting details'!H31)","v":""},{"$f":"IF('Gifting details'!I31=\"\",\"\",'Gifting details'!I31)","v":""},{"$f":"IF('Gifting details'!J31=\"\",\"\",'Gifting details'!J31)","v":""},{"$f":"IF('Gifting details'!K31=\"\",\"\",'Gifting details'!K31)","v":""}]
[]
[]
[null,null,"Revised estate liable to IHT",null,null,{"$f":"IF(F11=\"\",\"Enter date of death above\",IFERROR('Data sheet'!AF29,0))","v":"Enter date of death above"},null,"See calculation"]
[null,null,"Revised IHT liability ",null,null,{"$f":"IFERROR('Data sheet'!AF31,0)","v":0}]
[]
[null,null,"IHT saving based on gifting solution",null,null,{"$f":"F13-F40","v":0}]
[]
[]
[]
[]
[null,"This financial planning tool provides the current IHT liability of your client based on the information you provide. In addition, it can show the value of any IHT liability at a future date entered by you (provisional date of death). Finally, you are able to enter a series of proposed gifts to show the IHT impact of these proposed gifts should they be made. "]
[]
[]
[null,"The results calculated by this tool are based on the information you provide. It is your responsibility to ensure that the information you have input into this tool is accurate, if it is not the figures provided following the calculation will not be correct and should not be relied upon. "]
[]
[]
[null,"Every care has been taken to ensure that the information contained in this tool is correct and in accordance with our understanding of the law relating to IHT and HM Revenue and Customs practice as at July 2023. This could change in the future. "]
[]
[]
[null,"You should be satisfied that the information you have entered and the results of any calculation are correct, before acting or refraining from acting in reliance upon the information given. "]
[]
[]
[null,"Quilter accepts no responsibility for actions taken or refrained from being taken following use of this financial planning tool."]
[]
[null,"More information on IHT can be found on our technical insights pages - www.quilter.com/help-and-support/technical-insights/"]

{"sheet":"Data sheet","index":3,"n_rows":112,"n_cols":33,"rows_kept":112,"cut":false,"hidden":true,"merged":[[23,17,24,22],[23,25,24,30],[23,9,24,14]]}
["Yes",null,"Estate above £2m",{"$f":"SUM('Estate overview'!J12:K19)-'Estate overview'!J29","v":0},{"$f":"SUM(X2:X9)-SUM(X12:X14)","v":0},{"$f":"SUM(AF2:AF9)-'Gifting details'!J32-SUM(AF12:AF14)","v":0},null,null,null,"Current IHT calc",null,null,null,null,null,null,null,"Revised IHT calc DOD",null,null,null,null,null,null,null,"Revised IHT calc with gifting plan"]
["No",null,"Taper",{"$f":"MAX((D1-Taper_limit)/2,0)","v":0},{"$f":"MAX((E1-Taper_limit)/2,0)","v":0},{"$f":"MAX((F1-Taper_limit)/2,0)","v":0},null,null,null,"Value of main home",null,null,null,null,null,{"$f":"'Estate overview'!J12","v":0},null,"Value of main home",null,null,null,null,null,{"$f":"IF('Estate overview'!M12=\"\",'Estate overview'!J12,'Estate overview'!M12)","v":0},null,"Value of main home",null,null,null,null,null,{"$f":"IF('Estate overview'!M12=\"\",'Estate overview'!J12,'Estate overview'!M12)","v":0}]
["RNRB:",null,null,null,null,null,null,null,null,"Second home, business property/land",null,null,null,null,null,{"$f":"'Estate overview'!J13","v":0},null,"Second home, business property/land",null,null,null,null,null,{"$f":"IF('Estate overview'!M13=\"\",'Estate overview'!J13,'Estate overview'!M13)","v":0},null,"Second home, business property/land",null,null,null,null,null,{"$f":"IF('Estate overview'!M13=\"\",'Estate overview'!J13,'Estate overview'!M13)","v":0}]
[175000,null,null,null,null,null,null,null,null,"Car(s), boat, etc",null,null,null,null,null,{"$f":"'Estate overview'!J14","v":0},null,"Car(s), boat, etc",null,null,null,null,null,{"$f":"IF('Estate overview'!M14=\"\",'Estate overview'!J14,'Estate overview'!M14)","v":0},null,"Car(s), boat, etc",null,null,null,null,null,{"$f":"IF('Estate overview'!M14=\"\",'Estate overview'!J14,'Estate overview'!M14)","v":0}]
["NRB:",null,null,null,null,null,null,null,null,"Household contents and personal effects",null,null,null,null,null,{"$f":"'Estate overview'!J15","v":0},null,"Household contents and personal effects",null,null,null,null,null,{"$f":"IF('Estate overview'!M15=\"\",'Estate overview'!J15,'Estate overview'!M15)","v":0},null,"Household contents and personal effects",null,null,null,null,null,{"$f":"IF('Estate overview'!M15=\"\",'Estate overview'!J15,'Estate overview'!M15)","v":0}]
[325000,null,null,null,null,null,null,null,null,"Bank and building society accounts",null,null,null,null,null,{"$f":"'Estate overview'!J16","v":0},null,"Bank and building society accounts",null,null,null,null,null,{"$f":"IF('Estate overview'!M16=\"\",'Estate overview'!J16,'Estate overview'!M16)","v":0},null,"Bank and building society accounts",null,null,null,null,null,{"$f":"IF('Estate overview'!M16=\"\",'Estate overview'!J16,'Estate overview'!M16)","v":0}]
["Taper limit",null,null,null,null,null,null,null,null,"Investments (stocks and shares, bonds, offshore accounts, ISAs)",null,null,null,null,null,{"$f":"'Estate overview'!J17","v":0},null,"Investments (stocks and shares, bonds, offshore accounts, ISAs)",null,null,null,null,null,{"$f":"IF('Estate overview'!M17=\"\",'Estate overview'!J17,'Estate overview'!M17)","v":0},null,"Investments (stocks and shares, bonds, offshore accounts, ISAs)",null,null,null,null,null,{"$f":"IF('Estate overview'!M17=\"\",'Estate overview'!J17,'Estate overview'!M17)","v":0}]
[2000000,null,null,null,null,null,null,null,null,"Life assurance policies (if not under trust)",null,null,null,null,null,{"$f":"'Estate overview'!J18","v":0},null,"Life assurance policies (if not under trust)",null,null,null,null,null,{"$f":"IF('Estate overview'!M18=\"\",'Estate overview'!J18,'Estate overview'!M18)","v":0},null,"Life assurance policies (if not under trust)",null,null,null,null,null,{"$f":"IF('Estate overview'!M18=\"\",'Estate overview'!J18,'Estate overview'!M18)","v":0}]
["IHT rate",null,null,null,null,null,null,null,null,"Pensions lump sum (if not under trust)",null,null,null,null,null,{"$f":"'Estate overview'!J19","v":0},null,"Pensions lump sum (if not under trust)",null,null,null,null,null,{"$f":"IF('Estate overview'!M19=\"\",'Estate overview'!J19,'Estate overview'!M19)","v":0},null,"Pensions lump sum (if not under trust)",null,null,null,null,null,{"$f":"IF('Estate overview'!M19=\"\",'Estate overview'!J19,'Estate overview'!M19)","v":0}]
[0.4,null,null,null,null,null,null,null,null,"Gifts within 7 years of death",null,null,null,null,null,{"$f":"SUMIFS(L$36:L$55,J$36:J$55,\"<\"&'Gifting details'!D8,J$36:J$55,\">\"&'Gifting details'!E8)","v":0},null,"Gifts within 7 years of death",null,null,null,null,null,{"$f":"SUMIF('Gifting details'!B12:B31,\"<\"&7,'Gifting details'!E12:E31)","v":0},null,"Gifts within 7 years of death",null,null,null,null,null,{"$f":"SUMIF('Gifting details'!B12:B31,\"<\"&7,'Gifting details'!E12:E31)+SUMIF('Gifting details'!M12:M31,\"<\"&7,'Gifting details'!J12:J31)","v":0}]
["Lifetime rate"]
[0.2,null,null,null,null,null,null,null,null,"Mortgages",null,null,null,null,null,{"$f":"'Estate overview'!J25","v":0},null,"Mortgages",null,null,null,null,null,{"$f":"IF('Estate overview'!M25=\"\",'Estate overview'!J25,'Estate overview'!M25)","v":0},null,"Mortgages",null,null,null,null,null,{"$f":"IF('Estate overview'!M25=\"\",'Estate overview'!J25,'Estate overview'!M25)","v":0}]
["PET",null,null,null,null,null,null,null,null,"Loans, hire purchase, credit cards",null,null,null,null,null,{"$f":"'Estate overview'!J26","v":0},null,"Loans, hire purchase, credit cards",null,null,null,null,null,{"$f":"IF('Estate overview'!M26=\"\",'Estate overview'!J26,'Estate overview'!M26)","v":0},null,"Loans, hire purchase, credit cards",null,null,null,null,null,{"$f":"IF('Estate overview'!M26=\"\",'Estate overview'!J26,'Estate overview'!M26)","v":0}]
["CLT",null,null,null,null,null,null,null,null,"Other liabilities (tax bills etc.)",null,null,null,null,null,{"$f":"'Estate overview'!J27","v":0},null,"Other liabilities (tax bills etc.)",null,null,null,null,null,{"$f":"IF('Estate overview'!M27=\"\",'Estate overview'!J27,'Estate overview'!M27)","v":0},null,"Other liabilities (tax bills etc.)",null,null,null,null,null,{"$f":"IF('Estate overview'!M27=\"\",'Estate overview'!J27,'Estate overview'!M27)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Current nil rate band",null,null,null,null,null,{"$f":"'Estate overview'!J33","v":325000},null,"Current nil rate band at DOD",null,null,null,null,null,{"$f":"LOOKUP(2,1/((Results!$F11>=$A19:$A112)*(Results!$F11<=$B19:$B112)),$C19:$C112)","v":{"$error":"#N/A"}},null,"Current nil rate band at DOD",null,null,null,null,null,{"$f":"LOOKUP(2,1/((Results!$F11>=$A19:$A112)*(Results!$F11<=$B19:$B112)),$C19:$C112)","v":{"$error":"#N/A"}}]
["NRB",null,null,null,null,"RNRB",null,"nil rate band",null,"Percentage of transferrable nil rate band available",null,null,null,null,null,{"$f":"'Estate overview'!J34","v":0},null,"Percentage of transferrable nil rate band available",null,null,null,null,null,{"$f":"'Estate overview'!$J34","v":0},null,"Percentage of transferrable nil rate band available",null,null,null,null,null,{"$f":"'Estate overview'!$J34","v":0}]
["From","To","Threshold/nil rate band",null,null,"2017-04-06","2018-04-05",100000,null,null,null,null,null,null,"Total",{"$f":"'Estate overview'!J35","v":325000},null,null,null,null,null,null,"Total",{"$f":"X16+(X16*X17)","v":{"$error":"#N/A"}},null,null,null,null,null,null,"Total",{"$f":"AF16+(AF16*AF17)","v":{"$error":"#N/A"}}]
["1986-03-18","1987-03-16",71000,null,null,"2018-04-06","2019-04-05",125000]
["1987-03-17","1988-03-14",90000,null,null,"2019-04-06","2020-04-05",150000,null,"Residence nil rate band",null,null,null,null,null,{"$f":"'Estate overview'!J41","v":0},null,"Residence nil rate band at DOD",null,null,null,null,null,{"$f":"IF('Estate overview'!J39=\"No\",0,LOOKUP(2,1/((Results!$F11>=$F18:$F93)*(Results!$F11<=$G18:$G93)),$H18:$H93))","v":0},null,"Residence nil rate band at DOD",null,null,null,null,null,{"$f":"IF('Estate overview'!J39=\"No\",0,LOOKUP(2,1/((Results!$F11>=$F18:$F93)*(Results!$F11<=$G18:$G93)),$H18:$H93))","v":0}]
["1988-03-15","1989-04-05",110000,null,null,"2020-04-06","2028-04-05",175000,null,"Percentage of transferrable residence nil rate band available",null,null,null,null,null,{"$f":"'Estate overview'!J42","v":0},null,"Percentage of transferrable residence nil rate band available",null,null,null,null,null,{"$f":"'Estate overview'!J42","v":0},null,"Percentage of transferrable residence nil rate band available",null,null,null,null,null,{"$f":"'Estate overview'!J42","v":0}]
["1989-04-06","1990-04-05",118000,null,null,"2028-04-06","2029-04-05",{"$f":"ROUNDUP(H21*102%,0)","v":178500},null,null,null,null,null,null,"Total",{"$f":"'Estate overview'!J43","v":0},null,null,null,null,null,null,"Total",{"$f":"MIN(MAX(X20+(X20*X21)-E2,0),MAX(X2-X12,0))","v":0},null,null,null,null,null,null,"Total",{"$f":"MIN(MAX(AF20+(AF20*AF21)-F2,0),MAX(AF2-AF12,0),MAX(SUM(AF2:AF9)-AF10,0))","v":0}]
["1990-04-06","1991-04-05",128000,null,null,"2029-04-06","2030-04-05",{"$f":"ROUNDUP(H22*102%,0)","v":182070}]
["1991-04-06","1992-03-09",140000,null,null,"2030-04-06","2031-04-05",{"$f":"ROUNDUP(H23*102%,0)","v":185712},null,"Enter any specifc exemptions (E.G amount going to spouse / civil partner, business property relief, charitable legacy)",null,null,null,null,null,{"$f":"'Estate overview'!J47","v":0},null,"Enter any specifc exemptions (E.G amount going to spouse / civil partner, business property relief, charitable legacy)",null,null,null,null,null,{"$f":"IF('Estate overview'!M47=\"\",'Estate overview'!J47,'Estate overview'!M47)","v":0},null,"Enter any specifc exemptions (E.G amount going to spouse / civil partner, business property relief, charitable legacy)",null,null,null,null,null,{"$f":"IF('Estate overview'!M47=\"\",'Estate overview'!J47,'Estate overview'!M47)","v":0}]
["1992-03-10","1995-04-05",150000,null,null,"2031-04-06","2032-04-05",{"$f":"ROUNDUP(H24*102%,0)","v":189427}]
["1995-04-06","1996-04-05",154000,null,null,"2032-04-06","2033-04-05",193216]
["1996-04-06","1997-04-05",200000,null,null,"2033-04-06","2034-04-05",197081,null,"Total assets, less liabilities  & exemptions",null,null,null,null,null,{"$f":"SUM(P2:P9)-SUM(P12:P14)-P24","v":0},null,"Total assets, less liabilities  & exemptions",null,null,null,null,null,{"$f":"SUM(X2:X9)-SUM(X12:X14)-X24","v":0},null,"Total assets, less liabilities  & exemptions",null,null,null,null,null,{"$f":"SUM(AF2:AF9)-'Gifting details'!J32-SUM(AF12:AF14)-AF24","v":0}]
["1997-04-06","1998-04-05",215000,null,null,"2034-04-06","2035-04-05",201023,null,"Total nil rate bands available",null,null,null,null,null,{"$f":"MAX(P18-P10,0)+P22","v":325000},null,"Total nil rate bands available",null,null,null,null,null,{"$f":"MAX(X18-X10,0)+X22","v":{"$error":"#N/A"}},null,"Total nil rate bands available",null,null,null,null,null,{"$f":"MAX(AF18-AF10,0)+AF22","v":{"$error":"#N/A"}}]
["1998-04-06","1999-04-05",223000,null,null,"2035-04-06","2036-04-05",205044,null,"Estate above nil rate bands",null,null,null,null,null,{"$f":"MAX(0,P27-P28)","v":0},null,"Estate above nil rate bands",null,null,null,null,null,{"$f":"MAX(0,X27-X28)","v":{"$error":"#N/A"}},null,"Estate above nil rate bands",null,null,null,null,null,{"$f":"MAX(0,AF27-AF28)","v":{"$error":"#N/A"}}]
["1999-04-06","2000-04-05",231000,null,null,"2036-04-06","2037-04-05",209145]
["2000-04-06","2001-04-05",234000,null,null,"2037-04-06","2038-04-05",213328,null,"IHT payable ",null,null,null,null,null,{"$f":"P29*IHTrate+Q56","v":0},null,"IHT payable ",null,null,null,null,null,{"$f":"X29*IHTrate+Y56","v":{"$error":"#N/A"}},null,"IHT payable",null,null,null,null,null,{"$f":"AF29*IHTrate+Y56+AG56","v":{"$error":"#N/A"}}]
["2001-04-06","2002-04-05",242000,null,null,"2038-04-06","2039-04-05",217595]
["2002-04-06","2003-04-05",250000,null,null,"2039-04-06","2040-04-05",221947]
["2003-04-06","2004-04-05",255000,null,null,"2040-04-06","2041-04-05",226386,null,"Current gifts",null,null,null,null,null,null,null,"Current gifts at date of death",null,null,null,null,null,null,null,"Current gifts after gifting plan"]
["2004-04-06","2005-04-05",263000,null,null,"2041-04-06","2042-04-05",230914,null,"Date of gift","Type","Amount ","Complete years","Rate","<7","Gifts within 7","Tax","Date of gift","Type","Amount ","Complete years","Rate","<7","Gifts within 7","Tax","Date of gift","Type","Amount ","Complete years","Rate","<7","Gifts within 7","Tax"]
["2005-04-06","2006-04-05",275000,null,null,"2042-04-06","2043-04-05",235533,null,{"$f":"IF('Gifting details'!C12=\"\",\"\",'Gifting details'!C12)","v":""},{"$f":"IF('Gifting details'!D12=\"\",\"\",IF(AND(M36<7,'Gifting details'!D12=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D12))","v":""},{"$f":"IF('Gifting details'!E12=\"\",\"\",'Gifting details'!E12)","v":""},{"$f":"IF('Gifting details'!F12=\"\",\"\",'Gifting details'!F12)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M36>=$J$63:$J$67)*(M36<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},{"$f":"IFERROR(DATE(YEAR(J36)-7,MONTH(J36),DAY(J36)),\"\")","v":""},{"$f":"SUMIFS(L$36:L$55,J$36:J$55,\"<\"&J36,J$36:J$55,\">\"&O36,K$36:K$55,\"<>\"&\"PET\")","v":0},{"$f":"MAX(0,IF(M36>6,0,MAX(0,L36-(MAX(0,P$18-P36)))*N36)-'Gifting details'!X12)","v":0},{"$f":"IF('Gifting details'!C12=\"\",\"\",'Gifting details'!C12)","v":""},{"$f":"IF('Gifting details'!D12=\"\",\"\",IF(AND(U36<7,'Gifting details'!D12=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D12))","v":""},{"$f":"IF('Gifting details'!E12=\"\",\"\",'Gifting details'!E12)","v":""},{"$f":"IF('Gifting details'!B12=\"\",\"\",'Gifting details'!B12)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U36>=$J$63:$J$67)*(U36<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},{"$f":"IFERROR(DATE(YEAR(R36)-7,MONTH(R36),DAY(R36)),\"\")","v":""},{"$f":"SUMIFS(T$36:T$55,R$36:R$55,\"<\"&R36,R$36:R$55,\">\"&W36,S$36:S$55,\"<>\"&\"PET\")","v":0},{"$f":"MAX(0,IF(U36>6,0,MAX(0,T36-(MAX(0,X$18-X36)))*V36)-'Gifting details'!X12)","v":0},{"$f":"IF('Gifting details'!H12=\"\",\"\",'Gifting details'!H12)","v":""},{"$f":"IF('Gifting details'!I12=\"\",\"\",IF(AND(AC36<7,'Gifting details'!I12=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I12))","v":""},{"$f":"IF('Gifting details'!J12=\"\",\"\",'Gifting details'!J12)","v":""},{"$f":"IF('Gifting details'!M12=\"\",\"\",'Gifting details'!M12)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC36>=$J$63:$J$67)*(AC36<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},{"$f":"IFERROR(DATE(YEAR(Z36)-7,MONTH(Z36),DAY(Z36)),\"\")","v":""},{"$f":"SUMIFS(AB$36:AB$55,Z$36:Z$55,\"<\"&Z36,Z$36:Z$55,\">\"&AE36,AA$36:AA$55,\"<>\"&\"PET\")+SUMIFS(T$36:T$55,R$36:R$55,\"<\"&Z36,R$36:R$55,\">\"&AE36)","v":0},{"$f":"MAX(0,IF(AC36>6,0,MAX(0,AB36-(MAX(0,AF$18-AF36)))*AD36)-'Gifting details'!AF12)","v":0}]
["2006-04-06","2007-04-05",285000,null,null,"2043-04-06","2044-04-05",240244,null,{"$f":"IF('Gifting details'!C13=\"\",\"\",'Gifting details'!C13)","v":""},{"$f":"IF('Gifting details'!D13=\"\",\"\",IF(AND(M37<7,'Gifting details'!D13=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D13))","v":""},{"$f":"IF('Gifting details'!E13=\"\",\"\",'Gifting details'!E13)","v":""},{"$f":"IF('Gifting details'!F13=\"\",\"\",'Gifting details'!F13)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M37>=$J$63:$J$67)*(M37<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},{"$f":"IFERROR(DATE(YEAR(J37)-7,MONTH(J37),DAY(J37)),\"\")","v":""},{"$f":"SUMIFS(L$36:L$55,J$36:J$55,\"<\"&J37,J$36:J$55,\">\"&O37,K$36:K$55,\"<>\"&\"PET\")","v":0},{"$f":"MAX(0,IF(M37>6,0,MAX(0,L37-(MAX(0,P$18-P37)))*N37)-'Gifting details'!X13)","v":0},{"$f":"IF('Gifting details'!C13=\"\",\"\",'Gifting details'!C13)","v":""},{"$f":"IF('Gifting details'!D13=\"\",\"\",IF(AND(U37<7,'Gifting details'!D13=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D13))","v":""},{"$f":"IF('Gifting details'!E13=\"\",\"\",'Gifting details'!E13)","v":""},{"$f":"IF('Gifting details'!B13=\"\",\"\",'Gifting details'!B13)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U37>=$J$63:$J$67)*(U37<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},{"$f":"IFERROR(DATE(YEAR(R37)-7,MONTH(R37),DAY(R37)),\"\")","v":""},{"$f":"SUMIFS(T$36:T$55,R$36:R$55,\"<\"&R37,R$36:R$55,\">\"&W37,S$36:S$55,\"<>\"&\"PET\")","v":0},{"$f":"MAX(0,IF(U37>6,0,MAX(0,T37-(MAX(0,X$18-X37)))*V37)-'Gifting details'!X13)","v":0},{"$f":"IF('Gifting details'!H13=\"\",\"\",'Gifting details'!H13)","v":""},{"$f":"IF('Gifting details'!I13=\"\",\"\",IF(AND(AC37<7,'Gifting details'!I13=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I13))","v":""},{"$f":"IF('Gifting details'!J13=\"\",\"\",'Gifting details'!J13)","v":""},{"$f":"IF('Gifting details'!M13=\"\",\"\",'Gifting details'!M13)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC37>=$J$63:$J$67)*(AC37<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},{"$f":"IFERROR(DATE(YEAR(Z37)-7,MONTH(Z37),DAY(Z37)),\"\")","v":""},{"$f":"SUMIFS(AB$36:AB$55,Z$36:Z$55,\"<\"&Z37,Z$36:Z$55,\">\"&AE37,AA$36:AA$55,\"<>\"&\"PET\")+SUMIFS(T$36:T$55,R$36:R$55,\"<\"&Z37,R$36:R$55,\">\"&AE37)","v":0},{"$f":"MAX(0,IF(AC37>6,0,MAX(0,AB37-(MAX(0,AF$18-AF37)))*AD37)-'Gifting details'!AF13)","v":0}]
["2007-04-06","2008-04-05",300000,null,null,"2044-04-06","2045-04-05",245049,null,{"$f":"IF('Gifting details'!C14=\"\",\"\",'Gifting details'!C14)","v":""},{"$f":"IF('Gifting details'!D14=\"\",\"\",IF(AND(M38<7,'Gifting details'!D14=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D14))","v":""},{"$f":"IF('Gifting details'!E14=\"\",\"\",'Gifting details'!E14)","v":""},{"$f":"IF('Gifting details'!F14=\"\",\"\",'Gifting details'!F14)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M38>=$J$63:$J$67)*(M38<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",{"$f":"SUMIFS(L$36:L$55,J$36:J$55,\"<\"&J38,J$36:J$55,\">\"&O38,K$36:K$55,\"<>\"&\"PET\")","v":0},{"$f":"MAX(0,IF(M38>6,0,MAX(0,L38-(MAX(0,P$18-P38)))*N38)-'Gifting details'!X14)","v":0},{"$f":"IF('Gifting details'!C14=\"\",\"\",'Gifting details'!C14)","v":""},{"$f":"IF('Gifting details'!D14=\"\",\"\",IF(AND(U38<7,'Gifting details'!D14=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D14))","v":""},{"$f":"IF('Gifting details'!E14=\"\",\"\",'Gifting details'!E14)","v":""},{"$f":"IF('Gifting details'!B14=\"\",\"\",'Gifting details'!B14)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U38>=$J$63:$J$67)*(U38<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U38>6,0,MAX(0,T38-(MAX(0,X$18-X38)))*V38)-'Gifting details'!X14)","v":0},{"$f":"IF('Gifting details'!H14=\"\",\"\",'Gifting details'!H14)","v":""},{"$f":"IF('Gifting details'!I14=\"\",\"\",IF(AND(AC38<7,'Gifting details'!I14=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I14))","v":""},{"$f":"IF('Gifting details'!J14=\"\",\"\",'Gifting details'!J14)","v":""},{"$f":"IF('Gifting details'!M14=\"\",\"\",'Gifting details'!M14)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC38>=$J$63:$J$67)*(AC38<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC38>6,0,MAX(0,AB38-(MAX(0,AF$18-AF38)))*AD38)-'Gifting details'!AF14)","v":0}]
["2008-04-06","2009-04-05",312000,null,null,"2045-04-06","2046-04-05",249950,null,{"$f":"IF('Gifting details'!C15=\"\",\"\",'Gifting details'!C15)","v":""},{"$f":"IF('Gifting details'!D15=\"\",\"\",IF(AND(M39<7,'Gifting details'!D15=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D15))","v":""},{"$f":"IF('Gifting details'!E15=\"\",\"\",'Gifting details'!E15)","v":""},{"$f":"IF('Gifting details'!F15=\"\",\"\",'Gifting details'!F15)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M39>=$J$63:$J$67)*(M39<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M39>6,0,MAX(0,L39-(MAX(0,P$18-P39)))*N39)-'Gifting details'!X15)","v":0},{"$f":"IF('Gifting details'!C15=\"\",\"\",'Gifting details'!C15)","v":""},{"$f":"IF('Gifting details'!D15=\"\",\"\",IF(AND(U39<7,'Gifting details'!D15=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D15))","v":""},{"$f":"IF('Gifting details'!E15=\"\",\"\",'Gifting details'!E15)","v":""},{"$f":"IF('Gifting details'!B15=\"\",\"\",'Gifting details'!B15)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U39>=$J$63:$J$67)*(U39<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U39>6,0,MAX(0,T39-(MAX(0,X$18-X39)))*V39)-'Gifting details'!X15)","v":0},{"$f":"IF('Gifting details'!H15=\"\",\"\",'Gifting details'!H15)","v":""},{"$f":"IF('Gifting details'!I15=\"\",\"\",IF(AND(AC39<7,'Gifting details'!I15=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I15))","v":""},{"$f":"IF('Gifting details'!J15=\"\",\"\",'Gifting details'!J15)","v":""},{"$f":"IF('Gifting details'!M15=\"\",\"\",'Gifting details'!M15)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC39>=$J$63:$J$67)*(AC39<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC39>6,0,MAX(0,AB39-(MAX(0,AF$18-AF39)))*AD39)-'Gifting details'!AF15)","v":0}]
["2009-04-06","2028-04-05",325000,null,null,"2046-04-06","2047-04-05",254949,null,{"$f":"IF('Gifting details'!C16=\"\",\"\",'Gifting details'!C16)","v":""},{"$f":"IF('Gifting details'!D16=\"\",\"\",IF(AND(M40<7,'Gifting details'!D16=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D16))","v":""},{"$f":"IF('Gifting details'!E16=\"\",\"\",'Gifting details'!E16)","v":""},{"$f":"IF('Gifting details'!F16=\"\",\"\",'Gifting details'!F16)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M40>=$J$63:$J$67)*(M40<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M40>6,0,MAX(0,L40-(MAX(0,P$18-P40)))*N40)-'Gifting details'!X16)","v":0},{"$f":"IF('Gifting details'!C16=\"\",\"\",'Gifting details'!C16)","v":""},{"$f":"IF('Gifting details'!D16=\"\",\"\",IF(AND(U40<7,'Gifting details'!D16=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D16))","v":""},{"$f":"IF('Gifting details'!E16=\"\",\"\",'Gifting details'!E16)","v":""},{"$f":"IF('Gifting details'!B16=\"\",\"\",'Gifting details'!B16)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U40>=$J$63:$J$67)*(U40<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U40>6,0,MAX(0,T40-(MAX(0,X$18-X40)))*V40)-'Gifting details'!X16)","v":0},{"$f":"IF('Gifting details'!H16=\"\",\"\",'Gifting details'!H16)","v":""},{"$f":"IF('Gifting details'!I16=\"\",\"\",IF(AND(AC40<7,'Gifting details'!I16=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I16))","v":""},{"$f":"IF('Gifting details'!J16=\"\",\"\",'Gifting details'!J16)","v":""},{"$f":"IF('Gifting details'!M16=\"\",\"\",'Gifting details'!M16)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC40>=$J$63:$J$67)*(AC40<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC40>6,0,MAX(0,AB40-(MAX(0,AF$18-AF40)))*AD40)-'Gifting details'!AF16)","v":0}]
["2028-04-06","2029-04-05",{"$f":"ROUNDUP(C40*102%,0)","v":331500},null,null,"2047-04-06","2048-04-05",260048,null,{"$f":"IF('Gifting details'!C17=\"\",\"\",'Gifting details'!C17)","v":""},{"$f":"IF('Gifting details'!D17=\"\",\"\",IF(AND(M41<7,'Gifting details'!D17=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D17))","v":""},{"$f":"IF('Gifting details'!E17=\"\",\"\",'Gifting details'!E17)","v":""},{"$f":"IF('Gifting details'!F17=\"\",\"\",'Gifting details'!F17)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M41>=$J$63:$J$67)*(M41<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M41>6,0,MAX(0,L41-(MAX(0,P$18-P41)))*N41)-'Gifting details'!X17)","v":0},{"$f":"IF('Gifting details'!C17=\"\",\"\",'Gifting details'!C17)","v":""},{"$f":"IF('Gifting details'!D17=\"\",\"\",IF(AND(U41<7,'Gifting details'!D17=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D17))","v":""},{"$f":"IF('Gifting details'!E17=\"\",\"\",'Gifting details'!E17)","v":""},{"$f":"IF('Gifting details'!B17=\"\",\"\",'Gifting details'!B17)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U41>=$J$63:$J$67)*(U41<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U41>6,0,MAX(0,T41-(MAX(0,X$18-X41)))*V41)-'Gifting details'!X17)","v":0},{"$f":"IF('Gifting details'!H17=\"\",\"\",'Gifting details'!H17)","v":""},{"$f":"IF('Gifting details'!I17=\"\",\"\",IF(AND(AC41<7,'Gifting details'!I17=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I17))","v":""},{"$f":"IF('Gifting details'!J17=\"\",\"\",'Gifting details'!J17)","v":""},{"$f":"IF('Gifting details'!M17=\"\",\"\",'Gifting details'!M17)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC41>=$J$63:$J$67)*(AC41<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC41>6,0,MAX(0,AB41-(MAX(0,AF$18-AF41)))*AD41)-'Gifting details'!AF17)","v":0}]
["2029-04-06","2030-04-05",{"$f":"ROUNDUP(C41*102%,0)","v":338130},null,null,"2048-04-06","2049-04-05",265249,null,{"$f":"IF('Gifting details'!C18=\"\",\"\",'Gifting details'!C18)","v":""},{"$f":"IF('Gifting details'!D18=\"\",\"\",IF(AND(M42<7,'Gifting details'!D18=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D18))","v":""},{"$f":"IF('Gifting details'!E18=\"\",\"\",'Gifting details'!E18)","v":""},{"$f":"IF('Gifting details'!F18=\"\",\"\",'Gifting details'!F18)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M42>=$J$63:$J$67)*(M42<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M42>6,0,MAX(0,L42-(MAX(0,P$18-P42)))*N42)-'Gifting details'!X18)","v":0},{"$f":"IF('Gifting details'!C18=\"\",\"\",'Gifting details'!C18)","v":""},{"$f":"IF('Gifting details'!D18=\"\",\"\",IF(AND(U42<7,'Gifting details'!D18=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D18))","v":""},{"$f":"IF('Gifting details'!E18=\"\",\"\",'Gifting details'!E18)","v":""},{"$f":"IF('Gifting details'!B18=\"\",\"\",'Gifting details'!B18)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U42>=$J$63:$J$67)*(U42<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U42>6,0,MAX(0,T42-(MAX(0,X$18-X42)))*V42)-'Gifting details'!X18)","v":0},{"$f":"IF('Gifting details'!H18=\"\",\"\",'Gifting details'!H18)","v":""},{"$f":"IF('Gifting details'!I18=\"\",\"\",IF(AND(AC42<7,'Gifting details'!I18=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I18))","v":""},{"$f":"IF('Gifting details'!J18=\"\",\"\",'Gifting details'!J18)","v":""},{"$f":"IF('Gifting details'!M18=\"\",\"\",'Gifting details'!M18)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC42>=$J$63:$J$67)*(AC42<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC42>6,0,MAX(0,AB42-(MAX(0,AF$18-AF42)))*AD42)-'Gifting details'!AF18)","v":0}]
["2030-04-06","2031-04-05",344893,null,null,"2049-04-06","2050-04-05",270554,null,{"$f":"IF('Gifting details'!C19=\"\",\"\",'Gifting details'!C19)","v":""},{"$f":"IF('Gifting details'!D19=\"\",\"\",IF(AND(M43<7,'Gifting details'!D19=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D19))","v":""},{"$f":"IF('Gifting details'!E19=\"\",\"\",'Gifting details'!E19)","v":""},{"$f":"IF('Gifting details'!F19=\"\",\"\",'Gifting details'!F19)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M43>=$J$63:$J$67)*(M43<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M43>6,0,MAX(0,L43-(MAX(0,P$18-P43)))*N43)-'Gifting details'!X19)","v":0},{"$f":"IF('Gifting details'!C19=\"\",\"\",'Gifting details'!C19)","v":""},{"$f":"IF('Gifting details'!D19=\"\",\"\",IF(AND(U43<7,'Gifting details'!D19=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D19))","v":""},{"$f":"IF('Gifting details'!E19=\"\",\"\",'Gifting details'!E19)","v":""},{"$f":"IF('Gifting details'!B19=\"\",\"\",'Gifting details'!B19)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U43>=$J$63:$J$67)*(U43<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U43>6,0,MAX(0,T43-(MAX(0,X$18-X43)))*V43)-'Gifting details'!X19)","v":0},{"$f":"IF('Gifting details'!H19=\"\",\"\",'Gifting details'!H19)","v":""},{"$f":"IF('Gifting details'!I19=\"\",\"\",IF(AND(AC43<7,'Gifting details'!I19=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I19))","v":""},{"$f":"IF('Gifting details'!J19=\"\",\"\",'Gifting details'!J19)","v":""},{"$f":"IF('Gifting details'!M19=\"\",\"\",'Gifting details'!M19)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC43>=$J$63:$J$67)*(AC43<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC43>6,0,MAX(0,AB43-(MAX(0,AF$18-AF43)))*AD43)-'Gifting details'!AF19)","v":0}]
["2031-04-06","2032-04-05",351791,null,null,"2050-04-06","2051-04-05",275966,null,{"$f":"IF('Gifting details'!C20=\"\",\"\",'Gifting details'!C20)","v":""},{"$f":"IF('Gifting details'!D20=\"\",\"\",IF(AND(M44<7,'Gifting details'!D20=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D20))","v":""},{"$f":"IF('Gifting details'!E20=\"\",\"\",'Gifting details'!E20)","v":""},{"$f":"IF('Gifting details'!F20=\"\",\"\",'Gifting details'!F20)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M44>=$J$63:$J$67)*(M44<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M44>6,0,MAX(0,L44-(MAX(0,P$18-P44)))*N44)-'Gifting details'!X20)","v":0},{"$f":"IF('Gifting details'!C20=\"\",\"\",'Gifting details'!C20)","v":""},{"$f":"IF('Gifting details'!D20=\"\",\"\",IF(AND(U44<7,'Gifting details'!D20=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D20))","v":""},{"$f":"IF('Gifting details'!E20=\"\",\"\",'Gifting details'!E20)","v":""},{"$f":"IF('Gifting details'!B20=\"\",\"\",'Gifting details'!B20)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U44>=$J$63:$J$67)*(U44<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U44>6,0,MAX(0,T44-(MAX(0,X$18-X44)))*V44)-'Gifting details'!X20)","v":0},{"$f":"IF('Gifting details'!H20=\"\",\"\",'Gifting details'!H20)","v":""},{"$f":"IF('Gifting details'!I20=\"\",\"\",IF(AND(AC44<7,'Gifting details'!I20=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I20))","v":""},{"$f":"IF('Gifting details'!J20=\"\",\"\",'Gifting details'!J20)","v":""},{"$f":"IF('Gifting details'!M20=\"\",\"\",'Gifting details'!M20)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC44>=$J$63:$J$67)*(AC44<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC44>6,0,MAX(0,AB44-(MAX(0,AF$18-AF44)))*AD44)-'Gifting details'!AF20)","v":0}]
["2032-04-06","2033-04-05",358827,null,null,"2051-04-06","2052-04-05",281486,null,{"$f":"IF('Gifting details'!C21=\"\",\"\",'Gifting details'!C21)","v":""},{"$f":"IF('Gifting details'!D21=\"\",\"\",IF(AND(M45<7,'Gifting details'!D21=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D21))","v":""},{"$f":"IF('Gifting details'!E21=\"\",\"\",'Gifting details'!E21)","v":""},{"$f":"IF('Gifting details'!F21=\"\",\"\",'Gifting details'!F21)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M45>=$J$63:$J$67)*(M45<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M45>6,0,MAX(0,L45-(MAX(0,P$18-P45)))*N45)-'Gifting details'!X21)","v":0},{"$f":"IF('Gifting details'!C21=\"\",\"\",'Gifting details'!C21)","v":""},{"$f":"IF('Gifting details'!D21=\"\",\"\",IF(AND(U45<7,'Gifting details'!D21=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D21))","v":""},{"$f":"IF('Gifting details'!E21=\"\",\"\",'Gifting details'!E21)","v":""},{"$f":"IF('Gifting details'!B21=\"\",\"\",'Gifting details'!B21)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U45>=$J$63:$J$67)*(U45<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U45>6,0,MAX(0,T45-(MAX(0,X$18-X45)))*V45)-'Gifting details'!X21)","v":0},{"$f":"IF('Gifting details'!H21=\"\",\"\",'Gifting details'!H21)","v":""},{"$f":"IF('Gifting details'!I21=\"\",\"\",IF(AND(AC45<7,'Gifting details'!I21=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I21))","v":""},{"$f":"IF('Gifting details'!J21=\"\",\"\",'Gifting details'!J21)","v":""},{"$f":"IF('Gifting details'!M21=\"\",\"\",'Gifting details'!M21)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC45>=$J$63:$J$67)*(AC45<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC45>6,0,MAX(0,AB45-(MAX(0,AF$18-AF45)))*AD45)-'Gifting details'!AF21)","v":0}]
["2033-04-06","2034-04-05",366004,null,null,"2052-04-06","2053-04-05",287116,null,{"$f":"IF('Gifting details'!C22=\"\",\"\",'Gifting details'!C22)","v":""},{"$f":"IF('Gifting details'!D22=\"\",\"\",IF(AND(M46<7,'Gifting details'!D22=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D22))","v":""},{"$f":"IF('Gifting details'!E22=\"\",\"\",'Gifting details'!E22)","v":""},{"$f":"IF('Gifting details'!F22=\"\",\"\",'Gifting details'!F22)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M46>=$J$63:$J$67)*(M46<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M46>6,0,MAX(0,L46-(MAX(0,P$18-P46)))*N46)-'Gifting details'!X22)","v":0},{"$f":"IF('Gifting details'!C22=\"\",\"\",'Gifting details'!C22)","v":""},{"$f":"IF('Gifting details'!D22=\"\",\"\",IF(AND(U46<7,'Gifting details'!D22=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D22))","v":""},{"$f":"IF('Gifting details'!E22=\"\",\"\",'Gifting details'!E22)","v":""},{"$f":"IF('Gifting details'!B22=\"\",\"\",'Gifting details'!B22)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U46>=$J$63:$J$67)*(U46<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U46>6,0,MAX(0,T46-(MAX(0,X$18-X46)))*V46)-'Gifting details'!X22)","v":0},{"$f":"IF('Gifting details'!H22=\"\",\"\",'Gifting details'!H22)","v":""},{"$f":"IF('Gifting details'!I22=\"\",\"\",IF(AND(AC46<7,'Gifting details'!I22=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I22))","v":""},{"$f":"IF('Gifting details'!J22=\"\",\"\",'Gifting details'!J22)","v":""},{"$f":"IF('Gifting details'!M22=\"\",\"\",'Gifting details'!M22)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC46>=$J$63:$J$67)*(AC46<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC46>6,0,MAX(0,AB46-(MAX(0,AF$18-AF46)))*AD46)-'Gifting details'!AF22)","v":0}]
["2034-04-06","2035-04-05",373325,null,null,"2053-04-06","2054-04-05",292859,null,{"$f":"IF('Gifting details'!C23=\"\",\"\",'Gifting details'!C23)","v":""},{"$f":"IF('Gifting details'!D23=\"\",\"\",IF(AND(M47<7,'Gifting details'!D23=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D23))","v":""},{"$f":"IF('Gifting details'!E23=\"\",\"\",'Gifting details'!E23)","v":""},{"$f":"IF('Gifting details'!F23=\"\",\"\",'Gifting details'!F23)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M47>=$J$63:$J$67)*(M47<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M47>6,0,MAX(0,L47-(MAX(0,P$18-P47)))*N47)-'Gifting details'!X23)","v":0},{"$f":"IF('Gifting details'!C23=\"\",\"\",'Gifting details'!C23)","v":""},{"$f":"IF('Gifting details'!D23=\"\",\"\",IF(AND(U47<7,'Gifting details'!D23=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D23))","v":""},{"$f":"IF('Gifting details'!E23=\"\",\"\",'Gifting details'!E23)","v":""},{"$f":"IF('Gifting details'!B23=\"\",\"\",'Gifting details'!B23)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U47>=$J$63:$J$67)*(U47<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U47>6,0,MAX(0,T47-(MAX(0,X$18-X47)))*V47)-'Gifting details'!X23)","v":0},{"$f":"IF('Gifting details'!H23=\"\",\"\",'Gifting details'!H23)","v":""},{"$f":"IF('Gifting details'!I23=\"\",\"\",IF(AND(AC47<7,'Gifting details'!I23=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I23))","v":""},{"$f":"IF('Gifting details'!J23=\"\",\"\",'Gifting details'!J23)","v":""},{"$f":"IF('Gifting details'!M23=\"\",\"\",'Gifting details'!M23)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC47>=$J$63:$J$67)*(AC47<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC47>6,0,MAX(0,AB47-(MAX(0,AF$18-AF47)))*AD47)-'Gifting details'!AF23)","v":0}]
["2035-04-06","2036-04-05",380792,null,null,"2054-04-06","2055-04-05",298717,null,{"$f":"IF('Gifting details'!C24=\"\",\"\",'Gifting details'!C24)","v":""},{"$f":"IF('Gifting details'!D24=\"\",\"\",IF(AND(M48<7,'Gifting details'!D24=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D24))","v":""},{"$f":"IF('Gifting details'!E24=\"\",\"\",'Gifting details'!E24)","v":""},{"$f":"IF('Gifting details'!F24=\"\",\"\",'Gifting details'!F24)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M48>=$J$63:$J$67)*(M48<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M48>6,0,MAX(0,L48-(MAX(0,P$18-P48)))*N48)-'Gifting details'!X24)","v":0},{"$f":"IF('Gifting details'!C24=\"\",\"\",'Gifting details'!C24)","v":""},{"$f":"IF('Gifting details'!D24=\"\",\"\",IF(AND(U48<7,'Gifting details'!D24=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D24))","v":""},{"$f":"IF('Gifting details'!E24=\"\",\"\",'Gifting details'!E24)","v":""},{"$f":"IF('Gifting details'!B24=\"\",\"\",'Gifting details'!B24)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U48>=$J$63:$J$67)*(U48<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U48>6,0,MAX(0,T48-(MAX(0,X$18-X48)))*V48)-'Gifting details'!X24)","v":0},{"$f":"IF('Gifting details'!H24=\"\",\"\",'Gifting details'!H24)","v":""},{"$f":"IF('Gifting details'!I24=\"\",\"\",IF(AND(AC48<7,'Gifting details'!I24=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I24))","v":""},{"$f":"IF('Gifting details'!J24=\"\",\"\",'Gifting details'!J24)","v":""},{"$f":"IF('Gifting details'!M24=\"\",\"\",'Gifting details'!M24)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC48>=$J$63:$J$67)*(AC48<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC48>6,0,MAX(0,AB48-(MAX(0,AF$18-AF48)))*AD48)-'Gifting details'!AF24)","v":0}]
["2036-04-06","2037-04-05",388408,null,null,"2055-04-06","2056-04-05",304692,null,{"$f":"IF('Gifting details'!C25=\"\",\"\",'Gifting details'!C25)","v":""},{"$f":"IF('Gifting details'!D25=\"\",\"\",IF(AND(M49<7,'Gifting details'!D25=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D25))","v":""},{"$f":"IF('Gifting details'!E25=\"\",\"\",'Gifting details'!E25)","v":""},{"$f":"IF('Gifting details'!F25=\"\",\"\",'Gifting details'!F25)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M49>=$J$63:$J$67)*(M49<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M49>6,0,MAX(0,L49-(MAX(0,P$18-P49)))*N49)-'Gifting details'!X25)","v":0},{"$f":"IF('Gifting details'!C25=\"\",\"\",'Gifting details'!C25)","v":""},{"$f":"IF('Gifting details'!D25=\"\",\"\",IF(AND(U49<7,'Gifting details'!D25=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D25))","v":""},{"$f":"IF('Gifting details'!E25=\"\",\"\",'Gifting details'!E25)","v":""},{"$f":"IF('Gifting details'!B25=\"\",\"\",'Gifting details'!B25)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U49>=$J$63:$J$67)*(U49<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U49>6,0,MAX(0,T49-(MAX(0,X$18-X49)))*V49)-'Gifting details'!X25)","v":0},{"$f":"IF('Gifting details'!H25=\"\",\"\",'Gifting details'!H25)","v":""},{"$f":"IF('Gifting details'!I25=\"\",\"\",IF(AND(AC49<7,'Gifting details'!I25=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I25))","v":""},{"$f":"IF('Gifting details'!J25=\"\",\"\",'Gifting details'!J25)","v":""},{"$f":"IF('Gifting details'!M25=\"\",\"\",'Gifting details'!M25)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC49>=$J$63:$J$67)*(AC49<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC49>6,0,MAX(0,AB49-(MAX(0,AF$18-AF49)))*AD49)-'Gifting details'!AF25)","v":0}]
["2037-04-06","2038-04-05",396177,null,null,"2056-04-06","2057-04-05",310786,null,{"$f":"IF('Gifting details'!C26=\"\",\"\",'Gifting details'!C26)","v":""},{"$f":"IF('Gifting details'!D26=\"\",\"\",IF(AND(M50<7,'Gifting details'!D26=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D26))","v":""},{"$f":"IF('Gifting details'!E26=\"\",\"\",'Gifting details'!E26)","v":""},{"$f":"IF('Gifting details'!F26=\"\",\"\",'Gifting details'!F26)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M50>=$J$63:$J$67)*(M50<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M50>6,0,MAX(0,L50-(MAX(0,P$18-P50)))*N50)-'Gifting details'!X26)","v":0},{"$f":"IF('Gifting details'!C26=\"\",\"\",'Gifting details'!C26)","v":""},{"$f":"IF('Gifting details'!D26=\"\",\"\",IF(AND(U50<7,'Gifting details'!D26=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D26))","v":""},{"$f":"IF('Gifting details'!E26=\"\",\"\",'Gifting details'!E26)","v":""},{"$f":"IF('Gifting details'!B26=\"\",\"\",'Gifting details'!B26)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U50>=$J$63:$J$67)*(U50<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U50>6,0,MAX(0,T50-(MAX(0,X$18-X50)))*V50)-'Gifting details'!X26)","v":0},{"$f":"IF('Gifting details'!H26=\"\",\"\",'Gifting details'!H26)","v":""},{"$f":"IF('Gifting details'!I26=\"\",\"\",IF(AND(AC50<7,'Gifting details'!I26=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I26))","v":""},{"$f":"IF('Gifting details'!J26=\"\",\"\",'Gifting details'!J26)","v":""},{"$f":"IF('Gifting details'!M26=\"\",\"\",'Gifting details'!M26)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC50>=$J$63:$J$67)*(AC50<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC50>6,0,MAX(0,AB50-(MAX(0,AF$18-AF50)))*AD50)-'Gifting details'!AF26)","v":0}]
["2038-04-06","2039-04-05",404101,null,null,"2057-04-06","2058-04-05",317002,null,{"$f":"IF('Gifting details'!C27=\"\",\"\",'Gifting details'!C27)","v":""},{"$f":"IF('Gifting details'!D27=\"\",\"\",IF(AND(M51<7,'Gifting details'!D27=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D27))","v":""},{"$f":"IF('Gifting details'!E27=\"\",\"\",'Gifting details'!E27)","v":""},{"$f":"IF('Gifting details'!F27=\"\",\"\",'Gifting details'!F27)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M51>=$J$63:$J$67)*(M51<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M51>6,0,MAX(0,L51-(MAX(0,P$18-P51)))*N51)-'Gifting details'!X27)","v":0},{"$f":"IF('Gifting details'!C27=\"\",\"\",'Gifting details'!C27)","v":""},{"$f":"IF('Gifting details'!D27=\"\",\"\",IF(AND(U51<7,'Gifting details'!D27=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D27))","v":""},{"$f":"IF('Gifting details'!E27=\"\",\"\",'Gifting details'!E27)","v":""},{"$f":"IF('Gifting details'!B27=\"\",\"\",'Gifting details'!B27)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U51>=$J$63:$J$67)*(U51<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U51>6,0,MAX(0,T51-(MAX(0,X$18-X51)))*V51)-'Gifting details'!X27)","v":0},{"$f":"IF('Gifting details'!H27=\"\",\"\",'Gifting details'!H27)","v":""},{"$f":"IF('Gifting details'!I27=\"\",\"\",IF(AND(AC51<7,'Gifting details'!I27=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I27))","v":""},{"$f":"IF('Gifting details'!J27=\"\",\"\",'Gifting details'!J27)","v":""},{"$f":"IF('Gifting details'!M27=\"\",\"\",'Gifting details'!M27)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC51>=$J$63:$J$67)*(AC51<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC51>6,0,MAX(0,AB51-(MAX(0,AF$18-AF51)))*AD51)-'Gifting details'!AF27)","v":0}]
["2039-04-06","2040-04-05",412184,null,null,"2058-04-06","2059-04-05",323343,null,{"$f":"IF('Gifting details'!C28=\"\",\"\",'Gifting details'!C28)","v":""},{"$f":"IF('Gifting details'!D28=\"\",\"\",IF(AND(M52<7,'Gifting details'!D28=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D28))","v":""},{"$f":"IF('Gifting details'!E28=\"\",\"\",'Gifting details'!E28)","v":""},{"$f":"IF('Gifting details'!F28=\"\",\"\",'Gifting details'!F28)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M52>=$J$63:$J$67)*(M52<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M52>6,0,MAX(0,L52-(MAX(0,P$18-P52)))*N52)-'Gifting details'!X28)","v":0},{"$f":"IF('Gifting details'!C28=\"\",\"\",'Gifting details'!C28)","v":""},{"$f":"IF('Gifting details'!D28=\"\",\"\",IF(AND(U52<7,'Gifting details'!D28=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D28))","v":""},{"$f":"IF('Gifting details'!E28=\"\",\"\",'Gifting details'!E28)","v":""},{"$f":"IF('Gifting details'!B28=\"\",\"\",'Gifting details'!B28)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U52>=$J$63:$J$67)*(U52<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U52>6,0,MAX(0,T52-(MAX(0,X$18-X52)))*V52)-'Gifting details'!X28)","v":0},{"$f":"IF('Gifting details'!H28=\"\",\"\",'Gifting details'!H28)","v":""},{"$f":"IF('Gifting details'!I28=\"\",\"\",IF(AND(AC52<7,'Gifting details'!I28=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I28))","v":""},{"$f":"IF('Gifting details'!J28=\"\",\"\",'Gifting details'!J28)","v":""},{"$f":"IF('Gifting details'!M28=\"\",\"\",'Gifting details'!M28)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC52>=$J$63:$J$67)*(AC52<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC52>6,0,MAX(0,AB52-(MAX(0,AF$18-AF52)))*AD52)-'Gifting details'!AF28)","v":0}]
["2040-04-06","2041-04-05",420428,null,null,"2059-04-06","2060-04-05",329810,null,{"$f":"IF('Gifting details'!C29=\"\",\"\",'Gifting details'!C29)","v":""},{"$f":"IF('Gifting details'!D29=\"\",\"\",IF(AND(M53<7,'Gifting details'!D29=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D29))","v":""},{"$f":"IF('Gifting details'!E29=\"\",\"\",'Gifting details'!E29)","v":""},{"$f":"IF('Gifting details'!F29=\"\",\"\",'Gifting details'!F29)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M53>=$J$63:$J$67)*(M53<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M53>6,0,MAX(0,L53-(MAX(0,P$18-P53)))*N53)-'Gifting details'!X29)","v":0},{"$f":"IF('Gifting details'!C29=\"\",\"\",'Gifting details'!C29)","v":""},{"$f":"IF('Gifting details'!D29=\"\",\"\",IF(AND(U53<7,'Gifting details'!D29=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D29))","v":""},{"$f":"IF('Gifting details'!E29=\"\",\"\",'Gifting details'!E29)","v":""},{"$f":"IF('Gifting details'!B29=\"\",\"\",'Gifting details'!B29)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U53>=$J$63:$J$67)*(U53<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U53>6,0,MAX(0,T53-(MAX(0,X$18-X53)))*V53)-'Gifting details'!X29)","v":0},{"$f":"IF('Gifting details'!H29=\"\",\"\",'Gifting details'!H29)","v":""},{"$f":"IF('Gifting details'!I29=\"\",\"\",IF(AND(AC53<7,'Gifting details'!I29=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I29))","v":""},{"$f":"IF('Gifting details'!J29=\"\",\"\",'Gifting details'!J29)","v":""},{"$f":"IF('Gifting details'!M29=\"\",\"\",'Gifting details'!M29)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC53>=$J$63:$J$67)*(AC53<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC53>6,0,MAX(0,AB53-(MAX(0,AF$18-AF53)))*AD53)-'Gifting details'!AF29)","v":0}]
["2041-04-06","2042-04-05",428837,null,null,"2060-04-06","2061-04-05",336407,null,{"$f":"IF('Gifting details'!C30=\"\",\"\",'Gifting details'!C30)","v":""},{"$f":"IF('Gifting details'!D30=\"\",\"\",IF(AND(M54<7,'Gifting details'!D30=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D30))","v":""},{"$f":"IF('Gifting details'!E30=\"\",\"\",'Gifting details'!E30)","v":""},{"$f":"IF('Gifting details'!F30=\"\",\"\",'Gifting details'!F30)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M54>=$J$63:$J$67)*(M54<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M54>6,0,MAX(0,L54-(MAX(0,P$18-P54)))*N54)-'Gifting details'!X30)","v":0},{"$f":"IF('Gifting details'!C30=\"\",\"\",'Gifting details'!C30)","v":""},{"$f":"IF('Gifting details'!D30=\"\",\"\",IF(AND(U54<7,'Gifting details'!D30=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D30))","v":""},{"$f":"IF('Gifting details'!E30=\"\",\"\",'Gifting details'!E30)","v":""},{"$f":"IF('Gifting details'!B30=\"\",\"\",'Gifting details'!B30)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U54>=$J$63:$J$67)*(U54<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U54>6,0,MAX(0,T54-(MAX(0,X$18-X54)))*V54)-'Gifting details'!X30)","v":0},{"$f":"IF('Gifting details'!H30=\"\",\"\",'Gifting details'!H30)","v":""},{"$f":"IF('Gifting details'!I30=\"\",\"\",IF(AND(AC54<7,'Gifting details'!I30=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I30))","v":""},{"$f":"IF('Gifting details'!J30=\"\",\"\",'Gifting details'!J30)","v":""},{"$f":"IF('Gifting details'!M30=\"\",\"\",'Gifting details'!M30)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC54>=$J$63:$J$67)*(AC54<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC54>6,0,MAX(0,AB54-(MAX(0,AF$18-AF54)))*AD54)-'Gifting details'!AF30)","v":0}]
["2042-04-06","2043-04-05",437414,null,null,"2061-04-06","2062-04-05",343136,null,{"$f":"IF('Gifting details'!C31=\"\",\"\",'Gifting details'!C31)","v":""},{"$f":"IF('Gifting details'!D31=\"\",\"\",IF(AND(M55<7,'Gifting details'!D31=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D31))","v":""},{"$f":"IF('Gifting details'!E31=\"\",\"\",'Gifting details'!E31)","v":""},{"$f":"IF('Gifting details'!F31=\"\",\"\",'Gifting details'!F31)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((M55>=$J$63:$J$67)*(M55<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(M55>6,0,MAX(0,L55-(MAX(0,P$18-P55)))*N55)-'Gifting details'!X31)","v":0},{"$f":"IF('Gifting details'!C31=\"\",\"\",'Gifting details'!C31)","v":""},{"$f":"IF('Gifting details'!D31=\"\",\"\",IF(AND(U55<7,'Gifting details'!D31=\"PET\"),\"Chargeable Transfer\",'Gifting details'!D31))","v":""},{"$f":"IF('Gifting details'!E31=\"\",\"\",'Gifting details'!E31)","v":""},{"$f":"IF('Gifting details'!B31=\"\",\"\",'Gifting details'!B31)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((U55>=$J$63:$J$67)*(U55<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(U55>6,0,MAX(0,T55-(MAX(0,X$18-X55)))*V55)-'Gifting details'!X31)","v":0},{"$f":"IF('Gifting details'!H31=\"\",\"\",'Gifting details'!H31)","v":""},{"$f":"IF('Gifting details'!I31=\"\",\"\",IF(AND(AC55<7,'Gifting details'!I31=\"PET\"),\"Chargeable Transfer\",'Gifting details'!I31))","v":""},{"$f":"IF('Gifting details'!J31=\"\",\"\",'Gifting details'!J31)","v":""},{"$f":"IF('Gifting details'!M31=\"\",\"\",'Gifting details'!M31)","v":""},{"$f":"IFERROR(LOOKUP(2,1/((AC55>=$J$63:$J$67)*(AC55<=$K$63:$K$67)),$L$63:$L$67),0)","v":0},"",0,{"$f":"MAX(0,IF(AC55>6,0,MAX(0,AB55-(MAX(0,AF$18-AF55)))*AD55)-'Gifting details'!AF31)","v":0}]
["2043-04-06","2044-04-05",446163,null,null,"2062-04-06","2063-04-05",349999,null,null,{"$f":"'Gifting details'!D32","v":"Total"},{"$f":"'Gifting details'!E32","v":0},null,null,null,null,{"$f":"SUM(Q36:Q55)","v":0},null,{"$f":"'Gifting details'!D32","v":"Total"},{"$f":"'Gifting details'!E32","v":0},null,null,null,null,{"$f":"SUM(Y36:Y55)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(AG36:AG55)","v":0}]
["2044-04-06","2045-04-05",455087,null,null,"2063-04-06","2064-04-05",356999]
["2045-04-06","2046-04-05",464189,null,null,"2064-04-06","2065-04-05",364139]
["2046-04-06","2047-04-05",473473,null,null,"2065-04-06","2066-04-05",371422]
["2047-04-06","2048-04-05",482943,null,null,"2066-04-06","2067-04-05",378851]
["2048-04-06","2049-04-05",492602,null,null,"2067-04-06","2068-04-05",386429]
["2049-04-06","2050-04-05",502455,null,null,"2068-04-06","2069-04-05",394158,null,"Taper rates"]
["2050-04-06","2051-04-05",512505,null,null,"2069-04-06","2070-04-05",402042,null,0,3,0.4]
["2051-04-06","2052-04-05",522756,null,null,"2070-04-06","2071-04-05",410083,null,3,4,0.32]
["2052-04-06","2053-04-05",533212,null,null,"2071-04-06","2072-04-05",418285,null,4,5,0.24]
["2053-04-06","2054-04-05",543877,null,null,"2072-04-06","2073-04-05",426651,null,5,6,0.16]
["2054-04-06","2055-04-05",554755,null,null,"2073-04-06","2074-04-05",435185,null,6,7,0.08]
["2055-04-06","2056-04-05",565851,null,null,"2074-04-06","2075-04-05",443889]
["2056-04-06","2057-04-05",577169,null,null,"2075-04-06","2076-04-05",452767]
["2057-04-06","2058-04-05",588713,null,null,"2076-04-06","2077-04-05",461823]
["2058-04-06","2059-04-05",600488,null,null,"2077-04-06","2078-04-05",471060]
["2059-04-06","2060-04-05",612498,null,null,"2078-04-06","2079-04-05",480482]
["2060-04-06","2061-04-05",624748,null,null,"2079-04-06","2080-04-05",490092]
["2061-04-06","2062-04-05",637243,null,null,"2080-04-06","2081-04-05",499894]
["2062-04-06","2063-04-05",649988,null,null,"2081-04-06","2082-04-05",509892]
["2063-04-06","2064-04-05",662988,null,null,"2082-04-06","2083-04-05",520090]
["2064-04-06","2065-04-05",676248,null,null,"2083-04-06","2084-04-05",530492]
["2065-04-06","2066-04-05",689773,null,null,"2084-04-06","2085-04-05",541102]
["2066-04-06","2067-04-05",703569,null,null,"2085-04-06","2086-04-05",551925]
["2067-04-06","2068-04-05",717641,null,null,"2086-04-06","2087-04-05",562964]
["2068-04-06","2069-04-05",731994,null,null,"2087-04-06","2088-04-05",574224]
["2069-04-06","2070-04-05",746634,null,null,"2088-04-06","2089-04-05",585709]
["2070-04-06","2071-04-05",761567,null,null,"2089-04-06","2090-04-05",597424]
["2071-04-06","2072-04-05",776799,null,null,"2090-04-06","2091-04-05",609373]
["2072-04-06","2073-04-05",792335,null,null,"2091-04-06","2092-04-05",621561]
["2073-04-06","2074-04-05",808182,null,null,"2092-04-06","2093-04-05",633993]
["2074-04-06","2075-04-05",824346,null,null,"2093-04-06","2094-04-05",646673]
["2075-04-06","2076-04-05",840833,null,null,"2094-04-06","2095-04-05",659607]
["2076-04-06","2077-04-05",857650,null,null,"2095-04-06","2096-04-05",{"$f":"ROUNDUP(H88*102%,0)","v":672800}]
["2077-04-06","2078-04-05",874803,null,null,"2096-04-06","2097-04-05",686256]
["2078-04-06","2079-04-05",892300,null,null,"2097-04-06","2098-04-05",699982]
["2079-04-06","2080-04-05",910146,null,null,"2098-04-06","2099-04-05",713982]
["2080-04-06","2081-04-05",928349,null,null,"2099-04-06","2100-04-05",728262]
["2081-04-06","2082-04-05",946916]
["2082-04-06","2083-04-05",965855]
["2083-04-06","2084-04-05",985173]
["2084-04-06","2085-04-05",1004877]
["2085-04-06","2086-04-05",1024975]
["2086-04-06","2087-04-05",1045475]
["2087-04-06","2088-04-05",1066385]
["2088-04-06","2089-04-05",1087713]
["2089-04-06","2090-04-05",1109468]
["2090-04-06","2091-04-05",1131658]
["2091-04-06","2092-04-05",1154292]
["2092-04-06","2093-04-05",1177378]
["2093-04-06","2094-04-05",{"$f":"ROUNDUP(C105*102%,0)","v":1200926}]
["2094-04-06","2095-04-05",1224945]
["2095-04-06","2096-04-05",1249444]
["2096-04-06","2097-04-05",1274433]
["2097-04-06","2098-04-05",1299922]
["2098-04-06","2099-04-05",1325921]
["2099-04-06","2100-04-05",1352440]

{"sheet":"Current IHT calc","index":4,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[4,3,4,9],[7,5,7,6],[9,2,9,4],[9,5,9,6],[11,2,11,4],[11,5,11,6],[7,2,7,4],[30,2,30,4],[32,2,32,4],[30,5,30,6],[19,2,19,4],[19,5,19,6],[23,2,23,4],[23,5,23,6],[25,2,25,4],[25,5,25,6],[27,2,27,6],[21,2,21,6],[29,2,29,4],[31,2,31,4],[29,5,29,6],[31,5,31,6],[34,8,36,9],[35,5,35,6],[11,8,15,9],[17,8,21,9],[22,8,26,9],[27,8,29,9],[31,8,33,9],[17,5,17,6],[15,2,15,6],[13,2,13,4],[13,5,13,6],[17,2,17,4]]}
[]
[]
[]
[]
[null,null,null,"     Inheritance Tax (IHT) Calculator - summary of current IHT position"]
[]
[null,null,null,{"$f":"TODAY()","v":"2023-09-20"},{"$f":"DATE(YEAR(D7)-7,MONTH(D7),DAY(D7))","v":"2016-09-20"}]
[null,null,{"$f":"IF(Results!E7=\"\",\"\",Results!E7)","v":""},null,null,"Current value provided"]
[]
[null,null,"Total assets",null,null,{"$f":"'Estate overview'!J21","v":0}]
[null,{"$f":"IF(C11=\"\",\"\",IFERROR(DATEDIF(C11,Results!F$11,\"y\"),0))","v":0},"less",null,null,null,{"$f":"IF(F11=\"\",\"\",IF(F11>=14,\"Remove\",\"\"))","v":""}]
[null,{"$f":"IF(C12=\"\",\"\",IFERROR(DATEDIF(C12,Results!F$11,\"y\"),0))","v":0},"Total liabilities",null,null,{"$f":"'Estate overview'!J29","v":0},null,null,"This financial planning tool provides the current IHT liability of your client based on the information you provide. In addition, it can show the value of any IHT liability at a future date entered by you (provisional date of death). Finally, you are able to enter a series of proposed gifts to show the IHT impact of these proposed gifts should they be made. "]
[null,{"$f":"IF(C13=\"\",\"\",IFERROR(DATEDIF(C13,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C14=\"\",\"\",IFERROR(DATEDIF(C14,Results!F$11,\"y\"),0))","v":0},"Net estate (after exemptions entered)",null,null,{"$f":"'Data sheet'!P27","v":0}]
[null,{"$f":"IF(C15=\"\",\"\",IFERROR(DATEDIF(C15,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C16=\"\",\"\",IFERROR(DATEDIF(C16,Results!F$11,\"y\"),0))","v":0},"Nil rate bands available"]
[null,{"$f":"IF(C17=\"\",\"\",IFERROR(DATEDIF(C17,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C18=\"\",\"\",IFERROR(DATEDIF(C18,Results!F$11,\"y\"),0))","v":0},"Nil rate band incl transferrable nil rate band",null,null,{"$f":"'Data sheet'!P18","v":325000},null,null,"The results calculated by this tool are based on the information you provide. It is your responsibility to ensure that the information you have input into this tool is accurate, if it is not the figures provided following the calculation will not be correct and should not be relied upon. "]
[null,{"$f":"IF(C19=\"\",\"\",IFERROR(DATEDIF(C19,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C20=\"\",\"\",IFERROR(DATEDIF(C20,Results!F$11,\"y\"),0))","v":0},"Residence nil rate band incl. transferrable",null,null,{"$f":"'Data sheet'!P22","v":0}]
[]
[null,null,"Gifts within 7 years"]
[null,null,null,null,null,null,null,null,"Every care has been taken to ensure that the information contained in this tool is correct and in accordance with our understanding of the law relating to IHT and HM Revenue and Customs practice as at July 2023. This could change in the future. "]
[null,null,"Total gifts",null,null,{"$f":"'Data sheet'!P10","v":0}]
[]
[null,null,"Tax on gifts after taper relief",null,null,{"$f":"'Data sheet'!Q56","v":0}]
[null,{"$f":"IF(C27=\"\",\"\",IFERROR(DATEDIF(C27,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C28=\"\",\"\",IFERROR(DATEDIF(C28,Results!F$11,\"y\"),0))","v":0},"Taxable estate",null,null,null,null,null,"You should be satisfied that the information you have entered and the results of any calculation are correct, before acting or refraining from acting in reliance upon the information given. "]
[null,{"$f":"IF(C29=\"\",\"\",IFERROR(DATEDIF(C29,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C30=\"\",\"\",IFERROR(DATEDIF(C30,Results!F$11,\"y\"),0))","v":0},"Estate taxable",null,null,{"$f":"'Data sheet'!P29","v":0}]
[]
[null,null,"Tax on estate",null,null,{"$f":"'Data sheet'!P31-F26","v":0},null,null,"Quilter accepts no responsibility for actions taken or refrained from being taken following use of this financial planning tool."]
[]
[]
[null,null,null,null,null,null,null,null,"More information on IHT can be found on our technical insights pages - www.quilter.com/help-and-support/technical-insights/"]
[null,null,"Total tax",null,null,{"$f":"'Data sheet'!P31","v":0}]

{"sheet":"DoD IHT calc","index":5,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[4,3,4,9],[9,2,9,4],[9,5,9,6],[11,2,11,4],[11,5,11,6],[7,2,7,4],[11,8,15,9],[27,2,27,6],[13,2,13,4],[13,5,13,6],[15,2,15,6],[17,2,17,4],[17,5,17,6],[19,2,19,4],[19,5,19,6],[21,2,21,6],[23,2,23,4],[23,5,23,6],[25,2,25,4],[25,5,25,6],[29,2,29,4],[29,5,29,6],[31,2,31,4],[31,5,31,6],[35,5,35,6],[34,8,36,9],[17,8,21,9],[22,8,26,9],[27,8,29,9],[31,8,33,9]]}
[]
[]
[]
[]
[null,null,null,"     Inheritance Tax (IHT) Calculator - summary of current IHT position"]
[]
[null,null,null,{"$f":"TODAY()","v":"2023-09-20"},{"$f":"DATE(YEAR(D7)-7,MONTH(D7),DAY(D7))","v":"2016-09-20"}]
[null,null,{"$f":"IF(Results!E7=\"\",\"\",Results!E7)","v":""},null,null,"Date of death",{"$f":"Results!F11","v":"00:00:00"}]
[]
[null,null,"Total assets",null,null,{"$f":"SUM('Data sheet'!X2:X9)","v":0}]
[null,{"$f":"IF(C11=\"\",\"\",IFERROR(DATEDIF(C11,Results!F$11,\"y\"),0))","v":0},"less",null,null,null,{"$f":"IF(F11=\"\",\"\",IF(F11>=14,\"Remove\",\"\"))","v":""}]
[null,{"$f":"IF(C12=\"\",\"\",IFERROR(DATEDIF(C12,Results!F$11,\"y\"),0))","v":0},"Total liabilities",null,null,{"$f":"SUM('Data sheet'!X12:X14)","v":0},null,null,"This financial planning tool provides the current IHT liability of your client based on the information you provide. In addition, it can show the value of any IHT liability at a future date entered by you (provisional date of death). Finally, you are able to enter a series of proposed gifts to show the IHT impact of these proposed gifts should they be made. "]
[null,{"$f":"IF(C13=\"\",\"\",IFERROR(DATEDIF(C13,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C14=\"\",\"\",IFERROR(DATEDIF(C14,Results!F$11,\"y\"),0))","v":0},"Net estate (after exemptions entered)",null,null,{"$f":"'Data sheet'!X27","v":0}]
[null,{"$f":"IF(C15=\"\",\"\",IFERROR(DATEDIF(C15,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C16=\"\",\"\",IFERROR(DATEDIF(C16,Results!F$11,\"y\"),0))","v":0},"Nil rate bands available"]
[null,{"$f":"IF(C17=\"\",\"\",IFERROR(DATEDIF(C17,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C18=\"\",\"\",IFERROR(DATEDIF(C18,Results!F$11,\"y\"),0))","v":0},"Nil rate band incl transferrable nil rate band",null,null,{"$f":"'Data sheet'!X18","v":{"$error":"#N/A"}},null,null,"The results calculated by this tool are based on the information you provide. It is your responsibility to ensure that the information you have input into this tool is accurate, if it is not the figures provided following the calculation will not be correct and should not be relied upon. "]
[null,{"$f":"IF(C19=\"\",\"\",IFERROR(DATEDIF(C19,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C20=\"\",\"\",IFERROR(DATEDIF(C20,Results!F$11,\"y\"),0))","v":0},"Residence nil rate band incl. transferrable",null,null,{"$f":"'Data sheet'!X22","v":0}]
[]
[null,null,"Gifts within 7 years"]
[null,null,null,null,null,null,null,null,"Every care has been taken to ensure that the information contained in this tool is correct and in accordance with our understanding of the law relating to IHT and HM Revenue and Customs practice as at July 2023. This could change in the future. "]
[null,null,"Total gifts",null,null,{"$f":"'Data sheet'!X10","v":0}]
[]
[null,null,"Tax on gifts after taper relief",null,null,{"$f":"'Data sheet'!Y56","v":0}]
[null,{"$f":"IF(C27=\"\",\"\",IFERROR(DATEDIF(C27,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C28=\"\",\"\",IFERROR(DATEDIF(C28,Results!F$11,\"y\"),0))","v":0},"Taxable estate",null,null,null,null,null,"You should be satisfied that the information you have entered and the results of any calculation are correct, before acting or refraining from acting in reliance upon the information given. "]
[null,{"$f":"IF(C29=\"\",\"\",IFERROR(DATEDIF(C29,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C30=\"\",\"\",IFERROR(DATEDIF(C30,Results!F$11,\"y\"),0))","v":0},"Estate taxable",null,null,{"$f":"'Data sheet'!X29","v":{"$error":"#N/A"}}]
[]
[null,null,"Tax on estate",null,null,{"$f":"'Data sheet'!X31-F26","v":{"$error":"#N/A"}},null,null,"Quilter accepts no responsibility for actions taken or refrained from being taken following use of this financial planning tool."]
[]
[]
[null,null,null,null,null,null,null,null,"More information on IHT can be found on our technical insights pages - www.quilter.com/help-and-support/technical-insights/"]
[null,null,"Total tax",null,null,{"$f":"'Data sheet'!X31","v":{"$error":"#N/A"}}]

{"sheet":"DoD post gifting calc","index":6,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[4,3,4,9],[7,2,7,4],[9,2,9,4],[9,5,9,6],[11,2,11,4],[11,5,11,6],[11,8,16,9],[27,2,27,6],[13,2,13,4],[13,5,13,6],[15,2,15,6],[17,2,17,4],[17,5,17,6],[19,2,19,4],[19,5,19,6],[21,2,21,6],[23,2,23,4],[23,5,23,6],[25,2,25,4],[25,5,25,6],[29,2,29,4],[29,5,29,6],[31,2,31,4],[31,5,31,6],[35,5,35,6],[34,8,36,9],[17,8,21,9],[22,8,26,9],[27,8,30,9],[31,8,33,9]]}
[]
[]
[]
[]
[null,null,null,"     Inheritance Tax (IHT) Calculator - summary of current IHT position"]
[]
[null,null,null,{"$f":"TODAY()","v":"2023-09-20"},{"$f":"DATE(YEAR(D7)-7,MONTH(D7),DAY(D7))","v":"2016-09-20"}]
[null,null,{"$f":"IF(Results!E7=\"\",\"\",Results!E7)","v":""},null,null,"Date of death",{"$f":"Results!F11","v":"00:00:00"}]
[]
[null,null,"Total assets less proposed gift(s)",null,null,{"$f":"SUM('Data sheet'!AF2:AF9)-'Gifting details'!J32","v":0}]
[null,{"$f":"IF(C11=\"\",\"\",IFERROR(DATEDIF(C11,Results!F$11,\"y\"),0))","v":0},"less",null,null,null,{"$f":"IF(F11=\"\",\"\",IF(F11>=14,\"Remove\",\"\"))","v":""}]
[null,{"$f":"IF(C12=\"\",\"\",IFERROR(DATEDIF(C12,Results!F$11,\"y\"),0))","v":0},"Total liabilities",null,null,{"$f":"SUM('Data sheet'!AF12:AF14)","v":0},null,null,"This financial planning tool provides the current IHT liability of your client based on the information you provide. In addition, it can show the value of any IHT liability at a future date entered by you (provisional date of death). Finally, you are able to enter a series of proposed gifts to show the IHT impact of these proposed gifts should they be made. "]
[null,{"$f":"IF(C13=\"\",\"\",IFERROR(DATEDIF(C13,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C14=\"\",\"\",IFERROR(DATEDIF(C14,Results!F$11,\"y\"),0))","v":0},"Net estate (after exemptions entered)",null,null,{"$f":"'Data sheet'!AF27","v":0}]
[null,{"$f":"IF(C15=\"\",\"\",IFERROR(DATEDIF(C15,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C16=\"\",\"\",IFERROR(DATEDIF(C16,Results!F$11,\"y\"),0))","v":0},"Nil rate bands available"]
[null,{"$f":"IF(C17=\"\",\"\",IFERROR(DATEDIF(C17,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C18=\"\",\"\",IFERROR(DATEDIF(C18,Results!F$11,\"y\"),0))","v":0},"Nil rate band incl transferrable nil rate band",null,null,{"$f":"'Data sheet'!AF18","v":{"$error":"#N/A"}},null,null,"The results calculated by this tool are based on the information you provide. It is your responsibility to ensure that the information you have input into this tool is accurate, if it is not the figures provided following the calculation will not be correct and should not be relied upon. "]
[null,{"$f":"IF(C19=\"\",\"\",IFERROR(DATEDIF(C19,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C20=\"\",\"\",IFERROR(DATEDIF(C20,Results!F$11,\"y\"),0))","v":0},"Residence nil rate band incl. transferrable",null,null,{"$f":"'Data sheet'!AF22","v":0}]
[]
[null,null,"Gifts within 7 years"]
[null,null,null,null,null,null,null,null,"Every care has been taken to ensure that the information contained in this tool is correct and in accordance with our understanding of the law relating to IHT and HM Revenue and Customs practice as at July 2023. This could change in the future. "]
[null,null,"Total gifts (incl. proposed)",null,null,{"$f":"'Data sheet'!AF10","v":0}]
[]
[null,null,"Tax on gifts after taper relief",null,null,{"$f":"'Data sheet'!AG56+'Data sheet'!Y56","v":0}]
[null,{"$f":"IF(C27=\"\",\"\",IFERROR(DATEDIF(C27,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C28=\"\",\"\",IFERROR(DATEDIF(C28,Results!F$11,\"y\"),0))","v":0},"Taxable estate",null,null,null,null,null,"You should be satisfied that the information you have entered and the results of any calculation are correct, before acting or refraining from acting in reliance upon the information given. "]
[null,{"$f":"IF(C29=\"\",\"\",IFERROR(DATEDIF(C29,Results!F$11,\"y\"),0))","v":""}]
[null,{"$f":"IF(C30=\"\",\"\",IFERROR(DATEDIF(C30,Results!F$11,\"y\"),0))","v":0},"Estate taxable",null,null,{"$f":"'Data sheet'!AF29","v":{"$error":"#N/A"}}]
[]
[null,null,"Tax on estate",null,null,{"$f":"'Data sheet'!AF31-F26","v":{"$error":"#N/A"}},null,null,"Quilter accepts no responsibility for actions taken or refrained from being taken following use of this financial planning tool."]
[]
[]
[null,null,null,null,null,null,null,null,"More information on IHT can be found on our technical insights pages - www.quilter.com/help-and-support/technical-insights/"]
[null,null,"Total tax",null,null,{"$f":"'Data sheet'!AF31","v":{"$error":"#N/A"}}]

{"sheet":"Control sheet","index":7,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Version control"]
[]
["V1","2023-07-01","Intial launch"]