{"product_id":"promotion-and-internal-equity-calculator","title":"Promotion and Internal Equity Calculator","description":"\u003cp\u003ePressure-test one promotion before you commit to it. Enter the current salary, the new grade and its range, the proposed pay, and what peers already earn, and the workbook shows the size of the raise, where it lands in the new range, how it compares to peers, and what it costs in the first year.\u003c\/p\u003e\u003ch3\u003eOne Excel workbook that prices a promotion before you make it\u003c\/h3\u003e\u003cp\u003eA working model, not a blank grid. You enter one move, the workbook returns the raise, the range position, the peer read, and the first-year cost, and it opens on a filled-in example so the math is clear before you change anything.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003ePromotion and Internal Equity Calculator.\u003c\/strong\u003e Enter the current salary, the new grade with its minimum, midpoint, and maximum, the proposed pay, and the peers already in that grade. The workbook returns the increase, the range position, the peer comparison, and the loaded first-year cost, and opens on a filled-in example so the logic is clear before you change anything.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe summary, the cost, and the math in plain English.\u003c\/strong\u003e A one-page summary carries the whole case into the approval: the raise, the range position, the peer read, and the loaded first-year cost. A Benchmark tab shows typical promotion increases, and the Notes tab documents how each number is calculated and how to act on it.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eThree steps from a proposed promotion to a decision\u003c\/h3\u003e\u003cp\u003eYou set the move, add the peers and the cost assumptions, and the workbook shows whether the number holds up.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eSet the move.\u003c\/strong\u003e Enter the current salary, the new grade with its minimum, midpoint, and maximum, and the proposed new salary.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAdd peers and assumptions.\u003c\/strong\u003e Enter what the people already in the new grade earn, and set the payroll tax and benefits rates for the cost view.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRead it and decide.\u003c\/strong\u003e See the raise, the range position, the peer comparison, and the first-year cost, and adjust the number before it goes for sign-off.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eA promotion priced the way it gets questioned\u003c\/h3\u003e\u003cp\u003eA raise that looks fine as a percentage can still land in the wrong part of the range or past peers, so the workbook keeps range position, peer pay, and cost on the surface.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eRange position, not just a percent.\u003c\/strong\u003e The workbook reports compa-ratio and range penetration against the new grade, so a promotion does not start someone near the top of the range by accident.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eInternal equity on the surface.\u003c\/strong\u003e The proposed pay sits next to the peers already in the grade, with a compression check to the level above, because paying past peers is the most common promotion mistake.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe cost, not just the raise.\u003c\/strong\u003e Payroll tax and benefits load onto the increase, so the first-year cost is what you take to approval rather than the headline number.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eWho this calculator fits and where to go if that is not you\u003c\/h3\u003e\u003cp\u003e\u003cstrong\u003eBuilt for\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eAn HR lead or manager preparing a single promotion who needs the raise sized right before asking for approval.\u003c\/li\u003e\n\u003cli\u003eA comp partner sanity-checking promotion requests against the range and against peers.\u003c\/li\u003e\n\u003cli\u003eA small-business owner promoting someone for the first time who wants the move to hold up if other people ask about it.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eIf you are looking for\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eA whole pay structure to build, not one move. The Salary Band Builder builds the grades and ranges this promotion lands inside.\u003c\/li\u003e\n\u003cli\u003eThe annual raise cycle across the team, not a single promotion. The Merit Increase Matrix pairs performance with range position and totals the merit budget.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eBefore you buy\u003c\/h3\u003e\u003cp\u003e\u003cstrong\u003eWhat format is it and can I edit it?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eIt is one Excel workbook that also works in Google Sheets. Every input and formula is editable, and the file is yours to keep. Duplicate it to test another promotion or to compare two offers side by side.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eHow accurate is the result?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eIt is exactly as good as the range and peer numbers you enter. The workbook does the range position, the peer comparison, and the first-year cost correctly from those inputs. It does not pull market data or set your promotion policy, so confirm your range data is current and review a sensitive move with a qualified professional before it is final.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eDoes it tell me how big the raise should be?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eNo. It shows the size of the raise you propose and where it lands, so you can judge it against your own policy and your peers. The number is your call.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eDoes it include salary survey or market data?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eNo. It works from the grade ranges and peer pay you enter. Pull those from your own structure or a current survey.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat is the refund policy?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eDigital products are covered by a 14-day money-back guarantee. See the refund policy for the full terms.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat happens after I buy?\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eCheckout delivers an instant download link, and a receipt with the same link arrives by email. Open the workbook in Excel or Google Sheets and start with the inputs on the first tab. If a file gives you trouble, email support@truestephr.com.\u003c\/p\u003e\u003cp\u003ePlanning estimates and general business information, not legal or tax advice. A promotion changes pay, and pay decisions carry equity and legal weight, so confirm your own range data and review sensitive moves with a qualified professional. Last reviewed June 2026.\u003c\/p\u003e","brand":"TrueStep HR","offers":[{"title":"Default Title","offer_id":52641503084820,"sku":"TSHR-020","price":29.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1013\/9048\/3732\/files\/TSHR-020__promotion-and-internal-equity-calculator-hero.jpg?v=1781149799","url":"https:\/\/shop.truestephr.com\/products\/promotion-and-internal-equity-calculator","provider":"TrueStep HR","version":"1.0","type":"link"}