Choose a stock and estimate its beta based on the monthly returns over the last five years. Use S&P 500 as the proxy for the market portfolio, and the interest rate on the 10-year Treasury note as the risk free rate.

Your submission should be an Excel file including the historical data, and three different ways to estimate beta.