Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The spreadsheet below contains the monthly stock returns for several different stocks, the S&P 500, and Treasuries between 2015 and 2019. Using these data and
The spreadsheet below contains the monthly stock returns for several different stocks, the S&P 500, and Treasuries between 2015 and 2019. Using these data and Excel estimate the beta for Barrick Gold over this time period. Round your answer to two decimals.
Date | Monthly Returns on S&P 500 | Monthly Return on Treasuries | Monthly Returns on Tesla Stock | Monthly Returns on General Dynamics | Monthly Returns on Alphabet Inc | Monthly Returns on Berkshire Hathaway | Monthly Returns on Lockheed Martin | Monthly Returns on Walt Disney | Monthly Returns on Walmart | Monthly Returns on Barrick Gold | Monthly Returns on AutoZone | Monthly Returns on Yum! Brands | Monthly Returns on Netflix |
12/31/19 | 0.02859 | 0.0014 | 0.267897 | -0.029658 | 0.024568 | 0.027519 | -0.004220 | -0.040045 | 0.002351 | 0.106548 | 0.011368 | 0.000596 | 0.028316 |
11/29/19 | 0.034047 | 0.0012 | 0.047695 | 0.027941 | 0.035592 | 0.036233 | 0.044467 | 0.166718 | 0.015606 | -0.029378 | 0.029308 | -0.006096 | 0.094812 |
10/31/19 | 0.020432 | 0.0015 | 0.307427 | -0.026870 | 0.033724 | 0.022791 | -0.034302 | -0.003069 | -0.011965 | 0.001731 | 0.055098 | -0.103324 | 0.073948 |
9/30/19 | 0.017181 | 0.0018 | 0.067639 | -0.044649 | 0.026008 | 0.028884 | 0.015490 | -0.050561 | 0.038684 | -0.105779 | -0.015494 | -0.028686 | -0.088953 |
8/30/19 | -0.018092 | 0.0016 | -0.066222 | 0.028665 | -0.023490 | -0.018104 | 0.066654 | -0.040207 | 0.039953 | 0.194342 | -0.019011 | 0.041593 | -0.090529 |
7/31/19 | 0.013128 | 0.0019 | 0.081223 | 0.028270 | 0.125607 | -0.030419 | -0.003768 | 0.030435 | -0.000996 | 0.031072 | 0.021438 | 0.016716 | -0.120685 |
6/28/19 | 0.06893 | 0.0018 | 0.206848 | 0.130581 | -0.020587 | 0.071669 | 0.073847 | 0.057558 | 0.089215 | 0.269726 | 0.070450 | 0.081290 | 0.070030 |
5/31/19 | -0.065778 | 0.0021 | -0.224266 | -0.100157 | -0.071394 | -0.086194 | 0.022230 | -0.035993 | -0.008460 | -0.020440 | -0.001167 | -0.015519 | -0.073568 |
4/30/19 | 0.039313 | 0.0021 | -0.147109 | 0.061791 | 0.012929 | 0.079229 | 0.110508 | 0.233631 | 0.054445 | -0.072210 | 0.004091 | 0.045887 | 0.039208 |
3/29/19 | 0.017924 | 0.0019 | -0.125109 | -0.005522 | 0.047673 | -0.003259 | -0.029896 | -0.016040 | -0.009395 | 0.084652 | 0.090685 | 0.056190 | -0.004300 |
2/28/19 | 0.029729 | 0.0018 | 0.041887 | -0.005550 | 0.003180 | -0.029856 | 0.075667 | 0.011836 | 0.032975 | -0.056012 | 0.108138 | 0.010002 | 0.054786 |
1/31/19 | 0.078684 | 0.0021 | -0.077464 | 0.094714 | 0.077983 | 0.017974 | 0.106363 | 0.017054 | 0.028771 | -0.011078 | 0.010736 | 0.022411 | 0.268400 |
12/31/18 | -0.091777 | 0.0019 | -0.050445 | -0.149711 | -0.053745 | -0.061350 | -0.128449 | -0.042947 | -0.040758 | 0.067451 | 0.036177 | -0.003253 | -0.064551 |
11/30/18 | 0.017859 | 0.0018 | 0.039013 | 0.071329 | 0.016401 | 0.059456 | 0.029879 | 0.005748 | -0.026227 | 0.018327 | 0.103072 | 0.024002 | -0.051859 |
10/31/18 | -0.069403 | 0.0019 | 0.274011 | -0.152452 | -0.097782 | -0.038422 | -0.150624 | -0.018043 | 0.067831 | 0.132672 | -0.054441 | -0.005500 | -0.193382 |
9/28/18 | 0.004294 | 0.0015 | -0.122290 | 0.058532 | -0.020292 | 0.013300 | 0.079742 | 0.043921 | -0.020342 | 0.063340 | 0.011501 | 0.046265 | 0.017542 |
8/31/18 | 0.030263 | 0.0016 | 0.011806 | -0.031838 | 0.000764 | 0.047256 | -0.011316 | -0.013561 | 0.080130 | -0.066130 | 0.086956 | 0.100391 | 0.089584 |
7/31/18 | 0.036022 | 0.0016 | -0.130660 | 0.076605 | 0.091077 | 0.069175 | 0.103815 | 0.091499 | 0.041798 | -0.147753 | 0.051570 | 0.013679 | -0.137905 |
6/29/18 | 0.004842 | 0.0014 | 0.204474 | -0.075851 | 0.028258 | -0.017967 | -0.060755 | 0.053684 | 0.037679 | -0.004549 | 0.033281 | -0.038239 | 0.113282 |
5/31/18 | 0.021608 | 0.0014 | -0.031201 | 0.001987 | 0.066507 | -0.011870 | -0.013402 | -0.008572 | -0.061045 | -0.018560 | 0.039710 | -0.062112 | 0.125264 |
4/30/18 | 0.002719 | 0.0014 | 0.104347 | -0.084473 | -0.014015 | -0.028251 | -0.050573 | -0.001095 | -0.005732 | 0.081928 | -0.037260 | 0.023141 | 0.057931 |
3/29/18 | -0.026885 | 0.0012 | -0.224246 | -0.006968 | -0.066025 | -0.035939 | -0.041170 | -0.026367 | -0.005777 | 0.080729 | -0.024115 | 0.046080 | 0.013625 |
2/28/18 | -0.038947 | 0.0011 | -0.031752 | -0.000135 | -0.055738 | -0.040588 | -0.001155 | -0.050704 | -0.155628 | -0.196801 | -0.131584 | -0.033692 | 0.077987 |
1/31/18 | 0.056179 | 0.0011 | 0.137980 | 0.097665 | 0.118062 | 0.086610 | 0.105280 | 0.010790 | 0.079494 | -0.006220 | 0.076008 | 0.036515 | 0.408106 |
12/29/17 | 0.009832 | 0.0009 | 0.008095 | -0.017909 | 0.024466 | 0.020926 | 0.006048 | 0.033677 | 0.020878 | 0.050073 | 0.035835 | -0.022283 | 0.023350 |
11/30/17 | 0.028083 | 0.0008 | -0.068410 | 0.020593 | 0.004692 | 0.039327 | 0.042056 | 0.071670 | 0.113618 | -0.044291 | 0.164987 | 0.125185 | -0.045054 |
10/31/17 | 0.022188 | 0.0009 | -0.028056 | -0.008561 | 0.059983 | 0.020856 | -0.000419 | -0.007710 | 0.117353 | -0.101927 | -0.009427 | 0.011411 | 0.083154 |
9/29/17 | 0.019303 | 0.0009 | -0.041585 | 0.021008 | 0.021058 | 0.012120 | 0.016045 | -0.025988 | 0.000897 | -0.105614 | 0.126164 | -0.041786 | 0.038006 |
8/31/17 | 0.000546 | 0.0009 | 0.100257 | 0.025569 | 0.009490 | 0.032970 | 0.051621 | -0.079414 | -0.017627 | 0.065642 | -0.021081 | 0.017753 | -0.038258 |
7/31/17 | 0.019349 | 0.0007 | -0.105473 | -0.004695 | 0.023957 | 0.031747 | 0.052304 | 0.041976 | 0.056950 | 0.062854 | -0.053711 | 0.027386 | 0.215849 |
6/30/17 | 0.004814 | 0.0006 | 0.060409 | -0.025338 | -0.058174 | 0.025197 | -0.012521 | -0.015657 | -0.037150 | -0.038090 | -0.058523 | 0.015419 | -0.083768 |
5/31/17 | 0.011576 | 0.0006 | 0.085777 | 0.048816 | 0.065014 | 0.002664 | 0.050102 | -0.066263 | 0.052275 | -0.008971 | -0.124633 | 0.104791 | 0.071419 |
4/28/17 | 0.009091 | 0.0005 | 0.128530 | 0.039690 | 0.092097 | -0.008285 | 0.006913 | 0.019490 | 0.043008 | -0.119537 | -0.042680 | 0.033646 | 0.029700 |
3/31/17 | -0.000389 | 0.0003 | 0.113244 | -0.013751 | 0.007714 | -0.028199 | 0.003826 | 0.029976 | 0.023403 | 0.022067 | -0.018329 | -0.021739 | 0.039963 |
2/28/17 | 0.037198 | 0.0004 | -0.007701 | 0.048211 | 0.033158 | 0.045205 | 0.067919 | -0.005061 | 0.062781 | 0.009219 | 0.015959 | -0.003205 | 0.010092 |
1/31/17 | 0.017884 | 0.0004 | 0.178951 | 0.053168 | 0.032352 | 0.007617 | 0.005561 | 0.061696 | -0.034433 | 0.153942 | -0.082060 | 0.039476 | 0.136591 |
12/30/16 | 0.018201 | 0.0003 | 0.128247 | -0.015341 | 0.018179 | 0.030046 | -0.057719 | 0.059322 | -0.011501 | 0.063915 | 0.008440 | -0.000946 | 0.058120 |
11/30/16 | 0.034174 | 0.0001 | -0.042128 | 0.163261 | -0.033778 | 0.098748 | 0.083976 | 0.069371 | 0.005856 | -0.144969 | 0.055271 | 0.051752 | -0.063026 |
10/31/16 | -0.019426 | 0.0002 | -0.030878 | -0.023589 | 0.009327 | -0.002405 | 0.027782 | -0.001831 | -0.029118 | -0.007336 | -0.034074 | -0.044268 | 0.267073 |
9/30/16 | -0.001234 | 0.0002 | -0.037640 | 0.019314 | 0.013350 | -0.042257 | -0.013376 | -0.016938 | 0.009518 | 0.041740 | 0.035778 | 0.001102 | 0.011288 |
8/31/16 | -0.001219 | 0.0002 | -0.097023 | 0.036286 | -0.002263 | 0.045185 | -0.032090 | -0.015529 | -0.014115 | -0.220952 | -0.088664 | 0.014426 | 0.067945 |
7/29/16 | 0.03561 | 0.0002 | 0.106039 | 0.054941 | 0.110808 | -0.004494 | 0.018374 | -0.011859 | -0.000685 | 0.023888 | 0.025358 | 0.083936 | -0.002514 |
6/30/16 | 0.000906 | 0.0002 | -0.049053 | -0.013181 | -0.059289 | 0.024942 | 0.050544 | -0.014110 | 0.031647 | 0.273107 | 0.041511 | 0.010111 | -0.108121 |
5/31/16 | 0.015329 | 0.0001 | -0.072811 | 0.009607 | 0.061630 | -0.033356 | 0.023668 | -0.039125 | 0.065949 | -0.133196 | -0.003960 | 0.031800 | 0.139287 |
4/29/16 | 0.002699 | 0.0001 | 0.047830 | 0.075436 | -0.069723 | 0.026001 | 0.049120 | 0.039774 | -0.023653 | 0.426362 | -0.039488 | -0.022358 | -0.119339 |
3/31/16 | 0.065991 | 0.0002 | 0.197155 | -0.035958 | 0.067615 | 0.053788 | 0.026461 | 0.039678 | 0.039946 | -0.022318 | 0.028558 | 0.129433 | 0.094422 |
2/29/16 | -0.004128 | 0.0002 | 0.003818 | 0.018689 | -0.060812 | 0.042164 | 0.030521 | -0.003131 | -0.000301 | 0.403633 | 0.009356 | 0.001382 | 0.017095 |
1/29/16 | -0.050735 | 0.0001 | -0.203367 | -0.021112 | -0.020991 | -0.017391 | -0.028321 | -0.088123 | 0.082545 | 0.342818 | 0.034344 | -0.003012 | -0.197062 |
12/31/15 | -0.01753 | 0.0001 | 0.042343 | -0.062133 | 0.021923 | -0.017680 | -0.009171 | -0.067683 | 0.050136 | 0.005450 | -0.053409 | 0.007447 | -0.072570 |
11/30/15 | 0.000505 | 0 | 0.112743 | -0.014268 | 0.044724 | -0.015817 | 0.004458 | -0.002374 | 0.027952 | -0.042913 | -0.000816 | 0.022564 | 0.137941 |
10/30/15 | 0.082983 | 0 | -0.166948 | 0.082059 | 0.168288 | 0.047921 | 0.060393 | 0.112916 | -0.117212 | 0.209119 | 0.083694 | -0.107317 | 0.049584 |
9/30/15 | -0.026443 | 0 | -0.002650 | -0.028726 | -0.015900 | -0.035999 | 0.030470 | 0.003141 | 0.001699 | -0.084892 | 0.010950 | 0.002256 | -0.102321 |
8/31/15 | -0.062581 | 0 | -0.064212 | -0.047482 | -0.011764 | -0.053593 | -0.021342 | -0.151000 | -0.093915 | -0.012748 | 0.021471 | -0.091044 | 0.006299 |
7/31/15 | 0.019742 | 0 | -0.007866 | 0.052368 | 0.201917 | 0.044667 | 0.114040 | 0.057123 | 0.014803 | -0.337711 | 0.051042 | -0.021203 | 0.218026 |
6/30/15 | -0.021012 | 0 | 0.069617 | 0.015839 | -0.021800 | -0.046322 | -0.012221 | 0.034158 | -0.044971 | -0.101180 | -0.009976 | -0.000333 | 0.052687 |
5/29/15 | 0.010491 | 0 | 0.109489 | 0.020682 | -0.009733 | 0.006560 | 0.016613 | 0.015177 | -0.042153 | -0.085254 | 0.001427 | 0.048278 | 0.121402 |
4/30/15 | 0.008521 | 0 | 0.197489 | 0.016798 | -0.016760 | -0.018851 | -0.080607 | 0.036514 | -0.051064 | 0.187956 | -0.013926 | 0.097180 | 0.335525 |
3/31/15 | -0.017396 | 0 | -0.071653 | -0.021977 | -0.018625 | -0.016638 | 0.014546 | 0.007782 | -0.014178 | -0.158218 | 0.061430 | -0.029466 | -0.122592 |
2/27/15 | 0.054893 | 0 | -0.001277 | 0.041814 | 0.044676 | 0.024622 | 0.069969 | 0.144239 | -0.012356 | 0.022692 | 0.076588 | 0.122164 | 0.074943 |
1/30/15 | -0.031041 | 0 | -0.084574 | -0.027540 | 0.015426 | -0.044845 | -0.021810 | -0.034292 | -0.010480 | 0.188837 | -0.035777 | -0.002196 | 0.293288 |
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