Excel Income tax calculator FY 20-21 (AY 21-22). Which one will save more tax, New income tax or Existing income tax?

Summary :

Maximum savings – ‘Existing’ income tax rate slab,

Minimum savings – ‘NEW’ income tax rate slab.

Income tax rate slab for Financial Year 2020-21 (AY 21-22) in India :

Smt. Nirmala Sitharaman presented Union Budget for FY 2020-21, in which she had mentioned all sector’s budget allocation, performance. GDP forecast, budget deficit etc., but the most important topic like always was the tax rate slab change. People were eagerly glued on to TV, mobile for this tax rate change.

Now she has introduced new tax slab and given us both the option to choose. So, obviously confusion started as which one is better? 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 next financial year 2020-21.

Excel Income tax Calculator
Income tax Calculator

Tax rate changed and the Finance Minister has given us the 2 options, either remain in Existing tax regime or come to NEW tax regime. Here, you can see the difference of tax slabs between Existing and new tax regime.

‘NEW’ Income tax rate slab for FY 20-21:

Sl. No.Income EarnedTax rate (%)
1Up to 2.5 Lakh0
22.5 Lakh – 5 Lakh5
35 Lakh – 7.5 Lakh10
47.5 Lakh – 10 Lakh15
510 Lakh – 12.5 Lakh20
612.5 Lakh – 15 Lakh25
7more than 15 Lakh30%
NEW tax rate slab, Income tax rate slab for FY 20-21:

Also Read: FY 19-20 Income tax return e-filing, exemptions, deductions, e-payment, refund and excel calculator

‘Existing’ Income tax rate slab for FY 20-21:

Sl. No. Income Earned Tax rate (%)
1Up to 2.5 Lakh0
22.5 Lakh – 5 Lakh5
35 Lakh – 10 Lakh20
7more than 10 Lakh30%
Existing Income tax rate slab for FY 19-20 and FY 20-21

Also know: Post office and small savings Interest rates from 1st Oct 2020

3 Case studies showing the difference between ‘Existing’ and ‘New’ tax schemes:

Case 1 to choose between existing or new income tax slabs:

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.

It the the case for someone who has done Maximum savings. He may save 68,640 in Existing tax slab in comparison to the existing income tax rate slab.

Excel Income tax Calculation for - who saves more - Case 1
Excel Income tax Calculation for – who saves more – Case 1

Case 2 to choose between existing or new income tax slabs:

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.

It is the case for someone who has done almost ZERO savings. He may save 52,500 in New tax slab in comparison to the existing income tax rate slab.

Excel Income tax Calculation for - who saves nothing - Case 2
Excel Income tax Calculation for – who saves nothing – Case 2

Case 3 to choose between existing or new income tax slabs:

This is the case of customization, means you can calculate based on your profile. Suppose you live in company provided residence, but does not have NPS facility or medical insurance premium or donated to PM fund for covid-19, flood etc. Like these, there may be so many exemptions and deductions for different types of people.

For an employee who is availing 80C deductions at maximum, NPS contribution by employer and paying interest on home loan. This is just an sample, you can change it your way.

Excel Income tax Calculation for - who saves forcibly - Case 3
Excel Income tax Calculation for – who saves forcibly – Case 3

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 2020-21 in Excel / Download Income Tax Calculator for Assessment Year 2021-22 in Excel / Download Calculator for Income Tax for FY 2020-21 in Excel / Download Calculator for Income Tax Calculator for AY 2021-22 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 figure 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.

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.

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.

%d bloggers like this: