Question
1. Select 2 publicly trading companies with trading history of at least five years. 2. Get monthly return data for the two companies for at
1. Select 2 publicly trading companies with trading history of at least five years.
2. Get monthly return data for the two companies for at least five years (60 months). The returns should be based on adjusted prices and dividends, if any. Get latest five years.
3. Get market index return and Fama-French factors, monthly corresponding to the stocks returns. These are the Rm-Rf, SMB and HML factors. Make sure to match the companies returns and the FF factors in terms of time range.
4. Run regression of each stocks excess returns over the risk-free rate on the market index excess return, i.e., estimate SIM.
5. Run regression of each stocks excess returns on the three FF factors.
6. Test if the three-factor model explains stock returns better than the SIM.
a) compare the R-squares of SIM and 3-factor model.
b) compare the standard error of estimates.
c) conduct F-test. Calculate F-statistics for each stock by comparing SIM and 3-factor model regressions.
Where RRSS = residual (error) sum of squares under the SIM
URSS = residual (error) sum of squares under 3-factor model
N = number of observations
k = number of explanatory variables in 3-factor model (=4) including constant.
m = different in number of explanatory variables between SIM and 3-factor model (2).
Critical F can be obtained from F tables at (m, N-k) degrees of freedom. Critical F can also be obtained from MS Excel with the command =f.inv.rt(,m,N-k), where is the level of test such as 5%. Test if the F-stat is significant at 5% level of significance.
Write concluding statements about whether 3-factor model is better than SIM in explaining stock returns.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started