Due on November $20,2023-$ Please Submit Answers in Excel File Only on Canvas

Use Yahoo Finance to download the monthly closing price for Tesla's stock $($TSLA$)$ for

$25$ months back. Then do the same for the S&P $500$ index $({?}^{{?}^{{?}^{?}}}GSPC),$ and the $13$ Week

Treasury Bill index $(^$IRX$).$

a$)$ Calculate the monthly excess returns for Tesla and the S&P $500$ index over a

period of at least $24$ months and show the average excess returns for each.

b$)$ What is the beta of Tesla?

c$)$ What is the alpha of Tesla?

d$)$ What is the standard error for Tesla's beta?

e$)$ How does your calculated beta for Tesla compare with the beta provided by

Yahoo Finance? Please comment.