Purchase Solution

Portfolio analysis.

Not what you're looking for?

Ask Custom Question

Assume you had a portfolio with shares in each of five stocks. You had General Motors (GM), Walt Disney (DIS), Abercrombie and Fitch (ANF), Nova Med (NOVA), and Corning.

Collected in the Excel file:
Monthly price and dividend data using the dates October 2004 through October 2006 for each stock and the Russell 3000 market index. The adjusted closing price data was used to calculate the monthly returns for each stock and the index. Additionally, T-bill data and put it on a monthly basis to make it useable with the stock data were downloaded. This data is attached in the Excel spreadsheet.

1. In Excel:
a. For each stock, calculate the Sharpe, Treynor, and Jensen measures.
b. Indicate whether each stock beat the benchmark.
c. Which stock had the greatest percent unsystematic risk during the evaluation period and which had the least?

Reminder: Excel will assist in your calculations if you use tools, data analysis. If this does not appear as an option, you have to do an "add-in" for the analysis tool pak. Under data analysis, you can select descriptive statistics, summary statistics, for the means and standard deviation (return and risk). Select regression to find beta using each stock's returns and the appropriate market's return.

2. Write the equation for the ex-post CML.
3. Write the equation for the ex-post SML.
4. What was the fair expected return on Disney during that time frame?

Purchase this Solution

Solution Summary

The problem deals with calculating the Sharpe ratio, Treynor measure, and Jensen ratios for evaluating portfolios.

Furthermore the Security Market Line (SML) was described and calculated.

Solution provided by:
  • B. Sc., University of Nigeria
  • M. Sc., London South Bank University
Recent Feedback
  • "Thank you."
  • "thank you Chidi Ngene.. if you have any APA references would be great"
  • "Thank you so much for your help, your explanations were easy to understand and apply!"
  • "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
  • "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution

Free BrainMass Quizzes
Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.