• Preview of Merit Increase Matrix and Budget CalculatorExcel workbook preview

Compensation, Pay Equity and Benefits

Merit Increase Matrix and Budget Calculator

$17.99 Free XLSX
Excel workbook · 16 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

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.