Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 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.

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions