Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Compute the monthly returns for HAS stock and those of the S&P. The data is listed below for each. HAS Stock Date Open High Low
Compute the monthly returns for HAS stock and those of the S&P. The data is listed below for each.
HAS Stock
Date | Open | High | Low | Close | Adj Close | Volume |
2017-06-01 | 105.32 | 113.489998 | 104.910004 | 111.510002 | 96.878815 | 18823800 |
2017-07-01 | 112.089996 | 116.199997 | 103.68 | 105.879997 | 91.987541 | 21853000 |
2017-08-01 | 106.080002 | 106.800003 | 93.730003 | 98.25 | 85.81736 | 29495800 |
2017-09-01 | 98.449997 | 99.089996 | 91.57 | 97.669998 | 85.310768 | 28113900 |
2017-10-01 | 97.349998 | 98.93 | 88.660004 | 92.589996 | 80.873596 | 39225400 |
2017-11-01 | 92.900002 | 99.169998 | 87.919998 | 93.019997 | 81.737183 | 28472500 |
2017-12-01 | 92.639999 | 97.169998 | 90.029999 | 90.889999 | 79.865562 | 24062900 |
2018-01-01 | 91.559998 | 97.459999 | 88.300003 | 94.57 | 83.099182 | 33893000 |
2018-02-01 | 94.339996 | 103.389999 | 89.889999 | 95.57 | 84.488731 | 39670900 |
2018-03-01 | 96.059998 | 97.160004 | 83.559998 | 84.300003 | 74.525497 | 29977900 |
2018-04-01 | 83.970001 | 89.059998 | 79 | 88.089996 | 77.876045 | 40703000 |
2018-05-01 | 88 | 89.209999 | 85.309998 | 86.75 | 77.248505 | 20515700 |
2018-06-01 | 87.220001 | 93 | 86.279999 | 92.309998 | 82.199524 | 22295500 |
2018-07-01 | 91.75 | 107.580002 | 91.699997 | 99.610001 | 88.699982 | 39660300 |
2018-08-01 | 99.379997 | 102.519997 | 97.220001 | 99.309998 | 88.998055 | 15977000 |
2018-09-01 | 98.75 | 109.599998 | 98.650002 | 105.120003 | 94.20475 | 20561200 |
2018-10-01 | 106.110001 | 107.57 | 89.889999 | 91.709999 | 82.187195 | 39613800 |
2018-11-01 | 92.050003 | 100.849998 | 90.970001 | 91 | 82.114212 | 24238700 |
2018-12-01 | 91.470001 | 91.510002 | 76.839996 | 81.25 | 73.316246 | 27703400 |
2019-01-01 | 79.889999 | 91.540001 | 77.339996 | 90.559998 | 81.717171 | 23375400 |
2019-02-01 | 90.540001 | 93.190002 | 82.879997 | 84.900002 | 77.143631 | 34300600 |
2019-03-01 | 85.790001 | 90.040001 | 82.870003 | 85.019997 | 77.252655 | 19848400 |
2019-04-01 | 85.459999 | 103.599998 | 84.610001 | 101.860001 | 92.554176 | 29382000 |
2019-05-01 | 101.900002 | 105 | 95.099998 | 95.139999 | 87.029907 | 21764700 |
2019-06-01 | 95.209999 | 108.860001 | 94.580002 | 105.68 | 96.67144 | 17327300 |
2019-07-01 | 106.699997 | 126.870003 | 104.470001 | 121.160004 | 110.831848 | 24574900 |
2019-08-01 | 121.589996 | 122.190002 | 103.040001 | 110.470001 | 101.608627 | 21211200 |
2019-09-01 | 109.82 | 121.480003 | 108.089996 | 118.690002 | 109.16925 | 15384600 |
2019-10-01 | 118.949997 | 123.050003 | 94.190002 | 97.309998 | 89.50425 | 31959000 |
2019-11-01 | 97.790001 | 102.699997 | 92.589996 | 101.699997 | 94.187172 | 35831200 |
2019-12-01 | 102.599998 | 106.269997 | 98.07 | 105.610001 | 97.808334 | 20493100 |
2020-01-01 | 106.169998 | 106.25 | 100.620003 | 101.870003 | 94.344597 | 20827600 |
2020-02-01 | 102.690002 | 109.5 | 75.629997 | 77.25 | 72.012878 | 33799200 |
2020-03-01 | 77.32 | 80.120003 | 41.330002 | 71.550003 | 66.699318 | 52967900 |
2020-04-01 | 68.040001 | 80.489998 | 66.470001 | 72.209999 | 67.314583 | 32395300 |
2020-05-01 | 70.650002 | 74.959999 | 60.200001 | 73.510002 | 69.171577 | 22626300 |
2020-06-01 | 73.559998 | 83.989998 | 69.330002 | 74.949997 | 70.526588 | 25540300 |
2020-07-01 | 74.690002 | 80.800003 | 70.779999 | 72.760002 | 68.465851 | 23129800 |
2020-08-01 | 72.959999 | 82.080002 | 72.279999 | 78.940002 | 74.976654 | 13636800 |
2020-09-01 | 78.57 | 85.82 | 75.25 | 82.720001 | 78.566879 | 20357500 |
2020-10-01 | 82.989998 | 92.949997 | 80.239998 | 82.720001 | 78.566879 | 23669600 |
2020-11-01 | 83.529999 | 94.300003 | 82.010002 | 93.029999 | 89.081505 | 17257100 |
2020-12-01 | 94.339996 | 97.129997 | 87.519997 | 93.540001 | 89.569847 | 20843700 |
2021-01-01 | 93.739998 | 101.239998 | 90.389999 | 93.82 | 89.837975 | 15161100 |
2021-02-01 | 93.75 | 99.68 | 89.160004 | 93.709999 | 89.732643 | 20687900 |
2021-03-01 | 94.139999 | 99.489998 | 90.32 | 96.120003 | 92.712318 | 21142300 |
2021-04-01 | 96.25 | 100.510002 | 94.360001 | 99.449997 | 95.924263 | 19235300 |
2021-05-01 | 99.709999 | 101.099998 | 92.75 | 95.970001 | 93.207268 | 12839200 |
2021-06-01 | 96.5 | 97.639999 | 90.550003 | 94.519997 | 91.799011 | 14471400 |
2021-07-01 | 94.900002 | 104.889999 | 90.82 | 99.440002 | 96.577377 | 19174500 |
2021-08-01 | 100.07 | 101.599998 | 94.290001 | 98.309998 | 96.130409 | 11179500 |
2021-09-01 | 98.540001 | 100.949997 | 88.82 | 89.220001 | 87.241943 | 12414600 |
2021-10-01 | 89.279999 | 96.669998 | 86.050003 | 95.760002 | 93.636948 | 21783500 |
2021-11-01 | 95.879997 | 101.199997 | 92.07 | 96.910004 | 95.433311 | 14018700 |
2021-12-01 | 97.57 | 102.790001 | 95.099998 | 101.779999 | 100.229095 | 15703100 |
2022-01-01 | 102.220001 | 105.730003 | 85.970001 | 92.480003 | 91.070816 | 23010700 |
2022-02-01 | 92.75 | 105.129997 | 89.660004 | 97.050003 | 96.299011 | 27118900 |
2022-03-01 | 96.559998 | 97.550003 | 81.160004 | 81.919998 | 81.286079 | 31070000 |
2022-04-01 | 82.339996 | 92.519997 | 81.839996 | 88.059998 | 87.378571 | 26525300 |
2022-05-01 | 87.879997 | 94.220001 | 86.599998 | 86.760002 | 86.760002 | 14819400 |
S&P 500
Date | Open | High | Low | Close* | Adj Close** | Volume |
20-May-22 | 3,927.76 | 3,943.42 | 3,810.32 | 3,901.36 | 3,901.36 | 3,002,384,000 |
1-May-22 | 4,130.61 | 4,307.66 | 3,810.32 | 3,901.36 | 3,901.36 | 64,796,810,000 |
1-Apr-22 | 4,540.32 | 4,593.45 | 4,124.28 | 4,131.93 | 4,131.93 | 74,784,850,000 |
1-Mar-22 | 4,363.14 | 4,637.30 | 4,157.87 | 4,530.41 | 4,530.41 | 100,978,320,000 |
1-Feb-22 | 4,519.57 | 4,595.31 | 4,114.65 | 4,373.94 | 4,373.94 | 73,167,790,000 |
1-Jan-22 | 4,778.14 | 4,818.62 | 4,222.62 | 4,515.55 | 4,515.55 | 73,279,440,000 |
1-Dec-21 | 4,602.82 | 4,808.93 | 4,495.12 | 4,766.18 | 4,766.18 | 68,699,830,000 |
1-Nov-21 | 4,610.62 | 4,743.83 | 4,560.00 | 4,567.00 | 4,567.00 | 67,520,800,000 |
1-Oct-21 | 4,317.16 | 4,608.08 | 4,278.94 | 4,605.38 | 4,605.38 | 61,874,700,000 |
1-Sep-21 | 4,528.80 | 4,545.85 | 4,305.91 | 4,307.54 | 4,307.54 | 66,268,850,000 |
1-Aug-21 | 4,406.86 | 4,537.36 | 4,367.73 | 4,522.68 | 4,522.68 | 63,217,960,000 |
1-Jul-21 | 4,300.73 | 4,429.97 | 4,233.13 | 4,395.26 | 4,395.26 | 66,496,430,000 |
1-Jun-21 | 4,216.52 | 4,302.43 | 4,164.40 | 4,297.50 | 4,297.50 | 85,705,180,000 |
1-May-21 | 4,191.98 | 4,238.04 | 4,056.88 | 4,204.11 | 4,204.11 | 75,155,370,000 |
1-Apr-21 | 3,992.78 | 4,218.78 | 3,992.78 | 4,181.17 | 4,181.17 | 82,869,290,000 |
1-Mar-21 | 3,842.51 | 3,994.41 | 3,723.34 | 3,972.89 | 3,972.89 | 120,863,560,000 |
1-Feb-21 | 3,731.17 | 3,950.43 | 3,725.62 | 3,811.15 | 3,811.15 | 98,596,960,000 |
1-Jan-21 | 3,764.61 | 3,870.90 | 3,662.71 | 3,714.24 | 3,714.24 | 105,548,790,000 |
1-Dec-20 | 3,645.87 | 3,760.20 | 3,633.40 | 3,756.07 | 3,756.07 | 96,056,410,000 |
1-Nov-20 | 3,296.20 | 3,645.99 | 3,279.74 | 3,621.63 | 3,621.63 | 100,977,880,000 |
1-Oct-20 | 3,385.87 | 3,549.85 | 3,233.94 | 3,269.96 | 3,269.96 | 89,737,600,000 |
1-Sep-20 | 3,507.44 | 3,588.11 | 3,209.45 | 3,363.00 | 3,363.00 | 92,084,120,000 |
1-Aug-20 | 3,288.26 | 3,514.77 | 3,284.53 | 3,500.31 | 3,500.31 | 84,402,300,000 |
1-Jul-20 | 3,105.92 | 3,279.99 | 3,101.17 | 3,271.12 | 3,271.12 | 97,197,020,000 |
1-Jun-20 | 3,038.78 | 3,233.13 | 2,965.66 | 3,100.29 | 3,100.29 | 131,044,000,000 |
1-May-20 | 2,869.09 | 3,068.67 | 2,766.64 | 3,044.31 | 3,044.31 | 106,799,100,000 |
1-Apr-20 | 2,498.08 | 2,954.86 | 2,447.49 | 2,912.43 | 2,912.43 | 123,163,450,000 |
1-Mar-20 | 2,974.28 | 3,136.72 | 2,191.86 | 2,584.59 | 2,584.59 | 161,801,100,000 |
1-Feb-20 | 3,235.66 | 3,393.52 | 2,855.84 | 2,954.22 | 2,954.22 | 84,292,270,000 |
1-Jan-20 | 3,244.67 | 3,337.77 | 3,214.64 | 3,225.52 | 3,225.52 | 77,104,420,000 |
1-Dec-19 | 3,143.85 | 3,247.93 | 3,070.33 | 3,230.78 | 3,230.78 | 72,054,000,000 |
1-Nov-19 | 3,050.72 | 3,154.26 | 3,050.72 | 3,140.98 | 3,140.98 | 72,179,920,000 |
1-Oct-19 | 2,983.69 | 3,050.10 | 2,855.94 | 3,037.56 | 3,037.56 | 77,564,550,000 |
1-Sep-19 | 2,909.01 | 3,021.99 | 2,891.85 | 2,976.74 | 2,976.74 | 73,992,330,000 |
1-Aug-19 | 2,980.32 | 3,013.59 | 2,822.12 | 2,926.46 | 2,926.46 | 79,599,440,000 |
1-Jul-19 | 2,971.41 | 3,027.98 | 2,952.22 | 2,980.38 | 2,980.38 | 70,349,470,000 |
1-Jun-19 | 2,751.53 | 2,964.15 | 2,728.81 | 2,941.76 | 2,941.76 | 70,904,280,000 |
1-May-19 | 2,952.33 | 2,954.13 | 2,750.52 | 2,752.06 | 2,752.06 | 76,860,120,000 |
1-Apr-19 | 2,848.63 | 2,949.52 | 2,848.63 | 2,945.83 | 2,945.83 | 69,604,840,000 |
1-Mar-19 | 2,798.22 | 2,860.31 | 2,722.27 | 2,834.40 | 2,834.40 | 78,596,280,000 |
1-Feb-19 | 2,702.32 | 2,813.49 | 2,681.83 | 2,784.49 | 2,784.49 | 70,183,430,000 |
1-Jan-19 | 2,476.96 | 2,708.95 | 2,443.96 | 2,704.10 | 2,704.10 | 80,401,630,000 |
1-Dec-18 | 2,790.50 | 2,800.18 | 2,346.58 | 2,506.85 | 2,506.85 | 83,522,570,000 |
1-Nov-18 | 2,717.58 | 2,815.15 | 2,631.09 | 2,760.17 | 2,760.17 | 80,080,110,000 |
1-Oct-18 | 2,926.29 | 2,939.86 | 2,603.54 | 2,711.74 | 2,711.74 | 91,327,930,000 |
1-Sep-18 | 2,896.96 | 2,940.91 | 2,864.12 | 2,913.98 | 2,913.98 | 62,492,080,000 |
1-Aug-18 | 2,821.17 | 2,916.50 | 2,796.34 | 2,901.52 | 2,901.52 | 69,238,220,000 |
1-Jul-18 | 2,704.95 | 2,848.03 | 2,698.95 | 2,816.29 | 2,816.29 | 64,542,170,000 |
1-Jun-18 | 2,718.70 | 2,791.47 | 2,691.99 | 2,718.37 | 2,718.37 | 77,439,710,000 |
1-May-18 | 2,642.96 | 2,742.24 | 2,594.62 | 2,705.27 | 2,705.27 | 75,617,280,000 |
1-Apr-18 | 2,633.45 | 2,717.49 | 2,553.80 | 2,648.05 | 2,648.05 | 69,648,590,000 |
1-Mar-18 | 2,715.22 | 2,801.90 | 2,585.89 | 2,640.87 | 2,640.87 | 76,369,800,000 |
1-Feb-18 | 2,816.45 | 2,835.96 | 2,532.69 | 2,713.83 | 2,713.83 | 79,579,410,000 |
1-Jan-18 | 2,683.73 | 2,872.87 | 2,682.36 | 2,823.81 | 2,823.81 | 76,860,120,000 |
1-Dec-17 | 2,645.10 | 2,694.97 | 2,605.52 | 2,673.61 | 2,673.61 | 65,251,190,000 |
1-Nov-17 | 2,583.21 | 2,657.74 | 2,557.45 | 2,647.58 | 2,647.58 | 73,173,260,000 |
1-Oct-17 | 2,521.20 | 2,582.98 | 2,520.40 | 2,575.26 | 2,575.26 | 70,871,570,000 |
1-Sep-17 | 2,474.42 | 2,519.44 | 2,446.55 | 2,519.36 | 2,519.36 | 66,337,980,000 |
1-Aug-17 | 2,477.10 | 2,490.87 | 2,417.35 | 2,471.65 | 2,471.65 | 70,616,030,000 |
1-Jul-17 | 2,431.39 | 2,484.04 | 2,407.70 | 2,470.30 | 2,470.30 | 63,169,400,000 |
1-Jun-17 | 2,415.65 | 2,453.82 | 2,405.70 | 2,423.41 | 2,423.41 | 81,002,490,000 |
Please show how to compute in Excel. Thank you.
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