Reset Password

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form

Register

Bids

1

Project-Budget

$30- $100

Active

finance

Project Description:

 Download monthly data on prices and dividends from finance.yahoo.com from January 1 2011 to January 1 2013 for McDonald’s Corporation (NYSE:MCD) and Yum! Brands, Inc. (NYSE:YUM), for the period. Assume that you trade at the close price and that all dividends are only available to you on the first trading day of the month after they are “paid”. For instance, the dividend paid on July 11, 2012 is not available to you until the first trading day in August 2012.
(a) Calculate the monthly return on each stock for each month in 2011 and 2012. (b) Using these returns, calculate the following: i. The expected monthly return on each stock ii. The variance of the monthly return on each stock iii. The standard deviation of the monthly return on each stock iv. The covariance between the two stocks v. The correlation between the two stocks (c) Given your calculations of expected return, variance, and covariance above, calculate the expected return and the standard deviation of return for the following portfolios of MCD and YUM. Please do this question without first calculating each portfolio return in each month. Rather, use the formulas for expected return and variance of return of a portfolio given the statistics of the individual assets.
Weight in MCD Weight in YUM -1 2 0 1 0.25 0.75 0.5 0.5 0.75 0.25 1 0 2 -1 (d) Plot the expected return of these portfolios as a function of their standard deviation. In Excel, use an X-Y or Scatter plot, and put Expected Return (the 7 values calculated above) on the Y axis and Standard Deviation on the X-axis.
1
(e) Using the return data for IBM I calculated in class, which is posted on Blackboard, find the expected return and the variance of return on IBM. Also find the correlation and the covariance of return between IBM and MCD and, separately, IBM and YUM. Are these correlations lower or higher than the correlation of YUM and MCD? Does this agree with your intuition? (f) Consider the portfolio which has equal weights in MCD and YUM. Think of this portfolio as just another asset, and call it MY (for MCD and YUM). Find the covariance and correlation of this portfolio with IBM. To do this, first find the return on this portfolio in each of the 24 months. (g) Given your calculations of expected return, variance, and covariance above, calculate the expected return and the standard deviation of return for portfolios of the following two assets: (1) IBM stock (2) Asset MY. Please do this question without first calculating each portfolio return in each month. Rather, use the formulas for expected return and variance of return of a portfolio given the statistics for IBM and MY.
Weight in IBM Weight in asset MY -1 2 0 1 0.25 0.75 0.5 0.5 0.75 0.25 1 0 2 -1 (h) Plot the expected return of these portfolios as a function of their standard deviation. In Excel, use an X-Y or Scatter plot, and put Expected Return (the 7 values calculated above) on the Y axis and Standard Deviation on the X-axis. (i) You are a financial advisor with a client who wants to invest in one of two assets (a) A portfolio of MCD and YUM or (b) a portfolio of IBM and asset MY. What advice would you give this client? Remember that option (a) has many possible portfolios, as does option (b). In your analysis, you do not have to give a definite recommendation: you don’t need to say: “I pick this portfolio as being best for you”, but you could, for example, talk about which portfolios the client should avoid.

Files Attached:

About student:

0 rating(0 Reviews)

Tutors Bidding

Ratings

Bid Price

(109 reviews)

$110