The spreadsheet below contains the monthly stock returns for Tesla, the S&P 500, and Treasuries between 2015 and 2019. Using these data and Excel estimate the beta for Tesla over this time period. Round your answer to two decimals.
You can download the spreadsheet here: TSLA Stock Returns.xlsx
1/31/2017 0.178951 0.017884 0.0004 12/30/20160.128247 0.018201 0.0003 11/30/2016-0.042128 0.034174 0.0001 10/31/2016-0.030878 -0.019426 0.0002 9/30/2016 -0.03764 -0.001234 0.0002 8/31/2016 -0.097023 -0.001219 0.0002 --- ... 7/29/2016 0.106039 0.03561 0.0002 6/30/2016 -0.049053 0.000906 0.0002 5/31/2016 -0.072811 0.015329 0.0001 4/29/2016 0.04783 0.002699 0.0001 3/31/2016 0.197155 0.065991 0.0002 2/29/2016 0.003818 -0.004128 0.0002 1/29/2016 -0.203367 -0.050735 0.0001 12/31/2015 0.042343 -0.01753 0.0001 11/30/20150.112743 0.0005050 10/30/2015-0.166948 0.082983 0 9/30/2015 -0.00265 -0.0264430 8/31/2015 -0.064212 -0.062581 0 1943015 007056 01071 7/31/2015 -0.007866 0.019742 0 6/30/2015 0.069617 -0.021012 0 5/29/2015 0.109489 0.010491 0 4/30/2015 0.197489 0.008521 0 3/31/2015 -0.071653 -0.017396 0 2/27/2015 -0.001277 0.054893 0 1/30/2015 -0.084574 -0.031041 0 0.017859 Returns Data (in decimals) Date Monthly Monthly Monthly Returns Returns Return on on Tesla on S&P Treasuries Stock 500 12/31/2019 0.267897 0.02859 0.0014 11/29/20190.047695 0.034047 0.0012 10/31/20190.307427 0.020432 0.0015 9/30/2019 0.067639 0.017181 0.0018 8/30/2019 -0.066222 -0.018092 0.0016 7/31/2019 0.081223 0.013128 0.0019 6/28/2019 0.206848 0.06893 0.0018 5/31/2019 -0.224266 -0.065778 0.0021 4/30/2019 -0.147109 0.039313 0.0021 3/29/2019 -0.125109 0.017924 0.0019 2/28/2019 0.041887 0.029729 0.0018 1/31/2019 -0.077464 0.078684 0.0021 12/31/2018 -0.050445 -0.091777 0.0019 11/30/20180.039013 10/31/2018 0.274011 -0.069403 0.0019 9/28/2018 -0.12229 0.004294 0.0015 8/31/2018 0.011806 0.030263 0.0016 7/31/2018 -0.13066 0.036022 0.0016 6/29/2018 0.204474 0.004842 0.0014 5/31/2018 -0.031201 0.021608 0.0014 4/30/2018 0.104347 0.002719 0.0014 3/29/2018 -0.224246 -0.026885 0.0012 2/28/2018 -0.031752 -0.0 0.0011 T9010 43200 seis 2011 1/31/2018 0.13798 0.056179 0.0011 12/29/20170.008095 0.009832 0.0009 14 11/30/2017-0.06841 0.028083 0.0008 10/31/2017-0.028056 0.022188 0.0009 9/29/2017 -0.041585 0.019303 0.0009 8/31/2017 0.100257 0.000546 0.0009 W 7/31/2017 -0.105473 0.019349 0.0007 6/30/2017 0.060409 0.004814 0.0006 5/31/2017 0.085777 0.011576 0.0006 4/28/2017 0.12853 0.009091 0.0005 3/31/2017 0.113244 -0.000389 0.0003 2/28/2017 -0.007701 0.037198 0.0004 0.0018 1/31/2017 0.178951 0.017884 0.0004 12/30/20160.128247 0.018201 0.0003 11/30/2016-0.042128 0.034174 0.0001 10/31/2016-0.030878 -0.019426 0.0002 9/30/2016 -0.03764 -0.001234 0.0002 8/31/2016 -0.097023 -0.001219 0.0002 --- ... 7/29/2016 0.106039 0.03561 0.0002 6/30/2016 -0.049053 0.000906 0.0002 5/31/2016 -0.072811 0.015329 0.0001 4/29/2016 0.04783 0.002699 0.0001 3/31/2016 0.197155 0.065991 0.0002 2/29/2016 0.003818 -0.004128 0.0002 1/29/2016 -0.203367 -0.050735 0.0001 12/31/2015 0.042343 -0.01753 0.0001 11/30/20150.112743 0.0005050 10/30/2015-0.166948 0.082983 0 9/30/2015 -0.00265 -0.0264430 8/31/2015 -0.064212 -0.062581 0 1943015 007056 01071 7/31/2015 -0.007866 0.019742 0 6/30/2015 0.069617 -0.021012 0 5/29/2015 0.109489 0.010491 0 4/30/2015 0.197489 0.008521 0 3/31/2015 -0.071653 -0.017396 0 2/27/2015 -0.001277 0.054893 0 1/30/2015 -0.084574 -0.031041 0 0.017859 Returns Data (in decimals) Date Monthly Monthly Monthly Returns Returns Return on on Tesla on S&P Treasuries Stock 500 12/31/2019 0.267897 0.02859 0.0014 11/29/20190.047695 0.034047 0.0012 10/31/20190.307427 0.020432 0.0015 9/30/2019 0.067639 0.017181 0.0018 8/30/2019 -0.066222 -0.018092 0.0016 7/31/2019 0.081223 0.013128 0.0019 6/28/2019 0.206848 0.06893 0.0018 5/31/2019 -0.224266 -0.065778 0.0021 4/30/2019 -0.147109 0.039313 0.0021 3/29/2019 -0.125109 0.017924 0.0019 2/28/2019 0.041887 0.029729 0.0018 1/31/2019 -0.077464 0.078684 0.0021 12/31/2018 -0.050445 -0.091777 0.0019 11/30/20180.039013 10/31/2018 0.274011 -0.069403 0.0019 9/28/2018 -0.12229 0.004294 0.0015 8/31/2018 0.011806 0.030263 0.0016 7/31/2018 -0.13066 0.036022 0.0016 6/29/2018 0.204474 0.004842 0.0014 5/31/2018 -0.031201 0.021608 0.0014 4/30/2018 0.104347 0.002719 0.0014 3/29/2018 -0.224246 -0.026885 0.0012 2/28/2018 -0.031752 -0.0 0.0011 T9010 43200 seis 2011 1/31/2018 0.13798 0.056179 0.0011 12/29/20170.008095 0.009832 0.0009 14 11/30/2017-0.06841 0.028083 0.0008 10/31/2017-0.028056 0.022188 0.0009 9/29/2017 -0.041585 0.019303 0.0009 8/31/2017 0.100257 0.000546 0.0009 W 7/31/2017 -0.105473 0.019349 0.0007 6/30/2017 0.060409 0.004814 0.0006 5/31/2017 0.085777 0.011576 0.0006 4/28/2017 0.12853 0.009091 0.0005 3/31/2017 0.113244 -0.000389 0.0003 2/28/2017 -0.007701 0.037198 0.0004 0.0018
