{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Home","input","xxxSheet1","adjustments","info_input","info_adjustments"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[[6,2,6,16],[17,2,17,14],[19,2,19,17],[16,15,16,16],[17,15,17,16],[14,16,14,17],[15,16,15,17]]}
[null,"input"]
[]
["IHT"]
["2021-03-01",null,"Inheritance tax calculator"]
[1]
[null,null,"About this tool"]
[]
[]
[null,null,"How to use this tool"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last updated:","2023-05-30"]
[]
[null,null,"39-41 Bank Street ▪ Ashford ▪ Kent TN23 1DQ ▪ customer.services@indicator-flm.co.uk"]
[]
[null,null,"© Indicator - FL Memo Ltd - No part of this tool may be reproduced or transmitted in any form or by any means or stored in any retrieval system without permission. Every effort has been made by the publisher to ensure that the results of this tool are accurate and not misleading, but the publisher cannot accept responsibility for any loss or liability perceived to have arisen from any such information."]

{"sheet":"input","index":1,"n_rows":36,"n_cols":19,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Home","adjustments"]
["bhpsni","Input - general information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+whatyear(TODAY())","v":2023},{"$f":"+CONCATENATE(R3,\"/\",R4)","v":"2023/2024"}]
[null,"Choose a year",null,null,null,null,null,null,null,null,null,"2022/2023",null,null,null,null,null,{"$f":"+R3+1","v":2024},{"$f":"+CONCATENATE(R4,\"/\",R5)","v":"2024/2025"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,{"$f":"+CONCATENATE(R5,\"/\",R6)","v":"2025/2026"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026,{"$f":"+CONCATENATE(R6,\"/\",R7)","v":"2026/2027"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2027,{"$f":"+CONCATENATE(R7,\"/\",R8)","v":"2027/2028"}]
[null,"Value of your assets",null,null,null,null,null,null,null,"You",null,"Spouse",null,null,null,null,null,2028]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2029]
[null,"Home:",null,null,null,null,null,null,null,0,null,0]
[]
[null,"Contents and personal effects:",null,null,null,null,null,null,null,0,null,0]
[]
[null,"Savings and investments (including endowments, PEPs and ISAs):",null,null,null,null,null,null,null,0,null,0]
[]
[null,"Business assets (less business property relief):",null,null,null,null,null,null,null,0,null,0]
[]
[null,"Other assets (car, boat, second home, etc):",null,null,null,null,null,null,null,0,null,0]
[]
[null,"Money owed to you:",null,null,null,null,null,null,null,0,null,0]
[]
[null,"Total assets",null,null,null,null,null,null,null,{"$f":"+SUM(J10:J21)","v":0},null,{"$f":"+SUM(L10:L21)","v":0}]
[]
[]
[null,"Value of your current liabilities"]
[null,"Outstanding mortgage on your home:",null,null,null,null,null,null,null,0,null,0]
[]
[null,"Bank loans/overdraft:",null,null,null,null,null,null,null,0,null,0]
[]
[null,"Credit cards/hire purchase:",null,null,null,null,null,null,null,0,null,0]
[]
[null,"Other liabilities:",null,null,null,null,null,null,null,0,null,0]
[]
[null,"Total liabilities",null,null,null,null,null,null,null,{"$f":"SUM(J26:J32)","v":0},null,{"$f":"SUM(L26:L32)","v":0}]
[]
[null,"Amount of your estate liable to IHT carried forward",null,null,null,null,null,null,null,{"$f":"IF((J22-J34)<1,0,J22-J34)","v":0},null,{"$f":"IF((L22-L34)<1,0,L22-L34)","v":0}]

{"sheet":"xxxSheet1","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["year","year_name","last_updated","nrb","rate","gross_up","IHT_MRNRB"]
[2020,"2020/2021","2020-03-22",325000,0.4,0.25,175000]
[2019,"2019/2020","2019-05-04",325000,0.4,0.25,150000]
[2012,"2012/2013","2018-05-04",325000,0.4,0.25,0]
[2013,"2013/2014","2018-05-04",325000,0.4,0.25,0]
[2014,"2014/2015","2018-05-04",325000,0.4,0.25,0]
[2015,"2015/2016","2018-05-04",325000,0.4,0.25,0]
[2016,"2016/2017","2018-05-04",325000,0.4,0.25,0]
[2017,"2017/2018","2018-05-04",325000,0.4,0.25,100000]
[2018,"2018/2019","2018-05-04",325000,0.4,0.25,125000]
[2021,"2021/2022","2023-01-12",325000,0.4,0.25,175000]
[2022,"2022/2023","2023-01-12",325000,0.4,0.25,175000]
[2023,"2023/2024","2023-01-12",325000,0.4,0.25,175000]
[2024,"2024/2025","2023-01-12",325000,0.4,0.25,175000]

{"sheet":"adjustments","index":3,"n_rows":44,"n_cols":20,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["input"]
["bhpsi","Input - additional information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"year",{"$f":"+LEFT(input!L4,4)","v":"2022"}]
[null,null,null,null,null,null,null,null,null,"You",null,"Spouse"]
[]
[null,"Amount of your estate liable to IHT brought forward",null,null,null,null,null,null,null,{"$f":"+input!$J$36","v":0},null,{"$f":"+input!$L$36","v":0}]
[]
[null,"Value of your main residence"]
[null,"Left to spouse:",null,null,null,null,null,null,null,0,null,0]
[]
[null,"Left to descendants:",null,null,null,null,null,null,null,0,null,0]
[]
[null,"Left to charity:",null,null,null,null,null,null,null,0,null,0]
[]
[null,"Left to others:",null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,"Y",null,"S"]
[]
[null,{"$f":"IF(OR(J17<>\"\",L17<>\"\"),\"Unallocated \",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(SUM(J9:J16)<>R17,R18,\"\")","v":""},null,{"$f":"IF(SUM(L9:L16)<>T17,T18,\"\")","v":""},null,null,null,null,"Values",{"$f":"+input!J10-input!J26","v":0},null,{"$f":"+input!L10-input!L26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+R17-SUM(J9:J15)","v":0},null,{"$f":"+T17-SUM(L9:L15)","v":0}]
[null,"Remaining estate"]
[null,"Left to spouse:",null,null,null,null,null,null,null,0,null,0]
[]
[null,"Left to charity:",null,null,null,null,null,null,null,0,null,0]
[]
[null,"Left to others:",null,null,null,null,null,null,null,0,null,0]
[]
[null,{"$f":"IF(OR(J26<>\"\",L26<>\"\"),\"Unallocated \",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(SUM(J21:J25)<>R26,R27,\"\")","v":""},null,{"$f":"IF(SUM(L21:L25)<>T26,T27,\"\")","v":""},null,null,null,null,"Values",{"$f":"+J6-R17","v":0},null,{"$f":"+L6-T17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+R26-SUM(J20:J24)","v":0},null,{"$f":"+T26-SUM(L20:L24)","v":0}]
[null,"Amount chargeable to IHT"]
[null,"Total net estate",null,null,null,null,null,null,null,{"$f":"J6","v":0},null,{"$f":"L6","v":0}]
[]
[null,"Less: nil rate band:",null,null,null,null,null,null,null,{"$f":"+MIN(dc(rates[],\"nrb\",$R$3),J6-J33)","v":0},null,{"$f":"+MIN(dc(rates[],\"nrb\",$R$3),L6-L33)","v":0}]
[]
[null,"Less: main residence nil rate band:",null,null,null,null,null,null,null,{"$f":"MAX(MIN(dc(rates[],\"IHT_MRNRB\",$R$3),IF(J11=\"\",0,J11),dc(rates[],\"IHT_MRNRB\",$R$3)-((J6-2000000)*0.5)),0)","v":0},null,{"$f":"MAX(MIN(dc(rates[],\"IHT_MRNRB\",$R$3),IF(L11=\"\",0,L11),dc(rates[],\"IHT_MRNRB\",$R$3)-((L6-2000000)*0.5)),0)","v":0},null,null,null,null,null,"limited to amount passed to descendents"]
[]
[null,"Less: nil rate band unused from spouse:",null,null,null,null,null,null,null,0,null,0]
[]
[null,"Amount you intend to leave to your spouse:",null,null,null,null,null,null,null,{"$f":"+J9+J20","v":0},null,{"$f":"+L9+L20","v":0}]
[]
[null,"Amount you intend to leave to charity:",null,null,null,null,null,null,null,{"$f":"+J13+J22","v":0},null,{"$f":"+L13+L22","v":0}]
[]
[]
[null,"Amount on which IHT payable",null,null,null,null,null,null,null,{"$f":"MAX(+J29-J31-J35-J37-J39-J33,0)","v":0},null,{"$f":"MAX(+L29-L31-L35-L37-L39-L33,0)","v":0}]
[]
[null,"IHT payable on your estate",null,null,null,null,null,null,null,{"$f":"(+IF(J39<(J29-J31-J33-J35-J37)*0.1,dc(rates[],\"rate\",whatyear(TODAY())),0.36))*J42","v":0},null,{"$f":"(+IF(L39<(L29-L31-L33-L35-L37)*0.1,dc(rates[],\"rate\",whatyear(TODAY())),0.36))*L42","v":0}]

{"sheet":"info_input","index":4,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[9,1,9,2]]}
["input"]
["bhps","Information - general information"]
[]
[null,"Value of your assets now"]
[]
[null,"Home:",null,null,"Enter your share of the value of your home."]
[]
[null,"Contents and personal effects:",null,null,"Include all personal items such as jewellery."]
[]
[null,"Savings and investments (including endowments, PEPs and ISAs):",null,null,"Include your share of all investments unless they qualify for an IHT exemption of 100% relief, e.g. shares in trading AIM companies."]
[]
[null,"Business assets (less business property relief):",null,null,"Enter the value of your business unless it qualifies for 100% business property relief (BPR) or agricultural property relief (APR). If it qualifies for 50% BPR or APR enter half its value."]
[]
[null,"Other assets (car, boat, second home, etc):",null,null,"Include your share of the value of other assets you own or partly own, including assets held in trust which you are entitled to. Do not include assets held in a discretionary trust of which you are a beneficiary."]
[]
[null,"Money owed to you:",null,null,"Enter the money owed to you, e.g. a loan made to a relative."]
[]
[]
[null,"Value of your current liabilities"]
[]
[null,"Outstanding mortgage on your home:",null,null,"Enter the amount you owe on loans used to buy your home. Where the loan is in joint names include only the relevant proportion, e.g. if you have a loan with one other person enter only 50% of the loan balance."]
[]
[null,"Bank loans/ overdraft:",null,null,"Enter other loan balances. Again only include the relevant proportion of joint borrowings. Where the loan relates to an asset that qualifies for BPR only include the amount by which the loan exceeds the value of the business property."]
[]
[null,"Credit cards/ hire purchase:",null,null,"Enter the current amount you owe to all card companies."]
[]
[null,"Other liabilities:",null,null,"Enter any other type of money or debt you owe."]

{"sheet":"info_adjustments","index":5,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["adjustments"]
["bhps","Information - additional information"]
[]
[null,"Value of main residence "]
[null,"Left to spouse:",null,null,"Enter the value of the part of your home which you intend to leave to your spouse."]
[]
[null,"Left to direct descendants:",null,null,"Enter the value of the part of your home which you intend to leave to your direct descendants, e.g. children, grandchildren."]
[]
[null,"Left to charity:",null,null,"Enter the value of the part of your home which you intend to leave to one or more registered charities."]
[]
[null,"Left to others:",null,null,"Enter the value of the part of your home which you intend to leave to persons other than your spouse or direct descendants."]
[]
[null,{"$f":"IF(OR(J13<>\"\",L13<>\"\"),\"Unallocated \",\"\")","v":""}]
[]
[null,"Remaining estate"]
[null,"Left to spouse:",null,null,"Enter the amount of your estate, apart from your home, that you intend to leave to your spouse."]
[]
[null,"Left to charity:",null,null,"Enter the amount of your estate, apart your from home, that you intend to leave to a registered charity."]
[]
[null,"Left to others:",null,null,"Enter the amount of your estate, apart from your home, that you intend to leave to anyone or any organisation apart from your spouse or registered charity."]
[]
[null,{"$f":"IF(OR(J22<>\"\",L22<>\"\"),\"Unallocated \",\"\")","v":""}]
[]
[null,"Adjustments to amount chargeable to IHT"]
[null,"Nil rate band unused from spouse:",null,null,"Where applicable enter the amount of the nil rate band that was not used by your spouse's estate when they died and which is available to set against your estate"]