Problem 1. You are given the following longrun annual rates of return for alternative investment instruments:
• US Government TBills 3.5%
• Largecap common stocks 12.1%
• Longterm corporate bonds 6.2%
• Longterm government bonds 5.6%
• Smallcapitalization common stock 14.6%
The annual rate of inflation during the period was 2.9%. Compute the real rate of return on these investment alternatives.
Problem 2. The following are the monthly rates of return for TECO Electric and Gold Hill
Month

Nike

JNJ

1

0.06

0.08

2

0.03

0.01

3

0.05

0.02

4

0.09

0.11

5

0.02

0.04

6

0.03

0.06

Using an excel spreadsheet, compute the following:
a. Average monthly rate of return for each stock
b. Standard deviation of returns for each stock
c. Covariance between the rates of return
d. The correlation coefficient between the rates of return
Problem 3. Based on five years of monthly data, you derive the following information for the companies listed:
Company a_{i }(Intercept)

σ_{i}

r_{im}

Johnson and Johnson

0.09

14.4

0.41

Exxon Mobil

0.15

7.4

0.53

Pfizer

0.07

10.3

0.67

Microsoft

0.21

12

0.70

S&P 500

0

5.4

1

a. Compute the beta coefficient for each stock
b. Assuming a risk free rate of 5 percent and an expected return for the market portfolio of 12 percent, compute the expected (required) return for all the stocks.
c. Plot the following estimated returns for the next year on the SML and indicate which stocks are undervalued or overvalued.
• Johnson and Johnson—15%
• Exxon Mobil—10%
• Pfizer—13%
• Microsoft—20%
Problem 4. The following are the historic returns for the Columbia Sportswear Company (COLM) and the General Index:
Year COLM INdex
1 34% 14%
2 9% 12%
3 10% 13%
4 7% 8%
5 9% 11%
6 3% 6%
Based on this information, and using an excel software, compute the following:
a. The correlation coefficient between COLM and the General Index.
b. The standard deviation for the company and the Index
c. The beta for the COLM.