← All prebuilt solutions
Tax & Company

Inheritance Tax Estimator

What your estate could pay – on the first and second death – and how to reduce it

£20

Secure checkout. Your download link is sent as soon as payment clears.

Inheritance Tax Estimator

Overview

Inheritance tax (IHT) is charged at 40% on the part of an estate above the tax-free bands. Since April 2026 business and farm reliefs have been capped, and from 6 April 2027 most unused pensions will count as part of the estate too – so far more families are now in scope. This workbook estimates how much IHT could be due, when it has to be paid, who ends up with what, and how much common planning steps could save. It is a planning tool for conversations with your family and your advisers – not a substitute for advice.

Price
£20
Who it’s for
Tax & Company
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Estate

All the inputs: you, your wills, late-spouse allowances, assets and debts. What you do: fill in every yellow cell that applies to you.

Estate
Gifts

Step 2

Gifts

Gifts in the 7 years before each death, the nil-rate band they use and any tax on them. What you do: one line per gift.

Step 3

Calculation

Step-by-step workings for the first and the second (or only) death. What you do: nothing to enter – use it to see exactly how each figure is reached.

Calculation
What-If

Step 4

What-If

Six planning levers tested one at a time and all together. What you do: change the yellow lever amounts and Yes/No switches.

Who it is for

Made for people like you

  • Example – text
  • Single, widowed or divorced people – The tax on your estate on one assumed date of death, using any bands claimed from a late spouse or civil partner.
  • Married couples and civil partners – The tax on the first death AND the second death, with unused bands passing to the survivor automatically.
  • Business owners and farmers – Business Relief and Agricultural Relief with the £2.5m 100% allowance, 50% relief above it and on AIM shares.
  • People with large pensions – A switch to bring pensions into the estate under the April 2027 rules, plus the income tax beneficiaries may pay if death is at 75 or over.
  • WATCH OUT – Inheritance tax and estate planning are complex. Wills, trusts, gifts where you keep a benefit, foreign assets, business ownership tests and the interaction with income tax and capital gains tax can all change the answer. Use this workbook to understand your position and prepare questions – always take professional advice before acting.

Quick start

Up and running in minutes

  1. Example – text
  1. Estate – about you – Choose your situation, enter names and dates of birth, pick who is assumed to die first and enter the assumed dates of death. Choose whether pensions count (Automatic is right for most people).
  2. Estate – your wills – For each person: is the home (or their share) left to children or grandchildren, any cash legacies to people other than the spouse, any charity gifts, and who the pension is nominated to.
  3. Estate – if widowed – Widowed? Enter the % of your late spouse's bands that went unused. Couples skip this.
  4. Estate – assets and debts – Enter today's values in the yellow cells, sole assets in each person's column and joint assets in the Jointly owned column.
  5. Gifts – List gifts made in the last 7 years (or that you plan) – who gave them, when, to whom, the value and any exemptions used.
  6. Read the Dashboard – The total tax, each death, who receives what, the checks and the charts. Then open What-If and try the planning levers.

Key features

  • Works out inheritance tax for a single person, or a married couple / civil partners on the first and second death, with the nil-rate band, residence nil-rate band (and £2m taper) and transferable bands.
  • Business Relief and Agricultural Relief with the £2.5m 100% allowance from 6 April 2026, 50% above it and on AIM shares; pensions brought into the estate from 6 April 2027 (with an on/off switch).
  • Lifetime gifts in the last 7 years with taper relief, charity exemption and the 36% rate, spouse exemption, life cover in or out of trust, and payment timing with the instalment option.
  • Who receives what, eight status checks, and a What-If sheet comparing six planning levers – gifts, regular gifts from income, spending pension, 10% to charity, life cover in trust and the home.

What’s included

  • Dashboard – The bill, who gets what and the checks
  • Estate – You, your wills, assets and debts
  • Gifts – Gifts in the last 7 years
  • Calculation – Step-by-step workings for each death
  • What-If – Planning levers compared
  • Tax Rates – Bands, rates and key dates
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions