Federal High-3 Salary Tracker & Calculator | 2026 Professional Edition

Your High-3 salary is one of the most important numbers used in calculating your FERS retirement benefit — and it is not necessarily your final three years of salary.

The Federal High-3 Salary Tracker & Calculator is an interactive Excel planning tool designed to help federal employees organize their retirement-covered basic pay, calculate an estimated High-3 average, and compare how different High-3 and service scenarios could affect an estimated FERS basic annuity.

Instead of simply guessing what your High-3 may be, this calculator lets you enter the actual pay-rate periods from your records and build a documented planning estimate.

WHAT THE CALCULATOR DOES:

• Tracks retirement-covered basic pay periods
• Allows entry of years, months, and days at each pay rate
• Automatically calculates weighted pay
• Automatically calculates the total time factor
• Calculates an estimated High-3 salary
• Helps verify that your selected period covers approximately three years
• Supports multiple pay-rate changes within the High-3 period
• Includes a separate retirement scenario comparison tool
• Compares different estimated High-3 amounts
• Compares 1.0% and 1.1% FERS calculation scenarios
• Estimates annual FERS basic annuity amounts for planning
• Includes built-in data validation
• Includes official authority and verification information

BUILT AROUND THREE IMPORTANT STEPS:

YOUR DATA
Enter retirement-covered basic pay from your own personnel and payroll records.

PLANNING ESTIMATE
The spreadsheet automatically calculates weighted pay and produces an estimated High-3 based on the information you enter.

OFFICIAL VERIFICATION
Use the estimate for retirement planning while recognizing that the final High-3 and retirement benefit calculation are determined by the responsible retirement authority.

IMPORTANT HIGH-3 CONCEPT:

Your High-3 is generally the highest average basic pay you earned during any three consecutive years of creditable federal service.

It is not automatically your final three years.

Overtime, bonuses, and other compensation that is not considered basic pay for retirement purposes should not be included.

WHO THIS IS FOR:

Federal employees who want to better understand, track, and estimate the High-3 salary that may be used in their FERS retirement calculation.

FORMAT:

• Interactive Microsoft Excel workbook
• Automatic High-3 calculations
• High-3 salary tracking worksheet
• FERS scenario comparison worksheet
• Authority and instructions worksheet
• 2026 Professional Edition
• Immediate digital download

Know the number behind your retirement calculation.

Track your pay. Run the numbers. Compare the possibilities. Verify the result.

IMPORTANT:

This is an independent educational and planning resource. It is not an official government calculator and is not affiliated with, endorsed by, or sponsored by any federal agency. Calculations produced by this workbook are planning estimates only. It does not provide legal, tax, investment, financial, or individualized retirement advice. Federal retirement rules and individual circumstances can change. Final High-3 salary, creditable service, retirement eligibility, and benefit amounts are determined by the responsible retirement authorities under applicable law and regulation.