# Project #14765 - Finance, Investments

Excel spreadsheet, powerpoint, essay. My presentation has to be 4 minutes. I will present via video, I need to know what I have to say when presenting it. I would like the companies to be from the U.S.

You will need to collect the stock price data for any 2 companies of your choice. Choose companies that are in different industries. Collect the end-of-month prices for the last 21 months of your chosen stocks and set them on the spreadsheet. Taking this raw data, compute the monthly returns for both (there should be 20 returns). Make sure that I am able to see the cell formulas for each computation.

Next, compute the mean rate of return and the standard deviation of returns for both your stocks. Compute the correlation coefficient for the 2 stocks. Plot the returns of your stocks against each other on a graph within the spreadsheet.

Next, assume that you construct a portfolio where you put equal money in each of your 2 stocks. Compute the 20 monthly rates of return for the portfolio, the mean rate of return and the standard deviation of returns of the portfolio. Finally, within the spreadsheet and in your video presentation comment on your findings regarding risk/return of your portfolio as compared to the risk/return characteristics of the 2 individual stocks.

The presentation should be at least 4 minutes in length not to exceed 5 minutes. Power point slides or your spreadsheet can be used in explaining mainly your choice of the 2 companies AND “Finally, within the spreadsheet comment on your findings regarding risk/return of your portfolio as compared to the risk/return characteristics of the 2 individual stocks.” Send me your spreadsheet file separately as per above instructions.

 Subject Mathematics Due By (Pacific Time) 10/31/2013 12:00 am
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews