Go to finance.yahoo.com. Input an assigned stock symbol in the search field (see your stock assignment below). Click on Historical Prices, input data range for 4 years back from Download to Spreadsheet. The last column will have Adjusted prices (for dividends and stock splits). Using this column, find monthly rates of return for your stock using the following formula: Monthly Return-(Price today - Price last month)/ Price last month. the date of your search and choose monthly prices. Click Do the same for the S&P5o0 index (SPX) a. Find the average annual return and the annual standard deviation for your company and for the market index. Which investment do you prefer on a stand-alone basis? b. What are the betas for your stock and for the market index? Which of the two investments do you prefer based on market risk Beta? c. What is the required return for your stock? d. Compare it to the expected average return that you found in part (a). Is the stock overvalued (SELL), undervalued (BUY) or in equilibrium (HOLD)? Attach the Excel file to the assignment link and click SUBMIT. Group 1- 1BM Group 2- Delta Air Group 3 Expedia Group 4- Costco ASSIGNMENT SUBMISSION Show All