This free Excel income tax calculator compares the Old Regime and New Regime for FY 2025-26 (AY 2026-27) side by side, including Section 87A rebate, marginal relief, surcharge and 4% Health & Education Cess. Enter your income and deductions in the yellow cells and both regimes recalculate instantly — no signup, no macros, works in Excel, Google Sheets and LibreOffice.
Download Excel Calculator (.xlsx)
Preview above is view-only. Click “Download Excel Calculator” to get your own editable copy.
What’s Inside the Workbook
How to Use This Calculator
- Download the file and open it in Excel, Google Sheets or LibreOffice Calc.
- Go to the Calculator sheet and fill in the yellow input cells: salaried status, age category, gross annual income and any deductions you claim.
- Both regimes’ tax, rebate, surcharge and cess update automatically — the bottom row tells you which regime saves more and by how much.
- Check the Worked Examples sheet to see the same logic applied to common income levels.
Tax Slabs Used in This Calculator (FY 2025-26)
| New Regime Income Slab | Rate |
|---|---|
| Rs 0 – 4,00,000 | 0% |
| Rs 4,00,000 – 8,00,000 | 5% |
| Rs 8,00,000 – 12,00,000 | 10% |
| Rs 12,00,000 – 16,00,000 | 15% |
| Rs 16,00,000 – 20,00,000 | 20% |
| Rs 20,00,000 – 24,00,000 | 25% |
| Above Rs 24,00,000 | 30% |
| Old Regime Income Slab | Below 60 | 60–80 (Senior) | 80+ (Super Senior) |
|---|---|---|---|
| Rs 0 – 2,50,000 | 0% | ||
| Rs 2,50,000 – 3,00,000 | 5% | 0% | |
| Rs 3,00,000 – 5,00,000 | 5% | 5% | 0% |
| Rs 5,00,000 – 10,00,000 | 20% | 20% | 20% |
| Above Rs 10,00,000 | 30% | 30% | 30% |
Standard deduction: Rs 75,000 (new regime) or Rs 50,000 (old regime) for salaried/pensioners. Section 87A rebate makes tax zero up to Rs 12,00,000 taxable income under the new regime (with marginal relief above it), or up to Rs 5,00,000 under the old regime (no marginal relief). Surcharge applies only above Rs 50 lakh taxable income; 4% cess applies on tax + surcharge in both regimes.
Worked Examples
| Scenario | Old Regime Tax | New Regime Tax |
|---|---|---|
| Rs 7,00,000 salary, no deductions | Rs 44,200 | Rs 0 |
| Rs 12,75,000 salary, no deductions | Rs 1,87,200 | Rs 0 |
| Rs 13,00,000 salary (marginal relief kicks in) | Rs 1,95,000 | Rs 26,000 |
| Rs 25,00,000 salary, 80C + 80D + home loan claimed | Rs 4,52,400 | Rs 3,19,800 |
Frequently Asked Questions
- Is this Excel calculator free to download?
- Yes. There is no signup, watermark or paywall. Click the download button above to save your own copy.
- Does it work in Google Sheets?
- Yes. Upload the downloaded .xlsx file to Google Drive and open it with Google Sheets — all formulas are standard functions (IF, MIN, MAX) supported everywhere.
- Why does my old regime tax jump sharply just above Rs 5 lakh?
- The old regime’s Section 87A rebate has no marginal relief — it fully disappears the moment taxable income crosses Rs 5,00,000. The new regime avoids this cliff above Rs 12,00,000 with a marginal relief formula, which this calculator applies automatically.
- Which regime should I choose?
- For most salaried individuals with limited deductions, the new regime results in lower or zero tax. If you claim large deductions (80C, HRA, home loan interest), the old regime can still work out cheaper — enter your numbers in the calculator to see your specific answer.
- Is this calculator accurate?
- The formulas are cross-checked against our online Old vs New Regime Calculator and verified against multiple worked examples. It is for information only — verify with a tax professional before filing.
Related Tools & Guides
Old vs New Tax Regime Calculator (online tool) · Take-Home Salary Calculator · HRA Exemption Calculator · Capital Gains Tax Calculator · Advance Tax Calculator · Complete Income Tax & ITR Guide
This calculator and article are for general information only and do not constitute tax advice. Tax rules can change; verify your calculation with a qualified professional before filing. See our disclaimer.
