3. In what month was the largest negative monthly return for the company in the past five years?

March 2020

February 2020

October 2023

November 2019

4. What is the most recent month that the company return moved in the opposite direction of the S&P 500 return?

July 2023

December 2023

May 2023

May 2019

5. What was the largest positive monthly return over the last five years for the S&P 500?

April 2020

March 2020

October 2023

October 2022

6. Based on the line graph with your company returns and S&P 500 returns, does it appear that the company is _____ than the market?

far more risky

about the same risk

less risky

No answer text provided.

7. In October of 2022, did the company overperform of underperform when compared to the market.

Overperform

Underperform

Same Performance

8. What is the MONTHLY Variance of company (in decimal format, answering to 4 decimals, so 0.1234 for example)?

9. What is the MONTHLY Standard Deviation of the company (in decimal format, answering to 4 decimals, so 0.1234 for example)?

10. Thinking back to the pandemic (March of 2020), did the market overperform or underperform compared to it's expected monthly return?

Overperform

Underperform

Same Performance

This spreadsheet calculates the Expected Returns, Variances, and Standard Deviations of 2 Return Series. Page down to bottom for results Distance Distance Market Company from Mean Variance(M) from Mean Variance (C) Date Returns Returns (R E( R )) (R - E/R ) R. - E/R.)) R. - ER.) Dec-23 0.04391 0.03772 0.03172 0.00101 0.02605 0.00068 Nov-23 0.08918 0.07503 0.07699 0.00593 0.06335 0.00401 Oct-23 -0.02198 -0.00482 -0.03416 0.00117 -0.01650 0.00027 Sep-23 -0.04872 -0.05795 -0.06090 0.00371 -0.06963 0.00485 Aug-23 -0.01772 -0.04110 -0.02990 0.00089 -0.05278 0.00279 Jul-23 0.03114 -0.01224 0.01895 0.00036 -0.02392 0.00057 Jun-23 0.06473 0.04665 0.05254 0.00276 0.03497 0.00122 May-23 0.00248 -0.03598 -0.00970 0.00009 -0.04765 0.00227 Apr-23 0.01464 0.05772 0.00246 0.00001 0.04604 0.00212 Mar-23 0.03505 0.06561 0.02287 0.00052 0.05393 0.00291 Feb-23 -0.02611 -0.01305 -0.03830 0.00147 -0.02473 0.00061 Jan-23 0.06175 0.01469 0.04957 0.00246 0.00301 0.00001 Dec-22 -0.05897 -0.02850 -0.07116 0.00506 0.04018 0.00161 Nov-22 0.05375 0.00048 0.04157 0.00173 -0.01120 0.00013 Oct-22 0.07986 0.18168 0.06768 0.00458 0.17000 0.02890 Sep-22 -0.09340 -0.08037 -0.10558 0.01115 -0.09205 0.00847 Aug-22 -0.04244 -0.04211 -0.05462 0.00298 -0.05379 0.00289 Jul-22 0.09112 0.07271 0.07893 0.00623 0.06103 0.00372 Jun-22 -0.08392 -0.02113 -0.09610 0.00924 -0.03281 0.00108 May-22 0.00005 0.01224 -0.01213 0.00015 0.00056 0.00000 Apr-22 -0.08796 0.00760 -0.10014 0.01003 -0.00408 0.00002 Mar-22 0.03577 0.01587 0.02359 0.00056 0.00420 0.00002 Feb-22 -0.03136 -0.05658 -0.04355 0.00190 -0.06826 0.00466 Jan-22 -0.05259 -0.03216 -0.06477 0.00420 -0.04383 0.00192 Dec-21 0.04361 0.10203 0.03143 0.00099 0.09035 0.00816 Nov-21 -0.00833 -0.00387 -0.02052 0.00042 -0.01555 0.00024 Oct-21 0.06914 0.01841 0.05696 0.00324 0.00674 0.00005 Sep-21 -0.04757 0.02094 -0.05975 0.00357 0.00926 0.00009 Aug-21 0.02899 -0.02163 0.01681 0.00028 -0.03331 0.00111 Jul-21 0.02275 0.05074 0.01056 0.00011 0.03906 0.00153 Jun-21 0.02221 -0.00694 0.01003 0.00010 0.01862 0.00035 May-21 0.00549 -0.00928 -0.00670 0.00004 -0.02095 0.00044 Apr-21 0.05243 0.05327 0.04024 0.00162 0.04159 0.00173 Mar-21 0.04244 0.09401 0.03025 0.00092 0.08233 0.00678 Feb-21 0.02609 -0.00818 0.01391 0.00019 0.01986 0.00039 Jan-21 -0.01114 -0.03141 -0.02332 0.00054 -0.04309 0.00186 Dec-20 0.03712 -0.00729 0.02494 0.00062 -0.01897 0.00036Nov-20 0.10755 0.02084 0.09536 0.00909 0.00917 0.00008 Oct-20 -0.02767 -0.02957 -0.03985 0.00159 -0.04125 0.00170 Sep-20 -0.03923 0.03397 -0.05141 0.00264 0.02230 0.00050 Aug-20 0.07006 0.09903 0.05788 0.00335 0.08735 0.00763 Jul-20 0.05510 0.05318 0.04292 0.00184 0.04150 0.00172 Jun-20 0.01839 -0.00333 0.00620 0.00004 -0.01501 0.00023 May-20 0.04528 -0.00661 0.03310 0.00110 -0.01829 0.00033 Apr-20 0.12684 0.13432 0.11466 0.01315 0.12264 0.01504 Mar-20 -0.12512 -0.14310 -0.13730 0.01885 -0.15478 0.02396 Feb-20 -0.08411 -0.09254 -0.09630 0.00927 -0.10421 0.01086 Jan-20 -0.00163 0.08279 -0.01381 0.00019 0.07111 0.00506 Dec-19 0.02859 0.02261 0.01641 0.00027 0.01093 0.00012 Nov-19 0.03405 -0.01129 0.02186 0.00048 -0.02296 0.00053 Oct-19 0.02043 -0.08388 0.00825 0.00007 -0.09556 0.00913 Sep-19 0.01718 -0.00975 0.00500 0.00002 -0.02143 0.00046 Aug-19 -0.01809 0.03441 -0.03028 0.00092 0.02273 0.00052 Jul-19 0.01313 0.01474 0.00094 0.00000 0.00306 0.00001 Jun-19 0.06893 0.05349 0.05675 0.00322 0.04181 0.00175 May-19 -0.06578 0.00354 -0.07796 0.00608 -0.00814 0.00007 Apr-19 0.03931 0.04039 0.02713 0.00074 0.02871 0.00082 Mar-19 0.01792 0.03954 0.00574 0.00003 0.02786 0.00078 Feb-19 0.02973 0.02830 0.01754 0.00031 0.01662 0.00028 Jan-19 0.07868 0.00681 0.06650 0.00442 -0.00486 0.00002 Sums: 0.73108 0.70071 0.16849 0.18040 Market Company Monthly E(R): 0.01218 0.01168 Monthly Variance: 0.00281 0.00301 Monthly Standard Deviation: 0.05299 0.05483Company vs. S&P 500 over time 0.2 0.15 0.1 0.05 8/1/2020 2/1/2023 13/1/2020 3/1/2019 8/1/2023 21/2023 -0.05 -0. 1 -0.15 -+Mkt Returns Co. Returns -0.2\fMonth Date GSPC McD Mkt Returns Co. Returns 2. Calc. Returns (2) Input Worksheet 12/1/2023 4,768.37 290.73 0.043909541 0.037723606 NOTE: You need 61 total dates, in order to calculate 60 months worth of returns! 11/1/2023 4,567.80 280.161 0.089179265 0.075027580 10/1/2023 4,193.80 260.608 -0.021979688 -0.004820776 9/1/2023 4.288.05 261.871 -0.048719291 -0.057953569 8/1/2023 4,507.66 277.981 -0.017716432 -0.041098265 7/1/2023 4,588.96 289.895 0.031138914 -0.012243593 6/1/2023 4,450.38 293.488 0.064727513 0.046648699 5/1/2023 4,179.83 280.408 0.002482324 -0.0359765 4/1/2023 4,169.48 290.872 0.014642361 0.057723368 10 3/1/2023 4,109.31 274.999 0.035051572 0.065607245 11 2/1/2023 3,970.15 258.067 -0.026112447 -0.013051663 12 1/1/2023 4,076.60 261.48 0.061752832 0.014685148 13 12/1/2022 3,839.50 257.696 -0.058971449 -0.028504798 14 11/1/2022 4,080.11 265.257 0.05375286 0.000476875 15 10/1/2022 3,871.98 265.131 0.079863455 0.181676378 16 9/1/2022 3,585.62 224.368 -0.093395702 -0.080374849 17 8/1/2022 3,955.00 243.978 -0.042440119 -0.042108093 18 7/1/2022 4,130.29 254.703 0.091116348 0.072705899 19 6/1/2022 3,785.38 237.44 -0.083819893 -0.021133133 20 5/1/2022 4,132.15 242.566 5.32439E-05 0.012241103 21 4/1/2022 4,131.93 239.632 -0.087956719 0.00760276 22 3/1/2022 4,530.41 237.824 0.035773239 0.015874467 23 2/1/2022 4,373.94 234.108 -0.031360521 -0.05658127 24 1/1/20224 4,515.55 248.149 -0.052585089 -0.032155795 25 12/1/2021 4,766.18 256.393 0.043612875 0.102028463 26 11/1/2021 4,567.00 232.656 -0.008333731 -0.003868806 27 10/1/2021 4,605.38 233.559 0.069143873 0.018414796 28 9/1/2021 4,307.54 229.336 -0.04756914 0.020937638 29 8/1/2021 4,522.68 224.633 0.028990321 -0.021630752 30 7/1/2021 4,395.26 229.599 0.022748109 0.050738125 31 6/1/2021 4,297.50 218.512 0.022213976 -0.006944461 32 5/1/2021 4,204.11 220.04 0.005486503 -0.009276438 33 4/1/2021 4,181.17 222.101 0.052425313 0.053270335 34 3/1/2021 3,972.89 210.868 0.042438634 0.094009286 35 2/1/2021 3,811.15 192.748 0.026091475 -0.008179366 36 1/1/2021 3,714.24 194.337 -0.01113664 -0.031410379 37 12/1/2020 3,756.07 200.639 0.037121407 -0.007287466 38 11/1/2020 3,621.63 202.112 0. 107545658 0.020844997 39 10/1/2020 3,269.96 197.985 -0.027665775 -0.02956846 40 9/1/2020 3,363.00 204.018 -0.039227954 0.033973783 41 8/1/2020 3,500.31 197.314 0.070064687 0.089032337 42 7/1/2020 3,271.12 179.534 0.055101297 0.053179264 43 6/1/2020 3,100.29 170.469 0.018388403 -0.003328081 44 5/1/2020 3,044.31 171.038 0.045281775 -0.00661 1009 45 4/1/2020 2,912.43 172.176 0.126844103 0.134321036 46 3/1/2020 2 584.59 151.788 -0. 1251 19321 -0.14309748 47 2/1/2020 2,954.22 177.136 -0.084110469 -0.092536377 48 1/1/2020 3,225.52 195.199 -0.00162809 0.082789385 49 12/1/2019 3,230.78 180.274 0.028589803 0.022605899 50 11/1/2019 3,140.98 176.289 0.034047064 -0.01 128604 51 10/1/2019 3,037.56 178.301 0.020431747 -0.083880679 52 9/1/2019 2,976.74 194.627 0.017181168 -0.009747678