Question: What is Tesla's beta? Round your answer to two decimal places. Answer 1 What is Ford's beta? Round your answer to two decimal places. Answer

What is Tesla's beta? Round your answer to two decimal places. Answer 1

What is Ford's beta? Round your answer to two decimal places. Answer 2

What is GM's beta? Round your answer to two decimal places. Answer 3

Date p_Tesla r_Tesla p_riskfree pv_riskfree r_riskfree p_market r_market r_Tesla - r_riskfree r_market - r_riskfree p_Ford r_Ford r_Ford - r_riskfree p_GM r_GM r_GM - r_riskfree
4/1/2019 15.912667 2.509 $13.99 2945.83 8.224204 36.528137
5/1/2019 12.344 -0.2242658 2.142 $14.67 0.048827358 2752.06 -0.065777726 -0.273093159 -0.114605085 7.612484 -0.074380451 -0.123207809 31.266954 -0.14403097 -0.192858328
6/1/2019 14.897333 0.206848104 2 $15.00 0.022597072 2941.76 0.068930183 0.184251032 0.046333111 8.180223 0.074579993 0.051982921 36.134247 0.155668921 0.133071849
7/1/2019 16.107332 0.081222525 2.021 $14.95 -0.003463632 2980.38 0.013128195 0.084686157 0.016591827 7.620482 -0.06842613 -0.064962498 38.237114 0.058195955 0.061659587
8/1/2019 15.040667 -0.066222327 1.506 $16.64 0.113196118 2926.46 -0.018091653 -0.179418444 -0.13128777 7.442057 -0.023413873 -0.136609991 35.156536 -0.080565128 -0.193761246
9/1/2019 16.058001 0.067638889 1.675 $15.97 -0.040261581 2976.74 0.017181168 0.10790047 0.057442749 7.433941 -0.001090559 0.039171022 35.526199 0.010514773 0.050776354
10/1/2019 20.994667 0.307427182 1.691 $15.91 -0.003537143 3037.56 0.020431747 0.310964325 0.02396889 6.971349 -0.062227021 -0.058689878 35.57642 0.001413633 0.004950776
11/1/2019 21.996 0.047694636 1.776 $15.63 -0.017785344 3140.98 0.034047064 0.06547998 0.051832408 7.473454 0.07202408 0.089809424 34.465851 -0.031216435 -0.013431091
12/1/2019 27.888666 0.267897163 1.919 $15.21 -0.026843652 3230.78 0.028589803 0.294740815 0.055433455 7.671426 0.026490027 0.053333679 35.040283 0.0166667 0.043510352
1/1/2020 43.371334 0.555159863 1.52 $16.58 0.089928058 3225.52 -0.00162809 0.465231806 -0.091556147 7.275482 -0.051612829 -0.141540887 32.310036 -0.077917379 -0.167845436
2/1/2020 44.532665 0.026776465 1.127 $18.87 0.138378333 2954.22 -0.084110469 -0.111601868 -0.222488802 5.838836 -0.197464031 -0.335842363 29.513508 -0.086552921 -0.224931254
3/1/2020 34.933334 -0.215557075 0.698 $24.33 0.288957772 2584.59 -0.125119321 -0.504514847 -0.414077093 4.051951 -0.306034456 -0.594992228 20.107895 -0.318688412 -0.607646184
4/1/2020 52.125332 0.492137338 0.622 $26.08 0.071959067 2912.43 0.126844103 0.420178271 0.054885036 4.270068 0.053830118 -0.018128949 21.832176 0.085751442 0.013792376
5/1/2020 55.666668 0.067938867 0.648 $25.43 -0.024737026 3044.31 0.045281775 0.092675893 0.070018801 4.790194 0.121807428 0.146544454 25.348436 0.161058614 0.18579564
6/1/2020 71.987335 0.293185628 0.653 $25.31 -0.004646218 3100.29 0.018388403 0.297831846 0.023034622 5.100592 0.064798628 0.069444847 24.78035 -0.022411087 -0.017764868
7/1/2020 95.384003 0.325010893 0.536 $28.66 0.132052984 3271.12 0.055101297 0.192957909 -0.076951687 5.545216 0.087171058 -0.044881926 24.378771 -0.016205542 -0.148258526
8/1/2020 166.106674 0.741452118 0.693 $24.43 -0.147494288 3500.31 0.070064687 0.888946406 0.217558975 5.721388 0.031770088 0.179264376 29.021416 0.190438025 0.337932313
9/1/2020 143.003326 -0.139087416 0.677 $24.77 0.013959644 3363 -0.039227954 -0.15304706 -0.053187599 5.587162 -0.023460391 -0.037420035 28.982237 -0.001350003 -0.015309647
10/1/2020 129.346664 -0.095498912 0.86 $21.63 -0.126887715 3269.96 -0.027665775 0.031388803 0.09922194 6.484799 0.160660636 0.287548351 33.82077 0.166948224 0.293835939
11/1/2020 189.199997 0.462735807 0.844 $21.85 0.010192121 3621.63 0.107545658 0.452543686 0.097353537 7.617332 0.174644272 0.16445215 42.939545 0.269620562 0.25942844
12/1/2020 235.223328 0.243252282 0.917 $20.91 -0.04317105 3756.07 0.037121407 0.286423331 0.080292456 7.374048 -0.031938217 0.011232833 40.784733 -0.05018246 -0.00701141
1/1/2021 264.51001 0.124505857 1.093 $19.15 -0.08399828 3714.24 -0.01113664 0.208504137 0.07286164 8.833755 0.197951925 0.281950205 49.639057 0.217098982 0.301097262
2/1/2021 225.166672 -0.14874045 1.46 $16.85 -0.120100269 3811.15 0.026091475 -0.028640181 0.146191744 9.815285 0.1111113 0.231211569 50.275707 0.012825586 0.132925855
3/1/2021 222.643326 -0.01120657 1.746 $15.73 -0.066586577 3972.89 0.042438634 0.055380007 0.109025211 10.276688 0.04700862 0.113595196 56.2798 0.119423343 0.186009919
4/1/2021 236.479996 0.062147248 1.631 $16.13 0.025676945 4181.17 0.052425313 0.036470303 0.026748368 9.681059 -0.057959237 -0.083636182 56.044731 -0.004176792 -0.029853736
5/1/2021 208.406662 -0.118713356 1.581 $16.33 0.012020355 4204.11 0.005486503 -0.130733711 -0.006533852 12.189409 0.259098721 0.247078366 58.091805 0.036525717 0.024505363
6/1/2021 226.566666 0.087137349 1.443 $16.93 0.037053117 4297.5 0.022213976 0.050084232 -0.014839141 12.466249 0.022711519 -0.014341598 57.954678 -0.002360522 -0.03941364
7/1/2021 229.066666 0.01103428 1.239 $18.07 0.067396197 4395.26 0.022748109 -0.056361918 -0.044648088 11.702838 -0.061238228 -0.128634426 55.672539 -0.039377995 -0.106774192
8/1/2021 245.240005 0.07060538 1.304 $17.67 -0.022262897 4522.68 0.028990321 0.092868277 0.051253218 10.931038 -0.065949815 -0.043686918 48.003353 -0.137755276 -0.11549238
9/1/2021 258.493347 0.054042333 1.529 $16.54 -0.063869359 4307.54 -0.04756914 0.117911692 0.016300219 11.879011 0.086723054 0.150592413 51.627361 0.075494893 0.139364252
10/1/2021 371.333344 0.436529599 1.557 $16.42 -0.007110835 4605.38 0.069143873 0.443640433 0.076254708 14.328638 0.206214726 0.213325561 53.312038 0.032631476 0.039742311
11/1/2021 381.58667 0.027612188 1.443 $16.93 0.030896394 4567 -0.008333731 -0.003284206 -0.039230125 16.098745 0.123536305 0.092639912 56.681374 0.063200285 0.032303891
12/1/2021 352.26001 -0.076854519 1.512 $16.61 -0.018679869 4766.18 0.043612875 -0.05817465 0.062292744 17.511965 0.087784483 0.106464352 57.42577 0.013132991 0.031812861
1/1/2022 312.23999 -0.113609319 1.782 $15.61 -0.060316541 4515.55 -0.052585089 -0.053292778 0.007731452 17.115686 -0.022629042 0.037687499 51.646954 -0.100631058 -0.040314517
2/1/2022 290.143341 -0.070768158 1.839 $15.44 -0.011141303 4373.94 -0.031360521 -0.059626855 -0.020219217 14.881612 -0.130527868 -0.119386564 45.760399 -0.113976809 -0.102835505
3/1/2022 359.200012 0.238008809 2.327 $14.30 -0.07386829 4530.41 0.035773239 0.311877099 0.109641529 14.330754 -0.037016017 0.036852273 42.841606 -0.063784256 0.010084034
4/1/2022 290.253326 -0.191945111 2.887 $13.46 -0.05830267 4131.93 -0.087956719 -0.133642441 -0.029654049 12.000206 -0.162625637 -0.104322967 37.131344 -0.133287767 -0.074985097
5/1/2022 252.753326 -0.129197486 2.844 $13.52 0.003889774 4132.15 5.32439E-05 -0.13308726 -0.00383653 11.670555 -0.027470445 -0.031360219 37.885536 0.020311465 0.016421692
6/1/2022 224.473328 -0.111887738 2.972 $13.36 -0.011204121 3785.38 -0.083919993 -0.100683617 -0.072715872 9.495123 -0.186403474 -0.175199354 31.107668 -0.178903843 -0.167699723
7/1/2022 297.149994 0.323765263 2.642 $13.79 0.031446469 4130.29 0.091116348 0.292318794 0.059669879 12.532198 0.319856309 0.28840984 35.51524 0.141687638 0.110241169
8/1/2022 275.609985 -0.072488674 3.133 $13.19 -0.043030972 3955 -0.042440119 -0.029457702 0.000590853 13.001407 0.03744028 0.080471252 37.425182 0.053778096 0.096809068
9/1/2022 265.25 -0.037589295 3.804 $12.63 -0.042679233 3585.62 -0.093395702 0.005089938 -0.050716469 9.650135 -0.257762256 -0.215083023 31.502647 -0.158249999 -0.115570766
10/1/2022 227.539993 -0.142167793 4.077 $12.45 -0.013938593 3871.98 0.079863455 -0.1282292 0.093802048 11.51985 0.193750139 0.207688732 38.531601 0.223122647 0.23706124
11/1/2022 194.699997 -0.144326259 3.703 $12.70 0.019893478 4080.11 0.05375286 -0.164219738 0.033859382 11.976506 0.039640794 0.019747316 39.817619 0.03337567 0.013482192
12/1/2022 123.18 -0.367334351 3.879 $12.58 -0.009647569 3839.5 -0.058971449 -0.357686781 -0.04932388 10.125376 -0.154563443 -0.144915873 33.024281 -0.170611357 -0.160963787
1/1/2023 173.220001 0.406234786 3.529 $12.83 0.020327575 4076.6 0.061752832 0.385907212 0.041425258 11.762153 0.161650985 0.14132341 38.686157 0.171445852 0.151118277
2/1/2023 205.710007 0.18756498 3.916 $12.55 -0.021820563 3970.15 -0.026112447 0.209385543 -0.004291883 10.508451 -0.106587799 -0.084767236 38.115509 -0.014750703 0.007069861
3/1/2023 207.460007 0.008507121 3.494 $12.86 0.024568445 4109.31 0.035051572 -0.016061324 0.010483127 11.661444 0.109720548 0.085152102 36.088718 -0.053174969 -0.077743414
4/1/2023 164.309998 -0.207991938 3.452 $12.90 0.002707356 4169.48 0.014642361 -0.210699295 0.011935004 10.995075 -0.057142923 -0.05985028 32.583122 -0.09713828 -0.099845637
5/1/2023 203.929993 0.241129545 3.637 $12.75 -0.011425449 4179.83 0.002482324 0.252554994 0.013907773 11.244848 0.022716807 0.034142256 31.96184 -0.019067602 -0.007642153
6/1/2023 261.769989 0.283626725 3.819 $12.62 -0.010277433 4450.38 0.064727513 0.293904157 0.075004945 14.177878 0.260833228 0.27111066 38.026798 0.189756222 0.200033654
7/1/2023 267.429993 0.021622051 3.959 $12.53 -0.007338133 4588.96 0.031138914 0.028960184 0.038477047 12.378703 -0.126900161 -0.119562027 37.944794 -0.002156479 0.005181654
8/1/2023 258.079987 -0.034962443 4.093 $12.44 -0.0066019 4507.66 -0.017716432 -0.028360543 -0.011114532 11.490397 -0.07176083 -0.06515893 33.138653 -0.126661407 -0.120059507
9/1/2023 250.220001 -0.03045562 4.573 $12.19 -0.020609448 4288.05 -0.048719291 -0.009846172 -0.028109843 11.765106 0.023907703 0.044517151 32.692757 -0.013455465 0.007153983
10/1/2023 200.839996 -0.197346354 4.875 $12.05 -0.011115865 4193.8 -0.021979688 -0.186230489 -0.010863822 9.235892 -0.214975879 -0.203860013 27.96287 -0.144676908 -0.133561043
11/1/2023 240.080002 0.19537944 4.352 $12.30 0.020455257 4567.8 0.089179265 0.174924184 0.068724008 9.870544 0.068715832 0.048260575 31.334278 0.120567309 0.100112053
12/1/2023 248.479996 0.034988312 3.866 $12.59 0.023488664 4769.83 0.044229169 0.011499648 0.020740505 11.727283 0.188109085 0.164620421 35.719685 0.139955578 0.116466914
1/1/2024 187.289993 -0.24625726 3.967 $12.52 -0.005232233 4845.65 0.015895745 -0.241025027 0.021127978 11.275125 -0.038556075 -0.033323842 38.583626 0.080178227 0.08541046
2/1/2024 201.880005 0.077900649 4.252 $12.35 -0.01349452 5096.27 0.051720615 0.091395169 0.065215135 11.967793 0.061433288 0.074927808 40.751465 0.056185466 0.069679986
3/1/2024 175.789993 -0.129235245 4.206 $12.38 0.002082399 5254.35 0.031018765 -0.131317644 0.028936366 13.12064 0.096329123 0.094246724 45.230682 0.109915484 0.107833086

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!