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
| Field | What to enter | Example |
|---|---|---|
| Start date | First day of continuous employment with this employer. | 01/11/2014 |
| End date | Last day of employment (after any notice period). | 31/10/2026 |
| Age at end date | Age on the day employment ends; the UK formula depends on it. | 45 |
| Weekly pay | Gross weekly pay before tax; the sheet applies the statutory cap you enter. | £600 |
| Statutory weekly cap | The maximum weekly pay that counts, as published for the current year. | Check GOV.UK |
| Company enhancement | Any extra weeks or months your policy or contract adds. | 0 weeks |
Calculation (automatic)
| Field | What to enter | Example |
|---|---|---|
| Full years of service | Complete years only, counted back from the end date, maximum 20. | 12 years |
| Weeks aged 41 or older | 1.5 weeks for each full year worked at age 41+. | 6 weeks |
| Weeks aged 22 to 40 | 1 week for each full year worked at age 22 to 40. | 8 weeks |
| Weeks under 22 | 0.5 week for each full year worked under 22. | 0 weeks |
| Statutory redundancy pay | Total 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 date | 01/11/2014 |
|---|---|
| End date | 31/10/2026 (12 full years) |
| Age at end date | 45 |
| Estimated statutory redundancy pay | £8,400 |
Calculation steps
| Step | Formula | Result |
|---|---|---|
| Full years of service | 01/11/2014 to 31/10/2026 | 12 years |
| Years aged 41 to 44 | 4 years × 1.5 weeks | 6 weeks |
| Years aged 33 to 40 | 8 years × 1 week | 8 weeks |
| Total weeks | 6 + 8 | 14 weeks |
| Weekly pay used | £600 (below the cap) | £600 |
| Statutory redundancy pay | 14 × £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
- 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.
- Count full years of service. Count back from the end date and use complete years only; the UK formula caps service at 20 years.
- 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.
- Choose the pay figure. Use gross weekly pay and apply the statutory cap in force on the end date.
- Add contractual enhancements. If your policy promises more, calculate it in a separate row so the statutory minimum stays visible.
- 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
- GOV.UK: Redundancy pay — your rights (checked November 13, 2026)
- GOV.UK: Calculate your statutory redundancy pay (checked November 13, 2026)
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.