Income Tax Calculation Template
Department of Atomic Energy
Administrative Training Institute
Calculate Income Tax – Activity
1. Create a new MS Excel worksheet and enter the data given below:
A
B C
D
1 NAME CATEGORY TAXABLE
INCOME
INCOME
TAX
2 A
M 310000
3 B
F 700000
4 C
S 320000
5 D
M 510000
6 E
F 195000
7 F
S 350000
8 G
M 310000
9 H
F 156000
10 I
S 320000
11 J
S 850000
2. In Cell C2 please enter the following formula (Please do not leave any space in
between or press enter key. The formula has to be entered in one stretch). Copy
the formula to the remaining cells below C2
=IF(B2="S",(IF(C2>800000,((C2-800000)*0.3)+86000,IF(C2>500000,
((C2-500000)*0.2)+26000,IF(C2>240000,(C2-
240000)*0.1,0)))),IF(B2="f",(IF(C2>800000,((C2-
800000)*0.3)+91000,IF(C2>500000,((C2-
500000)*0.2)+31000,IF(C2>190000,(C2-190000)*0.1,0)))),
(IF(C2>800000,((C2-800000)*0.3)+94000,IF(C2>500000,((C2-
500000)*0.2)+34000,IF(C2>160000,(C2-160000)*0.1,0))))))
Note: 1 - The above calculation is based on following slabs
Category Income
exempted from
Tax
First Slab Second Slab Third Slab
Male 1,60,000 160001 to
500000 @ 10%
500001 to
800000 @ 20%
800001 and
above @ 30%
Female 1,90,000 190001 to
500000 @ 10%
500001 to
800000 @ 20%
800001 and
above @ 30%
Senior Citizen 2,40,000 240001 to
500000 @ 10%
500001 to
800000 @ 20%
800001 and
above @ 30%
Note: 2 – Education Cess; Surcharge etc. as per rules.
Page 1/1
Free Download
Income Tax Calculation Template DOC
Favor this template? Just fancy it by voting!
(0 Votes)
0.0
Related Forms
