a file which contains 2 different sheets and please do it carefully The CAPM is an important model in the field of finance. It explains variations in the rate of return on a security as a function of the rate of return on a portfolio consisting of all publicly traded stocks, which is called the market portfolio. Generally the rate of return on any investment is measured relative to its opportunity cost, which is the return on a risk free asset. The resulting difference is called the risk premium, since it is the reward or punishment for making a risky investment. The CAPM says that the risk premium on security j is proportional to the risk premium on the market portfolio. That is rj −rf ＝βj(rm −rf), (0.1) where rj and rf are the returns to security j and the risk-free rate, respectively, rm is the return on the market portfolio, and βj is the jth security’s ”beta” value. A stock’s beta is important to investors since it reveals the stock’s volatility. It measures the sensitivity of security j’s return to variation in the whole stock market. As such, values of beta less than 1 indicate that the stock is “defensive” since its variation is less than the market’s. A beta greater than 1 indicates an ”aggressive stock.” Investors usually want an estimate of a stock’s beta before purchasing it. The CAPM model shown above is the ”economic model” in this case. The ”econometric model” is obtained by including an intercept in the model (even though theory says it should be zero) and an error term rj −rf ＝αj +βj(rm −rf)+e, (0.2) Questions 1. Explain why the econometric model in equation 0.2 is a simple regression model. 2. In the data file Case1-data.xlsx are data on the monthly returns of seven firms (Apple, Amazon, Chevron, Disney, GE, Microsoft, and Mobil-Exxon), the rate of return on the market portfolio (MKT), and the rate of return on the risk free asset (RISKFREE). The 120 observations cover July 1998 to June 2008. Estimate the CAPM model for each firm, and comment on their estimated beta values. Which firm appears most aggressive ? Which firm appears most defensive ? 3. Finance theory says that the intercept parameter αj should be zero. Does this seem correct given your estimates ? For the Microsoft stock, plot the fitted regression line along with the data scatter. 4. Estimate the model for each firm under the assumption that αj ＝ 0. Do the estimates of the beta values change much ?
