Calculation of pensionable pay
The calculation of pensionable pay spreadsheet calculates the final years pensionable pay for monthly paid employees.
This is to assist you with pensionable pay calculations. It will not cover every circumstance but should assist with the majority of calculations.
The worksheet has been password protected therefore you will only be able to enter information in the input cells, all of which are shown in white. If you tab from one white field it will take you to the next one. When using the spreadsheet please refer to the notes as these guide you through each section.
If you wish to print out the output and attach this to the P43 leaver forms please do so.
If you have any problems when using the spreadsheet please contact the Pension Technical Team on telephone 01629 539250 or e-mail pensions@derbyshire.gov.uk
Related documents
The following document is in Portable Document Format (PDF). You can download the PDF software for free from the Adobe website (opens in a new window)
The following document is in Excel format. You can download the Excel software for free from the Excel viewer page (opens in a new window) of the Microsoft website.