Home / Questions / SPREADSHEET PROJECT GUIDELINES This project MUST be done on an excel spreadsheet and be su
This project MUST be done on an excel spreadsheet and be submitted to me AS ONE SPREADSHEET.
You will need to collect the stock price data for any 2 companies of your choice and the S&P 400 index. Choose companies that are in different industries. Collect the end-of-month prices for the last 21 months of your chosen stocks and the S&P 400 and set them on the spreadsheet. Taking this raw data, compute the monthly returns for all (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 and the stock market. Compute the beta value for each stock and plot the characteristic lines on 2 graphs. 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 and the standard deviation of returns of the portfolio. Finally, within the spreadsheet discuss in DETAIL your findings regarding risk/return of your portfolio as compared to the risk/return characteristics of the 2 individual stocks. These comments must be detailed with a complete analysis.
Nov 07 2017 View more View Less
What are the consequences of environmental degradation as pointed out by Lester Brown ? >
Apr 25 2020The nurse is assessing a client with a bleeding gastric ulcer. When examining the client's stool, which characteristic would the nurse be most likely to find?
Aug 11 2021Specializing and participating in international trade allows an economy:
Jun 07 2021What are some basic macroeconomic concepts about an open economy?
Jun 09 2021A company which uses austenitic nickel chromium ions to manufacture resistance heating wire is considering a new annealing drawing process to reduce cost. If the new proc...
Aug 23 2020Write the preferred plural forms of the following nouns in the spaces provided. Use a dictionary if necessary.wolf ________
Jun 15 2021A first-order reaction is 75% complete in 320 s.a. What are the first and second half-lives for the reaction?b. How long will it take for 90% completion?
May 21 2021You are the partner on the audit of Datasave, Inc., a small publicly held corporation that manufactures high-speed disk drives for the computer industry. The audit of Dat...
Apr 05 2020Which of the following would cause a decrease in market equilibrium price and quantity?A) An increase in supplyB) An increase in demandC) A decrease in supplyD) A decreas...
May 08 2021Woodruff Company is currently producing a snowmobile that uses ﬁve specialized parts. Engineering has proposed replacing these specialized parts with commodity parts, whi...
Apr 06 2020