Answered step by step
Verified Expert Solution
Question
1 Approved Answer
URGENT!!! These problems were solved through Excel. Please go through all the problems included above. Thank you! begin{tabular}{|c|c|c|c|c|c|} hline & Clos Price & Div &
URGENT!!! These problems were solved through Excel. Please go through all the problems included above. Thank you!
\begin{tabular}{|c|c|c|c|c|c|} \hline & Clos Price & Div & R & RR & Div Yield \\ \hline 2010 & $76.76 & $2.26 & & & \\ \hline 2009 & 62.44 & 2.05 & & & \\ \hline 2008 & 62.19 & 1.63 & & & \\ \hline 2007 & 57.27 & 1.50 & & & \\ \hline 2006 & 44.33 & 1.00 & & & \\ \hline 2005 & 33.72 & 0.67 & & & \\ \hline 2004 & 32.06 & 0.55 & & & \\ \hline 2003 & 24.83 & 0.40 & & & \\ \hline 2002 & 15.75 & 0.24 & & & \\ \hline 2001 & 26.60 & 0.23 & & & \\ \hline 2000 & 34.00 & & & & \\ \hline \end{tabular} 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 annual return on McDonald's stock for the years 2001-2003. 1. 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 at the close of business on December 31, 2010. 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 annual return did your money grow if you invested in this index at the start of the five years? n. Assume the information generated above is all the information you have about McDonald's return. What would be the best estimate of the return for McDonald's for 2011? What was the actual return? \begin{tabular}{|c|c|c|c|c|c|} \hline & Clos Price & Div & R & RR & Div Yield \\ \hline 2010 & $76.76 & $2.26 & & & \\ \hline 2009 & 62.44 & 2.05 & & & \\ \hline 2008 & 62.19 & 1.63 & & & \\ \hline 2007 & 57.27 & 1.50 & & & \\ \hline 2006 & 44.33 & 1.00 & & & \\ \hline 2005 & 33.72 & 0.67 & & & \\ \hline 2004 & 32.06 & 0.55 & & & \\ \hline 2003 & 24.83 & 0.40 & & & \\ \hline 2002 & 15.75 & 0.24 & & & \\ \hline 2001 & 26.60 & 0.23 & & & \\ \hline 2000 & 34.00 & & & & \\ \hline \end{tabular} 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 annual return on McDonald's stock for the years 2001-2003. 1. 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 at the close of business on December 31, 2010. 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 annual return did your money grow if you invested in this index at the start of the five years? n. Assume the information generated above is all the information you have about McDonald's return. What would be the best estimate of the return for McDonald's for 2011? What was the actual returnStep 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