Purchase Solution

# Index Models for IBM and GE returns

Not what you're looking for?

See attached data file.

3. Regress excess IBM returns on the excess S&P 500 index returns and report ?, ?, the r-square and whether ? and ? are different from zero at the 5% level of significance. Explain your inference.
4. Use equation 8.10 to decompose total risk for IBM into systematic risk and firm-specific risk. That is, calculate total risk, systematic risk and firm-specific risk for IBM.
5. Regress excess GE returns on the excess S&P 500 index returns and report ?, ?, the r-square and whether ?, ? are different from zero at the 5% level of significance.
6. Use equation 8.10 to decompose total risk for GE into systematic risk and firm-specific risk. That is, calculate total risk, systematic risk and firm-specific risk for GE.
7. Use equation 8.10 to estimate the covariance and correlation of GE and IBM excess returns.

##### Solution Summary

The following post helps answer questions regarding index models for IBM and GE returns. Step by step calculation are given for each.

##### Solution Preview

Please see the attachments for proper format and formulas.

3. Regress excess IBM returns on the excess S&P 500 index returns and report Ã±, Ã², the r-square and whether Ã± and Ã² are different from zero at the 5% level of significance. Explain your inference.
We need to first create a variable "GSPC Excess Return" that measures the excess S&P 500 index returns.

Please refer to the attached EXCEL file: spreadsheet â??Q3â? for regression results.
The r-square is 0.3638.

The intercept is ?. Since its p-value is 0.028075 which is lower than the 5% level of significance, it is significantly different from zero.

The coefficient of the excess S&P 500 index returns is ?=0.6258. Since its p-value is 3.38E-07 which is lower than the 5% level of significance, it is significantly different ...

##### Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

##### Motivation

This tests some key elements of major motivation theories.

##### MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

##### Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

##### Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce