Zoho Sheet

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
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

SIXTH PAY COMMISSION PENSION BENEFITS - EXPECTED PENSION AND ARREARS CALCULATOR
	NAME OF THE PENSIONER:
ENTER PENSION AS ON 01/03/08 AS PER BANK PASS BOOK							3766	2671	2671	1317	3097	712	3809
ENTER MEDICAL ALLOWANCE AMOUNT RECEIVED (ENTER 0 IF AMOUNT IS NIL)							0					3809	3811
ENTER COMMUTED VALUE PORTION (ENTER 0 IF COMMUTATION IS NIL							0		1780
ENTER DATE OF RETIREMENT (DD-MM-YY)					38078	04/30/04	4/30/2004
WHETHER RECEIVING DEARNESS PENSION					01/01/96	1/1/1996	NO

REVISED PENSION DETAILS
REVISED BASE PENSION AS ON 1.1.2006					36612	4/1/1985	3811
LESS COMMUTATION FACTOR					04/27/19	38718	0
NET PENSION AS ON 1.1.2006							3811
PENSION FITMENT BY JAYALAN			PENSION AS ON 1/1/06	COM.VAL	MED ALOW			OLD PENSION+DP IF ANY	COM VAL	MED ALOW


			3811	0	0			2671	0	0

	MONTH	PENSION	COMM.VAL	MED.ALL	NET	DA	TOT PEN	DRAWN					arrears
	Jan-06	3811	0	0	3811	0	3811	2671	0	641	0	3312	499
	Feb-06	3811	0	0	3811	0	3811	2671	0	641	0	3312	499
	Mar-06	3811	0	0	3811	0	3811	2671	0	641	0	3312	499
	Apr-06	3811	0	0	3811	0	3811	2671	0	641	0	3312	499
	May-06	3811	0	0	3811	0	3811	2671	0	641	0	3312	499
	Jun-06	3811	0	0	3811	0	3811	2671	0	641	0	3312	499
	Jul-06	3811	0	0	3811	0	3811	2671	0	775	0	3446	365
	Aug-06	3811	0	0	3811	0	3811	2671	0	775	0	3446	365
	Sep-06	3811	0	0	3811	0	3811	2671	0	775	0	3446	365
	Oct-06	3811	0	0	3811	0	3811	2671	0	775	0	3446	365
	Nov-06	3811	0	0	3811	0	3811	2671	0	775	0	3446	365
	Dec-06	3811	0	0	3811	0	3811	2671	0	775	0	3446	365
	Jan-07	3811	0	0	3811	229	4040	2671	0	935	0	3606	434
	Feb-07	3811	0	0	3811	229	4040	2671	0	935	0	3606	434
	Mar-07	3811	0	0	3811	229	4040	2671	0	935	0	3606	434
	Apr-07	3811	0	0	3811	229	4040	2671	0	935	0	3606	434
	May-07	3811	0	0	3811	229	4040	2671	0	935	0	3606	434
	Jun-07	3811	0	0	3811	229	4040	2671	0	935	0	3606	434
	Jul-07	3811	0	0	3811	457	4268	2671	0	1095	0	3766	502
	Aug-07	3811	0	0	3811	457	4268	2671	0	1095	0	3766	502
	Sep-07	3811	0	0	3811	457	4268	2671	0	1095	0	3766	502
	Oct-07	3811	0	0	3811	457	4268	2671	0	1095	0	3766	502
	Nov-07	3811	0	0	3811	457	4268	2671	0	1095	0	3766	502
	Dec-07	3811	0	0	3811	457	4268	2671	0	1095	0	3766	502
	Jan-08	3811	0	0	3811	686	4497	2671	0	1255	0	3926	571
	Feb-08	3811	0	0	3811	686	4497	2671	0	1255	0	3926	571
	Mar-08	3811	0	0	3811	686	4497	2671	0	1255	0	3926	571
	TOTAL	102889	0	0	102889	6174	109063	72117	0	24441	0	96558	12505

		EXPECTED PENSION AS ON APRIL-08
	MONTH	PENSION	COMM.VAL	MED.ALL	NET	DA	TOT PEN
	Apr-08	3811	0	0	3811	686	4497

pen arr calc sheet

penfitment