What is the formula to calculate income tax in Excel?

What is the formula to calculate income tax in Excel?

Write the formula =B2-B3-B4 inside the formula bar and press the Enter key. Step 4: Taxable income is now extracted from gross income, which is 2,19,000. “Taxable income is on which we apply the tax.” “Tax is 5% on income below 2,50,000.” As the taxable value is between 1.5 to 2.5 lakhs so that 5% will apply to income.

How do I calculate my tax on FY 2020 21?

The total tax liability in the new tax regime comes out to be Rs 1,99,500 ( 0+12,500+25,000+37,500+ 50,000+62,500+12,000)….

S. No.	Income slabs	Income tax rate (%)
1	Up to Rs 2.5 lakh	Nil
2	Between Rs 2,50,001 and Rs 5 lakh	5%
3	Between Rs 5,00,001 and Rs 7.5 lakh	10%
4	Between Rs 7,50,001 and Rs 10 lakh	15%

What is the formula for calculating income tax?

In case your total taxable income after deductions doesn’t exceed Rs 5 lakh, you can claim rebate under Sec 87A of Rs 12,500….Let’s now understand this with an example –

Income Tax Calculation	AY 2020-21
HRA and LTA	– ₹ 2.5 lakh
Standard deduction	– ₹ 50,000
Net salary	₹ 12 lakh
Income from other sources	₹ 10,000

How is taxable income calculated 2020?

In a nutshell, to estimate taxable income, we take gross income and subtract tax deductions. What’s left is taxable income. Then we apply the appropriate tax bracket (based on income and filing status) to calculate tax liability.

How do you calculate tax for the financial year 2021 22?

For example, if you have a taxable income of Rs 10 Lakhs in the FY 2020-21, your maximum tax-saving investments could be about Rs….Income Tax Slabs FY 2021-22 (AY 2022-23)

Annual Income	Tax Rate(New Regime)	Tax Rates(Old Regime)
INR 2,50,001 to INR 5,00,000	5%	5%
INR 5,00,001 to INR 7,50,000	10%	20%

What formula is in Excel?

Examples

Data
5
Formula	Description	Result
=A2+A3	Adds the values in cells A1 and A2	=A2+A3
=A2-A3	Subtracts the value in cell A2 from the value in A1	=A2-A3

How is new tax slab calculated?

Let’s understand income tax calculation under the current tax slabs and new tax slabs (optional) by way of an example….How to calculate income tax? (See example)

Up to Rs 2,50,000	Exempt from tax	0
Total Income Tax	Rs 12,500 + Rs 25,500+ Rs 37,500 + Rs 50,000 + Rs 62,500 + Rs 1,77,600 + Rs 14,604	Rs 3,79,704