This preview shows page 1. Sign up to view the full content.
Unformatted text preview: UNIVERSITY OF NORTH CAROLINA
KENANFLAGLER BUSINESS SCHOOL
BUSI 580: INVESTMENTS
PART I: PORTFOLIO THEORY AND ASSET PRICING
Prof. Günter Strobl Spring 2010 Problem Set 1
For the following set of questions you will need to use the returns data contained in the
Excel spreadsheet PS1_data.xls. Please download this file from the course website. The
file contains monthly returns for three indexes (VW = valueweighted index of stocks
listed on the NYSE, AMEX, and NASDAQ including distributions, EW = equallyweighted index including distributions, S&P = S&P 500 index excluding dividends) and
onemonth riskfree rates (RF) over the period from January 1959 to December 2008.
You also need to obtain monthly holding period returns (including dividends) for the
following five stocks from CRSP for the same 50year period: General Motors (ticker:
GM), IBM, Merck (MRK), Coca Cola (KO), and Eastman Kodak (EK). You can access
the
CRSP
database
through
the
Wharton
Research
Data
Service
(http://wrds.wharton.upenn.edu/).
A. Empirical Properties of Stock Returns
1. Calculate the largest and smallest returns for each of the three indexes and five stocks
over the entire period. Did anything happen on or around these dates to explain such
extreme returns? Are these clustered in time? Why or why not?
2. Compute the mean returns and standard deviations of each of the indexes and
individual stocks over the entire period. Are any of the mean returns significantly
different from 1%? Can the returns be modeled as normally distributed random
variables?
3. Compute the correlation matrix for the indexes and individual stocks for the entire
sample. Which index is most highly correlated with the S&P 500 (VW or EW) and
why? Which of the five stock returns is most highly correlated with the S&P 500 and
why? Are the correlations among the five stocks unusual in any way or are they as
you expected them to be? Why or why not? 1 B. MeanVariance Portfolio Optimization
4. Using the entire sample of monthly returns on the 5 stocks in the data set, calculate
and plot the meanvariance efficient frontier in meanstandard deviation space. Plot
the position of each stock in meanstandard deviation space. 1
5. If you are restricted to invest in the 5 individual stocks, what is the minimum level of
risk you have to bear? How would the minimum variance portfolio look like if you
cannot sell stocks short?
6. Compute the optimal tangency portfolio using the average Tbill rate. Plot it on the
graph you created in (4). What is the Sharpe ratio of the optimal tangency portfolio?
7. Suppose your desired rate of return is 1.5% per month. Which portfolio (consisting of
the five stocks and Tbills) would you optimally choose? 1 Hint: There are several ways to determine the efficient frontier. Probably the easiest way is to use Excel’s
solver to minimize the variance at two possible values of expected portfolio returns. Then use the fact that
the entire efficient frontier can be constructed as a linear combination of any two frontier portfolios once
you know the coordinates of and covariance between these two portfolios. 2 ...
View
Full
Document
This note was uploaded on 04/06/2010 for the course BUSI 580 taught by Professor Strobl during the Fall '09 term at UNC.
 Fall '09
 Strobl

Click to edit the document details