Compensation Analysis Template

  • Compares base salary and total compensation against external benchmarks to assess competitiveness
  • Highlights employees paid below market (compa-ratio < 0.9) who may be at risk of leaving
  • Assigns "high," "medium," or "low" priority to salary adjustments based on the distance from market benchmarks
  • Aggregates base salary, variable pay, and equity value to provide a holistic view of an employee's total compensation
Download resource SaveSave this resource
10/10 downloads remaining To avoid copyright infringement and ensure personal usage, downloads are limited to 10 per week.
Downloads 55 downloads Type Template Publication date January 21, 2026 Topics Comp. & Ben.HR OperationsPeople Analytics

The Compensation Analysis Template enables HR teams to evaluate total compensation packages against market midpoints to ensure competitive and equitable pay. It automates the calculation of compa-ratios and provides clear interpretation guidelines to streamline the pay adjustment process.

Included in this resource:

  • Employee details, i.e., name, job title, department, and pay components
  • Compensation breakdown for each employee, tracking base salary, variable pay percentage, and equity value
  • Compa-ratio analysis: Calculating the ratio of base salary and total compensation to the market benchmark
  • Adjustment action plan: Determining the specific dollar amount needed and the priority level for raises
  • A reference table for understanding compa-ratio results
Click here to report a problem or ask a question about this resource.