Withdrawal Plan In Retirement

	A	B	C	D	E	F	G	H	I	J	K	L	M	O	P
1
2	Age	Corpus	Equity	Debt MF	Expenses	Equity %	Fixed Income %	FD rate	Inflation	Equity	Nifty date	Nifty	Units

3		600						10.50%	7.16%		1/1/1997	940
4	40	588	360	228	12	61%	39%	9.00%	13.23%	15.08%	1/1/1998	1081	0.33	Equity allocation	60%
5	41	532	316	216	14	59%	41%	8.50%	4.67%	-17.61%	1/1/1999	891	0.35	FD rate	6%
6	42	784	468	317	14	60%	40%	8.50%	4.01%	78.74%	1/1/2000	1592	0.29	Inflation	6%
7	43	697	414	283	15	59%	41%	7.50%	3.78%	-21.22%	1/1/2001	1254	0.33
8	44	637	380	257	15	60%	40%	4.25%	4.30%	-15.87%	1/1/2002	1055	0.36
9	45	648	392	256	16	60%	40%	4.00%	3.81%	4.25%	1/1/2003	1100	0.36
10	46	932	562	369	17	60%	40%	5.25%	3.77%	73.82%	1/1/2004	1912	0.29
11	47	993	598	395	17	60%	40%	6.00%	4.25%	10.60%	1/1/2005	2115	0.28
12	48	1,203	722	481	18	60%	40%	6.75%	5.80%	34.09%	1/1/2006	2836	0.25
13	49	1,515	907	607	19	60%	40%	8.00%	6.37%	41.31%	1/1/2007	4007	0.23
14	50	2,027	1,210	817	20	60%	40%	8.00%	8.35%	53.33%	1/1/2008	6144	0.20
15	51	1,458	866	592	22	59%	41%	6.00%	10.88%	-50.63%	1/1/2009	3033	0.29
16	52	2,097	1,259	837	24	60%	40%	8.25%	11.99%	72.48%	1/1/2010	5232	0.24
17	53	2,361	1,407	954	27	60%	40%	9.00%	8.86%	17.69%	1/1/2011	6158	0.23
18	54	2,070	1,226	844	30	59%	41%	8.75%	9.31%	-24.70%	1/1/2012	4637	0.26
19	55	2,459	1,463	996	32	60%	40%	8.75%	11.06%	28.34%	1/1/2013	5951	0.25
20	56	2,596	1,544	1,053	36	59%	41%	8.50%	6.65%	5.89%	1/1/2014	6302	0.24
21	57	3,133	1,865	1,268	38	60%	40%	7.25%	4.91%	31.46%	1/1/2015	8284	0.23
22	58	3,112	1,859	1,253	40	60%	40%	6.75%	4.95%	-3.87%	1/1/2016	7963	0.23
23	59	3,205	1,919	1,287	42	60%	40%	6.40%	3.33%	2.72%	1/1/2017	8180	0.23
24	60	3,773	2,262	1,512	44	60%	40%	6.25%	3.95%	27.58%	1/1/2018	10436	0.22
25	61	3,925	2,354	1,571	45	60%	40%	5.00%	3.72%	4.55%	1/1/2019	10910	0.22
26	62	4,231	2,549	1,682	47	60%	40%	4.90%	6.62%	11.66%	1/1/2020	12183	0.21
27	63	4,648	2,802	1,846	50	60%	40%	4.90%	5.56%	15.07%	1/1/2021	14019	0.20
28	64	5,406	3,257	2,149	53	60%	40%	6.00%	6.00%	25.73%	1/1/2022	17626	0.18
29	65	5,970	3,584	2,386	56	60%	40%	6.00%	6.00%	15.08%	1/1/1998	20283	0.18
30	66	5,422	3,255	2,167	60	60%	40%	6.00%	6.00%	-17.61%	1/1/1999	16711	0.19
31	67	8,052	4,834	3,219	63	60%	40%	6.00%	6.00%	78.74%	1/1/2000	29869	0.16
32	68	7,153	4,294	2,859	67	60%	40%	6.00%	6.00%	-21.22%	1/1/2001	23530	0.18
33	69	6,572	3,946	2,627	71	60%	40%	6.00%	6.00%	-15.87%	1/1/2002	19797	0.20
34	70	6,822	4,096	2,726	75	60%	40%	6.00%	6.00%	4.25%	1/1/2003	20639	0.20
35	71	9,930	5,961	3,969	80	60%	40%	6.00%	6.00%	73.82%	1/1/2004	35873	0.17
36	72	10,716	6,432	4,283	84	60%	40%	6.00%	6.00%	10.60%	1/1/2005	39677	0.16
37	73	13,076	7,848	5,227	90	60%	40%	6.00%	6.00%	34.09%	1/1/2006	53202	0.15
38	74	16,536	9,925	6,611	95	60%	40%	6.00%	6.00%	41.31%	1/1/2007	75178	0.13
39	75	22,125	13,278	8,847	101	60%	40%	6.00%	6.00%	53.33%	1/1/2008	115266	0.12
40	76	15,826	9,499	6,327	107	60%	40%	6.00%	6.00%	-50.63%	1/1/2009	56907	0.17
41	77	22,979	13,791	9,188	113	60%	40%	6.00%	6.00%	72.48%	1/1/2010	98155	0.14
42	78	25,849	15,514	10,336	120	60%	40%	6.00%	6.00%	17.69%	1/1/2011	115515	0.13
43	79	22,511	13,511	9,000	127	60%	40%	6.00%	6.00%	-24.70%	1/1/2012	86984	0.16
44	80	26,745	16,052	10,694	135	60%	40%	6.00%	6.00%	28.34%	1/1/2013	111636	0.14
45	81	28,190	16,919	11,271	143	60%	40%	6.00%	6.00%	5.89%	1/1/2014	118217	0.14
46	82	34,038	20,428	13,610	151	60%	40%	6.00%	6.00%	31.46%	1/1/2015	155406	0.13
47	83	33,903	20,347	13,556	160	60%	40%	6.00%	6.00%	-3.87%	1/1/2016	149387	0.14
48	84	35,099	21,065	14,034	170	60%	40%	6.00%	6.00%	2.72%	1/1/2017	153445	0.14
49	85	41,571	24,949	16,622	180	60%	40%	6.00%	6.00%	27.58%	1/1/2018	195768	0.13
50	86	43,512	26,114	17,398	191	60%	40%	6.00%	6.00%	4.55%	1/1/2019	204670	0.13
51	87	47,399	28,446	18,953	202	60%	40%	6.00%	6.00%	11.66%	1/1/2020	228540	0.12
52	88	52,609	31,573	21,036	215	60%	40%	6.00%	6.00%	15.07%	1/1/2021	262983	0.12
53	89	61,768	37,069	24,700	227	60%	40%	6.00%	6.00%	25.73%	1/1/2022	330653	0.11
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