My birthday is may 18. Could you help please? home work is attach

FI 4000 - Fundamentals of Valuation CRN 10353, Section 003 Excel Project Due Date: Tuesday, 02/14/2017 Instruction This project is individually assigned. You are not allowed to work in groups. Submit a report with summary for each part of the project. The report should be complete but concise. You are required to submit your report in hardcopy and upload your Excel spreadsheet on iCollege under the section \"Dropbox/Excel Project\". Please name your Excel spreadsheet using the following convention to ensure proper credit: FirstName_LastName.xlsx (or .xls) For example, if your Name is ABC DEF, your Excel spreadsheet should be named as ABC_DEF.xlsx (or .xls). This project is due on 02/14/17. The hardcopy report should be submitted at the beginning of the class. And the Excel spreadsheet must be uploaded by the start of the class. No late submission will be accepted. Your project submission will be graded based on accuracy and the extent to which it is professionally executed. You should imagine yourself as an analyst who will submit a report to your director or client. In addition to getting the answer right, you want to make a good impression. Be concise, straight to the point, yet thorough and professional in your report, and have the firepower in your Excel model to back it up. Part 1: Returns, Risk and Correlations Go to finance.yahoo.com and obtain the daily returns for GE, AAPL, MSFT, and WMT over the year MM/DD/2015 to MM/DD/2016, where MM/DD corresponds to your birthday. You will find the daily adjusted closing prices in the \"Historical Prices\" section. Use the daily adjusted closing prices to calculate daily returns. Note: The adjusted closing prices already incorporate all dividend payout, so you will not need to find the dividend information to calculate the returns. That is, the capital gain yield based on adjusted closing prices is equal to the return. Merge the returns for these firms into a single Excel workbook with the returns for each company properly aligned. 1. Using the Excel functions for Average and Standard Deviation, calculate the average return and standard deviation for each of the firms. 2. Using the Correlation function construct the correlation matrix for the firms using the daily returns for the entire period. 3. Which pair of firms has the highest correlation coefficient? The lowest? 4. If you have to choose two stocks for your portfolio, which pair would give you the greatest benefit with regard to diversification? Explain. Part 2: Minimum Variance Portfolios Monthly price data can be obtained for securities at a number of online sources. A good source is finance.yahoo.com. (Look for the \"Historical Prices\" tab once you enter ticker symbol of the firm you choose.) 1. Download 10 years' worth of monthly price data for two different stocks. Calculate their monthly returns. 2. Calculate the annualized mean return and annualized standard deviation of the monthly returns and the correlation coefficient of the returns on the two stocks. 3. Use a spreadsheet to calculate the investment opportunity set composed of these two stocks. 4. What is the weight of each of these stocks in the minimum-variance portfolio? Hints: After you compute the monthly mean return and standard deviation, follow the formulas given below to convert it into annual mean return and standard deviation. Annual Mean Return = (1 + Monthly Mean Return)12 1, Standard Deviation of Annual Return = Standard Deviation of Monthly Return 12 Part 3 Go to finance.yahoo.com. Use data from Yahoo Finance to calculate the beta of Adobe Systems, Inc. (ADBE). Start by downloading the monthly adjusted closing prices of Adobe and the S&P 500 (^GSPC) in the Historical Prices section. Copy the data into Excel and calculate the monthly rates of return (based on closing prices) for each series. Using the entire period for which data are available for both Adobe and S&P 500, estimate a regression with Adobe's excess return as the dependent (Y) variable and the S&P 500 excess return as the independent (X) variable. To compute excess return assume risk free rate to be 3%. Verify the and from the regression with and computed using the analytical formula given in Example 6.3 in BKM. Finally, compare your results to the beta listed in Adobe's Yahoo Finance Stock Report. Do any of your results match the Yahoo Finance Report beta? What might explain the differences