Income Tax Calculator in Excel
Content
Income Tax Calculator
Income Tax Payee Type Gross Total Income Deduction under VI A Total Income Tax Slab 180,000 500,000 800,000 8,00,000+ Tax on Total Income Education Cess Tax Payable Monthly Income Effective Tax Ratio Gross Total Income/12 Gross Total Income/Tax Payable K.Gandhi Sr. Citizen>60, Very Sr. Citizen>80 After Allowances & HRA 80C, Infra Bonds, Mediclaim Tax payable on this income Slab Income 180,000 320,000 300,000 80,000 Dropdown Input Input Input Output Tax Rate 0% 10% 20% 30% Output 3% Output Output Output Output
Monthly Tax (Appx TDS) Tax Payable/12 Copyright - www.fpindia.in
culator
Male 1,000,000 120,000 880,000 Tax Amount 32,000 60,000 24,000 116,000 3,480 119,480 83,333 9,957 11.95%
Income Tax Payee Type Gross Total Income Deduction under VI A Total Income Tax Slab 180,000 500,000 800,000 8,00,000+ Tax on Total Income Education Cess Tax Payable Monthly Income Effective Tax Ratio Gross Total Income/12 Gross Total Income/Tax Payable K.Gandhi Sr. Citizen>60, Very Sr. Citizen>80 After Allowances & HRA 80C, Infra Bonds, Mediclaim Tax payable on this income Slab Income 180,000 320,000 300,000 80,000 Dropdown Input Input Input Output Tax Rate 0% 10% 20% 30% Output 3% Output Output Output Output
Monthly Tax (Appx TDS) Tax Payable/12 Copyright - www.fpindia.in
culator
Male 1,000,000 120,000 880,000 Tax Amount 32,000 60,000 24,000 116,000 3,480 119,480 83,333 9,957 11.95%
