Question

In: Finance

EXCEL FILE ONLY Refer to the table below. The table below shows the annual returns (in...

EXCEL FILE ONLY

Refer to the table below. The table below shows the annual returns (in percentages) for 2 major market indices. For each index, calculate the arithmetic mean return and the geometric mean return of full-year returns from 2005-2015. What is the relationship between the arithmetic and geometric mean returns?

2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005
Nasdaq Composite Index 1.37 8.59 50.0 -31.5 -21.1 -39.3 85.6 39.6 21.6 22.7 39.9
Dow Jones Industrial Average -0.61 3.15 25.3 -16.8 -7.1 -6.2 25.2 16.1 22.6 26.0 33.5

Solutions

Expert Solution

Arithmetic and Geometric mean returns have a relation in common between them, while arithmetic mean refers to the average returns of the stocks, geometric mean returns multiply the returns and find the nth root of those return.

Also, it is a proven fact that if the numbers are positive between them then the arithmetic mean is higher than geometric mean,

Let us suppose an example, consider two returns 5%, 10%

So Arithmetic Mean being average returns hence the values will be (5%+10%)/2 = 7.5%

Now with same values the geometric returns would be (5*10)^ (1/2) = 7.07% (approx)

So AM> GM (proved)


Related Solutions

Table 3 (below) shows annual returns for the S&P 500 for the years 2000-2016: Table 3:...
Table 3 (below) shows annual returns for the S&P 500 for the years 2000-2016: Table 3: Annual Returns Year Returns 2000 -9.0% 2001 -11.9% 2002 -22.0% 2003 28.4% 2004 10.7% 2005 4.8% 2006 15.6% 2007 5.5% 2008 -36.6% 2009 25.9% 2010 14.8% 2011 2.1% 2012 15.9% 2013 32.2% 2014 13.5% 2015 1.4% 2016 11.7% Calculate: The cumulative return over the 17 years; The average annual return; The standard deviation; The Sharpe Ratio (assuming a risk free rate of 2.3% on...
The following table shows the annual returns (in percent) and summary measures for a sample of...
The following table shows the annual returns (in percent) and summary measures for a sample of returns from the Vanguard Energy Fund and the Vanguard Health Care Fund from 2012 through 2016. Year Energy (%) Health Care (%) 2012 44.6 15.41 2013 19.68 10.87 2014 37 10.43 2015 -42.87 -18.45 2016 28.36 20.96 If the risk-free rate is 3%, using mean-variance analysis, which fund performed better, and why? a. The Energy Fund performed better, because its Sharpe Ratio was higher....
Question 3: (Minitab or Excel – Excel is easiest) The table below shows the average distance...
Question 3: (Minitab or Excel – Excel is easiest) The table below shows the average distance of each of the nine planets from the sun, and the length of the year (in earth years). Note that Pluto is not considered a planet anymore (check it out on Wikipedia). Number Position Distance from Sun (million miles) Length of Year in earth years Mercury 1 36 0.24 Venus 2 67 0.61 Earth 3 93 1 Mars 4 142 1.88 Jupiter 5 484...
The following table shows the past annual returns for Stock A and Stock B, please find...
The following table shows the past annual returns for Stock A and Stock B, please find the expected return, standard deviation and coefficient of variation for Stock A, Stock B and a Portfolio that puts 40% weight on Stock A and 60% weight on Stock B. Year Stock A Returns Stock B Returns 2005 10.30%    10.71% 2006 -0.10% 25.00% 2007 23.30% 0.38% 2008 2.20% 26.20% 2009 14.00% 11.52%
Answer the following problems in an Excel file. Please upload only one Excel file with all...
Answer the following problems in an Excel file. Please upload only one Excel file with all of your answers, including #3 (which requires an explanation rather than a calculation). All problems must be solved using the PV and FV functions in Excel. If I deposit $8,000 in a bank account that pays interest of 1.5%, compounded annually, how much will I have in the account after 10 years? If I deposit $8,000 in a bank account that pays simple interest...
The following table shows the annual returns over a six year period for the S&P 500...
The following table shows the annual returns over a six year period for the S&P 500 market index and MCH, Inc. Assume that the historical information represents a population. Use this data to calculate the correlation between both sets of security returns. Discuss your findings. Year S&P 500 MCH, Inc. 2013 0.15 0.37 2014 0.13 0.09 2015 0.14 -0.11 2016 -0.09 0.08 2017 0.12 0.11 2018 0.09 0.04 Please show me each step. Thank you
Table 2 shows regressions of the standard deviation and Sharpe ratio of household portfolio annual returns...
Table 2 shows regressions of the standard deviation and Sharpe ratio of household portfolio annual returns for different brackets of the distribution of net wealth in Sweden between 1999 and 2007 (standard errors are not reported). The reported Sharpe ratio of a household portfolio is equal to the expected return of the portfolio divided by its standard deviation. The Sharpe ratio is used to measure performance in relation to risk taken. For example, when comparing two portfolios, the one with...
The following table shows the annual returns over a six year period for the S&P 500...
The following table shows the annual returns over a six year period for the S&P 500 market index and MCH, Inc. Assume that the historical information represents a population. Use this data to calculate the correlation between both sets of security returns. Discuss your findings. Year S&P 500 MCH, Inc. 2013 0.15 0.37 2014 0.13 0.09 2015 0.14 -0.11 2016 -0.09 0.08 2017 0.12 0.11 2018 0.09 0.04
Table 2 shows regressions of the standard deviation and Sharpe ratio of household portfolio annual returns...
Table 2 shows regressions of the standard deviation and Sharpe ratio of household portfolio annual returns for different brackets of the distribution of net wealth in Sweden between 1999 and 2007 (standard errors are not reported). The reported Sharpe ratio of a household portfolio is equal to the expected return of the portfolio divided by its standard deviation. The Sharpe ratio is used to measure performance in relation to risk taken. For example, when comparing two portfolios, the one with...
Table below shows the historical returns for Companies A, B and C Year Company A Company...
Table below shows the historical returns for Companies A, B and C Year Company A Company B Company C 1 30% 26% 47% 2 7% 15% -54% 3 18% -14% 15% 4 -22% -15% 7% 5 -14% 2% -28% 6 10% -18% 40% 7 26% 42% 17% 8 -10% 30% -23% 9 -3% -32% -4% 10 38% 28% 75% 11 27.0% 23.4% 42.3% 12 6.3% 13.5% -48.6% 13 16.2% -12.6% 13.5% 14 -19.8% -13.5% 6.3% 15 -12.6% 1.8% -25.2% 16...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT