1) Actual HRA Received, 2) Rent Paid over 10% of salary, 3) 50%/40% of Salary. For this purpose salary means Basic+DA. Calculation for the figures given by you will be following: 1) Actual HRA Received: Rs. 24000 per month, 2) Rent Paid over 10% of Salary: Rs. 84000- (10% of 81360), i.e 84000-8136=75864.
87A. An assessee, being an individual resident in India, whose total income does not exceed five hundred thousand rupees, shall be entitled to a deduction, from the amount of income-tax (as computed before allowing the deductions under this Chapter) on his total income with which he is chargeable for any assessment year, of an amount equal to hundred per cent of such income-tax or an amount of
Improved version of Excel Salary Sheet Vids . Please if you feel difficulty to understand. Please visit below vids link for more clarity.Excel : Salary Sheet
salary sheet in excel | D.A , HRA, PF, ESI, GROSS SALARY | MS Excel#msexcel #data_entry_in_excel #salary_sheet #salary_sheet_in_excelWelcome to Computer Gya
5. HRA Calculation Formula With Example. HRA calculations are based on a number of factors, including your salary, the HRA you receive from your employer, the actual rent you pay, and whether you live in a metro or a non-metro city. However, when computing the HRA tax calculation, the amount of exemption will be the lowest of:
Out of the same, Mr A has already utilised 200 days of paid leave and is left with 325 days of unutilised leave. Mr A was drawing basic salary + DA of Rs 33,000 per month at the time of retirement and received Rs 3,57,500 as leave encashment calculated based on 325 days * Rs. 1,100 (salary per day = Rs.33,000/30 days).
Then add the following formula to the cell where you want to get the result. =C5*D5. Here, C5 = Gross Salary. D5 = Basic Salary Percentage. Click ENTER and the desired output will come. Now use the Autofill to drag the formula to every cell you want the output and you will get the basic salary of every employee.
LePy. 8xd1ejmgdj.pages.dev/3508xd1ejmgdj.pages.dev/3058xd1ejmgdj.pages.dev/698xd1ejmgdj.pages.dev/2158xd1ejmgdj.pages.dev/3928xd1ejmgdj.pages.dev/1788xd1ejmgdj.pages.dev/2668xd1ejmgdj.pages.dev/2988xd1ejmgdj.pages.dev/15
hra calculation formula in excel
