Compute real rate of return on investment alternative

Problem 1.  You are given the following long-run annual rates of return for alternative investment instruments:

•    US Government T-Bills                         3.5%
•    Large-cap common stocks                   12.1%
•    Long-term corporate bonds                   6.2%
•    Long-term government bonds                5.6%
•    Small-capitalization 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                   ai (Intercept) σi rim 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.

#### Solution Preview :

##### Reference No:- TGS02018207

Now Priced at \$25 (50% Discount)

Recommended (95%)

Rated (4.7/5)