Reference no: EM132425832

Assignment

Question 1. CAPM versus Fama and French 3-factor Model

A. CAPM
Select a company from the S&P 500 index. Download monthly adjusted closing prices from the Bloomberg Terminal for S&P 500 and the company over the period January 2007 -December 2017. For the same period download the monthly excess return on one-month T-bills from Professor Kenneth French's website

Once the data are obtained perform the following steps:

a) (i) Calculate the log returns and the excess return for S&P 500 and the company (You may wish to recreate the table headings below):

Monthly Returns                                                         Excess Returns
Date	S&P 500 Adj Close	Company Returns Adj Close	S&P 500 Returns	Company Returns	Risk Free Rate	S&P 500 returns            - Risk Free Rate	Company returns  - Risk-free  rate

(ii) Obtain beta by regressing the company's excess returns against those of S&P 500 (Include a table of your results).

(iii) Discuss your regression results and its implications on investing in the index as opposed to the company. Your discussion should include the effect of the financial crisis (November 2007 - May 2009).

b) (i) Create a graph of the Security Market line (SML);

(ii) What does the SML graph tell you about the mean-beta relationship?

B. FAMA AND FRENCH 3-FACTOR MODEL

Using all the previous data downloaded from Professor Kenneth French's website, perform the following steps:

a) (i) Merge the previously calculated company excess returns with the Fama and French factors (You may wish to recreate the table below). Then regress the company's excess returns against the Fama and French factors.

Date

Company - Risk Free Rate

Mkt-RF

SMB

HML

RF

(ii) Discuss your regression results and compare it to the CAPM results.

b) Using relevant literature, critically analyse the validity of CAPM and the Fama and French three factor model. Your discussion should include underlying assumptions, implications, and practical applications.

Attachment:- CAPM versus Fama and French 3-factor Model.rar