About the Merit Increase Matrix Calculator
This merit increase calculator applies a classic merit matrix to a list of employees. Each person’s raise depends on two things: their performance rating and their compa-ratio — salary divided by the midpoint of their pay range. Strong performers who are low in their range get the largest increases, while people already paid above midpoint get smaller ones, which moves pay toward market over time without overspending.
It is built for managers and compensation teams running an annual pay review. Paste each employee’s salary, range midpoint and rating, set the matrix percentages and your merit budget, and the calculator shows every raise, the new salary and compa-ratio, the total spend and how far you are over or under budget. Turn on scaling to adjust the whole matrix proportionally so spend lands exactly on budget.
Ratings use a 3-point scale (3 = exceeds, 2 = meets, 1 = below expectations) and three compa-ratio zones with boundaries you choose. The default matrix and 3.5% budget are illustrative; set them to your own salary increase budget and guidelines.
With the default inputs, the total merit spend is $23,715.00. Change any value above to recalculate instantly.
How to use the merit increase matrix calculator
- 1Paste each employee as name, salary, range midpoint and rating (1–3), one per line.
- 2Enter the merit budget as a percentage of payroll.
- 3Set the compa-ratio boundaries for the low, target and high zones.
- 4Fill in the matrix percentages for each rating and zone.
- 5Check total spend against budget, and turn on scaling if you need to land exactly on budget.
Formula and method
Each employee’s compa-ratio places them in one of three zones: below the lower boundary, between the boundaries (the target zone), or above the upper boundary. Their performance rating picks a row of the matrix and their zone picks a column; that cell’s percentage times their current salary is their merit increase.
Total spend is the sum of all increases, compared with the budget (payroll × budget %). The scale factor is the number every matrix cell must be multiplied by for spend to equal the budget exactly; with scaling turned on it is applied to every cell, preserving the relative differences between cells. Employees with no midpoint are treated as in the target zone.
- Compa-ratio
- Salary relative to the midpoint of the pay range (1.00 = at midpoint)
- Matrix %
- Merit percentage for a rating and compa-ratio zone
- Budget %
- Merit budget as a percentage of current payroll
Worked examples
8-person team, 3.5% budget
Payroll is $682,000, so a 3.5% budget is $23,870. Ana (compa-ratio 0.85, exceeds) gets 6% = $4,080, Fay (1.05, exceeds) gets 5% = $5,250, Cara (1.19, exceeds) gets 3.5% = $3,325, and Gus (below expectations) gets nothing. The matrix spends $23,715, leaving $155 unspent.
Matrix scaled to budget
At a 3% budget ($20,460) the unscaled matrix would overspend ($23,715). Scaling multiplies every cell by 20,460 ÷ 23,715 = 0.8627, so Ana’s 6% becomes 5.18% and total spend equals the budget exactly.
Two employees without names
The first employee (compa-ratio 0.83, meets) gets 4% = $2,000. The second sits exactly on the 1.10 upper boundary, which still counts as the target zone, and exceeds expectations, so gets 5% = $3,300. Spend of $5,300 is $660 over the 4% budget of $4,640 — a scale factor of about 0.875 would fix it.
Frequently asked questions
What is a merit matrix?+
A merit matrix is a grid that sets salary increase percentages by performance rating and by position in the pay range (usually compa-ratio). Higher performers get more, and people lower in their range get more than those near the top, so pay moves toward market rates while rewarding performance.
What is a compa-ratio?+
Compa-ratio is an employee’s salary divided by the midpoint of their salary range. A compa-ratio of 1.00 means pay is exactly at midpoint, 0.90 means 10% below and 1.10 means 10% above. Many organisations treat roughly 0.90–1.10 as the target zone for fully competent employees.
How do I make my merit matrix fit the budget?+
Calculate total spend with your draft matrix, then divide the budget by that spend to get a scale factor. Multiplying every cell by the factor keeps the relative differences between cells and lands spend on budget. You can also adjust individual cells, for example lowering increases above the target zone.
What is a typical merit increase budget?+
Merit budgets are set each year by each employer, typically as a percentage of payroll in the low single digits, and vary with inflation, labour-market conditions and company performance. Check current salary budget surveys and your own finances rather than relying on a fixed rule of thumb.
Should employees above the top of the range get a merit increase?+
Many organisations give employees above range maximum a smaller increase or a one-time lump sum instead of a base pay raise, so base salary does not drift further above the range. You can model this by setting low percentages in the above-target column.