Download Employee Base Salary Increase Rate Calculator excel template. This template comes with predefined formulas and layout. This template helps you to calculate the percentage increase of the base salary for a given period.
The increment rate can be annual, half-yearly, or quarterly. This depends on the policy of the company. You can also calculate the Base Salary Increase Rate department-wise with this template.
What is base salary in CTC ?
In simple terms, Base salary means the basic salary fixed as compensation apart from allowances. Base salary is the fixed compensation paid to an employee by his employer. It doesn’t include any kind of allowances like HRA, DA, Medical, Conveyance, and even bonus pays.
Employee base Salary Increase rate is the percentage of increase in the basic salaries of employees during a specific period. It can be annually, half-yearly, or quarterly. In General, it happens annually.
About employee base rate increment calculator excel template
Post downloading this template, you will jump into the blue colored table. This template comes with the following four sections
- Department Wise Base Salary Increase Rate
- Yearly Base Salary Increase Rate
- Half-Yearly Base Salary Increase Rate
- Quarterly Base Salary Increase Rate
Based on your requirement you can use the relevant section of this template.
Download and use employee base rate increment calculator excel template
To use this HR and Payroll Metrics excel template, you should have Microsoft Office/ Microsoft Excel installed in your system.
After installing Excel or Spreadsheet, download the zip file of this template, extract the template using WinRAR or 7Zip decompressing software. Once extracted, you can open the file using Excel and start entering data or customizing the template.
