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 Return from last day of previous month

Date

Adj Close

Ri-Rf Excess Return

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/2019	55.972
201905	-0.0694	0.0021		4/1/2019	47.738
				5/1/2019	37.032