Income Tax Excel Template India

Tax planning in the beginning of the financial year is always better instead of doing that at the end of the year in hurry.
Income tax excel template india. To help taxpayers here is a simple excel based income tax calculator for the financial year 2020 21 ay 2021 22. You can calculate your tax liabilities as per old and new tax slab. Unlike the existing tax regime consisting of three taxable slabs with minimum tax rate of 5 and highest being 30 the new tax regime consists of six taxable brackets with minimum tax rate of 5 with 5 incremental rise for each higher tax brackets. It will help you to make an informed decision to opt for a suitable tax structure.
Standard deduction enhanced for salaried persons from 40 000 to 50 000 in fy 2019 20. Income tax rates for financial year 2018 19 2019 20 assessment year. 2019 20 2020 21 upto rs. Income tax calculation is one of the complex tasks for the taxpayer.
Download income tax calculator fy 2018 19 excel template income tax calculator fy 2018 19 ay 2019 20 is a simple tax estimator for indian taxpayers with calculations of gross incomes from multiple sources all allowed and possible deductions. Income tax calculator for the financial year 2019 20 for salaried individuals in india in excel. Income tax calculator for the financial year 2019 20 for salaried individuals in india in excel. The 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.
Income statement template excel many companies and organizations prepare an income statement getting awareness about financial ratio s including gross profit operating profit earnings before subtracting amount of any tax and other deductions. In this condition you can apply the vlookup function to calculate the income tax for a certain income in excel. 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. 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.