Reference no: EM1357937
Question 1 Below is a list of 17 US companies across 8 industries. The data file provided to you contains monthly returns on the 17 company stocks beginning in January 1993. Time series of the risk free rate and returns on the market index are also provided in the data file.
Industry Company Code
Oil Mobil MOBIL
Texaco TEXACO
Computers IBM IBM
Digital Equip. Co. DEC
Data General DATGEN
Electric Utilities Consolidated Edison CONED
Pub Service of New Hamp. PSNH
Forest Products Weyerhauser WEYER
Boise BOISE
Electronic
Components Motorola MOTOR
Tandy TANDY
Airlines Pan American Airlines PANAM
Delta DELTA
Banks Continental Illinois CONTIL
Citicorp CITCRP
Foods Gerber GERBER
General Mills GENMIL
Choose one industry from the list that you think is relatively risky and another industry that is relatively safe. Choose two companies in the safe industry and two companies in the relatively riskier industry.
(a) Calculate the means and standard deviations of the returns of each of the four companies over the period. Do the risk-return patterns for these companies correspond with your prior expectations? Why or why not?
(b) Assume that you have $1m to invest. Construct 3 alternative portfolios as follows:
Portfolio 1: 50% in a company in the safe industry and 50% in a company in the risky industry. Portfolio 2: 50% in each of the 2 companies in the safe industry. Portfolio 3: 50% in each of the 2 companies in the risky industry. Calculate the sample correlation coefficient between the two companies in each of the 3 portfolios, comment on the size and interpretation of these correlations. For each of the 3 portfolios calculate the means and standard deviations of the returns over the period. Are there any surprises?
c) Distinguish between specific and market risk. Which of the 3 alternative portfolio diversifications would have been most justifiable in terms of reducing the specific risk of investment?
(d) Using regression analysis estimate the CAPM equation Rpi = Rf +Bpi (Rm-Rf)+ Ei for each of the 3 portfolios. Interpret the meaning of the Bpi value in each of the 3 portfolios. Are there any surprises ?
(e ) For portfolio 1, compare the R2 from the portfolio regression in part (d) with the R2 values from separate CAPM equation estimations for the 2 companies within portfolio Would you expect the R2 from the portfolio equations to be higher than that from the two individual equations? Why or why not?
(f) Using any sample of 10 stocks calculate the mean return and estimate the Bi for each stock. With these 10 means and 10 values of Bi, use regression analysis once again to estimate the equation of the Security Market Line (SML). Select any one of the remaining 7 stocks and determine whether it lies on the estimated SML. Assuming that the CAPM is a valid risk/return model, explain how you would exploit a situation where your chosen stock is temporarily lying either above or below the SML.
Attachment:- data.xls
|
Modeling effect and committing suicide
: She broght up the topic of media influences, How would you see the media as involved here? Because some young celebrities are in the news after attempting or committing suicide?
|
|
Show critical path method
: Critical path method - The Critical Path Method is a fundamental topic for all project managers to understand.
|
|
Joint cost allocation
: Elsie Dairy Products Corp. buys one input, full-cream milk, and refines it in a churning process. Allocate the $31,680 joint cost to the spreadable butter and the buttermilk using the following (show work):
|
|
Determine which project will you fund
: Suppose your hurdle rate is 15 percent. The first project is a seven year project with an expected IRR of 15.2% and the second project is a five year project with an IRR 15.3 percent.
|
|
Calculate the means and standard deviations of the returns
: Calculate the means and standard deviations of the returns of each of the four companies over the period. Do the risk-return patterns for these companies correspond with your prior expectations? Why or why not?
|
|
Googles four functions of management
: Explain how internal and external factors affect the four functions of management of the company Google.
|
|
Illustrate impact of the federal reserve bank
: Illustrate what do you think will be the impact of the federal reserve bank $600 billion purchase. Apply ALL of your knowledge on MONETARY POLICY to answer this question.
|
|
Valuation of land as an investment
: Julia currently is considering the purchase of some land to be held as an investment. She and the seller have agreed on a contract under which Julia would pay $1,000 per month for 60 months, or $60,000 total.
|
|
Skill of dialogue and leadership
: Identify its importance to change leadership and achieving shared understanding. Please provide a reference.
|