Compensation


How the calculator works:

By inserting the annual pay values for an employee’s current annual rate and their new rate, after merit is applied, the spreadsheet will  calculate the monthly rate for employees in each of the 9 or 12 month categories, for the remainder of this year, and for next year.   Use row 4, column B for the current salary, and row 5, column B for the new salary.

This is a spreadsheet which provides a calculator to determine the payroll treatment for a partial year pay change, for faculty, who are paid over 9 months as well as those paid over 12 months.  In order for the total annual compensation to be equitable, the pay increase which is applied to each remaining month of this academic year will be based on the 9-month or 12-month schedules.