Measuring Risk Montana Bank wants to

determine the sensitivity of its stock returns to

QUARTER interest rate movements, based on the following information:

Use a regression model in which Montana's stock return is a function of the stock market return and the interest rate. Determine the relationship between the interest rate and Montana's stock return by assessing the regression coefficient applied to the interest rate. Is the sign of the coefficient positive or negative? What does it suggest about the bank's exposure to interest rate risk? Should Montana Bank be concerned about rising or declining interest rate movements in the future?

(*** Kindly read the full question carefully and answer this question. Also, show me all the workings. Use excel function for regression)

QUARTER RETURN ON MONTANA STOCK RETURN ON MARKET 3% 29 INTEREST RATE 6.0% 7.5 2 2 2 3 HI -2 9.0 -1 8.2 2 1 73 -3 4 81 1 5 7.4 0 1 9.1 2 0 10 82 11 7.1 3 6.4 12 4 5.5