Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investment Risk Management

Authors: Yen Yee Chong

1st Edition

0470849517, 9780470849514

More Books

Students also viewed these Finance questions