Performance Review Template with Merit Raise Calculator (US 2026)

Score goals and competencies, get the rating, then the merit raise in dollars. Check that raise against the 3.1% wage growth BLS measured for June 2026. A raise below it means a 'meets expectations' employee's pay falls behind the market.

Your result: rating and merit raise

Weighted review score3.8
Rating band (1-5)4
Compa-ratio (salary / midpoint)0.96
Rating multiplier (5=1.5, 4=1.2, 3=1.0, 2=0.5, 1=0)1.2
Range position factor (below 0.90 = 1.25, above 1.10 = 0.75)1
Merit raise %4.20%
Merit raise ($ per year)$3,024.00
New annual salary$75,024.00
Raise needed to keep pace with market$2,232.00
Raise above (+) or below (-) market$792.00
New compa-ratio1

Full version — $21 once · the .xlsx with the printable Review Form and a 15-row Team Calibration sheet checked against your merit pool ·

Everything updates as you type. Nothing is uploaded. This runs in your browser.

Your employee's numbers

What the merit raise is checked against

BLS Employment Cost Index: private-industry wages and salaries rose 3.1% in the 12 months to June 2026. A raise below that pace is a pay cut against the market, even with a "meets expectations" rating.

Free performance review templates are blank forms that stop at the rating. This one turns the rating into dollars: weighted score → rating band → compa-ratio merit matrix → raise → gap to market.

Merit matrix used: rating 5 = 1.5×, 4 = 1.2×, 3 = 1.0×, 2 = 0.5×, 1 = no raise, times your merit budget. Below 0.90 compa-ratio the raise is ×1.25; above 1.10 it is ×0.75. These are a starting matrix, not a law. Change them in the workbook to match your company's policy.

Yardstick: BLS OEWS 2025: Human Resources Specialists median $36.51/h; Compensation, Benefits and Job Analysis Specialists median $37.60/h.

The workbook opens directly in Excel. For Google Sheets, use File ▸ Import ▸ Upload (menu names vary by version and language). Formulas are plain arithmetic, IF, ROUND, SUM, AVERAGE and COUNTIF, and they work in both. Fill colours and column widths can look slightly different in Sheets.

Get the full calculatorFull version: all tabs, your own file, works offline.

Open full tool → getreadystack.com · Put this on your site with your logo