The PA Calculator is an Excel spreadsheet. Use it to calculate PAs for both normal retirement age 60 and 65 members. (Normal retirement age does not affect PA calculations.)
Record the PA in Box 52 on the member’s 2017 T4.
Right-click on the link below and select “Save target as.”
Download Excel PA Calculator
(Do not use it within the browser, save to your computer first)
Have ready the member's 2017 credited service and contributory earnings.
Important! Do not delete row #4. The PA formulas are contained here, and the spreadsheet will not work if these are deleted or modified.
The PA will appear in the “PA to Report” field. Round the answer to the nearest dollar. Click ADD to Sheet, the information you entered and the PA will be saved and recorded on the spreadsheet. Enter new data for another PA calculation.
Click Exit to Sheet to return to the spreadsheet.
On the spreadsheet will be: