Reference no: EM131907275

Fill in the spreadsheet below and answer the following questions. Calculate answers to three decimal places.

a. Calculate returns (Rs) and return relatives (RRs) for McDonald’s for the 10 years 2001–2010 using the data provided below. Place Rs in Column E and RRs in Column F. Also, calculate the dividend yield for each year using dividend for a given year divided by price for the previous year.

b. What was the dividend yield on McDonald’s for 2010, based on the closing price for 2009?

c. What was the arithmetic average dividend yield for this 10-year period? (Note: calculate the dividend yield for each year using the closing price for the previous year (2001 dividend and 2000 price, 2002 dividend and 2001 price, etc.) and then determine the 10-year arithmetic average).

d. Calculate the arithmetic mean and geometric mean R for McDonald’s for this 10-year period using Excel functions. State answers as a percentage.

e. Calculate the cumulative wealth for McDonald’s for this 10-year period, assuming:

i. $1,000 invested at the beginning of the 10 years ii. $10,000 invested at the beginning of the 10 years

f. The geometric mean return for the S&P 500 for this

10-year period was 1.014 percent. Calculate the cumulative wealth for the S&P 500 for this 10-year period, assuming $1 invested at the beginning.

g. i.Calculate the standard deviation of these 10 years of returns for McDonald’s using the Excel function STDEV. Note: for this calculation, you can use either Rs or RRs.

ii. Based on the information in Table 6-6, and assuming the risk information in this table applies to the 10-year period being considered here, is McDonald’s more risky than the S&P 500, or less risky?

h. What is the biggest single factor in explaining McDonald’s returns for 2001 and 2002?

i. For an investor who bought McDonald’s stock on January 1, 2005, and held it to December 31, 2010, at what compound annual average rate of return did this investment in the stock grow? State your answer as a compound annual average percentage rate of return.

j. Assume an investor invested $5,000 in McDonald’s stock on January 1, 2001, and held it for 20 years. Also assume that the geometric mean for these 20 years is the same as the geometric mean for the 10 years 2001–2010. Including the initial investment, how much money would the investor have at the end of the 20 years? In other words, what is the cumulative wealth from this investment given an initial investment of $5,000?

k. Calculate the compound annual average rate of return on McDonald’s stock for the years 2001–2003. State your answer as a compound annual average percent rate of return.

l. Assume you purchased 100 shares of McDonald’s stock on January 1, 2007, the year before the great financial crisis of 2008. Calculate the cumulative wealth of this position (which includes the starting amount) at the close of business on December 31, 2010. Ignore any brokerage costs.

m. Assume that over the next five years the returns on the S&P 500 are 6 percent, 2.5 percent, 4 percent, 5.2 percent, and 3.1 percent.

a. What will be the cumulative wealth per dollar invested in this index? b. At what compound annual rate of return did your money grow if you invested in this index at the start of the five years?

n. Assume that the information generated above is all the information you have about McDonald’s rate of return. What would be the best estimate of the return for McDonald’s for 2011? What was the actual return?

Clos Price  Div R RR DivY

2010 76.76 2.26

2009 62.44 2.05

2008 62.19 1.63

2007 57.27 1.5

2006 44.33 1

2005 33.72 0.67

2004 32.06 0.55

2003 24.83 0.4

2002 15.75 0.24

2001 26.6 0.23

2000 34