Go to http://finance.yahoo.com/, enter the symbol HFWA (Heritage Financial Corporation), and click on Get Quotes. Then, retrieve

Question:

Go to http://finance.yahoo.com/, enter the symbol HFWA (Heritage Financial Corporation), and click on “Get Quotes.” Then, 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 Heritage Financial. Derive the quarterly change in the interest rate. Apply regression analysis in which the quarterly return of Heritage Financial 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 Heritage Financial? Is the relationship significant? Offer an explanation for this relationship.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: