Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started