SIP with 10K.xlsx

	A	B	C	D	E
1	Monthly Salary	20,000
2	Monthly Investment	50%
3	Investment Amount	40,000
4
5		Returns	Allocation	Amount
6	FDs	6.05%	0%	-
7	Real Estate	6.96%	0%	-
8	Corporate Bonds	7.50%	0%	-
9	EPF	8.38%	0%	-
10	Gold	10.41%	0%	-
11	Nifty50 Index	15.90%	40%	16,000
12	Midcap100	21.38%	30%	12,000
13	Smallcap250	29.96%	30%	12,000
14		21.76%	100%	40,000
15
16	Savings Increment	5%
17	Inflation	5%
18
19	After years	Salary pm	Investment (pm)	Amount (Cr)	Today's price Cr)
20	10	124,106	62,053	2.11	1.30
21	15	158,395	79,197	7.99	3.84
22	20	202,156	101,078	30.02	11.31
23	25	258,008	129,004	116.68	34.46
24	30	329,291	164,645	470.58	108.88
25	35	420,268	210,134	1,953.74	354.19
26	40	536,380	268,190	8,202.93	1,165.19
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
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