Answered step by step
Verified Expert Solution
Link Copied!

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

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Students also viewed these Finance questions