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

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

Written By David Johnk on Friday, Jun 19, 2020 | 10:30 PM

 
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

Disclaimer:
All images, musics and videos copyright are belong to their respective owners. We just put embed contents from Youtube.com and do not host any content in our server. These content(s) may be protected by copyright law or other laws regarding intellectual property of the United States or other countries. Downloading file(s) on this site is just for review purpose. If you love the song, please support the artists by buying the original CD/Cassette or buying the song from iTunes.