# CAPM regression

Not what you're looking for?

This needs to be done in Excel.

The CAPM states that the excess return on a stock is proportional to the excess return on the market. This implies:

X stock = beta*(X market)

Where X is the excess return = return- (return on risk free asset). One criticism of the CAPM regression we ran in class is that it excludes relevant variables. Some have argued that "surprise" factors impact excess return on stocks. You will explore this issue.

Choose two companies from the CAPM example we did in class. (CAPM - From Class.xls)

(1) Redo the CAPM regression

(2) The attached filed APM.xls contains data on POIL, FRBIND and CPI which are: price of oil, Federal Reserve Board Index of industrial production and Consumer price Index. Calculate the growth rate of these variables. For example:

Growth rate of CPI at t = (CPI at t-CPI at t-1)/CPI at t

Now calculate the "surprise" in these variables for each year. The surprise is calculated as growth rate minus sample mean

(3) Perform a regression of X stock on a constant, X market, and the three surprise variables.

(4) Analyze your results.

##### Purchase this Solution

##### Solution Summary

Regression Analysis-CAPM-is achieved step by step.

##### Solution Preview

(1) Redo the CAPM regression

<br>we pick up Coned and Delta for this question. As shown in the attached table, we have Xconed and Xciti and the regressions respectively. Because these two stocks both have significantly high t-value of the slope estimate.

<br>Then:

<br>Xdelta = 0.48*Xmkt , and

<br>Xciti = 0.67*Xmkt

<br>

<br>(2) The attached filed APM.xls contains data on POIL, FRBIND and CPI, which are: price of oil, Federal Reserve Board Index of industrial production and Consumer price Index. Calculate the growth rate of these variables. For example:

<br>Growth rate of CPI at t = (CPI at t-CPI at t-1)/CPI at t

<br>Now calculate the "surprise" in these variables for each year. The surprise is calculated as growth ...

##### Purchase this Solution

##### Free BrainMass Quizzes

##### Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

##### Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

##### Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

##### Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

##### Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.