Compa Ratio Calculator: Formula & How to Use It

This calculator works out an employee’s compa ratio — the percentage that a salary sits relative to the midpoint of a pay range. You enter the employee’s salary and the range midpoint (or minimum and maximum, from which the midpoint is derived), and you get the compa ratio as a percentage, plus the salary difference from midpoint. It is the standard HR metric for checking whether pay is internally consistent and competitive.

Formula

The compa ratio is a simple percentage:

Compa Ratio (%) = (Employee Salary ÷ Range Midpoint) × 100

Where:

• Employee Salary — the current annual (or hourly) base pay, in the same units as the range.
• Range Midpoint — the middle of the pay range, usually calculated as (Minimum + Maximum) ÷ 2. Some companies set the midpoint from market data instead.

The result is expressed as a percentage. A compa ratio of 100% means the employee is paid exactly at the midpoint. Values below 100% indicate pay below midpoint; above 100% means pay above midpoint.

Worked Example

Using the default values from the calculator above:

• Employee salary = $60,000
• Range minimum = $50,000
• Range maximum = $70,000

First, find the midpoint:

Midpoint = ($50,000 + $70,000) ÷ 2 = $60,000

Then compute the compa ratio:

Compa Ratio = ($60,000 ÷ $60,000) × 100 = 100%

The employee is paid exactly at the midpoint, so the compa ratio is 100%. The difference from midpoint is $0.

Why Compa Ratio Matters

Compa ratio is a core internal equity metric in compensation management. HR teams use it to:

• Check whether new hires are being offered a reasonable salary relative to the pay range.
• Identify employees who are significantly below or above midpoint, which can signal pay compression or high performer rewards.
• Guide salary increase decisions — for example, an employee at 80% may need a larger raise to move toward midpoint.
• Monitor pay equity across teams, departments, or demographic groups.

It is often used alongside external market data (like salary surveys) to ensure pay is both internally fair and externally competitive.

How to Read the Result

Common reference points:

• Below 80% — significantly below midpoint; often a new hire or an employee in a development role.
• 80%–90% — below midpoint but within a typical range for newer or less experienced employees.
• 90%–110% — the “targetâ€� zone for most fully competent employees.
• 110%–120% — above midpoint, often for high performers or those with advanced skills.
• Above 120% — well above midpoint; may indicate a retention risk or a need for promotion to a higher range.

However, these bands are not universal. Each organization sets its own policies. The compa ratio is only meaningful when the pay range itself is well-constructed and up to date.

Common Mistakes and Limitations

Several pitfalls can make compa ratio misleading:

• Mixing units — if the salary is annual but the range is hourly, the ratio is meaningless. Always use the same time basis.
• Using the wrong midpoint — some ranges are not symmetric; the midpoint may be a market reference, not the arithmetic average. If your range has a stated midpoint, use that.
• Ignoring geographic differentials — a compa ratio of 95% in a high-cost city may be less competitive than 110% in a low-cost area.
• Treating it as a performance measure — compa ratio reflects pay position, not performance. Two employees with the same performance can have different ratios due to tenure or hire date.
• Rounding too early — rounding the midpoint before dividing can skew the result, especially with small ranges.

The formula also assumes the range is linear and that midpoint is the intended “market rate.� If the range is skewed or outdated, the compa ratio will be less useful.

Alternatives and Related Metrics

Compa ratio is one of several pay position metrics. Others include:

• Range penetration — (Salary – Minimum) ÷ (Maximum – Minimum) × 100. This shows where the salary falls within the full range, not just relative to midpoint.
• Market ratio — salary divided by an external market rate, rather than the internal midpoint.
• Geographic differential — an adjustment factor applied to a base salary to account for cost of living differences.
• Pay equity index — a broader measure comparing pay across groups after controlling for role and experience.

Each metric answers a slightly different question. Compa ratio is the simplest and most widely used for internal alignment.

How to Choose the Right Midpoint

The midpoint is the anchor of the compa ratio, so it must be chosen carefully. Options include:

• Arithmetic average of min and max — easy to compute, but only accurate if the range is symmetric.
• Market-based midpoint — set from salary survey data for the role and location. This is often the most meaningful, especially for competitive roles.
• Policy midpoint — a value that the company has decided represents “full competencyâ€� pay, which may differ from the arithmetic midpoint.

If your organization uses a market-based midpoint, enter that value directly into the calculator instead of the min and max.

Frequently Asked Questions

What is a good compa ratio?

There is no single “good� number. Many companies aim for 90%–110% for experienced employees, with 100% being the target for full competency. New hires often start at 80%–90%, and high performers may reach 110%–120%. The right value depends on your pay philosophy and market conditions.

How do I calculate compa ratio in Excel?

Use the formula = (Salary / Midpoint) * 100. If you have min and max in cells A1 and B1, and salary in C1, the formula would be = (C1 / ((A1+B1)/2)) * 100. Format the cell as a number with one decimal place.

What is the difference between compa ratio and range penetration?

Compa ratio compares salary to the midpoint, while range penetration compares salary to the entire range from minimum to maximum. Range penetration is calculated as (Salary – Min) / (Max – Min) × 100. A salary at the minimum has 0% penetration; at the maximum, 100%.

Can compa ratio be over 100%?

Yes. A compa ratio above 100% means the employee is paid more than the midpoint. This is common for senior employees, those with scarce skills, or long-tenured staff who have received raises over time. Values above 120% may warrant review for promotion or range adjustment.

Should I use annual or hourly salary for compa ratio?

Either works, but the salary and the range must be on the same basis. If your pay range is annual, use annual salary. If it’s hourly, use hourly wage. Mixing the two will give a nonsensical result.

What if my pay range is not symmetric?

If the midpoint is not exactly halfway between min and max, use the stated midpoint from your salary structure. The calculator’s formula assumes a symmetric range, so for asymmetric ranges, enter the midpoint directly (if you have it) or use a different tool.

Related

• Bladder Volume Calculator: Formula & Normal Range
• Bing Square Footage Calculator? How to Use It
• Bilateral Factor Calculator: VA Disability Math

in s | Employee salary | $ | 60000 | 0
in min | Range minimum | $ | 50000 | 0
in max | Range maximum | $ | 70000 | 0
out ratio | Compa ratio | % | s / ((min + max) / 2) * 100 | 1
out mid | Range midpoint | $ | (min + max) / 2 | 0
out diff | Difference from midpoint | $ | s - (min + max) / 2 | 0