Finance

STOCK TICKERS: SEAS (SeaWorld ) & MGM (MGM International

1. The daily returns for each stock must be regressed against the daily returns for the index. (Please make sure that the periods for the stock returns and the index returns are exactly same) The betas must be calculated and interpreted. This beta must be compared with the beta from Value line or other reported beta (finance.yahoo.com; finance.google.com) and the source must be quoted.

2. The variance of daily returns for each stock must be calculated over the period.

3. Assign equal weights to your stocks in the portfolio.

4. The standard deviation, variance and coefficient of variation of the daily returns for the portfolio must be calculated.

5. The standard deviation, variance and coefficient of variation of the portfolio must be calculated over the eight week period.

6. The performance of each of the stocks and the portfolio (had you invested in these stocks five years ago) must be analyzed with respect to each other and with respect to the index. The current performance of each of the stocks and the portfolio must also be analyzed with respect to the past performance. The analysis should also include the comparison of the key ratios across the stocks, across the industry and over time. Relate your analysis to the concepts learned so far in the course and state what you learned from this project.

7. You must include reference page(s). Please include your references/citations within the content as well.

8. The report must be typed. No handwritten reports will be accepted. Please make it presentable.

9. Originality, clarity, presentation, expression of thoughts will be rewarded.

The project must be typed and all calculations must be done using Excel. You have to turn in soft copy of your excel spreadsheet and the report.