INCOME TAX CALCULATION UNDER OLD AND NEW TAX REGIMES FOR F.Y.2020-21 WITH AUTOMATED EXCEL BASED INCOME TAX SOFTWARE ALL IN ONE FOR GOVT & NON-GOVT EMPLOYEES FOR F.Y.2020-21 AS PER THE BUDGET 2020

Income Tax Form 16

On 13th April 2020, the Central Board of Direct Taxes (CBDT) issued a circular to employers to obtain a declaration from their employees if they wish to opt for the new tax regime. For better understanding, to know the calculation procedure under Old and New tax regimes, and to take the decision whether we can select old tax structure or new tax structure, Therefore, I am trying to write an article on this. This will be useful for salaried employees relating to India. Before going to examples under Old and New tax regimes, we need to keep in mind the below important points.

Free download Automated Master of Form 16 Part B for the F.Y. 2019-20 [This excel Based Prepare at a time 50 employees Form 16 Part B for F.Y. 2019-20

Income Tax Revised Form 16
Income Tax Revised Form 16

 1.          In other words, The tax rate slabs of both the Old tax regime and New tax regime are as mentioned below :-

Calculation of Tax under Old tax structure
Tax SlabTax rate
Up to 2,50,000NIL
2,50,001 to 5,00,0005%
5,00,000 to 10,00,00020%
Above 10,00,00030%

However, Calculation of Tax under New tax structure
Tax SlabTax rate
Up to 2,50,000NIL
2,50,001 to 5,00,0005%
5,00,001 to 7,50,00010%
7,50,001 to 10,00,00015%
10,00,001 to 12,50,00020%
12,50,001 to 15,00,00025%
Above 15,00,00030%

2.          Health and Education cess @ 4% will be added to the “Tax payable amount after deduction of rebate u/s 87A”.

3.          Surcharge is levied on taxable income above Rs50,00,000

4.          The individuals who are having taxable income of up to Rs5,00,000 will be eligible for tax rebate u/s 87A up to maximum of Rs12,500, and thereby no need to pay any tax either in old tax regime or new tax regime. (The detailed notes will be there below about sec 87A).

5.          Under the new tax regime, the individuals are eligible for only one deduction u/s 80CCD(2) which allows deduction on the employer’s contribution to the National Pension Scheme (NPS) Account for maximum of 10% of the respective employee’s salary (Basic + DA). Other commonly available deductions such as u/s 80C, 80D, 80E, 80G, and 80U, etc. under chapter VI A, and tax exemptions like House Rent Allowance (HRA), Leave Travel Allowance (LTA), etc. are not available in the new tax regime. The deductions and tax exempts under chapter VI A are mentioned below :-

Deductions under chapter VI A
1. Total aggregate deduction up to Rs1,50,000 of below 3 items i.e. (a), (b), and (c)
(a) Investments in specified schemes, savings instruments, etc. such as :-
(i) Employee contribution to Provident fund (PF)
(ii) Employee contributions to Public provident fund (PPF)
(iii) L I C premium
(iv) Subscription to recognized National Savings Scheme certificates (NSC)
(v) Contribution to Unit Linked Insurance Plan (ULIP)
(vi) Subscription to equity shares and debentures forming part of approved public limited companies
(vii) Subscription to approved Mutual funds
(viii) Subscription to Term deposits for a fixed period of not less than 5 years of approved scheduled banks, and Post offices
(ix) Subscription to notified bonds issued by NABARD
(x) deposit to senior citizen savings scheme
(xi) Subscription to 5-year term deposit with Post Offices.
(b) Contribution to pension funds of LIC or other insurers u/s 80 CCC
(c) Assessee’s contributions to pension schemes of central government u/s 80 CCD (1)
2. Other deductions under VI-A
(d) Deduction up to Rs 50000 in addition to above points (a), (b), and (c) u/s 80 CCD (1B)
(e ) Assessee’s contributions to pension schemes of central government u/s 80 CCD (2)
(f) Amount invested in Health insurance u/s 80 D
(g) Interest paid on Educational loan u/s 80 E
(h) Amount invested in listed shares u/s 80 CCG
(i) Expenditure incurred for the medical treatment of a dependent u/s 80 DD
(j) Expenditure incurred for the medical treatment of specified diseases u/s DDB
(k) Interest on loan for acquired of residential house property u/s 80 EE
(l) Interest on loan for acquired of electric vehicle u/s 80 EEB
(m) persons with disability u/s 80 U
(n) Donations to recognized trusts u/s 80 G
(o) Rent paid for residential accommodation u/s 80 GG
(p) Royalty Income of books u/s 80 QQB
(q) Royalty Income of patents u/s 80 RRB
(r) Interest on Savings Bank Accounts u/s 80 TTA
(s) Interest in deposits with post offices, co-operative banks u/s 80 TTB

6. Eligibility to claim rebate u/s 87A :-

For instance, following conditions should satisfy if we claim the benefit of rebate u/s 87A :-

(a)  we should be a resident individual,

(b)   Our total taxable income (after deductions, but before calculating Health and Education cess) does not exceed Rs12,500.

Above all, then, we are not required to pay any tax either under old tax structure or new tax structure. For example, see the below table.

Rebate u/s 87A under Old tax regime :-

Total Taxable income


Tax payable

Rebate available u/s 87A
Tax payable before Health and Education cess calculated

260000

500(2,50,001 to 2,60,000) x 5%

500

NIL

400000

7500(2,50,001 to 4,00,000) x 5%

7,500

NIL


580000

28500(2,50,000 to 5,00,000) x 5%(5,00,001 to 5,80,000) x 20%


N/A


28500(12,500 + 16,000)
Rebate u/s 87A under New tax regime :-




Total Taxable income





Tax payable




Rebate available u/s 87A



Tax payable before Health and Education cess calculated

260000
500(2,50,001 to 2,60,000) x 5%
500

NIL

400000
7500(2,50,001 to 4,00,000) x 5%
7,500

NIL
580000
N/A

28500(2,50,000 to 5,00,000) x 5%(5,00,001 to 5,80,000) x 15%

24500(12,500 + 12,000)

In addition, based on above points keep in mind, then we can follow the below examples to understand the basic calculation procedure of both the Old tax structure and New tax structure.

Free Download Automated Excel Based Income Tax All in One TDS on Salary for the Govt &Non-Govt Employees with Automated Arrears Relief Calculator U/s 89(1) with Form10E for the Financial Year 2020-21 & Assessment Year 2021-22 ( Both of Old Tax Regime and New Tax Regime)

Feature of this Excel Utility are :-

1)    Prepare all the Income Tax Calculation in one single file like as Automated Tax Computed Sheet + Automated House Rent Exemption Calculation U/s 10(1) A + Automated Arrears Relief calculation U/s 89(1) for F.Y.2020-21,Automated Form 10E + Automated Revised Form 16 Part B for F.Y.2020-21

2)    Automated Income Tax Computed Sheet for both of Govt & Non-Govt employees as per Budget 2020 ( Old & New Tax Regime)

3)    Inbuilt the Salary Structure as per the all of the Government & Non-Government Employees Salary Pattern

4)    Automated House Rent Calculation U/s 10(13A)

5)    Automated Arrears Relief Calculation U/s 89(1) with Form 10E from the F.Y. 2000-01 to F.Y.2020-21 (Updated Version)

6)    Automated Income Tax Revised Form 16 Part A&B for F.Y. 2020-21

7)    Automated Income Tax Revised Form 16 Part B for F.Y. 2020-21

8)    Automated Income Tax Form 10E for F.Y.2020-21

Example 1 :-

ParticularsTax RateOld Tax StructureNew Tax Structure
Total income or Gross Salary
480000480000
Less : Standard deduction
50000N/A
Income after standard deduction
430000480000
Less : Deductions and Tax exemptions of Chapter VI A
800000
Taxable income
350000480000
Calculation of Tax for Old tax structure:-


7500







11500
Up to 2,50,000NIL
2,50,001 to 5,00,0005%
5,00,000 to 10,00,00020%
Above 10,00,00030%
Calculation of Tax for New Tax structure:-
Up to 2,50,000NIL
2,50,001 to 5,00,0005%
5,00,001 to 7,50,00010%
7,50,001 to 10,00,00015%
10,00,001 to 12,50,00020%
12,50,001 to 15,00,00025%
Above 15,00,00030%
Total Tax amount
750011500
Less : Tax rebate u/s 87 A
750011500
Total Taxable amount after rebate u/s 87 A
00
Add : Health and Education cess4%N/AN/A
After that, Total Tax Payable amount to Government
N/AN/A

Note 1 :-

Similarly, the tax amount of Rs11,500 calculated as below :-

There is a taxable amount under New tax regime is Rs4,80,000

On first 2,50,0000%0.00
From 2,50,001 to 4,80,000(i.e. 2,30,000 x 5%)
5%

11500.00


11500.00

Note 2 :-

Total Taxable amount after rebate u/s 87A is considered zero because both the old and New tax regimes are having the rebate u/s 87A is below Rs12,500 which is under eligible limit.

Example 2 :-

ParticularsTax RateOld Tax StructureNew Tax Structure
Total income or Gross Salary
860000860000
Less : Standard deduction
50000N/A
Income after standard deduction
810000860000
Less : Deductions and Tax exemptions of Chapter VI A
23500040000
Taxable income
575000820000
Calculation of Tax for Old tax structure:-


Up to 2,50,000NIL0
2,50,001 to 5,00,0005%12500
5,00,000 to 10,00,00020%15000
Above 10,00,00030%

Calculation of Tax for New Tax structure:-


Up to 2,50,000NIL
0
2,50,001 to 5,00,0005%
12500
5,00,001 to 7,50,00010%
25000
7,50,001 to 10,00,00015%
10500
10,00,001 to 12,50,00020%

12,50,001 to 15,00,00025%

Above 15,00,00030%

Total Tax amount
2750048000
Less : Tax rebate u/s 87 A
00
Total Taxable amount after rebate u/s 87 A
2750048000
Add : Health and Education cess4%11001920
Total Tax Payable amount to Government
2860049920
Benefit by choosing old tax regime is Rs.21320

Note :-

The Health and Education cess @ 4% is calculated on “Total taxable amount after rebate u/s 87A”.

Example 3 :-

ParticularsTax RateOld Tax StructureNew Tax Structure
Total income or Gross Salary
17000001700000
Less : Standard deduction
50000N/A
Income after standard deduction
16500001700000
Less : Deductions and Tax exemptions of Chapter VI A
21000010000
Taxable income
14400001690000
Calculation of Tax for Old tax structure:-


Up to 2,50,000NIL0
2,50,001 to 5,00,0005%12500
5,00,000 to 10,00,00020%100000
Above 10,00,00030%132000
Calculation of Tax for New Tax structure:-


Up to 2,50,000NIL
0
2,50,001 to 5,00,0005%
12500
5,00,001 to 7,50,00010%
25000
7,50,001 to 10,00,00015%
37500
10,00,001 to 12,50,00020%
50000
12,50,001 to 15,00,00025%
62500
Above 15,00,00030%
57000
Total Tax amount
244500244500
Less : Tax rebate u/s 87 A
00
Total Taxable amount after rebate u/s 87 A
244500244500
Add : Health and Education cess4%97809780
Total Tax Payable amount to Government
254280254280
Benefit either by choosing old or New tax regime is Rs.0

In conclusion,

We understand that the old tax regime is beneficial for us when the below conditions are fulfilled ;-

(a)  Total taxable income is more than Rs15,00,000, and

(b)  The total deductions and exemptions of old tax regime are should be more than Rs2,50,000 (including standard deduction), comparing to the deductions under new tax regime which is applicable for only u/s80CCD(2).

If the total taxable income is below Rs15,00,000 then the above said deductions under old tax structure i.e. 2,50,000 gradually decrease, comparing to the deductions under new tax regime which is applicable for only u/s80CCD(2).

Hope this article gives you basic information to opt the suitable tax structure to pay Income Tax.

Enter your email address:

Delivered by FeedBurner

PRANAB BANNERJE

Author

About Author

Hi, Welcome to a leading Income Tax and Accounts Providing Web Site merataxplan.com, merataxplan.com Blog is owned and maintained by Pranab Bandyopadhyay. Basic Idea behind Income Tax & it’s to help people in achieving excellence for save tax. Data shows that even urban Indian taxpayers are less aware about Income Tax and importance of financial planning.

I thought to start a blog and write about Articles related to Income Tax, Income Tax News, Income Tax  planning, Income Tax Easy Excel Based Software and other financial Software in Excel like as Gratuity Calculator, Pension Calculator, Central and Various State Employees Accounts Software in Excel that interest me most, and which I feel will help others make better financial decisions about their money with Tax. I have sound knowledge about in MS Excel, MS Access, Visual Basic, C++, JAVA and much more knowledge on the Computer Applications.

If you are seeking professional advice tailored to your situation – I am sure there are  good certified financial professionals doing that but at merataxplan.com we just try to educate people about how to calculate Income Tax.

There are much more products for sale here but all are related to Income tax And Account Software, and merataxplan.com is not affiliated with any agents or brokers, so I can help you sell any Income Tax & Accounts Software in Excel etc.

The purpose of this blog is to spread Taxation s awareness and help people in achieving excellence for Save Tax. Please note that the views expressed on this Blog/Comments are clarifications meant for reference and guidance of the readers to explore further on the topics. These should not be construed as investment advice or legal opinion.

Hope you find this site useful, in fulfilling your goal towards Income Tax.