Skip to content
The title slide and first slides of the Pay Raise Calculator template

Pay Raise Calculator

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 16, 2026

Every slide (5)

Overview

A raise is easier to judge when it is shown in the units you live in: a yearly figure, a monthly figure and the amount on each paycheck. This calculator does the conversion. The Pay tab holds your current yearly pay, hours, weeks and paychecks a year, and finds your hourly rate and pay per paycheck. The Raise tab lists as many scenarios as you like, each as a percent or a dollar amount a year.

For every scenario the sheet shows new pay, the gain per year, month and paycheck, the new hourly rate and the effective percent raise, which lets you compare a percent raise and a dollar raise directly. The Result tab picks out the best of them and adds a table of raises between two and ten percent plus a chart. The sample compares a cost-of-living adjustment, a merit raise, a promotion, an outside offer and a counter-offer on 68,000 dollars of pay.

Useful for

  • Comparing a counter-offer with a new job's pay
  • Preparing for a salary conversation with numbers
  • Converting a dollar raise into a percent

What's included

  • 4 tabs: Pay, Raise, Result, How to use
  • Pay: a table
  • Raise: a table
  • Result: a dashboard with 4 summary figures
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Pay tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I calculate a raise percentage?

Divide the dollar increase by your current pay. The Raise tab does this in the Effective raise column, so a dollar raise can be compared with a percent raise.

How much more will each paycheck be?

Divide the yearly gain by the number of paychecks in the year. The sheet shows the gross amount, so the amount after tax will be lower.

Does this work for an hourly job?

Yes. Multiply your hourly rate by hours a week and weeks a year to get yearly pay, then enter it. The sheet shows the new hourly rate for each scenario.

  • #financial-calculator
  • #pay-raise-calculator
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More financial calculator templates

See all 29

Also in Finance

All finance templates
Get this template

Preparing your template…