Merit Increase Calculator
Matrix Guideline
--
The range suggested by the standard Compa-Ratio matrix logic.
Adjusted Recommendation
--
The increase percentage applied after budget and fairness adjustments.
Planning Logic Applied
Disclaimer: This tool is for planning purposes only. Results are based on general matrix logic and user-provided inputs. All salary recommendations should be verified against internal company policies.
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.
Disclaimer: Actual merit increases aren't guaranteed and depend on final performance reviews and budget approvals.
Confused by these results? Read our deep-dive guide on Compa-Ratio strategy.
Helpful 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.