Excel-based Redundancy Calculator UK 2025
Input staff data into this Excel-based Redundancy Calculator UK and it will instantly calculate the statutory redundancy payments for multiple staff, based on their weekly pay, age, and length of service. This spreadsheet has been used by companies such as P&O Ferries, Coventry University, and Go South Coast Buses. Incorporates 2025 weekly and total payout statutory caps.
==============================================================================================
Demo
Features
🌟 Calculates the 2025 statutory redundancy payment for UK staff (furloughed and non-furloughed), based on age categories (under 22, 22-40, 41 and over), weekly pay, and years of service.
🚀 Automatically computes redundancy pay for 1 or hundreds of staff, as needed.
💰 Provides a capped redundancy payment figure, accounting for the statutory weekly cap and the total payout cap.
⏱️ Automatically considers the 2-year qualifying period for redundancy eligibility.
📊 Includes up-to-date statutory payment caps for weekly (£719) and total payout (£21,570) applicable for the year 2025/2026.
Previous customers
1.P&O Ferries
2.Go South Coast Buses
3.Coventry University
4.Rainbow Casinos
5.H E Simm Group
Instructions:
- Getting Started:
- Download the UK Statutory Redundancy Pay Calculator 2025 Excel template.
- Save an extra copy of the file for backup purposes.
- Preparing Your Data Ready for Import:
- Organize your data file with the following headings: Name, Date of Birth, Age in Years, Annual Pay, Employee Start Date, Date of Redundancy, and Location (UK or Northern Ireland).
- Importing Your Data:
- If your data file layout exactly matches the redundancy calculator input fields, cut and paste your data into the calculator.
- Alternatively, use Excel’s import tool to uniformly transpose your data into the input fields.
- Only enter data into the green input cells.
- Redundancy Calculation Parameters:
- Columns I to Q in red contain parameters for the formulas used in the system to calculate the 2025 statutory redundancy pay.
- Do not modify these cells.
- Statutory Redundancy Payment Calculations:
- Column P represents the weekly statutory redundancy pay entitlement (subject to statutory pay caps).
- Column Q displays the Final UK Statutory Redundancy Payment based on age and length of service for your employees.
Screenshot
==============================================================================================
Excel-based Redundancy Calculator UK 2025
Input staff data into this Excel-based Redundancy Calculator UK and it will instantly calculate the statutory redundancy payments for multiple staff, based on their weekly pay, age, and length of service. This spreadsheet has been used by companies such as P&O Ferries, Coventry University, and Go South Coast Buses. Incorporates 2025 weekly and total payout statutory caps.
==============================================================================================
Disclaimer: While thecareercafe.co.uk has taken every precaution to ensure the correctness of the analytical calculations used in our 2025 UK Statutory Redundancy Pay Excel Calculator Tool, we do not guarantee the results will be error-free.