- bennythadathil
- | Income Tax - Downloads
- 01 Feb 2020
- 82,338 Views
- 14 comments
Income Tax Calculator in Excel; Format for Financial Year 2020-21 / Assessment Year 2021-22
The Finance Minister has proposed to bring a new and simplified personal income tax regime, wherein income tax rates will be significantly reduced for the individual taxpayers who forego certain deductions and exemptions, however the same is options to individual. Hence the assesses have to review the benefits to take call on which option to be exercise. Please review your tax plans for the FY 2020-21.
The proposed changes in tax slabs are listed in the following table:
| Taxable Income Slab (Rs.) | Existing Tax Rates | New Tax Rates |
| 0-2.5 Lakh | Exempt | Exempt |
| 2.5-5 Lakh | 5% | 5% |
| 5-7.5 Lakh | 20% | 10% |
| 7.5-10 Lakh | 20% | 15% |
| 10-12.5 Lakh | 30% | 20% |
| 12.5-15 Lakh | 30% | 25% |
| Above 15 Lakh | 30% | 30% |
Sec 87 Relief – No change
Surcharge and cess shall be continued to be levied at the existing rates.
Sec-80EEA- Tax benefit on the new housing loans, additional deduction of Rs.150,000/- extended for the loans taken till March 31, 2021.
(Republished with amendments)
Author Bio
My Published Posts
More Under Income Tax
14 Comments
Leave a Comment
Latest Posts
- GST: HC cannot be made middle authority between Tax & Appellate Authority
- Section 271(1)(c) Notice should clearly specify charge of Penalty
- Upsurge in E-way bills signals to green shoots in economy
- GSTR 1, GSTR 3B Interest and Late Fees made simpler
- My 3 years with GST
- Compulsory GST Registration | Section 24 | CGST Act 2017 |GST Series Part 16
- GST Applicable on Sale of Plot of Land with Amenities- GAAR
- Row over School Fee- Punjab & Haryana HC Balances Schools & Parents
- Direct & Indirect Taxes Updates- June 2020
- FAQs on Compliance Audit by SEBI Registered Research Analysts
Popular Posts
- Due Date Compliance Calendar July 2020
- Details of Various Types of PAN Applications
- Updated extended GST Due Date Chart
- Form 15CA & 15CB- Things to be kept in mind
- Corporate Compliance Calendar for the Month of July 2020
- Section 68, 69, 69A, 69B and 69C of Income Tax Act, 1961
- Register for GST & Income Tax Course at 50% discount
- Proof of Identity, Address & Date of birth for PAN/TAN application
- Understanding Section 143 of Income Tax Act, 1961
- All about GSTR 1- Monthly Statement of Outward Supplies with FAQs
Featured Posts
- Practical Aspects in Income Tax Scrutiny proceedings
- Benami Transactions – Meaning and Consequences
- Due Date Compliance Calendar July 2020
- Form 15CA & 15CB- Things to be kept in mind
- TDS implication on purchase of property from NRI
- Profits on sale of shares when taxable as capital gains & when as business income
- Income Tax Demand and Notice under Section 245- FAQs
- How to Maintain Safe Distance from Income Tax Department
- How to E-file TDS/TCS Statement
- Income Tax Provision for Doctors
I need help in filing FY20-21 declaration
I am confused. can some one help.
I have LIC three policies worth 93639.94 pa.
I have a PPF worth 12000 pa.
I have a housing loan interest 47k pm.
I am also paying rent worth 9500pm.
my gross pay is 1147919
Amt in INR.
Sir,
I am retired bank employee aged 61 years old
My pension pa Rs 4,92,000/-My income from intt on Sr citizen scheme – Rs 1,29,000/-Interest from FD 3,53,750/- I pay tution & other fees to College 2,21,000/- Donation under 80 G 50,000/- what would be my tax burden.
tnak u sir please send 20-21 tax calcy
Dear Sir
As per your calculator new tax rate has been considered standard deduction and profession tax. As per budget if we go to new tax regime then we can’t get standard deduction and profession tax also. But as per your calculator new tax regime amount was come after considering of standard deduction and profession tax. Please check at you end.
Thank you
ok
Hey Benny,
I am using your excel tax calculators since March 2015.
Its great, simple & accurate.
Thank you.
Hi Benny,
I am using your excel file for a long time and I find it very very useful.
Thank you.
sir, I am retired banker having appx annual pension plus fd interest amounting to rupees 10.91 lacs having no housing loan. As per existing rule I invest 1.50 lacs under section 80c rupees 10200 under section 80d and 50000 under 80ttb and 50000 standard deductions. As per new system I don”t have any option for above deductions but as per my calculations, I presume I would be able to save around 7000 as per new system than submitting my return under existing system. Kindly guide which would be the best for me
NEW SYSTEM U SAVE 21798
30200
1914
Is interest from Tax Free Bonds taxable under new tax regime?
Sir, New IT slabs
1. Interest on housing loan exempted or not?
2. EPF contribution is allowed or not?
3. To employee what is the better slab? Either old or new?
please clarify the above points.
To calculate my income tax from salary.