1. A bank has DA = 2.5 years, DL= 0.80 years, and k = 92%. Assets are equal to $1,200 million. According to the duration gap model, find the change in the direction and magnitude of interest rate that would make the institution insolvent if rates are currently 5 percent?

please answer in excel format