Thursday, December 8, 2022
HomeBusinessFinancial PlanningEarnings Tax Calculator India In Excel★ (FY 2021-22) (AY 2022-23) ★

Earnings Tax Calculator India In Excel★ (FY 2021-22) (AY 2022-23) ★ – Private Finance Funding Concepts

Yearly there are adjustments within the Earnings Tax guidelines of India within the Union Price range. Maintaining these adjustments in thoughts we provide you with our Earnings Tax Calculator India yearly. The most recent price range was offered in February 2021 and made the next adjustments.

Earnings Tax Adjustments in Union Price range 2021

There was No main adjustments in earnings tax in Price range 2021. The one change was the curiosity earned on contribution of greater than Rs 2.5 Lakh in a 12 months via EPF or VPF can be added to the earnings and taxed at marginal tax fee.

Additionally the most important change in Price range 2020 relating to earnings tax was introduction of new tax slabs in case you do not need to take profit of varied tax deductions like customary deduction, Chapter VI A deductions, HRA profit, LTA, residence mortgage curiosity for self-occupied properties and so forth. continues.

From final 12 months you may have the choice to decide on on what you need to comply with:

  1. New Tax Slabs however forgoing all tax deductions
  2. Proceed with previous tax slabs with all tax deductions

The earnings tax calculator India calculates the tax outgo utilizing each the above tax slabs and you may select what fits you.

Earnings Tax Slabs for FY 2021-22 (AY 2022-23)

Sukanya Samriddhi Account + PPF + SCSS Calculator

Sukanya Samriddhi Account, PPF, Senior Residents’ Financial savings Scheme are a part of small saving scheme sponsored by Authorities of India. These schemes are fairly well-liked and rightly so due to the protection, greater rate of interest supplied amongst different issues. We’ve constructed calculator for every of them the place you may verify the maturity quantity, mortgage eligibility, partial withdrawal and extra. Click on on the hyperlinks to get the related calculator – PPF Calculator, Sukanya Samriddhi Yojana Calculator, Senior Residents’ Financial savings Scheme Calculator, NSC Calculator.

Obtain Earnings Tax Calculator in Excel

You may obtain the earnings tax calculator 2021 (for FY 2021-22) in excel by clicking the button under.

How you can use the Earnings Tax Calculator India for FY 2021-22 (AY 2022-23)?

The image under exhibits how the earnings tax calculator India for FY 2021-22 (AY 2022-23) seems to be like. You may edit all cells in Orange color.

Income Tax Calculator India
Earnings Tax Calculator India

Part 1: Primary Particulars

The highest cells ask in your title and PAN Quantity. It’s elective area and is supposed in case you need to use it for a number of folks.

Date of Start is obligatory area because the tax slab is totally different for folks aged under 60, between 60 to 80 years and greater than 80 years.

Part 2: Wage Earnings

The subsequent fields ask details about gross wage earnings.

  • In case you might be employed, get HRA and lease out do fill within the particulars
  • Normal Deduction is Rs 50,000 from Price range 2019 onwards and is relevant to salaried and pensioners solely.
  • Do point out Any Different Exempted Receipts/ allowances like LTA, and so forth
  • In case you may have paid Skilled Tax as occurs in Maharashtra and another states do point out that. That is tax exempt.

Tax Free Wage Elements

There are parts in wage that are totally or partially tax exempt. For instance HRA is tax exempt if you happen to fulfill sure situations. You may have the entire listing within the put up: Will need to have Tax Free parts in Wage.

Part 3: Earnings from different sources

Enter all the opposite earnings like Curiosity earnings from fastened or recurring deposits. You may also embrace earnings from items acquired if its greater than Rs 50,000 and from non-relatives.

Part 4: Loss from House Mortgage Curiosity

In case you may have residence mortgage, replenish the columns to replicate the identical. You get tax profit on curiosity below part 24. Price range 2018 onwards there may be extra profit for first time consumers of inexpensive properties. You may also declare tax profit on curiosity paid on residence enchancment mortgage.

HRA & House Mortgage Profit at similar Time – Attainable?

Many employer (& employers) are confused if they will make the most of each HRA and House Mortgage for saving tax. This appears intuitive as how will you pay for residence mortgage and likewise reside on lease. Nevertheless simply in your info its fully authorized to make the most of each HRA & House Mortgage as there are a number of conditions the place you’ll want to reside on lease however nonetheless pay residence mortgage. You may learn extra about this our put up – Can I declare Tax Profit on each HRA & House Mortgage?

Part 5: Tax Deductions – Chapter VI A

Fill within the tax deductions you need to declare. It covers Part 80C for investments like EPF, VPF, PPF, SCSS, and so forth.

Moreover, you may declare tax deduction as much as Rs 50,000 by investing in NPS u/s 80CCD(1B). that is along with Part 80C.

Part 6: Extra Tax Deductions

There are a number of instances the place you may declare tax deductions like shopping for medical insurance coverage, and so forth. Point out the identical accordingly.

  • Medical Insurance coverage premiums (for Self or mother and father)
  • Curiosity Paid on Schooling Mortgage
  • Medical Remedy of handicapped Dependent
  • Expenditure on Chosen Medical Remedy for self/ dependent
  • Donation to authorised funds
  • For Hire in case of NO HRA Element (Price range 2016)
  • For Bodily Disable Assesse
  • In case your employer contributes to NPS account in your behalf, you may declare as much as 10% of your fundamental wage as tax deductible.
  • There’s additionally tax deduction for curiosity paid on buy of electrical autos.

Part 7: Earnings Tax Calculation (Previous Tax Slabs)

This part is auto-computed primarily based in your inputs and shows your remaining tax outgo. There

Part 9: Calculating Earnings Tax with New Tax Slab below new Regime

This part computes the Earnings Tax with Decrease Tax Slab below new Regime introduced in Price range 2020. This may assist you to find out which tax regime fits you.

How you can Calculate Earnings Tax in India?

In case you need to calculate your earnings tax with out utilizing the Earnings Tax India calculator, it’s not very troublesome. You want to comply with following steps utilizing the under instance.

Amit is salaried worker with following wage construction.

  • Primary Wage: Rs 6,00,000
  • HRA: Rs 3,00,000
  • Particular Allowance: Rs 60,000
  • LTA: Rs 40,000
  • Whole CTC: Rs 10,00,000

Step 1: Calculate Gross whole earnings from wage:

The desk under exhibits the calculation for gross taxable earnings from wage.

Element Quantity (Rs.) Exemption/ Deduction Previous regime New regime
Primary Wage 600,000 600,000 600,000
HRA 300,000 240,000 60,000 300,000
Particular Allowance 60,000 60,000 60,000
LTA 40,000 40,000 (payments submitted) 0 40,000
Normal Deduction 50,000 – 50,000
Gross Whole Earnings from Wage 670,000 1,000,000
Gross Earnings from Wage – New Vs Previous tax Regime

Step 2: Tax Deductions

Amit had made the next investments to avoid wasting tax. These shall be deducted from the gross earnings to reach at web taxable earnings.

  • EPF deduction from wage – Rs 60,000
  • PPF Funding – Rs 1,50,000
  • Medical Insurance coverage Premium – Rs 25,000
  • Whole Tax Deduction = Rs 1,50,000 + 25,000 = Rs 1,75,000 (PPF & EPF each come below part 80C and have a tax deduction higher restrict of Rs 1.5 lakh)

Step 3: Different Earnings

Amit additionally had Rs 20,000 from curiosity from fastened deposits with banks.

Step 4: Internet Taxable Earnings

The desk under exhibits the Internet Taxable Earnings for Amit

Nature Previous Tax Regime New Tax Regime
Earnings from Wage 670,000 1,000,000
Earnings from Different Sources 20,000 20,000
Tax Deduction -175,000 0
Whole Taxable Earnings 515,000 1,020,000

Step 5: Calculating utilizing Earnings Tax Method

Previous Regime:

Tax Slab Calculation Tax
as much as Rs 250,000 Tax Exempt 0
Rs 250,000 to 500,000 5% || (5% * (500,000 – 250,000) 12,500
Rs 500,000 to 1,000,000 20% || (20% *(515,000 – 500,000) 3,000
Earnings Tax 15,500
Cess 4% || (4% of 15,500) 620
Whole Tax Payable 16,120
Tax computation utilizing previous tax slabs

New Regime:

Tax Slab Calculation Tax
as much as Rs 250,000 Tax Exempt 0
Rs 250,000 to 500,000 5% || (5% * (500,000 – 250,000) 12,500
Rs 500,000 to 750,000 10% || (10% * (750,000 – 500,000) 25,000
Rs 750,000 to 1,000,000 15% || (15% * (1,000,000 – 750,000) 37,500
Rs 1,000,000 to 1,250,000 20% || (20% * (1,020,000 – 1,000,000) 4,000
Earnings Tax 79,000
Cess 4% || (4% of 79,000) 3,160
Whole Tax payable 82,160
Tax computation utilizing new tax slabs

As you may see the tax legal responsibility adjustments massively relying on what tax regime you select. So it is best to plan fastidiously. You may also verify the official Earnings Tax web site for calculating your earnings tax.

How you can Pay 0 Earnings Tax on Wage of Rs 20+ Lakh (FY 2021-22)?

As you may see with the above earnings tax calculation, wage parts and wage construction performs an important function in how a lot earnings tax you pay. We’ve provide you with some optimised wage construction utilizing which you pay NO earnings tax even with CTC of greater than Rs 20 Lakhs.

Earnings Tax Calculator FY 2020-21 Excel

Price range 2020 had launched the brand new Vs previous tax slabs. Under are the tax slabs

Income Tax Slabs for FY 2020-21 (AY 2021-22)
Earnings Tax Slabs for FY 2020-21 (AY 2021-22)

Earnings Tax Calculator FY 2019-20 Excel

Following adjustments had been made in Price range 2019 relevant for FY 2019-20:

  1. Rebate below Part 87A modified from Rs 2,500 to Rs 12,500 or 100% of earnings tax (whichever is decrease) for people with earnings under Rs 5 Lakhs (from Rs 3.5 Lakhs)
  2. Normal Deduction raised for Salaried & Pensioners from Rs 40,000 to Rs 50,000
  3. Elevated Tax for super-rich: Surcharge elevated to 25% for earnings between 2 to five crore & to 37% for earnings past Rs 5 crores
  4. Extra Tax Deduction of Rs 1.5 lakhs u/s 80EEA on residence loans on buy of inexpensive residence
  5. Extra Tax Deduction of Rs 1.5 lakhs u/s 80EEB on Auto loans on buy of Electrical autos
  6. No Tax on Notional Rental Earnings from Second Home
  7. Capital beneficial properties exemption on reinvestment in two home properties: Tax payers can now purchase two homes on sale of 1 home if the capital beneficial properties are lower than Rs 2 crore. This profit could be availed solely as soon as in lifetime
  8. TDS threshold elevated from Rs 10,000 to Rs 40,000 on Financial institution Curiosity Earnings
Income Tax Slabs for FY 2019-20 (AY 2020-21)
Earnings Tax Slabs for FY 2019-20 (AY 2020-21)

You may obtain the Earnings Tax Calculator in Excel for FY 2019-20 from the hyperlink under.

Earnings Tax Calculator FY 2018-19 Excel

Price range 2018 has made some adjustments to Earnings tax for particular person. There was no adjustments within the earnings tax slab, nonetheless there have been some adjustments associated to salaried/pensioner tax payers and senior residents.

  1. No Change in Earnings Tax Slabs
  2. 1% extra well being cess taking whole cess on earnings tax to 4% (2% training cess & 1% greater training cess continues). This can marginally enhance earnings tax for each tax payer.
  3. Normal Deduction of Rs 40,000 to Salaried and Pensioners. Nevertheless transport allowance (Rs 19,200 each year) and medical reimbursement of Rs 15,000 has been abolished. So the web profit for salaried can be Rs 5,800 solely bringing marginal reduction. Nevertheless Pensioners would acquire as they didn’t have transport & medical allowance.
  4. 10% Lengthy Time period Capital Positive factors Tax on Fairness and Fairness primarily based Mutual Funds launched.
  5. Medical Insurance coverage premium exemption for senior citizen elevated from Rs 30,000 to Rs 50,000 u/s 80D
  6. Medical bills will see elevated tax advantages for senior residents. 100,000 on essential sickness u/s 80DDB
  7. Rs 50,000 exemption for curiosity earnings from Financial institution or Put up Workplace Mounted/Recurring Deposits for Senior Residents
Budget 2018 - Income Tax Slabs for FY 2018-19
Price range 2018 – Earnings Tax Slabs for FY 2018-19

Earnings Tax Calculator FY 2017-18 Excel

In Price range 2017, the finance minister has made little adjustments to this. We spotlight the adjustments and provide you with the brand new tax calculator for FY 2017-18 [AY 2018-19].

  1. Tax decreased from 10% to five% for Earnings from Rs 2,50,000 – Rs 5,00,000 resulting in tax saving of as much as Rs 12,500.
  2. 10% surcharge on earnings tax if the whole earnings exceeds Rs 50 Lakhs however lower than Rs 1 crore
  3. For folks with web taxable earnings under Rs 3.5 lakh, the tax rebate has been decreased to Rs 2,500 u/s 87A
  4. NO RGESS Tax exemption from FY 2017-18
  5. Curiosity deduction on rented property capped at Rs 2 Lakh
Income Tax Slab for FY 2017–18 [AY 2018-19]
Earnings Tax Slab for FY 2017–18 [AY 2018-19]

Earnings Tax Calculator FY 2016-17 Excel

In Price range 2016, the finance minister has made little adjustments.

  1. There was no change within the earnings tax slabs.
  2. For folks with web taxable earnings under Rs 5 lakh, the tax rebate has been elevated from Rs 2,000 to Rs 5,000 u/s 87A. This may profit individuals who have web taxable earnings between Rs 2.7 Lakhs to Rs 5 Lakhs.
  3. Extra exemption for first time residence purchaser as much as Rs. 50,000 on curiosity paid on housing loans. This may be relevant the place the property price is under Rs 50 Lakhs and the house mortgage is under Rs 35 lakhs. The mortgage ought to be sanctioned on or after April 1, 2016.
  4. Tax Exemption u/s 80GG (for lease bills who do NOT have HRA element in wage) has been elevated from Rs 24,000 to Rs 60,000 each year. This can be a good transfer to align the exemption quantity with right now’s lease and maintain the part related.
  5. For folks with web taxable earnings above Rs 1 crore, the surcharge has been elevated from 12% to fifteen%
  6. Dividend Earnings in extra of Rs. 10 lakh each year to be taxed at 10%
  7. 40% of lump sum withdrawal on NPS at maturity can be exempted from Tax. This rule now additionally applies to EPF. So now in case of EPF earnings tax can be relevant on 60% of the corpus on maturity.
  8. Presumptive taxation scheme launched for professionals with receipts as much as Rs. 50 lakhs. The presumptive earnings can be 50% of the revenues.
  9. Exemption to employer’s contribution to acknowledged provident funds restricted to 1.5 lakh. Earlier, the cap was as much as 12% of wage
Income Tax Slabs for FY 2016–17 [AY 2017-18]
Earnings Tax Slabs for FY 2016–17 [AY 2017-18]

Earnings Tax Calculator FY 2015-16 Excel

The tax slabs have stay unchanged however there have been some adjustments by way of Transport Allowance, Medical Insurance coverage advantages and exemption for Bodily challenged tax payers.

  1. Transport Allowance elevated to Rs 1,600 from Rs 800
  2. Enhance in Medical Insurance coverage Premium exemption restrict from Rs 15,000 to Rs 25,000 u/s 80D (as much as 30K for Senior Residents)
  3. Sukanya Samriddhi Account a brand new funding possibility u/s 80C
  4. Very Senior Residents (above 80 Years of age) to be allowed deduction of Rs 30,000 for medical expenditure in case they don’t have medical health insurance
  5. Extra exemption of Rs 50,000 below sec 80CCD for investing in NPS (New Pension Scheme)
  6. Enhance within the restrict of deduction accessible for therapy of power ailments u/s 80DDB from Rs 60,000 to Rs 80,000
  7. Rs 25,000 enhance in deduction accessible to individuals with incapacity and extreme incapacity u/s 80DD and 80U
  8. 2% surcharge on Tremendous wealthy (i.e. people with earnings > 1 crore)
Income Tax Slab for FY 2015-16 (AY 2016-17)
Earnings Tax Slab for FY 2015-16 (AY 2016-17)

Earnings Tax Calculator FY 2014-15 Excel

We’ve integrated the three adjustments that occurred in Price range 2014 (offered on July 10, 2014)

  1. Earnings as much as Rs 2.5 lakhs for Normal Public and as much as Rs. 3 lakhs for Senior residents are actually exempted from paying Earnings tax. Earlier this restrict was Rs 2 Lakhs for Normal Public and rs 2.5 Lakhs for Senior Residents.
  2. The exemption restrict for investments below part 80C has been raised from Rs 1 Lakh to Rs 1.5 Lakhs. 
  3. The exemption on paying curiosity on House Mortgage has been raised from Rs 1.5 Lakhs to Rs 2 Lakh.
Income Tax Slab for FY 2014-15 (AY 2015-16)
Earnings Tax Slab for FY 2014-15 (AY 2015-16)

Earnings Tax Calculator FY 2013-14 Excel

The finance minister, P Chidambaram in his Price range 2013-14 stored the earnings tax charges unchanged. The desk under exhibits the abstract of tax slabs for FY 2013-14.

There are two minor adjustments:

  1. Tremendous wealthy must pay extra taxes. A surcharge of 10% on Rs 1 crore plus earnings earners have been imposed. That is for one 12 months solely and would affect about 42,800 folks solely
  2. The center class with earnings of as much as Rs 5 lakhs would obtain tax credit score of Rs 2,000 for FY 2013-14. This basically means folks with earnings as much as Rs 5 lakhs have decreased tax burden of Rs. 2,060 for FY 2013-14.
Income Tax Slab for FY 2013-14
Earnings Tax Slab for FY 2013-14

Earnings Tax Calculator FY 2012-13 Excel

Under is the Earnings Tax Slab for FY 2012-13. A major distinction is there isn’t any extra distinction between males and girls so far as taxes are involved.

Income Tax Slab for FY 2012-13
Earnings Tax Slab for FY 2012-13

Earnings Tax Calculator FY 2011-12 Excel

Under is the Earnings Tax Slab for FY 2011-12.

Income Tax Slab for FY 2011-12
Earnings Tax Slab for FY 2011-12

Earnings Tax Calculator India FAQs

✅ Ought to I am going with New or Previous Tax Slab?

It’s best to do the calculation utilizing our earnings tax calculator and verify your self. Normally if you happen to do tax saving investments and get wage parts tax deduction, it is best to comply with the previous tax slab.

✅ Is Tax Deduction totally different than Tax Exemption?

You might discover each Tax Deduction and Tax exemption phrases used interchangeably. However technically each phrases have totally different which means.
Tax Deduction means you may deduct these out of your earnings. This might be investments like PPF, and so forth that you simply do below part 80C. That is tax deducted as much as Rs 1.5 lakhs.
Tax Exemption means the earnings just isn’t taxable like curiosity earned on PPF.

✅ Do NRIs have to pay Earnings Tax in India?

NRIs (Non-resident Indians) and foreigners must pay earnings tax in India on earnings accrued in India.

✅ What’s surcharge on Earnings Tax?

For sure high-income tax payers, the federal government of India has launched surcharge. As of FY 2021-22 the surcharge is as follows:
Lower than Rs 50 Lakh – No Surcharge
Rs 50 lakh to 1 crore – 10%
Rs 1 crore to 2 crores – 15%
Rs 2 crores to five crores – 25%
Greater than Rs 5 crores – 37%

✅ What’s Cess on Earnings Tax?

All tax payers must pay 4% of Earnings Tax as well being and Schooling cess. This cess is claimed for use for the above function.

Supply hyperlink



Please enter your comment!
Please enter your name here

- Advertisment -
Google search engine

Most Popular

Recent Comments