PLEASE USE EXCEL TO CALCULATE AND INCLUDE WORK

a. Use data from Yahoo Finance to calculate HOG's beta Use the S&P 500 Index (GSPC) as a proxy for the market, and find historical monthly prices for the S&P500 Index and HOG over the following time frame. March 31, 2014 March 31, 2020. Use the "Adj. Close" prices to calculate monthly returns, then use Excel's Eslope() function to find beta for HOG b. If the return on the market is 11.5 percent and the riskfree rate of return is 3 percent, what is HOG's cost of equity? S UOC has the followe dband