Start Filing Your ITR Now
Our plans start from ₹ 499/-

Calculate Your Income Tax Under the Old and New Tax Regimes with This Free Excel Calculator

Excel Calculator for Comparing Old vs New Tax Regime

Navigating the dynamic terrain of income tax regulations can be daunting, with the need to identify the most advantageous tax regime for your finances. The Old vs New Tax Regime Calculator Excel stands out as a vital resource, offering an income tax calculator excel that equips you to assess your taxes under both regimes. This article will illuminate the calculator's features, its benefits, and the best practices for leveraging it to your advantage.

Understanding the Old and New Tax Regimes

To effectively utilize the Old vs New Tax Regime Calculator Excel, it's essential to grasp the distinctions between the two systems. The old tax regime features stable slab rates and permits deductions for certain investments, which can be calculated using an old tax regime calculator. Conversely, the new tax regime, unveiled in Budget 2020, presents marginally lower slab rates and excludes deductions for investments, necessitating a new tax regime vs old tax regime calculator to compare the potential tax liabilities.

Introducing the Old vs New Tax Regime Calculator Excel

The Old vs New Tax Regime Calculator Excel, a complimentary and intuitive tool, streamlines the task of estimating your income tax for both regimes. It factors in your income, age, and deductions or investments for a given financial year, enabling a transparent comparison of the tax payable in each scenario. Armed with this data, courtesy of the income tax calculator excel sheet, you can judiciously choose the regime that aligns best with your financial goals.

How to Use the Old vs New Tax Regime Calculator Excel

Using the Old vs New Tax Regime Calculator Excel is straightforward and can be done in a few simple steps:

1. Select the financial year for which you want to calculate your income tax.

2. Choose your age category.

When using the tax calculator excel sheet, it's crucial to specify your employment status—be it a salaried employee, a business proprietor, or a pensioner—as this influences the standard deduction applicable to you. This step ensures the calculator provides a tailored estimate of your tax obligations.

In the 'Income' field of the calculator, input your total annual income, inclusive of any interest accrued and additional income streams. This comprehensive figure, representing your gross total income, will be the basis for the subsequent tax calculations.

5. Provide details of any deductions or investments made in the selected financial year.

Old and New Tax Slab Rates

Old and New Tax Slab Rates

To demystify the computations of the Old vs New Tax Regime Calculator Excel, let's examine the tax slabs and tax rates for the fiscal year 2023-24. Understanding these figures is key to making an informed decision about your tax planning strategies.

The income range for the financial year is delineated into tax brackets under both the old and new tax regimes. Notably, the new tax regime features uniform slab rates for all age groups, in contrast to the old regime's age-specific slabs. This distinction is vital when calculating your taxable income and considering the standard deduction's impact.

Examples of Income Tax Calculation

To demonstrate the capabilities of the Old vs New Tax Regime Calculator Excel, let's delve into a scenario where the income for the financial year 2023-24 stands at Rs. 8 lakhs. By utilizing the old vs new tax regime calculator excel download, one can easily compare the tax liabilities under both systems.

Tax Calculation with the Old Tax Regime

Under the old tax regime, utilizing an old tax regime calculator, the income tax calculation for an Rs. 8 lakhs income would unfold as detailed below:

·0% tax on income between Rs. 0 - Rs. 2.5 lakhs = Rs. 0

· A 5% tax on the income bracket from Rs. 2.5 lakhs to Rs. 5 lakhs equals Rs. 12,500, as per the tax calculation formula provided by an income tax calculator.

· Applying a 20% tax on the taxable income ranging between Rs. 5 lakhs and Rs. 8 lakhs results in Rs. 60,000, which can be precisely determined using an income tax calculator.

This computation yields an intermediate tax amount of Rs. 72,500. After factoring in the 4% education cess on this sum, which amounts to Rs. 2,900, the total tax payable under the old tax regime is calculated to be Rs. 75,400 with the assistance of an income tax calculator.

Tax Calculation with the New Tax Regime

Employing the same income example of Rs. 8 lakhs, the income tax calculation under the new tax regime can be efficiently executed using a new regime tax calculator excel, and the results would be as follows:

·0% tax on income between Rs. 0 - Rs. 3 lakhs = Rs. 0

· A 5% tax on the income range from Rs. 3 lakhs to Rs. 6 lakhs amounts to Rs. 15,000, which can be swiftly ascertained with an income tax calculator focusing on the taxable income under the new regime.

Utilizing an income tax calculator, you'll find that a 10% tax on the taxable income ranging between Rs. 6 lakhs and Rs. 8 lakhs equals Rs. 20,000.

When you apply an income tax calculator to determine the net taxable income, the intermediate tax amount is Rs. 35,000. After adding the 4% cess of Rs. 1,400, the total stands at Rs. 36,400 under the new tax regime.

Making an Informed Decision

The old vs new tax regime calculator excel offers a detailed juxtaposition, enabling you to evaluate the income tax payable under each system. This tool helps you decide which tax regime—old or new—aligns best with your financial situation by considering your overall income and potential investment deductions.

Additional Tips for Tax Planning

Beyond using the old vs new tax regime calculator excel for income tax computations, it's vital to explore other tax saving options and tax saving investment options. To optimize your tax planning, here are some strategies that could lead to significant investment deductions:

1. Utilize Section 80C Deductions

Under Section 80C of the Income Tax Act, you can access a variety of tax benefits through small saving schemes and other investment avenues, each offering a path to reduce your income tax liability.

·Public Provident Fund (PPF)

·Employee Provident Fund (EPF)

·National Savings Certificate (NSC)

·Tax-saving fixed deposits

·Equity-linked savings schemes (ELSS)

Investing in these financial instruments allows you to leverage investment deductions and tax saving investment options, with the possibility of claiming deductions up to Rs. 1.5 lakhs under Section 80C.

2. Consider Section 80CCD(1B) - National Pension Scheme (NPS)

Contributions to the National Pension Scheme (NPS) can fetch you a tax rebate, as they are eligible for an extra deduction under Section 80CCD(1B), which is in addition to the Rs. 1.5 lakhs limit offered by Section 80C.

3. Explore House Rent Allowance (HRA) Exemption

If your compensation includes a house rent allowance (HRA) and you reside in a rental property, you're eligible to claim an HRA exemption. The exempt amount is calculated based on several factors, such as the house rent paid, the HRA received as part of your salary, and the actual rent you pay. To successfully claim this exemption, it's crucial to maintain thorough documentation and provide rent receipts.

4. Maximize Medical Insurance Benefits

Leveraging Section 80D, individuals can secure a tax rebate for medical insurance premiums paid for themselves, their dependents, and their parents. This provision allows a maximum deduction of Rs. 25,000 for non-senior citizens, which escalates to Rs. 50,000 for senior citizens, aiding in financial health management.


The income tax calculator AY 2023-24 Excel TaxGuru is an indispensable asset for simplifying the comparison between the old and new tax regimes. Incorporating this tool into your personal finance and tax planning strategies enables you to make savvy decisions that could reduce your income tax obligations. It's advisable to engage with a tax expert to maximize deductions and exemptions. Harness the power of the Old vs New Tax Regime Calculator Excel today to master your income tax planning.


The Tax Heaven

Mr.Vishwas Agarwal✍📊, a seasoned Chartered Accountant 📈💼 and the co-founder & CEO of THE TAX HEAVEN, brings 10 years of expertise in financial management and taxation. Specializing in ITR filing 📑🗃, GST returns 📈💼, and income tax advisory. He offers astute financial guidance and compliance solutions to individuals and businesses alike. Their passion for simplifying complex financial concepts into actionable insights empowers readers with valuable knowledge for informed decision-making. Through insightful blog content, he aims to demystify financial complexities, offering practical advice and tips to navigate the intricate world of finance and taxation.

Subscribe to the exclusive updates!