To find beta, we also need the return on the market portfolio. Download the data for the S&P 500 (^GSI for the same time period onto a new tab labeled "GSPC". What was the return on the index from 12/31 to 1/2/147 -0.00886 Part 5 Create a new tab labeled 'beta' in Excel. Using Excel's SLOPE() function and the industry model, what is t beta for Bank of America? 2+ decimals Correct Submit Part 6 What is the beta for Procter and Gamble? Attempt 1/3 for 10 Attempt 1/3 for 10 pts