Income Tax Calculator for FY 2019-20 (AY 2020-21) – Excel Download

This is an Income Tax Calculator India for the FY 2019-20 (AY 2020-21) and can be downloaded in Excel format.

This calculator calculates Income from..

  1. Salary,
  2. Pension,
  3. House Property (1 SOP & 2 LOP) along with Set off & carry forward of loss therein, and
  4. Other Sources.

This is useful for all Individuals, viz. Normal Citizen, Senior Citizen & Very Senior Citizen.

Click below to download an Excel calculator.

Income Tax calculator Monthly tabulation of Salary Data, for Income Tax calculator on Salary & for Income Tax calculator on Pension.

 

Income Tax slabs for FY 2019-20 (AY 2020-21)
General public
less than 60 years of Age
Senior Citizen
(60-80 years of Age)
Very Senior Citizen
more than 80 years of Age
Income Slab Tax Income Slab Tax Income Slab Tax
Up to ₹ 2.5 lakhs Nil Up to ₹ 3 lakhs Nil Up to ₹ 5 lakhs Nil
₹ 2.5 to 5 Lakhs 5% ₹ 3 to 5 Lakhs 5% ₹ 5 to 10 Lakhs 20%
₹ 5 to 10 Lakhs 20% ₹ 5 to 10 Lakhs 20% Above ₹ 10 lakhs 30%
Above ₹ 10 lakhs 30% Above ₹ 10 lakhs 30%

Additional points :

Standard Deduction of ₹ 50,000 to Salaries person as well as to Pensioners.

Education + Health cess @ 4%

A surcharge is as per the below table..

Income S.C. on Tax
Income is less than 50 Lakhs NIL
Income is More than 50 Lakhs & Less than 1 Cr. 10%
Income is More than 1 Cr. & Less than 2 Cr. 15%
Income is More than 2 Cr. & Less than 5 Cr. 25%
Income is More than 5 Cr. 37%

Tax Credit of ₹ 12,500/- for income up to ₹ 5,00,000 under section 87A.

Slabs are the same, both for Male & Female.

For Income Tax Calculator for FY 2018-19 (AY 2019-20) click here to download in Excel for free.

To calculate Interest for FY 2018-19 (AY 2019-20) click here to download in Excel for free.

For Income Tax Calculator for FY 2020-21 (AY 2021-22) click here to download in Excel for free.

.

Related posts

7 Thoughts to “Income Tax Calculator for FY 2019-20 (AY 2020-21) – Excel Download”

    1. Admin

      Very soon I will be publishing FY 2020-21.

  1. narayana

    Hi Sir,

    Greetings!,

    I have download the income tax calculation excel , but problem is it is password protected, Can you please share the password with us sir, it is help to carrier sir,

    thanks in advance sir

  2. R.Krishna Moorthy

    DEAR SIR.,

    GOOD MORNING.,

    PLS UPDATE FY 20-21 TDSSALARY WORKING SHREET

    1. Admin

      I will update soon

  3. Dhaneesh Kumar

    how to get password?

    1. Admin

      The calculator is designed to work automatically. The cells are protected to avoid misfunction in case the formula gets deleted or altered by mistake.

Leave a Comment