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://www.seevid.ir/fa/w/j65sNTANYVk 3) Here's a video where I just calculate Beta: https://www.seevid.ir/fa/w/fv0_3wnw6h8

• #education
• #excel
• #finance
• #beta
• #capm
• #capital_asset_pricing_model
• #risk_free_rate
• #90_day_t_bill
• #expected_return