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 Read more Less More
Delphi Products Corporation currently pays a dividend of $2 per share, and this dividend is expected to grow at a 15 percent annual rate for three years, and then at a 10...
May 12 2020On January 1, 2017, the Hermann Company ledger shows Equipment $36,000 and Accumulated Depreciation $13,600. The depreciation resulted from using the straight- line metho...
Apr 01 20201.A cylinder fitted with a piston contains argon gas at 140 kPa, 10°C, and the volume is 200 L. The gas is compressed in a polytropic process to 700 kPa, 180°C. Calculate...
Jun 07 2020Suppose the kick in Example 3-5 is attempted 36.0m from the goalposts, whose crossbar is 3.00m above the ground. If the football is directed correctly between the goalpos...
Apr 01 2020What are the performance objectives of operations and what are the internal and external benefits which derive from excelling in each of them ?
May 18 2018Form the differential equation for the family of straight lines x/a+y/b=1 >
Aug 04 20201. Write a Hello World program. 2. Write a program that prompts the user for a radius value and outputs the area and circumference of a circle. The area and circumferenc...
May 27 2020How do country-specific factors affect a country’s attractiveness as a manufacturing base? 142.Define minimum efficient scale of output. How does this influence the loc...
Jan 11 2020How does a generic drug differ from its brand-name, previously patented equivalent? Explain why the price of a brand-name drug typically declines when an equivalent gener...
Apr 23 2020Pertinent transfer price, perfect and imperfect markets. Wheely, Inc., has two divisions, A and B, that manufacture expensive bicycles. Division A produces the bicycle fr...
Nov 08 2017Welcome to MyCourseHelp Services, World's leading Academic solutions provider with Millions of Happy Students.