Impact of Beta on Portfolio (Four Company) Excel Work - 20715

Solution Posted by
studentlance

studentlance

Rating : (5)F
Solution Detail
Price: $10.00
  • From: Business, Marketing
  • Posted on: Tue 30 Jul, 2013
  • Request id: None
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description

Impact of Beta on Portfolio (Four Company) Excel Work

Week six, assignment

This assignment needs to consist of a portfolio analysis in a Microsoft Word 
document that is not to exceed three pages. You must also include your portfolio
 
analysis in either Word or Excel. You must show how you calculated the
 
answers.

  1. Select four stocks from finance.yahoo.com, google.finance.com, or 
    moneycentral.msn.com. One should be a clothing manufacturer, one should be a
     
    retailer, one should be an automobile manufacturer, and one should be a
     
    restaurant or food producer.
  2. Obtain the closing price, the change in price from the previous day, and the 
    beta.
  3. Calculate the return on holding the stock for a day (this should be the 
    change in price over the closing price without the change).
  4. Calculate a portfolio return with weights of 0.25 for each stock.
  5. Calculate a weighted beta with weights of 0.25 for each stock.
  6. Write up the implications of the portfolio return and risk with respect to 
    what you learned about beta and the CAPM in 2-3 pages.

 

 

Solution Description

Return:

Attachments
Impact of Beta on Portfolio (Four Company) Excel Work.zip
Impact of Beta ...