1. Home
  2. Banking
  3. Tax
  4. Forms
  5. ppf - ssy
  6. Sr. Citizen
  7. Widgets
  8. Misc.
Home  ❯  Tax  ❯  This Page

Income Tax Calculator in Excel for AY 2121-22 (Both Regimes)

Online Income Tax Calculator AY 2021-22 | 2022-23

Download Excel file to

Download Income Tax Calculator AY 2021-22 | 2022-23 in Excel

Option for Existing and New Regimes ( Tax Rates )

From Assessment Year 2021-22, Individuals and HUFs (including Resident Individuals below 60 years of age, Senior Citizens and Very Senior Citizens) will have option to opt for Section 115BAC. In case Section 115BAC is opted the computation of income will be as per the provisions of Section 115BAC and New Tax Rates are applicable. In case Section 115BAC is not opted the computation of income will be as per the Existing Provisions and Existing Tax Rates are applicable.

If an Individual / HUF opts for Section 115BAC, no exemption or deduction under the provisions of clause (5) or clause (13A) or prescribed under clause (14) (other than those as may be prescribed for this purpose) or clause (17) or clause (32), of section 10 or section 10AA or section 16 or clause (b) of section 24 (in respect of the property referred to in sub-section (2) of section 23) or clause (iia) of sub-section (1) of section 32 or section 32AD or section 33AB or section 33ABA or sub-clause (ii) or sub-clause (iia) or sub-clause (iii), of sub-section (1) or sub-section (2AA), of section 35 or section 35AD or section 35CCC or clause (iia) of section 57 or under any of the provisions of Chapter VI-A other than the provisions of sub-section (2) of section 80CCD or section 80JJAA from income will be available and New Income tax rates shall be applicable:

S. No.Total IncomeNew Tax Rates
1Upto Rs 2,50,000Nil
2From Rs 2,50,001 to Rs 5,00,0005%
3From Rs 5,00,001 to Rs 7,50,00010%
4From Rs 7,50,001 to Rs 10,00,00015%
5From Rs 10,00,001 to Rs 12,50,00020%
6From Rs 12,50,001 to Rs 15,00,00025%
7Above 15,00,000/-30%
Surcharge
( subject to Marginal Relief )
10% of Income Tax, in case taxable income is above ₹ 50 lacs.
15% of Income Tax, in case taxable income is above ₹ 1 crore.
25% of Income Tax, in case taxable income is above ₹ 2 crore.
37% of Income Tax, in case taxable income is above ₹ 5 crore.
Health & Education Cess4% of (Income Tax + Surcharge).
For more details on Section 115BAC, please refer to the Finance Act No. 12 of 2020

Updated : Jan 26, 2021