Answered step by step
Verified Expert Solution
Question
1 Approved Answer
S&P 500 (^GSPC) ZTS MAR Date Adj Close Date Adj Close Date Adj Close 2016-01-01 1,940.24 2016-01-01 41.50 2016-01-01 57.75 2016-02-01 1,932.23 2016-02-01 39.67 2016-02-01
S&P 500 (^GSPC) | ZTS | MAR | |||||
Date | Adj Close | Date | Adj Close | Date | Adj Close | ||
2016-01-01 | 1,940.24 | 2016-01-01 | 41.50 | 2016-01-01 | 57.75 | ||
2016-02-01 | 1,932.23 | 2016-02-01 | 39.67 | 2016-02-01 | 64.23 | ||
2016-03-01 | 2,059.74 | 2016-03-01 | 42.83 | 2016-03-01 | 67.34 | ||
2016-04-01 | 2,065.30 | 2016-04-01 | 45.44 | 2016-04-01 | 66.31 | ||
2016-05-01 | 2,096.95 | 2016-05-01 | 45.91 | 2016-05-01 | 62.47 | ||
2016-06-01 | 2,098.86 | 2016-06-01 | 45.95 | 2016-06-01 | 63.15 | ||
2016-07-01 | 2,173.60 | 2016-07-01 | 48.97 | 2016-07-01 | 68.13 | ||
2016-08-01 | 2,170.95 | 2016-08-01 | 49.58 | 2016-08-01 | 67.78 | ||
2016-09-01 | 2,168.27 | 2016-09-01 | 50.46 | 2016-09-01 | 63.98 | ||
2016-10-01 | 2,126.15 | 2016-10-01 | 46.38 | 2016-10-01 | 65.56 | ||
2016-11-01 | 2,198.81 | 2016-11-01 | 48.88 | 2016-11-01 | 75.18 | ||
2016-12-01 | 2,238.83 | 2016-12-01 | 52.04 | 2016-12-01 | 79.21 | ||
2017-01-01 | 2,278.87 | 2017-01-01 | 53.41 | 2017-01-01 | 81.05 | ||
2017-02-01 | 2,363.64 | 2017-02-01 | 51.93 | 2017-02-01 | 83.34 | ||
2017-03-01 | 2,362.72 | 2017-03-01 | 51.99 | 2017-03-01 | 90.54 | ||
2017-04-01 | 2,384.20 | 2017-04-01 | 54.66 | 2017-04-01 | 90.77 | ||
2017-05-01 | 2,411.80 | 2017-05-01 | 60.79 | 2017-05-01 | 103.49 | ||
2017-06-01 | 2,423.41 | 2017-06-01 | 60.88 | 2017-06-01 | 96.74 | ||
2017-07-01 | 2,470.30 | 2017-07-01 | 61.12 | 2017-07-01 | 100.48 | ||
2017-08-01 | 2,471.65 | 2017-08-01 | 61.30 | 2017-08-01 | 99.89 | ||
2017-09-01 | 2,519.36 | 2017-09-01 | 62.34 | 2017-09-01 | 106.69 | ||
2017-10-01 | 2,575.26 | 2017-10-01 | 62.40 | 2017-10-01 | 115.61 | ||
2017-11-01 | 2,647.58 | 2017-11-01 | 70.68 | 2017-11-01 | 122.89 | ||
2017-12-01 | 2,673.61 | 2017-12-01 | 70.54 | 2017-12-01 | 131.68 | ||
2018-01-01 | 2,823.81 | 2018-01-01 | 75.13 | 2018-01-01 | 142.94 | ||
2018-02-01 | 2,713.83 | 2018-02-01 | 79.31 | 2018-02-01 | 137.00 | ||
2018-03-01 | 2,640.87 | 2018-03-01 | 81.91 | 2018-03-01 | 132.23 | ||
2018-04-01 | 2,648.05 | 2018-04-01 | 81.88 | 2018-04-01 | 132.91 | ||
2018-05-01 | 2,705.27 | 2018-05-01 | 82.21 | 2018-05-01 | 131.63 | ||
2018-06-01 | 2,718.37 | 2018-06-01 | 83.68 | 2018-06-01 | 123.47 | ||
2018-07-01 | 2,816.29 | 2018-07-01 | 84.94 | 2018-07-01 | 124.68 | ||
2018-08-01 | 2,901.52 | 2018-08-01 | 89.12 | 2018-08-01 | 123.34 | ||
2018-09-01 | 2,913.98 | 2018-09-01 | 90.06 | 2018-09-01 | 129.19 | ||
2018-10-01 | 2,711.74 | 2018-10-01 | 88.68 | 2018-10-01 | 114.37 | ||
2018-11-01 | 2,760.17 | 2018-11-01 | 92.34 | 2018-11-01 | 112.55 | ||
2018-12-01 | 2,506.85 | 2018-12-01 | 84.26 | 2018-12-01 | 106.60 | ||
2019-01-01 | 2,704.10 | 2019-01-01 | 84.87 | 2019-01-01 | 112.46 | ||
2019-02-01 | 2,784.49 | 2019-02-01 | 93.00 | 2019-02-01 | 123.01 | ||
2019-03-01 | 2,834.40 | 2019-03-01 | 99.36 | 2019-03-01 | 123.23 | ||
2019-04-01 | 2,945.83 | 2019-04-01 | 100.51 | 2019-04-01 | 134.39 | ||
2019-05-01 | 2,752.06 | 2019-05-01 | 99.90 | 2019-05-01 | 122.98 | ||
2019-06-01 | 2,941.76 | 2019-06-01 | 112.20 | 2019-06-01 | 138.72 | ||
2019-07-01 | 2,980.38 | 2019-07-01 | 113.58 | 2019-07-01 | 137.51 | ||
2019-08-01 | 2,926.46 | 2019-08-01 | 125.16 | 2019-08-01 | 124.65 | ||
2019-09-01 | 2,976.74 | 2019-09-01 | 123.35 | 2019-09-01 | 123.43 | ||
2019-10-01 | 3,037.56 | 2019-10-01 | 126.64 | 2019-10-01 | 125.60 | ||
2019-11-01 | 3,140.98 | 2019-11-01 | 119.47 | 2019-11-01 | 139.30 | ||
2019-12-01 | 3,230.78 | 2019-12-01 | 131.20 | 2019-12-01 | 150.83 | ||
2020-01-01 | 3,225.52 | 2020-01-01 | 133.04 | 2020-01-01 | 139.50 | ||
2020-02-01 | 2,954.22 | 2020-02-01 | 132.26 | 2020-02-01 | 123.50 | ||
2020-03-01 | 2,584.59 | 2020-03-01 | 116.83 | 2020-03-01 | 74.81 | ||
2020-04-01 | 2,912.43 | 2020-04-01 | 128.37 | 2020-04-01 | 90.94 | ||
2020-05-01 | 3,044.31 | 2020-05-01 | 138.60 | 2020-05-01 | 88.50 | ||
2020-06-01 | 3,100.29 | 2020-06-01 | 136.26 | 2020-06-01 | 85.73 | ||
2020-07-01 | 3,271.12 | 2020-07-01 | 150.82 | 2020-07-01 | 83.83 | ||
2020-08-01 | 3,500.31 | 2020-08-01 | 159.41 | 2020-08-01 | 102.91 | ||
2020-09-01 | 3,363.00 | 2020-09-01 | 164.66 | 2020-09-01 | 92.58 | ||
2020-10-01 | 3,269.96 | 2020-10-01 | 157.87 | 2020-10-01 | 92.88 | ||
2020-11-01 | 3,621.63 | 2020-11-01 | 159.89 | 2020-11-01 | 126.87 | ||
2020-12-01 | 3,756.07 | 2020-12-01 | 165.00 | 2020-12-01 | 131.92 |
Calculate the MONTHLY return data for the 01/01/2016 12/31/2020 period for the selected three securities.
Note: Return for Month 2 = (Adj Close for Month 2/Adj Close for Month 1) 1
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