FinPlan NAPindex.xlsx

	B	C	D	E	F	I	J	K	L	M	N	O	P	Q	R	S	T
1	Historial Data 2000-2025					Nifty 50 Data
2	Calendar Year	Nifty 50 (%)	Midcap Nifty (%)	Gold (%)	Average %	Year	Open	Close	High	Low	Change	Return %	CAGR 3Y%	CAGR 5Y%	CAGR 10Y%	CAGR 15Y%	CAGR 20Y%
3	2000	-14.7%	-13.4%	3.9%	-8.0%	2000	1482	1264	1818	1108	-219	-14.7%
4	2001	-16.2%	-15.1%	-2.3%	-11.2%	2001	1264	1059	1423	850	-204	-16.2%
5	2002	3.3%	5.3%	16.1%	8.2%	2002	1059	1094	1206	920	35	3.3%	-9.6%
6	2003	71.9%	76.6%	12.2%	53.6%	2003	1094	1880	1914	920	786	71.9%	14.2%
7	2004	10.7%	13.0%	4.5%	9.4%	2004	1880	2081	2088	1292	200	10.6%	25.2%	7.0%
8	2005	36.3%	38.6%	19.7%	31.5%	2005	2080	2837	2857	1894	757	36.4%	37.4%	17.6%
9	2006	39.8%	28.4%	20.0%	29.4%	2006	2837	3966	4047	2596	1130	39.8%	28.3%	30.2%
10	2007	54.8%	77.6%	23.4%	51.9%	2007	3966	6139	6185	3555	2172	54.8%	43.4%	41.2%
11	2008	-51.8%	-60.0%	15.7%	-32.0%	2008	6137	2959	6357	2253	-3178	-51.8%	1.4%	9.5%
12	2009	71.3%	105.4%	16.0%	64.2%	2009	2963	5201	5222	2539	2238	75.5%	9.5%	20.1%	13.4%
13	2010	18.0%	19.2%	27.6%	21.6%	2010	5201	6135	6339	4675	934	18.0%	0.0%	16.7%	17.1%
14	2011	-24.6%	-33.0%	42.7%	-5.0%	2011	6177	4624	6181	4531	-1553	-25.1%	16.0%	3.1%	15.9%
15	2012	27.7%	38.6%	17.6%	28.0%	2012	4640	5905	5965	4588	1265	27.3%	4.3%	-0.8%	18.4%
16	2013	6.8%	-3.4%	-4.7%	-0.4%	2013	5938	6304	6415	5119	366	6.2%	0.9%	16.3%	12.9%
17	2014	31.4%	55.1%	-5.4%	27.0%	2014	6324	8283	8627	5933	1959	31.0%	21.4%	9.8%	14.8%	12.2%
18	2015	-4.1%	6.5%	-5.9%	-1.2%	2015	8273	7946	9119	7540	-326	-3.9%	10.4%	5.3%	10.9%	13.0%
19	2016	3.0%	-4.8%	8.7%	2.3%	2016	7938	8186	8969	6826	247	3.1%	9.1%	12.1%	7.5%	14.6%
20	2017	28.7%	65.7%	3.7%	32.7%	2017	8210	10531	10552	8134	2321	28.3%	8.3%	12.3%	5.5%	16.3%
21	2018	3.2%	-15.4%	6.0%	-2.1%	2018	10532	10863	11760	9952	331	3.1%	11.0%	11.5%	13.9%	12.4%
22	2019	12.0%	-4.3%	12.0%	6.6%	2019	10882	12168	12294	10584	1287	11.8%	14.1%	8.0%	8.9%	12.5%	11.1%
23	2020	14.9%	21.9%	38.1%	25.0%	2020	12202	13982	14025	7511	1780	14.6%	9.9%	12.0%	8.6%	11.2%	12.8%
24	2021	24.1%	46.1%	0.1%	23.4%	2021	13996	17354	18604	13597	3358	24.0%	16.9%	16.2%	14.1%	10.3%	15.0%
25	2022	4.3%	3.5%	8.1%	5.3%	2022	17387	18105	18888	15183	718	4.1%	14.2%	11.4%	11.9%	7.5%	15.1%
26	2023	19.4%	46.6%	24.0%	30.0%	2023	18132	21731	21801	16828	3600	19.9%	15.8%	14.9%	13.2%	14.2%	13.0%
27	2024	8.8%	23.9%	23.4%	18.7%	2024	21728	23645	26277	21137	1917	8.8%	10.9%	14.2%	11.1%	10.6%	12.9%
28	2025	10.5%	5.7%	59.5%	25.3%	2025	23638	26130	26326	21744	2492	10.5%	13.0%	13.3%	12.6%	10.1%	11.7%
29	Average	15.0%	20.3%	14.8%	16.7%						Average	15.0%
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