Calculating Annualized returns of 1 year, 3 years, 5 years, and 10 years from the data of 132 months/ 11 Years

[Brandon_333]

Hello everyone; I hope you all are doing well. New to this forum, so please help me. I recently got an internship and I have been given a task to Calculate annualized returns of 1 year, 3 years, 5 years, and 10 years and also the calendar year returns of 2022-2013. I browsed forum to solve the answer I have got some values but I'm not sure if it's correct so I'm posting the raw data here. Hope you all can help me. Monthly returns are from cell O23:O154. Thank you in advance.

Calculation.xlsx
	O
23	-3.41%
24	-11.17%
25	-6.56%
26	-10.88%
27	-11.87%
28	-10.92%
29	-7.41%
30	-10.97%
31	-3.76%
32	-2.57%
33	3.51%
34	4.64%
35	7.39%
36	11.04%
37	10.30%
38	17.53%
39	13.56%
40	15.52%
41	15.27%
42	17.02%
43	16.32%
44	18.07%
45	25.38%
46	14.06%
47	8.72%
48	10.73%
49	8.91%
50	4.67%
51	7.49%
52	9.04%
53	7.49%
54	5.28%
55	5.76%
56	0.92%
57	-4.16%
58	6.64%
59	13.00%
60	15.34%
61	12.62%
62	10.96%
63	7.40%
64	5.78%
65	6.36%
66	6.92%
67	6.05%
68	9.36%
69	7.62%
70	5.01%
71	1.30%
72	-2.73%
73	0.46%
74	0.13%
75	3.94%
76	5.72%
77	5.12%
78	3.29%
79	1.50%
80	0.28%
81	0.71%
82	1.52%
83	4.84%
84	5.54%
85	6.19%
86	6.20%
87	3.26%
88	2.39%
89	2.55%
90	5.19%
91	7.03%
92	8.81%
93	8.57%
94	12.61%
95	11.44%
96	9.16%
97	7.56%
98	5.96%
99	10.42%
100	9.18%
101	6.03%
102	4.87%
103	1.64%
104	-0.26%
105	-1.02%
106	-6.11%
107	-5.82%
108	-1.36%
109	-1.37%
110	0.90%
111	0.16%
112	-0.57%
113	3.70%
114	2.72%
115	5.77%
116	7.21%
117	8.33%
118	10.60%
119	11.82%
120	9.03%
121	9.58%
122	7.85%
123	8.85%
124	12.18%
125	9.63%
126	11.33%
127	7.69%
128	5.44%
129	6.10%
130	5.28%
131	4.08%
132	5.91%
133	6.73%
134	7.14%
135	4.58%
136	4.74%
137	5.73%
138	5.54%
139	9.21%
140	8.89%
141	7.13%
142	7.39%
143	8.06%
144	5.99%
145	4.78%
146	4.59%
147	4.13%
148	2.78%
149	2.54%
150	1.30%
151	0.22%
152	1.87%
153	1.90%
154	1.51%
Portfolio_Calculation

Cell Formulas
Range	Formula
O23:O154	O23	=IF($A23>132,"",PRODUCT(1+D23,1+D24,1+D25,1+D26,1+D27,1+D28,1+D29,1+D30,1+D31,1+D32,1+D33,1+D34)-1)