Beta, the risk-free rate, and CAPM. Calculate the expected return of a security on Excel.

https://www.buymeacoffee.com/DrDavidJohnk
Use Excel, Yahoo Finance, and 90 Day T-bill data from the US Federal Reserve to calculate the expected return of a security. Here's the link to the file used in this video: https://bit.ly/3fAJ8uS
Notes:
1) I used 365 days when calculating annual returns since there were only 252 observations/year 252 would be better.
2) I don't use returns in excess of the risk-free rate when calculating the Beta (my method is still very close). If you want to be more accurate here's a good video: https://youtu.be/j65sNTANYVk
3) Here's a video where I just calculate Beta: https://www.youtube.com/watch?v=fv0_3wnw6h8&t=4s

Видео Beta, the risk-free rate, and CAPM. Calculate the expected return of a security on Excel. канала David Johnk