Portfolio Return and Risk Analysis
Not what you're looking for?
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.
1. Obtain the closing price, the change in price from the previous day, and the beta.
2. Calculate the return on holding the stock for a day (this should be the change in price over the closing price without the change).
3. Calculate a portfolio return with weights of 0.25 for each stock.
4. Calculate a weighted beta with weights of 0.25 for each stock.
5. Summarize the implications of the portfolio return and risk with respect to what you learned about the beta and the CAPM.
Use a Microsoft Excel spreadsheet that illustrates your calculations. You may use the formulas embedded in Microsoft Excel and/or a financial calculator for these calculations.
Purchase this Solution
Solution Summary
The following posting helps with problems involving portfolio return and risk analysis in an Excel spreadsheet.
Purchase this Solution
Free BrainMass Quizzes
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.