Please help me out!!!

CAPM, Fama-French, and APT Note: All of your regressions should be run on the most recent 60 months of data, but the time period may vary depending on when particular data series are available. You should gather all of the data before you run any regressions. CAPM Go to finance.yahoo.com and download the historical monthly level of the S&P. Enter these in a worksheet and then calculate the monthly returns for the index. Now download the monthly adjusted prices for a stock and a domestic equity mutual fund. Enter these prices and returns in the same worksheet and calculate the monthly returns for the each series. Now go to www.stls.frb.org and find the data for "3- Month Treasury Constant Maturity Rate. This is the risk-free rate for this particular analysis. Note, the interest rate is expressed as an APR in this data. Estimate the market model for the stock and mutual fund and answer the following questions: 1. What is the beta and alpha for this stock? 2. Are the beta and alpha significant at the 5 percent level? 3. What is the RP of this regression? In your opinion, does this regression explain the returns for your stock? FAMA-FRENCH You ant to construct a Fama-French model to explain your stock's returns. Use the ame stock and mutual fund and the same period you used to construct the CAPM. The variables in the Fama-French Model are: (NOTE: Use monthly data in your analysis.) E(R) R;: = B.X [E(Rs.) R,]+B.E(SMB,)+:EC HML) The Fama-French factors can be downloaded in the data section of Ken French's website: http://mba.tuck.dartmouth.edu/pages/faculty/ken.french/index.html Construction: The Fama/French factors are constructed using the 6 value-weight portfolios formed on size and book-to-market. (See the description of the 6 size/book-to-market portfolios.) English (United States) O Focus See Fama and French, 1993, "Common Risk Factors in the Returns on Stocks and Bonds," Journal of Financial Economics, for a complete description of the factor returns. Stocks: Rm-Rf includes all NYSE, AMEX, and NASDAQ firms. SMB and HML for July of yeart to June of t+1 include all NYSE, AMEX, and NASDAQ stocks for which we have market equity data for December of t-1 and June of t, and (positive) book equity data for t-1. 1. What are the betas and alphas for the stock and mutual fund? 2. Are the betas and alphas significant at the 5 percent level? 3. What is the RP of these regressions? In your opinion, does this regression explain the returns? Fama-French and APT Estimate a regression for the stock and mutual fund using the Fama-French factors plus the following variables: ST = the percentage change in consumer sentiment. Recently, a branch of finance called behavioral finance has emerged that argues that investor sentiment drives markets. On www.stls.frb.org, go to the Business/Cyclical link and find "University of Michigan: Consumer Sentiment." You need to construct this variable as the percentage change in the index. The 5th variable -YOURS Find a fifth variable for your APT model. Explain why you chose this variable, i.e., what are the economic reasons this variable should affect the returns of your stock. The variable could possibly be an industry specific variable. For example, you could use the book-to-bill ratio for the computer industry. One place to find the variable is www.stls.frb.org, but you can use any appropriate variable you find. NOTE: This variable cannot be the stock market, another stock, or any stock index. 1. What are the betas and alphas for the stock and mutual fund? 2. Are the betas and alphas significant at the 5 percent level? 3. What is the R of these regressions? In your opinion, does this regression explain the returns? CAPM, Fama-French, and APT Note: All of your regressions should be run on the most recent 60 months of data, but the time period may vary depending on when particular data series are available. You should gather all of the data before you run any regressions. CAPM Go to finance.yahoo.com and download the historical monthly level of the S&P. Enter these in a worksheet and then calculate the monthly returns for the index. Now download the monthly adjusted prices for a stock and a domestic equity mutual fund. Enter these prices and returns in the same worksheet and calculate the monthly returns for the each series. Now go to www.stls.frb.org and find the data for "3- Month Treasury Constant Maturity Rate. This is the risk-free rate for this particular analysis. Note, the interest rate is expressed as an APR in this data. Estimate the market model for the stock and mutual fund and answer the following questions: 1. What is the beta and alpha for this stock? 2. Are the beta and alpha significant at the 5 percent level? 3. What is the RP of this regression? In your opinion, does this regression explain the returns for your stock? FAMA-FRENCH You ant to construct a Fama-French model to explain your stock's returns. Use the ame stock and mutual fund and the same period you used to construct the CAPM. The variables in the Fama-French Model are: (NOTE: Use monthly data in your analysis.) E(R) R;: = B.X [E(Rs.) R,]+B.E(SMB,)+:EC HML) The Fama-French factors can be downloaded in the data section of Ken French's website: http://mba.tuck.dartmouth.edu/pages/faculty/ken.french/index.html Construction: The Fama/French factors are constructed using the 6 value-weight portfolios formed on size and book-to-market. (See the description of the 6 size/book-to-market portfolios.) English (United States) O Focus See Fama and French, 1993, "Common Risk Factors in the Returns on Stocks and Bonds," Journal of Financial Economics, for a complete description of the factor returns. Stocks: Rm-Rf includes all NYSE, AMEX, and NASDAQ firms. SMB and HML for July of yeart to June of t+1 include all NYSE, AMEX, and NASDAQ stocks for which we have market equity data for December of t-1 and June of t, and (positive) book equity data for t-1. 1. What are the betas and alphas for the stock and mutual fund? 2. Are the betas and alphas significant at the 5 percent level? 3. What is the RP of these regressions? In your opinion, does this regression explain the returns? Fama-French and APT Estimate a regression for the stock and mutual fund using the Fama-French factors plus the following variables: ST = the percentage change in consumer sentiment. Recently, a branch of finance called behavioral finance has emerged that argues that investor sentiment drives markets. On www.stls.frb.org, go to the Business/Cyclical link and find "University of Michigan: Consumer Sentiment." You need to construct this variable as the percentage change in the index. The 5th variable -YOURS Find a fifth variable for your APT model. Explain why you chose this variable, i.e., what are the economic reasons this variable should affect the returns of your stock. The variable could possibly be an industry specific variable. For example, you could use the book-to-bill ratio for the computer industry. One place to find the variable is www.stls.frb.org, but you can use any appropriate variable you find. NOTE: This variable cannot be the stock market, another stock, or any stock index. 1. What are the betas and alphas for the stock and mutual fund? 2. Are the betas and alphas significant at the 5 percent level? 3. What is the R of these regressions? In your opinion, does this regression explain the returns