Have an account? Log in to check out faster.
Promotion and Internal Equity Calculator
Review the numbers behind a promotion before approving it. Enter the current salary, new grade and salary range, proposed pay, and peer salaries. The workbook calculates the raise, shows where the proposed salary falls in the new range, compares it with peer pay, and estimates the first-year cost.
Enter the current salary, the new grade with its minimum, midpoint, and maximum, the proposed pay, and salaries for peers already in that grade. Add payroll tax and benefits rates to calculate the cost. The workbook shows the increase, range position, peer comparison, and loaded first-year cost. The one-page Summary brings the full case together for approval, and the Benchmark tab shows typical promotion increases. The workbook opens with a filled-in example so you can see how the calculations work.
The percentage increase is only one part of a promotion decision. The workbook calculates compa-ratio and range penetration against the new grade so you can see where the proposed salary falls within the range. It compares that salary with peers already in the grade and checks for pay compression with the level above. Payroll tax and benefits are added to the increase, giving you the loaded first-year cost for approval. You can review the proposed raise, peer pay, range position, and full cost together.
For a complete pay structure, the Salary Band Builder creates the grades and ranges used for promotion decisions. To plan the annual raise cycle across a team, see the Merit Increase Matrix.
What format is it, and can I edit it?
You receive one Excel workbook that also works in Google Sheets. The download is five files: the workbook, a Start Here, the one-page Quick Reference, the product license, and a short guide to using it in Google Sheets. Every input and formula is editable. Duplicate the file to test another promotion or compare two offers side by side. Your download link is available immediately after checkout, with the same link included in your emailed receipt.
Does the workbook recommend a raise amount or include market data?
You choose the raise amount. The workbook calculates the increase and compares the proposed salary with the new grade range and peer pay so you can assess it against your compensation policy. It does not recommend a raise amount or pull salary survey or market data. Enter grade ranges and peer salaries from your own structure or a current survey.
How accurate is the result?
The calculations depend on the salary ranges and peer pay you enter. The workbook uses those figures to calculate range position, peer comparisons, and first-year cost. Confirm your range data against current figures and review sensitive promotion decisions against your compensation structure before final approval.
What is the refund policy?
Digital products are covered by a 30-day money-back guarantee. To request a refund, email support@truestephr.com or reply to your receipt within 30 days of purchase. Questions? Email support@truestephr.com.
These are planning estimates, not legal advice. Confirm range and peer data against current figures and review promotion decisions for compliance with applicable pay-equity laws before final approval.
How the download works
Your files arrive as a single ZIP download, best opened on a computer. Save it, extract it (right-click and select Extract All on Windows, or double-click on a Mac), then open the Start Here file first. PDFs open in any reader, and editable files work in Microsoft Excel or free equivalents, including LibreOffice and Google Sheets. No other software is needed. Step-by-step help for every device is at truestephr.com/pages/download-help.
FREE HR GUIDE
A five-minute screen that catches the most common and most expensive people decisions before they go wrong. Free guide, plus practical HR tools and guidance sent to your inbox.
No spam. Unsubscribe at any time.