Returns, Risk and Correlations

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

QUESTION

Go to finance.yahoo.com and obtain the daily prices for MSFT, AAPL, TGT, and WMT over the year MM/DD/2018 to MM/DD/2019, where MM/DD corresponds to your birthday. Compute daily return for each stocks for the entire sample period. 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.  (10 points)
2. Using the Correlation function construct the correlation matrix for the firms using the daily returns for the entire period. (5 points)
3. Which pair of firms has the highest correlation coefficient? The lowest? (2 points)
4. If you have to choose two stocks for your portfolio, which pair would give you the greatest benefit with regard to diversification? Explain. (3 points)

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 year’s worth of monthly price data for two different stocks.            (2 points)
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. (15 points)
3. Use a spreadsheet to calculate the investment opportunity set composed of these two stocks. Plot the investment opportunity set. (15 points)
4. What are the weights of each of these stocks in the minimum-variance portfolio? (4 points)
5. Compute the expected return and standard deviation of the minimum-variance portfolio. (4 points)
Hints:
 ,
Standard Deviation of Annual Return = Standard Deviation of Monthly Return

Part 3    (20 points: 15 excel + 5 report)

Go to finance.yahoo.com. Choose any stock that you want to analyze.  Use data from Yahoo Finance to calculate the beta of the stock. Start by downloading the monthly adjusted closing prices of the stock 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 the stock and S&P 500, estimate a regression with stock’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 Yahoo Finance Stock Report. Do any of your results match the Yahoo Finance Report beta? What might explain the differences?

Sample Solutions
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Phasellus hendrerit. Pellentesque aliquet nibh nec urna. In nisi neque, aliquet vel, dapibus id, mattis vel, nisi. Sed pretium, ligula sollicitudin laoreet viverra, tortor libero sodales leo, eget blandit nunc tortor eu nibh. Nullam mollis. Ut justo. Suspendisse potenti.

Get sample solution
Order Now

Sed egestas, ante et vulputate volutpat, eros pede semper est, vitae luctus metus libero eu augue. Morbi purus libero, faucibus adipiscing, commodo quis, gravida id, est. Sed lectus. Praesent elementum hendrerit tortor. Sed semper lorem at felis. Vestibulum volutpat, lacus a ultrices sagittis, mi neque euismod dui, eu pulvinar nunc sapien ornare nisl. Phasellus pede arcu, dapibus eu, fermentum et, dapibus sed, urna.

Morbi interdum mollis sapien. Sed ac risus. Phasellus lacinia, magna a ullamcorper laoreet, lectus arcu pulvinar risus, vitae facilisis libero dolor a purus. Sed vel lacus. Mauris nibh felis, adipiscing varius, adipiscing in, lacinia vel, tellus. Suspendisse ac urna. Etiam pellentesque mauris ut lectus. Nunc tellus ante, mattis eget, gravida vitae, ultricies ac, leo. Integer leo pede, ornare a, lacinia eu, vulputate vel, nisl.
Suspendisse mauris. Fusce accumsan mollis eros. Pellentesque a diam sit amet mi ullamcorper vehicula. Integer adipiscing risus a sem. Nullam quis massa sit amet nibh viverra malesuada. Nunc sem lacus, accumsan quis, faucibus non, congue vel, arcu. Ut scelerisque hendrerit tellus. Integer sagittis. Vivamus a mauris eget arcu gravida tristique. Nunc iaculis mi in ante. Vivamus imperdiet nibh feugiat est.
Ut convallis, sem sit amet interdum consectetuer, odio augue aliquam leo, nec dapibus tortor nibh sed augue. Integer eu magna sit amet metus fermentum posuere. Morbi sit amet nulla sed dolor elementum imperdiet. Quisque fermentum. Cum sociis natoque penatibus et magnis xdis parturient montes, nascetur ridiculus mus. Pellentesque adipiscing eros ut libero. Ut condimentum mi vel tellus. Suspendisse laoreet. Fusce ut est sed dolor gravida convallis. Morbi vitae ante. Vivamus ultrices luctus nunc. Suspendisse et dolor. Etiam dignissim. Proin malesuada adipiscing lacus. Donec metus. Curabitur gravida

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services