Answered step by step
Verified Expert Solution
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
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