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

Solution Posted by

studentlance

Rating : (5)F
Solution Detail
Price: \$10.00
• 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

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