Every employer needs to pay 13% of the employee’s basic salary towards the EPF account of the employee and 3.25% of the employee’s gross salary as ESIC contribution if applicable. How to calculate PF if the basic wage is more than 15,000 Rs. Download Form 16 in Excel format for Ay 2021-22. Download salary breakup calculator excel 2022 which Step 2: Enter the variable part of the CTC like the bonus. Step 3: Enter the basic salary from your CTC. Step 4: ET Money’s Salary Calculator will show the approximate net take-home salary. Step 5: Lastly, You also have the option to calculate actual in-hand salary. In this step, you can enter actual values like HRA, actual rent paid The first step in calculating HRA in Excel is to set up the spreadsheet. This involves creating a new Excel workbook and entering the relevant data into the cells. The data should include the employee’s salary any deductions and any additional benefits. Once the data is entered the HRA formula can be entered into the cells. Human life value is the monetary value of a person’s life. It is determined by the total benefits others depending on him/her may expect to derive from future efforts made by the person whose life is being valued. Evaluating human life in this way is important especially in cases where there happens to be a sole breadwinner as it determines Employee Salary Break Up Report is a ready-to-use Template in Excel, Google Sheet, and OpenOffice Calc that helps you to calculate salary breakup paid under each head. It includes the breakup of salary like how much basic salary, allowances, deductions, etc are paid/deducted during that time. Salary Breakup Report Excel Template can be useful Here are some key reasons why in hand salary calculator is important: 1. Salary Transparency. An in hand salary calculator provides transparency to employees by letting them know the breakdown of their total salary. It portrays various deductions, taxes, and contributions and their impact on the in hand salary. 2. Rent paid minus 10% of salary. ₹20,000 x 12 - 10% (₹30,000 + ₹3,000) x 12 (months) = ₹2,04,000. In this case, the minimum value among these three calculations is the HRA of ₹1,50,000. Therefore, the entire HRA received from the employer, which is ₹1,50,000, is exempt from income tax under Section 10 (13A). Example 1. Calculating percent difference between 2 columns. Suppose you have the last month prices in column B and this month prices in column C. Then your percent change formula takes this form: = (C2-B2)/B2. To calculate the percent difference between two numbers correctly, carry out these steps. 1Oqodx.