On 1st February 2025, FM has introduced new income tax slab for individuals for FY 2025-26. This time the deduction and tax slabs have been changed to give relief to salaried class.
For FY 25-26, there is a change in the New income tax slab, while the slabs of Old tax regime has been kept unchanged. The Old tax regime and New tax regime – both are tax saving, but that depends on the ‘earned income’ and ‘types of savings’ of a person. So, how to choose wisely? This excel calculator will help you in finding the difference of tax amount between old and new, with 2 case studies.
Excel Income tax calculator for FY 25-26 (AY 26-27) – Which one will save more tax, New income tax or Old income tax?
Summary :
‘Old’ income tax rate slab – If you have more ‘savings’ like 80C, Home loan interest, NPS, APY etc
‘NEW’ income tax rate slab – If you have less ‘savings’ like 80C, Home loan interest, NPS, APY etc
Income tax rate slab for Financial Year FY 25-26 (AY 26-27) in India :
So, here you have one simple Excel Calculator for income tax, in which only you have to put salary and your deductions, that’s it. Rest leave all to this excel calculator, which will show you the tax amount in old regime, tax amount in new regime and their difference indicating which one is suitable for filing the income tax return for the financial years FY 25-26 (AY 26-27).
Tax rate has been changed and the Finance Minister has given us two options, either remain in OLD tax regime or come to NEW tax regime. Here, you can see the difference of tax slabs between Old and New tax regime.
‘New Income tax’ rate slab for Financial Year FY 25-26 (AY 26-27) in India:
Income tax is Zero (0) up to taxable income of Rs. 12,00,000 for FY 25-26 (AY 26-27) under new tax regime. The ‘new’ income tax rate slab for Financial Year FY 25-26 (AY 26-27) is mentioned below in the table.
| Income Earned during FY 25-26 | Income Tax rate (%) – NEW Option FY 25-26 (AY 26-27) |
| Up to 4 Lakh | 0 % |
| 4 Lakh – 8 Lakh | 5 % |
| 8 Lakh – 12 Lakh | 10 % |
| 12 Lakh – 16 Lakh | 15 % |
| 16 Lakh – 20 Lakh | 20 % |
| 20 Lakh – 24 Lakh | 25 % |
| more than 24 Lakh | 30 % |
‘Old Income tax’ rate slab for FY 25-26 (AY 26-27):
Under Old tax regime, Income tax is Zero (0) up to taxable income of Rs. 5,00,000 for FY 25-26 (AY 26-27. The ‘old’ income tax rate slab for Financial Year FY 25-26 (AY 26-27) is mentioned below in the table.
| Income Earned in a FY 25-26 | Old Income Tax rate (%) – FY 25-26 |
| Up to 2.5 Lakh | 0 |
| 2.5 Lakh – 5 Lakh | 5 |
| 5 Lakh – 10 Lakh | 20 |
| more than 10 Lakh | 30% |
Also Read : Fixed deposit interest rates of ICICI, HDFC, Axis banks’ comparison – Latest
Excel income tax calculator to download:
Here you can download Income Tax Calculator applicable for Financial Year FY 25-26 (AY 26-27) in Excel.
We may calculate income tax for any salary and deductions based on our investment, deduction and exemption here. Here I am attaching the excel calculator link to download and for calculation by yourself.
Just change the figures like Salary, Home loan principal, Home loan Interest, NPS contribution by employee and by employer separately, 80C deductions, Medical u/s 80D etc., you will know the tax amount difference. This will help you to decide which income tax scheme you should choose, new or old. This excel income tax calculator has been updated with 80TTA section, Short term capital gains, Long term capital gains etc.
2 Case studies showing the difference between ‘Old’ and ‘New’ tax schemes for FY 25-26 (AY 26-27)
Case 1 to choose between Old or New income tax slabs for FY 25-26 (AY 26-27):
For an employee who is availing home loan interest benefits, Medical Premium under 80D, NPS Contribution U/s 80CCD (1B) – means contribution by employee to NPS, 80C deductions all at maximum value, with small investment in share market. It is the case for someone, who has done Maximum savings.
Case 2 to choose between Old or New income tax slabs for FY 25-26 (AY 26-27):
For an employee who is availing NO home loan interest benefits and NO 80C deductions, NO Medical Premium under 80D, No NPS Contribution U/s 80CCD (1B) – means contribution by employee to NPS and also with small investment in share market. It is the case for someone who has done almost ZERO savings.
To know all about the income tax sections about deductions, exemptions and rebates on savings, FDs, Stamp duty, Principal of home loan, donations to PM relief fund, trust or charity – Click here.
TAX CALCULATOR – OLD REGIME VIS-À-VIS NEW REGIME by Income tax India department:
Income tax department has also released a calculator to know the difference between OLD tax regime and NEW tax regime. This income tax calculator is for For Individual / HUF / AOP / BOI / Artificial Juridical Person (AJP) as per section 115BAC proposed by Finance Bill, 2023. Also, it is for male, female, senior citizen and super senior citizen. This is not an exact calculator, but an indicative one.
TAX CALCULATOR – OLD REGIME VIS-À-VIS NEW REGIME
Also Read : Fixed deposit interest rates of all Govt. banks comparison – Latest
Disclaimer: Kindly refer income tax official website for any inconsistencies in rules, understandings and clarification.
where is HRA section in that
For HRA, 2 options are there – Either You reside in company provided flat or reside in your accomodation. In company flat, you get less adjusted salary and in the personal accomodation, you get salary with HRA. So, in both cases, put salary in salary field in excel calculator.
great work for comparing old and new regimes. pls upload revised excel sheet with new slabs and standard deduction for FY 24
Thanks for creating this excel and providing it…..it made tax calculation & comparison very easy
Thanks