Income Tax Calculator Excel Sheet India

If you want to continue this discussion or have a follow up question please post it on the network.
Income tax calculator excel sheet india. 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 standard deduction raised for salaried pensioners from rs 40 000 to rs 50 000. The income tax department never asks for your pin numbers passwords or similar access information for credit cards banks or other financial accounts through e mail. To help them here is simple income tax calculator for the financial year 2019 20. Standard deduction enhanced for salaried persons from 40 000 to 50 000 in fy 2019 20.
This will help the individual to plan their investments in advance and submit necessary documents to their employer in time. As you are aware that income tax calculation is one of the most complex tasks for the common man especially for salaried. The income tax department never asks for your pin numbers passwords or similar access information for credit cards banks or other financial accounts through e mail. Income tax calculator for the financial year 2019 20 for salaried individuals in india in excel.
Tax planning in the beginning of the financial year is always better instead of doing that at the end of the year in hurry. The income tax department appeals to taxpayers not to respond to such e mails and not to share information relating to their credit card bank and other financial accounts. The income tax department appeals to taxpayers not to respond to such e mails and not to share information relating to their credit card bank and other financial accounts. It is simple excel based calculator specially made for the salaried people.
Download income tax calculator fy 2020 21 ay 2021 22 in excel format. Income tax calculator pankaj batra in finance government income tax india investment february 4 2019. This calculator is designed to work with both old and new tax slab rates released in the budget 2020. Select the cell you will place the calculated result at enter the formula vlookup c1 a5 d12 4 true c1 vlookup c1 a5 d12 1 true vlookup c1 a5 d12 3 true into it and press the enter key.
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.