Scripwise
Taxes

Income Tax Calculator Excel: New Regime Slabs for FY27

Avinash Solanki · Senior Content Strategist
Published · 2 min read

In short

  • New scheme keeps the slab structure the same for FY 2026‑27, so the spreadsheets that were made before can be used again without changing their bands.
  • Employees will find the standard deduction first cut from their pay, and only after that the slab rates are applied to the rest of the income.
  • Builders of simple sheets are trying the rebate edge close to Rs 12 lakh first, because the tax changes quite sharply in that zone.
  • Many simple sheets stop at the slab tax and leave out the 4% cess, while the rebate is also not available to NRIs.
Jump to a section (2)

Budget 2026 has kept the income‑tax slabs for FY 2026‑27 unchanged, so an income‑tax calculator Excel sheet built last year for the new regime still works without any change in its bands. Many individuals who made such sheets for FY 2025‑26 now find that they can reuse same files again.

According to data from CA Club India, the new tax regime has seven slabs. Tax is zero for income up to Rs 4 lakh, and it rises to 5% in the next band, and goes up to 30% on income exceeding Rs 24 lakh.

For salaried people, the tax sheet still shows a standard deduction of Rs 75,000, unchanged for FY 2026‑27. The tax is calculated on the slab rates after this deduction is subtracted from the salary, and then a 4% cess is added on that amount.

Rebate cliff and test values

For resident individuals, the rebate of Rs 60,000 under Section 87A of the old Act removes the entire slab tax on taxable income up to Rs 12 lakh. According to TaxAtlas data, a salaried person earning a gross income of up to Rs 12.75 lakh will owe no tax under the new regime.

Just above Rs 12 lakh, a marginal relief caps the tax at the amount by which income exceeds that threshold. According to CA Club India data, this relief zone goes up to about Rs 12.71 lakh, and many spreadsheet builders are testing this edge first.

Rupaywise data provides the cumulative tax amount at the top of every slab, and these numbers are being used as test values for the formulas.

  • Rs 20,000 at Rs 8 lakh
  • Rs 60,000 at Rs 12 lakh
  • Rs 1.2 lakh at Rs 16 lakh
  • Rs 2 lakh at Rs 20 lakh
  • Rs 3 lakh at Rs 24 lakh

What simple sheets often miss

A lot of basic sheets end just at the slab tax, but you have to add that 4% cess on the final amount, and some builders are omitting this line altogether. The rebate under Section 87A of the old Act does not apply to NRIs, even though they are taxed at the same slab rates as residents.

Sheets that carry the old regime need different inputs. Axis Max Life Insurance data shows the basic exemption limit stays at Rs 2.5 lakh for individuals below 60 years, and the old regime rebate has no marginal relief, so it disappears fully once taxable income crosses Rs 5 lakh.

Return filing threshold equals the Rs 4 lakh basic exemption limit, and it is separate from the rebate limit, says CA Akhilesh Kumar on his website.

income tax calculator excelnew tax regime FY 2026-27income tax slabs 2026-27section 87A rebatemarginal reliefstandard deduction 75000excel tax calculatorold vs new regime

Frequently asked questions

Is there a ready income tax calculator excel for FY 2026-27?

Many individuals are reusing the sheets made for FY 2025-26, as the new regime bands remain the same.

What is the Section 87A rebate in the new regime?

It is a rebate of Rs 60,000 for resident individuals. It clears the slab tax on taxable income up to Rs 12 lakh.

Does the 87A rebate apply to NRIs?

NRIs do not get this rebate. They are taxed at the same slab rates as residents.

Sources & credits

Facts and figures in this article draw on these sources. All writing is our own.

Share this article

XLinkedInFacebookWhatsApp

About the author

Avinash Solanki

Avinash Solanki

Senior Content Strategist Mumbai, India

Writes about markets, business and personal finance with a focus on clear insights and real world takeaways for everyday investors. Aims to make complex financial topics easier to understand through well researched, practical and reader friendly articles.

  • Markets
  • Business
  • Personal Finance
  • Investing
  • Economy

More articles by Avinash →

Screen stocks yourself

Run quality filters on 5,000+ NSE & BSE companies with Scripwise, free.

Keep reading