Examples of Calculation of Bonus. Case 1 If the Basic salary of the employee is less than or equal to Rs 7,000. Saahil is working as an engineer in a Company in Bangalore. His basic salary is Rs. 6,500 per month. Formula: Basic Salary*8.33% = Bonus per month. 6500*8.33% = 541.45 (6497.4 per annum)
CAGR Calculator. I’d love to hear from you if you have any queries about Personal Finance and Money Management. JOIN Telegram Group and stay updated with latest Personal Finance News and Topics. Download our Free Android App – FinCalC to Calculate Income Tax and Interest on various small Saving Schemes in India including PPF, NSC, SIP and
Salary Slip Template is a ready-to-use template in Excel, Google Sheets, OpenOffice Calc, and Apple Numbers that helps to issue salary slip to the employees with ease. This template performs the calculations automatically. Insert the salary and it calculates the PF and EPS amount based on Indian law.
The Importance of HRA Calculation in Excel. Before delving into the inner workings of Excel formulas and functions, let us first establish the importance of accurate HRA calculation. The House Rent Allowance (HRA) is an important component of an employee’s pay, particularly for those who live in leased accommodation.
Employee contribution = (Basic Pay + DA) X 12% X 12 months. By using the fill handle function of excel, copy the formula till the end. Company Yearly Contribution: Employer or company’s contribution to EPF is 3.67 % according to the EPF and MP Act. Employer Contribution = (Basic Salary + DA) X 3.67% X 12 months.
Summary. To look up employee information in a table with a unique id in the first column, you can use the VLOOKUP function. In the example shown, the formula in cell H6 is: = VLOOKUP ( id, data,2,0) where id (H4) and data (B4:E104) are named ranges. Note: although VLOOKUP is a simple way to solve this problem, you can also use XLOOKUP.
We have created a Salary Sheet With Attendance Register Template with predefined formulas for easy calculations. Excel Google Sheets Open Office Calc. Click here to Download All HR & Payroll Excel Templates for ₹299. Important Note: To edit and customize the Google Sheet, save the file on your Google Drive by using the “Make a Copy
The HRA exemption under section 10(13A) will be Rs. 90,000, being the least of all three amounts mentioned above. The taxable income would then be calculated as the difference between these two figures which is Rs 30,000 (Rs 1,20 000 – Rs 90 000).
Manually insert the leaves of a certain month. Move to Cell J6 to calculate the number of worked days of each employee. =IF (B6=0,"",ROUND (K6/G6*J6,-1)) It is calculated based on the allowed leaves and taken leaves. Press the Enter button and pull the Fill Handle icon. Then, enter the CTC of each employee manually.
The DA will be calculated on the basis of the All India Consumer Price Index. The DA for Central Government Employees was earlier calculated based on the consumer price index with the base year 2001. The Central Government replaced it with a new consumer price index with the base year 2016 to calculate the DA from September 2020.hra calculation formula in excel
