FIN550: (See Attachment for copy of the below questions)

For homework submissions, I require that all work be completed in Excel, which means that you will use the Excel functions to arrive at the answer. I should be able to click on the cell that holds your answer, and see the formula you used to arrive at this answer in the function ribbon. I will not accept answers that were simply re-typed into the Excel workbook.

Chapter 8

Problem 6

The following are the historic returns for the Chelle Computer Company:

Year		Chelle Computer		General Index
1	37	15
2	9	13
3	-11	14
4	8	-9
5	11	12
6	4	9

Based on this information, compute the following:

a. The correlation coefficient between Chelle Computer and the General Index.

b. The standard deviation for the company and the index.

c. The beta for the Chelle Computer Company.

Problem 8.

As an equity analyst, you have developed the following return forecasts and risk estimates for two different stock mutual funds ( Fund T and Fund U):

	Forecasted Return		CAPM Beta
Fund T	9.0%	1.20
Fund U	10.0%	0.80

a. If the risk- free rate is 3.9 percent and the expected market risk premium ( i. e., E( RM) - RFR) is 6.1 percent, calculate the expected return for each mutual fund according to the CAPM.

b. Using the estimated expected returns from Part a along with your own return forecasts, demonstrate whether Fund T and Fund U are currently priced to fall directly on the security market line ( SML), above the SML, or below the SML.

c. According to your analysis, are Funds T and U overvalued, undervalued, or properly valued?

Problem 10.

Draw the security market line for each of the following conditions:

a. ( 1) RFR = 0.08; RM( proxy) = 0.12 ( 2) Rz = 0.06; RM( true) = 0.15

b. Rader Tire has the following results for the last six periods. Calculate and compare the betas using each index.

Rates Of Return

RATES OF RETURN
Rader Tire	Proxy Specific Index	True General Index
Period		(%)			(%)				(%)
1	29	12	15
2	12	10	13
3	-12	-9	-8
4	17	14	18
5	20	25	28
6	-5	-10	0

c. If the current period return for the market is 12 percent and for Rader Tire it is 11 percent, are superior results being obtained for either index beta?

Chapter 9

Problem 3.

You have been assigned the task of estimating the expected returns for three different stocks: QRS, TUV, and WXY. Your preliminary analysis has established the historical risk premiums associated with three risk factors that could potentially be included in your calculations: the excess return on a proxy for the market portfolio ( MKT), and two variables capturing general macroeconomic exposures ( MACRO1 and MACRO2). These values are: .MKT = 7.5%, .MACRO1 = - 0.3%, and .MACRO2 = 0.6%. You have also estimated the following factor betas ( i. e., loadings) for all three stocks with respect to each of these potential risk factors:

FACTOR LOADING
Stock		MKT		MACRO1		MACRO2
QRS	1.24	-0.42	0.00
TUV	0.91	0.54	0.23
WXY	1.03	-0.09	0.00

a. Calculate expected returns for the three stocks using just the MKT risk factor. Assume a risk- free rate of 4.5%.

b. Calculate the expected returns for the three stocks using all three risk factors and the same 4.5% risk- free rate.

c. Discuss the differences between the expected return estimates from the single- factor model and those from the multifactor model. Which estimates are most likely to be more useful in practice?

d. What sort of exposure might MACRO2 represent? Given the estimated factor betas, is it really reasonable to consider it a common ( i. e., systematic) risk factor?

PROBLEM 5.

Suppose that three stocks ( A, B, and C) and two common risk factors ( 1 and 2) have the following relationship:

E(RA) = (1.1) 1 + (0.8) 2

E(RB) = (0.7) 1 + (0.6) 2

E(RC) = (0.3) 1 + (0.4) 2

a. If 1 = 4% and 2 = 2%, what are the prices expected next year for each of the stocks? Assume that all three stocks currently sell for $ 30 and will not pay a dividend in the next year.

b. Suppose that you know that next year the prices for Stocks A, B, and C will actually be $ 31.50, $ 35.00, and $ 30.50. Create and demonstrate a riskless, arbitrage investment to take advantage of these mispriced securities. What is the profit from your investment? You may assume that you can use the proceeds from any necessary short sale.

PROBLEM 7.

a. Using regression analysis, calculate the factor betas of each stock associated with each of the common risk factors. Which of these coefficients are statistically significant?

b. How well does the factor model explain the variation in portfolio returns? On what basis can you make an evaluation of this nature?

c. Suppose you are now told that the three factors in Exhibit 9.12 represent the risk exposures in the Fama- French characteristic- based model ( i. e., excess market, SMB, and HML). Based on your regression results, which one of these factors is the most likely to be the market factor? Explain why.

d. Suppose it is further revealed that Factor 3 is the HML factor. Which of the two portfolios is most likely to be a growth- oriented fund and which is a value- oriented fund? Explain why.