Select 4 (publicly traded) stocks and download 61 months of adjusted prices from https://finance.yahoo.com/ historical prices.

Select 4 (publicly traded) stocks and download 61 months of adjusted prices from https://finance.yahoo.com/ historical prices.

For each stock:

i. calculate one month’s returns for 60 months.

ii. find the 60-month risk-free rate, and use the index ^irx, each month is an annual return, so to convert to monthly divide by 1200,https://jessescrossroadscafe.blogspot.com/2008/03/…

https://fred.stlouisfed.org/series/TB3MS

iii. Calculate each stock’s beta from the data, assume the market is the S&P 500, and recall to find beta we use the excess returns (i.e., monthly returns less the risk-free return, and regress on the market excess returns)

iv. find the return for 2019 (i.e, the one-year holding period return), compare the return to the expected one-year return using the CAPM,

v. was the stock over or undervalued relative to the CAPM?

vi. upload your Excel with your data and calculations, and include your commentary in the Excel file