Merit Increase Calculator | Salary Planning Tool

Posted by: Pesync Team

Compa Ratio Performance Matrix

Performance Rating 1st Quartile (≤70%) 2nd Quartile (71%-84%) 3rd Quartile (85%-100%) 4th Quartile (101%-115%) 5th Quartile (116%-130%)
Exceeded 10%-15% 8%-9% 6%-8% 3%-6% 0%-3%
Achieved 8%-10% 7%-8% 3%-6% 2%-3% 1%-2%
Partially Achieved 2%-3% 1%-2% 0% 0% 0%
Not Achieved 0% 0% 0% 0% 0%

Key Definitions for Compensation Planning

1. Performance Rating: A qualitative assessment of an employee’s contributions over a specific review period:
  • Exceeded: Consistently delivered results above required standards.
  • Achieved: Fully met all goals; a solid and dependable contributor.
  • Partially Achieved: Met some expectations; requires development.
  • Not Achieved: Did not meet minimum requirements; improvement required.
​2. Employee Compa-Ratio (%): Measures how an employee's salary compares to the Midpoint of their range.
  • Formula: (Actual Salary ÷ Range Midpoint) X 100
  • Meaning: 100% means the employee is paid at market midpoint. 80% is below market; 120% is highly paid relative to market.​​​​​
3. Budget Limit (%): The maximum percentage of total payroll allocated for annual increases.
  • Why it matters: If the merit increase matrix suggests 8% but your budget is 4%, the tool scales the recommendation to stay within financial limits while still rewarding top performers more than others.

How to Use the Merit Increase Calculator

Step 1: Input Employee Data
  • Employee Compa-Ratio (%): Enter the current salary position relative to the midpoint (e.g., enter 95 if they earn $95k and the midpoint is $100k).
  • Performance Rating: Select from the four-tier scale: Exceeded, Achieved, Partially Achieved, or Not Achieved.
  • Budget Limit (%): Enter your organization's merit pool cap (e.g., 4.0).
Step 2: Analyze the Results
Click "Analyze Recommendation" to see:
  • Matrix Guideline: The standard range for that employee's specific quartile.
  • Adjusted Recommendation: The critical final number. If your budget is tight, the tool automatically scales increases to preserve the "merit gap" ensuring high performers are prioritized.
Step 3: Review the Strategic Analysis
The Planning Logic box provides HR-validated justification. Use this text to explain decisions to stakeholders or communicate clearly during employee merit increase discussions.
Confused by these results? Read our deep-dive guide on Compa-Ratio strategy.

Recommended Resources

​For Salary Increments: 
  • To move away from 'guessing' your yearly payroll increases, you can use this free Salary Increase Matrix Toolkit to model your budget with actual data.​
For Internal Equity: 
  • To ensure your pay scales are fair and consistent across different departments, use this Job Leveling Framework to help you align every role to a specific grade.
For Compensation Benchmark: