Estimate the beta and expected return of Bank of America stock (BAC) based on historical return data.

Explain your choice of time period, frequency, and index proxy for your beta estimation. Explain choice of risk-free rate and market premium for your expected return calculation.

Show the results of your beta estimation. Interpret the R squared, intercept and slope coefficients. Be sure to discuss the importance of the standard error of the slope coefficient.

If you were told that the actual return of the stock over the next year will be 10%, would you recommend buying the stock today? Why?

Please show your work on excel, thank you in advance!!