HR & attendance

Severance Pay Calculator in Excel: Formula, Example and Checklist

Severance pay is the money an employer pays when employment ends, usually because of redundancy or dismissal without fault. Whether it is required, and how much, depends entirely on where you work: some countries set a statutory formula, others leave it to the contract or company policy.

This free Excel severance pay calculator walks through the inputs, the formula and a worked example based on UK statutory redundancy pay, and explains how the same sheet can be adapted to a company severance policy. Treat every result as an estimate and confirm it with your employer, a payroll professional or an official government calculator.

What is a severance pay calculator?

A severance pay calculator is a spreadsheet that turns a few inputs, such as start date, end date, age and weekly or monthly pay, into an estimated termination payment. HR and payroll teams use it to check figures before a redundancy round; employees use it to understand an offer or a settlement agreement.

The sheet keeps the logic visible. Instead of a single number from a black-box tool, each step is a row: years of service counted, weeks or months per year applied, the pay figure used, and any statutory cap. That makes it easy to spot where your figure and your employer's figure differ, which is usually the first question in any severance discussion.

When to use a severance calculator

  • Before a redundancy consultation, to estimate what each affected employee is owed
  • When you receive a severance or settlement offer and want to check the statutory minimum
  • When comparing a voluntary redundancy package with staying
  • When budgeting for a restructuring or a site closure
  • When documenting how a termination payment was calculated for the personnel file

How to fill in the severance pay calculator

The Excel file has an input area and a calculation area. Fill in the yellow cells; the rest is formulas.

Inputs

FieldWhat to enterExample
Start dateFirst day of continuous employment with this employer.01/11/2014
End dateLast day of employment (after any notice period).31/10/2026
Age at end dateAge on the day employment ends; the UK formula depends on it.45
Weekly payGross weekly pay before tax; the sheet applies the statutory cap you enter.£600
Statutory weekly capThe maximum weekly pay that counts, as published for the current year.Check GOV.UK
Company enhancementAny extra weeks or months your policy or contract adds.0 weeks

Calculation (automatic)

FieldWhat to enterExample
Full years of serviceComplete years only, counted back from the end date, maximum 20.12 years
Weeks aged 41 or older1.5 weeks for each full year worked at age 41+.6 weeks
Weeks aged 22 to 401 week for each full year worked at age 22 to 40.8 weeks
Weeks under 220.5 week for each full year worked under 22.0 weeks
Statutory redundancy payTotal weeks × weekly pay (capped).£8,400

Severance pay calculation example

An employee in England aged 45 is made redundant after 12 full years of service, earning £600 a week gross, which is below the statutory weekly cap.

Start date01/11/2014
End date31/10/2026 (12 full years)
Age at end date45
Estimated statutory redundancy pay£8,400

Calculation steps

StepFormulaResult
Full years of service01/11/2014 to 31/10/202612 years
Years aged 41 to 444 years × 1.5 weeks6 weeks
Years aged 33 to 408 years × 1 week8 weeks
Total weeks6 + 814 weeks
Weekly pay used£600 (below the cap)£600
Statutory redundancy pay14 × £600£8,400

Statutory redundancy pay up to £30,000 is generally tax-free in the UK, but notice pay and holiday pay are taxed as earnings. Check the current weekly cap on GOV.UK before relying on any figure.

Free download

Free, no sign-up. Opens in Excel, Google Sheets, Numbers, Word, Google Docs and LibreOffice.

Open the downloaded file in Nobami, our web office, to edit it right away.

How to calculate severance pay in 6 steps

  1. Check eligibility. In the UK, statutory redundancy pay generally requires at least two years of continuous service as an employee. Elsewhere, check your contract and local law.
  2. Count full years of service. Count back from the end date and use complete years only; the UK formula caps service at 20 years.
  3. Apply the age bands. Give half a week per year under 22, one week per year aged 22 to 40 and one and a half weeks per year aged 41 or over.
  4. Choose the pay figure. Use gross weekly pay and apply the statutory cap in force on the end date.
  5. Add contractual enhancements. If your policy promises more, calculate it in a separate row so the statutory minimum stays visible.
  6. Verify with the official calculator. Run the same inputs through the GOV.UK redundancy pay calculator and keep both results on file.

Severance rules: UK and US

United Kingdom: employees with at least two years of continuous service who are made redundant are normally entitled to statutory redundancy pay. It is half a week's pay for each full year under 22, one week's pay for each full year aged 22 to 40, and one and a half weeks' pay for each full year aged 41 or older, with service capped at 20 years and weekly pay capped at a statutory maximum that is updated every April.

United States: there is no federal law requiring severance pay. It depends on the employment contract, a company policy or plan, or a negotiated separation agreement. Large layoffs may trigger advance-notice duties under the federal WARN Act and similar state laws, which are different from severance.

Other countries use their own formulas, often based on monthly pay and years of service, and some exclude employees who resign. Adapt the multiplier rows in the sheet to the rule that applies to you.

Sources

General information only, not legal or tax advice. The calculator gives an estimate; the amount you are owed depends on your contract, current statutory limits and local law.

Common severance calculation mistakes

  • Counting partial years as full years of service
  • Using net pay instead of gross weekly pay
  • Forgetting to apply the statutory weekly pay cap, or using last year's cap
  • Mixing statutory redundancy pay with notice pay and holiday pay in one figure
  • Assuming severance is required by law in the United States
  • Ignoring a more generous company policy that applies on top of the statutory minimum

Severance pay calculator FAQs

How is severance pay calculated?

Under UK statutory rules: count full years of service (max 20), give 0.5, 1 or 1.5 weeks' pay per year depending on age, and multiply by weekly pay up to the statutory cap. Company policies often add more.

Do I get severance if I resign?

Usually not. Statutory redundancy pay applies when the employer ends the job because the role is no longer needed, not when the employee resigns voluntarily.

Is severance pay required in the US?

No federal law requires it. Severance depends on your contract, company policy or a separation agreement.

Is severance pay taxable?

It depends on the country. In the UK, statutory and contractual redundancy pay up to £30,000 is generally tax-free, while notice pay and holiday pay are taxed.

Can I use this sheet outside the UK?

Yes. Replace the age-band rows with your local formula, for example a number of days or months of pay per year of service, and keep the official source next to the result.

Write and share it with your team in Workbami

Stop emailing spreadsheets around. Fill in, approve and file it in Workbami, where approvals, reports and team chat live together. Free during the beta.

Start free

Related templates

← All templates