New_EPS_Calc.xlsx

	A	B	C	D	E	F	G	H	I
1	Inputs			RESULT
2	Initial Salary pm	₹ 10,000.00			Last 5 yrs Average Pay	New Pension	Old Pension	Old Pension - EPF	Total Old Pension Amount
3	Salary Inflation	10%		Per Annum	₹ 2,473,600.00	₹ 1,236,000.00	₹ 90,000.00	₹ 352,000.00	₹ 442,000.00
4	Employer Contribution	12%		Per Month	₹ 206,100.00	₹ 103,000.00	₹ 7,500.00	₹ 29,300.00	₹ 36,800.00
5	EPS Share	70%
6	EPS Old Option max pm	₹ 1,250.00
7	EPF Return	8%
8	Final EPF Corpus	₹ 4,411,000.00
9	Return on EPF Corpus	8%
10
11	Year #	Annual Salary	New EPS Contribution	Old EPS Contribution	Old EPF Contribution - EPS Contribution	EPF Corpus
12	1	120000	10080	10080	0	0
13	2	132000	11088	11088	0	0
14	3	145000	12180	12180	0	0
15	4	159000	13356	13356	0	0
16	5	174000	14616	14616	0	0
17	6	191000	16044	15000	1044	1000
18	7	210000	17640	15000	2640	3000
19	8	231000	19404	15000	4404	7000
20	9	254000	21336	15000	6336	14000
21	10	279000	23436	15000	8436	24000
22	11	306000	25704	15000	10704	37000
23	12	336000	28224	15000	13224	54000
24	13	369000	30996	15000	15996	75000
25	14	405000	34020	15000	19020	101000
26	15	445000	37380	15000	22380	133000
27	16	489000	41076	15000	26076	171000
28	17	537000	45108	15000	30108	217000
29	18	590000	49560	15000	34560	271000
30	19	649000	54516	15000	39516	335000
31	20	713000	59892	15000	44892	410000
32	21	784000	65856	15000	50856	497000
33	22	862000	72408	15000	57408	598000
34	23	948000	79632	15000	64632	715000
35	24	1042000	87528	15000	72528	850000
36	25	1146000	96264	15000	81264	1005000
37	26	1260000	105840	15000	90840	1183000
38	27	1386000	116424	15000	101424	1387000
39	28	1524000	128016	15000	113016	1620000
40	29	1676000	140784	15000	125784	1885000
41	30	1843000	154812	15000	139812	2186000
42	31	2027000	170268	15000	155268	2528000
43	32	2229000	187236	15000	172236	2916000
44	33	2451000	205884	15000	190884	3355000
45	34	2696000	226464	15000	211464	3851000
46	35	2965000	249060	15000	234060	4411000
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