Income Tax Calculator FY 2023-24 Excel [DOWNLOAD]

how to calculate income tax 2023-24 excel income tax calculation examples video

Please fill below form to download Income Tax Calculator FY 2023-24 Excel (AY 2024-25) for FREE. Once you provide details, you will be provided with link to download excel for Free via Email. Also, read the instructions to use this Income Tax Excel Calculator. This excel calculator helps you to calculate income tax if you are salaried employee or business man.

Enter Correct Email ID to receive Excel
If you opt in above, we use this information to send related content

Check out More online Calculators here including Income Tax, PPF, SIP, Home Loan Calculator and many more..

Note: This calculator is applicable for FY 2023-24 and AY 2024-25. There were some changes made in Budget 2023 in new tax regime mentioned below. For senior citizens, download senior citizen income tax calculator from here.

Income Tax Calculator FY 2023-24 Excel Download
Income Tax Calculator FY 2023-24 Excel Download

Instructions to use Income Tax Calculator FY 2023-24 Excel:

  • Download the Income Tax Calculator FY 2023-24 Excel on your device
  • Provide Income as Gross Income for FY 2023-24
  • Provide Investments including Standard Deduction, Section 80C investments, Section 80CCD(1B) investments and other tax saving options you are eligible for. Total amount of investments need to be entered. Standard Deduction of Rs. 50,000 is applicable for Employees.
  • Enter TDS amount that is already deducted from your salary in financial year
  • After providing all these parameters, income tax will be calculated based on Old and New Tax Regime

You can find more income tax calculation examples here

Now since you got the idea about how this excel calculator works, let’s see How to calculate Income Tax FY 2023-24 with the help of a video.

Income Tax Calculation FY 2023-24 Video

YouTube player

Watch more Excel Videos Here

Also in case you want to use Online income tax calculator use below link instead of using excel calculator:

instant calculator click here
instant calculator click here

New Tax Regime Changes in Budget 2023

Below are few changes made in Budget 2023 applicable to new tax regime:

  • Tax Rebate limit has been increased to Rs. 7 Lakh income with new tax regime. Which means if your income is up to 7 lakh and you choose new tax regime, you don’t have to pay any tax. This limit is still of Rs. 5 lakh with old tax regime for FY 2023-24
  • Tax Slab Rates have been updated in new tax regime
  • Standard Deduction will be now available in new tax regime as well, for FY 2023-24

So these were some of the important changes made for FY 2023-24.

Note that you will not get any other deductions except standard deduction in new tax regime. All other deductions are still available in old tax regime and new regime will be the default regime from FY 2023-24.

How this Income Tax Calculator in Excel helps you?

  • This income tax calculator helps you to understand your income tax based on Old and New Tax Regime.
  • Based on the calculations, you can choose which Tax regime you should choose. You should select tax regime based on which you’ll be paying less income tax.
  • It is important to note that investment deductions are available only in Old Tax Regime.
  • New Tax Regime does not allow you to claim any investment deductions to save income tax. This is because new tax regime are reduced tax slab rates.
  • Only Standard Deduction is available in New Tax Regime for FY 2023-24
  • In this way, the calculator can help you to compare your tax outgo and by iteratively entering the investment amount, you can decide how much you can invest more to pay less income tax if selecting Old Tax Regime.

Old Tax Regime vs New Tax Regime Slab Rates

Below is the table showing Old and New Tax Slab Rates for FY 2023-24:

IncomeOld Tax RegimeIncomeNew Tax Regime
Rs. 0 to Rs. 2.5 Lacs0%Rs. 0 to Rs. 3 Lacs0%
Rs. 2.5 Lacs to Rs. 5 Lacs5%Rs. 3 to Rs. 6 Lacs5%
Rs. 5 Lacs to Rs. 10 Lacs20%Rs. 6 to Rs. 9 Lacs10%
more than Rs. 10 Lacs30%Rs. 9 to Rs. 12 Lacs15%
Rs. 12 to Rs. 15 Lacs20%
more than Rs. 15 Lacs30%
Tax Slab Rates to calculate Income Tax FY 2023-24

As seen above, New Tax regime has reduced tax slab rates which means you will be paying less income tax, if you are not opting for any investment deductions.

In case you want to claim various deductions to save income tax, you might have to check how much income tax can be saved using Old Tax Regime.

ALSO READ: Income Tax Brackets in India

Which Tax Regime you should choose?

To answer this question, it depends on person to person. Every individual is having different incomes in a Financial Year.

And based on the investment options and deductions, you income tax can be calculated.

Below is the table of income tax with new tax regime (Rs. 50,000 deduction) and old tax regime (Rs. 2 lakh deduction) for income between Rs. 4 Lakh to Rs. 20 lakh in FY 2023-24:

Income Tax Calculation FY 2023-24
Income Tax Calculation FY 2023-24

So based on your income and investments, you can see which tax regime is better for you. If you can make deductions above Rs. 2 lakh by availing more deduction options, you can go for old tax regime.

If not than new tax regime would be better as it helps you pay less income tax with less or no deductions.

ALSO READ: How to Change Tax regime from new to old or vice versa

What is the new income tax calculation formula in Excel?

In Budget 2020, new tax regime was introduced with no deductions to be claimed. But Old tax regime is also applicable since than and you have the option to choose between these 2 options of old and new tax regime to pay income tax.

Using tax calculation formula in Excel (provided above), you can calculate tax liability based on below steps:

  1. 5% tax calculation on income between 2.5 to 5 lakh in old regimes. Formula will be 5% * 2.5 lakh / 100
  2. 10% tax calculation on income between 6 lakh to 9 lakh in new regime. Formula will be 10% * 3 lakh / 100
  3. Similarly for various slab rates and incomes, the tax calculation will be done based on such formula
  4. Finally cess of 4% will be applicable on the intermediate tax calculated

Are you eligible for Tax Rebate u/s 87A?

You will be eligible for Tax Rebate u/s 87A when your taxable income is below Rs. 5 lacs in FY 2023-24 with Old tax regime and below Rs. 7 Lacs with New Tax Regime.

Tax Rebate u/s 87A will be allowed in both Old and New Tax Regime.

According to new rule in Budget 2023, no income tax need to be paid on income up to Rs. 7 lakh in new tax regime. In old tax regime, the limit remains same of Rs. 5 lakh.

Example

Let’s say your Net Taxable Income equals Rs. 5 Lacs in FY 2023-24

Based on Old and New Tax Slab Rates, you are liable to pay Rs. 12,500 as Income Tax based on your Net Taxable Income.

But we also have Tax Rebate u/s 87A which provides us a maximum rebate of Rs. 12,500, thus making our Income Tax = Rs. 0.

Also if your income is Rs. 7 lakh and you choose new tax regime, your tax will be Rs. 25,000 according to new slab rates, but you also get tax rebate since income is within 7 lakh and you choose new tax regime, so no tax in this case for FY 2023-24.

How to pay ZERO Income Tax?

Using above trick of getting your Taxable income to below Rs. 5 lacs (old regime) and Rs. 7 lacs (new regime) in FY, you need not have to pay any income tax, and by making investments, you save for your future as well. So it’s a win-win situation.

This is possible only when your total income is up to 10-12 lacs in a financial year and you are able to use all available investment options present. If your income goes above this figure in FY, it becomes difficult to save maximum income tax. Again, you can check by yourself using the Income Tax Calculator in Excel I have provided above.

Note that you can reduce taxable income with old regime only and get it below 5 lakh, by using deductions. In new regime there are no deductions available except standard deduction so you cannot do much to get it below 7 lakh limit to get tax rebate.

Watch below video to know various tax saving options:

YouTube player

Watch more Excel Videos Here

That’s it in this article about income tax calculator FY 2023-24 in excel. Comment your queries in case you have any. Make sure that you Subscribe to YouTube Channel for more Personal Finance Videos and Download Income Tax Calculator App “FinCalC” on your mobile.

Conclusion

You can easily download income tax calculator FY 2023-24 in excel using above form. Make sure that you watch the video at the start of this article to know how to use this tax calculator.

Some more Reading:

Frequently Asked Questions

Standard Deduction available in New Tax Regime?

Yes standard deduction of Rs. 50,000 is made available in new tax regime from FY 2023-24. No other deductions are available in new tax regime

How much tax on 7 lakh with new tax regime?

Since we will get tax rebate on income up to Rs. 7 lakh with new tax regime, income tax will be Rs. 0 for FY 2023-24 on this income and new tax regime. Even with income = Rs. 7.5 lakh, you get standard deduction of Rs. 50,000 making taxable income = Rs. 7 lakh with new regime, making income tax as Rs. 0.

Use Income tax calculator for more details.

You can Donate Too!

Found this Helpful? DONATE any amount to see more useful Content. Scan below QR code using any UPI App!

fincalc donate

UPI ID: abhilashgupta8149-1@okhdfcbank

Verify that you are “Paying Abhilash Gupta” before making the transaction so that it reaches me. It makes my Day 🙂

Thank you for Donating. Stay Tuned!

Income Tax Calculator App – FinCalC

For Income Tax Calculation on your mobile device, you can Download my Android App “FinCalC” which I have developed for you to make your income tax calculation easy.

What you can do with this mobile App?

  • Calculate Income Tax for new FY 2023-24 and previous FY 2022-23
  • Enter estimated Investments to check income tax with Old and New Tax Regime
  • Save income tax details and track regularly
  • Know how much to invest more to save income tax
  • More calculators including PPF, SIP returns, Savings account interest and lot more
Download Income Tax Calculator APP from play store
Download Income Tax Calculator APP from play store

14 thoughts on “Income Tax Calculator FY 2023-24 Excel [DOWNLOAD]”

  1. Jatinkumar V Patel

    Can you send excel sheet for Income tax calculation for Financial year 2022-23 for a Pensioner (Age 77 Yrs.)?

Leave a Comment

Your email address will not be published. Required fields are marked *