Question: Can someone please post how to solve the geometric annual average return on Excel? Per my photo I think i did it correctly, but i

Calculate the geometric and arithmetic annual average returns for the three stocks in the "Homework 3 Data.csv" file. The returns are in decimals (0.12 corresponds to a 12% return). Examine the differences between each measure for each stock. What do you notice? What factor(s) appear to influence the magnitude of the difference between each measure? Solving this problem using excel is recommended but not required. Submission Instructions. Please submit your work as an excel or pdf file to eLearning. Paste 14 b 1 2 3 4 5 16 17 18 19 20 69 S Calibri (Body) V 11 v EE B IU EA- E X fx =(PRODUCT(B2:B11+{1;1;1;1;1;1;1;1;1;1})^(1/10))-1 A B C D E F Year stock 1 stock 2 stock 3 2010 0.102 0.14967 0.372 2011 0.097 0.21 -0.165 2012 0.123 -0.03 0.217 2013 0.134 0.00514 0.100 2014 0.115 0.15 0.235 2015 0.126 -0.1 -0.290 2016 0.087 0.18 0.660 2017 0.105 0.12 -0.169 2018 0.119 0.18347 0.209 2019 0.09298 0.29324 0.267 Arithmetic Annual Average Return 11.01% 11.62% 14.35% Geometric Annual Average Return 11.00% 11.00% 11.00%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
