Calculate the CAPM beta of Tesla using monthly return data Ri represents the return from the last day of the previous month to the last day of the current month. For example, the first return observation should equal the return from May 2018 to
June 2018. This represents the return for June 2018.
Submission Instructions: Submit your work as an excel file to show the formulas
Month Rm-Rf Rf Ri Date Adj Clos Ri-Rf Excess
Return from last day Return
of previous month

201806 0.0048 0.0014 5/1/2018 56.946
201807 0.0319 0.0016 6/1/2018 68.59
201808 0.0344 0.0016 7/1/2018 59.628
201809 0.0006 0.0015 8/1/2018 60.332
201810 -0.0768 0.0019 9/1/2018 52.954
201811 0.0169 0.0018 10/1/2018 67.464
201812 -0.0955 0.0019 11/1/2018 70.096
201901 0.0841 0.0021 12/1/2018 66.56
201902 0.034 0.0018 1/1/2019 61.404
201903 0.011 0.0019 2/1/2019 63.976
201904 0.0396 0.0021 3/1/201 55.972
201905 -0.0694 0.0021 4/1/2019 47.738
5/1/2019 37.032