Answered step by step
Verified Expert Solution
Link Copied!

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

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Capital Markets Institutions And Instruments

Authors: Frank J. Fabozzi, Franco Modigliani

2nd Edition

0133001873, 978133001877

More Books

Students also viewed these Finance questions