Income Tax Calculator Excel Sheet Download Now and Calculate Your Tax
As per the new income tax slab proposed by Finance Minister Pranab Mukherjee in Indian budget 2011; Income Tax Calculator for financial year 2011-12 (Assessment Year 2012-13) is attached.
Broadly speaking, the tax slabs exempt all income below INR 1,80,000 whereas the income between INR 1,80,000 and INR 5,00,000 is proposed to be taxed at the rate of 10%. The next income tax slab lies between INR 5,00,000 and INR 8,00,000 for which the rate of taxation is 20%. Finally, all income above INR 8,00,000 would be taxed at the rate of 30%.
A new tax slab has been introduced for senior citizens of 80 years and above. There will not be any tax upto 5 lacs income for people above 80 years.
Current age limit for consideration as senior citizens has been reduced from 65 years to 60. And they will get tax exemption for income up to Rs 2.5 lakh (earlier it was 2.4 lakhs)
Income Tax Rates for financial year 2011-2012
| For Men | |
| Upto Rs. 1,80,000/- | Nil |
| Rs. 1,80,001/- to Rs. 5,00,000/- | 10 per cent |
| Rs. 5,00,001/- to Rs. 8,00,000 | 20 per cent |
| Above Rs. 8,00,000/- | 30 per cent |
| For Women | |
| Upto Rs. 1,90,000/- | Nil |
| Rs. 1,90,000/- to Rs. 5,00,000/- | 10 per cent |
| Rs. 5,00,001/- to Rs. 8,00,000 | 20 per cent |
| Above Rs. 8,00,000/- | 30 per cent |
| For resident individual of 60 years or above (Senior Citizens) | |
| Upto Rs. 2,50,000/- | Nil |
| Rs. 2,50,001/- to Rs. 5,00,000/- | 10 per cent |
| Rs. 5,00,001/- to Rs. 8,00,000 | 20 per cent |
| Above Rs. 8,00,000/- | 30 per cent |
| For resident individual of 80 years or above (Very Senior Citizens) | |
| Upto Rs. 5,00,000/- | Nil |
| Rs. 5,00,001/- to Rs. 8,00,000 | 20 per cent |
| Above Rs. 8,00,000/- | 30 per cent |
This calculator supports inclusion of following salary components:
- Basic salary
- House Rent Allowance (HRA) and HRA exemption calculations
- Dearness allowance
- Transport Allowance
- Child Education Allowance
- Grade/Special/Management/Supplementary Allowance
- Arrears
- Gratuity
- Leave Travel Allowance (LTA)
- Leave Encashment
- Performance Incentive/Bonus
- Medical Reimbursement
- Food Coupons
- Periodical Journals
- Telephone Reimbursements
- Car Reimbursement
- Internet Expense
- Driver Salary
- Gifts From Non-Relatives
- Gifts From Relatives
- House Rent Income
- Professional Tax
- Employee’s PF Contribution
- Employer’s PF Contribution
- Home Loan Interest Component
- Deductions under chapter VIA
- Insurance Premium/ULIP
- Employee’s contribution to PF
- PPF
- ELSS, Mutual Fund
- NSC/NSS/SCSS/Post Office Deposit
- Tution Fees paid
- Housing Loan Principal repayment
- Fixed Deposit for 5 yrs. or more
- Other Eligible Investments
- Total of Section 80C
- Pension Fund (80 CCC)
- Total Deduction under Section 80-C & 80-CCC
- 80D (Medical insurance premium, Self/Family)
- 80D (Medical insurance premium, Parents)
- 80E (Interest on Loan for Higher Education)
- 80U (Handicapped person)
- Donations – 80G (100 % deductions)
- Donations – 80G (50 % deductions)
- Long Term Infrastructure Bonds (Section 80 CCF)
- TDS deduction (Tax deducted at source)
- In Hand monthly salary
- In Hand monthly salary without reimbursments
- Total income this year
- Advance Tax schedule
Important posts:
- Direct Tax Code (DTC): Highlights and Impact
- Income tax calculator for India
- Income Tax Calculator for 2010-11
Income Tax Calculator Excel Sheet Download Now and Calculate Your Tax