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

Download Excel file to

• Calculate and compare Taxable Income and Income Tax Liability as per the Existing and New Regimes (Tax Provisions & Tax Rates) for AY 2021-22 (FY 2020-21).
• Save your calculations on your computer for future reference.

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: