Income Tax Calculator Formula Guide (Old vs New Regime) – Complete Guide
Agar aap khud se calculate karna chahte hain ki aapko kitna income tax dena padega, to aapko sirf 5 cheezein samajhni hain:
-
Gross Salary
-
Standard Deduction
-
Other Deductions (80C, 80D etc.)
-
Tax Slab
-
4% Cess
India me income tax system ko manage karta hai:
Income Tax Department
Step 1: Taxable Income Ka Formula
✅ Formula:
Taxable Income = Gross Income – Standard Deduction – Other Deductions
Example:
Gross Salary = ₹10,00,000
Standard Deduction = ₹50,000
80C Investment = ₹1,50,000
Taxable Income =
10,00,000 – 50,000 – 1,50,000
= ₹8,00,000
Step 2: Slab Wise Tax Calculation Formula
General Formula:
Tax = (Income in Slab × Slab Rate)
Har slab ke liye alag-alag calculate karke total add karte hain.
Old Tax Regime Formula (Example Structure)
| Slab | Rate |
|---|---|
| 0 – 2.5L | 0% |
| 2.5L – 5L | 5% |
| 5L – 10L | 20% |
| Above 10L | 30% |
Example: Taxable Income = ₹8,00,000
-
₹2.5L – ₹5L
= ₹2,50,000 × 5% = ₹12,500 -
₹5L – ₹8L
= ₹3,00,000 × 20% = ₹60,000
Total Tax = ₹72,500
Step 3: Cess Add Karna
Final Tax = Total Tax + 4% Cess
Formula:
Final Tax = Total Tax × 1.04
Example:
₹72,500 × 1.04 = ₹75,400
👉 Ye aapka final tax hoga.
New Tax Regime Formula (Example Structure)
| Slab | Rate |
|---|---|
| 0 – 3L | 0% |
| 3L – 6L | 5% |
| 6L – 9L | 10% |
| 9L – 12L | 15% |
| 12L – 15L | 20% |
| Above 15L | 30% |
Same method use hota hai – har slab ka alag tax calculate karo, phir add karo.
Excel Me Tax Calculator Kaise Banaye?
Agar aap Excel use karte hain, to ye simple formula ka use kar sakte hain.
Step 1:
Cell A1 = Gross Salary
Cell A2 = Standard Deduction
Cell A3 = Other Deduction
Step 2:
Taxable Income Formula:
=A1-A2-A3
Basic Slab Calculation Logic (Example)
Agar taxable income B1 cell me hai:
Old Regime Example (simplified logic):
=IF(B1<=250000,0,
IF(B1<=500000,(B1-250000)5%,
IF(B1<=1000000,(2500005%)+(B1-500000)20%,
(2500005%)+(500000*20%)+(B1-1000000)*30%)))
Phir 4% Cess add karne ke liye:
=TaxCell*1.04
Quick Manual Shortcut Method
1️⃣ Total Income likho
2️⃣ Deductions minus karo
3️⃣ Slab me divide karo
4️⃣ Har slab ka tax nikalo
5️⃣ Sab add karo
6️⃣ 4% multiply karo
Important Points
✔ Standard deduction ko mat bhooliye
✔ Old vs New regime compare kariye
✔ Rebate (agar applicable ho) check kariye
✔ Latest budget ke slab rates confirm kariye
Conclusion
Income tax calculate karna mushkil nahi hai.
Bas sahi formula use karein aur slab-wise calculation karein.
Agar aap har saal apna tax khud calculate karte hain, to:
✔ Aap better planning kar sakte hain
✔ Extra tax payment avoid kar sakte hain
✔ Smart financial decision le sakte hain
No comments:
Post a Comment