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

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 could be mkstaken.
Can someone please post how to solve the geometric annual average return
on Excel? Per my photo I think i did it correctly, but

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!