Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use data from Data for Assignment 12 file and Calculate monthly returns for SP500, JPMorgan Chase & Co., Bank of America Corporation, Wells Fargo &

Use data from Data for Assignment 12 file and

Calculate monthly returns for SP500, JPMorgan Chase & Co., Bank of America Corporation, Wells Fargo & Company, and Citigroup Inc.

Estimate a regression line using returns of JPMorgan Chase & Co. as dependent variable and returns of SP500, Bank of America Corporation, Wells Fargo & Company, and Citigroup Inc.as independent variables.

Interpret the estimated coefficients of your regression line and discuss their finance implications, in writing, in 6 lines in a Word file.

Date JPM BAC WFC C SP500
1/2/2014 51.32 16.24 41.96 46.98 2063.36
2/3/2014 52.67 16.02 43.25 48.17 2080.41
3/3/2014 56.28 16.68 46.34 47.15 2079.36
4/1/2014 52.22 14.68 46.25 47.46 1920.03
5/1/2014 51.84 14.68 47.65 47.13 1972.18
6/2/2014 53.75 14.92 49.32 46.67 2103.84
7/1/2014 54.18 14.8 47.76 48.47 2063.11
8/1/2014 55.85 15.61 48.61 51.19 2107.39
9/2/2014 56.59 16.6 49.02 51.35 2085.51
10/1/2014 57.2 16.7 50.17 53.06 2067.89
11/3/2014 56.89 16.59 51.82 53.5 2104.5
12/1/2014 59.18 17.47 52.15 53.63 1994.99
1/2/2015 51.76 14.79 49.39 46.55 2058.9
2/2/2015 58.33 15.44 52.46 51.97 2067.56
3/2/2015 57.66 15.07 52.09 51.08 2018.05
4/1/2015 60.61 15.6 52.76 52.86 1972.29
5/1/2015 63.03 16.16 53.94 53.67 2003.37
6/1/2015 64.92 16.72 54.21 54.82 1930.67
7/1/2015 66.09 17.56 55.79 58.06 1960.23
8/3/2015 61.82 16.05 51.74 53.12 1923.57
9/1/2015 58.8 15.35 49.82 49.27 1883.95
10/1/2015 62.41 16.54 52.53 52.86 1872.34
11/2/2015 64.77 17.18 53.83 53.77 1859.45
12/1/2015 64.68 16.85 53.62 51.99 1782.59
JPMorgan Chase & Co. (JPM)
Bank of America Corporation (BAC)
Wells Fargo & Company (WFC)
Citigroup Inc. (C)
S&P 500

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions

Question

=+6. What five driving forces make CSR more relevant today?

Answered: 1 week ago