-
Excel workbook preview
Compensation, Pay Equity and Benefits
Merit Increase Matrix and Budget Calculator
3 downloads per free account, no card needed.
Who this is for
A reward lead or line manager in the annual pay review who must propose fair increases within the budget finance approved.
What is inside
- Merit matrix of 5 ratings x 4 compa-ratio bands with guide percentages
- 12 sample employees with guide increase looked up automatically by INDEX and MATCH
- Increase above the range maximum split off as a lump sum, flagged amber
- Proposals more than 1 point from the guide turn red until a rationale is written
- Budget check: payroll, budget, base increases, lump sums and remaining budget in red or green
- New base pay and new compa-ratio calculated for every proposal
How to use it: Enter the approved matrix and budget on Matrix and your ranges on Ranges, then let managers propose increases in column K and resolve every red cell.
Files & formats
- XLSXmerit-increase-matrix-budget-calculator.xlsx16 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.



