Merit Increase & Raise Budget Calculator

Enter your total team payroll, merit budget percentage, inflation rate, and performance tier distribution to calculate your merit dollar pool, tier-by-tier cost, total spend, budget surplus or deficit, weighted average raise, real purchasing power gain after inflation, and whether your tier differentiation is strong enough to actually retain top performers.

✓ Team-level merit pool modeling — tier distribution × raise% = actual spend, not estimates✓ Budget remaining output — know your surplus or deficit before approvals go out✓ Real raise after inflation — 3.2% average with 2.8% inflation is 0.4% in real terms✓ Differentiation multiplier — whether top performers are getting the 2–3× benchmark or meaningfully less✓ Free Excel download✓ No signup required

Download This Calculator

Get the Excel spreadsheet behind this calculator to use offline, customize for your needs, and publish as a web tool using Sheetflow.

Download Excel File

Tier-by-Tier Merit Pool Modeling

Model your Exceeds, Meets, and Below tier distribution with separate raise percentages. See exact dollar spend per tier — not estimates — before approvals go out.

Budget Surplus or Deficit

Compare total merit spend against your approved pool and see the remaining surplus or deficit at a glance — so discretionary adjustments can be made before the cycle is locked.

Real Raise After Inflation

Subtract inflation from the weighted average merit raise to show what employees actually gained in purchasing power — the number that almost never makes it into the leadership presentation.

Frequently Asked Questions

What is the difference between a merit increase, a cost-of-living raise, and a promotion raise?

These three compensation actions are often conflated in annual review cycles but serve different purposes, and treating them as interchangeable erodes the signal each is meant to send.

Merit increase — a permanent base salary raise tied to individual performance in the review period. It is awarded after evaluation and compounds forward: a 5% merit raise on a $70,000 salary raises the base from which every future raise, bonus calculation, and retirement contribution will be calculated. It is the most direct connection between demonstrated performance and compensation.

Cost-of-living adjustment (COLA) — a raise designed to maintain purchasing power as prices rise, not tied to individual performance. COLAs are typically uniform across the organization. In 2026, with inflation running approximately 2.8% year-over-year, a 2.8% COLA maintains purchasing power without improving it.

Promotion raise — accompanies a change in role, title, or level. Typically 8–15%, reflecting expanded responsibilities and new expectations rather than past performance.

The distinction matters for budget design. Most organizations that budget effectively run separate merit and COLA pools. Combining them into a single "salary increase budget" causes two problems: the merit component becomes too small to signal performance differentiation, and employees cannot tell whether they were rewarded for their work or simply given an inflation adjustment. A plan that gives everyone 2% COLA plus 1.5% "merit" has effectively eliminated the merit signal — $1,050 in additional annual take-home does not function as performance recognition for a $70,000 employee.

This calculator focuses on the merit component specifically, with inflation as a context input to help HR communicate what the merit increase actually means in real terms.

How do I build a merit increase budget for my team?

The merit planning process has five steps that this calculator models in sequence.

Step 1: Establish the merit dollar pool. Finance sets the merit budget as a percentage of total base payroll. The national average is 3.5% for 2026 per WorldatWork, Payscale, and WTW surveys. On a $1,200,000 total payroll, that is $42,000 available to spend.

Step 2: Define your workforce distribution across performance tiers. Decide what percentage of employees fall into each tier — Exceeds Expectations, Meets Expectations, Below Expectations. A typical distribution is 25% / 60% / 15%. This single decision drives budget utilization more than the raise percentages themselves.

Step 3: Set raise percentages by tier. Common ranges: Exceeds 5–7%, Meets 2.5–4%, Below 0–2%. In the default scenario: 5% / 3% / 1%.

Step 4: Check budget utilization before approvals. Total merit spend = sum of (each tier's share of payroll × tier raise %). Default calculation:

  • Exceeds tier: $1,200,000 × 25% × 5.0% = $15,000
  • Meets tier: $1,200,000 × 60% × 3.0% = $21,600
  • Below tier: $1,200,000 × 15% × 1.0% = $1,800
  • Total spend: $38,400
  • Budget remaining: $42,000 − $38,400 = $3,600 surplus
  • Budget utilization: 91.4%

The $3,600 surplus can be allocated as discretionary increases for flight-risk employees, held in reserve for mid-year adjustments, or redistributed to the Exceeds tier to improve differentiation.

Step 5: Review the differentiation multiplier. Weighted average raise = $38,400 ÷ $1,200,000 = 3.2%. Differentiation multiplier = 5.0% ÷ 3.2% = 1.56×. The benchmark is 2–3×. At 1.56×, the merit system signals weak differentiation — top performers receive $1,400 more per year than average performers on a $70,000 base, before taxes. That is not a retention mechanism.

What is the average merit increase budget in 2025 and 2026?

Four major compensation surveys report consistent figures:

Survey2026 Average Merit Budget
WorldatWork3.6%
WTW (Willis Towers Watson)3.5%
Payscale3.5%
Mercer3.2%

Industry ranges vary meaningfully:

IndustryTypical Merit Budget
Technology4.0–5.0%
Financial services4.0–4.5%
Healthcare3.0–3.5%
Manufacturing3.0–3.5%
Education / nonprofit2.5–3.0%
Government2.0–3.0%

The national average of 3.5–3.6% is only meaningful against inflation. With CPI running approximately 2.8% year-over-year through early 2026 (BLS), the average real wage improvement from merit is roughly 0.7–0.8%. At the $80,000 median professional salary, the 2026 average merit increase is approximately $2,800 gross — $233/month before taxes, roughly $170/month after. Three consecutive years at this rate represent modest but genuine real wage growth for employees who stay.

The more important benchmark: the Atlanta Fed Wage Growth Tracker for early 2026 shows job switchers averaging 5.0% wage growth versus 3.8% for job stayers. The compounding advantage of mobility relative to internal merit cycles is why retention strategy cannot rely on compensation alone — but differentiation within the merit pool remains the most controllable lever HR has.

What differentiation multiplier should top performers actually receive?

The benchmark from compensation research is 2–3× — meaning top performers (Exceeds tier) should receive raises that are 2 to 3 times the weighted average merit increase. At a 3.2% average, that implies a range of 6.4–9.6% for top performers.

The default scenario produces a 1.56× multiplier (5% for Exceeds ÷ 3.2% weighted average). This is where most organizations land — and it is consistently below the threshold where differentiation changes behavior or retention rates.

The dollar consequence of this gap is the issue. On a $70,000 salary:

Performance tierRaise %Annual raiseMonthly take-home increase (est.)
Exceeds5.0%$3,500~$215
Meets3.0%$2,100~$130
Below1.0%$700~$43

Exceeds vs. Meets differential: $1,400/year, approximately $85/month after taxes. For a high performer considering a competing offer that typically represents a 10–20% salary increase ($7,000–$14,000/year), the internal merit system is not providing a meaningful financial reason to stay.

Two adjustments improve the multiplier without increasing the total budget:

Widen the spread. Move from 5% / 3% / 1% to 7% / 2.5% / 0%. Total spend actually decreases slightly (depending on tier distribution), and the multiplier rises to 2.2× — above the 2× retention threshold.

Shift the distribution. Tighten the Exceeds tier to 20% and the Below tier to 20%, with Meets at 60%. Redirect the freed budget from the Below tier to the Exceeds tier. Same total pool, better differentiation.

The calculator lets you model both adjustments in real time before approvals are submitted.

Why does a 3.5% merit increase feel so much smaller than it looks on paper?

Four factors compound to make a nominally positive merit increase feel inadequate to the employees who receive it:

Inflation absorption. A 3.5% raise against 2.8% inflation is a 0.7% real increase in purchasing power. On an $80,000 salary, that is $560 per year — less than $50 per month in real terms. Three consecutive years of 3.5% raises with 2.8% inflation produces cumulative real wage growth of roughly 2.1%, or approximately $1,680 on an $80,000 base. This is the math behind 47% of employees reporting their pay raise does not reflect their actual contribution (Payscale, 2024) — the disconnect is real, not a communication problem.

Tax reduction. A $2,800 gross merit increase at a 25% combined federal and state tax rate delivers $2,100 net — $175 per month in additional take-home. Employees experience the after-tax number, not the headline percentage.

The job-switcher premium. The Atlanta Fed data consistently shows that changing employers delivers substantially higher wage growth than staying. For employees who are aware of the market and have options, internal merit cycles that produce 0.7% real raises cannot compete with external mobility on financial terms. This is why retention strategy requires more than competitive merit budgets — career growth, flexibility, and culture carry the weight that compensation budgets cannot.

Compression against historical raises. After three or four years of below-inflation or barely-above-inflation merit cycles, the real value erosion compounds. An employee earning $80,000 today who received 3.0%, 3.2%, 3.5%, and 3.5% raises over four years of 3.5–4.0% inflation has seen net purchasing power decline. The merit increases looked reasonable in isolation; the cumulative effect is a meaningful real pay cut.

The output that brings this into a single number is Real Raise After Inflation. Putting that figure on the merit planning document — "our weighted average merit raise will deliver 0.4% in real purchasing power improvement" — changes the conversation with leadership about budget allocation before the cycle begins, not after employees receive offers from competitors.

Transform Your Excel Models into Web Tools

Turn your complex Excel calculations into online calculators, web forms, and APIs. No coding required — upload your spreadsheet and publish your calculations instantly.

Calculations are for estimation and planning purposes. Users should verify important results for their specific situations. No signup required. Calculations performed securely.