Salary Band & Pay Range Structure Calculator
Enter a market midpoint for your anchor level, a midpoint progression percentage between levels, and a range spread percentage to generate a complete 4-level salary band structure — with minimum, midpoint, and maximum for each level, band overlap between adjacent levels, and individual employee positioning via compa-ratio.
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 FileFull Structure from Three Inputs
Enter an anchor midpoint, midpoint progression, and range spread — the calculator generates minimum, midpoint, and maximum for all four levels without any line-by-line entry.
Band Overlap Diagnostic
Calculates the overlap percentage between adjacent levels — the structural health metric that reveals whether promotions represent meaningful pay steps or are undermined by compressed bands.
Compa-Ratio & Pay Position
Enter any employee's salary and level to see their compa-ratio, quartile position, and gap to the next level midpoint — the three numbers that anchor merit and promotion conversations.
Frequently Asked Questions
What is a salary band and how does a pay structure actually work?
A salary band — also called a pay range or compensation range — is the defined minimum, midpoint, and maximum salary for a job level within an organization. A pay structure is the full system of bands stacked across levels, typically 4–8, that defines how compensation scales as employees develop, advance, and take on broader scope.
Each band has three components that serve distinct purposes:
Minimum — the lowest salary the organization will pay for a new or still-developing employee at this level. Typically 80% of the midpoint. Paying below the minimum is a pay equity risk and a correctable exception, not a policy.
Midpoint — the market rate. What a fully competent, consistently performing employee at this level should earn based on external salary survey data. The midpoint is the structural anchor — every other number in the band is derived from it. It does not represent what you currently pay your team; it represents what the external market pays for comparable work.
Maximum — the ceiling for this level. Typically 120% of the midpoint. Paying above the maximum means either a promotion is warranted, the band needs to be updated to reflect market movement, or the situation is documented as a formal exception.
The three design parameters that generate an entire structure from scratch:
- Anchor midpoint: what the market pays for your Level 1 (or whichever level you anchor to)
- Midpoint progression: the percentage increase in midpoint from one level to the next
- Range spread: how wide each band is, expressed as (max − min) ÷ min × 100
This calculator takes those three numbers and outputs the complete structure — the same methodology compensation consultants use, without the consulting engagement.
How do I build a salary band structure for my company?
Here is the complete process using the default scenario — a professional services firm designing a four-level individual contributor structure.
Step 1: Anchor to market data. Find the median market pay for your entry level from a published salary survey. Sources: Radford, Mercer, WTW, Payscale, or proxy sources like LinkedIn Salary Insights and BLS Occupational Employment Statistics. This is not what you currently pay people — it is what the external market pays for fully competent employees at this level. For the default: $55,000 for Level 1.
Step 2: Set your two structure parameters.
- Midpoint progression: 20% means each successive level's midpoint is 20% above the previous. Common for individual contributor tracks; management tracks typically use 25–30%.
- Range spread: 50% means the band maximum is 50% above the band minimum. This produces a minimum at 80% of midpoint and a maximum at 120% of midpoint.
Step 3: The structure generates itself. With Level 1 midpoint $55,000, 20% progression, 50% spread:
| Level | Minimum | Midpoint | Maximum |
|---|---|---|---|
| Level 1 | $44,000 | $55,000 | $66,000 |
| Level 2 | $52,800 | $66,000 | $79,200 |
| Level 3 | $63,360 | $79,200 | $95,040 |
| Level 4 | $76,032 | $95,040 | $114,048 |
The complete structure spans $44,000 to $114,048 — a $70,048 range — from three inputs. Level 1 to Level 4 midpoints span $40,040, reflecting the expected pay growth across a full IC career track.
Step 4: Check an individual employee. A Level 2 employee earning $65,000: compa-ratio = $65,000 ÷ $66,000 = 98.5%. They sit at Q2 — Developing, 46.2% through their band. Gap to the Level 3 midpoint: $14,200. The action is clear: continue developing them with moderate merit increases, and have an explicit conversation about what reaching Level 3 scope looks like.
Step 5: Review the overlap. The default structure shows 60% band overlap between adjacent levels — above the 20–40% healthy range. That means 60% of Level 1's salary range is covered by Level 2. Adjusting either the progression or spread (see the last FAQ) brings it into the healthy zone.
What midpoint progression and range spread should I use?
Published guidance from WorldatWork, WTW, and Mercer salary structure surveys:
Midpoint progression by track:
| Track | Typical progression |
|---|---|
| Entry-level / hourly | 10–15% |
| Individual contributor (IC) | 15–20% |
| Senior IC / specialist | 20–25% |
| Management | 25–35% |
Below 15%: bands compress so tightly that level distinctions feel meaningless — a one-level promotion generates almost no pay movement. Above 30% for IC tracks: salaries escalate faster than business growth can sustain.
Range spread by level type:
| Role type | Typical spread |
|---|---|
| Hourly / production | 20–35% |
| Professional / salaried | 40–55% |
| Senior / technical expert | 50–65% |
| Executive | 60–80% |
The 50% default in this calculator is mid-range for professional roles. For hourly workers, 30–35% is more appropriate. For executives where individual negotiation drives wide variation, 60–70% is common.
Band overlap benchmark: 20–40% overlap between adjacent levels is healthy. It means progression is real — employees earn meaningfully more at the next level — while allowing some pay continuity across the boundary.
The default scenario produces 60% overlap, which is above the healthy range. A senior Level 1 employee at $63,000 earns the same as a mid-level Level 2 employee. This dilutes the financial signal of progression and makes promotion conversations harder to anchor. Tightening to 20% progression and 40% spread — or 25% progression with 50% spread — brings overlap into the 30–40% range.
What is a compa-ratio and how do I use it to manage pay?
Compa-ratio = Employee salary ÷ Band midpoint × 100. It is the universal metric for positioning an employee's pay relative to the market rate for their level. A compa-ratio of 100% means exactly at market; below 100% means below market for a fully competent employee at that level.
The four quartile positions and what each tells you:
Q1 — Entry (0–25% through the band, compa-ratio roughly 80–90%): New to the role or recently promoted. Standard for hires who are still ramping to full proficiency. Merit increases here should be larger — 5–7% — to accelerate movement toward the midpoint. A high performer stuck in Q1 after two years is a retention risk.
Q2 — Developing (25–50%, compa-ratio roughly 90–100%): Performing and growing but not yet at full market rate. This is the most common zone for developing employees in their first 2–3 years at a level. Standard merit increases of 3–5% move employees through this range at a predictable pace. The default employee — 98.5% compa-ratio — sits at the top of Q2, nearly at the market midpoint.
Q3 — Competitive (50–75%, compa-ratio roughly 100–110%): Fully proficient at the current level, paid at or above market. This is the target zone for tenured, strong performers. Increases here can moderate (2–4%), focused on maintaining competitiveness rather than catching up to the market.
Q4 — Senior (75–100%, compa-ratio roughly 110–120%): High performer or long tenure. Approaching the band maximum. This is the zone where promotion conversations become structurally necessary — continued pay increases will push above the maximum, requiring either promotion documentation or a formal exception.
Above Range (compa-ratio > 120%): Above the band maximum. Pay equity and compliance risk. Options: promote to the next level if scope warrants it, freeze increases until the market catches up through structure updates, or document as a formal approved exception. Leaving above-range pay unaddressed creates pressure to justify it with other employees and erodes structure integrity over time.
The default employee at 98.5% compa-ratio, Q2 — Developing, with a $14,200 gap to the Level 3 midpoint: the right action is 3–4% merit increases for the next 2–3 cycles, alongside a clear articulation of what Level 3 scope and performance look like. That $14,200 gap gives the employee a concrete number to work toward — which is more motivating and more honest than a vague "you're almost ready for the next level."
What is band overlap, why does 60% overlap signal a problem, and how do I fix it?
Band overlap is the percentage of a lower band's salary range that is also covered by the adjacent higher band. It measures how much of a "raise" a promotion actually represents in structural terms.
In the default scenario, Level 1 runs $44,000–$66,000 and Level 2 runs $52,800–$79,200. The overlap:
($66,000 − $52,800) / ($66,000 − $44,000) × 100 = 60%
Sixty percent of Level 1's range is shared with Level 2. A Level 1 employee at the top of their band earning $63,000 earns the same as a Level 2 employee at the 40th percentile of theirs. When a promotion happens at that point, the pay increase is structurally small — perhaps $2,000–$3,000 — because the employee was already earning what Level 2 entry looks like.
This is the structural reason why managers say "a promotion is the reward, pay comes later" — they're papering over a structure that doesn't differentiate levels clearly enough.
The healthy range is 20–40% overlap. At 30% overlap, a promotion from the top of one band to the minimum of the next represents a meaningful pay step even for high-earning employees at their current level.
Two levers control overlap, and they pull in opposite directions: increasing midpoint progression (wider gaps between level midpoints) reduces overlap; increasing range spread (wider bands) increases overlap. Most organizations need to adjust both simultaneously.
Three scenarios to bring the default from 60% to ~30% overlap:
Option A — Increase progression to 25%, keep 50% spread: Level 1 maximum ($66,000) vs. Level 2 minimum ($68,750): overlap = ($66,000 − $68,750) is negative — no overlap. Better than baseline but progression alone at 25% overcorrects with 50% spread still in place. Result: ~50% overlap.
Option B — Keep 20% progression, reduce spread to 35%: New Level 1: Min $45,720, Max $61,720. Level 2: Min $54,864, Max $74,115. Overlap = ($61,720 − $54,864) / ($61,720 − $45,720) = 43%. Closer to the healthy range.
Option C — 25% progression + 40% spread: Level 1: $46,429–$65,000. Level 2: $58,036–$81,250. Overlap = ($65,000 − $58,036) / ($65,000 − $46,429) = 37.5% — in the healthy range.
This is the adjustment most HR teams make when auditing an existing structure and discovering the bands are too compressed. The calculator lets you model all three scenarios in seconds by adjusting two inputs — rather than rebuilding the structure manually in a spreadsheet.
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.