Analyzing Historical Risk vs. Return for a Company.

Analyzing Historical Risk vs. Return for a Company. Choose a company that you are using in the investment challenge and complete the following steps. Follow the 6 steps below. Submit your answers on these sheets to the Drop Box Step 1: Gather the most recent 61 monthly stock prices for the S&P500 and your company using . a. Go to the above website and enter "^GSPC" in the Enter Symbol box in upper left-hand home page of Yahoo! Finance. b. Click on Historical Prices on the left-hand side. c. Choose a start date 5 years prior to today's date, change to monthly, and click Get Historical Data to get 61 months of data. (You need 61 observations to calculate 60 returns.) d. Scroll down to the bottom of the page click on Download Spreadsheet Format and copy (DO NOT CUT) the closing prices and dates into the highlighted areas of this spreadsheet under the tab 2.Calc. Returns below ………………………………….CONTINUED……………………………..