Income Tax Calculator Excel Template

This calculator is designed to work with both old and new tax slab rates released in the budget 2020.

Income tax calculator excel template. Simple tax estimator is an excel template to help you compute estimate your federal income tax. What i found was either. Firstly insert personal information like your name your pan number and date of birth. You can calculate your tax liabilities as per old and new tax slab.

This excel based income tax calculator can be used for computing income tax on income from salary pension gifts fixed deposit and bank interest house rent and capital gains short and long term gains. Highlights of changes in fy 2019 20 in income tax return form. Excel based income tax calculator for fy 2019 20 ay 2020 21. How to use income tax calculator fy 2018 19 excel template.

A user needs to input the in respective cells and it will automatically estimate your tax liability. It will help you to make an informed decision to opt for a suitable tax structure. This date of birth will define your age using the datedif function. This template consists of computations of your adjustments tax credit itemized deductions etc.

Download income tax calculator fy 2020 21 ay 2021 22 in excel format.