Exam 3 Critical Thinking Question Best Buy For the company that you are assigned, please complete the following: . . . Download monthly data for the last 5 years. Calculate a percentage return using the formula (New-Old)/Old for each of those months. Use the close number. (You may ignore dividends for this project.) Calculate the average monthly return using the Average function in Excel. Calculate the standard deviation using the sample standard deviation function (STDEV.S). Download monthly data for the last 5 years for the S&P 500 (GSPC). Calculate the percentage return, average, 5 and standard deviation using the same procedures described above. For your company, find the following data: . Beta Market capitalization Range for the stock price over the last year Average volume of shares sold each day Using your data and the calculations for the company and the stock index, how does the return and risk of the index compare to the return and risk of the individual stock? What does the beta tell you about the firm