Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
2012-06-01 5.41 5.51 5.38 5.51 5.51 0 2012-07-01 5.52 5.56 5.52 5.56 5.56 0 2012-08-01 5.57 5.59 5.57 5.59 5.59 0 2012-09-01 5.6 5.69 5.6
| 2012-06-01 | 5.41 | 5.51 | 5.38 | 5.51 | 5.51 | 0 |
| 2012-07-01 | 5.52 | 5.56 | 5.52 | 5.56 | 5.56 | 0 |
| 2012-08-01 | 5.57 | 5.59 | 5.57 | 5.59 | 5.59 | 0 |
| 2012-09-01 | 5.6 | 5.69 | 5.6 | 5.64 | 5.64 | 0 |
| 2012-10-01 | 5.65 | 5.69 | 5.65 | 5.65 | 5.65 | 0 |
| 2012-11-01 | 5.65 | 5.66 | 5.59 | 5.66 | 5.66 | 0 |
| 2012-12-01 | 5.66 | 5.72 | 5.66 | 5.71 | 5.71 | 0 |
| 2013-01-01 | 5.73 | 5.79 | 5.73 | 5.75 | 5.75 | 0 |
| 2013-02-01 | 5.75 | 5.75 | 5.73 | 5.75 | 5.75 | 0 |
| 2013-03-01 | 5.75 | 5.78 | 5.75 | 5.77 | 5.77 | 0 |
| 2013-04-01 | 5.77 | 5.85 | 5.77 | 5.85 | 5.85 | 0 |
| 2013-05-01 | 5.86 | 5.89 | 5.78 | 5.78 | 5.78 | 0 |
| 2013-06-01 | 5.75 | 5.75 | 5.55 | 5.6 | 5.6 | 0 |
| 2013-07-01 | 5.61 | 5.73 | 5.59 | 5.67 | 5.67 | 0 |
| 2013-08-01 | 5.67 | 5.67 | 5.59 | 5.6 | 5.6 | 0 |
| 2013-09-01 | 5.61 | 5.67 | 5.59 | 5.63 | 5.63 | 0 |
| 2013-10-01 | 5.64 | 5.74 | 5.64 | 5.74 | 5.74 | 0 |
| 2013-11-01 | 5.73 | 5.73 | 5.69 | 5.73 | 5.73 | 0 |
| 2013-12-01 | 5.73 | 5.73 | 5.72 | 5.73 | 5.73 | 0 |
| 2014-01-01 | 5.74 | 5.77 | 5.73 | 5.73 | 5.73 | 0 |
| 2014-02-01 | 5.73 | 5.82 | 5.72 | 5.82 | 5.82 | 0 |
| 2014-03-01 | 5.81 | 5.82 | 5.78 | 5.8 | 5.8 | 0 |
| 2014-04-01 | 5.8 | 5.81 | 5.8 | 5.8 | 5.8 | 0 |
| 2014-05-01 | 5.81 | 5.83 | 5.8 | 5.83 | 5.83 | 0 |
| 2014-06-01 | 5.83 | 5.87 | 5.83 | 5.85 | 5.85 | 0 |
| 2014-07-01 | 5.86 | 5.86 | 5.74 | 5.74 | 5.74 | 0 |
| 2014-08-01 | 5.7 | 5.8 | 5.7 | 5.8 | 5.8 | 0 |
| 2014-09-01 | 5.8 | 5.8 | 5.63 | 5.65 | 5.65 | 0 |
| 2014-10-01 | 5.66 | 5.69 | 5.56 | 5.69 | 5.69 | 0 |
| 2014-11-01 | 5.69 | 5.69 | 5.62 | 5.64 | 5.64 | 0 |
| 2014-12-01 | 5.6 | 5.6 | 5.39 | 5.53 | 5.53 | 0 |
| 2015-01-01 | 5.53 | 5.53 | 5.48 | 5.51 | 5.51 | 0 |
| 2015-02-01 | 5.51 | 5.62 | 5.51 | 5.62 | 5.62 | 0 |
| 2015-03-01 | 5.62 | 5.62 | 5.54 | 5.58 | 5.58 | 0 |
| 2015-04-01 | 5.58 | 5.62 | 5.58 | 5.61 | 5.61 | 0 |
| 2015-05-01 | 5.61 | 5.61 | 5.58 | 5.6 | 5.6 | 0 |
| 2015-06-01 | 5.6 | 5.6 | 5.5 | 5.5 | 5.5 | 0 |
| 2015-07-01 | 5.51 | 5.52 | 5.43 | 5.47 | 5.47 | 0 |
| 2015-08-01 | 5.47 | 5.47 | 5.36 | 5.38 | 5.38 | 0 |
| 2015-09-01 | 5.37 | 5.41 | 5.23 | 5.23 | 5.23 | 0 |
| 2015-10-01 | 5.22 | 5.34 | 5.2 | 5.33 | 5.33 | 0 |
| 2015-11-01 | 5.34 | 5.34 | 5.2 | 5.21 | 5.21 | 0 |
| 2015-12-01 | 5.21 | 5.21 | 4.98 | 5.05 | 5.05 | 0 |
| 2016-01-01 | 5.02 | 5.04 | 4.83 | 4.94 | 4.94 | 0 |
| 2016-02-01 | 4.93 | 4.94 | 4.77 | 4.94 | 4.94 | 0 |
| 2016-03-01 | 4.98 | 5.15 | 4.98 | 5.13 | 5.13 | 0 |
| 2016-04-01 | 5.13 | 5.27 | 5.12 | 5.26 | 5.26 | 0 |
| 2016-05-01 | 5.26 | 5.26 | 5.21 | 5.26 | 5.26 | 0 |
| 2016-06-01 | 5.25 | 5.31 | 5.2 | 5.27 | 5.27 | 0 |
| 2016-07-01 | 5.28 | 5.41 | 5.28 | 5.38 | 5.38 | 0 |
| 2016-08-01 | 5.38 | 5.45 | 5.36 | 5.45 | 5.45 | 0 |
| 2016-09-01 | 5.45 | 5.46 | 5.39 | 5.46 | 5.46 | 0 |
| 2016-10-01 | 5.46 | 5.5 | 5.44 | 5.44 | 5.44 | 0 |
| 2016-11-01 | 5.41 | 5.41 | 5.31 | 5.37 | 5.37 | 0 |
| 2016-12-01 | 5.37 | 5.45 | 5.37 | 5.43 | 5.43 | 0 |
| 2017-01-01 | 5.46 | 5.51 | 5.46 | 5.5 | 5.5 | 0 |
| 2017-02-01 | 5.51 | 5.57 | 5.51 | 5.57 | 5.57 | 0 |
| 2017-03-01 | 5.58 | 5.58 | 5.45 | 5.52 | 5.52 | 0 |
| 2017-04-01 | 5.52 | 5.55 | 5.51 | 5.55 | 5.55 | 0 |
| 2017-05-01 | 5.55 | 5.56 | 5.55 | 5.55 | 5.55 | 0
|
1.Compute monthly returns using the data in Adj Close(Excel) please be specific
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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