McDonald's
		Closing Price	Dividend	Returns	Return Relative	Dividend Yield
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

Spreadsheet Exercise 15-1 Investments Analysis & Management - Chales P. Jones & Gerald R. Jensen 13th Edition

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

a. Calculate returns (Rs) and return relatives (RRs)for McDonalds's for the 10 years 2001-2010 using the data provided. Place Rs in Column E and RRs in Column F. Also, calculate the dividend by price for the previous year. R = CF₁ + (P_E- P_B ) / P_B RR = CF₁ + P_E / P_B = 1 + R

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 Jan 1, 2005, and held it to Dec 31, 2010, @ 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 Jan. 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 invetment 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 Jan. 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%, 2.5%, 4%, 5.2% and 3.1%

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?