Income Tax Calculator for FY 2019-20 [AY 2020-21] – Excel Download

Budget 2019 has made some changes to Income tax for individual – the highlight being full tax rebate for individuals earning below Rs 5 Lakhs. There has been no changes in the income tax slab. We highlight the changes and give you the new tax calculator for FY 2019-20 [AY 2020-21].

Changes in Income Tax Rules:

  1. Rebate under Section 87A changed from Rs 2,500 to Rs 12,500 or 100% of income tax (whichever is lower) for individuals with income below Rs 5 Lakhs (from Rs 3.5 Lakhs)
  2. Standard Deduction raised for Salaried & Pensioners from Rs 40,000 to Rs 50,000
  3. Increased Tax for super-rich: Surcharge increased to 25% for income between 2 to 5 crore & to 37% for income beyond Rs 5 crores
  4. Additional Tax Deduction of Rs 1.5 lakhs u/s 80EEA on home loans on purchase of affordable home
  5. Additional Tax Deduction of Rs 1.5 lakhs u/s 80EEB on Auto loans on purchase of Electric vehicles
  6. No Tax on Notional Rental Income from Second House
  7. Capital gains exemption on reinvestment in two house properties: Tax payers can now buy two houses on sale of 1 house if the capital gains are less than Rs 2 crore. This benefit can be availed only once in lifetime
  8. TDS threshold increased from Rs 10,000 to Rs 40,000 on Bank Interest Income

For Details of changes read: 19 Key changes in Budget 2019

Download Income Tax Calculator (FY 2019-20)

Download: Free ebook for Income Tax Planning for FY 2019-20

Income Tax Slab for FY 2019-20 [AY 2020-21]

For Income Tax Purpose – citizens above age of 60 are considered as Senior Citizens and above age of 80 are considered Very Senior citizens.

Income Tax Slabs for FY 2019-20 (AY 2020-21)
Income Tax Slabs for FY 2019-20 (AY 2020-21)

Download Income Tax Calculator

You can download the Income Tax Calculator for FY 2019-20 [AY 2020-21] from the link below.

Download Income Tax Calculator (FY 2019-20)

Also Read: 19 Important Changes in Tax Rules from April 1, 2019

Limitations of the Calculator:

  • This Calculator is for people with only one home
  • It does not computes Capital Gains Tax

These features might be incorporated in next versions of the Tax calculator

You can also download Income Tax Calculator for FY 2018-19, FY 2017-18, FY 2016-17FY 2015-16,  FY 2014-15,  FY 2013-14 FY 2012-13 and FY 2011-12 by clicking on respective links.

29 thoughts on “Income Tax Calculator for FY 2019-20 [AY 2020-21] – Excel Download

  1. Dear Sir,
    Can You Customize this output as per form no 16 Part B.

  2. Murari Mohan Das says:

    how to filling Income Tax return

  3. Sandra Adam says:

    The Interim Budget 2019, announced by Union Minister for Finance, Corporate Affairs, Railways & Coal, Shri Piyush Goyal, laid out several tax sops for individuals. The schemes have been designed to benefit the middle class. The budget provides for Tax benefits
    of Rs.18,500 crore to an estimated 3 crore middle-class taxpayers comprising self-employed, small business, small traders, salary earners, pensioners, and senior citizens. Nil Income Tax for individuals with a taxable income of up to Rs 5 lakh. The finance minister proposed that individuals earning a taxable income of up to Rs 5 lakh will not have to pay tax. Thus, a person with an income of Rs 6.50 lakh, who claims full benefit under Section 80C of Rs 1.50 lakh, will not have to pay tax on his income.

  4. deepanshu sharma says:

    thank you for simplifying the process of income tax calculation

  5. Hi,

    How can we download the excel? more then four buttons show.

    The GST going success or failures in India.

  6. Hi Amit
    Thanks for sharing the excel tool, but one clarification is in 80 C home loan repayment principal amount it is mentioned as 50 % of actual amount. Please confirm on this.

    • I am sorry this was written by mistake. 100% of home loan principal (up to Rs 1.5 lakh) is eligible for tax exemption u/s 80C.

  7. If CTC is 6 25 lakh and gross salary is 524806 in that case TDS will be deducted or not?

  8. Shaikh Maksud says:

    Standard Deduction Words “fifty thousand” shall be subs. for “forty thousand” by the Finance Act, 2019 (w.e.f. 1-4-2020).

  9. Can you please Add how to fill form 15G File sir….

  10. Ashish Agarwal says:

    Hello Amit,

    Thanks a lot for sharing the excel utility on computing income tax liability across many assessment year. I noticed a gap in the utility which i want to bring to your notice.

    The surcharge calculation @10% for >50L and @15% for >1Cr is not proper. This surcharge is on net taxable income and not gross income. Also if the surcharge tax @10% or 15% is more than the increase in taxable income from the applicable base, the individual will get a marginal relief of the difference amount between the excess tax payable on higher income. Request you to please update the logic in the excel and share, thanks


  11. Please give the link for fy 2019-2020 and where ay 2020 2021

  12. How is Basic Tax Exemption calculated?
    If an employee is having 12lakhs per annum as CTC.

  13. Hi,

    Interest Received from Bank Savings account will Entertain any TDS? and what is the tax for Term deposits and recurring deposit interest accrued in your tax calculator it is not showing current budget values

  14. Pradeep Agrawal says:

    Can you please add the entry of 80 CCD (2) as well ?

  15. Sir plz provide free eBook for fy2019-20…Thank you.

  16. Wherr is the download link?

Leave a Reply

Your email address will not be published. Required fields are marked *