IT AY 2024-25 Ver 24.0.xlsm

	B	E	K	L	N	O	P	Q	S	U	V	W	Z
1
2	Income Tax Calculation for AY 2024-25 (FY 2023-24)
3
4					Version 24.0
5
6
7
8
9
10	Enter the following Data :
11	Name										ARUNAGIRI K (4303054321)
12
13	Designation											PG ASSISTANT
14
15	PAN											AJQPA1234K
16
17	School / Office NAME											GHSS JAYAPURAM
18
19	School / Office TAN											CHEG12345F
22			Age : below 60 Years
25	Date of Birth					dd-mm-yyyy						3/7/1979
26
27
28		LEVEL in Pay Matrix
29													FALSE
30		BASIC Pay for Mar-2023
31										TRUE		FALSE
32		Increment Month								FALSE	FALSE	TRUE
34					₨				SPF	₨		70
35
36	Personal Pay for Mar-2023								Conv	₨		0
37	PF Scheme
38
39
40				0			0
42
45		Monthly House Rent PAID			₨	0		0				.
46										TRUE
47		Professional Tax Paid			₨	0
48
49		Interest on Housing Loan u/s 24 (b)			₨	0		Max. ₨2,00,000
50
51		Repayment of Housing Loan (Principal)			₨	0		No Limits but bound to the limit u/s 80 C
54
55
56		Permanent Disabilty (Self)
57		Permanent Disabilty (Dependant)
58
59
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257