New Tax Regime vs Old Tax Regime FY 2024-25 Excel [DOWNLOAD]

Please click below button to download New Tax Regime vs Old Tax Regime FY 2024-25 Excel (AY 2025-26). Also, read the instructions to use this New Tax Regime vs Old Tax Regime Excel Calculator. This excel calculator helps you to calculate income tax if you are salaried employee or business man.

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

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

New Tax Regime vs Old Tax Regime Calculator FY 2024-25 Excel Download

Instructions to use New Tax Regime vs Old Tax Regime Calculator FY 2024-25 Excel:

Download the New Tax Regime vs Old Tax Regime Calculator FY 2024-25 Excel on your device
Provide Income as Gross Income for FY 2024-25
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 2024-25 with the help of a video.

Income Tax Calculation FY 2024-25 Video

Watch more Excel Videos Here

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

New Tax Regime Changes in Budget 2024

Below are few changes made in Budget 2024 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 2024-25
Tax Slab Rates have been updated in new tax regime
Standard Deduction will be now available in new tax regime of Rs. 75,000, for FY 2024-25

So these were some of the important changes made for FY 2024-25.

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 2024-25.

How this New Tax Regime vs Old Tax Regime 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 2024-25
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 2024-25:

Income	Old Tax Regime	Income	New Tax Regime
Rs. 0 to Rs. 2.5 Lacs	0%	Rs. 0 to Rs. 3 Lacs	0%
Rs. 2.5 Lacs to Rs. 5 Lacs	5%	Rs. 3 to Rs. 7 Lacs	5%
Rs. 5 Lacs to Rs. 10 Lacs	20%	Rs. 7 to Rs. 10 Lacs	10%
more than Rs. 10 Lacs	30%	Rs. 10 to Rs. 12 Lacs	15%
		Rs. 12 to Rs. 15 Lacs	20%
		more than Rs. 15 Lacs	30%

Income Tax Slab Rates to calculate Income Tax FY 2024-25

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. 75,000 Standard deduction) and old tax regime (Rs. 50,000 standard deduction) for income between Rs. 3 Lakh to Rs. 20 lakh in FY 2024-25:

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 to save more income tax as per your investments.

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:

5% tax calculation on income between 2.5 to 5 lakh in old regimes. Formula will be 5% * 2.5 lakh / 100
10% tax calculation on income between 6 lakh to 9 lakh in new regime. Formula will be 10% * 3 lakh / 100
Similarly for various slab rates and incomes, the tax calculation will be done based on such formula
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 2024-25 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 2024, 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 2024-25

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 2024-25.

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:

Watch more Excel Videos Here

That’s it in this article about income tax calculator FY 2024-25 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 2024-25 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. 75,000 is made available in new tax regime from FY 2024-25. 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 2024-25 on this income and new tax regime. Even with income = Rs. 7.75 lakh, you get standard deduction of Rs. 75,000 making taxable income = Rs. 7 lakh with new regime, making income tax as Rs. 0 for salaried employees.

New Tax Regime vs Old Tax Regime Which is Better?

It depends on your income and investments to select between new tax regime and old tax regime. If you can make required investments under various sections with old tax regime, than compare the income tax payable with the help of above calculator, else new tax regime helps you pay less income tax without any investments to be made.

Get EARLY Retirement!

Use Retirement Excel Calculator that will help you to Retire Early.
Click below button to download Retirement Calculator in Excel:

Watch how Retirement Calculator in Excel Works

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 2024-25 and previous FY 2023-24
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

Use Popular Calculators:

I’d love to hear from you if you have any queries about Personal Finance and Money Management.

JOIN Telegram Group and stay updated with latest Personal Finance News and Topics.

Download our Free Android App – FinCalC to Calculate Income Tax and Interest on various small Saving Schemes in India including PPF, NSC, SIP and lot more.

Follow the Blog and Subscribe to YouTube Channel to stay updated about Personal Finance and Money Management topics.