ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Sheet Name: Arrear Calculation (with Auto Formulas)
2
From,To,Months,Per Month Due,Total Due,Per Month Drawn,Total Drawn,Difference,Recovery,Net
3
01-NOV-2016,31-DEC-2016,2,19533,=C2*D2,0,=F2*G2,=E2-H2,0,=I2-J2
4
01-JAN-2017,30-JUN-2017,6,19916,=C3*D3,0,=F3*G3,=E3-H3,0,=I3-J3
5
01-JUL-2017,31-DEC-2017,6,20108,=C4*D4,0,=F4*G4,=E4-H4,0,=I4-J4
6
01-JAN-2018,30-JUN-2018,6,20491,=C5*D5,0,=F5*G5,=E5-H5,0,=I5-J5
7
01-JUL-2018,31-DEC-2018,6,20874,=C6*D6,0,=F6*G6,=E6-H6,0,=I6-J6
8
01-JAN-2019,30-JUN-2019,6,21448,=C7*D7,0,=F7*G7,=E7-H7,0,=I7-J7
9
01-JUL-2019,31-DEC-2021,30,22406,=C8*D8,0,=F8*G8,=E8-H8,0,=I8-J8
10
01-JUL-2021,31-DEC-2021,6,25087,=C9*D9,0,=F9*G9,=E9-H9,0,=I9-J9
11
01-JAN-2022,30-JUN-2022,6,25661,=C10*D10,0,=F10*G10,=E10-H10,0,=I10-J10
12
01-JUL-2022,31-DEC-2022,6,26427,=C11*D11,0,=F11*G11,=E11-H11,0,=I11-J11
13
01-JAN-2023,30-JUN-2023,6,27193,=C12*D12,0,=F12*G12,=E12-H12,0,=I12-J12
14
01-JUL-2023,31-DEC-2023,6,27959,=C13*D13,0,=F13*G13,=E13-H13,0,=I13-J13
15
01-JAN-2024,30-JUN-2024,6,28725,=C14*D14,0,=F14*G14,=E14-H14,0,=I14-J14
16
01-JUL-2024,31-DEC-2024,6,29300,=C15*D15,0,=F15*G15,=E15-H15,0,=I15-J15
17
01-JAN-2025,30-JUN-2025,6,29683,=C16*D16,0,=F16*G16,=E16-H16,0,=I16-J16
18
,,,,,,,=SUM(I2:I16),=SUM(J2:J16),=SUM(K2:K16)
19
TOTALS,,,,,0,0,2514042.00,0.00,2514042.00
20
21
Sheet Name: Form10E Year-wise (Tax Relief Calculator)
22
Financial Year,Arrear Amount,Previous Year Income (apna daalo),Tax Paid Previous (apna daalo),Tax on Arrear (auto),Relief (auto)
23
2016-17,158562,,,"=B2*0.1","=B2*(C2/100)"
24
2017-18,243594,,,"=B3*0.1","=B3*(C3/100)"
25
2018-19,253932,,,"=B4*0.1","=B4*(C4/100)"
26
2019-21,301044,,,"=B5*0.1","=B5*(C5/100)"
27
2021-22,304488,,,"=B6*0.1","=B6*(C6/100)"
28
2022-23,321720,,,"=B7*0.1","=B7*(C7/100)"
29
2023-24,340104,,,"=B8*0.1","=B8*(C8/100)"
30
2024-25,178098,,,"=B9*0.1","=B9*(C9/100)"
31
Grand Total,=SUM(B2:B9),,,"=SUM(E2:E9)","=SUM(F2:F9)"
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100