Go to http://finance.yahoo.com/, enter the symbol MS (Morgan Stanley), and retrieve stock price data at the beginning
Question:
Go to http://finance.yahoo.com/, enter the symbol MS (Morgan Stanley), and retrieve stock price data at the beginning of the last 20 quarters. Then go to http://research.stlouisfed.org/fred2/ and retrieve interest rate data at the beginning of the last 20 quarters for the three-month Treasury bill. Record the data on an Excel spreadsheet. Derive the quarterly return of Morgan Stanley. Derive the quarterly change in the interest rate. Apply regression analysis in which the quarterly return of Morgan Stanley is the dependent variable and the quarterly change in the interest rate is the independent variable (see Appendix B for more information about using regression analysis). Is there a positive or negative relationship between the interest rate movement and the stock return of Morgan Stanley? Is the relationship significant? Offer an explanation for this relationship.
Step by Step Answer: